Government Agency Business Intelligence Solution
 

Government Agency Business Intelligence Solution

Government Agency Business Intelligence Solution

The Main Sail team contracted to direct the design and development of the Business Intelligence solution in an Oracle environment with SAP BusinessObjects and Informatica ETL.  All milestones of the project plan were delivered to the client on time to include the live production environment.

Main Sail drove improvements to the data delivery process from the web interface database into a new Operational Data Store (ODS) and Data Warehouse (DWH).

  • Managed the project planning, implementation, training and roll-out for the ODS and DWH
  • Established strategic value of data integrity by creating a single version of the truth  and a “one- stop” shop for all future data
  • Managed the business intelligence architecture and solution from an idea to a tangible asset (final product delivered to the client)
    • Used best practice approaches to the development, implementation and integration of the Operational Data Store and Data Warehouse
    • Conducted Business Requirements workshops with IT and the Business Personnel to establish as-is and to-be requirements
    • Partnered with the business stakeholders to align and prioritize future IT initiatives in support of the business objectives
    • Introduced new ideas, examined and applauded new approaches for the business to bring about change
    • Established stakeholder buy-in/alignment to help facilitate setting of strategic roadmaps
    • Developed and presented a conference room pilot (CRP) and recommended an ODS approach for a quick win solution followed by a data warehouse strategic design

Other Examples Of Our Work