SUMMARY

• Over 10 years of experience in completing Informatica projects related to master data management, data warehousing, data integration, performance tuning, product installation and upgrades, architectural designs, and server sizing and infrastructure assessments
• Over 15 years of accumulated experiences in various industries: financial (Bank of the West and PayPal), healthcare (Sharp, St Joseph’s Health and Kaiser), Insurance (WellPoint/Anthem and Health Management Systems), retail (Disney Consumer Products and PetSmart), and pharmaceutical (Allergan and Pfizer)
• Among the few Informatica Professional Services consultant with expertise in PowerCenter, B2B Data Transformation, Informatica Analyst, Informatica Developer (Data Quality), Metadata Manager, Business Glossary, Informatica Data Validation Option, and Master Data Management
• Previously worked at Informatica as a level 3 Senior Consultant and was awarded the INFA Star award in the first year of employment in 2007 and was also recognized as the top consultant for the west region in 2012
• Highly technical combined with a strong understanding in business functionalities and processes
• Proven record of delivering critical projects and business solutions on time and under budget

TECHNICAL SKILLS

Master Data Management: MDM Hub Configurations, IDD, Business Entities, Entity 360, ActiveVOS

ETL: Informatica PowerCenter, Informatica Developer

Databases/Database Tools: SQL Server, Oracle, Teradata, Sybase, DB2, SQL Developer, Toad

Project Management Tools: Microsoft Project, JIRA, HPQC

PROFESSIONAL EXPERIENCE

Confidential, CA

MDM Solutions Architect

Environment: MDM 10.1, PowerCenter/Data Quality 10.2, Linux, JBoss 6.4, and Oracle 11.2

Responsibilities:

• Designed and constructed a multi - domain party model to accommodate for Provider, Patient, and Employee mastering
• Architected, designed, and developed ETL data integration to load source data from Cerner, Cactus/GECB, and ASPM into MDM
• Set up job control table process to initiate batch jobs, capture run-time statistics, and log all batch executions in PowerCenter, Data Quality, and MDM
• Leveraged MDM resource kit to execute MDM batch groups and commands via Linux Bash scripting
• Collaborated with business team in gathering requirements for match and merge process
• Applied standardization rules via DQ Mapplets in standardizing trust-enabled attributes (full name, gender, address, email, phone, etc)
• Configured Hierarchy Manager to showcase relationships between providers and organizations (hospitals/medical groups), patients and providers, and providers and specialties
• Configured a post process leveraging MDM’s “Load by Rowid” concept to override certain key fields (i.e. Provider Active Status or Record Effective Date and End Date)
• Worked with Data Stewards in customizing the UI layout of IDD
• Configured two-step approval process with ActiveVOS for task management in IDD
• Migrated Informatica Servers (PowerCenter, Data Quality, and MDM) off-premise which saved the company nearly half a million dollars annually
• Created a global lookup table in MDM to reduce the total number of lookup tables from 15 to 3

Bank of the West, CA

MDM Solutions Architect

Environment: MDM 10.2, PowerCenter/Data Quality 9.6, Linux, JBoss 6.4, and Oracle 12.1

Responsibilities:

• Set up and configured Business Entities, Hierarchies, Relationships, and E360 UI layouts via MDM Provisioning tool
• Configured and enabled Smart Search for E360 UI and downstream consumers leveraging Rest API payloads
• Spearheaded the initiative to convert cleanse functions and Mappings from MDM into PowerCenter which reduced the load time by 2 hours
• Met with business analysts to determine both manual and auto match rules for mastering 5 million customer records and 7 million address records
• Added MDM validation rules to degrade trusts for records with data quality issues and records with a locked status
• Worked with production support team in setting up 2 MDM Hub Servers and 3 process servers to optimize MDM performance and Apache Solr Smart Search indexing
• Worked with various LOBs in finalizing stop words for improving MDM Smart Search results and performance
• Worked with ESB and Appian downstream development teams in integrating front end applications with MDM through real-time Business Entity Services (BES)
• Implemented bulk merge, bulk unmerge, and post process to recalculate BVTs for trust enabled fields through ETL PowerCenter and MDM Resource Kit commands
• Attended daily Scrum meetings, Sprint kickoffs, and demos
• Provided weekly status reports to management and posted daily status updates onto both JIRA storyboards and HP ALM defect tracking system
• Setup MDM hierarchy relationships for individual and organization party types as well as customer data linked to accounts
• Completed MDM environment assessment and health check by analyzing existing infrastructure setup and current code development
• Created automated process to register and create custom indexes on MDM HIST, HMRG, and XREF tables through PowerCenter and SIF API

Confidential, CA

MDM Solutions Architect /Informatica Product Specialist

Environment: MDM/PowerCenter/Data Quality 10.1, SQL Server 2012, Windows Server 2012, JBoss 6.4

Responsibilities:

• Created table driven approach to initiate both ETL and MDM jobs for over 25 source systems that include Meditech, IDX, 3Won, Symplr, and MD Staff
• Customized and leveraged Informatica MDM Healthcare Solution Model to master provider, payer, and address information
• Created and constructed a custom product data model for mastering 2 supply chain applications
• Developed DQ profiles and standardization rules to analyze and clean source data
• Created reusable ETL components to load source data into prelanding and landing tables
• Moved delta detection logic from MDM into ETL to optimize performance
• Implemented MDM external match process on NPI and USDEA datasets to better enrich provider data
• Worked with production support in upgrading PowerCenter and Data Quality 9.6 to 10.1 and MDM 9.7.1 to 10.1
• Leveraged B2B Data Transformation to parse complex XML files provided by Symplr and HL7 segments for Patient information
• Implemented MDM validation rules and logic to derive a final record status/archive flag for providers and facilities
• Created hierarchical relationships for provider-to-provider, provider-to-facility, provider-to-organization, and organization-to-organization
• Responsible for IDD application rollout, which includes customizing IDD UI layouts, creating custom queries for better search results, setting up roles and permissions, configuring hierarchy diagrams, and implementing a 2-step approval process for task management
• Integrated Informatica Business Glossary with downstream applications
• Enabled Kerberos single-sign on for PowerCenter and Data Quality services
• Constructed both MDM and ETL Development Best Practice and Standards guide
• Developed DQ Mapplets leveraging address doctor to standardize address records
• Setup MDM table triggers and JMS message queues for real-time MDM integration with HIE application
• Created automated scripts to backup and restore MDM ORS databases
• Leveraged MDM external match process to analyze new source systems (i.e. Scorpion marketing data and Workday employee information) to see potential match records before bringing the entire dataset into the Hub
• Participated actively throughout all phases of the development lifecycle
• Provided knowledge transfer sessions for fellow team members and constructed user manuals for downstream users for front end applications such as IDD, DQ profiles, Metadata Manager, and Business Glossary
• Created DQ Mapplets and leveraged Java custom transformations to parse out free-form text fields that include provider specialties, subspecialties, email addresses, and phone numbers
• Assisted St Joseph’s management team in interviewing potential ETL and MDM candidates
• Coordinated with regional data stewards in fixing data quality issues in the source system and worked with the data governance team in incorporating policies and procedures in preventing data quality errors for new incoming records
• Created bulk merge process to help data stewards resolve manual match candidates
• Created bulk unmerge process to resolve inaccurate merges done in MDM

Confidential, TX

MDM Solutions Architect

Environment: MDM 9.7.1, Data Quality 9.6.1, Oracle 11g, Linux, WebLogic

Responsibilities:

• Executed readiness script to analyze and address manual data issues pertaining to the base objects, XREFs, and historical match and merge tables
• Successfully completed the upgrade process for MDM 9.0.1 to 9.7.1 HF3 running Oracle 11g, WebLogic 10.3.6, and RedHat Linux 6
• Constructed an upgrade runbook that included step-by-step instructions for fellow staff members to replicate in higher environments
• Converted all legacy MDM Stored Procedure packages into PowerCenter Web Services leveraging SIF API
• Setup and configured MDM cluster environment and multiple process servers to optimize performance
• Reviewed and optimized existing match rules/match rule sets
• Regression tested ETL Mappings, load jobs, match and merge, and IDD functionalities
• Performed rounds of stress testing to ensure all environments are not under capacity
• Replaced Trillium address validation with IDQ Mapplet leveraging AddressDoctor to reduce license and maintenance fees
• Worked with management team and Informatica Sales Rep in negotiating license deals, which resulted in in the client saving $200,000 in unnecessary license purchases and services
• Combined Java SIF API, Enterprise Java Beans, and the Spring framework to allow IBM Sterling Integrator to interface with MDM via Web services

Confidential, CA

MDM Solutions Architect

Environment: MDM 9.7.1, PowerCenter/Data Quality 9.6.1, Oracle 11g, Teradata, Linux, WebLogic

Responsibilities:

• Worked with admin team in installing, configuring, and architecting the topology for MDM 9.7.1 on Redhat Linux OS, WebLogic 10.3.6 application server, and Oracle 11 database
• Collaborated with Business Analysts to identify source systems, trust scores, and match and merge rules
• Developed enhanced form validation in IDD via Java User Exits
• Leveraged ERwin in creating and designing the customer master data model
• Successfully imported ERwin CMW file into the MDM Hub to expedite hub configuration setup
• Accelerated development effort by 50% through XML code generation for MDM Hub objects that include landing, staging, and base object tables, as well as MDM Mappings and cleanse functions
• Leveraged Informatica Mapping Accelerator to mass produce over 50 PowerCenter Mappings
• Developed data quality Mapplets and rules for Name Parsing, Address Standardization, Phone Validation, and data cleansing
• Performance tuned end-to-end initial data load volume of 1 billion records in both PowerCenter and MDM Hub
• Setup match rules set that include auto match and manual match rules in the MDM Hub
• Created validation rules to degrade trusts for records with data quality issues
• Performance tuned match and merge rules for initial data volume of 1 billion records
• Set up and configured hierarchy manager leveraged in Informatica Data Director
• Developed custom Java function to call Google Phone API to standardize customer phone numbers
• Leveraged SIF API via Web Services to invoke batch groups, put calls, and unmerge dataset via PowerCenter
• Designed, developed, and implemented reject data management strategies in PowerCenter ETL, MDM staging, and MDM base object loads
• Attended daily Scrum meetings and provided regular updates on JIRA storyboards
• Completed task to bring Dun and Bradstreet data into MDM landing

Confidential, CA

MDM Hub Configuration Specialist

Environment: MDM 9.7.1, PowerCenter/Data Quality 9.5.1, SQL Server 2012, Windows Server 2012, JBoss 6.4

Responsibilities:

• Installed and configured Multi-Domain Master Data Management 9.7.1 on Windows 2012 and SQL Server 2012
• Coordinated with business and stakeholders in gathering requirements and generating heat map
• Leveraged existing Informatica healthcare solution while also customizing data model based on given requirements
• Provided ETL architectural layout and guided developers in loading data from source-to-landing
• Created DQ rules and Mapplets to address data quality issues in the source systems
• Leveraged MDM Hub to configure source systems, trust settings, validation rules based on data quality scores, and match rules
• Developed cleanse list functions and created MDM Mappings to load data from landing-to-stage
• Automated MDM batch groups/batch jobs using Web services functionalities in PowerCenter to interface with MDM SIF Framework