SUMMARY

• Oracle Order to Cash Functional Analyst with 8 years of IT experience in implementation, upgrade and maintenance of Oracle Applications R12/11i
• Extensive experience in Hi - Tech, Mfg, Distribution and Telecom environments
• Extensively worked on transformation, integration and upgrade projects
• Extensive experience in successfully implementing Oracle Applications using Applications Implementation Method (AIM) processes and templates.
• Experience in leading Oracle Apps implementation team
• Experience in working with and managing onshore/off-shore outsourcing partners
• Strong Exposure in preparation of functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, Test Scripts, Functional Documentation, User Training Documents and Customization Documents.
• Excellent in understanding business operations and translating them into functional requirements.
• Strong problem solving and analytical skills with immense ability to grasp new concepts and apply them. Strong interpersonal skills, able to communicate and work well with people at all organization levels
• Excellent project management, leadership, communication, client facing and presentation skills
• Excellent functional skills, coordinated and participated CRP/CAT testing
• Designed and documented business process flows and transaction flows
• Good understanding of Oracle Applications APIs/Open Interfaces and the underlying data model
• Good understanding of Multi-Org and Multi-Language requirements
• Experience in mapping and conversion of data from legacy applications to Oracle system
• Designed custom interfaces to integrate Oracle Applications with 3rd party systems and legacy systems
• Good understanding of SOX IT controls over financial reporting

TECHNICAL SKILLS

Oracle Apps (R12/11i): Order Management, Advanced Pricing, Shipping, Inventory, Receivables, Purchasing, Service Contracts, Install Base, Bills of Material, Open Interfaces, Workflow, Alerts, AME, TCAProject ManagementOracle Application Implementation Method (AIM), Oracle Unified Method (OUM), MS Project

Industry: High-tech, Manufacturing, Distribution, Telecom Services

Tools: & Utilities: TOAD, DataLoad, MS VISIO, MS Excel, MS Word, MS Power Point, SharePointSFDC, SAP CRM, B2B, HP-QC/ALM

PROFESSIONAL EXPERIENCE

Oracle Applications Functional Analyst

Confidential, Sunnyvale, CA

Responsibilities:

• Migrated Order to Cash (CTO/ATO/PTO env), and Procure to Pay business process from SAP to Oracle E-Business
• Facilitated the system requirements gathering sessions including process mapping and improvement
• Developed and managed project plan to ensure timely completion of implementation
• Extensively used Oracle Application implementation methodology (AIM)
• Leveraged underlying existing technology Stack (Oracle EBS, R12 Quoting/Configurator, SFDC, SAP CRM and B2B architecture) to achieve integration.
• Responsible for Order Management, Inventory, Pricing and Shipping setups
• Participate in Conference Room Pilot (CRP) and UAT testing
• Provided post production support and did a knowledge transfer to on-site resources.
• Worked closely with client to understand business needs and drove end-to-end solution implementation
• Lead delivery of all project components; coordinated and communicated status, issues and delivery plan to the PMO.
• Issue resolution and troubleshooting of issues encountered during the complete project lifecycle and post production support.
• Confirmed the completeness and consistency of the RICE Functional/Technical design, resolving any inconsistencies discovered during the design and development phases.
• Implemented B2B integration without sourced partners (Jabil-CM, Menlo-DC and TD/IBM HUBs)
• Automated several manual processes, reduced transaction execution time by 90%
• Facilitated requirements gathering sessions and solution design.
• Provided implementation expertise and served as the first escalation path for issues and change requests throughout the project.
• Trained end users as required and mentored project team members
• Helped make complex implementation concepts simple for clients and more junior personnel
• Held team and client status meetings to provide visibility to project progress and deadlines, goals, objectives, and issues

Oracle Order to Cash Functional Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Conducted design workshops to define business requirements and documented RD050.
• Gathered Requirements and performed requirements mapping
• Documented BR100 and performed Order management, Advanced Pricing and Shipping related setups
• Documented Customer Requirements (CR) and Functional Design documents (MD50)
• Designed (MD50) solution to extract configurations from OM and interface the details to manufacturing
• Designed (MD50) solution for change orders related to complex system configurations
• Designed sales orders, items and pricing conversion strategies (CV40/CV50)
• Managed onsite/off-shore and off-shore teams
• Designed and implemented Advanced pricing solution to meet complex pricing requirements
• Enabled and defined multi-currency price lists
• Defined pricing attributes and linked the same to Config attributes using attribute mapping and calling a PL/SQL function to capture user selection during oracle configurator run time.
• Defined Dynamic formulas to calculate unit selling price for configured products based on user selections in Oracle Configurator runtime session
• Defined Pricing Modifiers to allow discounts based on product and product type with customer/customer class as the qualifier
• Conducted CRPs and UAT sessions with the business users
• Designed and documented customer and sales order conversion procedures (CV040/CV050)
• Designed and documented MD050s for Sales Order Acknowledgement, Quotation, Shipping Documents

Oracle Order to Cash Functional Analyst

Confidential, Davidson, NC

Responsibilities:

• Conducted meetings with Super users/SME’s to gather requirements for Procure to pay and Order to Cash cycles and documented in BR-30.
• Study AS-IS Business Process, identification of GAP & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), and Functional Testing Documents.
• Responsible for the complete setup and implementation of OM, INV, BOM, Advance Pricing, Shipping
• Developed all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Functional Specification MD050, and Testing Documents.
• Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
• Internal Sales Order/Internal Requisition process was configured to establish a simplified Intercompany sales across operating Units
• RMA and Approval Management functionality setup reduced the process time in Customer Returns management
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Designed Advanced Pricing solution using Configurator output strategy and Dynamic formulae
• Created Pricing contexts, defined Pricing Attributes and performed pricing attributes mapping
• Provided weekly status updates to the client and the project management

Oracle Apps Consultant

Confidential, Germantown, MD

Responsibilities:

• Participated in design workshops, gathered requirements and performed operations analysis. Drafted RD050 and performed business requirements mapping (BR030) using AIM templates
• Performed gap analysis and identified necessary customizations
• Documented BR100 for Order Management, Advanced Pricing and Shipping setups
• Functional design (MD050) of interface between Oracle and OneVoice (Legacy quoting) system to publish pricing and item related information from Oracle to OneVoice
• Documented CV040 for Price Lists and customer conversion. Developed converted data validation plan
• Defined Modifiers, Qualifiers and Price Agreements
• Extensively used iProjects and AIM through out the project
• Designed repair & return flows, return for repair, advance replacement, return to stock and return for credit
• Functional design of Customer Facing Documents (MD050) which includes Sales Order Acknowledgement, Customer Invoice, Pick Slip, Packing Slip, Commercial Invoice
• Functional design of event based alerts (MD050) to notify business and end users
• Functional design (MD50) of BOM/Routing validation of BOM enabled items at the time of order entry
• Assisted Configurator team in finalizing the config BOM structure, model design and UI
• Functional design of Standard, Non-Standard (Credit Card orders, Cash In Advance), Invoice Only workflow, Order Booked/Shipped Alerts and various Order Holds.
• Performed Setups for Drop-Ship order flow, GSA Pricing, Internal Purchase Requisition/Internal Sales order and Inter-company Relationships.
• Documented CV050 for manual conversion of open sales orders.
• Coordinated Conference Room Pilot sessions. Designed, prepared and conducted workshops and training sessions for other team members and end-users
• Functional testing of the customizations that were delivered by the technical team
• Developed test scripts (TE040) for standard order line, Drop Ship, IR/ISO, Cash in Advance, Credit card orders, Trade In Process & Returns
• Setup Shipping parameters, defined Pick slip grouping rules, shipping and pick release document sets
• Defined internal customers, customer sites and contacts to process internal orders

Oracle O2C Business Consultant

Confidential, San Jose, CA

Responsibilities:

• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on setting up the warranty contracts in Service Contracts.
• Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
• Worked on the Setups of AR, AP, GL, CM, i-Expense and worked on the integration of the modules with AR and AP along with PO integrated with internal e-Procure system.
• Setup i-Expense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, setting up Multi Currency, Audit Automation, Expense Report Summary client extension, etc.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATP Checking, Availability & Reservation
• Worked with business users in deciding and designing new Inventory Org. from new acquisitions.
• Worked on the Revenue Recognition Process in AR Module, setting up Deferred Revenue Rules, Service Revenue Rules, Etc.
• Worked on Invoice Conversion during new company acquisition.
• Coordinated CRP and UAT testing with business users.
• Conducted user training for acquired company's employees.
• Solved day-to-day production issues for new acquisitions.

Oracle Support Analyst

Confidential, Fort Wayne, IN

Responsibilities:

• Provide 24x7 business environment
• Support and maintenance of core order to cash, financials and manufacturing processes
• Coordinated functional TAR activities with Oracle Support
• Provides solutions for business problems like back order/cancel, pick release improvement
• Wrote detailed operations procedures based on result of Joint Application Development (JAD) sessions
• Documented Vertex (Tax) files loading procedures
• Manage the installation, testing and acceptance of Oracle application patches.
• Responsible for migration control from test instance to production instance
• Provided end of month and year end support and facilitated cycle counting activities
• Monitor and cleanup Oracle applications interfaces on a daily basis
• Automated daily support and maintenance tasks
• Provided technical assistance to other developers, business users and management