Thursday, 29 November 2012

Tata Steel Ideation

Tata Steel is looking for an original idea that will use any aspect of digital technology (cloud, mobile, Android etc ) to create an application or platform that can be integrated with the strategic management requirements of the company.

View the solution:-


Friday, 19 October 2012

Internal Customer Complaint System

Costra Company Ltd.

Costra Company Ltd. a cable manufacturing company in Gujarat implements a new technology on ExoPHPDESK for managing complaints of there internal customers. I was given the reaponsiblity to implement a Internal Customer Complaint System for which I evaluated a number of other technologies which are listed below:

1. phpOnline

2. HESK

3. osTicket

I chose ExoPHPDESK over others as it is easily customisable and user friendly. It has the unique feature of online chat with the customer. I found this technology best and well suited for my application.

I required to do the following customisation in order fullfil my requirements:

1. I have defined one more admin apart from the default one. Both of them have the rights to modify the response and the tickets


2. Then i have defined three department namely IT Support, HR and Facilities


3. I have alloted 6 number of staffs, two for each department.




Helpdesk Login : admin       Password : pass

Any employee can register a complaint at helpdesk.

The admin will be able to view the complaint and the details of the employee.


Thursday, 20 September 2012

e-Medical-store

Online Form powered by


If finding difficulty in viewing this application, please click here : e-Medical Store

Task  : Develop an application of Online Medical Store using the Zoho Creater.

Customer : Manas Ghose (12BM60100)

Vendor :     Kamya Sharma (12BM60101)

The application is created by me on request of my customer.

User Manual :   User Manual
Certificate of Compliance :  Acceptance Certificate




 

User Manual


e-Medical Store                                          

Introduction

e-Medical Store is the registered online chemist in India. e-Medical Store is a chain of Medical stores present all over India. You can buy entire range of medicines Online at competitive Prices and door delivery at your place.

 User Manual for the Customer

Following is the main page of the website:
 
The user needs to register first to buy any medicine. After registration the page will automatically move to login page for the user. Following is the screenshot for registration page and login page.



 A mail regarding the successful registration will be sent to the customer. After registration the customer needs to login using the same login id and password. After successful login it will automatically lead to medicine page, wherein customer can select the medicines they want.

 Medicine page will by default take the User ID and all the information which the customer had put it during registration. But the customer can change these fields as required. Now the customer will be selecting the medicine from the dropdown. It will automatically take the information like company name, per unit price and units. Now the customer needs to enter the quantity of medicines required. It will automatically calculate the total amount. After selecting everything the customer needs to place an order. It will automatically send a copy of invoice to the registered e-mail id of the customer.

 
Information of placing the order will be sent to the e-Medical store and delivery person will deliver the medicines ordered.

 
 
Admin User Manual

Admin is the owner of e-Medical store. Admin will get the information of registered customers in Registration view.

 The admin will also get the information every time the customer logins into the login page.


 The admin will also get an invoice copy after the customer place an order.

The admin will check if that medicine is available or not in the "Medicine Database". Admin can also check how much quantity is available in the database.

 The admin can also add the quantity of new medicines bought by the store. Also admin can add new medicines in the database.
 

 

Certificate for Tech Gymkhana Portal


Customer: Kamya Sharma(12BM60101)

Vendor: Happy Garg (12BM60103)

Delivered Solution

An online portal for Tech Gymkhana can reduce the amount of time wasted in standing in queue for the registration. The easy way of online registration encourages the students to step on the gym and live a healthier life.

*********************************************************************************

CERTIFICATE OF MEETING REQUIREMENTS

I Kamya Sharma (12BM60101) as a customer certify that Happy Garg(12BM60103) has fulfilled the requirements as a Vendor, An portal expected for Tech Gymkhana was delivered as per the requirements.
 
*********************************************************************************

Tuesday, 18 September 2012

Zoho Apps requirements


Disclaimer: This post is created as a requirement for ZOHO app, MIS Course , VGSoM IIT Kharagpur, class of 2014

Customer:                          Kamya Sharma (12BM60101)

Vendor:                               Happy Garg (12BM60102)

Problem Statement:         Make an online portal for Tech Gymkhana wherein the students of all years can register for the game they want to play and do the payment accordingly.

System specification requirements:
Requirement for the Registration :

1. There should be a registration page for the students where the students will be entering the fields like name, gender, degree pursuing, year, Branch/stream/concentration, residence hall, email address, contact no, Date of Birth, user ID.

2. All the fields shall be compulsory to complete the process of registration.

3. Provide the option to select the date of birth from the calendar.

4. An intimation of successful registration shall be sent on mail to the students.
5. The userID should be of maximum 6 characters.

6. It should check the validation for userID. UserID should be linked to the email ID of the respective students.

Requirements for Choice page of Games

7. Create the page for selecting the choices of games wherein the student will be entering the userID in order to select the game.

8. A mail should be sent to the student confirming the games he/she has selected.


Requirements for gateway
9. Create a interface for payment gateway as we can go for online payment mode in future. However till then will continue with the cash on delivery mode.

Other Requirements

10. After successful registration, it should directly move to the "Choice page". After completing choice page  it should directly move to "Payment Page".
11. The application should have good asthetics.
12. Create a user manual for the students.
 
The application can be accessed from here :   Tech Gymkhana Portal

Saturday, 4 August 2012

A talk with a Friend


Day before yesterday my friend called me to teach her System Architecture. Her name is Pallavi. She is also doing her MBA from Pune.

The conversation between us went as follow:

Pallavi:  Yaar thoda urgent hai.. Please can you teach me this topic "System Architecture".

Me:        Ok.. What happen? Why so urgent?

Pallavi:  Are we have a test tomorrow, so need to learn now only..

Me:        Why don't you ask your faculty to teach you the subject?

Pallavi:  If I would have understood what he teaches in the class I would not have asked you the same question. And since you have Prithwis Sir teaching you in your college, I knew that calling you will serve the purpose.

 Me:       Ohhh... got it now...Yeah we are really lucky to have him here...

Pallavi:  So now please teach me na...

Me:        Okay... Let's go... I will teach you..

Me:        See.. System Architecture is a model which that defines its structure, components and the relation between them.

The system architecture can be classified into different types of architectures which I will be telling u one be one.

Firstly We have an architecture called "Integrated Architecture" or "Single Tier Architecture" , just like we have our laptops at home. The basic principle is that the data must be logically distinct from applications. Here we don't need to separate data from applications even if they are on the same physical hardware.

Then we have "Two Tier Architecture" or "Client Server Architecture" where the data resides in the server. The server can be Oracle, mySQL, SQL Server etc. Here the application is stored in different machine unlike the integrated system. The application has a presentation and business logic. It communicate to the client machine on Local area network (LAN) via TCP/IP. It has certain Advantages and Disadvantages. The main advantage is that the server no needs to bear the processing burden when hundreds of users are using it. But the disadvantage is that it requires a high bandwidth which slows down the application....

Then we have one more type of architecture named "Three Tier Architecture" where the application itself is partitioned. Here the business logic is kept centrally so that changes need to be done only at one system which has the application on it. Presentation logic will be there on the clients on that the data transfer over the network is minimized.

Then the last one is "Multi Tier Architecture". Unlike other architectures we use internet over WAN as a communication media. Anyways both internet and WAN are TCP/IP based. The only difference is that internet is public and WAN is private. The internet is inexpensive but insecure. We don't need any specialized software for Clients but the application has to be web enabled.

Now the various types of Architectures are over. There are various other things to ponder when you design a particular architecture.

In order to manage the complexity of the data for example banks, offices etc we came make use of RDBMS that is Relational Database Management System. It has certain advantage that there won't be duplication of data. Also there won't be inconsistency of data across locations and time periods. It is also easier to manage and you can always take the backup and restore the system in case of emergency. It is quite secure and requires user authentication.

To manage even more complex databases we have ERP systems. It has very tight integration between the functions. No separate activity required to synchronize data. It can be purchased as a combined package from the same reputed vendor. It is faster to implement and easier to manage and maintain.

In order to protect data from hackers and intruders, we can make use of firewalls in the network. Placing the firewall doesn't guarantee complete protection. We can only try to configure it in such a manner so that we can protect our network to the maximum possible.

So that's it.. I am done..

Pallavi:  Nice yaar... Now it sounds so easy.. Well thanks a lot Kamya..

Me:        It okay yaar...Chal then I have to leave. Bye Bye and Take care...

Pallavi:  Bye.....