Pampapathi Patil

Client: Occidental Petroleum (OXY), Mukhaizna oil field, Oman,
ERP Tool: SAP S/4HANA, Oracle E-Business Suit R12

• Responsible for material cataloguing, storage location extensions, and inventory control.
• Perform Goods Receipt (GR), Goods Issue (GI), Transfer Posting (TP), and stock transfers (Intra/Inter STO).
• Manage daily SAP transactions (MIGO, MMBE, LS01N, LX02, LT10, VL02N, etc.).
• Prepare and manage reports: Surplus Usage, Material Reservation, Daily & Weekly Inventory, and Audit Reports.
• Conduct quarterly and annual physical stock audits and reconciliation.
• Update and maintain material master data using SAP MDG (NWBC).

• Project Name: of the ERP system from Maximo to SAP.
• (1) Data cleaning, standardization, and enrichment are all part of the project
scope. (2) Convert OEM to OCM. (3) Physical verification and enrichment.
• Working on-site at the clients ADNOC for data cleansing, enrichment, physical
verification, and converting OEM to OCM for procurement data/PO description.
• Data cleansing: Structuring, validating, enriching, standardizing the short and PO
descriptions as well as eliminating duplicates.
1. Create the material, then assign the appropriate noun/modifier.
2. Populate attribute values as per the source data/input PO data
(mandatory/optional).
3. Enrich the data such as capturing missing attribute values from (manufacturer
catalogs, data sheets, SPIR sheets, drawings, PO, web search, physical walkdown
etc.) or validate the existing data.
4. Standardize attribute values.
5. Capture and standardize the reference data such as part details (part number,
model number, drawing number) and equipment details (such as OEM part
number/model/serial no/tag number/drawing no/position number etc.).
6. Identification of OEM, OCM and checking the possibility of converting OEM to
OCM.
7. Generate a consistent long and short description.
8. Identification of the duplicate materials

Clients: ADNOC Onshore & NPCC | ERP Tools: Pilog MDPM, MDRM, Oracle R12
• Led data cleaning, standardization, and enrichment as part of ERP migration from Maximo to SAP.
• Performed OEM to OCM conversion, physical verification, and validation of procurement data.
• Generated consistent short and long descriptions, and eliminated duplicate materials.
• Ensured accurate mapping of material attributes, manufacturer details, and specifications.

Client: Brakes India Pvt Ltd (Chennai), ERP Tool: ORACLE R12, SAP MM
• Worked for the client Brakes India on Material Master Data Management.
• Material master data creation, material description changes, and flagging
materials for inactivation.
• Data Cleansing, data enrichment using UNSPSC taxonomy.
• Data enrichment by manual sourcing i.e., by web search or contacting the
supplier for additional data, ensuring supplier data tightly aligned, reducing
purchasing error.
• Decide target data Structures (Noun/Modifier/Attribute structures).
• Generate short and long descriptions.
• Continuously improving master data by eliminating duplicates.
• Preparing daily, monthly, and yearly report.
• Inventory cycle count before audit so that material count must align with system
count.
•

• Led data cleaning, standardization, and enrichment as part of ERP migration from Maximo to SAP.
• Performed OEM to OCM conversion, physical verification, and validation of procurement data.
• Generated consistent short and long descriptions, and eliminated duplicate materials.
• Ensured accurate mapping of material attributes, manufacturer details, and specifications.

Client: Syngenta, ERP Tools: SAP BODS
• Project Name: SAP MDM Implementation for Commercial Identity.
• Build SQL queries to identify erroneous data and discover a possible solution for
the client.
• Defined code development approach for Global Data Cleansing - 1. Data
Standardization and Enrichment (DSE) 2. Error Record Identification (ERI) 3.
Health Check Analysis (HCA). Similar approach will be followed for Argentina, Italy
and France post Global data cleansing.
• Used SAP BODS ETL Transformations like Query, Merge, Validation, Table
Comparison, Data Cleanse Transform, and Match for de-duplication and custom
functions for developers.
• After enriching data, the developed ETL code identifies error records specially
nulls in mandatory columns and then it will perform health check analysis of data
for example if the title is populated it should have a name.
• Used ETL code, import-export to migrate code from Development to Testing
environment.
• Conducting unit test cases (UTC) on Extract and Transformation objects that have
been created or modified using SQL scripts.

• Developed ETL transformations (Data Cleanse, Validation, Match, Merge) for global data cleansing.
• Conducted Health Check Analysis and implemented Error Record Identification (ERI) framework.
• Performed data migration between development and testing environments using SAP BODS.

tool: Team Center, Siemens PLM, Navetti PricePoint, SAP MM
• Worked in client location in Sanvik India for short term project.
• Classification of materials from class level to family level using all possibilities like
unit price, material, where it is used, weight and so on using PLM Team Center &
Navetti Price point.
• Analyzing materials along with price.
• Gathering information from SAP ECC.

• Distributing the work to complete team & handling the team.
• Providing clarification of material for productivity through domain knowledge &
industry experience.
• Understanding customer expectations & delivering on time with quality.
• Data Audit, Data Classification, Data Cleansing, Data Enrichment and Data
Validation.
• Strong knowledge of analyzing & classifying materials, UNSPSC Coding.
• Material input, analyzing by de-duplication, sourcing & allocation.
• Data enrichment using the Catalogue, Data Sheet, Website.
• Cataloguing into structured data as per approved template by client.
• Checking the completeness and accuracy of the PO data/short/Long description.

• Supervised data teams and distributed workloads for MRO material cataloguing.
• Conducted data audit, classification, enrichment, and de-duplication using UNSPSC taxonomy.
• Delivered client-verified structured catalogs to improve procurement efficiency.

• Data Audit, Data Classification, Data Cleansing, Data Enrichment and Data
Validation for MRO products.
• Data audit to estimate the data problem in the system like duplicates & coding
error.
• De-duplication.
• Normalization & enable ERP, EAM & SAP system.
• Data enrichment by collecting all possible critical product information by web
search.

• Executed data audit, validation, enrichment, and
standardization for MRO materials.
• Normalized and enabled data for ERP/EAM/SAP systems.
• Improved data accuracy by identifying duplicates and coding errors.