SUMMARY

• I have over 9.2 years of experience in IT Industry on Data Governance projects (Informatica Master Data Management and IDQ) and have involved with multiple projects in various stages of software development life cycle including - requirement analysis, design, development, testing, implementation and Support of various systems.
• Vast experience Informatica MDM (Version 9.0.1 to 10.2), Informatica Data Director (IDD) and Provisioning Tool Configurations.
• Working knowledge on Informatica IDQ Developer/Analyst and Power-Center tool.
• Good experience in Informatica MDM upgrade ( v9.0.1 to v9.7 and v9.5 to v 10.1) and installation
• Having understanding on Address Doctor and Informatica Cloud
• Sound knowledge in Stage/Load Jobs, Mapping, Staging Platform config, Cleanse Function, Packages, Queries, IDD/HUB User Exit, Match and Merge, Trust Settings, Validation Rules, Hierarchy, Tokenization and Batch Group creation, SAM Privilege, User creation, SIP POP, Smart Search, Customer E360View, DaaS provider and Business Entity as Object/Service, ActiveVOS, BEActiveVOS, Siperian Workflow engine etc. of Informatica MDM Hub.
• Working knowledge in Inbound/Outbound Services, Batch Sync/Publish Services with Informatica MDM Hub 9.0.1 to 10.2 version using SIF APIs
• Good troubleshooting knowledge and isolating the root cause across the Master Data Management product
• Working knowledge on Jboss and Weblogic 12c Servers.
• Working knowledge in PL/SQL, Oracle and SQL server databases
• Working knowledge on Linux and Windows operating systems
• Experience in Job and batch file Scheduling Tool (IPM, TWS and Autosys).
• Highly efficient in understanding client’s requirements and converting them into code developments.
• Innovative, committed, result oriented quick learner with quest and zeal to learn new systems.
• Basic experience into Informatica Cloud and salesforce UI.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Adv MDM Developer

Responsibilities:

• Upgrading the Master database, ORS store, Hub Server, Process Server and Resource Kit.
• Had better understanding flowing the data from Slaesforce to MDM vice versa and too other downstream system.
• Worked on E360, Smart search, External Link, Daas provider, Bossiness entity object and services and task configuration.
• Was part of Post upgrade testing and solved the bugs/defect raised by QA team
• Planned and executed in scrum mode, agile methodology

Confidential

Informatica MDM Consultant

Responsibilities:

• Understanding client requirement w.r.t MDM implementation and suggesting better option in all possible ways.
• Having strong understanding in Customer life cycle, Data governance, Data quality, Data security for customers across the enterprise from many disparate systems.
• Building a data model according to business needs by interacting with data architect.
• Planned and executed in scrum mode, agile methodology
• Configured Informatica MDM and Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards
• Configured the Source system and respective stage table and trust setting based on business need.
• Worked on External Match process, Match and Merge rule set and tunings considering Latin and Non-Latin data, Business Hierarchy Configuration, Population file/SIP POP and Batch Group, stage table configuration and publishing logic for Core and Non-core attributes and Task Configuring(Siperian, Activevos and BEActivevos) etc.
• Worked on E360 view, smart search, DAAS provider, Application/Entity Page layout, Application and Business entity as service
• Worked on SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge and Unmerge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Helped in developing the MDM/IDD user exist and batch process.

Confidential

Technical Lead

Responsibilities:

• Prepared the pre-requisites for the upgradation which consist of backing up the database.
• Upgraded WebLogic to 12C and JAVA 1.7
• Upgrading the Master data base, ORS store, Hub Server, Process Server and Resource Kit
• Setting the init.ora parameters of the database and the jvm and jnlp parameters of the application server and required configuration w.r.t environments.
• Configuring the connection pool settings. Creating the message queues in the standalone. Full file. Configuring the connection factory settings.
• Worked on MDM Pre and Post Upgrade issue by applying patches and through Custom implementation.
• Optimizing the hub server and process server by using the threads in the cmxserver.properties and cleanseserver.properties file.
• Helped in resolving issue with user exits which converted java from PLSQL.
• Resolved issue related to WebLogic( made changes into Setenv.sh and WebLogic start-up script)
• Worked on Match-Merge tuning and performance stats.
• Worked on code sync-up.

Confidential

Technical Lead

Responsibilities:

• Being part of discussions and requirement gathering with Clients.
• Worked on the complete life cycle in MDM/IDD and IDQ from requirement gathering, Development, UAT and Production deployment.
• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Implemented the business requirements, worked on physical data model, Hierarchy, Match/merge rule set and cleanse function, staging Mapping, data validation rules, Batch Group etc.
• Worked on IDD bulk upload and other custom extended functionality.
• Implemented custom logic using SIF API’s call(delete, cleanup, merge, unmerge and get, put, Searchmatch etc)
• Working knowledge on IDQ rules and profiling.

Confidential

Sr. software Engineer

Responsibilities:

• Worked on Informatica MDM enhancement(New Data-source integrations) and Upgrade(from version 9.0.1 to 9.7.1) project
• Worked on IDD and SIF API.
• Defect analysis and bug fixes in various environments.
• Working knowledge on Informatica Power-center to load the data into Landing table
• Health Care Account and Prescriber data from more than 72 data sources and applying business transformation and validation rules in the Mappings.
• Leading day to day support activities from offshore. Coordinating with Business teams for various issues.
• Maintain code, release documents in central repository (SVN).
• Data load validation and analysis for mismatch data
• Worked on Shell Script automation

Confidential

Software Engineer

Responsibilities:

• Requirement analysis and reverse engineering to find the RCA
• Analyzing requirements, Designing and developing Informatica objects as per requirements received from client and preparing data mapping sheet.
• Preparing high level design document for design and preparing technical design document for respective objects
• Analyzing dependency and preparing the dependency diagram for scheduling.
• Performing Impact analysis if there is a Change request received and implementing the same.
• Writing UNIX shell script wherever needed in project for making mandatory checks.
• Writing PL/SQL procedure wherever needed in project for making database checks and activities reusable.
• Optimizing the code to do performance tuning and to meet architectural standards.
• Delivered KT to new joinees.
• Fixing defects raised in Quality Centre (QC) by testing team.
• Helping Production Support team to identified issues