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. Past projects include: Federal Civilian & DHS, DOD, Treasury and Fortune 500 clients. Active SECRET Clearance.
10/2015 to Current
Senior Oracle DBA Data ArchitectTPG, Inc
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 incorporate 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.
04/2014 to 10/2015
Senior Oracle DBA, Data ArchitectHighlight Technologies, Inc
Developed enterprise data models at all levels (conceptual, logical & physical).
Provided oversight and mentoring to architecture and database teams to promote best practices.
Designs include 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.
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.
12/2013 to 04/2014
Senior Oracle DBA, Data ArchitectData Solutions & Technology, Inc
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 Highlight technologies for the large data architecture project.
07/2013 to 09/2013
Senior Oracle DBA, Data ArchitectCervello Technologies, Inc
Accepted this short-term project to complete the first phase of a multi-phase Joint Interoperability Test Command (JITC) project requiring travel to Fort Huachuca, AZ, Tampa, FL.
CENTCOM), Indian Head, MD and other sites.
Responsible for designing architectures for Oracle Database and Business Intelligence (OBIEE) solutions as well as designing new data models to incorporate 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.
05/2011 to 06/2013
Senior Oracle DBA, Data ArchitectAstor & Sanders, Inc
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.
01/2009 to 05/2011
Senior Oracle Consultant and ArchitectDeloitte Consulting － Fort Wayne Greensboro, IN NC.
Senior Consultant originally hired by BearingPoint's federal practice and acquired by Deloitte Consulting.
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.
Clients included federal DOD and civilian agencies including DISA, Defense Health Information Management System (DHIMS), Pension Benefit Guaranty Corporation (PBGC) and the State of California's DMV.
Commercial clients included Lincoln Financial Group.
03/2008 to 01/2009
Senior Oracle Consultant and ArchitectBlackstone Technology Group Inc
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.
04/2003 to 03/2008
Development DBA and Data ArchitectCIBER, Inc Lead Oracle DBA
Senior Oracle DBA for a task order at US Courts.
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.
04/2003 to 06/2005
DBA and lead Data ArchitectAxiom Corp; Wolters Kluwer; Lincoln Financial － Phoenix, AZ.
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 warehouse architects.
Required working closely with Business Analysts, Java developers, ETL programmers, other team leads and customer representatives.
Also requires rapid turnaround of new data models, presentation to internal teams and implementation.
Provided DBA support for customer database environments including E-Business Suite R11.
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.
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.
Lead Oracle Consultant for the migration of a large data warehouse from Microsoft SQL Server to Oracle for the Postal Service's International Business Unit.
Providing step-by-step direction and strategy for the migration effort, plus expertise utilizing Oracle's Migration Workbench.
Also providing development and programming support for Microsoft DTS packages & stored procedures involving a large number of SQL Server databases and production applications.
Project involved T-SQL to PL/SQL conversions and re-writes.
Support for multiple Business Intelligence platforms including Business Objects, OBIEE, MicroStrategy and COGNOS.
Senior DBA and Data Architect on a RAD project for DOL including: data modeling, stored procedures and database implementation.
Oracle Development Team Lead for a large web application development project.
Tasks included Requirements Analysis - especially with respect to data model impact, Data Modeling, and DBA support for multiple database instances (development, testing and production).
Activities also included PL/SQL development, database and SQL tuning and database migration.
Presented data models and design strategies to senior management and customers.
Project covered multiple phases of e-commerce and web application development for a large federal agency.
06/2001 to 04/2003
providing senior Oracle DBA and development team lead on Oracle web-based development projects involving Oracle9iAS, 8i and 9i Databases.
DBA knowledge transfer and mentoring activities including backup/recovery, security and auditing, database configuration and tuning.
Provide proactive recommendations and direction for multiple database development projects and systems.
Requires good communication skills.
10/2000 to 05/2001
Principal ConsultantOracle Corporation
Raytheon, USAF, DFAS, Unisys, IRS.
Principal consultant at client site for a data-modeling project from conceptuality to physical model diagramming using Oracle's Designer 6i.
Performed DBA duties including creating additional instances, backup/recovery, PL/SQL, C++ and AWK programming, database and PL/SQL performance tuning.
05/1998 to 10/2000
Principal consultantCHM, Inc
at a client site, leading a team of consultants for a data warehouse-modeling project using Oracle's Designer 6i.
Included DBA tasks for Oracle 8i database, with performance tuning, Oracle Parallel Server (OPS), ad/hoc on-site DBA training, as well as Oracle Forms and Reports Development, Discoverer 3i and PeopleSoft integration.
Lead DBA and consultant at client site to Oracle8i administration and tuning, perform knowledge transfer and mentoring in Oracle8i DBA, Developer 6i, and Discoverer 3i.
Developed additional reports for the web.
Lead consultant at client site to install and configure Oracle 9iAS on NT4.0 with Discoverer 3i and PeopleSoft integration, Forms and Reports application servers, Oracle Portal and Apache Server.
Lead consultant at client site for a Designer6i data modeling project, including Discoverer 3i installation, configuration and development, and Oracle Forms 6i development.
Senior Oracle DBA and consultant for a DoD/IG client to provide lead DBA for multiple Oracle client/server and Web-based applications.
DBA activities included PL/SQL development, performance tuning, installing Oracle Parallel Server, database replication, and scaling architecture for high-availability databases.
Projects included Oracle Discoverer Implementation and Training, reports development and Discoverer client-app development, data modeling, database design, application development, web-based Oracle applications and lead DBA.
Platforms included Oracle 7.3, Oracle8 and Oracle8i for NT Server, Oracle8 for HP-UNIX, Designer2.1, and Developer2.1 for Windows NT.
11/1997 to 05/1998
Soza & Company
Technical Project Manager on the VA/HHS Image World contract to develop a web-enabled imaging and database application built around SQL-Server and Visual Basic.
Successfully completed the Analysis and Design Phase utilizing Oracle's Designer/2000 CASE tools.
Responsible for Functional Requirements Document, Logical Data Modeling and General Systems Design Document.
Conducted JAD style workshops with client representatives and team members.
Application integrates credential information for 170 VA hospital sites nationwide, including document management, workflow, imaging and OCR/ICR.
11/1997 to 11/1998
Senior Oracle DeveloperIndus Corporation
Contracted with Indus Corporation to provide senior Oracle database design and development on two high profile projects.
Senior Oracle consultant for a small team of Oracle developers involving large Oracle Designer, Forms and Reports applications including forms development, database design, Reports Development, data migration, PL/SQL development and Oracle DBA consulting working evening and weekend hours.
Successfully completed project and delivered to client.
10/1996 to 11/1997
Triad Management Systems, Inc
Lead Oracle DBA and Oracle CASE tools expert for a DOL client whose client/server development project required a large team of developers.
Lead such tasks as data modeling, database design, Designer/2000 design and Oracle Forms and Reports Development.
Provided lead for large user-workshops held throughout the development project.
System built around Oracle Server 7.3 for Sun Solaris and Oracle Server 7.3 for Windows NT with Windows 95 clients.
Principle in developing the Project Management Plan.
System incorporated data from an Informix conversion.
03/1996 to 10/1996
Joint Chiefs of StaffTriad Management Systems, Inc Houston Associates, Inc
Contracted to Houston Associates to provide Oracle expertise for a broad database development project supporting network management applications.
Provided requirements analysis, data modeling, database design, Oracle Forms development, Oracle DBA and PeopleSoft integration and data mapping.
Responsible for developing the Project Management Plan.
This enterprise-wide system supported several large-scale networks, DISN-LES, the world's largest ATM-backbone network and the Defense Simulation Internet (DSI).
10/1993 to 03/1996
TAC Engineering and Programming, Inc USPS Engineering
Lead Oracle DBA and Oracle Forms Developer for this Joint Application Development project at the U.S.
Postal Service's Engineering Dept.
System comprised of a central database with nationally deployed clients built around Microsoft's SQL-Server and Oracle database engines for Windows NT and Novell NetWare platforms.
Assigned lead in Project Management and incorporated full life-cycle development methodologies.
Project involved data mapping and migration.
Requirement analysis and design completed using Oracle's CASE tool Designer/2000 and System Architect.
Front-end application development via Oracle Forms and Visual Basic.
Also involved in the migration of data from 450 sites around the country to the central data warehouse.
Responsible for day-to-day NT Administration and Oracle DBA tasks.
10/1990 to 10/1993
Secretary Senior Systems Analyst and programmerComPro Systems, Inc
on a RDBMS development project for the Assistant Secretary of the Army, on site at the Pentagon.
Designed databases to integrate data from DOS-based systems worldwide.
Application development included scanning and OCR functionality.
Provided full life-cycle development methodologies including requirements analysis, data modeling, design, development, testing, implementation and support.
Projects included rewrites in CA-Clipper, Oracle database development on multiple platforms and data migration from mainframe to PC-based servers.
High visibility environment required excellent oral, presentation and written communication skills.
Secret clearance required.
08/1987 to 10/1990
IT ManagerThe Viguerie Companies, Inc
Promoted to IT Manager from Accounting Department Manager after successfully implementing a PC-based accounting system and conversion from a manual accounting system for this multi-company organization emerging from a period of financial difficulty.
Experience included general ledger accounting and financial reports.
05/1977 to 08/1987
Finance OfficerCentral Intelligence Agency
Assigned to a wide variety of offices in support of budget and accounting within the CIA including the design and development of financial databases and reporting from mainframe computer systems.
Received regular promotions.
Education and Training
BS Degree: Information Systems, Public AccountingBenjamin Franklin UniversityInformation Systems, Public Accounting Completed 100 hours