Consolidating datamarts

Posted by / 13-Sep-2017 13:57

Consolidating datamarts

Cepheid had developed reports to see invoiced sales, booked sales order, pending shipments by entity.

Cepheid needed to be able to view invoiced sales by region or by territory starting with current quarter and looking back 4 quarters.

Ability to understand the business environment and translate business requirements into technical solutions.

Their major challenge was to gain greater visibility into financial, physician performance, educational and research data.

This project is aimed at developing a research oriented DWH for fast, accurate decision making.

Objectives include, consolidating information from multiple data sources, establishment of an integrated business intelligence reporting and analysis solution etc.

Environment: Data Integrator 11.7.2, Oracle 10g, MS SQL Server 2005, Windows XP/NT.

consolidating datamarts-4consolidating datamarts-46consolidating datamarts-28

Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new environment and tools.