Case Studies : Web Development

Workflow Management System for a leading Water Heater Manufacturer in USA

Client Requirement :

This was a project we worked on for a leading water heater manufacturer in USA. The company was looking for a complete workflow management system in order to automate its process of distribution and selling. Being in the business of manufacturing & selling water heaters, the company had various distributors and sales representatives to eventually reach out to the end user. The workflow automation system had to keep this complex distribution & sales system in mind. Moreover, our system was also responsible for generating high level MIS reports.

Following are more details of the key client requirements :

One of the most time consuming part of the job was to understand the complete flow & functionality for each role. This included the roles of distributors, contractors, sales reps, regional sales manager, and website admin.
The workflow automation system was supposed to be capable of multi-user roles and logins.
Each user shall have access as per their roles, and be able to see orders, sales and reports.
Document Management was an important & challenging part of the role.
The system was required to generate comprehensive and holistic sales & revenue reports.
The development wouldn’t be complete without extensive training on the system.

Project Challenges :

Understanding the existing infrastructure, systems, and flow.
Developing complete knowledge about relations between different roles like distributors, contractors, sales reps, regional sales manager, and website admin.
Deciding on a system flow to cover all requirements.
Staying abreast with the existing data from Oracle DB.
Maintaining up-to-date sales & purchase details based on the above.
Generating top quality reports.

Technologies Used :

ASP.NET 4.0 – Design & Development.
SQL Server 2008 – Design & Development.
MVC & Entity Framework.

Solution :

The final solution to the customer combined powerful technologies like ASP.NET 4.0 and SQL Server 2008. With SQL Server 2008, we made use of MVC and Entity Framework. This was finally integrated with third party PDF tools for high quality PDF report generation.

User-friendly and manageable workflow for all roles – Distributors, Contractors, Sales Reps, Regional Sales Manager, and Website Admin.
Role based logins for Distributors, Sales Reps, and Regional Sales Manager.
Ability for members to see sales report based on data received from Oracle system.
Separate logins for contractors to view customer leads, generate invoices and view reports.
Admin login with CMS capabilities for news, training, and announcements.
Admin rights to generate MIS reports.
Automation & management of daily updates of data from Oracle DB (in CSV format) by creating a stand along application.

Portfolio Management for an Investment Advisory Firm

Client Requirement :

This project was for the design & development of a complete Client Portfolio Management application. Given that this is an upcoming investment advisory firm, we had nothing to take reference from. While there are some existing apps, we wanted to create a unique application that perfectly matched the needs of the end users. Another interesting facet of the app was that it was supposed to work like an add on to the existing application.

Following are more details of the key client requirements :

We need to garner detailed understanding of the clients’ existing site & structure to provide a tailored solution for new development.
The application was expected to present capabilities of online purchasing, selling, redemption, and scheme switching.
The existing user experience had to be enhanced.
Payment gateway had to be smoothly implemented.
Special focus had to be laid on site & data security, especially because the app was expected to deal with people’s financial information.
Deployment & maintenance on a cloud server was another important aspect of the requirement.

Project Challenges :

Understanding the existing infrastructure, systems, and flow.
Developing complete knowledge about relations between different roles like distributors, contractors, sales reps, regional sales manager, and website admin.
Getting familiar with the industry, and creating a system for real time data input from the capital markets and updating the same on the database.
Identifying key areas of integration.
Gauging the existing database structure, and identifying the part which can be used for integration with new database.

Technologies Used :

ASP.NET 4.0 – Design & Development.
SQL Server 2008 – Design & Development.
MVC & Entity Framework.

Solution :

The final solution to the customer combined powerful technologies like ASP.NET 4.0 and SQL Server 2008. With SQL Server 2008, we made use of MVC and Entity Framework. This was finally integrated with third party PDF tools for high quality PDF report generation.

User-friendly and manageable workflow for all roles – Distributors, Contractors, Sales Reps, Regional Sales Manager, and Website Admin.
Role based logins for Distributors, Sales Reps, and Regional Sales Manager.
Ability for members to see sales report based on data received from Oracle system.
Separate logins for contractors to view customer leads, generate invoices and view reports.
Admin login with CMS capabilities for news, training, and announcements.
Admin rights to generate MIS reports.
Automation & management of daily updates of data from Oracle DB (in CSV format) by creating a stand along application.

Online product-store for a food product company

Client Requirement :

Online store for food products with e-commerce platform to sell products online. Displaying list of products and options to view product details with payment gateway integration with shipping and discount offers.

Following are more details of the key client requirements :

Creating online store for food products.
Thumbnail & Detail view of products and ingredients.
Capabilities of online purchase.
Implementing payment gateway.
Site and data security.
Recent news.
Shipping and discount offers.
Facebook Likes.
Displaying List of stockists to user close to their location using Google Maps.
Order Management.
Discount & Offers.

Project Challenges :

Understanding the requirements in detail and providing feasible solution.
Payment gateway integration and resolving payment gateway issues.
Security of transactional data.
Rules for discounts and Shipping.
Displaying location of stockists and details based on PIN code entered using Google Map API.

Technologies Used :

ASP.NET 4.0 – Design & Development.
SQL Server 2008 – Design & Development.
MVC & Entity Framework.

Solution :

The design and development was done in ASP.NET 4.0 and SQL Server 2008 using google maps as third party tools for plotting stockists of the products.

Online product gallery with details and purchase option
Allowing discount code option for specific duration as and when required
Shipping amount flexibility based on number of products purchased
Payment Gateway Integration
CMS capabilities for news, inspire me, and stockists option
Integrating google maps for displaying locations and addresses of stockists based on PIN code entered
Integrating Facebook Likes for news

Realty Portal

Client Requirement :

The project was for re-design and development of complete web based realty portal to serve as one-stop resource for online real estate research. It should be a smooth process of finding properties throughout India. Searching for right property should be easy and should have filters to allow users to search properties to meet specific requirements.

Following are more details of the key client requirements :

Listing of properties for various categories.
Quick and easy search with latest properties display.
List of properties based on search with thumbnail of properties and specific details.
More filters for user specific search.
Complete details of property.
Contact form for each property and shortlisting of properties.
Downloading of project brouchers and research reports.
Complete responsive design for desktop, tablet and mobile versions.

Technologies Used :

ASP.NET 4.0 – Design & Development.
SQL Server 2008 – Design & Development.
MVC & Entity Framework.

Solution :

The final solution to the client combined powerful technologies like ASP.NET 4.0, MVC and SQL Server 2008. This was finally integrated with third party PDF tools for high quality PDF generation.

Complete responsive (desktop, tablet and mobile versions) and user friendly website.
Quick search for properties based on city, locality, project, price range and property type.
Listing of properties with quick view of basic details like locality, rate, area (carpet usable area), developer, current construction status, possession year and option to view complete property details.
Property shortlisting and contact form for each property.
Complete view of property including overview, location maps, layout, specifications, floor plans, Amenities, photo gallery...etc.
Download property specific brouchers.
Generate PDF on the go for required details for the property.
Downloading of project brouchers and research reports.

Case Studies : Web Development

Read More Case Studies