Management Service
Resume:
SRI RAMA SUNIL
Senior Oracle SCM Functional Consultant
732-***-*****2984
PROFILE:
* ***** ** ********** ** Oracle Applications
SUMMARY:
* ***** ** ********** ** Oracle Supply Chain Functional Consultant involving in Implementation, Upgrade & Production Support in 11i &R12.
Strong experience in Oracle Applications encompassing Requirement Analysis, Process Mapping, GAP Analysis, System Configuration, Functional Specification for Customizations and User Training.
Good knowledge on Order to Cash (O2C), Procure to Pay (P2P) cycle.
Proficient in Oracle Application Modules- Inventory, Cost Management, Purchasing, Oracle Approval Management(AME), Service Procurement, Landed Cost Management, Order Management, Advanced Pricing, Shipping Execution.
Good Knowledge on iProcurement, iSupplier Portal and Sourcing modules.
Basic Knowledge in BOM, WIP, General Ledger, Accounts Receivables & Accounts Payables modules.
Good experience in designing Third Party Interfaces.
Experience in ‘Data Cleansing’ activity for implementation projects.
Used AIM implementation methodology for all project documentation.
Good knowledge on base tables and proficient in executing SQL queries and able to write/interpret statements for tables.
Experience in SLA management and working with Service Management Tool.
Responsible for developing and adhering to engagement team project standards to ensure the delivery of quality client deliverables.
Worked for US and MEA clients on multiple projects in Retail, Healthcare and Manufacturing.
Assist, coach, and mentor other engagement team members on issues they may encounter in implementation, Custom Development and Support.
Proficient working with Oracle Support, creating and following up on SRs. Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
Coordinating the activities between the on-shore functional team and the Off-shore technical team.
Possess excellent interpersonal, communication and presentation skills.
Highly effective management and organizational skills with the ability to prioritize.
Dedicated and Self-motivate team player/builder with good leadership, communication, interpersonal and problem-Solving skills.
EDUCATION:
Bachelor of Engineering (B.E) from Anna University.
TECHNICAL SKILLS:
Business Domain
Retail, Health Care, Manufacturing
ERP
Oracle E-Business Suite – Inventory, Cost Management, Purchasing, BOM, WIP, iProcurement, iSupplier Portal, Sourcing, Services Procurement, Oracle Approval Management(AME), Landed Cost Management, Order Management, Advance Pricing, Shipping Execution, General Ledger, Account Receivables and Account Payables.
RDBMS
Oracle 11g
Tools
Toad, SQL Plus, UPK
Configuration Management
VSS
Operating Systems
Windows, Linux and DOS
PROFESSIONAL EXPERIENCE:
Genpak, NY Jan’15-Tilldate
Senior Oracle SCM Functional Consultant
Genpak has been the industry leader for manufacturing quality food packaging in premium quality, single use food packaging products. Involved in Production Support.
Responsibilities:
Solved issues related to Receiving, Purchase Order, Sales order, Auto invoice and WIP etc.
Maintenance of issue logs at each stage and their resolution is been documented.
Developed the process for streamlining and automating standard cost updates for the purchased items and copy the assembly cost across all inventory organizations to reduce the manual intervention. This is a complex process to identify and copy the cost components across the inventory organizations based on item characteristics and BOMs.
Updated functional Design Documents based on time to time changes and processing those changes to the development team for incorporation of such changes.
Created service request (SR) with Oracle support for resolving bugs and issues during the course of the project.
Environment: Inventory, BOM, WIP, Purchasing and Order Management modules, Linux4 x86-64 and Oracle EBS 11.5.10.2.
ThyssenKrupp Elevators, GA Dec’13–Dec’14
Senior Oracle SCM Functional Consultant
ThyssenKrupp Elevator is one of the world's leading elevator companies. The product range comprises passenger and freight elevators, escalators and moving walks, chair and platform lifts, passenger boarding bridges and quality service for the entire product range. Involved in Production Support.
Responsibilities:
Prepared functional design document (MD.050) for custom requirements.
Setup done related to Bi-Weekly Cycle count entries generation.
Setup done on Modifiers, Formulas, and Attribute Management.
Interacted with Oracle to prioritize the SRs in month end activities.
Passed Information To Techies For Data Fixes Which Mandates For Service Request.
Suggested proper work around wherever required and recommended business need for the same.
Environment: Inventory, Purchasing, Oracle Approval Management(AME), Advanced pricing and Order Management modules.Linux5x86-64 and Oracle EBS R12.1.3.
Hamad Medical Corporation, Qatar Sep’11-Nov’13
Senior Oracle SCM Functional Consultant
Hamad Medical Corporation (HMC) is the premier non-profit healthcare provider in Qatar. It was established by Emiri decree in 1979 and reports to the Supreme Council of Health. Since its establishment, HMC has rapidly developed medical facilities capable of providing state-of-the-art diagnosis and treatment of diseases that previously could only be managed in overseas medical institutions. Involved in Implementation, User training and part of production support team.
Responsibilities:
Assessed the fit of standard application and system features to detailed business requirements.
Responsible for organizing ‘AS-IS’ study, designing ‘To-Be’ processes and carrying out ‘Gap Analysis’ before configuring the application.
Prepared functional design documents for requirement gathering, customizations and all other needed in the project. (CR.010, RD.050, BR.100, TE.040, DO.070, and MD 050).
Responsible for ‘Data Cleansing’ activity for Inventory and Order Management modules.
Customized ‘Purchasing Account Generator Workflow’ for purchase & internal requisitions as per client requirement.
Gave user training to large group of end users in Inventory, iProcurement and Order Management.
Configured AME for Purchase requisitions.
Set up of Pricelist, Modifiers, API (cst_cost_api.get_item_Cost), Formulas, and Attribute Management.
Prepared UPK video for iProcurement business flows.
Prepared functional design documents (MD 050) to integrate Internal Requisition, Sales Order and Shipping details from Third party systems.
Constant monitoring of the ticketing system in order to respond to the queries which are categorized as per their severity as reported by the end users.
Updating and responding to the tickets as per SLA.
Review and analyze the program outputs and performance indicators to locate the code problems and correct errors by correcting codes.
Preparing weekly and monthly status report and discussing with the managers about ticket allocation in order to achieve their timely closure.
Raise, follow and timely close the SRs whenever required.
Environment: Inventory, iProcurement, Oracle Approval Management(AME), Order Management and Advanced Pricing modules. Linux5 x86-64 and Oracle EBS R12.1.3.
Alkoot Insurance & Re-Insurance Co, Qatar Jan’10-Aug’11
Oracle SCM Functional Consultant
Alkoot Insurance & Reinsurance Co is an insurance company incorporated in 2003 as Subsidiary to Qatar Petroleum. To provide a host of insurance solutions for QP & QP group of companies to cover for all onshore/offshore project activities.Involved in Implementation, User training and part of production support team.
Responsibilities:
Assessed the fit of standard application and system features to detailed business requirements.
Responsible for organizing ‘AS-IS’ study, designing ‘To-Be’ processes and carrying out ‘Gap Analysis’ before configuring the application.
Prepared functional design documents for requirement gathering, customizations and all other needed in the project. (CR.010, RD.050, BR.100, TE.040, DO.070, and MD 050).
Kick off, Requirement Gathering, Conduction CRP, Gap Fitment Analysis, User Training, User Acceptance Test, Go Live and Post Production Support
Performed all functional setups in CRP, UAT and Production instances.
Setup in INV (Inventory) the item categories, category sets, item template and catalog groups.
In PO (Oracle Purchasing) module setup Buyers, Suppliers, Financial options, purchasing options, receiving Options, Approval Hierarchy, Document Types, Line types.
Conducted and Involved in review meetings with Client for smooth completion of the project on time.
Used the hands-on practical approach for training which enhanced the knowledge and understanding of the users.
Created service request (SR) with Oracle support for resolving bugs and issues during the course of the project.
Environment: Shared Inventory, Purchasing, Oracle Approval Management(AME) and Services Procurement modules. Linux5 x86-64 and Oracle EBS R12.1.1.
Copycat Limited, Nairobi, Kenya Jul’08– Dec’09
Oracle Associate SCM Functional Consultant
The Copycat Limited was established in 1984 as an Office Automation outfit. The Company began its IT operations in 1992 and quickly expanded to include a wide range of IT services covering a broad spectrum of solutions and System Integration. Steady growth and Expansion has seen Copy Cat emerge as the leading IT Systems Integrator within the East Africa. Involved in Upgrade, Implementation, and User training and post-production support team.This includes study of the existing processes and custom development for smooth Upgrade.
Responsibilities:
Implementation of LCM and iteration testing for Inventory, Purchasing, OM modules.
Prepared functional design documents for LCM module for requirement gathering and customizations (CR.010, RD.050, BR.100, TE.040, DO.070, and MD 050).
Kick off, Requirement Gathering, Conduction CRP, Gap Fitment Analysis, User Training, User Acceptance Test, Go Live and Post Production Support.
Performed all functional setups in CRP, UAT and Production instances as Pre- receiving Application in LCM module.
Created service request (SR) with Oracle support for resolving bugs and issues during the course of the project.
Trained end users with common processes involved in day-to-day business in LCM.
Trained end users with new R12 features in the modules INV, PO and OM.
Set up done for Drop Shipment, Gross Margin calculation and Sales Quote Approvals.
Environment: Inventory, Purchasing, UAT, Order Management and Landed Cost Management modules. Linux5 x86-64 and Oracle EBS R12.1.1.
Tadmur Holdings, Qatar Aug’07 – Jun’08
Oracle Associate SCM Functional Consultant
Tadmur Trading is the premier supplier of products and services to the construction and associated infrastructure sector in Qatar. Involved in Rollout and Production Support.
Responsibilities:
Prepared functional design document (MD.050) for Sales Order Approval and other Custom Objects.
Given recommendations on Planning and Accuracy methods to enhance the business process.
Passed Information To Techies For Data Fixes Which Mandates For Service Request.
Setup done for Rollout on INV and OM modules.
Environment: Inventory, Purchasing and Order Management modules. Linux4 x86-64 and Oracle EBS R11.5.0.2.
Contact this candidate