-
ADESA
Developed an ODS source system for future data mart building and reporting.
-
Albany Times Union
Developed several SSIS packages that automate the secure FTP to obtain files from several government agencies and extract, transform and load these files into SQL Server databases. The data sources were all of varying layouts and data types.
-
Arch Insurance Group
Designed and developed corporate central data repository and related data marts to ensure the integrity and accuracy of data.
-
AT&T
Identified, validated and enhanced over 40 business rules, resulting in significant reduction of time and costs associated with manually researching and correcting issues enabled by DataStage-based rules filter implemented by TEKsystems.
-
Blue Cross Blue Shield Minnesota
Built a data mart loading automatically via SSIS 10 of 90 metrics–dashboard to display the raw metric and the trend (.NET 3) and a Web entry form to allow users to enter data in their data mart.
-
Data Recognition Corp.
Created a fully functional, rich UI, prototype of a front end application to publish the 25 reports of the Alabama State DWH that was also migrated from Cognos to SSRS.
-
FHLBank Pittsburgh
Designed and developed a corporate central data repository (CDR) and related data marts for the enterprise
-
HMSA Hawaii
Implemented a report conversion from Crystal Reports to SSRS 2008; report upgrade from SSRS 2005 to SSRS 2008.
-
Insurance Auto Auctions, Inc.
Development support of over multiple database-related projects .
-
Morgan Stanley
Developed a HASP/HAMP and Loss mitigation model, ETL process and reporting.
-
Peabody Energy
Performed a data migration from Mainframe to Oracle of 11 subject areas. Built reports to supply same or enhanced reporting capabilities.
-
Penn National Insurance
Added the agency-level calculations along with several improvements and fixes to the calculations, reports and user interface to the tool used to calculate profit sharing. The results were to be redistributed every year to the agencies.
-
Philadelphia Insurance Companies
Converted a large module from the Submission Application from Visual Basic 6, ASP and .NET 1.1 to the MS .NET 2.0 framework.
-
Prudential
Built a Global Data Warehouse where all Real Estate and Relocation Services operations data is centralized in order to achieve advanced online analytics with consolidated reporting capabilities.
-
Renal Advantage, Inc.
Performed an extensive enhancements to existing Reporting Portal, which includes ASP.NET development that allows users to build specialized criteria for reports, by user location. Built custom dashboard for expanded reporting needs, including graphics. Upgraded the look/feel of entire portal.
-
Sunoco
Built a Global Data Warehouse (scorenet) where all marketing operations data were centralized in order to develop a webfocus application.
-
Time Warner Cable
Migrated the Remedy tracking application to issue tracking system.
-
University of Rochester
Built and enhanced a patient-based fundraising program for the University of Rochester Medical Center (URMC).
-
Washington Dental Services
Implemented CIF/EDW to meet strategic project objectives. Included in this effort was an ETL conversion from DataStage to SSIS, CIF/EDW expansion, and data mart design and architecture.
-
Westfield
Converted ETL load processes for 11 subject areas from Informatica to DataStage
-
Wilton Re
Rebuilt existing Financial Mart to provide quarterly financial activity. The solution was to be rebuilt from bottom up with additional functionality.