SUMMARY

• Having 12 years of strong experience as an Architect/Lead Developer especially with MDM, ETL Data Quality, Data Governance and ElasticSearch.
• Provide technical leadership in the areas of database design and implementation, services, master data management, data modeling, data quality, data governance, data access & data integration.
• Collaborated with enterprise architecture organization to ensure best use of standards for Master Data Management and key data use cases.
• Work closely with strategic projects and coaches development teams on defined standards and methods for data usage and propagation.
• Deep experience in Master Data Management practices, concepts and Domains (Party, Product &Contract).
• Provided leadership & guidance on solving highly complex problems in Master Data Management, data architecture, design and build of complex applications and perform design reviews.
• Performed requirement gathering, analysis, design, development, and testing, implementation, support and maintenance phases of both MDM and Data Integration Projects.
• Engaging in performance tuning, load testing. Experience in develop performnace test plans and automation test cases.
• Good Experience in understanding business application, business dataflow and data relation.
• Knowledge of Dimensional Modeling, Star and Snowflake Schemas.
• Expertise in Data Profiling and 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.
• 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: IBM MDM AE 11x,IBM MDM 10,Informatica MDM 9.7/10x

Data Quality: Informatica IDQ 9x/10x,Mellisa Data, DQS (In-House)

ETL: Informatica-7x/8x/9x/10x,Informatica Meta Data Manager

Big Data Technologies: Hadoop Hortonworks, Elastic Search 5.2.1

Monitoring/Logging Tools: Splunk 7.0,Dynatrace 6.5

Development Tools: RAD V9.1.0,Eclipse Oxygen 4.7

DevOps: Jenkins, Maven

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

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

OLAP Tools: Web focus,Cognos,Tableau

Query Tools: TOAD, PLSQL Developer,Iseries Navigator

Data Modeling Tool: Erwin

Version Control: Serena Dimensions, Rational Clear case,SVN,GIT

PROFESSIONAL EXPERIENCE

Confidential

Data Management Specialist

Environment: IBM Infosphere Advanced Edition 11.3.0, Informatica 10.1, Oracle12c, WebSphere 8.5.2, Linux, Elastic Search 5.2.1, Splunk7, Dynatrace 6.5, Jenkins, Maven.

Responsibilities:

• Accountable for identifying and verifying appropriate application solution alternatives and driving the entire technical design for the project including functional, integration, data and infrastructure design, and working closely with dedicated resources for each area.
• Collaborated with enterprise architecture organization to provide Next 3 Year Stratergy for Master Data Management and related Integrated layers like Data lakes, Middleware.
• Collaborate with the MDM Service team, SOA Team, Data Governance, and Business Partners to define functional and technical requirements for MDM technology.
• Captures MDM use cases and requirements to incorporate into technology solutions, Conducts gap analysis for MDM data processes and content.
• Data Analysis/Root cause analysis for MDM use cases like Matching, survivorship, suspect processing.
• Applying Postproduction Data Patches/Fixes.
• Worked with WebSphere, Portal, MQ And Data Base Administrator’s to fulfill the Needs of MDMWith High Availability Setup across all the Layers.
• Performance Tuning of real time and Batch load at different Levels MDM Server, Match and Merge Process and at the Database.
• Converted Inbound/Outbound ETL jobs from Informatica to spring boot.
• Reviewing the code developed by the team, which includes ETL, MDM and DataQuality.
• Created Splunk Dash boards and Alters using Dynatrace as part of Production support.

Confidential

MDM/ETL Specialist

Environment: IBM Infosphere Advanced Edition 11.3/11.4.0 , IBM Infosphere Collaborative Edition 11.4.0, Informatica 9x, Quality Stage, Oracle12c, WebSphere 8.5.2, Linux

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 stakeholders and Business Users for obtaining Best of Breed Golden Record.
• Collaborate with the MDM Service team, ESB Team and Business Partners to define functional and technical requirements for MDM technology.
• Captures MDM use cases and requirements to incorporate 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 Post production Data Patches/Fixes.
• Worked with WebSphere, Portal, MQ And Data Base Administrator’s to fulfill the Needs of MDM With High Availability Setup across all the Layers
• Performance Tuning of real time and Bath load at different Levels MDM Server, Match and Merge Process and at the Database.
• 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.

Confidential

ETL Developer

Environment: Informatica9.1, Oracle11g

Responsibilities:

• Demonstrated strong analytical, problem-solving, organizational, communication, learning and team skills.
• Analyzed the data models of the source systems to develop comprehensive mapping specifications, created POC’s to prepare high level design, mapping specification, Low level design, unit testing plan, monitoring and resolving production issues.
• 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.
• Reviewing the code developed by the team.
• Designed the ETL processes using Informatica tool to load data from flat files and Oracle into the target Oracle database.
• Worked on Unix shell scripts and stored procedures to perform tasks like scheduling workflows and email notification for failures of loads.
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Involved in deployment of the project.
• Involved in scheduling the jobs using Control M.