SUMMARY

• Having 8+ years’ of experience in Information Technology.
• 4+ years of industry experience with proven expertise in system development activities including requirement analysis, design, coding, testing and implementation of applications in customer and products domains using Informatica MDM 10.x/9.7/9.5
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Expertise in MDM Hub configurations - Data Modeling, Data Mappings, Data Validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Expertise in designing transactional interface with MDM Hub using BES and Composite services.
• Expertise in designing multi-dimensional view of the entity data using Entity 360 and provisioning tool.
• Designing & developing multiple cleansing and standardization scenarios using Cleanse Function
• Defined Trust and Validation Rules before loading the data into the Base Objects.
• Created Match rule set in for base object by defining Match Path components, Match columns and rules.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Good understanding MDM HUB Process flow and Architecture
• Used Repository manager for validation, promotion, importing, exporting the ORS repositories to Development, QA, Pre-prod, prod environment.
• Knowledge in Data standardization and Address cleansing using Informatica Data Quality (IDQ) Cleanse Functions and Address Doctor.
• Exposure in integrating external business application withInformaticaMDMhub using Batch process SIF and message queues.
• Competent in developing SQL, PL/SQL Procedures, Functions& Packages in SQL Server & Oracle Databases.
• Experience with various SQL developer tools such as SQL Plus, and Oracle SQL Developer.
• Experience in Agile and Waterfall methodology projects.
• Highly focused, hard-working team player with strong interpersonal technical skills.
• Very good understanding about development methodologies like Waterfall and Agile
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Strong Experience in installation and troubleshooting Informatica MDM
• Excellent understanding and deployment experience with various application servers - IBM WebSphere, WebLogic, JBOSS and Tomcat
• Strong working experience with multiple databases - Oracle, DB2, SQL Server
• Very good experience in Object Oriented Analysis & Design and Java Design Patterns

TECHNICAL SKILLS

MDM Tools/Packages: Siperian/Informatica MDM Multi-Domain Edition (10.2/9.7/9.5 ), Informatica Data Director, Hierarchy Manager, SIF, Activos, IDD, SIF, IDQ, Informatica Power Center.

ETL Tools: Informatica 9.x, SAP BODS 4.0.

Operating Systems: Windows 9x/2000/XP/Vista/7/8,Unix

Cleanse Adapter: Address Doctor, IDQ Cleanse Functions

Application Servers: JBoss,WebLogic

Database Technologies: Oracle 9i/10g/11g,SQL Server2010, Teradata.

Development Tools: SQL plus, PL/SQL

Project Methodologies: Waterfall Model, Agile

PROFESSIONAL EXPERIENCE

Confidential, Parsipanny, NJ

MDM Developer

Responsibilities:

• Worked on Installation, Configuration, upgrades, deployments of Informatica and MDM.
• Co-coordination with off shore team on delivery and status updates
• Running requirement-gathering meeting from the business team.
• Configure Trust Rules and batch groups.
• Worked on clear case management.
• Conduct source system analysis, and data profiling for lifecycle management.
• Configured match rules and trust as per requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool
• Configured batch jobs for customer, contacts, material, vendor, customer material domains
• Configured Activevos and implemented approval process in IDD.
• Worked on entity 360 view and on Provisioning Tool.
• Good experience in IDD Apploication.
• Created manual workflows in Activevos.
• Worked on match tunning.
• Good experience on end-to-end MDM Hub configuration.
• Coordinated with ETL team for performing land batch process to populate data from external source system to landing tables in hub
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Worked with various teams involved in project to identify and resolve issue occurred during UAT.

Confidential, Titisville, NJ

MDM Consultant

Responsibilities:

• Exposure in configuring Informatica MDM Hub server, cleanse server and Address Doctor5 in Development, QA
• Worked on Installation, Configuration, upgrades, deployments of Informatica and MDM.
• Regular monitoring of platform and healthchecks.
• Configured the Landing Tables, mappings, staging tables, Base objects, relationships, Lookups, queries, packages, query groups, Batch groups
• Scheduling the batch jobs.
• Setup of Identify Service on ActiveVOS Console.
• Developed an integration platform between MDM and ActiveVOS
• Defined the Trust and Validation rules
• Configured Entity 360 for the subject area ORS.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Co-coordination with off shore team on delivery and status updates
• Running requirement-gathering meeting from the business team.
• Experience in documentation and functional writing.
• Configure Trust Rules and batch groups.
• Conduct source system analysis and data profiling for lifecycle management.
• Configured match rules and trust as per requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool
• Ran batch jobs for customer, contacts, material, vendor, customer material domains
• Defined Match rules in Match and Merge settings of the base table by creating Match Path Components, Match Columns and Rule sets.
• Created IDD application to support the ongoing business needs to feed the data into the hub.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager
• Created and scheduled Workflows, Configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager

Confidential, Santa clara, CA

MDM Developer

Responsibilities:

• Exposure in configuring Informatica MDM Hub server, cleanse server and Address Doctor5 in Development, QA
• Configured the Landing Tables, mappings, staging tables, Base objects, relationships, Lookups, queries, packages, query groups, Batch groups
• Worked on IDD user exists.
• Configured BES and composite services using IDD and provisioning tool.
• Good Knowledge in configuring Entity 360.
• Defined the Trust and Validation rules.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Co-coordination with off shore team on delivery and status updates
• Running requirement gathering meeting from the business team.
• Configure Trust Rules and batch groups.
• Worked on clear case management.
• Conduct source system analysis, and data profiling for lifecycle management.
• Configured match rules and trust as per requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool
• Configured batch jobs for customer, contacts, material, vendor, customer material domains
• Defined Match rules in Match and Merge settings of the base table by creating Match Path Components, Match Columns and Rule sets.
• Created IDD application to support the ongoing business needs to feed the data into the hub.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager
• Created and scheduled Workflows, Configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager

Confidential, Red wing, MN

MDM Developer

Responsibilities:

• Exposure in configuring Informatica MDM Hub server, cleanse server and Address Doctor5 in Development, QA
• Configured the Landing Tables, mappings, staging tables, Base objects, relationships, Lookups, queries, packages, query groups, Batch groups scheduling the batch jobs.
• Defined the Trust and Validation rules
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Took ownership for populating and validating 173 lookup tables associated to data model
• Ran batch jobs for customer, contacts, material, vendor, customer material domains
• Defined Match rules in Match and Merge settings of the base table by creating Match Path Components, Match Columns and Rule sets.
• Created IDD application to support the ongoing business needs to feed the data into the hub.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager
• Development, QA, Pre-prod and Prod environment.
• Performed Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase.
• Identified Master records for Party Data by analyzing the data and duplicate records from source systems.
• Created Unit Test Case Document, Technical Design Documents, Informatica Hub and IDD Migration Request Document.
• Validating all Data model changes comparing with hub configuration before conversions
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Coordinated with ETL team for performing land batch process to populate data from external source system to landing tables in hub
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Worked with various teams involved in project to identify and resolve issue occurred during UAT.

Confidential

MDM Developer

Responsibilities:

• Configure landing, mapping and staging tables.
• Test mappings and run staging jobs.
• Define match columns for fuzzy and exact match/Define match rules/Configure merge settings.
• Configure Trust Rules
• Configured batch groups
• Conduct source system analysis, and data profiling for lifecycle management.
• Configured match rules and trust as per requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool
• Thorough understanding of deterministic and probabilistic matching methodologies and master data hierarchy management
• Work with Architecture Review Board and Change Approval Board for technical reviews and approvals through the system development life cycle.
• Involved in service module starting from requirement gathering, design, development using Service Integration framework.
• Collaborate with the Enterprise Architecture teams (data integration, data architecture, business intelligence) to develop and deliver MDM solutions.
• Coordinate MDM program activities for the Member and Provider data domains
• Deployed and tested webservers in Soap UI
• Documented and updated TDS and FDS
• Updated HPQC with defects

Confidential

Informatica Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Confidential

ETL developer

Responsibilities:

• Designing, developing and testing Different Mappings according to Requirements.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
• Designed mappings for slowly changing type-1 and type-2 dimensions.
• Written complex SQL queries to pull the data from application systems to load fact tables.
• Created sessions and workflows to load and test the dimensions and fact tables.
• Created native and ODBC connections to connect to source and target databases.
• Prepared ETL mapping documents and unit test documents.
• Created and scheduled Workflows, Configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Involved in code reviews and peer reviews.
• Involved in User testing in getting approval for ETL CUT.
• Implemented SDLC process to push the code onto higher environments.