!! Painting Elite with Orange !!

Elite Pre-owned bikes is a Private limited company established in the year 2010. It deals with selling of high class and well - maintained pre-owned bikes at an affordable price
At elite we understand the value of your hard earned money. We also understand your sense of comfort and desire for satisfaction.
Having started as a localized business unit in Bangalore we now aspire to be all over India and establish Elite as a brand. Our rapidly increasing sales , have already enabled us to be in places like Kolkata , New Delhi  and Mumbai and there are yet more destinations we aspire to be in.

We offer well maintained and next to new products which suit your pockets.
"TVS apache , KTM Duke, Enfield Thunderbird, Karizma ZMR" looking for these kind of premium segment bikes then Elite is the place to be.
Our pride lies in our after sales service which is second to none.
Our Products are unique , in best of condition , prices lowest in the market taking pre-owned bikes into consideration.
Drop into our showroom to experience the ectacy of "value for money".


1) Problem Statement :

Increase in sales coupled with surge in customer demands necessitates the provision for growth. As such we are growing as an organization by recruiting more and more people. We have added Kolkata , Mumbai  and New Delhi already in our map apart from Bangalore and we aspire to add in more cities in near future.
As such definite HR IT integration to manage our manpower is indispensable.Bbut since we are a new company and going through the investment phase in our projects , we have a budget constraint to implement a IT integrated HR solution.

2) Available options :
After having done some primary research on the free web hosting service providers like  Biz.ht, ByetHost.com, 100webspace.com, FreeHostia.com etc we finally decided to go for X10Hosting.com.
X10hosting came to our rescue as it enables creation of free DNS and the ability to choose from various software which are free of cost. In this platform we found its Orange HRM application very suitable to our current needs

3)Advantages of Orange HRM :

>  It is fast and easy to install at free of cost.
>  The appliccation is very user friendly.
> Since we are growing in terms of size, Orange HRM provides the flexibility to add more number of   employees with subsequent recruitment.
> It gives us the flexibility to add in project , add in customers and correlate them by assigning specific projects to customers.
> Lot of customization can be done apart from the basic platform.
> The application is easy to customize and very user friendly.

4) Limitations :

Although the software efficiently serves our purpose keeping in mind the present requirements but in future going for an integrated HRM platform in the lines of SAP or ORACLE would be a viable option for us because:
> The pay slip generation and Form 16 generation application are not very feasible.
>Attendance regularization for employees i.e coming late or working outside office is limited.
> Booking of hotels and guest houses for outstation tour and reimbursement facility for employees is not been provided.


5) Configurations :


> The employee list ranges between 1001 and 1021.
> For all the employees details of job , salary, qualifications have been added.
> A specific reporting hierarchy based on the organization structure has been created.
> Projects have been specified in regard to specific customers.
> Project heads have also been added to specific projects.
> Key performance indicators  have been specified for the respective roles of emloyees.
> Provision for performance reviews have been enabled for employee numbers 1005, 1014 and 1018. Similarly it can be added for other employees.
> Earned , casual and sick leave have been provided to all the employees.
>Current vacancies and candidates who have applied for the vacant post have also been mentioned.

6) Application : 

To access the application  click here

The credentials required for admin are :
 User id - admin
 Password - elite

and for employees :

for employees with employee id 10XX ,
User id - 9910XX
Password - 9910XX.

for example , for employee id 1004 , user id is 991004 and password is 991004.

ELITE PRE-OWNED BIKES ( Vendor side perspective )

#disclaimer: This post is prepared as a requirement for ZOHO APP, MIS Course, VGSoM, IIT Kharagpur fall semester class of 2014

Topic: To Develop an application in Zoho Creator


An Order to Cash application that will allow customers to register and place an order. The customer will be able to book and pay through internet banking option. It will also allow the admin to generate an invoice of the order and subsequenlty deliver the product ordered to the address of the cutomer specified while registering. Specifications are left fuzzy and it is expected that student will use his knowledge of business to come out with an appropriate design.

This application was created by me on request of my customer for the completion of ZOHO app assignment.

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


For User Manual Click here 

Elite Pre-Owned Bikes.....click here

Customer requirements and Certification

ZoHotels Requirements

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

Customer:   Debjyoti Mitra(12BM60052)
Vendor:  Lakshmi Priya Vijay(12BM60055)

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 Lakshmi Priya Vijay(12BM60055) for building the application “PartyZoHotels ” have been listen down :-

●      SignUp Portal :

This is the software’s New User Registration portal, which should ask the customer to feed in a basic set of personal data which MUST include Customer Email ID and Password. On successful submission the SignUp form, an email should be sent to the Email ID entered, a welcome message with the information that the customer should use his e-mail ID and password to sign in and his favorite party hall at ZoHotels.

●      SignIn Portal :

The Customer SignIn portal should be designed to take in the Email Address and Password as mandatory fields. On successfully submitting the SignIn Page the customer should be made to redirect to the Party Hall Booking* portal.

●      Google Maps link to Bandra, Mumbai:

As Party @ ZoHotels is located at Bandra, Mumbai, the customer should be provided with a link to the Google map of Bandra, Mumbai.

●      Feedback Portal :

The feedback portal is to facilitate the customer to provide a feedback about the Party Hall and the service- There should be a dropdown menu for Complaints and Suggestion For Improvement.

The Home page should also have a button named “The ZoHotels Gallery” which redirects the customer to The ZoHotels Gallery Page***.

 *Party Hall Booking Portal:

This is the portal which enables the customer to book the Party Hall of his choice, where the Name, Contact Number, Number of Persons, Date of Party, Type of Party Hall, Food Preference, Choice of Cuisine and Genre of Music to be played at the party should be asked for. On successful submission of this form, a booking confirmation email should be sent to the registered user’s email ID with a message that the Party Hall booking has been confirmed and redirect the user to Order Successful Portal** along with a message that the booking has been successful and an email has been sent to his email ID for confirmation of Party Hall Booking.

** Order Successful Portal:

This is a Thank You page with a message that a confirmation mail has been sent to the users’ email ID. This should also have a hyperlink “Back to Home” to enable the user to go back to the Home page.

ZoHotels Gallery Page***:

This page serves as a gallery which contains the Photos, Price per day and a short description of each type of Party Hall:

The Rate slab:

Type of Party Hall	Price per day in INR
Birthday Party Hall	25000
Business Party Hall	30000
Disco Party Hall	27000
Jungle Party Hall	24000
Poolside Party Hall	26000
Wedding Party Hall	50000

ELITE PRE-OWNED BIKES portal's Requirements

Requirements given by Ashwini Kumar Rao(12BM60047) who is the customer of Elite Pre-Owned Bikes.

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

Customer:   Ashwini Kumar Rao (12BM60047)
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 :-

Ø  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.

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

Ø  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.

Ø  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.

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

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

Ø  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.

Ø  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.

MIS first chapter covered

It was a gloomy sultry evening, and my mood gave a tough competition to the weather outside. From morning we had a power cut due to some grid failure and to add to that the drizzle never seemed to stop making it more humid and pathetic. “Welcome to VGSOM , IIT Kharagpur “, this is what rang through my ears . I was wondering what kind of a welcome were the seniors talking about ? ?? No Fresher’s party yet, and to add to our misfortune went on the clubs selections, sitting all night through to get done with our presentations for the club interviews and not to leave the sessions and events even on the weekends.......
10 subjects, lakhs of assignments, surprise quizzes were waiting to devour us in the days to come. Keeping worries aside I went to Dipanjan’s room (who is pursuing MTECH in Computer Science out here in IIT Kharagpur and happens to be in his final year) room to have a break. He was busy explaining system architecture to 1st year UG guy. Now we had a subject called management information system which I knew would require fundamental computer hardware and software knowledge. So I thought it will be prudent enough for me to sit and listen to their discussion so the MIS gets easily tackled.
UG guy - what is system architecture and what does it contain ??
Dipanjan – A computer system architecture consists of four major components. Storage, processor, peripherals, and input/output. The storage system is used to keep data and programs, the processor is the unite that controls the operation of the system and carries out various computations; the peripheral devices are used to communicate with the outside world; and the input/output system allows the previous components to communicate with one another.
UG guy – so how is this storage and processing done ??
Dipanjan - have you heard of data structures and algorithms??
UG guy –Yaa, do have some vague idea, data structure is a way of organising data so that operations on the data are done in most effective way. I mean operations such as creation insertion , deletion , traversal , search , displays etc. and algorithms represent how this process is done.
Dipanjan – As you understand the fundamental process, I will tell you about single tier architecture which means that the data and the application exist on the same machine, for example both the word processor and the document which you create by using the word processor lie on your desktop only.
UG guy – But when there exists a large number of users and all of the want to access the access application ?
Dipanjan – that can be taken care by the 2-tier architecture. Here each user has a copy of the application in his own machine, but the common data that is used by all is stored in a common machine called the server. Since there is only one copy of the data available to all users, hence there will be no inconsistency when the data is modified by any user. It also ensured that individual machines are not loaded beyond their capacity because the application logic is placed on different machines.
UG guy - But again, I think using this architecture becomes a huge challenge when hundreds and thousands of users are involved because high bandwidth will be required to cater to such a large number of users.
Dipanjan - You are correct. This can be resolved by the Three-Tier architecture where the application is divided into two parts. One part, which handles only the user interface, is on the client machine and the other part containing the complex business logic is stored at a central location. This common location is known as the application server. Hence, any kind of changes to the application can be done once at the central server only. An ERP product like SAP or Oracle e-Business Suite is a suitable example of a well designed three-tier application where the database server exists at the back, an application server runs the ERP software in the middle and the ERP client software resides on every user’s machine.
UG guy – In that case the ERP software has be to installed in each and every user’s machine.
Dipanjan –Internet comes up with a solution for this, an additional machine called the web server can be placed between the application server and the user. Here the client software on the user machine has been replaced by the web browser which cannot communicate with the application server directly but needs an intermediate server for this purpose. This need is fulfilled by a web browser which converts the data traffic from the application server to a recognizable format. Firewall ensures that datas are safe denying access to unauthorized computers.
Suddenly the power was back. The grid failure had been resolved. We started to head towards the mess to have dinner. On the way I thought “ MIS first chapter covered”