Oracle Apps SCM Distribution / OTC Functional

Mahesh Hegde

*********@*****.***

Cell Phone# 973-***-****

Have 15 years of experience of which 10 years is in Oracle Applications, worked both as a functional and technical lead for the installation, conversion and set up of Oracle Distribution/ Supply chain / Financial applications. Experience includes managing projects using Oracle’s AIM methodologies, at local and international levels. Has broad experience in all phases of design, development and implementation of Purchasing, Payables, OM, Advanced Pricing, AR, Workflow, Inventory, EDI, GL, Service Contracts, System Administration and MultiOrg environment. Also have broad experience with Oracle Application’s technical architecture and Oracle tools. Experienced in Pl/Sql, Sql*Plus, Workflow, Forms and Reports.. Experienced in all phase of Project Implementation on both Functional and Technical activity. Completed multiple full lifecycle implementations in PO, AR, AP, GL, OM, Advanced Pricing, INV, EDI modules. Proficient in Data conversion and Integration. I am adept to facilitating sessions defining user requirements, developing and delivering end-user training. Havw Good experience on Order to Cash, Procure to Pay Business flows.

R12 SCM Certified

Professional Experience

Oracle Corporation – May 2006 – June 2009

Oracle SCM ImplementationVersion 11.5.10Sun Micro SystemsSept 2008 –Oct – 2008AndMar 2009 –May – 2009 · Advanced Pricing / Inventory / Order Management/ and AR: · Lead the RICE components related to advanced pricing and its integration with service contracts, Quoting and OM. · Set up Price lists, Multicurrency Conversion Setup, Modifiers, Qualifiers, Formulas, Pricing AttributesFactor Lists · Lead the cross functional teams in developing the extension that included multiple modules (Quoting/ OM/ EDI/ Pricing/ APC/ Service Contracts)· Determined and negotaited the deliverables and delivery schedule with the client· Directed the activities of the team supporting the project post implementation.· Lead the business critical extension to generate price lists using APIs for communicating the prices to the distributors globally. · Worked on customer comnersion from legacy to Oracle 11i system· Designed the AR invoice import interface· Proactively resolved issues and escalations and reported status to the management.· Worked on cut over activities related to the RICE components· Designed the Modifier conversion from legacy to Oracle Apps· Monitored the progress of the team; managed scope by identifying changes; estimated the impact to project schedule and recommended resolution.· Managed project progress against schedule, proactively resolving problems and reported status to the management.· Involved in requirement gathering sessions, worked on BR100, BR30, MD50 and MD70 documents.

Oracle SCM ImplementationVersion 11.5.10Cox CommunicationsJan 2009 –Feb - 2009 · OM, AR, Purchasing, Payables and Inventory · Designed the Requisitions Interface· Set Up Locations Suninventories · Set up the internal Order flow · Developed the TE40 for internal orders and conducted unit testing· Set up Customers Order Types and Line Types Document SequencePrice listsRelease Sequence RulesPick Release RulesPick Slip Grouping RulesShip Confirm Rules· Conducted the unit testing for complete Internal order flow· Designed the RMA interface to external system· Set Up Value Sets, DFF and Lookups· Worked on BR100, TE40 and MD50 documents.

Oracle SCM ImplementationVersion R12Dell ComputersOct 2008 –Nov - 2008 · Inventory, Product Information Management· Worked on planning the tasks and assigned and directed the activities of the team.· Participated in a cross-functional projects activities, co-ordinated the tasks to maintain the seamless integration of the application with other systems· Designed the Item Category assignment interface based on the custom business rules using the API EGO_ITEM_PUB. · Worked on Inventory Item Open Interface for bringing in the items into Inventory· Designed the outbound interface for Informatica team that extracts Item category assignments and Product attributes from PIM (Product Information Management System)· Designed the outbound interface for Informatica team that extracts Items that do not have categories assigned for a given category set category assignments · Designed the outbound interface for Informatica team that extracts leaf nodes of the category hierarchy in a given category set· Successfully handled the functional and technical issues, communicated with senior management, resolved conflicts that arose and recommended the optimal approach

Oracle SCM ImplementationVersion 11.5.9SymantecJan 2004 – May 2006 · Order Management, AR, Purchasing, Advanced Pricing, EDI· Conducted requirement gathering sessions, consolidated the requirements from US, EMEA and JPAC for a contract, OM and Pricing modules. · Planned the tasks, scheduled and monitored project work with respect to project scope and timing requirements.· Worked on future business process flow, identified the gaps and suggested the resolution· Lead the functional design and got the business sign off on that, · Reviewed the technical design· Configured dev and test instance for development and user testing.· Documented test scripts for user testing. Helped PMO with user training documentation.· Worked on the Order Import API to do custom validations· Lead solutioning sessions with the technical team and cross track teams.· Advanced Pricing: · Responsible for analyzing the business requirements defining the scope and planning the deliverables· Developed functional design document. Worked on future business process flow. Configured dev and test instance for user testing. Documented test scripts for user testing.. · Conducted CRP with the key users· Worked with the cross functional teams to ensure the end-to-end solution works.· Ensured technical stability, timely support and successful integration of enhancements.· Purchasing, Workflow· Designed the customization of PO approval Workflow· OM, Workflow, AR: · Analyzed the business requirements for an application that automatically creates repetitive billing. · Designed the OM Workflow, Process Order API to create order lines· Executed CRP with the key users. · Documented test scripts for user testing. · Conducted functional testing· OM, EDI, and Trade Compliance: · Analyzed the business requirements for Trade compliance (Export compliance). · Worked on functional design for EDI order import, Customer creation using seeded API’s. · Conducted functional testing· Worked on the Order Hold for placing the order on hold· System Administrator: Documented user matrix and created Custom menu and Responsibility and Report group and Report set and Concurrent program and Executable for the custom programs.

Rapidigm Inc – October 2001 – January 2004

Oracle SCM ImplementationVersion 11.5.7 / 11.5.5AlcoaOct 2001 –Jan 2004 · OM, AP, AR, Workflow, Shipping and Inventory: Worked on functional and technical design that enabled booking the orders from one Org and Shipping it from another Org. Used Oracle AIM Documentation. Developed custom workflow. Executed CRP with the key users.· Purchasing: Designed the customization of PO printing report and Requisition Import interface· OM, Workflow and Shipping: Worked on technical design and developed a customization that prints the shipping documents after ship confirmation and repricing are done. Used Oracle AIM Documentation. Developed custom workflow. · OM, Workflow: Worked on technical design for COGS account generator workflow customization. Developed the custom workflow. Used Oracle AIM Documentation.· OM, Inventory: Worked on technical design and developed a solution that enabled automatic loading of attachments for an order using a cross-referenced item. Oracle AIM Documentation.

IGate/Mastech Corp – June 1998 – October 2001

Oracle SCM ImplementationVersion 11.5.5 UtilitiesSuntory Water GroupJan 2001 –Oct 2001 · Inventory: Worked on technical design and developed Customer Item cross-reference upload program. Used Oracle AIM Documentation. · Inventory: Worked on technical design and developed Item – Subinventory assignment upload program. Used Oracle AIM Documentation.· Receivables: Worked on a project to bring the customer info from the existing system into the Oracle 11i TCA

Oracle Purchasing ImplementationVersion 11.0.3ManufacturingGE Power SystemsDec 199 –Jan 2000 · PO: Developed and tested an Interface and SQL*Loader Script to load the Requisitions into Staging and Interface table and move to Production.· PO: Developed and tested an Interface that extracts POs from the Oracle system to an external system. · PO: Worked as a production support resource· PO: Analyzed and developed spec for Custom error correction form at staging table for correcting the error records for Requisitions.· System Administrator: Created Custom menu, Report group, Report set, Concurrent program and Executable for the custom programs. · Menu Customizations: Modified menus for Purchasing.

Oracle Purchasing, Inventory, AP and GL ADPJan 1999 –Nov - 1999 · PO: Designed and tested an Interface that extracts Vendor information from the Oracle system to an external system.· Inventory: Designed and tested an Interface that extracts Item information from the Oracle system to an external system.· Inventory: Designed and tested an Interface that extracts Item Category information from the Oracle system to an external system.· PO: Designed and tested PO printing report.· AP: Designed and tested an Interface to load the AP Invoices into Staging and Interface table, validate and finally import.· GL: Designed and tested an Interface to load the GL journals into Staging and Interface table, validate and finally import.

Skills Summary

Oracle Applications R12 Certified · Oracle Order Management· Oracle Advanced Pricing· Oracle Purchasing· Oracle Shipping· Oracle Inventory· Service Contracts· Product Information Management · Oracle Workflow· Oracle Receivables· Oracle Payanles· Oracle General Ledger· System Administration·

Databases · Oracle RDBMS 9i, 8i, 7x

Hardware & Operating Systems · Windows NT· Windows 2000 · HP-UX (10.01, 9.4)· Red Hat Linux· Sun Solaris (2.4, 2.3)

Programming Languages & Tools · SQL PLUS· SQL*Loader · PL/SQL· Reports Versions 2.5, 6i; Forms Versions 4.5,6i; AOL

Engagement Experience · Applications Development· Data Conversion· AIM Methodology· Fit/Gap Analysis· Testing · Requirements gathering· Conversion· Configuration

Other Accomplishments

Education · BS in Computer Science and Engineering, Mysore University, India.

Training · Project Management· Consulting Skills· SOA Essentials· BPEL Process Manager· Field Service· Depot Repair· Warehouse Management System· IProcurement· Managerial Accounting· Financial Accounting

Languages * Hindi, read, speak – Moderate proficiency· Kannada, read, Write, Speak – High proficiency

Contact this candidate