Data Project
Resume:
Rick Sheffield
Woodbridge, VA *****
***************@*******.***
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, Oracle E-Business Suite, ETL Development and Production Support & Performance Tuning. Past projects include: Federal Civilian & DHS, DOD, Treasury and Fortune 500 clients. Active SECRET Clearance.
Professional Experience
TPG, Inc. (October 2015 to Present)
Senior Oracle DBA, Data Architect
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 to support. Administered and maintained the Enterprise Data Management tool.
Highlight Technologies, Inc. (April 2014 to October 2015)
Senior Oracle DBA, Data Architect
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 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.
Data Solutions & Technology, Inc. (Dec 2013 to April 2014)
Senior Oracle DBA, Data Architect
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 handling Oracle DBA support, support for Business Objects, Informatica and interview potential candidates. Left after accepting an offer from Highlight technologies for the large data architecture project.
Cervello Technologies, Inc. (July 2013 to Sept 2013)
Senior Oracle DBA, Data Architect
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 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.
Astor & Sanders, Inc. (May 2011 to June 2013)
Senior Oracle DBA, Data Architect
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 ETL development using Oracle Warehouse Builder & PL/SQL, Business Objects and metadata modeling and design.
Deloitte Consulting (January 2009 to May 2011)
Senior Oracle Consultant and Architect
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 – Fort Wayne, IN and Greensboro, NC.
Blackstone Technology Group Inc. (March 2008 to January 2009)
Senior Oracle Consultant and Architect
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 projects required training in Business Objects and OBIEE for the purpose of starting-up a BI practice within BTG’s Federal space.
CIBER, Inc. (April 2003 to March 2008
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 Objects client software and completed internal training for the software. Additional tasks included Functional and Requirements Analysis for PeopleSoft HR, Database Migration and ETL.
Development DBA and Data Architect
Axiom Corp; Wolters Kluwer; Lincoln Financial; AMC Theaters;
DBA and lead Data Architect for a large commercial project requiring weekly travel to 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. Senior DBA and Data Architect on a RAD project for DoL including: data modeling, stored procedures and database implementation. (July 2005 to present)
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. (April 2003 - June 2005)
Independent Consultant (June 2001 to April 2003)
Independent consultant providing senior Oracle DBA and development team lead on Oracle web-based development projects involving Oracle9iAS, 8i and 9i Databases. Projects include Oracle Portal and web-based development written in PL/SQL, HTML, Java, JSP and JavaScript. 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.
Oracle Corporation (October 2000 to May 2001)
Principal Consultant
Clients: 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.
Principal consultant 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.
CHM, Inc. (May 1998 to October 2000)
Client: Department of Defense Inspector General
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 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.
Soza & Company (November 1997 to May 1998)
Client: VA/HHS
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.
Independent Senior Oracle Developer (November 1997 to November 1998)
Client: Indus 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 programming and Oracle DBA consulting working evening and weekend hours. Successfully completed project and delivered to client.
Triad Management Systems, Inc. (October 1996 to November 1997)
Client: Department of Labor
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.
Triad Management Systems, Inc. (March 1996 to October 1996)
Client: Houston Associates, Inc./Joint Chiefs of Staff
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).
TAC Engineering and Programming, Inc. (October 1993 to March 1996)
Client: 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.
ComPro Systems, Inc. (October 1990 to October 1993)
Client: Secretary of the Army
Senior Systems Analyst and programmer 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.
The Viguerie Companies, Inc. (August 1987 to October 1990)
IT Manager
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.
Central Intelligence Agency (May 1977 to August 1987)
Finance Officer
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.
SECURITY CLEARANCE
SECRET (Current)
EDUCATION
Attended Benjamin Franklin University
Majors: Information Systems, Public Accounting (Completed 100 hours towards BS Degree)
Contact this candidate