Pamela Bacher

***** ********* **** #***

Rockville, Maryland 20852

acct71@r.postjobfree.com

301-***-**** (c)

RELEVANT EXPERIENCE: Twenty years experience designing and developing database systems.

Summary/Accomplishments:

Arrowpoint Corporation 6/2012-12/2013

Data Modeler Ft. Belvoir, VA

Responsible for all data models for the Civilian Information Services Division of the U.S.

Army. Reversed and version controlled existing models. Created new logical and

physical models / warehouses using Embarcadero’s ERStudio, such as the Korean

National Recruiting System, a multilingual application.

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 enterprise data dictionary. All ERStudio features used including metadata reporting

and macros.

VIPS/General Dynamics Information Technology 1/2011-4/2012

Sr. Principal Database Analyst Columbia, MD

Heavy PL/SQL 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.

CORESTAFF / Serco 7/2010-12/2010

Database Engineer Rosslyn, VA

Responsible for data model of the Diversity Visa Lottery for the Department of State /

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.

IA-TEAM 11/2008-4/2010

Senior Database Architect / Web Developer

Designed the catalog data model for the web services of NOAA’s National Marine

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.

P4-HEALTHCARE 4/07- 11/2008

Database Consultant Columbia, MD

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.

VETERANS BENEFITS ADMINISTRATION 10/06-03/07

Database Designer – Northrup Grumman Washington, DC

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.

RITPO 08/05 – 08/06

Research Information Technology Program Office Falls Church, VA

Tricare Management Activity (TMA)

Data Manager / Data Architect

Provided a deep understanding of the interaction of data between the MHS - Military Health 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.

AVINEON Inc. 07/2004 – 7/2005

Data Architect, Database Developer and DBA Alexandria, VA

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.

Oracle Corporation 5/2000 - 6/2004

Principal Consultant various locations

Federal Civilian and

Homeland Security Vertical

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.

RS Information Systems Inc. . 03/25/1996 – 04/10/2000

Senior Systems Programmer Analyst Arlington, VA

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. 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.

Oracle Corporation, Bethesda, MD August 1995 February 1996

Oracle Coursework Sabbatical Rosslyn, VA

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.

Schoenke & Associates, Bethesda, MD 1990 - July 1995

Database Developer and Administrator Supervisor: David C. Evans

Bethesda, MD

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 followup 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:

HARDWARE SOFTWARE LANGUAGES NETWORKS

IBM PC & Oracle SQL LAN (3+Open

Compatible CASE*Method PL/SQL v1.1)

IBM 4381 Oracle SQL*Plus Lan Manager

DOS/Windows Designer/2000 Visual Basic v2.2

3.x, Workgroups, Versions 1.1, 1.2 Access Basic

95/98/NT 1.3, 2.1 xWindows

UNIX

UNIX Oracle

HP 9000 UNIX 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, 10g, 11g

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

SVN

SQR Version 3.0

dBase III and V

TOAD

HTML DB /

Application

Express 2.x, 3.0

Javascript, AJAX

CSS

ER/Studio Data

Architect 8.5

EDUCATION/CERTIFICATIONS:

Popkins System Architect & DoDaf Telelogic 2005

Oracle SQL Tuning Oracle Corp. 2002

Oracle 8i Database Architecture and Administration Oracle Corp. 2000

Oracle 8i Performance and Tuning Oracle Corp. 2000

Designer 6i New Features Oracle Corp. 2000

Oracle Discoverer Oracle Corp. 2000

Java Programming. Graduate School, USDA DC 1999

LiveLink Design and System Administration

1999

Visual Basic. Graduate School, USDA, DC 1996

Advanced MicroSoft Access Engle Training & Design Group, VA 1996

Oracle Designer/Developer 2000 -- Masters Certification MD/VA 1996

SQL Programming Graduate School, USDA DC 1994

dBase IV Fundamentals Office of Information Technology, DOE DC 1990

dBase IV Developing Applications Future Enterprises, Inc., DC 1990

Master of Fine Arts in Film. New York University, New York, NY 1986

Academy of Motion Picture Arts and Sciences Fellowship 1985

BA in English and French. University of Vermont, Burlington, VT

1980

Université de Nice, Nice, France 1979

Philips Andover Academy, Andover, Massachusetts 1976

SECURITY CLEARANCE: Active Secret

Contact this candidate