EXPERIENCE SUMMARY

• 12 years of IT Experience, out of which nearly 11 years hands on expertise in Master Data Management (Customer, Product, Vendor, Supplier, Location) and ETL Solution Implementations in Tata Consultancy Services Ltd
• Hands on Experience in complete E2E SDLC phases including Requirements Gathering, Analysis, Define Solution Roadmap, Design Architecture & technical components and implementation of Enterprise wide MDM and ETL solutions as MDM / ETL Solution Architect
• Expertise in defining Data Governance and Data Quality Standards, Processes and Best Practices for major MDM implementations.
• Extensive experience in implementation of Data Warehousing, Data Marts, Star and Snowflake Schema, Dimensional Modeling on OLTP and OLAP concepts
• Possess knowledge and experience in working with leading MDM and ETL tools in the market such as Informatica Power Center, Informatica IDQ, IBM MDM, IBM Datastage, Confidential, SAP Hybris, STIBO STEP, Microsoft EDM, Tribold, Riversand, Talend etc and involved in product evaluations and solution roadmap and recommendations as MDM / ETL Consultant
• Had been Technical Lead for larger cross vendor teams in delivering MDM and ETL solutions in both AGILE and WATERFALL implementation methodologies.

TECHNICAL SKILLS

COTS MDM Tools: Trigo V1.4Websphere Product Center V5.3.2IBM Infosphere MDM Server for Product Information Management V6.0/V9.0IBM Infosphere MDM Collaborative Edition V 11.1/V10.1Microsoft Enterprise Dimension Manager V4.0 (+EDM

Integration and DW Tools: IBM Infosphere Data Stage V8.0, Informatica ETL (Power Center), IBM Netezza, Talend

Data Quality Tools: IBM Infosphere Quality Stage V5.1, Informatica IDQ

Database: Oracle 9i/11i, Microsoft SQL Server 2005, DB2 V10, PostgreSQL 9.3.2, Mango DB

Application/Web Servers: Websphere Application Server V8.0, Weblogic Server V10.0, Apache TomcatJBoss Application Server 5.0.1

Programming Languages: J2EE Concepts, C/C++, SQL, Unix Shell Scripting, .Net Framework, Struts Framework, Hive, Pig, WPC PIM Scripting, XML/XSD, UML, Javascript, Shell Script

Operating System: Windows 8,Windows 7,Windows NT,Windows XP 2000, Linux, HP - Unix, AIX 5.3/6.0

IDEs: Eclipse, IBM Rational Software Architect (RSA)

Version Control Systems: SVN (Sub VersioN), ClearCase

Quality Control Tools: HPeZilla, Test Rail, JIRA

PROFESSIONAL EXPERIENCE

MDM Advisor

Confidential

Responsibilities:

• Provide guidance to developers and testers of STIBO STEP PIM application on Quality Control aspects.
• Involved in designing product data governance standards.
• Involved in Integration Testing of PIM Components with Legacy applications through Informatica.
• Provide suggestions and recommendations on solution optimization
• Creation of Test Specifications/Testing Strategy documents
• System Integration and Performance Testing

MDM Consultant

Confidential

Responsibilities:

• Detailed study on PIM requirements.
• Evaluating various PIM technologies to finalize the best suitable platform for building the solution.
• Designing solution architecture, data governance framework and roadmap for Quick Win, Short Term, Medium Term and long term implementations
• Implementation of foundational model for Product and Customer in Informatica MDM
• Defining Match & Merge rules in Informatica MDM
• Define Data Governance rules and standards in Informatica IDD
• Design and Implement SIF calls for creating and updating master data records.
• Define Data Quality Standards and Profiling using Informatica IDQ

IM Solution Architect

Confidential

Responsibilities:

• Detailed study on International Remittance Information Management requirements.
• Evaluating various IM technologies to finalize the best suitable platform for building the solution.
• Designing solution architecture, Cost benefit analysis and defining IM implementation approach and design Analytics reports
• Lead Detailed designing on various modules in Remittance Information Management System and the integration of the same with Enterprise Product Catalog (PIM) system.
• Gathering requirements for Enterprise Product Catalog
• Evaluating various PIM products to finalize the platform for building Enterprise Product Catalog
• Designing solution architecture, data governance process, data quality standards, Cost benefit analysis and defining PIM life cycle processes for Enterprise Product Catalog.
• Detailed designing on various modules in PIM application which includes product catalog and hierarchy structure, workflows for product authorization and authentication using IBM MDM Server for PIM V9.0 and IBM Rational Software Architect (RSA)
• Coordinating development activities and presenting interim solutions and Proof of Concepts (PoC) to the customer using Confidential Server Collaborative Edition V10.1 and Integration with Customer Master Data - Confidential Server V10.1 (latterly known as Advanced Edition) using IBM Data Stage.
• Creation of Test Specifications/Testing Strategy documents
• System Integration and Performance Testing
• Tracking the project tasks for timely deliveries using Scrum Manager V2.0

Confidential

Informatica ETL,IBM Netezza

Responsibilities:

• Gathering requirements for Reference Data Management Solution
• Evaluating various MDM products to finalize the platform for building RDM
• Designing solution architecture, Cost benefit analysis and defining MDM data governance life cycle processes for RDM.
• Data Consolidation and Data Cleansing processes using Informatica ETL.
• Detailed designing on various modules in RDM application using Confidential (Laterly known as Informatica MDM)
• Coordinating development activities and presenting interim solutions to the customer using Confidential (Informatica MDM)
• Datawarehousing and Analytics done through IBM Netezza.
• Creation of Test Specifications/Testing Strategy documents
• System Integration and Performance Testing
• Tracking the project tasks for timely deliveries.

MDM Solution Designer and ETL Technical Lead

Confidential

Responsibilities:

• Gathering requirements for enhancements and change requests for Enterprise Content Management system using REVINE
• Analysis and preparing feasibility study on the change requests
• Designing solution architecture and future road map on the new CRs
• Detailed designing on each CR and presenting the same to customer for approval and sign-off
• Implement the change requests by configuring Confidential (Informatica MDM)
• Define Data cleansing and Data consolidation processes through Informatica ETL tool and data warehousing process done through IBM Netezza.

MDM Solution Designer

Confidential

Responsibilities:

• Gathering requirements for PIM solution
• Define a straw man for PoC to be done
• Design and develop the prototype using Confidential V4.0
• Presentation of the prototype to the customer and stakeholders

MDM Technical Consultant & Team Lead

Confidential

Responsibilities:

• Gathering high level requirements for Customer Response Initiative (CRI)
• Preparing project planning and initial estimation for designing and developing PIM solution
• Detailed requirement gathering and analysis to produce requirement catalogue and feasibility report.
• Designing solution architecture based on the business processes of CRI
• Detailed designing on various modules of PIM solution & development of the same using IBM Websphere Product Center V5.3.2
• Involved in preparing test strategies, test cases and executing System Integration Testing and Performance Testing for CRI
• Leading project team throughout design, development and testing phases.

MDM Solution Designer

Confidential

Responsibilities:

• Analyzing PRISM (Custom Built MDM) requirements and produce feasibility report using REVINE (newly known as ALM V2.0)
• Defining process flows and data modeling for PRISM application
• Designing solution architecture based on the business processes defined for product information life cycle
• Development of PRISM application.
• Involved in preparing test strategies, test cases using TCS and executing System Integration Testing and Performance Testing
• Involved in Go-Live activities of various releases of PRISM.
• Designing solution architecture for Enterprise Data Repository (EDRII) system, which includes product data modeling, defining workflows and system validation rules.
• Development of EDR II application in phase-wise manner.
• Involved in preparing test strategies, test cases and executing System Integration Testing and Performance Testing for EDRII application
• Involved in Go-Live activities of various releases of EDRII
• Analysis and implementation of change requests created for enhancement of EDRII applications

Confidential

J2EE Technologies

Responsibilities:

• Development activities in building digiTax application
• Involved in preparing test strategies, test cases.
• Involved in System Integration Testing and Performance Testing
• Project Description:
• digiTax, a Property Tax System is a TCS' comprehensive, state-of-art, integrated
• application for Tax Assessment, Property Management, Tax Billing, Collection,
• Distribution, Administration by County Governments, built on modern technology using
• Industry standards such as n-tier J2EE architecture. The application intends to provide