Client Success Stories
Connecticut Based Retail Services Firm:
Requirements : Design and implement the Data Warehouse to handle aggregate reporting for management by objective.
Accomplishments : Created SSIS ETL programs to move data from persistent staging database to a dimensional reporting model;
Replaced a lead database architect and administrator; Designed and implemented an Operational Data Store (ODS) to capture incremental data changes from client's
CRM application using: SQL Server SSIS and TSQL; Created a dimensional model to allow for ad hoc end user reporting using SQL Server 2005 SSAS; Setup portal web sites
using SharePoint MOSS 2007 for each of the functional departments for SSRS, operational metrics and dashboards; Integrated Great Plains financials with for reporting;
Microsoft CRM custom reporting.
Connecticut Based Global Financial Services Firm:
Requirements : Implement a custom software package to manage re-insurance functions across all lines of
business that would result in an accurate global view of the company’s activities.
Accomplishments : Designed and implemented an Operational Data Store (ODS) to capture incremental data changes
from multiple source systems using SQL Server, TSQL, Informatica, SSIS and AS/400; Used SQL Server Profiler to monitor the performance of SQL Server
particularly to analyze the performance of the stored procedures; Worked closely with Microsoft SQL Server engineers to analyze and performance tune a 100gb SQL Server database;
Created incremental daily feeds of policy, claim, and premium transactions from inward data to be used to calculate transactions using SQL Server, Informatica, and Transact SQL
example one:
(move cursor over image for preview)
example two:
(move cursor over image for preview)