SUMMARY:

Confidential has over 20 years of successful implementation experience as a Database Architect using Oracle products through RDBMS 11g and other databases such as MS SQL Server (2008). Confidential has extensive experience with Government, Confidential /Pharmaceutical as well as Communications, Financial/Insurance, Business/Scientific, Manufacturing, and other vertical industries. Confidential is adept at following established standards such as HIPAA, FDA 21 CFR part 11 and Sarbanes - Oxley (SOX) and all security protocols.

APPLICATION AREAS:

• Business Intelligence
• Data Warehouse
• OLTP
• Chargeback Modeling
• Confidential /Pharmaceutical
• Communications
• Financial/Insurance
• Business/Scientific
• Manufacturing

TECHNICAL SKILLS:

• UNIX / Linux / Solaris / MS Windows / Cloud - SaaS, Off Premise integration
• ORACLE RDBMS v12c, 11gR2 Ent, 10g, 9i, SQL*Plus, PL/SQL, RAC, Clusterware, Data Guard, Streams, Data Pump, RMAN, OBIEE, Hyperion, Oracle Portal, OEM, SQL*LOADER, ProC, WebDB, Packages, Triggers, Stored Procedures, E Business Suite (EBS/ERP), Peoplesoft HCM/FIN (ERP)
• SQL Server 2008 Ent, T-SQL, DTS/SSIS Packages, SSAS Cubes
• SAP / R / Q / BW / HANA
• ERwin, Informix, Access, Excel, VBA, Toad, Crystal Reports, Brio/Hyperion, OBIEE, MS Office, Tableau
• Big Data/Hadoop: HDFS, Hive, Impala

CURRENT EXPERIENCE:

Confidential

Sr DBA

Responsibilities:

• Supporting Production,l development, and test environments for SaaS Medical Data Set analytics software.
• Oracle 12g, 11c on RH Linux servers, including 2 - 4 node clustered RAC systems.
• Support of back end databases for a variety of SaaS applications.
• Full HIPAA compliance.
• Movement of analyzed and analytical data sets for custom clients using Data Pump and GoldenGate replication configuration and maintenance.
• Forensic performance tuning and optimization.
• SQL Server 2012, 2008 Performance Tuning and optimization. (

Confidential

Data Architect / Tech Lead

Responsibilities:

• Assessment, analysis, and documenting of extensive existing systems for migration of Data Warehouse to SAP HANA including design and development of new interfaces.
• Served as Technical Lead to plan and coordinate transfer of interfaces (automated integration) to SAP HANA via HANA Views. lso coordinated development with combination onshore/offshore teams (approx 12 people) as well as other established support teams.

Software and systems include: Oracle 11, Oracle 12 on MS Azure Cloud, SAP Q, SAP BW, SAP HANA, Cognos 8, Tableau 9.3.3, 10, MS SQL Server 2012 / SSIS, Informatica PowerCenter, Informatica On Demand (Cloud Based), Sales Force (CRM), Magento/MySQL, CloudCraze, Control M, Talend MDM, and proprietary applications. ( )

Confidential

BI Architect

Responsibilities:

• Assessment for review of current systems and recommendations to meet BI/DW and downstream processing for federal Regulatory Compliance reporting to meet Confidential, Treasure Regulatory Reporting specifically to fully automate the following items: Code control, notifications, approvals, Code and object promotion, and testing automation for Unit tests, PIT, Regression, and UAT including automatic artifact storage and conditional notifications.
• The goal is to eventually embrace CI/CD (Continuous Integration/Continuous Deployment).

Software and systems include: Oracle 11, Oracle Exadata, OBIEE, OFSAA, Lombard Risk Agile REPORTER, Oracle BPM, Informatica PowerCenter, ServiceNow, Microstrategy, SVN, Excel, Automic, Jenkins, Rally. (June to July 2016).

Confidential

Data Architect

Responsibilities:

• Requirements definition, documentation with Process Flow and Data Flow diagrams for a Confidential company with over 11 million customers ( Confidential, Financial, Banking, marketing campaigns).
• Data Modeling using ERwin 9.2 for OLTP and Data Warehouse systems running Oracle 11g and 10g.
• Extensive interaction with SOA (Spring JAVA), .NET, PL/SQL Web based and batch systems.
• Extensive diagnosis and analysis using Toad and SQL Developer for performance tuning of OLTP and batch processing.
• Designs include progressive partitioning strategies for automated maintenance and purging as well as query optimization.
• Full multi-team member of Agile Scrum/Kanban using Rally, and classic SDLC code implementation. OLTP systems include all customer facing Web interface, Voice Call Tree, Customer Service and mobile app and internal interfaces.
• Data Warehouse includes all staging, ODS, multi Mart and analysis layers for Microstrategy and SAS active business reporting up to 160 Confidential of data. Documentation and development of POC Hadoop system ingesting files, to HDFS, Hive, Impala

Confidential, Conshohocken, PA

Database Architect

Responsibilities:

• Full analysis, requirements gathering, data modeling, design and implementation of BI (Business Intelligence) reporting system for a Recovery Audit Confidential company.
• Project management and team direction for design and implementation of fully traceable, fully table driven ETL cleansing, transformation and delivery including re-engineering or improvements to operational system.
• Database components included ODS (Operational Data Store) including Staging area, 3rd Normal Form Data Warehouse and Dimensional /Star schemas.
• Implemented in a multi SQL Server 2008 R2, SSIS, SSAS in Windows Server environment to support complex operational system.
• Responsible for Database, Table and Index creation, data flow diagrams, source to end data element mapping and definition.

Confidential, Columbus, OH

Database Architect / DBA

Responsibilities:

• PeopleSoft Upgrade, Migration, and Maintenance for a Government agency.
• PeopleSoft EPM for HCM and Finance (9.0-9.1). Oracle 10g - 11g w/ASM, RMAN. Logical and Physical database reorg and maintenance.
• Performance Tuning specialist including re-indexing, partitioning, for Oracle Materialized Views, DataStage ETL, Cognos10 model and query optimization. 2.5 Confidential database. 2 and 3 node RAC clustered HP/UX servers. ( )

Confidential

Database Architect

Responsibilities:

• Full Requirements gathering, analysis, and definition for Confidential processing company including insurance eligibility and billing.
• Architected infrastructure and application solution.
• Developed Data Model for Enterprise level application interfacing with Confidential (Business Process Management System, Pega), Data Abstraction Layer (Informatica Data Services), SOA layers(.NET), full Enterprise Governance, and single sign-on Enterprise Security.
• Database Server specifications, Data Mapping matrix, LAN/storage specifications, ERwin 7.3, SQL Server 2008 Enterprise. ( )

Confidential, Newark, DE

Responsibilities:

• Database Administration of Oracle 8.x and 7.x systems on HPUX and Windows NT environments for 26 Oracle instances.
• Software support and administration for Pharmaceutical Confidential validated manufacturing systems (21 CFR Part 11) including Documentum ( installation, migration, validation), Beckman CALS/LIMS, Sparta Trackwise, Ingenium and others.
• Included installation and SOP authoring for installation and validation of Trackwise. Mentor of Oracle integration pieces. Software specs and evaluation.
• SOP development responsible for standardization of Oracle installations on NT and UNIX.
• Established installation, naming, and maintenance standards for the Plant. ( )

Confidential, Hatboro, PA

Customer Support Evaluation Analyst

Responsibilities:

• SQL Server 2000, 2005, 2008, (Standard, Enterprise, 32-64 bit) MS Windows Server 2000, 2003, 2008.
• Handled customer support calls related to database and Server performance.
• Provided evaluation and recommendations of software quality, Customer Support methodologies, and development standards. (Dec 2010)

Confidential, Augusta, GA

Project Manager/Developer

Responsibilities:

• Configuration, Development, testing and training of Confidential compliant Safety Incident and Audit application.
• Oracle 10g, TrackWise 6.0. Crystal Reports RAS 9.0.
• Full project management, development, configuration, and testing.
• Confidential Training module development in Power Point.
• Application promotion to Production.

Confidential, Newark, DE

Responsibilities:

• Database Administration of Oracle 8.1.7x for Cerner Millennium On-Line Patient Care system.
• Administration of multi 300+ GB databases, 24x7 support.
• Development of automated monitoring tools and modules using PL/SQL, SQL on VMS and DCL.
• Extensive performance tuning, optimization, and measurement.
• Space management.
• Long range migration planning.
• Oracle Portal analysis, configuration and maintenance.

Confidential, Southern, PA

Responsibilities:

• Implementation and historical data conversion of Departmental Data Store (Mini-Data Warehouse) application to feed PA State Trauma compliance software.
• Full Design, development, testing and implementation using ERwin, Oracle 8i, SQL*Forms 6.0, Crystal Reports 8 Developer 2000. Extensive ETL/Data migration/Data cleansing/QA algorithms developed.(DBA) Design and configuration of rule based data conversion engine for definition of Data Dictionary, MetaData and Standards repository. ( )