SUMMARY:

• Data Integration professional with more than 15 years designing, developing and implementing data warehouse, Master Data Management and cloud - based data integration solutions.
• Informatica certified in PowerCenter, Data Quality, and PowerExchange through version 8. Earned completion certificate for Advanced Data Modeling Design from Ralph Kimball Data Warehouse Institute.
• Extensive experience utilizing enterprise-class Integration, Business Intelligence and Relational Databases..
• Successful track record of working closely with project managers, application developers, and 3rd party vendors to deliver high-quality data warehouse and integration solutions in large-scale data processing environments.

TECHNICAL SKILLS:

Methodologies: Contributing author Informatica s Velocity methodology. Extensive experience utilizing integration best practice methods including Waterfall, AGILE development, LEAN integration and Integration Competency Centers (ICCs).

Databases: Oracle OBIEE, Oracle 10g, Oracle 9i, Teradata 10, Netezza, SQL Server, MySQL.

Tools: Salesforce.com, Apex Data Loader, Informatica Cloud Enterprise EditionPowerCenter v.8 & v.9, Informatica MDM / Siperion, Informatica Data Director 9.X, Data Quality, Change Data Capture, Business Objects, Hyperion / Brio, MicroStrategy, Erwin, PowerDesigner, Oracle Enterprise Manager, PeopleSoft, Siebel, TOAD, JIRA, Mercury Quality Center/Test Director.

Programming: SQL, PL/SQL, Unix shell scripting.

Compliance: Sarbanes Oxley (SOX), Health Insurance Portability and Accountability Act ( HIPPA), Personally identifiable information ( PII ).

Industry Standards: ASP, XML & corresponding XSDs, HTTP/HTTPS, Java, Webservices, REST/SOAP, B2C, B2E, SWIFT.

Operating Systems: UNIX, HP-UX, AIX, Linux, Solaris 8, Windows.

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential

Responsibilities:

• Responsible for designing and implementing extensible and scalable data integration solutions in a global enterprise environment using Informatica PowerCenter and Informatica Data Quality.
• Design & develop an enterprise data integration framework to promote the reuse of common ETL components to ensure conformed dimensions and data model consistency.
• Design and implement ETL solutions using PowerCenter 9.6 to extract, transform, and load data from Flat Files, XML files, and Cobol sources.
• Design, document and configure Informatica MDM Hub to support initial loading, matching, merging, and publication of MDM Customer data.
• Develop Informatica PowerCenter data and MDM standards and best practices for cross-functional resources to build, maintain and leverage corporate information assets.
• Develop detailed estimates for PowerCenter ETL projects utilizing established technology standards, labor rates, and existing enterprise software licensing agreements.
• Design solutions to resolve customer address related issues using Informatica Data Quality.
• Perform exploratory source data analysis, including ad-hoc SQL queries to proactively find and expose data quality problems and prepare for data volume and concurrent usage growth.
• Create unit test plans and support ETL code deployment through system integration and user acceptance testing.

ETL Informatica Developer & Architect

Confidential

Responsibilities:

• Collaborate with data architects and junior ETL developers to design and build a data integration solution linking MDM customer data with check-level financial transactions using Informatica PowerCenter 9.5.
• Work closely with Data Architects/Modelers, Business Analysts and Microstrategy Developers to understand and prioritize functional ETL requirements and information needs.
• Utilize new and existing data models to create source to target data mapping specifications, solution architecture and ETL detailed design documents, and Informatica PowerCenter objects.
• Provide ETL technical oversight and direction to peers, conduct code reviews, and present ETL solution designs to PMO and relevant oversight boards.
• Develop detailed project and task estimates, communicate with stakeholders and ensure relevant issues are analyzed, discussed and resolved.
• Provide consultative guidance to senior managers and technical resources to advance enterprise-wide data integration, data warehousing, data management, data quality, and ETL best practices.
• Provide technical and strategic direction for the creation and implementation of data integration solutions and standards.

Data Integration Consultant

Confidential

Responsibilities:

• Architect integration solutions using PowerCenter 9.X, PowerCenter Cloud, Salesforce and Oracle 10G.
• Design web services integrations between PeopleSoft legacy systems and Salesforce utilizing Informatica Cloud “Enterprise Edition”
• Develop data transformation rules detailing the extract, transform, and load logic for initial data loads into new Salesfore.com platform.
• Design, plan and perform data migrations from existing SQL Server 2008 database into new Salesforce.com implementation using Informatica Cloud or similar tools such as Apex Dataloader.
• Design and develop PowerCenter error handling techniques based on Informatica’s recommended Velocity best practice guidelines.

Data Integration Architect

Confidential

Responsibilities:

• Design, architect and implement data integration solution for extracting order data from Oracle E-Business Suite (EBS) and loading to new Salesforce.com environment, enabling greater sales order insight, improved forecasting capabilities, automated renewal generation, plus Salesforce quotas, reports and dashboards.
• Responsible for translating business requirements into detailed technical design specifications along with development, testing and implementation of related PowerCenter ETL integration logic.
• Create advanced mapping, transformations, and workflows using Informatica PowerCenter 8.X.
• Develop and document a thorough understanding of transactional systems business workflows, processes and events.
• Create and maintain best practice technical documentation including Report of Findings, Solution Design Documents, and Detailed Design Specifications.
• Assist in the ongoing development of technical best practices for data movement, data quality/cleansing and related ETL activities.
• Conduct code reviews to mentor junior resources as well as ensure code is based on best practices including reusability, maintainability, and scalability.

Senior Technical Consultant

Confidential

Responsibilities:

• Design, document and configure Informatica MDM Hub to support initial loading, Data Quality cleansing, matching, merging, and publication of MDM Customer data.
• Develop technical design documents, ETL mappings and workflow specifications to create enterprise-view MDM Customer hub.
• Develop Statements of Work, Design Documents, and Best Practices standards for Informatica PowerCenter, MDM, and Data Quality applications.
• Develop, configure and document PowerCenter ETL integration processes based on best practices to extract, transform, load, and cleanse Customer data.
• Perform PowerCenter, MDM and IDQ system stress-testing to improve operational scalability, test fail-over capabilities and optimize operational performance.
• Collaborate on the use of Informatica Data Director to support management of MDM Customer data by the Data Steward team.
• Perform ETL and ESP job scheduler monitoring, troubleshooting, and data analysis and provide recommendations operational improvements.
• Mentor junior staff and provide ongoing knowledge transfer, co-ordinate completed ETL roll-outs with IT Administrators.
• Participate in the data stewardship process by validating enterprise data integrity with business leaders, stewards, and analysts.
• Maintain Data lineage from source to target systems, and when necessary implement technical solutions to ensure full data confidentiality and maintain compliance with privacy laws and regulations such as HIPPA (Health Insurance Portability and Accountability Act) and PII (Personally identifiable information).

Senior Data Integration Consultant

Confidential

Responsibilities:

• PowerCenter Lead Developer & Administrator for large-scale consolidation initiative to eliminate redundant database expenses by more than $100 million.
• Interface with senior management to understand customer integration requirements and develop effective technical data integration solutions.
• Installed, developed and supported 5 tier PowerCenter 8 Linux implementation.
• Architected & implemented BI solutions using multiple Informatica products including PowerCenter 8, Data Quality, and Oracle Change Data Capture, and Goldengate
• Provided technical direction and operational supervision to team of 6 Informatica ETL developers.
• Developed mappings, workflows/sessions to consolidate Siebel and Oracle data into a consolidated database.
• Extensive experience debugging mappings to flag errors and error rows for correction and subsequent re-loaded into the target system.
• Developed and maintained client documentation and knowledgebase artifacts utilizing Sharepoint and Microsoft Source Safe.

Confidential

Responsibilities:

• Performed Baseline Architecture technical assessment of existing PowerCenter 7 & 8 and Teradata operational environment.
• Detailed environment-specific features and changes for PowerCenter upgrade 8.1 to 8.6.
• Performance-tuned Teradata Pushdown Optimization workflows, providing 50% performance improvement at runtime.
• Design and implement PowerCenter 9.0 and Salesforce.com API integration solution.

Confidential

Responsibilities:

• Installed, configured and deployed multiple Informatica 8.x platform products including PowerCenter, Metadata Manager, and Data Analyzer.
• Installed and deployed Essbase adapters for Informatica Metadata Exchange.
• Designed and developed successful 32 to 64 bit PowerCenter migration strategy.

Confidential

Responsibilities:

• Installed and configured PowerCenter development and production server on AIX and Windows.
• Established migration strategies across development, test and production environments.
• Designed and implemented enterprise-wide metadata strategy.
• Educated clients on best practices for PowerCenter development utilizing “Velocity” methodology.

Confidential

Responsibilities:

• Designed and delivered foundational “fact” and “dimension” models to lead off initial data warehousing implementation.
• Installed, configured, and upgraded PowerCenter 8 server on AIX.
• Created operational backup strategy for production logs and file system artifacts using scripting and scheduling.

Confidential

Responsibilities:

• Orchestrated multiple successful PowerCenter upgrades including: PowerCenter versions 5 to 6, 6 to 7, and 7 to 8 and 8 to 9.
• Provided technical guidance on PowerCenter new features and enhancements including versioning, data profiling, and data cleansing.
• Developed Administrative security procedures and best practice guidelines.

Confidential

Integration Manager

Responsibilities:

• Provided strategic direction, technical assistance, and knowledge transfer supervising team of up to 13 ETL developers.
• Championed successful data integration solutions resulting in $10M+ in organizational benefits.
• Architected integration solutions for real-time master data management (MDM) “Customer” hub.
• Designed dimensional and operational data modeling solutions to support strategic Service Oriented Architecture (SOA).
• Led demographic data cleansing engagement leveraging Informatica Data Explorer (IDE).

Confidential

ETL / Integration Developer

Responsibilities:

• Re-engineered ETL processes to accommodate Oracle database, business rule, SOX requirements and other regulatory changes.
• Profiled and published data accuracy scores to measure data quality and integrity.
• Established metadata management best practices and standards.