SUMMARY:

Confidential has been working in the Data Management space for 20+ years and has held positions as a Practice Manager, Managing Consultant and has extensive experience as an ETL/ Data Warehouse Architect, Project Lead, Data Analyst, and Developer with over 16 years of experience. He has technical expertise in Informatica (Standard and Advanced Editions, Versions 4.X, 5.X, 6.X, 7.X, 8.X, 9.X, 10.X) including PowerExchange (CDC, VSAM, DB2, and WebSphere MQ), Data Explorer, Data Quality, Data Security, Test Data Management (TDM) and B2B Data Exchange. Confidential also has experience with other ETL tools such as DataStage, Pentaho, SSIS and Talend. In addition, Confidential has experience with various relational databases and cloud database solutions (Snowflake, PostgreSQL, Azure, Redhat, AWS), SQL, UNIX shell scripting, metadata, and several scheduling applications. Recent projects have been in lead roles, providing ETL architecture solutions at the Enterprise level while building and maintaining relationships at several Fortune 500 companies with senior leadership.

SKILLS& EXPERIENCE SUMMARY:

• Practice Manager
• Data Warehousing
• Business Intelligence
• SQL and PL/SQL
• UNIX Shell scripting
• Informatica PowerCenter
• Informatica ILM Test Data Management
• Data Quality
• Metadata Management

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Architect/ETL Lead/Snowflake DBA

Responsibilities:

• Completed POC and initial setup and implementation of Snowflake Data Warehouse on Azure
• Built a Structured Data Lake with data sourced from SalesForce, Oracle, Azure, SQL Server and BaanIV ERP
• Configured Informatica Cloud and Matillion jobs to move data to Snowflake
• Maintain current data warehouse jobs loading to Azure SQL Database and migrating these jobs to load Snowflake as needed for eventual elimination of Azure in the environment

Confidential

Informatica Architect/ETL Lead

Responsibilities:

• Implemented Data Subsetting for 15+ applications as well as Test Data Generation and Test Data Warehouse capabilities for the Confidential team at Confidential .
• Performed the assessment for impact of upgrading to 10.2 R1.
• Performed the pilot of using the Self Service Portal in 10.2 R1.
• Provided mentoring for the Confidential team on a daily basis.

Confidential

Informatica Architect/ETL Lead

Responsibilities:

• Wrote the Test Data Management Strategy for the enterprise working in conjunction with the Enterprise Architecture and Security teams.
• Worked alongside Security Team Analysts to finalize masking requirements per field for each of these applications applying best practices.
• Created data masking rules based on the established requirements alongside the client technical lead for continuous knowledge transfer of Informatica ILM Workbench execution and best practices.
• Successfully masked 4 billion rows of data with PHI information for use by all development teams.
• Successfully subset Medica s largest Data mart to a single Golden Copy and reduced required capacity by 6TB.
• Installed and configured Data Integration Hub 10.2
• Developed Topics, publications and subscriptions in Data Integration Hub 10.2
• Configured Informatica B2B Data Transformation for HIPPA on the cloud.

Confidential

ILM Consultant/Architect and ETL Lead

Responsibilities:

• Assisted Confidential with the initial implementation of HP ILM software for the purpose of enforcing data retention policies for both structured and unstructured data.
• Installed and configured HP Structured data repositories on PostgreSQL database.
• Developed archive processes from mainframe and relational databases to PostgreSQL.

Confidential, Houston

ETL Architect/Lead

Responsibilities:

• Was responsible for the architecture and development of a real time process to pull sales data from the point of sale application using PowerExchange for Microsoft SQLServer and PowerCenter to both a local database as well as Aurora and Azure.
• This data was then loaded to a data mart using Informatica Cloud to create a reporting dashboard used by District Managers to C Level Executives.

Confidential, Minneapolis

Practice Manager Data Integration and Data Security, Managing Consultant

Responsibilities:

• Confidential is also responsible for scoping and pricing projects, handling pre - sales calls and meetings as well as overall client management.
• Confidential also assists significantly with Business Development in Minneapolis across all Data Management verticals (Data Integration, Data Security, Data Quality and Master Data Management)

Confidential

Principal Architecture/Development Lead

Responsibilities:

• Performed a review of their existing PowerExchange architecture to determine why the server was constantly using 100% of memory and causing all jobs to essentially lock
• Delivered a Health Check document that included the steps in order Confidential could take to fix the issues
• After being asked to be extended, I implemented step one and reduced the CPU utilization from 100% to 3%
• Upgraded Confidential from PowerExchange using LogMiner to Oracle CDC Express
• Delivered an Informatica Core Team document outlining how the central Informatica team should be positioned including Administration, Technical Architecture Oversight, Internal Customer Engagement and first level Production Support

Confidential

Principal Architecture/Development Lead

Responsibilities:

• Installed and configured PowerExchange CDC Oracle Express in two environments
• Proposed and implemented the architecture for their latency requirements
• Created an architecture plan for all PowerCenter, ILM, IDQ, Proactive Monitoring, Data Validation Option and PowerExchange for all environments
• Created a Real Time Data Flow document and diagrams for Confidential s latency requirements

Confidential

Principal ILM Architect/Development Lead

Responsibilities:

• Installed and configured Informatica Test Data Management (Persistent Data Masking and Data Subset) 9.5
• Worked alongside QA team, DBA team and the application development team to identify use cases for data subsetting
• Created multiple entities across seven applications with different subset criteria to supply six development teams and the QA team with production quality test data on demand
• Test data refreshes to lower environments was reduced from multiple days to as low as one hour
• All work was done alongside the client technical lead with continuous knowledge transfer of ILM Workbench execution and best practices

Confidential

Senior ILM Lead

Responsibilities:

• Assisted a newly formed Test Data Management team in the creation of a policy and data domains for the first twelve applications identified as top priority.
• Worked alongside Security Team Analysts to finalize masking requirements per field for each of these applications applying best practices.
• Created data masking rules based on the established requirements alongside the client technical lead for continuous knowledge transfer of Informatica ILM Workbench execution and best practices.
• Created plans and generated workflows to mask data both in - stream and in-place.
• Sourced data from Oracle, MS SQLServer, Flat Files, and DB2

Confidential

Senior ILM Lead

Responsibilities:

• Installed and configured Test Data Management (Persistent Data Masking and Data Subset) 9.5
• Created policies for masking PII data to be used by application testing teams
• Created rules to mask PII data using best practices
• Created the plan and generated workflow for masking data in - stream to lower environments
• All work was done alongside the client technical lead with continuous knowledge transfer of ILM Workbench execution and best practices

Confidential

Informatica ETL Lead

Responsibilities:

• Installed and configured Informatica Test Data Management (Persistent Data Masking and Data Subset) 9.5
• Installed and configured Informatica Data Explorer (IDE) 9.5
• Installed and configured PowerCenter 9.5
• Created policies for masking PII data
• Created rules to mask PII data using best practices
• Created the plan and generated workflow for masking data in - stream to lower environments
• Profiled data in PeopleSoft HR application to identify sensitive data
• All work was done alongside the client technical lead with continuous knowledge transfer of ILM Workbench execution and best practices
• Gave training session to business analysts at client on the use of the Informatica Analyst 9.5 tool

Confidential

Informatica Architect/Development Lead

Responsibilities:

• Preformed extensive data analysis on service order data in order to derive ETL requirements
• Service order data shows what customers added, dropped or changed on a daily basis
• Based on analysis and execution of requirements, service order data matching improved from 67% to 99.2%.
• This resulted in significant ROI to senior level executives on day to day changes at an enterprise level.