PROFESSIONAL SUMMARY:

• A versatile and driven data integration professional with a progressive history of planning, designing, executing, and maintaining highly technical data integration projects, models, and strategies in diverse environments.
• Develops solutions aligned with organizational and functional requirements, develops code and testing procedures, defines data quality and delivery metrics, and partners with cross - functional teams to disseminate best practices.
• Technical expertise in data integration, Informatica ETL development, and PPDM integration.
• Leads Integration Projects
• Data Integration/Data Architecture
• PPDM
• Data Warehousing
• Software Development Lifecycle (SDLC)
• ETL Principles and Best Practices | Mentors/Trains Staff
• E&P Data Model/Master Data Concepts
• Identifies/Resolves Issues
• Analyzes and Reports Progress Database Design Development
• Develops and Maintains Accurate Documentation

KEY STRENGTHS:

• Leads Integration Projects | Data Integration/Data Architecture
• PPDM
• Data Warehousing
• Software Development Lifecycle (SDLC)
• ETL Principles and Best Practices
• Mentors/Trains Staff
• E&P Data Model/Master Data Concepts
• Identifies/Resolves Issues
• Analyzes and Reports Progress Database Design Development
• Develops and Maintains Accurate Documentation

TECHNICAL SKILLS:

• Oracle 10g RAC, 9i, 8i, DB2, SQL server
• PPDM 3.7
• Informatica PowerCenter
• UNIX Shell Scripting
• PL/SQL
• T-SQL
• Oracle
• Sybase
• Data Warehousing
• Data Integration
• XML
• Process Automation
• Problem Solving
• Data Modeling
• Data Migration/Conversion

PROFESSIONAL EXPERIENCE:

Confidential

ETL / Cloud Developer

Responsibilities:

• Design/Develop a real-time interface for Confidential ’s BOM ( Confidential ) data from their EDR system to SAP utilizing the Informatica Cloud toolset.

Confidential

ETL Architect / Lead

Responsibilities:

• Led the design and development of inbound ETL for a custom developed well planning system.
• Designed and developed batch automation processing that executed ETL, Prosource load utilities and PL/SQL steps to load data - implemented failure notification and restart capabilities.

Confidential

Technical BA

Responsibilities:

• Confidential development of an Enterprise Well Header data dictionary utilizing Informatica Business Glossary.
• Confidential implementing Data Lineage using PPDM model - true end-to-end data lineage - not just ETL.
• Well Header Attribute Extension and Enhancement - Analysis of adding new attributes and identifying some obsolete attributes to be removed.
• Steered integration of production data utilizing PPDM 3.7 through numerous projects spanning several years and served as primary Informatica ETL developer.
• Designed technical solutions in line with business and functional requirements, developed and tested interfaces through SDLC, provided primary support and became SME for production well reporting integrations, performed Informatica development, sourced data from TOW, Artesia, and SAP/PRA, and ensured data integrity.
• Designed and developed extraction, transformation, and loading (ETL) processes for the production data store (PDS) system. The nightly processing window consisted of more than 150 interfaces that were charged with delivering critical production reporting across enterprise. The timing and performance of these processes was critical to meeting business SLAs and other downstream processing. Established, maintained, and adhered to ETL design principles and best practices.
• Leveraged robust knowledge of PPDM concepts and principles to architect customized “Load of the Rings” integration processing.
• Steered technical enhancement projects through lifecycle and ensured projects stayed on time and within budget. Designed, coded, and performed tests and monitored progress post-implementation and integration.
• Developed and validated ETL processes, identified requirements, and documented all ETL work.
• Provided expertise and resolved integration issues in partnership with business users, technical and system analysts, and SMEs.
• Analyzed technologies and applications to identify weaknesses and develop improvements to capacity, availability, and efficiency.
• Focused on PPDM integration subjects, including area, interest sets, production entities, production volumes, wells, and downtimes.

Confidential

Data Analyst and Database Administrator

Responsibilities:

• Established data integration practice for company using Informatica and helped champion use of Informatica within company. Created and implemented standards and processes for Informatica development for company globally and served as team lead.
• Completed projects in retail and commercial marketing, global supply chain, pipeline and terminaling systems, and pricing groups; projects often involved stringent performance requirements and complex business rule transformations.
• Leveraged UNIX shell scripting and Perl to provide event driven processing, XML formatting, and automated services, including FTP, email, backup/recovery, startup/shutdown, and source/target availability.
• Migrated mission-critical pipeline management system from Sybase to Oracle. Provided DBA support for both Sybase and Oracle, including production and development databases developed backup and disaster recovery strategies, and tuned database to resolve performance differences.
• Identified, implemented, and refined database standards to ensure data security, performance optimization, and efficient processing.
• Created and maintained logical/physical data models using ERWIN and Model Mart.
• Installed, upgraded, and administrated Informatica PowerCenter ETL environments.
• Developed ETL data interfaces to provide near real-time data from disparate data sources to pricing revenue optimization system.

Confidential

Senior Database Administrator

Responsibilities:

• Performed proactive DBA work, such as space management, database performance evaluations, index rebuilding, and schema management.
• Supported production and development databases for more than 100 client hospitals and created new processes for database-to-application bridges used in application deployments.

Confidential

Senior Sybase Database Administrator

Responsibilities:

• Evaluated, designed, produced, installed, upgraded, and maintained Sybase databases.
• Oversaw automated tasks, including space management, backups, DBCCs, and index rebuilds.
• Provided technical expertise and troubleshooting for application developers on table design and query optimization.

Confidential

Oracle Database Administrator and UNIX Systems Administrator

Responsibilities:

• Provided desktop support for more than 160 local and remote users working on PCs, X stations, and X terminals.
• Implemented network backup solution, Legato, for all corporate UNIX/NT systems.
• Performed Oracle database administration tasks, such as space management, backup and recovery, installation, migration, upgrades, and preparation for new sites, which involved LVM work, I/O analysis, and database analysis.

Confidential

Database and UNIX Systems Administrator

Responsibilities:

• Performed DBA responsibilities for Sybase 10.X environment supporting more than 220 databases on three Sybase SQL servers and for Informix 5.X and 7.X database environments.
• Assisted with UNIX administration, supporting corporate and retail locations affecting more than 120 stores.
• Held responsibility for maintaining legacy mainframe administration and designing and implementing disaster recovery policy.

Senior Computer Operator and Senior Operations Supervisor

Confidential

Responsibilities:

• Handled operations analysis and troubleshooting systems and applications problems.
• Assisted with installation and integration of new system tools, peripherals, and interfaces.
• Maintained all remote communications and system backups.