contract@jaffrayconsulting.com

Data Architect & Oracle DBA

CLEARANCES:

Department of Defense Secret (Active)

DEA clearances (Active), past Clearances FDA, USAID, DOJ, ATF

Expertise: More than 20 Years in Database Technology and Technical Management

• Data Architect
• Principal Oracle DBA
• Principal data modeler & data manager
• Technical manager
• Database architecture & performance tuning
• Business analysis and requirement
• Expert level skills in Oracle RDBMS, Linux, UNIX and Windows Server.
• SQL server multiples projects.
• Data migration and platform migration expertise.
• Enterprise Architect
• End user training and public speaking (seminar & conferences)

Data Architect/ DBA, DBSOLUTIONS Consulting, 10/1995 to Now

Data Architect:

Data architect for a government defense sub-contractor case execution and ERP System implementation, solution architecture, working heavily on data migration, data conversion, data quality and data cleansing issues, providing guidance on methods and high level strategy and policies.

Wrote & produced high-level data migration strategy document.

Project involves lots of data issues, continuous customer interactions, meeting with SMEs and vendors, working on Data Security and data standard, worked on Salesforce.com CRM for USAID.

Data Architect & DBA

Designed and Modeled E-commerce procurement system, worked on database design, tasks included working on requirement, design documents, data flow, business rules, data modeling, web design and supported Both Oracle and SQL Server environment, collaboration with customer and Management, Co-Lead the development team.

Created conceptual, logical and physical models, collaborated on business analysis, reviewed and completed technical requirements; convert requirements into model, reverse engineered existing systems.

Provide documentations and data dictionary, fields definitions, source to target mapping, supporting data load and data validation, creating conceptual context diagram for project teams and management, complete compare via Erwin or Toad, review SQL, triggers and other DDLs for development, creating and maintaining necessary Oracle databases for the application, worked on data load, validation and implementation of data, environment consisted of (XML, TOAD, PL/SQL, Shell, Windows Server, SQL Server 2008/R2, Oracle 11gR2,Linux, Erwin, .Net)

Data Architect & Modeler:

Created major centralized enterprise wide data warehouse Inmon 3^rd normal form style system with related data marts and BI systems for test and production, Created main and multiple logical and physical model, responsible for building the enterprise wide data warehouse and central data repository for the agency headquarter.

Working on design of related applications, databases and operational Data store.

Interacting with data owners, actors, reading and analyzing documents and requirements, creating conceptual model, working on data normalization and demoralization.

Other tasks include data mapping, generates data dictionary, physical DB objects, working on strategy for migration and data load, supporting ETL team, integration of other legacy system into new data warehouse.

Environment included Erwin, Rational Rose, Cognos, TOAD, SQL, Shell, XML, Supported BI team with fact and dimensional design issues.

Implemented data guard solutions with Oracle 10gR2 with physical standby for department of defense, switchover and failover setup, implemented Grid Control management servers.

Technical Manager:

Lead Oracle Expert to DOJ, led database system design based on industry best practices. Performed feasibility studies and then managed database synchronization, multi-master replication and Oracle streams.

Consultant to Mission Accomplishment and Regulatory Control Services (MARCS) program, FDA Office of Regulatory Affair.

Technical manager of the MARCS Integration & Design Group (a solutions analysis group that consulted on component and applications designs for a variety of MARCS initiatives at the FDA.

Technical expert, COTS product implementation support for Agency of international development USAID.

Provided database support at the Library of Congress, Oracle 9i, IBM AIX L5.2, and Win2K, database Migration from 9i to Oracle 10G.

Database Architect, Data Manager and DBA: DBSOLUTIONS Consulting, 10/1995 to 10/2004

Implementation specialist for enterprise solution ERP, Performed as Peoplesoft DBA and Peoplesoft integration specialist for Winstar Communications.

Worked as Peoplesoft & Oracle expert for Corning of New York.

Enterprise architect on Federal Enterprise Architecture Framework at Treasury Department, (ER, ERD, BP, reverse engineering), created conceptual and logical model.

DBA & Data manager, worked on Master Data Management for Citibank-Citigroup.

EDUCATION

M.S. , Computer Science