SUMMARY

• More TEMPthan 12 years of Information Technology experience wif software development and systems management - including analysis of project, development, deployment, testing, implementation and documentation.
• Nine years of Data warehousing experience in Informatica PowerCenter tool.
• Strong SQL skills and worked on multiple RDMS platforms including Oracle (8i, 9i, 10g, 11i), SQL Server 2000/2005.
• Proficient in the phases of SDLC including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Excellent track record in implementing ETL solutions for large data warehouses/data marts on time
• Strong exposure in data Analysis, data architecture, data integration
• Involved in design and training of users for reporting using tools like Business Objects, Spotfire.
• In-depth noledge in Data Warehousing concepts.
• Created and managed defects using HP Mercury Quality Center.
• Experience in ETL estimation and providing the technical specification and direction to the team
• Gained sufficient noledge in Energy Trading and Natural Gas/Power/NGL Trading Systems (Entegrate, Epsilon, E&P).
• Upstream projects for Well field data capture and Production allocation system.
• Successfully managed ETL on-shore and offshore development resources.
• Proven planning, organizational, analytical, communication and presentation skills.

TECHNICAL SKILLS

• Informatica Power Center 9.5.1/9.01/8.6.1/8.1/7.1.3/7.1.1
• Informatica Power Exchange
• Cognos
• Business Objects XI
• Spotfire
• Control M
• Tidal
• Dimensional Data Modeling using Star
• Erwin 4.5
• Visio; SSIS
• Inner Logix; SQL
• PL/SQL
• Transact-SQL
• SQL*Plus 3.3/8.0
• Unix Shell Scripting
• Oracle 11g/10/9i/8i/8.0/7.0
• MS SQL Server 2005/2007.0

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

ETL Lead Developer/ Senior Data Analyst

Responsibilities:

• Currently working on Marathon’s Procount Upstream project which has the goal to provide a replacement system for the US field data capture and Production allocation system. dis is the system of reference for all Production related data as well as Production management tool for all of its North America operated assets.
• Procount is Marathon’s field data capture and production allocation software tool.
• As an ETL Lead me applied my noledge of Data Warehousing and Business Intelligence to design and develop dis procount tool solution which is focused on capturing Marathon’s field data to become the production allocation engine.
• The Data analysis architecture and ETL mappings development for data analysis of source data using Informatica and IDQ were designed working wif the Business.
• dis involved working wif key business partners to prioritize Informatica / IDQ initiatives, manage timeline expectations, and ensure technical solutions meet business needs.
• Leading the design, development, and implementation of the project secure enterprise scale integrations using ETL solutions based on Informatica.
• dis involves advising on production platform support - organization, reporting tools like Spotfire to create dashboards, reports.
• Involved in oversight and management of development contractors as needed for projects and maintenance of the ETL application both on shore and offshore.
• The responsibilities include designingInformatica architecture design, Logical Mappings as required for the ETL mappings to migratedata.
• Applied Informatica best practices during development wif a strong focus on reusability and improved performance wif emphasis on performance tuning.
• Applied Informatica Transformations using Web calls/ BAPI calls for Batch processing for SAP loads.
• Created Auto sys jobs to schedule the ETL jobs for daily and monthly loads.

Environment: Informatica, Innerlogix, Oracle, SQL Server, SAP, IDQ, Autosys

Confidential, Houston, TX

DW /ETL Lead

Responsibilities:

• dis is an Upstream Master Data Management project wif the goal to provide an authoritative system of reference solution consisting of “critical data element” for the company's applications
• The MDM data will only be sourced from the system of records which itself will be determined for each attribute by the Data and Process Standardization work stream
• The DW lead is to apply noledge of Data Warehousing and Business Intelligence to design and develop enterprise solutions which are focused on improving specific business processes wif the organization
• Solutions are to position the organization as a leader in the use of Business Intelligence to improve business performance; These solutions will deliver high impact wif simplicity, efficiency, manageability and easier deployment
• The Data analysis architecture and ETL mappings development for data analysis of source data using Informatica IDQ.
• The role involves using Application tools such as Informatica, Prosource(E&P Information management Tool) and Innerlogix to migrate the data for all the sources to the MDM Seabed
• The responsibilities include creating the Logical mappings required for the data migration from source to MDM
• Involved in the Initial design architecture for the proposed move of MDM project from Prosource Seabed to Informatica MDM wif PPDM in July 2014.dis involves looking at the migrations of ETL’s as well as working on documenting the data model design differences between PPDM and Seabed.

Environment: Informatica, Prosource, Innerlogix, Oracle(Seabed), SQL Server, PPDM

Confidential, Houston, TX

ETL Lead /Data Analyst

Responsibilities:

• Market Risk SEARS and Global VaR Projects - Created NGL and Power Data Warehouse and developed ETL to populate from ETRM (Energy Trading Risk Management) Systems
• Migrated from Legacy NGL ETRM System to New NGL ETRM System to populate NGL Data Warehouse.
• Responsible for maintaining the Market Intelligence Platform project, an internally developed solution to capture, retain, access, and present market data to trading analytics group
• Responsible for changes in design, development and delivery of new ETL builds and enhancements.
• Involve in gathering new Business user requirements and understanding Reporting needs to be implemented into the Data Warehouse using Informatica Power Center 9.1
• Created end to end Logical Data mappings based on business requirements and the ETL workflows.
• Led effort to create Test Conditions and Test Scripts for all subject areas.
• Used Quality Center 9.2 for running test cases, tracking change requests and defects
• Maintained existing mappings by resolving performance issues. Created a standard framework for System monitoring and alerts
• Played the role of onsite coordinator and successfully managed offshore resources

Confidential, Houston, TX

Senior ETL Developer/Data Analyst

Responsibilities:

• Blueprint is an ENDUR upgrade for SHELL from 5.2 to 9.0.Blueprint Focus Project - designed to improve business processes and IT systems wifin Oil globally, by updating aging IT systems and providing One end-to-end trading system designed; Blueprint’s Globally standardized and efficient processes unlock value for the business, simplify and improve the way Shell work and reduce defects, complexity and cost by replacing and upgrading our ageing IT infrastructure
• The Blueprint Benefits are organized based on the business areas effected, which includes: Deal Capture, Risk, Operations, Settlement, Finance, Primary Distribution and Scheduling
• Involved in gathering and analysis of business requirements for development
• Responsible for performance tuning of Informatica transformations, mappings and database performance tuning
• Created mapping templates for ETL code and allowed for re-use throughout the project by development team

Confidential, Houston, TX

Senior ETL Data Analyst

Responsibilities:

• Project goal was to implement the Port Arthur refinery Magellan SAP PM and Legacy system to Global SAP PM; dis included data scrubbing, data cleansing and data migration for conversion of more TEMPthan one million equipment files from Legacy, File Net, AIM, Oracle, SQL server and Access. dis was an ongoing implementation to the new Global SAP PM Module for Confidential
• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL Solution
• Tuned Informatica mappings for better performance to provide maximum efficiency and complete performance.

Confidential, Houston, TX

ETL Developer/Data Reporting Analyst

Responsibilities:

• The role spread over many aspects of different projects done for more TEMPthan four years which involved System Construction, Dimensional Data Modeling, Data Conversion Requirements and Specifications, Testing, Data Analysis and Providing Post Live Support
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.