Database Services

Key Skills

  • Database Logical and Physical Design
  • Database Application Development
  • Performance Tuning
  • Database Administration
  • Data Conversion and Integration

 

Successful Projects

Data Integration

Designed and developed various applications to synchronize data between operational systems (Oracle ERP database, SQL Server, EDI, flat file, Salesforce.com) using database gateways, cloud based dated integration tools (e.g., Dell Boomi), etc.

Insurance Corporate Data Model

Developed corporate data model for Mortgage Insurance client.  Model included over 350 business entities, supporting all aspects of policy management.  Defined database standards (naming, sizing, etc.).

Web Applications

Designed and developed a wide variety of database driven web-based applications using server page (PL/SQL, Java) and servlet technologies.

Data Conversion

Lead team migrating data from client’s legacy O/36 (flat files) and SQL Server systems to new Oracle database.  Conversion required complex data mapping, integration, and cleanup that ran more than 50 hours on multiple processors.  Production startup went flawlessly, under a very tight time schedule.