Offshore Software Development Case Study

Industry

Computer Hardware

Scenario

Hitachi Data Systems (HDS) planned to enhance their 'Hitachi Unified Compute Platform for Oracle and SQL Server' with utility apps that monitor the health and growth of their client’s databases. HDS wanted to provide their storage clients with complete summary evaluation and trending of database environments. HDS conceptualized HiSED, a suite of utility apps to maintain their leadership position in the storage market

Software Implementation Partnership

Apps needed to be highly innovative to provide competitive edge over business rivals

Since it's a new solution being conceived on-the-go with some pilot feedback, the product requirements were defined as:

Needs to be built incrementally and iteratively

Built using a feedback-driven agile development process

Development team needs to be highly flexible and receptive to changes

Development team to be well versed with proven, very best engineering practices

Development team needs to be highly innovative to digest the business context and come up with intuitive features

Hitachi wanted to leverage the offshore cost arbitrage. Hence, a development team from Congruent as their 'Virtual Team' was hired. The team worked with the Hitachi as one team using state-of-the-art collaboration & communication tools. Team used the time-zone difference to their advantage, both teams had 3 hrs overlapping, worked cohesively & ensured highly successful product launch.

What is HiSed Application?

Using VBA macros, HiSED tool is capable of gathering required data from database instance AWR reports, and populate them in an individual excel worksheet in a desired format. Then it populates the summarized data of all the instances in another worksheet. It also represents imported data in a Bar Chart, Pie Chart, Column Chart & other graphs available with the MS Excel dynamically.

The tool has built-in Excel Chart objects to visualize the data imported form AWR reports. The excel chart objects consume memory and it made the importing process hang and quits MS Excel. Hence ‘Excel Chart objects’ are converted into ‘Excel Data Bars’. The data bars are not graphically rich and was not legible in the exported PPT.

Congruent provided a solution to create those excel chart objects dynamically after parsing the AWR reports. As these chart objects are created at the end of the process, system was stable and provided an excellent usable report.

Engagement Model

This project was executed on a retainer model by a team of 15 members.

Contact us to know more about our Offshore Software Development Services