SUMMARY:

• Seventeen years experience designing and developing database systems.

TECHNICAL SKILLS:

Technology and Tools: IBM PC & Compatible IBM 4381 DOS/Windows 3.x, Workgroups, 95/98/NT UNIX HP 9000 UNIX Oracle CASE*Method Oracle Designer/2000 Versions 1.1, 1.2 1.3, 2.1 Oracle CASE*Dictionary Version 5.0 Oracle CASE*Designer Version 1.1, 2.1,6.i Oracle CASE*Generator Version 2.0 Oracle RDBMS Versions 6.x, 7.1.3, 8.0.4, 8.1.6, 8.1.7, 9i Oracle SQL*Forms Versions 4.5 and 5.0, 6.i Oracle SQL*Plus Version 3.1 and 8 Oracle SQL* PL/SQL Version 2.1, 2.2 and 80 Oracle DataBrowser Version 1 and 2.0 Oracle ReportWriter Versions 1.0 and 2.0 Oracle Discoverer 4.1 Oracle SQL*Loader Version 7.0 SQL*Studio Version 2.0 PVCS Version Manager Version 5.2 SQR Version 3.0 dBase III and V HTML DB SQL PL/SQL SQL*Plus Visual Basic Access Basic xWindows UNIX LAN (3+Open v1.1) Lan Manager v2.2

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Architect

Responsibilities:

• Designed the catalog data model for the web services of NOAA’s National Marine Fisheries One Stop Shopping with Oracle’s Designer 6.1 including all relevant data structures. Also built a transactional web front end to the National Bycatch Reporting System in Oracle’s APEX, or Application Express. Oracle 10g. DB creation, exports, imports, dumps, table design, indexes, constraints, database triggers, pl/sql procedures and data loads. Oracle 10g and SqlServer 2005.

Confidential

Database Designer

Responsibilities:

• Responsible for Oracle data model. All new or modifications to objects such as indexes, triggers, tables, constraints. Pl/sql routines comparing recordsets of 100 million plus.
• RITPO
• Research Information Technology Program Office

Confidential

Data Manager / Data Architect

Responsibilities:

• Oracle Designer in Oracle 10G. Also built the pl/sql HTML DB front end. Confidential provides the IT for healthcare for all branches of the
• Provide data architecture insight to others in supportof theimplementation a Service Based Architecture that enables distributed, network centric operational threads.

Confidential

Data Architect, Database Developer and DBA

Responsibilities:

• 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. DBA implementation and oversight.

Confidential

Principal Consultant

Responsibilities:

• 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, 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. 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 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. Also customized 11i 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

Responsibilities:

• Develop the Integrated Naval Research Information System (INRIS) 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.
• 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 WEB, a combined INRIS, Web and EDI application. The Office of Naval Research s grant money of 4 to 5 billion dollars annually.

Confidential, Bethesda, MD

Oracle Coursework Sabbatical

Responsibilities:

• ORACLE Designer/Developer 2000 masters program from Confidential ed 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, Bethesda, MD

Database Developer and AdministratorSupervisor

Responsibilities:

• 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