PrestoServ and its architects have successfully implemented solutions for the diverse data needs of a variety of projects and industries in the following areas:
Data Warehouse Development
University of Maryland University College (through iCUBE Systems) – data warehouse design, source data analysis, and ETL process design.
Oracle Database Design
Lockheed Martin (through CPSI) – designed several Oracle database instances using the System Architect data modeling tool.
Legacy Data Migration
Constellation Energy (through TEKsystems) – designed target tables and archived legacy data using ERwin and Oracle.
multi-state Medicaid System projects (for CNSI) – PrestoServ's chief architect expanded and maintained data models in ERwin. Generated SQL scripts for database schema creation and updates. Merged database structures from Washington's to Michigan's projects.
ETL Design and Development
Northrop Grumman (through Trilogy Technology) – received, cleansed and transformed military health record data and loaded it into Oracle data warehouse. Created Informatica sessions and workflows to move source data into target environment.
General Dynamics (through Adecco Technical) – built a web-enabled corporate data dictionary, using ERwin, Oracle, netViz, and ASP. This effort included defining standard data elements and mapping various database / table / column combinations to them for display in user-friendly interface.
Legacy System Data Conversion
UnitedHealth Group / Dental Benefit Providers – PrestoServ's chief architect led team for Data Conversion from legacy system to Facets, supervising software engineers in extracting data for providers, employer dental benefit groups, members, claims and accumulators.