SUMMARY

• Experienced Enterprise Data Management professional committed to providing comprehensive & valuable solutions to business problems and challenges
• Recognized for promoting industry MDM & DQ best practices, processes, fit for purpose technology solution recommendations and using hypothesis based problem solving approach in making assessments to client problems and proposing solutions to Business Stakeholders.

AREAS OF EXPERTISE

• Informatica MDM,PIM
• Master Data Architecture
• Requirements Gathering
• IDD, JAVA
• Data Modeling
• MS Office Suite, GSuite
• SOA/Web Services
• ActiveVOS
• TOAD/SQL Developer
• Oracle, SQL Server, AWS Redshift
• Tableau, Alteryx, UI Path
• Sales Force Integration

TECHNICAL SKILLS

EIM Tools: Informatica MDM 9.5,10, 10.2 (MDM Hub, Informatica Data Director), PIM 7.1 (Product 360), Profisee V6/7

ERP: Oracle E - Business Suite R 12.1.1, SAP ECC

Cleanse Adapters: Address Doctor, Trillium

ETL: Informatica Power center 9.0/8.0(Designer, Workflow Manager), SSIS

BI Tools: Cognos 10/8.x (Business Insight, Report Studio, Framework Manager, Transformer, Metric Studio), Cognos TM1, OBIEE, SSRS, SSAS, SAP Business ObjectsDatabase Systems Oracle 11g, 10g/9i/8i/7x, MS Access, SQL Server 2000/2005, IBM DB2 and Teradata, AWS Redshift

Application Servers: Web Logic 10.x/9.x, JBoss, IBM Websphere 7.0

Web Servers: Microsoft Internet Information Server (IIS) 5.0/4.0/3.0 & Tomcat

LDAP Servers: Sun One 5.2, Netscape Directory Server, ADS

Operating Systems: Windows NT/2000/Server 2003/XP, UNIX, LINUX, CITRIX

Programming Skills: SQL, PL/SQL, MDX, Python, Java, Java Script and VB

Applications: Microsoft Visual Studio, MS Office Suite (Word, Excel, Power-point, Access)

Other: TOAD, PL/SQL Developer, ERWIN 4.0/7.0

PROFESSIONAL EXPERIENCE

Confidential, Newport Beach, CA

MDM LEAD CONSULTANT

Responsibilities:

• Led Data Governance meetings with Data Stewards from Retirement Solutions Division & Life Insurance Division
• Proactively engaged with Business & IT Leadership in gathering MDM requirements for key projects in the program roadmap
• Created Data Dictionary & Data Catalog capturing attribute classification, business usage and application usage
• Developed concrete Project schedules with action plan for the MDM upgrade project reporting weekly status to Management
• Designed and Architected ETL(Informatica Cloud) - MDM Process Integration to host staging layer data on Amazon Redshift
• Designed & prepared Report wireframe to help effectively monitor Duplicate Data Prevention in Centralized Data Hub
• Performed Data Profiling from Key Source Systems that intend to Onboard into the Centralized MDM Hub
• Developed Validation Rules, Standardization process, deduplication (match) rules to group most accurate match groups
• Configured Survivorship Rules based on Preferences to Master Data attributes based on Trusted Source Systems
• Developed MDM Data Quality metrics categorized by Accuracy, Completeness, Consistency and Population % visualized in Tableau
• Ensured effective project milestones were met working with Reference Data Vendors and Product Vendors
• Estimated resource and task effort for the upgrade project with milestones, activities and deliverables

Confidential, San Jose, CA

MDM PROJECT LEAD

Responsibilities:

• Advised CXO’s on emerging BI/DW technologies and strategies consistent with clients’ business strategies.
• Evaluated & proposed enterprise MDM architecture feasability, risk and technologies related to business change.
• Prioritized, prepared and implemented MDM technologies and strategies consistent with clients’ business strategies
• Identified, validated & mapped data from data sources like SAP ERP, Sales Force Applications, Dun & Bradstreet, Oracle CRM and other Legacy Source Systems using traditional ELT, ETL products and EAI methodologies
• Acted as the engagement manager for client projects planning and executing kick off meeting, weekly status & steerco meetings
• Conducted stakeholder interviews & workshops with key business functions to understand their current usage of reports, pain points
• Designed and Developed MDM solutions including Hub Configuration, IDD Development including User Exits enhancements using Java MDM development practices and building DQ reports deploying war files in Jboss
• Partnered with business teams to gather and translate business functional requirements into technical solutions
• Extensive experience in Identification of User requirements, System Design, writing Program specifications, Coding, Implementation and Testing of EIM Systems
• Hands on experience supporting MDM / IDQ administrators in starting and stopping services during operational downtimes and pre go live scenarios.
• Experienced working with database environments like Oracle, SQL Server, MS Access, Spark, DB2 & Teradata
• Competent in developing SQL, PL/SQL Procedures, Functions, & Packages in SQL Server & Oracle Databases
• Participated in design, development & code reviews on all MDM customization including IDD User Exits, SIF API services including SOA RESTful services, JMS queues
• Developing and validating business stakeholders conceptual data models, including socializing and implementing logical and physical data marts and data models demonstrating technical acumen
• Identifying data sources and metadata to deliver analytic requirements using research of business cases,solution design, transactions process flow, business issues & business strategy
• Designing and developing data models extraction code and cleansing routines utilizing typical data quality functions
• Interacting with end users to understand and document business and functional requirements, data sources, metadata and conceptual data models for complex projects with related technologies like BI, SQL, DW, ETL, Modeling tools
• Self Starter Recognized for refined problem solving skills and interpersonal skills ; follows detail oriented approach & committed to meet deadlines, ability to multitask, work under pressure and results oriented through the course of lifecycle

Confidential

Oracle EBS | SFDC Integration

Responsibilities:

• Acted as the First line of business contact for MDM for Architecture, Design & Operations for a large Information Architecture team
• Created design & MDM solution architecture including process flow pertaining to SOA integration with Financial and Sales applications
• Worked with Master Data Stewards to articulate customer needs, Integration Consumers, business systems and External Application teams to assist in the continual operation and enhancement of Univision’s MDM Program Vision
• Documents including Source Systems, Hub Data Model Design, GAP analysis, Hierarchy configuration Match Rules, Integration.
• Provided Data Stewards with “Send to Oracle” feature in IDD and Entity 360 application utilizing smart search capability with User Exit and Enterprise Service Bus Integration component with JMS queue configuration and webservices interaction using SIF
• Responsible for maintaining applications-data for Customer Hub and Product Hub in Informatica MDM/IDQ
• Created Operational Indicators (KPI) reports using Tableau BI product
• Utilized Service Now to create Enhancements and Defects to manage Project related iteration and Sprint planning activities.
• Provided Data Stewards with “Send to Oracle” feature in IDD and Entity 360 application utilizing smart search capability with User Exit and Enterprise Service Bus Integration component with JMS queue configuration and webservices interaction using SIF
• Created Operational Indicators (KPI) reports using Tableau BI product
• Utilized Service Now to create Enhancements and Defects to manage Project related iteration and Sprint planning activities.
• Performed Bulk Merge based on Requests from Master Data Stewards
• Lift & Shift plan detailing from On premise MDM to Azure Cloud
• Created capabilities of Bulk Approval through IDD for task flow management using Active VOS
• Created Statement of Purpose for Operational Procedures & work arounds to support MDM application
• Worked Closely with Informatica Product Vendor’s in raising product defects and working with them to resolve the defects in lower environments planning for EBF’s and Hot Fixes
• Configured Post Load Hub Exit to enable multithreading for reactivaton scenarios of Customers

Confidential

Oracle EBS

Responsibilities:

• Served as a key MDM Consultant in thoroughly defining the Scope, architecture deisgn & Implementation strategy of Informatica Master Data Management capabilities for EPIC 2.0 translating from Business Requirements Documents (BRD) and Functional Specifications Documents to Technical Design Documentation with the holistic intent to Master an Organizational level attribute record (Party) for specific Business Units like RISK, Corporate, Whole Sale and CAO
• Worked closely with Business Systems Consultant, Business Analysts, Tech Relationship Managers and Development team in defining the Functional Specifications Design Document & MDM Architectural process flows for upstream and downstream application onboarding
• Created MDM Architectural Technical Design Document that reflects MDM Implementation methodology that is derived from FSD
• Performed Proof of Concept Demonstrating Product capability of governing loaded Hub Data in IDD
• Configured Hub Data model including Base Objects, Hierarchies, Relationships, Landing Tables, Source Systems, Staging Tables, MDM Mappings and Batch Groups
• Enabled /Implemented Consensus Hard Deleted Detection (Delta) as multiple source systems were involved that were responsible to determine the delete state of a record.
• Implemented Data Standardization by creation General Cleanse Functions, Business Attribute Cleanse Functions
• Worked with Development Team to enable automation of Batch Jobs utilizing Autosys