Tata Steel Ideation Contest

# This post is created as a requirement of MIS Course, Autumn Semester, MBA, Batch of 2014, Vinod Gupta School of Management, IIT Kharagpur

# The work is done by Dev Karan Singh Maletia (12BM60060) and Ashwini Kumar (12BM60047).

The required deliverables of the project have been explained below :

Tata Steel is looking for an original idea that will use any aspect of digital technology (cloud, mobile, Android, IoS etc ) to create a application or platform that can be integrated with the strategic management requirements of the company. Since this is an ideation contest, no software need to be built but paper must contain the following sections.

1. Identify a need or a gap in the current management architecture of Tata Steel. Information available in the public domain can be used for this purpose.
2. Propose a solution that will show how the current gap can be closed or narrowed significantly
3. If possible give examples where a similar solution has or is being implemented.
4. List benefits -- economic or otherwise -- that will accrue to the company if it is implemented. Also identify potential problems or difficulties that need to be guarded against.
5. Provide  rough estimate of costs including people costs that the company would have to incur as a one time expense and as a regular expense.

The link for the presentation is provided below :::

Tata Steel Ideation Contest

Tata steel ideation contest from ashwinikumar1424

Kharagpur Hospitals Customer Support

• Through this website, I am trying to help the hospitals' customers i.e. the patients and other concerned personnel by providing them with a complaint registration system.
• Usually, the complaints are noted as hard copies which usually do not reach the concerned authorities or departments in time or get misplaced.
• This further leads to loss of time, money and most importantly customers i.e patients.
• Through this website, anyone can lodge a complaint directed to the HR department, bio medical department, the general hospital support, accounts department, hygiene department, catering, etc. which will directly reach the concerned authorities so that they can be solved in time.

I evaluated the following software :

• osTicket- the overall layout was dull, also the basic functionality was a bit complex, configuration as an admin was also little complex and demanded more effort.
• trellis desk- it is very simple and lacks some basic functionalities, also, the overall layout was confusing.
• exophpdesk- it did not solve the purpose of my business solution and was mainly concerned with the live chat. 
• HESK

Finally for developing my website, I chose HESK

• I chose this particular software because it is user friendly and has a good layout.
• Being an admin, it was simpler to configure specially when I compared it to osTicket which is similar to HESK in many functionalities.
• When evaluated as a user, it seemed more professional as compared to other softwares that I checked before installing it.  Some of its features are as follows :

For Administration:

• unlimited accounts
• ticket search ability
• time worked on a ticket
• email notifications
• translation into any language

For Customers:

• Attach necessary files
• SPAM prevention
• View staff replies and rate them accordingly
• email notifications are sent when staff replies.

I have done the following customozations in this website:

• I have created seven different users to manage the customer support system - Human Resource department, Bio Medical Department, General Admin, Accounts Department, Hygiene Department , maintenance department and support department.

• Also, I have split the system into seven categories that are Support team, HR, bio medical, accounts, support, hygiene, maintenance and accounts which cover almost all the aspects in which the complaints can be registered in a hospital.

• The customer can lodge a complaint directed to any of these departments and the concerned personnel responsible for solving the same will be informed through a mail.
• Also, being an admin, I can change the status of the ticket, move ticket to the respective department if it is not assigned to the same before hand by the customer and change the priority based on the availability of the respective staff.

Link to the website is :

 Kharagpur Hospitals Customer Support

ZOHO App_RAFTAAR Auto Service Centre

Online Form powered by

Merchandising company Online portal (Customer Perspective)

Problem Statement:

I am the owner of a Merchandising Company. Recently there were lot of mis-calculations in the customer orders and products. So I want to create an internal Product management system.

System:

To make an internal product management system using the cloud Zoho application and handle the customers, products, orders for a merchandising company in an efficient and well organized manner.

Functional Requirements:

1. HOME SCREEN: Staff should have the flexibility to choose the functions they want to work on.

2. CUSTOMER REGISTRATION: Staff/Customer should able to decide if they are new customers or existing customers and proceed accordingly for registration. The registration page should take all the necessary details from the customer and the staff.

3. EMAIL NOTIFICATION: Once the customers are registered, an email notification should be sent to them.

4. REQUIREMENT SELECTION: On successful login, the customers should be able to book the orders of their choice. The procedure should be user friendly and easy to understand.

5. PRODUCT REGISTRATION: Staff should be able to register the products they receive, update them in the web portal so that they are able to view the existing inventory so that it can be managed comfortably.

6. ORDERS: Customers cab book the orders by checking the available products. Then, the necessary details of the customers should be taken. Also, a sample payment procedure can be designed. Necessary reports based on the orders should be generated.

7. COMPLAINTS AND FEEDBACK: customers can feed the difficulties they faced while using the service and give the necessary feedback so that the organisation can make the required feasible changes to serve them better.

                                                FLOW DIAGRAM

MIS_Assignment0

Father: Hi Dev, how were your mid semester examinations??

Dev : Hi Papa, finally my exams got over, its such a great feeling.

Father : But, still you didn't speak how did you write your examinations.

Dev : Papa, the results will speak for themselves. HaHa !

Father : Well, you seem pretty confident. I definitely believe you will get good marks. So, did you learn any new subjects there?

Dev : Papa, all the subjects were new to me. But, specifically I loved this one subject called 'MIS'. It had one chapter named 'Systems Architecture' which I loved the most.

Papa : Oh, I haven't heard of the name before. What is it all about?

Dev : Papa, this subject just explains how computer systems are installed in different organizations and how their complexity varies in different types of architecture.

Papa: Dev, I am not getting what you are trying to explain.

Dev: Papa, just consider your laptop, and consider it has just two parts which are the database where all the data in your laptop lies and the other is the application part which processes all the data.Here is the diagram below dad.
                                

Papa: Ok, that seems pretty simple. I think I can go complex now.

Dev: Not so fast dad, this is the basic single tier architecture.

Papa: Ok son, go on.

Dev: Papa, if we look it from organizations perspective, the data and the applications always need to be separated from each other. Thus, they maintain their whole data in a single database and install the applications in different machines for the individual employees. Here is the diagram below dad.

           

Papa: Ok, that seems reasonable.

Dev: Papa, the data is managed by PL, SQL, Oracle, etc.

Papa: Please do not go into too much of technicalities and explain it to me slowly son.

Dev: Ok Papa, the architecture which I just explained is a two tier architecture. But, it has some disadvantages, the application systems which are connected through LANs to the main database server have high bandwidth requirements which in turn slow down the system.

Papa: Oh, then what is the solution for the same?

Dev: Dad, then most of the organisations go for the three three architecture.

Papa: And how does that work ?

Dev: Its very simple papa, applications always has two parts, one is the data logic and the other is the presentation logic. Data logic which has all the algorithms to manipulate the data is kept with the central database and only the presentation logic is installed in the employee machines.Following is the diagram:




Papa: Ok, now I get it, since the business logic is kept central, all the calculations will take place there nd in turn the data traffic will get reduced to a great extent.

Dev: Wow dad, you are catching up real fast. I would like you to explain multi tier architecture now. Its almost the same as three tier architecture , the only difference is here the servers and the application systems are not connected through LAN/WAN, but through the internet. The application systems are replaced by the web browser systems.You can find the diagram below dad.
 



Papa: I am proud of you Dev.

Dev: Thanks Dad, how about I tell you rest of the details tomorrow.