Customers

John Hancock

Wealth Management - Project involved the design/development and implementation of both Operational Data Stores and Data Marts. The many projects involved many feeds, extracts, data stores and data marts. The largest project being the integration of John Hancock data history into the Manulife ODSs and DMs.

Technologies used:
·         Microsoft SQL Server
·         Informatica
·         Cognos
·         ERWIN
·         DTS

Responsibilities and accomplishments:
·         Database design and modeling
·         Stored Procedure design and development
·         DTS design
·         Compare process development
·         Upgrade process/procedure design/development and implementation
·         Performance tuning

Biogen Idec

Working in the database administration group, tasked with trying to improve the performance, design and maintainability of their commercial data warehouse and other database applications.

Technologies used:
·         Oracle 9i and 10g
·         Informatica
·         Business Objects

Responsibilities and accomplishments:
·         Oracle configuration and tuning
·         SQL Statement tuning
·         Requirements gathering and recommendations on hardware
·         Monitoring

Plymouth Rock Assurance

Project for the design/development and implementation of a Decision Support System. The system is being developed to give the user community better tools and access to a large data warehouse. The project was initiated by one of the company presidents to try and get the users to better understand the business.

Technologies used:
·         UDB
·         Hyperion Performance Suite
·         Informatica
·         Microsoft SQL Server
·         Power Designer
·         DTS

Responsibilities and accomplishments:
·         Requirements gathering
·         Prototype development
·         Database design and modeling
·         Stored Procedure design and development
·         ETL design
·         Performance tuning