Randhir Rana

Results-driven Director of ERP at Murad - Unilever Prestige with expertise in business process reengineering and operational efficiency through Oracle ERP configuration. Proven track record in leading cross-functional teams and managing projects that implement advanced supply chain solutions. Strong team-building skills and strategic planning capabilities drive innovation and achieve organizational goals. Recognized for high productivity, effective communication, and adaptability in fast-paced environments.

• Functional Aspects (Purchasing, Inventory, BOM, Order Management, Advance Pricing, Work in Progress, Costing, Warehouse management system (Mobile interface), Advanced Supply Chain Planning (ASCP), Demantra, OPM, Production Scheduling (PS), Enterprise Asset Management (EAM), AP, AR, GL, Planning Cloud).
• Excellent hands on experience in APEX, ECC Power BI, Oracle Forms, Reports, Business intelligence Discoverer, XML Publisher, BI Publisher, Oracle Workflows, Oracle Applications 11i, AOL concepts (Alerts, Request set, profile, Menus and DFF), R12 concepts and hands on Demantra tables.
• Expertise in APIs, Loader scripts, Interfaces, Conversions, Customization (Custom Pll/Forms Personalization) in Oracle Applications.
• E-commerce Gateway inbound and outbound transactions.
• Comprehensive experience in Oracle Application Implementation and Support.
• Excellent in OracleSQL and PL/SQL programming.
• Hands of experience in Virtual Machines, Deploy a machine, EDI and Trinity data load.
• Expertise in generating scripts that assists in Implementation projects.
• Attitude to learn and adapts easily to situations.

• Implemented APEX and ECC Dashboard Reporting.
• Automate Item master life cycle.
• Implemented EMP portal, INTL PO Process.
• Enhanced GL/SL reconciliation process.
• Multiple oracle end to end Implementation.
• Application roll out to multiple countries.
• Automate 3PL order fulfillment process.
• Enhanced costing approval process.
• Implemented Inventory Allocation - Solution to meet inventory by minimizing the backorder situation and maximizing the fulfillment of Supply/demand on the bases of forecasting.
• Automate PO – AP fulfillment cycle.
• Amazon Fulfillment process, Rebranding And Advance Pricing Enhancement.
• Item Automation and Versioning - Solution to automate the inventory components by designing the B2B forms. Maintain inventory for multiple SKU versioning and fulfill on the bases of customers preferences.
• Order processing - Enhancements.
• Automate Procurement Cycle – ASCP to Procure to Pay.
• Implemented B2B portal for International Channels.
• Business User Training on Demantra, Real Time S&OP, ASCP and APCC.
• EDI Implementation and Order to cash Enhancements.
• Enhancements of Advance Supply Chain planning (ASCP).
• Upload and validate workflow with history data into Demantra.
• Implemented Collaborative Planning.
• Implemented Production Scheduling.
• DRR - Revenue Recognition Customization is the enhance in current functioning of the applications to recognize the revenue based on the actual delivery date of orders at customer location.
• R12 Master Data Extraction.

• Alshaya, Kuwait, 10/01/14, 11/01/14, Business user training on Demantra, Real Time S&OP, ASCP and APCC.
• Masco, U.S.A, 03/01/14, 10/01/14, Defined Plans (Constrain, Unconstraint) and customize parallel plans., EDI Implementation and Order to cash Enhancements., Enhancements of Advance Supply Chain planning., Taking Business requirements from the customers., Responsible for all technical development to meet business requirements., Conduct knowledge transfer session to client., Preparation of MD50, MD70 and MD120 Documents., Involved in Custom pll modifications, Forms personalization.
• Belkin, U.S.A, 01/01/14, 02/01/14, Implemented Collaborative Planning., Responsible for all technical development to meet business requirements., Conduct knowledge transfer session to client., Preparation of MD50, MD70 and MD120 Documents., Involved in creating/modifying Oracle Reports, Oracle Forms., Involved in Custom pll modifications, Forms personalization.
• IFFCO, SHARJAH, 10/01/13, 01/01/14, Implementing Oracle Production Scheduling., Understand Business requirement and provide the best feasibly solution., Responsible for all technical development to meet business requirements., Evolved in (to be) system and process flow testing., Preparation of MD50, MD70 and MD120 Documents.
• JR286, USA and CHINA, 09/01/11, 10/01/13, Visited Customer sites to China (Shenzhen and Hong Kong) for WMS (Inbound and Outbound process)., Visited factory suppliers and having exposure on live Supply chain cycle., Created XML and RDF reports along with the interfaces for P2P cycle., Involved in creating/modifying Oracle Reports, Oracle Forms., Involved in Custom pll modifications, Forms personalization., Responsible for smooth working of client environment with respect to the Order To cash cycle, O2C with respect to WMS (mobile interface), P2P and P2P with WMS integration and ASCP., Responsible for Item Upload, Customer Upload, and SO Upload PO uploads and load data on Demantra tables., Responsible for E-commerce gateway transactions (810, 850 and 856)., Defining new Trading partners, setting up profiles and new sites for customers., Responsible to support and maintain the code., Preparation of MD50, MD70 and MD120 Documents., Involved in Quality Audits.