Mahesh Kumar

Technical Project Manager with overall 13+ years of experience in the field of ETL/Data-warehousing/Business Intelligence in Cloud/On-Premise. Coordinate with larger cross-functional teams to support implementation of data integration and data quality procedures, streamlining data management processes and providing access to data across the enterprise. Perform tasks independently as well as collaboratively with Global teams to ensure delivery of robust and End to End solutions. Good Knowledge of working in Waterfall, Agile Methodology (SCRUM) & Hybrid. Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation. Expertise in working with onshore-offshore model.

• Expertise in AWS in cloudwatch, monitoring dashboards, cost report generation and S3 bucket. Managing RDS database.
• Experience working on Informatica MDM and, Reltio MDM Informatica PIM Product 360, design, development, testing and performance management.
• Responsible for Business Entity Services Development (BES)
• Coordinate with larger cross-functional teams to support implementation of data integration and data quality procedures, streamlining data management processes and providing access to master data across the enterprise.
• Perform tasks independently as well as collaboratively with onshore and offshore teams to ensure delivery of robust and complete MDM solutions.
• Translate logical MDM data models into physical models, including related metadata, and configure the data model within MDM software
• Assist the MDM Architect in technical architecture design, development, and review. Assist the Data Analyst in performing data profiling and data quality analysis.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation, RealTimeIntergration with SOAP and Rest calls.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Identifying data quality issues that must be corrected in the source system, for e.g. incomplete names, out of format addresses, unwanted characters etc.
• Experienced in improving the data quality by eliminating the redundant data by using Informatica data quality.
• Effectively communicate with business, project manager and team members.

• Infosys Ltd, Ulta, 11/2019 - 09/2021, Technology Lead, Ulta Beauty, Inc., formerly known as Ulta Salon, Cosmetics & Fragrance Inc., is an American chain of beauty stores headquartered in Bolingbrook, Illinois. Ulta Beauty carries cosmetics and skincare brands, men's and women's fragrances, nail products, bath and body products, beauty tools and haircare products. Developed customer master data model for the ULTA and managed data from various source systems to obtain golden data further publishing to the downstream systems., Involved in the requirement gathering call daily and working accordingly on that., Arranging daily scrum calls as well and updating the team status to the client and involved in the development work to clear the hurdles as I worked as a Technical project manager., Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments., Have worked on requirement gathering and designing the system integration initially via batch process and in parallel the RealTime development was done to integrate the system with all the external applications., Owner and supporting of Realtime integration., Extensively worked on Hub development, BES development, Realtime development and designing the new incoming source data with MDM., Worked on upgrading real-time SOAP services to BES Rest calls.
• Tech Mahindra, GSK (mdm) and wss (Internal to coe), 03/2016 - 08/2017, Technology Lead, Developed POC for WSS Corporation and GSK with design and development right from the scratch and executed demo to the client. Prepared data for two source systems for all the tables and consolidated the data to get the golden records. Developed IDD screen for the end user to show the data and hierarchy of data for the end users., MDM installation configuration in cluster mode., Worked on Migration project from V9.7 to V10.1 and from V10.1 to V10.3., Worked with the clients directly at onshore to gather the business requirements., Responsible for the initial development design and projection, Ability to make technology decisions related to the Client MDM environment., Create Design Document and data models addressing business needs for the client MDM environment., Expertise in development of BO, Stage and landing tables with respective mappings., Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them., Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system., Interacted with various teams like database team application development team etc to facilitate Informatica MDM Hub Console development, Performed analysis, design, development maintenance and support activities associated with the database and data in support of multiple applications (including following standards/procedures to achieve integration of systems through database design)., Develop, optimize and support InformaticaPowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data, Define, configure and optimize various MDM processes including landing, staging, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM, Wrote test cases for unit testing and SIT testing ensure expected client data is getting published., Define, configure and optimize various MDM processes and stages including data ingestion/acquisition, standardization/enrichment, harmonization and data provisioning using MDM tools, Work with business and technical teams to properly define, document and align business requirements with technical solutions, Perform root cause analysis to identify system/data defects and determine proper course of action, Provide guidance on project and new development work, ensuring adherence to master data standards and strategy, Assist business teams with process understanding and training as required, Work with Master Data Governance (MDG) organization to identify, prioritize and schedule changes needed within the MDM application, Ensure changes and enhancements within the application are properly tested before deploying to production, Comprehensive understanding of Material, Customer and Vendor Domains as well as Business Rules and workflows within an MDM application, Ability to reconcile, enhance and recommend business process alignment with Data Management Organization (DMO) and Master Data Governance (MDG) requirements, Will gather business requirements, solution design with technical teams, and write functional specification documents, Develop and evolve Master Data Management services in partnership with our strategic vendors, Providing technical management for definition, estimation and delivery of data modeling, configuration and integration, Provide assistance to internal and external auditors as requested, Maintain corporate master data management policy and recommend changes to management as necessary, Develop and implement productivity metrics and reporting, Creating user stories for IT development and support effort, Configured and Installed Informatica MDM Hub, MRM Server, MRM Cleanse, MRM Resource Kit in Sandbox for doing a POC in Windows environment., Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-keyrelationships, lookups, query groups, queries/custom queries and packages., MDM Developer with experience in implementing, development, maintenance and troubleshooting on Informatica MDM solutions, data quality, data integration., Experience in Informatica MDM Hub, Hierarchy Manager, Informatica Data Director, designing of Cleanse functions and Match rules, MDM User Exits., Hands-on experience with Informatica MDM Hub configurations- Data Mappings (Landing, staging and base objects), Data validation, 'Match and Merge rules', customizing/configuring Informatica data director (IDD) applications., Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation, Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management., Evaluated and reported the progress of data quality improvement to the management and also provided data quality training and consulting services to Business and IT members in the organization, Involved in implementing the Land Process of loading the customer data set into Informatica MDM Hub that was coming from various source systems., Took development decisions by working with business users and enterprise architects to understand enterprise vision and direction., Hands on executing MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups., Designed, configured and tested Informatica Data Director (IDD) reports., Provided weekly status updates on progress, status and fatal errors in IDD., Led ETL team towards designing and development of extraction mappings for inbound source to MDM and then outbound MDM to consuming systems., Extensively used Informatica Data Quality to define the rules., Analyzed Informatica Data Quality rules for Data Intake process and documented technical defects coordinating with Application DBA to identify Data related issues in UAT.
• Zensar Technologies, Logitech, 02/2014 - 03/2016, Sr Software Engineer, Logitech is the worldwide leader in computer mice with products sold in almost every country in the world. The goal of this project is to extract Common data elements of all Logitech Products for the Customers from Different Source Systems Like Agile, EBS, BUPS, DRM, PMD, ZYME, GPOS and WWPDB load into a relational data model to allow for enterprise interactive reporting and analysis of quality related data., Created sessions and batches for incremental data load which would run daily., Responsible for Business Analysis and Requirements Collection., Working on the tickets related to unmerge, merge and updating data., Configured Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, query groups, packages and custom cleanse functions, Defined System Trust and Validation rules for base object column, Configured Search Strategy, Match rule sets, Match Columns for Match and Merge Process in improving data quality by match analysis, Created Queries, Query Groups and packages in MDM Hub Console, Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards, Schedule the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data., Assisted team members in on-support activities and trained them on all activities and happenings in the project., Resolved production issues within the defined SLA, performed root cause analysis of major issues., Scheduled and monitored jobs in production environment., Prepared status reports of the issues which helped client managers to get high level view of the issues.
• Accenture Services Pvt Ltd, AstraZeneca, 06/2012 - 01/2014, Senior Software Engineer, This project is related to health care domain using MDM tool. The configuration is done using Hub console and data is transferred to the client through IDD. This includes Informatica MDM 9.5. Here various types of cleanse lists and cleanse functions have been developed for the data quality purpose. Batch groups are done using pl/sql for running job using database., Understanding and Analyzing Requirements., Prepared tables as per the requirement and did mapping to the tables., Created packages and queries and maintained relationships between the tables., Based on the relationships maintained, created match/merge concept on the base table., Created Task in Siperian using BDD by calling SIF calls., The created Task can be assigned to any other user and it can be reassigned or delete or cancel or reject the assigned task., Testing of the Application.
• Bose Software services Pvt Ltd, 08/2010 - 06/2012, Software Engineer, This project is related to data management using Siperian tool. Later the data is directed through Business Data Director to client. Where client can check the details regarding the data related to particular entity. The Client requested requirements were done in Business Data Director to attain the data quality. LNMDM is database related project which includes Informatica MDM(Master Database Management) i.e., Siperian and BDD is used. In this project we will create the relations for different entities and I have worked with one entity i.e., ALF module has successfully completed and tested in BDD console as well., Understanding and Analyzing Requirements., Prepared tables as per the requirement and did mapping to the tables., Created packages and queries and maintained relationships between the tables., Based on the relationships maintained, created match/merge concept on the base table., Created Task in Siperian using BDD by calling SIF calls., The created Task can be assigned to any other user and it can be reassigned or delete or cancel or reject the assigned task., Testing of the Application.