Prasanna Kumar

About Prasanna Kumar

Certified RPA Developer with 4 years of experience in automation design and deployment…

Experience

1. Senior Rpa Consultant

   IBM

   May 2025 — Present · Bengaluru, IN

   Client : DOWUse Case Delivered 1: OTM Fall-Out ProcessThis automated solution is designed to process fall-out data from the OTM system and post it into SAP.Process description:• Validation of input data to ensure accuracy.• Automated posting of validated data into SAP.• Handling of both invoice and sub-debit scenarios.This use case represents a 1 FTE automation, effectively optimizing manual effort and reducing the risk of errors.Use case delivered 2: BPD Cancelled shipmentProcess description:Automated Data Extraction and Integration Using Power Automate, VBA, and SAP1.Download PDF using Power Automate:The process begins with automating the download of PDF documents through power automate.2.Extract Data from PDF using VBA:A VBA script is used to extract key information from the downloaded PDFs, including:•Purchase Order Number•Material Number•Order Number3.Retrieve and Update SAP Data:SAP is accessed to extract the following data for each material number:•Plant Code•Material Code•MOD CodeThis information is then mapped and updated in the output file accordingly.4.Identify Master Shipment PO Numbers:The process includes logic to determine whether a PO number corresponds to a master shipment.5.Extract Plant Code for Each Order Number:For every identified order number, the plant code is extracted from SAP and updated into the output file.

Education

• P.S.N.A. College of Engineering and Technology, Dindigul

  B.E

  2017 — 2021