RELEVANT EXPERIENCE:

Twenty years experience designing and developing database systems.

Summary/Accomplishments:

Confidential

Data Modeler

Responsible for all data models for the Confidential Army. Reversed and version controlled existing models. Created new logical and physical models and data dictionaries using Embarcadero's ERStudio. Gathered requirements with stakeholders and worked with developers for modeling applications any and all changes went through me to be modeled i.e. check naming and architecture standards as well as generating the ddl before going to DBAs. Created data governance plan, standard operating procedures, naming standards, domains and data dictionaries. All ERStudio features used.

Confidential

Sr. Principal Database Analyst

Confidential position in Oracle 11G supporting the Hospital Reporting Project for CMS Centers for Medicaid and Medicare Services . Hospital Reporting handles a great variety of health data from nationwide sources. Built reports from ground up, sending refcursors to Cognos front ends. Worked on dozens of pl/sql packages, loading and validating data, as well as sql scripting for the annual population of HCAHPS, Hospital Consumer Assessment of Healthcare Providers and Systems A national, standardized, publicly reported survey of patients' perspectives of hospital care. Modeled all objects as needed.

Confidential

Database Engineer

Responsible for data model of the Confidential Consular Affairs which received 20 million entrants during the month of October, as well as pl/sql tuning and procedures for processing the entrants. System uses .Net front end. Cleaned the database of unnecessary structures and merged closely redundant schemas.

Confidential

Senior Database Architect / Web Developer

Designed the catalog data model for the web services of Confidential Fisheries One Stop Shopping with Oracle's Designer 6.1 90 crossover functionality with ERwin including all relevant data structures. Also designed Marine Recreational Information System, and National Bycatch Reporting System datawarehouse. Built a transactional 100 page web front end to the National Bycatch Reporting System in Oracle's Application Express 3.2, pl/sql and Oracle 11g.

Confidential

Database Consultant

DB creation, exports, imports, dumps, table design, indexes, constraints, database triggers, pl/sql procedures and data loads. Oracle 10g and SqlServer 2005. DTS ETL data extraction of medical records from doctors offices for application providing ease of service during follow up office visits.

Confidential

Database Designer Northrup Grumman

Responsible for Oracle data model using Oracle Designer.. All new or modifications to objects such as indexes, triggers, tables, constraints. Pl/sql routines comparing recordsets of 100 million plus to ensure data integrity from different VBA databases.

Confidential

Data Manager / Data Architect

• Provided a deep understanding of the interaction of data between the Confidential Systems and other systems by the creation of an integrated data model which supports the overall enterprise architecture from Oracle Designer in Oracle 10G. Also used Popkins System Architect and Erwin. System tracked data elements from 72 feeds going through an API to eBusiness Suite HR application. Also built the pl/sql HTML DB now Application Express front end. APEX TMA provides the IT for healthcare for all branches of the U.S. Military.
• Provide data architecture insight to others in support of the implementation a Service Based Architecture that enables distributed, network centric operational threads.
• Supervise in-house staff and subcontractors.

Confidential

Data Architect, Database Developer and DBA

Responsible for requirements gathering, hardware and software recommendations for all tiers, and an enterprise data model for the Research and Special Administrations Programs RSPA for the Department of Transportation. Process flows, data flows. Populated financial model with legacy data. Common data model generated from Oracle Designer 9.0.4.4.8 . Front end to in .Net, with prototyping in Oracle HTML DB. APEX DBA implementation and oversight.

Confidential

Principal Consultant

Highlights:

• - Designer Lead 6i Release 4 at DOJ's Office of Justice Programs. Reverse engineered and created server model diagrams for 18 existing schemas and 1000 tables. Created data structures tables, indexes, triggers, constraints, sequences etc. and generated data definition language for new development efforts, such as post 9/11 benefits for the families of police and firemen who were killed. Customized Forms 6i and Discoverer 4.2 applications to datawarehouses and OLTP's.
• - Sole designer/developer of a 12 screen, 3 menu prototype on-line test taking application for the Internal Revenue Service for their internal use, using Oracle Forms 6i and designer-generated data model.
• - Sole designer/developer/tester for a 30 screen intranet web application for DOJ's Executive Office of US Trustees which tracks information about fraudulent bankruptcy petition preparers using Oracle HTML DB. APEX. It can be used with database versions 9.2.0.3 or above. Designer-generated data model.
• - Responsible for the monitoring component of Web Bid and Compliance a custom add-on to Oracle's 11i Financials - Purchasing Application eBusiness Suite for the City of Chicago, which involves tracking payments from Prime to Subcontractors, and web upload of payrolls. This application was built with Oracle Platform FlowBuilder, a web-based pl/sql development environment. APEX Also customized 11i // eBusiness Suite Developer 6i forms, and generated data definition language through Designer 6i.
• - Responsible for requirements gathering and design of the RABITS data model for the National Cancer Institute's Cancer Trial Evaluation Program. ERD, Process Flows, Business Functions, data definition language generated through Designer 6.0. Weekly meetings with FDA key users. Overall system reduced drug approval time at the FDA from 3 years to 6 months.

Confidential

Senior Systems Programmer Analyst

Confidential for the Office of Naval Research applying CASE Methodology using Oracle Designer/2000 and Developer/2000. INRIS runs Oracle RDBMS version 8.04 in a Windows 98/NT environment. Primary responsibilities include analysis, design, test and implementation of the physical model using Oracle Designer/2000, SQL Plus, PL/SQL, Forms 5.0 as well as reporting with SQR and Microsoft Access. Project received CMM Level II certification.

Also responsible for a payroll information system for the Navy Controller which compares different Navy databases. Team lead on many projects, with staffs of up to 40, including mass processing of financial commitments and obligations to the Department of Defense Accounting System DFAS . Lead INRIS programmer on AWARDWEB, a combined INRIS, Web and EDI application. The Office of Naval Research awards grant money of 4 to 5 billion dollars annually.

Confidential

Oracle Coursework Sabbatical

ORACLE Designer/Developer 2000 masters program certification from ORACLE Corporation awarded February 1996. Curriculum included: SQL, SQL Plus, PL/SQL, CASE Tools, Reports, Forms, and Graphics. Developing complex data models and designing databases, designing and building database objects and designing and building database applications. All latest versions RDBMS and tools.

Confidential

Database Developer and Administrator

Responsible for the initial and continued design full life cycle and maintenance of a marketing database of 5,000 companies which involved a tracking tickler system for marketer and account executive follow up activity, integral case status history, as well as nationwide mailing campaigns to target markets using dBase IV and extensive hundreds of commands / variables WordPerfect macros. Other knowledge includes Microsoft Office, as well as other spreadsheet, presentation and publishing packages. General knowledge of data conversion

Technical Experience: