Senior Oracle Data Architect and PL/SQL programmer for data migration and conversion project. Designed database to present Service Parts data with perspectives supporting both historical shipments and future engineering efforts. Revised, maintained, and published data model as needed changes were discovered and implemented. Coded all SQL and PL/SQL code for back-end design as well as data migration processing and API coding for front end User Interface.

Senior Oracle PL/SQL Programmer on Electronic Key Management System (EKMS) project for U.S. Army at the Aberdeen Proving Ground, Aberdeen, Maryland. Bringing years of experience to a team with very little experience, the project challenges were largely due to a still-evolving set of requirements. The other PL/SQL programmers averaged less than two years of experience with Oracle and PL/SQL. I shared known best practices and standards and helped to apply them as quickly as possible with the least amount of down-time and impact on existing functional code. Identified multiple occurrences of inconsistent data per Data Quality standards, and reported same to project management.

Application Development DBA and Data Architect on the Defense Personal Property System (DPS) project for USTRANSCOM. Designed and implemented new database objects (tables, views, synonyms, database links, packages, functions, stored procedures) in response to both formal and informal requirements. Designed and implemented new processes for data replication between database instances for Siebel and DPS applications. Used Agile Methodology for application development. Maintained and upgraded data model for DPS application database objects (including entity and attribute meta data) using ERWin. Enforced Master Data Management rules and coded downstream application updates for dependent data elements and attributes. Reported weekly on data quality discrepancies and worked with data ownership to resolve issues. Supported in-house testing group with back-end data analysis.

Senior Data Architect and Application Oracle DBA for the Treasury Financial Management (TFM) division. Supported project team of ten developers, five business analysts, and seven testers as the sole Oracle DBA resource. Developed standards and procedures for TFM DBAs and Data Architects. Performed “light” systems DBA work (user provisioning, security, tablespaces, etc.). Led extensive Application DBA work including SQL scripting for structures, data, and reporting, as well as PL/SQL coding of functions, procedures, and packages. Development work performed using Agile Methodology. Provided data modeling (forward- and reverse-engineering using Visio), test data generation for testing groups and data migrations and replications from production to test and development environments. Developed and maintained project meta data repository. Analyzed and reported to project management on data quality issues.