SUMMARY

• More than 14 years of Designing, Development, and implementation Master Data Management (MDM) and Data warehouse (DWH) solutions. Currently Working with VertexGroup as Solution Architect and Technical Lead for 21st Century FOX (The Walt Disney Company). Roles and responsibilities involve leading Master Data Management and making sure projects are delivered on time. Actively involved in analysis, designing, coding, testing, configuration, and release management.
• Worked around 8 years with TCS (Tata Consulting services) as Solution Architect and Technical lead for a Life Sciences and Pharmaceutical client.
• Extensive working experience in Informatica ETL, Informatica MDM Hub, BES (Business Entity Services) and IDD including JAVA User Exits and JAVA SIF APIs, UNIX/LINUX shell scripting, Perl Scripting, SQL/PL - SQL scripting, HP-Quality Centre and CA-Workload Automation and accessing Web Services, Restful Services and XML.
• Other Technological Proficiency in Object Oriented programming using Python, JAVA, ERP solution SAP ABAP, SAP PI, SAP BI, Data Science using R-Programming, Business Intelligence/Reporting Solutions SAP-Business Objects, IBM-Cognos, other ETL solutions IBM-DataStage, and a good knowledge of Big Data Solution Hadoop.
• Full Exposure to Complete Development life cycle and Production Support.
• Exposure to Project Management, Defining Implementation Scope, Requirement Analysis, Logical and Physical Designing, Impact Analysis & Risk Management, Data Quality, Project Tracking, Interaction with Customer from around the Globe, Development, Testing, Performance Tuning, Documentation, Post Production Support Experience
• Worked in Entertainment, Life Sciences and Pharmaceutical, Retail and Telecom Domains.

TECHNICAL SKILLS

Operating Systems: UNIX/LINUX, Windows Servers.

Databases: Oracle, SQL Server, MS-Access.

ETL Tools: Informatica PowerCenter, IBM-DataStage, BO-Data Services.

MDM Tools: Informatica MDM, BES (Business Entity Services) and IDD, JAVA User Exits, SIF APIs, Active-VOS

Data Quality Tools: Informatica IDQ.

Languages: Python, R-Programming, JAVA, Perl, Shell Scripting, SQL/PL-SQL, XML.

ERP: SAP-ABAP, SAP-BI, SAP-PI.

Testing Tools: HP-QC/Quality Centre.

Scheduler Tools: CA-Workload Automation, Informatica Scheduler, Crontab

Reporting Tools: Cognos, Business Objects.

Big Data & Others: SAP Power Designer, TFS, Web Services, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect and Technical Leader

Responsibilities:

• Worked closely with all the involved Stakeholders for requirement gathering and coordinating between all involved stakeholders and developing mutual understanding between stakeholders about the solution, respective responsibilities, and requirements.
• Gathered the Master Data and Data Quality requirements from Business users and key stakeholders.
• Managing project tasks through JIRA and managing the teamwork and work distribution among teams and regular team meetings
• Monitoring and advising the solution development and keeping the team’s spirit and team motivated throughout the project activities.
• Creating Informatica ETL Designs for the Extraction of the Source data to load into Informatica MDM landings
• Creating MDM Hub Objects like Source Systems, Base Objects (BO), Queries, Packages, Cleanse Functions, Mappings and configuring the Trust Systems and Trust Settings and Hierarchies, Stage mappings, Landing, Staging, validation rules and Match & Merge configurations
• Creating and configuring Informatica MDM outbound JMS Queues and Message triggers to flow the consolidated master data insert/updates/deletes to the downstream applications
• Creating Security configurations and user profiles for the controlled and secured resource access to the Data Stewards and other users, and controlling the Hub tools accesses
• Working on the Changes Migration between DEV to QA and to PROD environments.
• Configured ORS databases, Upgraded ORS databases, Designing and developing BES (Business Entity Services) and IDD applications development for the Data Stewards and Business users
• Creating Oracle SQL scripts, SQL Packages and Procedures and Linux Shell Scripts
• Created business rule Mappings and Mapplets in IDQ, MDM Hub JAVA User Exits, IDD JAVA User Exits to enhance the MDM capabilities and Creating Physical and Logical Data Models using SAP Power Designer. Created and Configured Approval Workflows using the Active-VOS
• Helping downstream applications in writing MDM SIF APIs Calls, PUT Calls and Cleanse PUT Calls, BES Restful Web Services Calls and JSON inputs for accessing or consuming the Master data.
• Worked on MDM upgrade from Informatica MDM 10.0 to MDM 10.2

Confidential

Solution Architect and Technical Leader

Responsibilities:

• Responsible for requirement gathering and coordinating between all involved stakeholders for requirements gathering and developing mutual understanding between stakeholders about the solution, requirements, and respective responsibilities.
• Responsible for the Data Warehouse, Master Data and Data Quality requirements gathering.
• Designing Logical and Physical models and respective documentations of the Data Warehouse and Master Data Management solutions.
• Managing project tasks through ProChain and managing the teamwork and work distribution among teams.
• Implemented Data Warehouse and Master Data Management solutions and developed data quality rules using Informatica IDQ. Creating Physical Data Models using SAP Power Designer.
• Configured ORS databases, Upgraded ORS databases, Designing and developing IDD applications
• Created business rule Mappings and Mapplets in IDQ, was involved in creating Data Warehouse solution using PowerCenter ETL tool, Oracle SQL and creating MDM cleanse functions, MDM Hub JAVA User Exits, IDD JAVA User Exits and SIF JAVA APIs in order to enhance the MDM capabilities and implementing the customized requirements and track the Master Data changes.
• Creating Matching and Merging rules, Stage mappings, cleanse functions, Landing, Staging, Base Tables, defining trust systems and configuring trust settings and validation rules
• Creating Business validation rules using IDQ and deploying as application web services, Implemented Approval processes through Active-VOS and implemented Hierarchies to defined and display the relationships.
• Creating Informatica PowerCenter ETL mappings, workflows and reusable mapplets and transformations to extract the data from various sources (XML, Web Services & Database tables) transform it per the business requirements and load the data into targets
• Monitoring and advising the solution development and keeping the team’s spirit and team motivated throughout the project activities, helping the team in technical development, using Informatica PowerCenter, Informatica MDM and Informatica IDQ, Oracle SQL and LINUX Shell scripting
• Helping downstream applications in writing MDM SIF APIs for accessing or consuming the Master data.
• Working on MDM upgrade from Informatica MDM 10.0 to MDM 10.2
• Working on Informatica PowerCenter Upgrade from 9.6 to 10.1

Confidential

Solution Architect and Technical Leader

Responsibilities:

• Responsible for requirement gathering and coordinating between all involved stakeholders for requirements gathering and developing mutual understanding between stakeholders about the solution, requirements, and respective responsibilities.
• Managing project tasks through ProChain, Requirement analysis and proposing efficient solution for the problem.
• Creating Logical and Physical models, managing the teamwork and work distribution among team, reporting tasks, and creating respective documentation. Physical models developed using SAP Power Designer.
• Responsible for defining testing strategies, developing test scenarios, and testing the application accordingly through HP-Quality Centre.
• Implementing solution using SAP Power Designer, Informatica PowerCenter ETL, Informatica MDM, Oracle SQL/PL SQL, Unix/Linux Perl Scripting, XML and Web Services, MDM JAVA User Exits
• Creating ETL Mappings, Workflows and Mapplets to Extract the data from various sources and after applying the business validations and cleaning the data loaded into targets.
• Upgraded and configured the ORS databases, Writing JAVA User Exits and Creating Landing, Staging, Base tables, Stage mappings, Matching and merging rules.
• Developing IDD applications for the Data Stewards interfaces and configured approval process using Active-VOS.
• Monitoring and advising the physical solution development and keeping the team’s spirit and team motivated throughout the project activities, helping the team in technical development.
• Also responsible for the post production activities
• Was also involved in PowerCenter 9.1 to 9.6 upgrade and Informatica MDM 9.6 to 10.0

Confidential

Technical Leader

Responsibilities:

• Gathering the requirements from the stakeholders for either consuming the source (Publisher) data into Org Master using ETL tool or Passing the data into any downstream application (Subscribers), Creating Logical and Physical design of the system.
• Creating and managing the project tasks, teamwork, and work distribution for project tasks execution progress.
• Negotiating (match and merge) rules with all stakeholders and it can be applied onto the data for identifying and merging the duplicate records and making the MDM solution consistent.
• Interacting with customer to gather the requirements to define the data cleansing requirements so that consistent and integrated solution is created.
• Responsible for developing the logical and physical solution designs based on the customer requirements and creating respective documentations.
• Was responsible to design and develop the solution to transform and transfer of data from various publishers to Org Master (OM) as per the requirements using ETL jobs and designing and developing cleansing, matching and merging rules for cleansing and merging the duplicate data and creating BVT records.
• Responsible to develop and configure MDM Hub landing, stage cleanse mappings, matching, merging, Queries, Packages, BO objects, defining Business rules and validations and configuring the source systems trust and Creating Hub JAVA User Exits.
• Creating and configuring IDD Applications for the data Stewards, IDD User Exits, and ORS Specific SIF APIs for accessing MDM data.
• Creating and configuring Informatica MDM Hierarchies for the better display and managing the BVT records. Worked on java applications calling SIF APIs
• Creating documents such as Requirements and Design, Installation and Verification Instructions, Operational System Instructions and Standard Operation Procedures
• Upgrading Informatica PowerCenter 8.6 to 9.1

Confidential

Technical Leader

Responsibilities:

• To enable the transformation and transfer of data from various publishers to SAD as per the requirements.
• To create, host and support Informatica web services for publishing of approved organization data to be consumed by various downstream applications across the organization.
• To customize the Medical SAD repository and provide enhancements to the customer applications by updating existing or developing new modules.
• Was responsible to get the Ada Rec ETL interfaces migrated into Informatica
• Creating documents such as Requirements and Design, Installation and Verification Instructions, Operational System Instructions and Standard Operation Procedures
• Responsible to develop and configure MDM Hub landing, stage cleanse mappings, matching, merging, Queries, Packages, BO objects, defining Business rules and validations and configuring the source systems trust
• Creating and configuring IDD Applications for the data Stewards.
• Testing and code review of the developed solution and documenting the test/review results.
• Providing process improvement features so that client can achieve financial targets with the usage of developed software applications and achieve customer satisfaction.

Confidential

ETL Developer

Responsibilities:

• Making Technical and Business Client Interaction to understand Technical and Functional aspect of requirements.
• Requirements gathering, analysis and coding.
• Developed various Informatica Mappings, Mapplets, and Transformations for Data Transformation using Informatica Designer
• Created User Defined Transformations and Mapplets for reusability of certain business logic. Oracle Procedures for processing data
• Created UNIX/Linux Scripts and other required codes.
• Was involved in monitoring, troubleshooting and recovery of workflows and sessions.
• Creating test cases, executing the tests, preparing the reports on the test results and fine-tuning the processes.
• Created various technical non-technical documentation.

Confidential

ETL Developer

Responsibilities:

• Client Interaction and Business interaction to understand Environment and Functional aspect of requirements.
• Requirement gathering, analysis and coding.
• Developing new ETL jobs for cleansing and processing the business data.
• Created UNIX/Linux Scripts and other required codes.
• Was involved in monitoring, troubleshooting and recovery of workflows and sessions.
• Creating test cases, executing the tests, preparing the reports on the test results, and fine-tuning the processes.
• Helped in creating the documentations.

Confidential

Online Training Consultant

Responsibilities:

• Was responsible for providing the Live Online Trainings to the Students across the world.
• Provided the trainings on the various technologies like SAP ABAP, SAP BI, SAP PI, SAP BASIS, Informatica, AB-Initio, BI Tools etc.