Oracle Scm Functional Consultant
CurrentAs an Oracle SCM Functional Consultant at Allana Son's Private Limited, I specialized in optimizing Order to Cash (O2C), Inventory, and Procure to Pay (P2P) business cycles. I was responsible for analyzing, resolving, and enhancing day-to-day issues related to order management, providing production support, and implementing improvements.► Developed functionality to convert Blanket Sales Orders to Sales Orders using a streamlined CSV file upload process.► Managed and resolved issues related to advanced pricelists and month-end price uploads, ensuring accurate and timely updates.► Prepared over 50 functional documents, including MD-050 and TE-040, supporting seamless business operations.► Executed PL SQL queries for recurring data retrieval from the backend, improving data retrieval speed by 25%.► Provided Oracle R12 production support, enhancements, and developments, ensuring system reliability and efficiency.► Performed test cases related to O2C for process improvement, implementation, and patch purposes.► Created and modified reports using SQL and XML Publisher (e.g., Customer Aging, Open Sales Order Report).► Developed scripts for tasks such as disabling alerts, users, responsibilities, and concurrent programs in the system.► Created change requests (CR) and migrated them to production, conducting CPU patch testing.► Interacted with internal teams and users for requirements gathering, design, functional testing, and user training.► Led a team in resolving critical order management issues, reducing downtime by 40%.► Executed SQL queries to retrieve comprehensive delivery details, including creation and creator information.► Addressed issues with deliveries stuck at the shipped level due to insufficient inventory by running the shipping interface program.► Assisted with unassigned deliveries by coordinating with supervisors and performing necessary actions on their behalf.