Thursday, 29 November 2012

MIS Assignment-TATA 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 AshwiniKumar Rao (12BM60047) & Dev Karan Singh Maletia (12BM60060).

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.

Very ambitiously, we are looking for a “killer app” that will address “something that is not quite possible today but if done will dramatically change the way the company will operate”. 

The link for the presentation is given below:


Saturday, 20 October 2012

MIS Assignment No.3 Business Apllication

The Problem Domain :  Customer Support

The Problem :    To handle and manage the customer support system of a firm.

Software  Analyzed:

1.  ExoPhpDesk
2.  OSTicket
3.  Hesk
4.  PhpOnline
5.  Open Web Messenger


Selected Software -: OS Ticket

I chose OS Ticket because business problem required the software to be easy to install and customer friendly and OS Ticket clearly satisfies this clause as it does not require the customer to login to the portal. The customer can check the status of the ticket raised by him/her through a unique combination of His/her email -id and ticket no.,which is mailed to the customer upon creation of the ticket. Communication is an aspect which is the most important thing in a customer support system and OS Ticket provides us multiple means of communication at various levels thus keeping the customer up to date about the issue. OS Ticket has a proper follow up system and ticket can be re-assigned to staffs of other departments in real time.OS Ticket offers advanced flexibility without compromising simplicity which makes it distinct  from other customer support softwares.


Customization:

Various Departments were added:


  1.     Billing
  2.     Human Resource
  3.     IT Help Desk
  4.     Sales
  5.     Support
  6.     Research and Analysis
  7.     Public Relation
  8.     Finance
New managers as well as staff members were added to direct the mail to the concerned person or department.


Link to the Application:         http://ashwini14.x10.mx/ostic

Submitted by:
ASHWINI KUMAR RAO
12BM60047




Thursday, 20 September 2012

Requirements for Debjyoti Mitra




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

Customer:   Ashwini Kumar Rao (12BM60047) (ME)
Vendor:  Debjyoti Mitra(12BM60052)


Objective:  I am acting as customer and providing the requirements to the next roll number for the ZOHO app that he/she has to make for completing the course requirements.

Requirements that I had given to Debjyoti Mitra (12BM60052) for building the application “Elite Pre-owned bikes ” have been listen down :-
               HOME PAGE
Ø  The website should be user friendly; there should be an “INSTRUCTIONS” page where all the related information regarding how the application works should be mentioned.

REGISTRATION PAGE
Ø  The users should be have a registration page where they can fill in their details like, name, address, pan number, email-id etc.

CUSTOMER ID
Ø  On successful registration, a customer should receive a “CUSTOMER NUMBER”. Subsequently a mail should be sent to the customer giving them information about their customer number on completion of successful registration.

BOOKING
Ø  On submission of the registration form the customers should be directed to the booking page. In the booking page the customer should be able to view the products available and their respective prices.

PRICE INDICATION
Ø  On choosing a model the price should automatically be indicated.

GENERATE ORDER NUMBER
Ø  On choosing the preferable colour of the product and order number should be generated.

SEND INVOICE EMAIL
Ø  Then on confirming the order an email should be sent to the customer which will contain the information regarding the product ordered and the colour of the product ordered.

PAYMENT WINDOW
Ø  On submission the customer should then  be  directed to the payment window , where the customer will be able to pay using internet banking options.It should have a good look and feel to it.

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

Certificate for Elite Pre-Owned Bikes


Customer: Ashwini kumar Rao(12BM600547

Vendor: Debjyoti Mitra(12BM60052)



Delivered Solution

 



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

CERTIFICATE OF MEETING REQUIREMENTS



I Ashwini Kumar Rao(12BM60047) as a customer certify that Debjyoti Mitra(12BM60052) has fulfilled the requirements as a Vendor, An portal expected for Elite Pre-Owned bikes was delivered as per the requirements.





MIS Assignment-ZOHO Application

ASHWINI KUMAR RAO
ROLL NO: 12BM60047

Here is the link to access my application which I have developed as per the requirements given to me.

Copy  paste the following link  in your address bar to access the application:
Click Here










Online Form powered by

Sunday, 5 August 2012

MIS assignment 1(Ashwini Kumar Rao)

Monica looked quite frustrated when she entered the room.She had been undergoing a lot change since her last switch between two companies.She threw her carry bag on the table,took a soda from the fridge ,turned on the television and pushed herself back on the sofa.I was trying to complete an assignment but thought to sit with her for a while.

Me: Hi....How was office today?

Monica: Hey....T'was ok!!!! (Trying to open the soda as if it was the only thing that she wanted right now)

Me: That didn't look nice.Tell me whats going on with  you.(I sat next to her)

Monica: (trying to remove the string of hair that kept falling on her face)Nothing.

Me: See ..you can play this game of "what happened-nothing"..forever..or what you can do is answer me right now and save us both ,the time.

Monica: I told you that it would be difficult for me to adjust in an IT company. I dont even know the basics...Like everyone was talking about "system architecture"..and I was'nt able figure it out what exactly did they mean.I just stood there pretending I understood everything but I know that it was other way round.

Me: Hmmmm...But why do you want to know about system architecture? You work in the sales division.

Monica: I just dont want to stand out there looking like a fool..And knowledge doesnt cause any harm.By the way if you dont have time to explain it to me then I can ask Nitin to do .

Me: Come on...Gal!!!!!!!tell me...what do you want to know?

Monica: Give me a brief idea what  it is all about.(Turned towards me.Had one sip of soda and kept it on the table)

Me:I'll tell you in very simple words.Database describes what is to be processed and Applications tell How is it to be done.I guess you know what a database and an application is....(giggling)

Monica: I'll slap you if you tease me(trying to pull my hair)

Me: ok ..ok.!!!!!!Relax ! I was just kidding.There is a huge amount of data and there are various applications needed to play with that data.Now we have to make sure that these two dont get mixed up else there will be huge chaos.Therefore everything is arranged in such a manner that it is convenient and efficient as well.Even if they are on the same machine , they need to be separated. Now instead of keeping all the data on each machine,we have a server that keeps all the data and other computers are connected to this server so that they can access it as and when required.This makes up Local area Network.If this area is spread in a large amount of area and plenty of computers are attached to it then we call it WAN(wide area network).Are you getting it?

Monica: Yes..yes..carry on(folding her legs comfortably on the couch and seems to be interested)

Me: Ok..This we call as Client-Server architecture...Clients being the various computers attached to the server.To access these we need Oracle,Sql etc.On the client's end we have GUI-graphical user interface, that helps us to work on the machine.Now it has some demerits as well.Like It might be slow due to various machines trying to access the same server and the  applications might need to be updated because we have newer versions coming up every now and then.
Next comes the Three tier architecture.In this ,at the server end, we keep the business application along with the data as it is common for the users.Business logic is kept central whereas presentation logic is kept locally.
Next is the INTERNET which we refer to as Multi-tier architecture.(walking towards the fridge).You need another soda?

Monica: Yes(smiling)!!
 (I pulled out two chilled sodas and gave one to her)

Me:So..At the server we have data,business application,and web server.Now the clients just need to have the web browser to access the data.They need not even have the business applications .But this calls for an added disadvantage of security.For that we use firewalls in order to give access to only authorized person.
Now what corporate companies do is that they have this corporate database,enterprise application,and web server at one end,connected to this is a firewall server to protect from the web.

Monica: I guess thats enough  for me today.Thank you! that was really helpful.

She stood up,had the soda in one go and went inside..I moved towards my table,opened the laptop and continued writing the assignment...
"Monica looked quite frustrated when she......"