SUMMARY

• Certified Informatica MDM professional, with around 7 years of combined experience in implementation of Informatica MDM projects, Business Intelligence and data warehousing projects.
• Primary skills in Informatica MDM 9.5.1/9.7.1 , SAP Business Objects XIR2/3, Teradata 12/13, Oracle10g/11g, MySQL, Core java, Autosys, UNIX shell Scripting, Autosys technologies.
• Acquired good noledge of Entertainment/Media, Customer, Product, Sales, Manufacturing, and Procurement, Inventory domain while working with end clients like Confidential Inc. & The Confidential Company.
• Extensive noledge of implementing MDM ID based hub for enterprise level master data management implementations.
• Implemented unique spreadsheet based upload functionality, it allows data stewards to upload millions of subject areas/relationships into hub by providing data in just a spreadsheet.
• Good schema and data modeling skills with using entity relationship modeling, Normalization and dimensional modeling techniques using Star and Snowflake schemas.
• Extensive experience in setting up new source systems, trust scores, validation rules and defining the Match and Merge Rules in MDM Hub by use of path components, Match columns and match merge rules.
• Experience in creating landing, staging and base object tables and defining foreign Key relationships.
• Experience in creating mappings enabled with delta detections or delta loads for landing to stage table data loading along with use of using various internal or custom cleanse functions.
• Experience in registering of external database procedures, java user exists, custom cleanse list, and custom cleanse functions in MDM Hub.
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to QA to Production phases.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Experience in design and implementation of publish layer for external applications using master data from MDM hub.
• Knowledge of customizing IDD applications as per the business needs by creating the subject area and subject area groups, put and display packages, user exists for validations.
• Highly skilled in developing complex SQLs, Stored procedures, Macros, Tables, Indexes in Teradata / Oracle / MYSQL.

TECHNICAL SKILLS

• Informatica MDM 9.7.1
• IDD
• SAP Business Objects
• UNIX Shell Scripting
• PL/SQL
• Core Java
• Teradata 12/13/14
• Oracle 11g/10g
• MAC OSX
• Windows
• Linux
• SQL Workbench
• SQL Assistant
• MYSQL Developer
• Informatica Analytics
• Eclipse Service Pack 2
• SQL Modeler

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Informatica MDM Lead

Responsibilities:

• Currently working on CTaM, DCPLIC projects as Informatica MDM Consultant on Informatica MDM 9.7.x.
• Configured more than 5+ source systems in CTaM with use of MDM ID throughout the hub for all subject areas.
• Conducted various meeting with business to understand survivorship of each entity from a source system over another and configured trust setting accordingly
• Some source system data loading required enabling of delta detections while some other required a traditional approach of incremental data load.
• Also implemented a data loading functionality for urgent data publish needs called CBM spreadsheet upload, Where CBM is a name for business group which provided spreadsheet full of subject area details and relationships. This functionality reads the file and loads all data into MDM with in no time for immediate use. So fat have been able to load more than 100K such relationships in CTaM using this functionality.
• Developed multiple database codes, java user - exits codes using to implement very complex Title & character disambiguation, consolidation rules.
• Created custom Cleanse List and Custom cleanse function to validate for data while creating relationships using IDD.
• Created match path components, Match columns and merge rules for each entity in CTaM.
• Created batch groups with Batch viewer jobs and registered database codes with base objects.
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase

Confidential

Teradata & BO Developer 

Responsibilities:

• Involved in end to end lifecycle of the GSMA dashboard project as an onsite lead.
• Enhanced an existing business objects universe (Procurement Universe) and developed around 6 web-intelligence reports in the initial phase of the Procurement project.
• Designed the data model to fit in the dashboard requirements, and store summary tables in semantic layer.
• Developed various stored procedures having various business & summary data.
• Co-ordinated the development of GSMA dashboard UI with offshore team.
• Worked on performance turning of the dashboard continuously to make it as quick as possible. We utilized table partitioning, compressions methods & storing the summary data in most efficient way possible.
• Extensively worked on creating efficient SQL queries by working together with performance team.
• Involved in UAT support, Production deployment related important activities.
• Also worked as a functional lead involving business interactions to gather requirement and present dashboard Mockups & Designs to users.
• Involved in support activities of GSMA application until transitioned to EDW Support.
• Involved in impact analysis of the application for future enhancements post release.
• Dashboard Drag and Drop feature design, allowed user to change granularity of data as needed at the same time allowing them to analyze data against various aggregates of different measures.
• Successfully implemented caching framework
• Implemented rolling quarter feature on dashboard keeping initial page load within 3 sec and data view for CQ-1 to CQ+2 quarters.
• Implemented excel download of history data for max up-to 16 quarters in crosstab format by maintaining separate excel & dashboard semantic tables.

Confidential 

Teradata & BO Analyst

Responsibilities:

• Was involved in complete monitoring and root cause analysis of data and provided workable fixes for them.
• Created various automated data validation scripts to ensure data mismatches are caught immediately before AMR COB so that no mismatches in reports will be sent out to users.
• Created various business objects validation reports on top of core data tables to validate against various timeframe measures.
• Based on the issues found, a detailed analysis report and appropriate solutions were shared with onsite leads.
• Identified various data issues in written scripts, Which were fixed and deployed in production successfully
• Lots of specific scenario issues were identified & fixed in poll processing & Concurrent running of stored procedures etc.

Confidential

Teradata & BO Developer 

Responsibilities:

• Involved in requirement gathering, complete design and impact analysis of the required enhancements.
• Incorporated a huge list of enhancements in various existing IBB universes.
• Involved in development of various stored procedures.
• Involved in development, Unit Testing and integration testing of all enhancements & reports.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.
• Involved in performance testing and report performance tuning.
• Rigorous data testing and correcting data mismatch issues
• Involved in code migration, Warranty support.

Confidential 

Teradata & BO Developer 

Responsibilities:

• Worked on the development of various Webi reports development.
• Worked intensively to provide exact functionalities and desired look & feel to the reports.
• Involved in development of various stored procedures, data models and Macros.
• Involved in development, Unit Testing and integration testing of all enhancements & reports.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.
• Involved in performance testing and report performance tuning.
• Quick tickets analysis was done and issues were resolved.
• Involved in code migration, Warranty support, UAT issue analysis and fixes.