ApexSQL Software, USA awards VALUED third party template author status to Harjai
 
 
 
The Customer
  Our Customer is a leading gas company, headquartered in Providence, Rhode Island, USA.
   
The Challenge
 

Our Customer supplies gas to big companies for resale as well as direct small consumers. As a result of having big set up to maintain the customers , data was immense, volume wise. Our client was experiencing tremendous change as a result of its own business strategy as well as regulatory pressure (Govt. Changed many rules, so many business rules were changed accordingly). The IT systems that were in place, were simple and unable to manage the complexities which had arisen due to the above changes. The earlier system was developed in MS Access running on Windows based PCs. It was required to be re-engineered to work with Oracle based front-end and back-end to run on AIX on IBM RS6000 platform.

   
The Solution
 

Our role in this project ranged from inception to completion. Starting with an initial requirement study at the client's office. The source code and documentation of the excepting MS access system was not available. We studied the existing system and also interacted with direct and indirect users of the system and came up with Functional Specification.

The new system which was suppose to work with Oracle 7.3.4 on AIX on IBM RS 6000 was designed using Designer 2000. The users at client side were very choosy, they wanted the keystrokes to work in the exact fashion that it used to work in MS Access. So many times we had to really do things in the reverse way of Oracle to get the desired result.

The system study was done at the client site by our Project Manager who interacted with his counterpart at our Offshore Software Development centre at Mumbai. The entire design was done with close interaction of the onsite and offshore Project Managers. The development was then carried out under the guidance of the Offshore Project Manager at Mumbai and the final implementation was done again by the Onsite Project Manager.

The development was done in SCO Unix and no OS related features were used so that the implementation on IBM RS 6000 was effortless.

   
The Customer
  Our Customer, the Fleet Bank's Global Markets & Treasury System Group based in Boston, US.
   
The Challenge
 

Our Customer is in the field of Banking and Treasury operations. The customer contracted ManageIT, our alliance partner in CA, USA to document an existing application using reverse engineering approach. In pursuing this project the client was expecting the following objectives.
1) Formalize the documentation of the existing application.
2) Further advance its commitment to adopt the UML (Unified Modeling Language) Standards (primarily Use Cases)

   
The Solution
 

ManageIT offshore process dictates that activities related to planning and elaboration phases be
conducted locally, given the high level of interaction with Fleet bank.

The documentation of the existing systems were supposed to be developed at our Offshore Development Centre at Mumbai. This meant that the solution needed smooth coordination, effective communication between multiple entities.

ManageIT worked closely with Fleet Bank and We, the Offshore team in India worked closed with ManageIT to ensure that the deliverables of UML (primarily Use-Cases) will be accordance with the Standards specified by ManageIT for offshore development.

Our team designed, developed a comprehensive solution that integrated the entire process of the existing application of the Fleet Bank. The working of the Fleet Bank and the existing application was complex. We made it possible, giving the samples and more than one solution for problem using Use-Cases. ManageIT and Offshore team selected the most suitable solution for the Fleet Bank for its existing application. It was a difficult task for any offshore team to understand the clients requirement only through the documents like functional specification and without any actual interaction with the end users directly.

We as offshore team, used our business and analytical experience and skill to give the most acceptable Use-Cases and proposed a system document with consistency, completeness and accuracy after doing a thorough investigation using documents like functional specification, standard/guidelines document and day-to-day conversation with overseas project manager.


   
 Back To Top

Home | Services | Expertise | Products | New Releases | Case Studies | Purchase  | Press Release | Careers

Profile | Mission | People | Methodologies | Clients | Associates | Contact Us | Site Map

Privacy Policy | Terms of Use

Copyright (C) 2002 Harjai Software Consultants. All rights reserved.