SUMMARY

• 11 years of experience in Oracle Applications playing functional lead role in projects ranging from implementation, rollouts and enhancements with functional support in multi - org Order to Cash and Procure to Pay tracks.
• Expertise in business process analysis, mapping requirements, as well as data modeling and detailed functional design writing AIM docs BP-030, RD-050, MD-050 and BR100 documents and ability to present complex ideas in a clear, concise fashion to technical and non-technical audiences.
• Involved in design, map/gap analysis, system configuration, functional test scripts, validation testing and user acceptance testing/ sign off and post production support.
• Solid/extensive implementation/support experience in retail & manufacturing environment with financial shared services business model. Expertise in R12 & 11.5.10 Order Management (OM), Shipping, Advanced Pricing (QP), Procurement (PO), Projects (PA), Process Mfg. Inventory Management (GMI), Discrete Inventory Management (INV), Account Receivables (AR), Account Payables (AP), Intercompany product (IC), OPM Suite of Applications, Alerts, AOL and System Administration.
• Effective requirements gathering from business leaders of manufacturing and distribution divisions across various departments - Customer care/call centers, Pricing & Compensation, Distribution/Logistics, Procurement, Cost/inventory accounting and Finance (AR & AP).
• Was a full time employee at Oracle Process Manufacturing group - Sustaining Engineering Team supporting customers all over the globe for Oracle Process Manufacturing customers using discrete Oracle Order Management and discrete Oracle Procurement.
• Responsible for gap analysis between Oracle application Suite and client business requirements and develop functional specifications for customizations.
• Serve as a liaison between super-users, end users and technical team providing support for functional questions, managing year-end/period end period closure issues.
• Coordinate with Oracle Global Support/Development for SR/TAR resolution/escalation.
• Implemented six-sigma green belt project for Confidential Global Financial shared services (GFSS), Memphis, USA and Confidential European Financial Shared Services (EFSS), Dublin, Ireland.
• Good working experience in Discoverer Viewer/Plus, SQL, Toad, Oracle Database and RDBMS concepts and using oracle utilities, tools like SQL Navigator, SQL*Plus, SQL*Loader
• Excellent experience in writing functional test cases. Excellent analytical skill. Have good judgment & communication skills required for reporting and prioritizing production bugs in conjunction in conjunction with Quality Control & Quality Assurance.
• Proficient in providing Production system support and handling Oracle Apps System Administration.
• Ability to identify root causes of problems. Consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Excellent communicator with ability to work independently as well as part of a team

TECHNICAL SKILLS

ERP: Oracle Re. R12, 11i (11.5.10.2, 11.5.10, 11.5.9, 11.5.7)Order Management, Advanced Pricing, Shipping, BOM, Inventory - Oracle Supply Chain, Accounts Receivable, Tax - Sales and VAT taxation, Procurement, Projects, Accounts Payables, Fixed Assets, General Leger, GIS, Inventory, System Administration, Inter Company, Grants Management, Oracle Process Manufacturing Financials, Inventory, Costing, Inventory Convergence, Progress ERP.

RDBMS: Oracle 9i/ 8i/10.2.0.5, 10g, SQL, PL/SQL

Tools: /Utilities: Web ADI, Data loader, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Discoverer, Work Flow.

O/S: Linux, Sun Solaris 2.8, Windows XP

PROFESSIONAL EXPERIENCE

Confidential, Duluth, GA

Oracle Order to Cash Consultant

Responsibilities:

• Order to Cash operations support to review and resolve US and France helpdesk incidents raised by customer care (domestic and export), product pricing, warehouse and distribution and finance departments.
• Application gap and requirement analysis, business process mapping diagrams, estimation design, development, testing, training and documentation and implementation of various solutions and change requests in Oracle EBS environment.
• Configuring and performing unit tests and assisting users in UAT phase following Oracle AIM methodology.
• Configured shipping methods, shipping zones and transit-times for automatic warehouse routing based on ship-to address location, product class group, product weight and volume.
• Implemented advanced pricing extensions for shelter programs and educate business teams to understand advanced pricing engine behavior on accrual modifiers at shipments.
• Put workflow changes and specifications for developers to avoid delays in auto-invoice due to mismatch in shipment and invoice dates.
• Involved in implementing solutions, advising and supporting system users, projects to facilitate better usage of the system. Also involved in maintenance and support of e-business environments by providing techno-functional support of operational business implementation.
• Prepared custom reports in order to cash area for internal audits. Configured permission sets, menus and form functions with UMX-RBAC to remediate audit findings.
• Prepared end-user training documents and provided end-user training on shipping procedure and different options to analyze backorders.
• Created Oracle forms personalizations for customer care to ensure lot reservations on order entry are in sync with ordered quantity to prevent split shipments from the warehouse, to prevent order booking without order lines.
• Worked with Third party logistics providers (3PLs) on notification mechanisms to prevent duplicate shipments from the warehouse.
• Assisted finance in importing invoices stuck in Autoinvoice import, completed audit changes to prevent order entry functions by finance, cash and collections team members.
• Pro-active monitoring on long running jobs to ensure optimal system performance during month-ends.
• Assisted customer care order entry teams to resolve order holds, warehouse routing, ship method upgrade, scheduling, cancellation issues (training and data fixes) and research supply policy and business restriction orders.
• Configured party owners for shared bank accounts to prevent duplicate bank-accounts issue.
• Worked with Oracle SR analysts and DBAs to test patches on root cause fixes in E-Business suite 12.1.3 Order management release.

Environment: Oracle 12.1.3 Order Management, Advanced Pricing, Shipping, Tax, Inventory, Accounts Receivables, Revenue Management, TCA, UMX-Role based access control (RBAC), CRM-Contact center, Email center, resource management, SQL, PL/SQL, Application Object Library, Service desk 7.0, Request to Implement SD7.

Confidential, Greenville, WI

Oracle Business Technology Lead Contractor

Responsibilities:

• Supply chain project lead for continuous improvement initiatives involved in map/gap analysis, project estimation, MD050 design, development walk through and working with business groups for sign offs.
• Implemented Oracle Project manufacturing module (part of projects suite) to allow order entry for supplier shipments and returns from order management for projects by design group. Project drop ship process minimized manual work for merchandising department with options to use configurator for furniture and equipment items.
• MD050s for dropship project PO creation, To Supplier & To Buyer attachments, requisitions exception report to handle project requisitions, PO document design and printing, projects shipping detail report.
• OM Forms Personalization to prevent blank project/task, project number sequence validation for new process.
• AP Forms Personalization to notify AP agents while matching project POs since project and task don’t appear on invoice matched line.
• SR follow up and patch testing on Oracle advised patches locator LOV appearing in non PJM organizations. Regression testing on inbounds from warehouse using Radio Beacon and Sterling.
• Designed customer returns and vendor returns process flows along accounting impact. Finance demos to show PPV/IPV transferring to the project with project manufacturing module.
• Backfills for organization assignment for dropship and externally configured items, BOM common for existing BOMs.
• Worked with business on the prototypes for project drop shipments to review the business flow from drop ship sales orders creation, approving the project purchase orders, receiving in project locators and tie back to the order line for project invoicing.
• Regression testing for interfacing the expenditures to projects module for costing.
• MD050s item import enhancements to automate handling new item category sets and categories, material overhead costs, approved supplier list, pending costs, organization assignment and other business related attributes in Item/ASL DFFs.
• MD050s to allow ASL modifications from item import template.
• Working with business to re-align the item templates and MD050 design walk through with development.
• Preparation of manual test scripts based on MD050s for UAT/business sign off.
• Creating change requests and working with different teams to get approvals for deployment in production.
• Attended daily meetings to share project status and reported status to project manager on potential risk and delay if any.
• Go-live and cut over support on all 3 projects - Item import, item cross reference and projects by design order entry.

Environment: Oracle 11.5.10 Order Management, Advanced Pricing, Configurator, Procurement, Projects, Project Manufacturing, Inventory, BOM, SQL, PL/SQL, Application Object Library, Remedy Change Request.

Confidential

Senior Applications Analyst - OM/DM

Responsibilities:

• Implementation lead for Order and distributor management roll out of global Herbalife retail footprint (custom solution) to new countries in EMEA region with solutions for legal/fiscal requirements of local countries/region.
• Prepared MD050s for functional customizations related to country specific legal/statutory requirements and worked with business/Dev to obtain sign offs.
• Lead - Oracle upgrade & Vertex upgrade from 4.1 to 6.0 to research new application behavior n share workarounds with business partners to obtain sign offs.
• Ownership of business functions include distributor order processing, pricing, freight, package & handling, logistics charges, taxation, amending orders, 3rd party integrations for orders and logistics/shipping.
• Expertise in Oracle-Vertex integration configuring new countries on vertex for tax links/implementation and gathering tax requirements/set ups with business teams for tax handling. Configured various vertex rules for SKU exemptions and special rules specific to Herbalife business for International Orders. Managed new rate changes in EMEA via Vertex monthly update process for testing and sign off from business.
• Hands on with Oracle order management configurations including Logical Apps/processing/shipping locations/order types/various custom value-sets, look ups and profile options.
• Deployed new marketing fund and logistics charges requirement for Peru.
• Supported UAT activity- CRP3 at Darmstadt, Germany with EMEA users during EMEA rollout for 54 countries and closed more than 100 defects raised meeting SLA.
• Assisted team to build scripts and set ups for International orders - ISS with EMEA and US.
• Resolved production tickets for other live markets - US/CAM/SAM/CA meeting SLA for NTS printing, Internet ordering and Global Order Capture Applications.
• Completed MD50s to meet various rollout requirements ranging from legal NTS/invoice, Spain specific taxation, Taiwan’s freight charges, UK minimum freight and taxation based on multiple slabs.
• Conducted cross functional training for new team members and prepared knowledge documents for Vertex application integration.
• IT Operations support for US Sales tax and VAT changes, assist business in monthly US sales tax returns and reports preparation, built tax assist and tax rules and product mappings for new requirements specific to Herbalife business processes.
• Assist in resolving tax codes/rates in Accounts Receivables invoice generation for VAT countries following Vertex.
• Followed change management process for incorporating functional set up changes by following work order process for approval, authorization, implementing, testing and sign off to production.
• Month-end/year-end support/on-call and pro-active monitoring of jobs working with DBA teams.

Environment: Oracle 11.5.10/R12 Order Management, Advance Pricing, Discrete Inventory, Accounts Receivable, Vertex Sales Tax O Series 4.0, Vertex Value Added Tax O series 4.0, Global Order Capture application (custom iStore App), Shipping, Oracle R12, SQL, PL/SQL, BMC Ticketing and Change Management system.

Confidential, Richmond, VA

Senior Business consultant

Responsibilities:

• Post implementation lead consultant to manage the Oracle 11.5.10 multi-org order to cash solution for various Reynolds businesses of Consumer products, food packaging, and closure systems.
• Took ownership and resolved Oracle functional issues logged by CSR managers, pricing managers, warehouse supervisors, inventory leads, supply chain planners, purchasing managers, costing/inventory accountants, Global solution finance team.
• Designed Oracle solution for new business requirements like vendor drop shipments, advance pricing requests from the commercial businesses.
• Cleared stuck transactions in the inventory to facilitate better month end closure for inventory.
• Scheduled jobs to kick off batch programs and monitor them for any errors/resolving any interface integration issues.
• Resolved complex pricing issues around attribute driven pricing solution, WMS integration, receivables root cause fixes for proper accounting.
• Testing/working with Oracle SR analysts to test patches, work with DBAs to provide requested information and working towards SR closure.

Environment: Oracle 11.5.10 Order Management, Advance Pricing, Discrete Inventory, Warehouse Management, Purchasing, Intercompany Invoicing for the products, Shipping Execution, SQL, PL/SQL, SQL Developer for queries.

Confidential, Memphis, TN

Plant Sales/Commercial procurement Lead

Responsibilities:

• Lead/conduct gap workshops with Latin American market business leaders of various divisions of procurement, logistics, customer service, inventory accounting and finance to gather requirements and identify potential gaps from standard footprint with BP80 process and primarily responsible for map/gap around finished goods import and plant exports for 18 countries.
• Gather requirements, conduct map/gap analysis and configure business flows in Oracle Order Management for manufacturing division sales, inventory transfers from the plant to WMS and other financials impact involved around various other manufacturing/WMS activities like re-packaging, tolling and sub-contracting operations and consignment processes.
• Work out a process map for product intercompany transfers between Confidential entities integrating the purchasing side of the commercial business and the sales side from the manufacturing division.
• Configured full Oracle Order Management module and presented CRP workshops for full end to end business flows by setting up OM Transaction types, OM Price Lists, OM Internal Sales Order set ups, RMA orders with various workflow types, Intercompany customers for plant sales, credit check rules, pick release rules, release sequence rules, OM system parameters, auto ship confirmation rules for pick/pack/ship scenarios.
• Frame a methodology for intercompany product invoices with naming convention/logic for intercompany suppliers/customers.
• Configuring account mappings in OPM financials for intercompany transactions to capture ownership transfer.
• Perform map/gap analysis for the Latin American sites/countries rolling out and worked on analyzing regulatory, statutory and legal requirements with Ernst & Young team towards gap analysis.
• Conduct design workshops with markets and global financial shared services to identify solutions for the gaps from the standard model.
• Review Oracle globalization/localization patches and work with Oracle Latin American consulting group towards the solution mode.
• Design interfaces for integration with legacy automated WMS systems and outsourced WMS like DHL, global logistics, planning and manufacturing systems.
• Preparing test scripts to capture various business scenarios around direct procurement interfaces and integration with warehouse management systems and planning systems.
• Gather various costing requirements and propose solutions for landed cost calculations and setting up Oracle Process manufacturing financials for account mappings and cost calendars.
• Align with other team members of INV, AP and GL to discuss touch points.
• Developing application architecture maps integrating Oracle with manufacturing and planning legacy systems.
• Configuring the sandbox environment for supply chain transactions involving direct procurement automatic sourcing, manufacturing sales, inventory movements/transfers between plant/warehouses and cost accounting.
• Exposure to complex business flows involving intercompany transactions between various countries, tolling and repackaging by plant/warehouse, internal sales orders and drop shipments.
• Strong knowledge of inventory reconciliation/accounting working with Global financial shared services staff.
• Followed good documentation/methodology for project management
• Reviewed Oracle globalization/localization patches and work with Oracle Latin American consulting group towards implementing the patches.
• Be part of the conversion team developing conversion strategies from legacy systems to Oracle.
• Co-ordinate with local business leaders in the market, global Financials solutions team, Global Financial Shared Services (GFSS)

Environment: Oracle Apps release 11.5.10 Order management, Purchasing, Oracle process manufacturing inventory, Intercompany, Oracle process manufacturing financials, Accounts Payables integration/touch points. TOAD, SQL, PL/SQL, Microsoft Visio, Excel, Manufacturing software MAPS, planning system Manugistics.

Confidential, NY, NY

Sr. Financial Functional Consultant

Responsibilities:

• Providing business analysis and support for Confidential finance and procurement business users in Oracle Federal Financial Applications.
• Bringing new process improvements by configuration changes and fixing root cause issues in Mass Additions program, setting alerts for requisitions/purchase orders pending for approval, sequencing for voucher number in AP invoices, audit reports and audit requirements by reports to capture changes to awards/projects by users and project managers.
• Designing functional design for incorporating fund increase/decrease functionality in grants management from excel import.
• Formulating the change order process for both positive and negative amendments for Contracts/purchase orders/requisitions.
• Determining improvements to existing Oracle system to bridge the gap between the business process and application/system. Design, plan and conduct functional testing.
• Developing test scripts and test cases for customizations.
• Organizing and run user acceptance testing and obtain user sign off.
• Developing and maintaining detailed project plans and manage projects and/or tasks and phases of projects.
• Mentoring and training other team members and end-user community.
• Gathering user requirements for customizations, reports, and changes to existing functionality, and make recommendations as to the same.
• Participating in future upgrades by researching changes to functionality, developing test scripts, testing changed functionality and determining impact on customizations.

Environment: 11.5.9 Purchasing (PO), Accounts Payable (AP), Grants Management System (GMS), Fixed Assets (FA), General Ledger (GL), System Administration

Confidential

European Financial Shared Services

Responsibilities:

• Led the cut over activities post go live across 17 markets for Confidential Inc, Europe assisting business users in customer services group, commercial sales, plant sales, logistics divisions in Order to cash activities. Supporting order management order types, new defaulting rules based on requirement to each market, new customers, customer class, DFF across customers, custom and standard holds, credit check rules, Receivables quick codes, pick release rules, release sequence rules, shipping parameters form, ship confirm rules, purchasing and receiving options, shipping networks, drop shipments and internal sales orders.
• Assist business users to resolve basic/advanced pricing issues which customer specific price lists, secondary price lists, Header/Line Level qualifiers, Modifiers, Different modifier types - Discount, Promotion, Freight, Surcharge, Accrual Modifiers, qualifiers associated with modifiers and helped users with the shipping transaction form, AR invoices and credit memos.
• Modify functional specification for custom hold management - Supply Policy Feature
• Supported period closure and year end closure issues for France, Germany and Italy rollouts with typical month end activities of clearing pending transactions, making sure revenue recognition happens the same period and INV/AR period closure.
• Advance Pricing Security Implementation and post implementation production support
• Modifiers configuration based on business needs for various European Operating units & Freight Cost issues.
• Training Manuals for end users to simplify pricing
• Assist Business Users across various divisions of PGM, PGP, PAH and PCH to resolve Oracle Order Import/Booking issues for standard orders, bill only, ship only orders, RMA orders, Unassigned items to warehouses, incorrect defaulting rules, Undefined Cross References for items, Multiple Oracle Items for single cross reference, Null Price Lists, Payment Terms, Warehouse for Orders, workflow etc.
• Configuring Direct-To-Pharmacy (DTP) model for Confidential UK OU with interfaces re-redesign between standard Oracle modules Order Management, Oracle Receivables, Oracle Process Inventory and legacy systems which include Warehouse management systems (WMS), Manugistics, Logility and Ariba.
• Order to Cash Stream business map to in corporate UC4 Batch scheduling integration feature to kick off/manage concurrent requests for the full supply chains of purchase and sales mapping/links so that the files reach the WMS in time.
• Modules include Distribution - Order management, Purchasing, Inventory, Advanced Pricing, Financials - Account Receivable, OPM Financials.
• Assist Business users with inventory set up and transaction issues ranging from creating items, item categories, Units of Measure, Uom Classes, Uom Conversions, using transact process move order, Pick confirmation and Backordering issues.
• Assist users to progress orders from order import to ship confirmation and auto-invoicing.
• Strong data model knowledge of underlying O2C, P2P cycles and profile options in these business cycles to meet Confidential requirements.
• Fixed software bugs in these interfaces post GO-Live meeting SLA.
• Performed system administration functions such as creation of request groups and concurrent programs.
• Requirements gathering with Configuration document BR100s and Business Analysis.
• Handled Scoping of functional Landscape and devised interface architecture for Integration of Legacy system and 11.5.10 Implementation

Environment: Oracle Applications 11.5.10 Financials/Manufacturing (OM / AR/ INV/Advanced Pricing and PO), Discoverer, Oracle 9i, PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Peregrine Ticket Management Systems for Incidence Management, PVCS.