SUMMARY:

• 10 years of experience in ETL & data warehouse projects (full cycle) in large - scale enterprise IT environments, with a broad knowledge of data analysis and manipulation, including partitioning techniques & star schema designs.
• 7 years of experience in Informatica PowerCenter, including development, testing and deployment. Expert in error-handling and exception handling Techniques.
• 10 years of experience in SQL & programable SQL (T-SQL & PL/SQL), including design and creation of indexes, partitioning and database tuning.
• 2 years of experience with ERP, including data extraction from the HR, Financial & Supply Chain modules.

TECHNICAL SKILLS:

• ETL Analysis, Design and Implementation
• Documenting
• Testing
• Performance management
• SME interviewing and knowledge gathering
• On-job /teaching
• Reverse Engineering
• Informatica PowerCenter
• Microsoft SSIS
• Talend
• SQL, PL/SQL, T-SQL
• Oracle, DB2, SQL Server, MySQL
• XML
• Visual Studio 2010 RDLC reports (SSRS)
• UNIX Shell Script
• C, C#, C++
• Java, Visual Basic, .NET
• UNIX
• Windows
• Mac OS X
• Linux

EXPERIENCE:

Confidential

Data Integration Developer

Responsibilities:

• Tasked with creating a Reporting DW & ETL feed from JDE E1 ERP
• Closely collaborated with the Reporting Developer to ensure accurate capture of requirements and a reporting tool-friendly DW design

Confidential

Independent Consultant

Responsibilities:

• Callback engagement, due to the successful conclusion of my previous engagements with Confidential
• Migrated and/or created 10 SSRS reports to track successful operations of their various establishments, with particular focus on hierarchical relations of focus groups and .

Confidential

Technical Architect

Responsibilities:

• Designed & built a multi-phased KPI effort to combine automated and human-reported oil well data into unified daily, monthly, life-of-well and well-to-well comparison reports of the performance of drilling operations. Project exceeded expectations and was adapted for client-facing reporting.
• Installed and configured the Informatica Data Quality servers. Managed the Informatica full installation (Dev, QA and Prod), creating users, assigning permission, resolving locks, investigating and recovering downtimes, etc.
• Interfaced with the reporting layer by working closely with the Microstrategy Development team to better understand and serve their data needs.
• Granted user-friendly access to carefully selected and designed tables to non-technical users through the Informatica Analyst tool and using PL/SQL to maintain referential integrity and control data input.
• Designed and built the KPI & Marketing Data Warehouse objects and accompanying Informatica ETLs (workflows), including a number of on-demand, real-time file readers.
• Supervised and assisted junior resources as they designed and built the Supply Chain, HSE, COS, HCM, Assets & Maintenance warehouses and accompanying Informatica ETLs, and sourced them from the Oracle OBIEE ERP.
• Performed code promotions, ensured backward compatibility of release code, scheduled and supervised jobs in Production.
• Gave User Support in Production, gathering requirements, ps and proposing solutions, following with users from initial contact to full acceptance of the products. Ensured User acceptability of the product before completion.

Confidential

Senior Consultant

Responsibilities:

• Callback engagement, due to the successful conclusion of my previous engagement with Confidential (Nov 2013)
• Migrated and/or created 7 SSRS reports to track successful operations of their various establishments, with particular focus on hierarchical relations of focus groups and .
• Upgraded 3 of the previously built reports to provide extra functionality as requested by the report consumers.

Confidential

Lead Designer

Responsibilities:

• Participated in the requirements gathering and design of a cleansing project merging five different source databases.
• Performed the data quality research by studying the data and determining the existence, severity and cleansing approaches of 30 different data issues.
• Built a PoC of a cleansing approach in SSIS with SQL, involving fuzzy grouping and fuzzy logic, allowing for human intervention through a UI when uncertainty thresholds were reached on a row-by-row basis.

Confidential

Senior Consultant

Responsibilities:

• Migrated and/or created 5 SSRS reports to track successful operations of their various establishments, with particular focus on hierarchical relations of focus groups and .

Confidential

Lead Designer

Responsibilities:

• Developed a custom Java Transformation to extract data from Google Analytics for Informatica PowerCenter to use in an internal project and to be sold in the Informatica Marketplace
• Designed and developed the ETL structure that utilizes the Google Analytics Transformation

Confidential

Senior Consultant

Responsibilities:

• Coded a PoC Sales Prediction formula that improves reliability, efficiency and accuracy of the business projection processes. Delivered a full implementation of the formula in the form of SQL Stored Procedures that provided better accuracy in less processing time than the existing corporate system.
• Took the initiative in redesigning the coupon accounting code both at BOS and above-unit to ensure consistency of formulae across all levels of reporting. Modified legacy code and built new daily sales reports.
• Altered existing ETLs to provide new functionality while improving throughput by 20% and eliminating long-standing issues.
• Updated MDM code to perform Effective Dating
• Installed and configured Informatica PowerCenter Server and Clients for internal use
• Developed PowerCenter ETL to read from BOS into DW
• Created Engagement and Utilization RDLC reports and their supporting stored procedures in SQL Server

Confidential

Lead Designer

Responsibilities:

• Created a system of T-SQL stored procedures to load MDM data in the form of XML files to an existing DB and DW, ensuring backward compatibility and future expansion. Documented and tested in conjunction with the QA team.
• Examined existing proprietary stored procedures to gauge the effort required to adapt them to the new paradigm. Created proof of concept tests and code for the proprietors to adapt the code.
• Developed PL/SQL code to extract personnel data from the JDE system and adapted a subset of the JDE tables to perform historical recording of incoming data by ensuring accurate identification of updates, inserts and deletes (which were replaced with soft-deletes)

Confidential

IT Consultant

Responsibilities:

• Supported the data mart and its accompanying C# and .NET codebase, both expansion to new markets and general maintenance. Due to poor documentation, reverse engineering was required at every level of development.
• Created an automatic warning system for missing responses for the online EDI-based system which tracked outgoing messages and listened for responses, allowing for standard deviations in the delay and informing the relevant parties when the delay was deemed excessive.
• As part of a major team effort to detect, classify and eliminate common errors in the EDI communication, was responsible for three markets, reducing the daily average number of errors by 90% by identifying the most common errors, their cause, and designing and developing the appropriate protocols to prevent them from happening.

Confidential

Lead Designer

Responsibilities:

• Designed, developed, tested and documented an SSIS ETL integrating the financial predictions of three sub-companies being migrated to a single common data warehouse.
• ETL interfaced with the databases by means of a Web Service serving daily data on command.
• Data cleaned up and combined, identifying changes and aggregating constant daily values into single multi-day entries.

Confidential

Teacher Aide

Responsibilities:

• Substituted teachers in all subjects, managing class performance and identifying struggling students for further help.
• Regularly engaged small group or individual instruction, for improvement of language abilities or behavior.

Confidential

Solution Architect

Responsibilities:

• Designed in two weeks an Informatica/Teradata solution for a process blocking the project due to its ad-hoc algorithm being described in very ambiguous terms in the available documentation coupled with communication issues caused by four layers of management between SME and developer.
• Identified all ambiguities in the description and instituted a fast prototyping protocol that ran through a battery of scenarios designed to highlight the ambiguities, with the purpose of facilitating the communication by referring to specific examples.

Confidential

Lead Designer

Responsibilities:

• Coordinated team developers to increase the scope of the system beyond original designs, ensuring that additions ran within the window of operation while maintaining standards of quality and efficiency throughout all development for ease of maintenance.
• Guided and mentored the team, both in the design and best practices. Supervised new members, until self-sufficiency was achieved, teaching Informatica and, in extreme cases, SQL.
• Supervised all promotions to UK preproduction and production systems.
• Adapted ETL to read COBOL’s EBCDIC files directly and parse XML data.
• Created, enforced and maintained the standards of coding for the project, modifying Informatica’s Best Practices with practical experience to discern between beneficial, unhelpful and outright deleterious guidelines to the efficiency of Informatica PowerCenter ETLs. The revised standards were adopted by the client and propagated to all other development teams.
• Personally recreated core batch process when expansion outstripped runtime resources, and lead undertaking to move to a dedicated server. Combined, the measures reduced core process runtime from a high of 12±2 hours to an average of 6±0.5 hours, well within the 8 hour runtime window.

Confidential

Lead Designer

Responsibilities:

• Joined stalled project due to a leadership vacuum and technical requirements beyond the ability of the assigned developers. Requested and was given ample liberty to redesign the project.
• Collected anew all project information from SMEs due to insufficient quality extant documentation.
• Singlehandedly designed and implemented solution to a 6-dimensional aggregation cube requirement with frequently changing aggregation hierarchies.
• Phase 1 delivered by the deadline, designed phase 2 while working in the DCM project.