SUMMARY

• Been a member of the Functional focus team and about 9.1 years of IT experience, with a primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Senior Functional Consultant specializing in Oracle Application implementations, specifically Financials.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, OM, Service Contracts, Install Base, Depot Repair, Advance Pricing (QP), MRP, PO, INV, AP, AR, combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
• Extensive experience with the Order to Cash and Procure to Pay business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i

Modules: Quoting, OM, Advance Pricing (QP), MRP, Service Contracts, Depot Repair, MRP, Install Base, PO, INV, AP, AR

Databases: DB2 and Oracle 7.x./8.0.5/8i/9i/10g.

Oracle Tools/ Utilities: TOAD, PL/SQ: developer SQL * Loader, Export, Import, SQL & Monitors.

Operating Systems: UNIX, Windows 95/98/2000, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Functional Consultant

Responsibilities:

• Study AS-IS Business Process of Confidential .
• Analyze the Confidential Expandable System & Confidential Integration Requirements.
• Identification of GAPs & proposal of Solution.
• Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Carry out Data Mapping.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• Worked on the setups and configurations for OM, MRP, Quoting, Shipping, Advance Pricing, Depot Repair, Install Base and Inventory modules.
• Worked with business users on planning and executing data conversion activities like Item, PO, On-hand, Cost and Categories.
• Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation

Environment: Oracle applications R12 (OM, Service Contracts, Depot Repair, Install Base, and Quoting, Shipping, Advance Pricing and Inventory), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Confidential, SFO, CA

Senior Business Analyst

Responsibilities:

• Setup Document Approval / Approval Group / Assignments, Purchasing Options
• Define Line Types and Doc Types, Lookup Codes, PO Profile Options
• Create Requisition, Auto Create RFQ, Corrections
• Defining Standard, Blanket Purchase and Contract Purchase Agreement
• Define Supplier & Item Combination, Sourcing Rule, Approved Supplier List,
• PO Control, Release PO, Receipts, Run Reports & Journal Import Programs
• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on both CTO and ATO Models.
• 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.
• 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
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Setup Modifiers and Qualifiers in QP.
• Setup the pricing attributes in QP
• Setup the Dynamic formulas for pricing in QP.
• Setup the Attribute mapping in QP
• Setup the QP profile options.
• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
• Established a Item Category and Item Cataloging for their products.
• Defined a ABC Analysis and Cycle Count
• Established Customer Item and Customer Item Cross Reference
• Established a process for smooth month end closing procedure in Inventory

Environment: Oracle Applications 11.5.10 (OM, AR, INV, Advance Pricing, AP, GL, EDI), Oracle 9i (SQL, PL/SQL), TOAD.

Confidential, Overland Park, Kansas

Oracle SCM Business Analyst

Responsibilities:

• SPOC for the Business in resolving their day-to-day issues in OM, MRP, Advance Pricing, Shipping, Install Base, Service Contracts, PO, INV.
• Providing functional Support assistance to OM and AR Internal Customers.
• Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
• Worked on Inventory setup changes, real time defect resolution in areas like Inventory Move Order, pending Inventory transactions, material on hand & transaction quantity mismatch, Item control, Sub inventory Transfer & Month end closure.
• Played an important role on Advanced Pricing setups, designing Pricing Formulas, Price rounding, Modifiers, Pricing Events, Partial Pricing, Qualifiers, DFFs to track Price changes, assessment for tiered Pricing for expedited orders & maintaining Intercompany Transfer Pricing.
• Ensured appropriate seeded workflows in OM are used in the transactions. Resolved issues in application setup and configuration with the Financial Consultant to ensure proper interfacing of AR with OM and AP with Purchasing, and Inventory with GL.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
• Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
• Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.
• Handling a team of 4 members and responsible for their productivity, efficiency & quality.

Environment: Oracle Applications 11.5.10(AP, AR, GL, Purchasing), (SQL, PL/SQL), TOAD

Confidential

Oracle SCM Business Analyst

Responsibilities:

• As a Functional Consultant implemented the Order to Cash Business flows including MRP, Advance Pricing, Shipping, Install Base, Service Contracts
• Performed Requirement and Gap analysis.
• Configurations and Setups for MRP, Advance Pricing, Shipping, Install Base, Service Contracts, modules
• Worked on the setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined the Auto Lock Box process in AR module
• Defined the Auto invoice process in AR module
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle Applications 11.5.9 (AR, AP, GL, AOL), Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer

Confidential

Oracle Applications Functional Business Analyst

Responsibilities:

• Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology
• Part of a business transformation project team and assisted the end-users in the functional configuration of Order Management, WIP, BOM and Inventory modules
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc
• Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements
• Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
• Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Conducted CRP and Integration testing for related modules
• Maintain issue tracker and coordinated with the team for debugging
• Involved with user acceptance testing (UAT) and end user training
• Prepared and provided comprehensive training materials and practice exercises

Environment: Oracle Applications 11.03/11i (GL, AOL, Sys Admin, Alerts), Oracle 8i(SQL, PLSQL) Forms 6i, Reports 6i, TOAD, SQL Loader and HP-UNIX, Discoverer

Confidential

Oracle Functional Consultant

Responsibilities:

• Requirement gathering developed Functional Specifications for new development/enhancements/Change requests
• Functional Activities- Gap Analysis to identify the gaps based on Business requirements - Involved in Capturing and Documenting As-Is process & to-be business processes
• Configuration Set up of Oracle Financial Modules (AP/AR/GL/FA/CM)
• Provided support to users during go-live and Rollout by way of problem solving and instructions- Post Production issue resolution and support including Month/Quarter/Year End Close Support