NANDHAGOPAL P

Experienced in Oracle ASCP Planning Specialist with over 2 years of expertise in Oracle E-Business Suite (EBS), Oracle R12, and Oracle Applications. Proficient in developing and managing Oracle Reports, utilizing advanced SQL and PL/SQL for query optimization and data analysis. Skilled in leveraging Google Sheets for reporting and operational efficiency. Adept at planning processes and delivering data-driven solutions to enhance supply chain performance.

Implementation of ECO Dispositions in Oracle R12

• Implemented ECO (Engineering Change Order) dispositions for existing plants in Oracle R12 in ADRP (Advanced Distribution Requirements Planning), ensuring seamless integration and alignment with supply chain processes.
• Delivered solutions for various dispositions, including None and When Available, Min Build, and Mandatory Rework, optimizing planning and operational efficiency

Automated Manufacturer Details Retrieval and Email System

• Designed and developed a PL/SQL program to retrieve manufacturer details from the database based on client-specific requirements, automating the process of data extraction and email delivery to clients.

Implementation of new plant in Oracle R12

• Implemented a new plant in Oracle R12 by setting up planning processes with DRP (Distribution Requirements Planning) in R11i and ADRP in R12.
• Configured planning names in DRP and ADRP to support efficient supply chain operations.
• Reviewed and compared planned order results from DRP and ADRP to identify the best solution for the plant.
• Post migration to production, performed user support for first 6 weeks.

FTP to SFTP Conversion and Data Load Automation

• Converted FTP to SFTP (Secure File Transfer Protocol) connections for existing UNIX programs, enhancing security and efficiency.
• Automated the data load process, enabling secure transfer and seamless integration of data into the Oracle database from the server.