PROFESSIONAL SUMMARY:

• Having 9.4 years of Strong hands on experience in designing, modeling, implementing and testing the MDM/ETL related services in large - scale implementation environments.
• Extensively worked in Master Data Management, ETL tools of the legacy data to Data warehouse using IBM InfoSphere MDM (9.0/11.4), Informatica MDM (9.5/9.1), Informatica Power Center (9.1/9.01/8.6 ).
• Performed requirement gathering, analysis, design, development, testing, implementation, support and maintenance phases of both MDM and Data Integration Projects
• Data profiling, probabilistic match and merge and performance tuning on millions of records from various data sources, for trusted golden records creation.
• Proven ability to deliver highly comprehensive Master Data Management designs to consolidate data across a wide range of business entities.
• Deep experience in IBM Master Data Management practices and concepts
• Good Knowledge on Web sphere Administration and Architecture.
• Expert knowledge on IBM PIM Data Model, Import, Export, Report, Workflow, Security and other configurations
• Worked as Data Warehouse developer with strong experience in fulfilling many Data Warehouse project tasks, such as Analysis, Design, and ETL (Extract, Transform and Load) process using Informatica.
• Engaging in performance tuning, load testing. Experience in develop test plans and test cases.
• Good Experience in understanding business application, business dataflow and data relation.
• Good Knowledge on Informatica Administration and Architecture.
• Expertise in providing Data Analysis Document.
• Good Experience in providing generic solutions, which can be used as a global template for the other teams.
• Good Experience in Prioritize tasks, delegate work/tasks to team effectively, manage risks, and escalate communications when required.
• Expertise in creating documents like Deployment document, Run Book Document, Check list documents etc.
• Good Experience in Performance Tuning of database and Informatica levels.
• Good communication, inter-personnel and analytical skills.
• Good problem solving, self-learning ability and can adapt to new environments.
• Proactive, Dedicated, and zeal to learn New Technologies and Tools.

TECHNICAL SKILLS:

MDM Tools: IBM PIM CE 11.4.0,IBM MDM AE 11.4.0,IBM MDM 9.0/10.0,Informatica MDM 9.x

ETL Tools: Informatica-7x/8x

Development Tools: RAD V 9.1.0/ 7.5.4

Web Technologies: HTML, ASP, Java Script, XML,XSD

Languages: C, C++, Java, SQL, PL/SQL

Database: Oracle9i/10g/12c,DB2,SQLSERVER

OLAP Tools: Web focus

Query Tools: TOAD, PLSQL Developer,Iseries Navigator

Operating Systems: Windows NT/XP,Unix,Linuix

Data Modeling Tool: Erwin

Version Control: Serena Dimensions, Rational Clear case

PROFESSIONAL EXPERIENCE:

Confidential, Melville, NY

MDM Specialist

Environment: IBM Infosphere Advanced Edition 11.4, IBM Infosphere Collaboration Edition 11.4, Oracle12c, WebSphere 8.5.2, Linux, RAD 9.2, Jenkins, Serena

Responsibilities:

• Involved in design phase, gathering requirements from business users, working with Business analysts and helping them translate requirements into technical spec.
• Customized the Out of the Box Data Model from IBM to match with Canonical Data Architecture
• Worked as Data Architect by Analyzing Current data and performed workshops with stake holders and Business Users for obtaining Best of Breed Golden Record.
• Partner with the MDM Service team, ESB Team, ETL Designers.
• Captures MDM use cases and requirements to in corporate into technology solutions. Conducts gap analysis for MDM data processes and content.
• Generated XML’s using Stored Procedures.
• Developed UNIX Scripts for Daily Batch Processing.
• Reviewing the code developed by the team.
• Applying Prost production Data Patches/Fixes.
• Worked with WebSphere, Portal, MQ And Data Base Administrator’s to fulfill the Needs of MDM
• Performance Tuning of real time and Bath load at different Levels MDM Server and Database Level.
• Debugging code Developed by team to Identify and Resolve Issues.
• Configuring JMS Message Queues and WebSphere MQ.
• Coordinating with IBM for the Product PMRs.
• Keeps up with trends in MDM information technologies, methodologies and capabilities to keep the organization informed on where it is headed with respect to the industry.
• Created PIM Conceptual Model.
• Identified and Created Hierarchies, Taxonomy’s, Catalogs.
• Identified and created custom work flow process for different groups.
• Setup Security at LDAP and integrated with PIM.
• Designed the Import and Export process.
• Trained business stake holders on PIM.

Confidential, NJ

MDM Consultant

Environment: : Informatica Multi Domain MDM 9.1, Oracle 10g, Jboss, Eclipse

Responsibilities:

• Configure MDM tables in the following sequence: Base Objects, Relationships Base Objects, and Defined and developed the ETL process to load the data into the landing tables during the land process
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Worked on data director to show the output information to end users.
• Worked on Data Quality and profiling for different source systems.
• Experience in loading the data in staging Process and Loading Process in to the Hub.
• Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Experience with Informatica MDM batch processing.
• Deployed IDD Configuration by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications
• Experienced in Security Access Manager (SAM) for creating roles and assigning users
• Release Management - Exports using Metadata manager to keep environments in synch
• Testing - System Testing and Bug fixing.

Confidential, CA

Team Leader

Environment: Informatica8.6, DB2

Responsibilities:

• Participated and contribute in estimation, project planning, task scheduling, design activities
• Helped the team and extend support by sharing the knowledge and bringing offshore team up to speed of onshore.
• Involved in Data modeling for Enhancements.
• Prepared Design documents and mapping specification Documents.
• Reviewing the code developed by the team.
• Design and development of ETL modules for loading data into warehouse using Informatica.
• Created mappings for loading the data into Fact tables.
• Created stored procedure with dynamic SQL’s involved in it.
• Created Materialized Views.
• Created Partitions in session to improving the Performance.
• Used Reusable transformations, Parameters to facilitate the reusability of Code
• Created mappings for loading the Historic data into Fact and Dimension tables.
• Involved in unit testing and integration testing and deployment of the project.

Confidential

ETL Developer

Environment: Informatica8.5, oracle10G,Webfocus

Responsibilities:

• Prepared mapping specification Documents.
• Design and development of ETL modules for loading data into warehouse using Informatica.
• Developed mapping to load the data in slowly changing dimension.
• Created mappings for loading the data into Fact tables
• Converted Stored Procedures into mappings.
• Used Reusable transformations, Parameters to facilitate the reusability of Code
• Extensively used command tasks for keeping track of events in the ETL process.
• Migrated Informatica from 7.1 to 8.5 and from 8.5 to 8.6-Involved in all the phases and exposure to Informatica latest version-8.6.
• Enhanced the existing reports with scheduler functionality.
• Involved in unit testing and integration testing.
• Involved in deployment of the project.
• Monitoring the daily jobs.
• Involved in Recruitment process.

Confidential

Application Developer

Environment: Informatica8.1.5, oracle10G,Db2,BusinessObjects6.1

Responsibilities:

• Prepared Technical Specification Documents.
• Design and development of ETL modules for loading data into warehouse using Informatica.
• Migrated Informatica from 7.1 to 8.1-Involved in all the phases and exposure to Informatica latest version-8.6.
• Enhanced the existing mappings as per the change request by the client.
• Monitoring the daily jobs.
• Sending the Reconciliation sheet to the client.
• Involved in unit testing and integration testing.
• Scheduling the jobs using Control M.