PROFESSIONAL SUMMARY:

• Experienced professional with over 15 years in the IT industry focusing on Data Warehousing, Migrations, and Integrations utilizing industry leading technologies such as Informatica Power Center, Teradata, Netezza, Oracle Exadata, Oracle, SQL Server, SQL, ANSI - SQL, PL/SQL, ETL/ELT, data modeling, and UNIX/Linux shell scripting.
• Most of this time has been as a consultant at various companies with databases ranging in sizes up to over 150 Terabytes.
• My ability to leverage on and off-shore resources, work independently or as a member of a team, and as a lead has enabled me to bring added benefits to the projects I have been on.
• This has resulted in the completion of these projects by finishing tasks assigned in a timely manner and by mentoring coworkers and client workers on the technologies that I use.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, Shell Scripting, MLoad/Bteq, ASP.Net, VB.Net, HTML/xHTML, JavaScript, C++, SQR

Development Environments: Informatica PowerCenter (5.x - 9.x), Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), Visual Studio, Oracle, SQL Server, ERWin, Control-M, TIDAL, ActiveBatch, Informatica Power Exchange

Database Environments: Teradata, Netezza, Oracle (up to 11g), Oracle Exadata, SQL Server

Operating Systems: Windows, UNIX, AIX, Linux

SELECTED WORK EXPERIENCE:

SR Informatica Consultant

Confidential

ETL Tool: Informatica PowerCenter 9.1/9.6

Database: Netezza, Oracle, MS SQL

Responsibilities:

• Helped put the Confidential project back on track after DaVita dismissed previous consulting company
• Helped architect and implement design approach to enable the timely conversion of 500+ manual reports into automated Informatica ETL processes
• Assigned to various groups to be the Informatica SME for the groups project
• Developed a reusable process for reading in all X12 835s that could also be used to develop additional X12 feeds using Informatica s Data Transformation Studio
• Assisted in review and improvement of ETL Architecture Framework, to include creating a new logging process that mines the Informatica Repository for immediate logging of workflows and parameters
• Part of the CWOW (Clinic Without Walls) initiative to deliver a more patient centric experience when patients interact with DaVita.
• Responsible for the creation of new Confidential ETL processes, performance tuning of process (including Informatica s PDO), and maintenance of existing and new workflows, unix and SQL scripts, and other project related objects

ETL Tool: Informatica PowerCenter 9.5.1

Database: Netezza, Exadata

Sr Informatica Consultant

Confidential

Responsibilities:

• Brought in to assess and realign the Enterprise Analytic s Informatica Data Integration team to best standards by identifying gaps in their current SDLC process
• Assisted in the development of a new estimation worksheet to be used for estimating data integration projects
• Defined and developed a testing protocol for handling developers Unit Testing
• Developed and Implemented an Audit, Balance, and Control methodology for all processes produced by the DI team

ETL Tool: Informatica PowerCenter 9.5.1

Database: Teradata, SQL Server

Sr Informatica Consultant

Confidential

Responsibilities:

• Architected the No Wait Emergency Department project design approach
• Architected and designed new tables needed for Confidential project
• Developed all Informatica processes to handle the movement and loading of data from Meditech NPRs to staging (CDM STG), data mart (CDM) and warehouse (CDW) environments in order to report Emergency Department operating metrics

SR Informatica Consultant

Confidential

ETL Tool: Informatica PowerCenter 9.5.1

Database: Oracle, SQL Server

Responsibilities:

• Brought on to help implement changes required for ICD10 standardization
• Re-architected a Lawson Purchase Order process within Informatica; decreased runtime 300%
• Re-architected entire Lawson warehouse pull to allow for incremental loads and to trim all incoming CHAR fields
• Helped ETL team catch up on backlog of projects

SR Informatica Consultant

Confidential

ETL Tool: Informatica PowerCenter 9.1

Database: Oracle Exadata

Responsibilities:

• Short term assignment to assist the production team in while they sunset their Informatica environment
• Investigated and fixed several workflows that were dropping records from the fact loads
• Assisted in maintenance of system and responded to issues as needed

Lead CDI Engineer

Confidential

ETL Tool: Informatica PowerCenter 9.1

Database: Oracle Exadata

Responsibilities:

• Architected the Confidential - Net Insights enhancement project which required modeling several dimensions as well as the ETL solution that allowed the reporting of customers by marketing campaign as well as differentiating between Paid, Local, and Organic searches
• Architect for the Confidential Campaigns project that managed the reporting and tracking of customer via email subscriptions to divisional newsletters as well adding the capability of suppressing email based on business rules or on customer request
• Assisted as needed, developed processes, and oversaw the migration of the Confidential reporting database to new reporting tables
• Architect responsible for designing the process to load the reportable EasySet for use with the Unica tool which enabled the reporting of key mobile phone metrics
• Architected, Designed, and Developed technical specifications for developers both on shore and off shore
• Created new document standards for use within the engineering department. Documents include Source to Target Mapping, Technical Design Document, Developer Unit Test Plan, and a Process Flow Diagram template for Informatica Workflows
• Re-architected a long running process that took close to 2 days to complete to now run around 3 hours
• Re-architected a current batch feed process to run via an API feed in a more real-time scenario
• Architected a PL/SQL solution to handle the creation of dynamic scanlines and check digit validations for the Non-Profit Group that utilizes tables and views modeled to increase performance
• Responsible for documenting the technical design including the source to target specifications
• Mentored business, users as well as team members, as needed on how to use Informatica

Sr. Informatica Consultant

Confidential

ETL Tool: Informatica PowerCenter 8.6.1

Database: Oracle

Responsibilities:

• Lead ETL developer for Raytheon s Product Verification project
• Architected, Designed, and Developed all mapping and external logic to integrate Product Data Management (PDM) data with the Product Verification system (PVI)
• Provided support for User Acceptance Testing
• Reviewed, tuned, and fixed bottlenecks within existing mappings that transfers PDM data to the Corporate ODS for use in the PVI
• Gathered and documented functional requirements to be implemented in the PVI project

Sr. Informatica Architect

Confidential

ETL Tool: Informatica PowerCenter 9.1/KSH

Database: Oracle/Netezza

Responsibilities:

• ETL developer responsible for converting the Strategic Segmentation interface from a flat file extract to a table based extract via the new framework for moving data from Netezza to Oracle
• Developer responsible for maintaining the Audience Measurement proof - of-concept sandbox data push on Netezza
• Lead Developer on the Audience Measurement project to track channel viewership on a per second basis
• Created the validation and load scripts to handle the loading of all flat file sources into Netezza for the Audience Measurement project
• Created a proof-of-concept test of Informatica and Netezza utilizing Informatica s Push Down Optimization (PDO) approach
• Modeled control tables needed for the POC between Informatica and Netezza
• Created operational documentation for all projects including installation and support documents

ETL Tool: Informatica PowerCenter 8.6.1

Database: Oracle/Netezza

Senior Level Informatica Architect/Developer

Confidential

Responsibilities:

• ETL Architect and lead of team tasked with developing the ETL solution to capture clickstream data from Confidential s Site Activity logs and Call Tracking data
• Managed a remote team of developers to a successful implementation of the Project s goals within the allotted window
• Developed shell script to look for, move, and prepare Call Tracking source files as well as other small scripts for testing
• Fully documented ETL Architecture using the standards created by Confidential

ETL Tool: Informatica PowerCenter 8.6.1

Database: Oracle/Teradata/DatAllegro

Senior Level Informatica Architect/Developer

Confidential

Responsibilities:

• ETL Architect for Finance/Marketing campaign to capture Click data from all Confidential owned websites
• Lead several international teams of Informatica developers
• Created the standard for calling Teradata Macros from within Informatica
• Developed reusable mapping template that handles 95% of Package development via Informatica
• Developed mappings to pull form Oracle utilizing GoldenGate s CDC capabilities
• Responsible for creating all necessary Control - M interfaces to run processes within projects assigned to
• Lead a team of four developers, both stateside and in India, that developed 15 mappings which processed over 72GB of data daily
• Fully documented ETL Architecture using the standards created by Dell
• Developed Dell s standard process routines for handling extremely large datasets
• First team to production with zero defects
• Data Modeler responsible for modeling the tables for the Confidential project

ETL Tool: Informatica PowerCenter 8.5

Database: Oracle/SQL Server

Senior Level Informatica Developer

Confidential

Responsibilities:

• Completed both IDQ and IDE training through Informatica s e - learning portal.
• Attended Informatica s Professional Services advance training on IDE and IDQ.
• Completed a Data Quality Assessment for a large credit card processing unit that included doing Analysis, Cleansing, and Matching of the data set

ETL Tool: Informatica PowerCenter 7.6

Database: Oracle

Senior Level Architect/Developer

Confidential

Responsibilities:

• Lead ETL Developer/Architect for Phase I Implementation of a Consumer Complaints Data Warehouse
• Designed and Developed ETL to implement the capturing and reporting of complaints for Confidential
• Worked with the data architect to identify and build out all necessary database objects
• Provided peer - to-peer support and assistance

ETL Tool: Informatica PowerCenter

Database: Oracle

Senior Level Informatica Developer

Confidential

Responsibilities:

• Developed mappings, sessions, and workflows for large oil company
• Developed an auditing system to track field level and table level metrics during runtime
• Developed a parameter control system that allows for runtime creation and updating of parameters for Informatica
• Developed PL/SQL and Triggers as needed to complete warehousing tasks
• Provided peer - to-peer support and assistance

ETL Tool: Informatica PowerCenter

Database: Oracle/Teradata