SUMMARY:

Senior Oracle DBA/Data Architect specializing in modeling large scale, complex data architectures for OLTP and Data Warehouse/Data Mart (OLAP) Applications. Functional areas include: Healthcare, Financial among others. Technology expertise include: Oracle Database, Business Intelligence (OBIEE and Business Objects), PL/SQL Development, ETL Development and Performance Tuning. Methodologies include: Agile/Scrum/Sprint Planning & Reviews . Past projects include: Federal Civilian & DHS, DOD, Treasury and Fortune 500 clients.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA, Data Architect, ETL Developer

Responsibilities:

• Senior Oracle DBA and Data Architect on a federal Enterprise Data Warehouse (EDW) project. Provided expertise in architecture, DBA support and ETL design.
• Achievements include helping to build - up the use of Best Practices within the DBA, Data Architecture & ETL Teams, improving the communication within and amongst the teams and mentoring the Team Leads.
• Oracle DBA 11g, PL/SQL, Data Architecture, Data Warehouse (DW), MS-Visual Studio, MS-SSIS, Data Vault 2.0, Source-to-Target Mapping, Agile/Scrum/Sprint Planning & Reviews

Confidential

Senior Oracle DBA, Data Architect

Responsibilities:

• Senior Data Architect on a federal Enterprise Data Warehouse (EDW) project. Tasks include: Reverse-engineering existing legacy schemas via Erwin and producing subject-area data model diagrams and enhancing models to in corporate new requirements and audit trails
• Building-up the data architecture capabilities within the organization including best practices & CMMI areas
• Conducting reviews and walk-throughs of data model enhancements with management & stakeholders.
• Provided Oracle DBA support for DEV, TEST & Production environments including PL/SQL development.
• Administered and maintained the Enterprise Data Management tool.
• Data Architecture, Data Warehouse (DW), Relational Modeling (3NF), Master Data Management (MDM), CA-Erwin, Oracle DBA 10g-11g, Informatica, Business Intelligence Architecture, Agile/Scrum/Sprint Planning & Reviews)

Confidential

Senior Oracle DBA, Data Architect

Responsibilities:

• Developed enterprise data models at all levels (conceptual, logical & physical). Provided oversight and mentoring to architecture and database teams to promote best practices.
• Enterprise Data Warehouses (EDW) and legacy transformations. Other activities include design of Operational Data Stores (ODS), Master Data Management (MDM), gap analysis, source-to-target mapping. Collaborated with management, analysts, developers and Subject Matter Experts (SMEs) leading reviews of data models changes and enhancements designed for performance and scalability. (Specialties: Data Architecture, Data Warehouse (DWH), Relational Modeling (3NF), Master Data Management (MDM), CA-Erwin, Oracle DBA 10g-11g, Agile/Scrum/Sprint Planning & Reviews)
• Senior Oracle DBA and Data Architect on a new Data Warehouse/Business Intelligence (OBIEE) solution for CRM applications and large volumes of financial data.
• Conducted reviews of data models within the Enterprise Data Warehouse.
• Provided leadership by mentoring staff in the development and usage of data architectures solutions and problem resolution. Instrumental in developing and maintaining good customer working relationships, resulting in additional awards. Demonstrated ability to plan and meet monthly delivery objectives and maintain service levels.

Confidential

Senior Oracle DBA, Data Architect

Responsibilities:

• Hired to help win the initial contract at FDIC to support Oracle database environments and to provide support for a large inventory of development tools and customers.
• After the initial award, stayed on during project initialization providing DBA support, support for OBIEE, Informatica and other development tools.
• Assisted with the interviewing of potential candidates.
• Left after accepting an offer from Confidential for the large data architecture project.
• Data Architecture, Data Warehouse (DWH), Relational Modeling (3NF), Master Data Management (MDM), Embarcadero, SAS, CA-Erwin, Oracle DBA 10g-11g, Informatica, IBM-InfoSphere, Business Intelligence Architecture)

Confidential

Senior Oracle DBA, Data Architect

Responsibilities:

• Responsible for designing architectures for Oracle Database and Business Intelligence (OBIEE) solutions as well as designing new data models to in corporate data from DISA and JITC systems worldwide.
• Provided component architecture diagrams and data models (ERDs) to senior DISA/JITC management for Phase I deliverables.
• Due to a several month delay in funding for Phase II, accepted the offer from DST for the FDIC proposal.
• Data Architecture, Data Warehouse (DWH), Relational Modeling (3NF), SQL-Server, SSIS, Master Data Management (MDM), CA-Erwin, Oracle DBA 10g-11g, Informatica, Business Intelligence Architecture, Agile/Scrum/Sprint Planning & Reviews

Confidential

Senior Oracle DBA, Data Architect

Responsibilities:

• Lead DBA and Data Architect for a high visibility, fast-track project to re-engineer the Secretary of Labor’s National Emergency Grants system. Providing DBA support for all environments including patch installs & upgrades. Lead Architect for providing solutions from conception through implementation into production while supporting a team of ColdFusion developers.
• Also, lead architect on an Enterprise Architecture task. As part of the Data Warehouse Team, provided production support including Oracle 9i & Oracle 10g to Oracle 11i upgrades & performance tuning including the use of Oracle's AWR (STATSPACK) and ADDM reports, database initialization parameter tuning and SQL & PL/SQL tuning.
• Tuning & performance issues also included Oracle's OWB configuration, installs and repository management. Other tasks include supporting the OBIEE development team (architecture & PL/SQL) ETL development using Oracle Warehouse Builder & PL/SQL, Business Objects and metadata modeling and design.
• Data Architecture, Data Warehouse (DWH), Relational Modeling (3NF), Master Data Management (MDM), CA-Erwin, Oracle DBA 10g-11g, Informatica, Business Intelligence Architecture, Business Intelligence Development, Administration & Performance Tuning, Oracle DBA Performance Tuning, Business Objects, Oracle Warehouse Builder (OWB), Agile/Scrum/Sprint Planning & Reviews

Confidential

Senior Oracle Consultant and Architect

Responsibilities:

• Senior Consultant originally hired by BearingPoint’s federal practice and acquired by Confidential .
• Assigned to various Federal, State & commercial projects in varying roles. Primary contributions involved Oracle DBA and data architecture skills as well as direct onsite contact and interaction with client management.
• Extensive travel schedules required a high degree of organization and excellent time management.
• Data Architecture, Data Warehouse (DWH), Relational Modeling (3NF), Master Data Management (MDM), CA-Erwin, Oracle DBA, MS-SQL Server, Informatica, Business Intelligence Architecture, Embarcadero

Confidential

Senior Oracle Consultant and Architect

Responsibilities:

• Lead data architect and development DBA for a Java application development project for a large federal civilian agency.
• Responsible for reverse engineering existing data models via Designer 10g, completing enhancements per functional requirements and implementing development and test environments.
• Additional Business Intelligence (OBIEE) projects included the start-up of a BI practice within BTG’s Federal space.

Confidential

Lead Oracle DBA

Responsibilities:

• Senior Oracle DBA for a task order at Confidential .
• Responsible for installation, configuration and tuning of Oracle10g database on Red Hat Linux production servers, documenting procedures and performing knowledge transfer to existing staff. Performed multiple installs of Business Intelligence (OBIEE) client software and completed internal training for the software.
• Additional tasks included Functional and Requirements Analysis for PeopleSoft HR, Database Migration and ETL.
• Data Architecture, Data Warehouse (DWH), OLTP, Relational Modeling (3NF), CA-Erwin, Oracle DBA, MS-SQL-Server, Business Intelligence Architecture & Development, Agile/Scrum/Sprint Planning & Reviews

Development DBA and Data Architect

Confidential

Responsibilities:

• Required participation in frequent meetings with customer representatives, business analyst and subject-matter experts during the analysis phase.
• As part of the Requirements Analysis Team, helped to identify business rules and functional requirements.
• Conducted modeling session with other data warehouse architects.
• Required working closely with Business Analysts, Java developers, ETL programmers, other team leads and customer representatives.
• Also required rapid turnaround of new data models, presentation to internal teams and implementation. Provided DBA support for customer database environments including E-Business Suite R11.
• Data Architecture, Data Warehouse (DWH), OLTP, Relational Modeling (3NF), CA-Erwin, Oracle DBA, MS-SQL-Server, Business Intelligence Architecture & Development
• Lead Oracle Consultant during the project initiation phase for a Fortune 500 client - an IT outsourcing contract involving Oracle E-Business, Oracle ERP (Enterprise Resource Planning) and Financials.
• Provided direction on the migration of mainframe applications to Oracle environments as well as re-engineering Exadata 2008 v1 data and legacy reports to Oracle platforms. Conducted interviews for local Oracle sources.
• Successful project initiation resulted in contract award. Also provided assistance to an Oracle Financials project including mapping customer legacy transactions to Oracle A/R API tables.
• Data Architecture, Data Warehouse (DWH), OLTP, Relational Modeling (3NF), CA-Erwin, Oracle DBA, MS-SQL-Server, Business Intelligence Architecture & Development