SUMMARY:

As a consultant with over 12 years of consulting and pre - sales experience, the multitude of my expertise includes data warehouse design, (MDM) master data management, data replication, data warehouse implementation, software demo’s and POC’s, consulting best practices and methodologies. Completion of full cycle implementations leveraging Informatica products to design and implement complex data integration solutions. Providing in depth technical expertise on various product offerings throughout the sales cycle and continually afterwards.

TECHNICAL SKILLS:

• Informatica PowerCenter (6.x-10.x) High Availability/Grid
• Informatica/Siperion Master Data Management (MDM)
• Informatica Data Quality (IDQ)
• PowerExchange for Mainframe DB2, UDB, IMS
• Netezza, Teradata, Change Data Capture, SAP, Oracle, SQL Server
• Informatica Data Director
• Linux/UNIX Scripting
• Confidential Replicate
• Confidential Compose
• Hadoop

PROFESSIONAL IT EXPERIENCE:

TECHNICAL MDM ARCHITECT

Confidential, Anaheim, CA

Responsibilities:

• Provided consulting services to support the Provider Master data initiative
• Provided leadership for a major MDM effort to master healthcare provider data from 20+ credentialing and EMR systems
• Designed and built the end-to-end processes which cleansed and standardized the data for the Provider Master hub using Informatica MDM, IDQ, and PowerCenter
• Implemented enhancements to the MDM rules, data model, cleanse functions, and mappings as needed to improve match results and performance
• Collaborated with different teams within the organization to advise and provide support on Master Data Management concepts and protocols
• Functioned as an MDM Administrator managing code and configuration deployments for several environments as part of the release management cycle
• Upgraded Informatica MDM from version 9.7.1 to 10.1 running on JBoss 6.1, SQL Server 2012 and Windows Server 2008
• Upgraded IDD task workflow engine from deprecated Siperion to ActiveVOS
• Implemented best practices and provided documentation to ensure long term sustainability and reliability of the MDM application

SENIOR SOLUTIONS ENGINEER

Confidential

Responsibilities:

• Executed product demo’s and POC’s to demonstrate key customer use cases
• Presented at trade shows, seminars, and trained internally to improve technical sales demo’s
• Liaison with Product Managers to provide feedback from clients about product requirements to help innovate and improve the products
• Gathered customer implementation requirements to ensure proper delivery and deployment plans in partnership with internal professional services team.

INFORMATICA CONSULTANT

Confidential, Irvine, CA

Responsibilities:

• Subcontracted through Informatica and assigned as an ETL lead to oversee and tackle complex data integration challenges using PowerCenter.
• Used PowerCenter to maintain existing Data Marts including enhancements, bug fixes and production support
• Responsible for building new Informatica Code to support downstream systems from existing Data Marts
• Peer reviewed and enforced development best practices and standards
• Responsible for redesigning existing customer dimension data model and ETL interfaces for improved performance and sustainability

INFORMATICA LEAD CONSULTANT

Confidential, Brea, CA

Responsibilities:

• Functioned as an ETL lead overseeing solutions to complex DI challenges using PowerCenter.
• Used PowerCenter to extract, transform, and load XML data from an external rating engine into the EDW
• Lead ETL development for extracting quote data from a new source system into the EDW
• Designed and built Informatica interfaces to extract private passenger auto data from the new Guidewire source system
• Designed a solution to convert existing weekly loads into daily incremental loads drastically improving performance, SLA windows, and EDW data latency

INFORMATICA DATA QUALITY/MDM CONSULTANT

Confidential, San Diego, CA

Responsibilities:

• Implement a MDM solution, which involved mastering physician customer data from a new CRM source using Informatica Data Quality and PowerCenter.
• Upgraded existing Informatica (IDQ) environments from 9.0.1 to 9.1 as well as completed in-depth regression testing of impacted elements using Informatica (DVO) data validation option.
• Configured Informatica IDQ and PowerCenter mappings to standardize, cleanse, match, and merge physician data for a Party Master Data Management project.
• Leveraged DVO to create test plans for regression testing of upgraded environment

PROFESSIONAL SERVICES SENIOR CONSULTANT

Confidential, Irvine, CA

Responsibilities:

• Acted as a trusted advisor to clients on behalf of a software vendor providing expertise in Informatica Products.
• Demonstrated expertise with Informatica products ranging from PowerCenter, MDM, IDQ, PWX.
• Performed Informatica Upgrades for clients who were still using 7.x or 8.x to Informatica 9.x.
• Completed Baseline Architectures (BLA’s) and installations of Informatica 9.x for new customers, configuring their environments according to Informatica best practices as well as showing them the features and functionality of the Informatica Products.
• Designed and built complex data cleanse functions using IDQ and Informatica Analyst tools.
• Functioned as a MDM hub configuration specialist, responsible for designing and leading MDM development, configuring/deploying MDM and EIM system functionality, instantiate MDM environment, create Landing and Staging Tables, create Match Rules.
• Managed a team of Informatica consultants emphasizing team cohesion and communication with the client’s staff to ensure the success of project deliverables at various clients.
• Conducted assessments and audits to measure effectiveness and potential improvements for clients including data modeling, performance, architecture, maintenance, and security.

INFORMATICA CONSULTANT

Confidential, Brea, CA

Responsibilities:

• Lead initiative to restructure existing Informatica repository based on standards outlined in Informatica's Velocity Methodology best practices.
• Common challenges faced during this restructure were the incorrect use of shortcuts, folder structures, and code deployment techniques.
• Played a major role in building a new process of integrating codes and descriptions from various OLTP systems into the EDW.