This case study is about the Enterprise Application Integration which is being implemented at large sized a Freight Forwarding Company in Mumbai, India.
They offer comprehensive freight forwarding solutions to a cross section of clients across India.
They term themselves as a one stop solution for importers and exporters having branches all over India.

Business Situation
- Legacy Systems for sales & marketing department
- Bought Out Product for Operations department
- Standardized Accountancy Package

Business Challenges
- Numerous restrictions in the legacy system. Important data not counted for.
- No Centralized database.
- All products/systems developed on different technology platforms.
- Resistance of staff members to shift to another application.
- Management unable to get timely accurate data/reports.
- Lot of time lost in compiling data from different systems and generating required reports.
- Restriction on budget due to already blocked investment software which wasn’t giving required results

“blueMango solutions came up with a brilliant way out to help us get over the problems we were facing without any changes in our processes and it turned out to be a very cost effective solution. Our management is particularly impressed with the reports output which they are planning to deploy.” Software Manager

blueMango solutions approach
- Due to the business challenges like restriction of budget, resistance of shifting over to    another system, suggesting a complete new solution was not the option for this client.
- The major hassle they were facing were the reports generation as the data has to be    picked up from their Sales and Marketing system which was developed using Oracle 8i,    the Operations package was developed on Visual Basic 6.0 with the DB in MS Access and    the Accountancy package was also developed in Visual basic 6.0 in SQL 2000. But both    these systems being a product, the source code was not available with our client. So there    was no room for modification in these systems.
- So, Enterprise Application Integration was the best cost effective option to deal with the    chronic issues faced by this company.

Methodology
- blueMango solutions scrutinized all the systems being used with the individual user of the    system to understand the process flow as there was no documentation available on the    systems.
- Our team also analyzed the shortcomings of the existing system and the requirements    from the user’s point of view as well as the management point of view and accordingly    made prototypes of the reports which could be available with different filtering options.    The objective is to generate a summary which will take the user through the details as per    their requirement.
- We are developing an adapter which will connect these three systems at the database    level and pick up the essential data to give the required output. The user will have a    screen where he/she can choose the criteria, for example, Region: South East Asia,    Country: Singapore, Type: Sea Imports, Consignee:. Salesman, Date range and get the    specifications.
- The user can also generate a summary of the results based on the above mentioned    parameters which will give the management the entire picture of the group.
- A brief diagrammatic representation of the solution has been shown below:




- Our business approach, dedication and commitment can be distinguished from the    solutions we provide. As see in this case study, our client had tried to work out different    solutions with their existing vendors but w unable to come up with a cost effective    satisfactory solution.
- In order to strategize their business and expansion plans our client needed the accurate    updated information all the time as in their kind of business any inaccurate information    can lead to huge amount of capital being blocked.
- Our attitude of understanding the client’s processes and minimizing changing the same for    the sake of implementation of technology gives us the edge we require to achieve    customer satisfaction.
- On account of the successful solution, our client has decided to upgrade their sales and    marketing legacy systems in a phased out manner by partnering with blueMango solutions    as the technology consultant & developer.