SAP
Katakamsetty Venkata Jaganmohan
Master Data Analyst
Hyderabad
Summary
Dynamic and accomplished professional offering 10 years of experience in SAP Master Data Maintenance and Master Data Governance (MDG) Master Data guardian, attention to detail, and excellent organizational skills. Desire any challenging role in Master Data Management and MDG domain To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
10
10
years of professional experience
Work History
CTO Supervisor
PepsiCo Global Business Services India LLP
12.2021 - Current
- Enabling the STIBO PIM Trade Item configuration in MDM
- Configuring Master data governance solution in Teradata MDM
- Gathering business requirements and discovering the gaps in different markets
- Functional Mapping between the systems source and Target systems
- Identifying data issues and applying Governance solutions in PIM across the markets
- Map client business requirements, processes, and objectives
- Document functional designs, End Testing, and results
- Provide consulting services on Implementation, Rollouts, and support projects
- New Functional Mapping Document Design
- Design the Rule-based workflow for all the markets
- Supported Pre-Post-load validation activities before and after the Data load as part of Conversion
- Sharp resolution of the Defects & Incidents raised by the Business during the SIT and UAT phase of the project.
- Collaborated with colleagues to develop innovative solutions to complex problems, driving successful outcomes for multiple projects simultaneously.
- Led master data governance initiatives, establishing policies and procedures to maintain data integrity.
- Facilitated communication between IT and business units to address master data issues promptly and effectively.
- Served as subject matter expert on master data standards, providing guidance to stakeholders throughout the organization.
- Assisted in the migration of legacy systems to new platforms while preserving historical information accuracy.
- Collaborated with cross-functional teams to ensure consistent and accurate master data across systems.
- Developed customized reports for senior management, enabling informed decision-making based on accurate master data insights.
- Reduced manual effort by automating key processes related to master data maintenance and updates.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Created and automated data visualizations to present insights and tell compelling stories.
- Compiled, cleaned and manipulated data for proper handling.
- Developed reusable Teradata components that could be easily adapted for use in multiple projects, reducing development time and fostering a more modular approach to database design.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
- Designed and developed analytical data structures.
- Tested functional compliance of company products.
- Served as a subject matter expert on all aspects of master data management within the organization, providing guidance on best practices as needed.
- Improved overall data quality with consistent monitoring, validation, and correction efforts.
- Implemented randomized sampling techniques for optimized surveys.
Master Data Analyst
Crafsol Technology Solutions Pvt Ltd
02.2020 - 11.2021
- Map client business requirements, processes, and objectives
- Developed customized reports for senior management, enabling informed decision-making based on accurate master data insights.
- Identify gaps, and issues, and work around solutions
- Document functional designs, test cases, and results
- Provide consulting services on Implementation, Rollouts, and support projects
- Material Code Creation/Extension/Modification (Packing, Semi-Packing, Finished, Semi-Finished, and all other Material types) in ECC 7.0
- Vendor & Customer Code Creation/Extension/Modification
- Creation and Maintenance of Discount, Pricing, and Promotion condition records
- Creation of Assets, Cost Centre, and extension of the GL at Company codes based on BU User requests
- Pricing includes Condition types, Access sequences, Pricing procedures and Condition tables
- Using Bulk data upload techniques like LSMW for mass upload requirements
- Updating/Changing the Master data by following the MDM-defined rules and governing procedures and considering the data change requests from BU users
- PR, PO Creation, and resolving the SAP errors while raising PR/PO from SAP MDM point of view
- Timely reports and duplicate checking activities and resolving the MDM-related errors faced by BU users during P2P
- Extensively Support the Master data Projects (Go-To-Market) by performing various activities Data Cleansing, Data Uploading, Data Maintain, Data Validation based on business requirements for Project
- Co-ordination with the Business and Technical Team in creating programs for mass upload of Master data and transaction data related
- Preparing the Data Validation rules and maintaining them in MDM
- Customer Hierarchy Maintenance
- Material PH Code Creation
- And engaged in proposing Custom solutions to the clients to meet the business requirements across the client base
- Support on Field issues related to SAP
- SAP Implementation: Project: Go-To-Market Customer and material Data cleansing as per the Project requirement
- Data Migration from legacy system and Uploading to SAP using LSMW
- Mass maintenance of master data
- Coordinating with end users and understanding user requirements to develop new processes in the system
- Coordination with business to develop the Master data upload solution
- Data upload template preparation
- Preparation of Weekly Status Report to analyse the progress of the project
- Go-Live Activities and Post-Go-Live Activities
- End User training on the introduction of new master data objects (New Price conditions, Visit Plan, Promotions, Discounts) Preparation of End user manual and Supporting documents.
- Led master data governance initiatives, establishing policies and procedures to maintain data integrity.
- Facilitated communication between IT and business units to address master data issues promptly and effectively.
- Aligned company-wide departments through standardized nomenclature, hierarchies, attributes, taxonomies within all master data domains.
- Streamlined data management processes for increased efficiency and reduced errors.
- Assisted in the migration of legacy systems to new platforms while preserving historical information accuracy.
- Collaborated with cross-functional teams to ensure consistent and accurate master data across systems.
Master Data Consultant
Genpact Inc
09.2019 - 02.2020
- Performed root cause analysis on recurring issues affecting the integrity of master data assets, devising appropriate remediation measures to address them effectively.
- Managed migration projects involving the transfer of vast quantities of critical enterprise-level datasets between different storage platforms or formats without loss or corruption incidents occurring during transit.
- Championed a company-wide culture of data-driven decision-making by promoting awareness and understanding of the importance of accurate, reliable master data assets.
- Developed customized master data solutions for clients, resulting in improved business decision-making capabilities.
- Worked with multiple screens and programs to resolve customer issues.
- Located and corrected data entry errors and reported to management.
- Employed SQL to query databases and retrieve data.
- Updated and maintained customer information, documents and records.
- Analyzed current data records to provide detailed reports.
Material Data Analyst
PiLog India Pvt Ltd
05.2014 - 09.2019
- Worked on the SAP S/4 HANA Data Upload Support
- Extract and Collect the Data from the SAP ECC and upload it into the Data Cleansing tool MDPM
- Performing the Data Cleansing and data analysis
- Run the Duplicate report and assign the Master code
- Assign the HSN & UNSPSC Codes
- Data Upload to MDRM tool interfaced with SAP through SQL
- Worked on Material code Unification Project
- Understanding the project scope and adhering to the work execution of the plan, deliverables timely
- Enriching the material PO text by data collection through Web and physical Verification
- Upload the collected data in MDRM (Master Data Governance tool) by validating the Physical verification data for the existing Master data
- Timely extraction and analysis of Duplicate reports for all Vedanta Power and Aluminium Business Units (Unified Master Data)
- Identifying the Duplicates and providing the Master Code to be used further and suggesting blocking the rest of the Duplicate superseded Material codes.
- Integrated information from multiple data sources, solved common transformation problems and resolved data cleansing and quality issues.
- Improved data quality by implementing ETL processes and data cleansing techniques.
- Monitored and managed data cleansing requirements and data conversion initiatives.
- Improved data quality by implementing stringent validation processes and enhanced data cleansing techniques.
- Improved data accuracy by implementing advanced data cleansing and validation techniques.
- Implemented data cleansing processes to maintain high-quality records within databases.
- Optimized data quality for improved customer insights through thorough analysis and data cleansing initiatives.
- Enhanced data accuracy by implementing validation rules and data cleansing procedures.
- Enhanced data accuracy by implementing advanced data cleansing and validation techniques.
- Improved data accuracy by conducting thorough data cleansing and validation processes.
- Enhanced data accuracy by conducting thorough data cleansing and validation processes.
- Collaborated closely with IT support teams to troubleshoot system issues impacting data integrity or availability.
- Implemented quality control measures for consistent data collection, minimizing errors in the research process.
- Collaborated with team members to ensure accurate, timely completion of data control tasks.
- Optimized data quality by conducting thorough data validation and cleansing procedures.
- Leveraged advanced Excel skills to efficiently manipulate large datasets for meaningful analysis and presentation purposes.
- Resolved data discrepancies by identifying root causes and implementing corrective actions.
- Enhanced overall data integrity with regular audits and updates to maintain accurate information.
Education
B. Tech - Mechanical Engineering
Guntur Engineering College
Skills
- Data Cleaning
- Advanced Excel
- SQL Expertise
- Data Validation
- Data Quality Management
- Data Governance
Disclaimer
I now declare that the details furnished above are true and to the best of my knowledge and I bear responsibility for the correctness of the above-mentioned.
Software
Teradata
Timeline
CTO Supervisor
PepsiCo Global Business Services India LLP
12.2021 - Current
Master Data Analyst
Crafsol Technology Solutions Pvt Ltd
02.2020 - 11.2021
Master Data Consultant
Genpact Inc
09.2019 - 02.2020
Material Data Analyst
PiLog India Pvt Ltd
05.2014 - 09.2019
B. Tech - Mechanical Engineering
Guntur Engineering College
Similar Profiles
Anirudh JhawarAnirudh Jhawar
Manager – FP&A (Contract & Trade Spend) at Pepsico Global Business Services India LLPManager – FP&A (Contract & Trade Spend) at Pepsico Global Business Services India LLP
Rakshith BhatRakshith Bhat
Manager - HR Transformation Projects at PepsiCo Global Business Services India LLPManager - HR Transformation Projects at PepsiCo Global Business Services India LLP
Animesh NishantAnimesh Nishant
Finance Senior Coodinator at PepsiCo Global Business Services India LLPFinance Senior Coodinator at PepsiCo Global Business Services India LLP