Data warehouse support and maintenance (PAS, Business Objects)

Development of Data Warehouse for insurance branch of a large USA manufacturer. The system supports the operations of several business units, provides timely and accurate reporting, and automates report generation process.

GRT CORP. (US)

GRT is a Connecticut based premier provider of integrated information management solutions for global corporations.

Principia Analytical System (PAS) v.3.1.6 was a primary data source for the Data Warehouse. The automated feeds from PAS and other data sources were developed to populate the Data Warehouse. A comprehensive reporting environment was built based on Business Objects.

Aplana responsibilities

Implementing changes in transformation and loading processes
Performing Physical Database Modeling including ER modeling and scripts generation
Implementing retroactive data conversion
Developing unit test cases and performing unit test cases for all modifications
Performing regression testing
Business Objects universe design and report development
Implementing changes to BO universes and reports
Updating development documentation
VBA programming
Oracle PL/SQL development

Tools

Windows 2000, Sun Solaris UNIX, PAS 3.1.6, Oracle 9i, Business Objects, BO BCA, Rational Unified Process (RUP), Rational Suite 2000

All projects

Moscow Office: 84/32, Bld 1, Profsoyuznaya Str. 117485, Moscow, Russia
Tel: +7 (495) 710 7581
United Kingdom Office: Cowley House, 12 Black Jack Street, Cirencester, Gloucestershire, GL7 2AA, United Kingdom
Tel: +44 (0) 845 055 9783
USA Office: 2600 Philmont Avenue, Suite 305, Huntingdon Valley, PA 19006, USA
Tel: +1 (215) 947 4757
info@aplana.com