SUMMARY

• Been a member of the Functional focus team and about 12 years of IT experience, with a primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Project Manager 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
• Skilled with Oracle Channel Revenue Management R12 or Trade Management 11i, Oracle AR/Rev Rec, RevPro.
• Possess strong knowledge of Financials modules of Oracle applications, with concentration on AP, AR, GL, FA, Sub Ledger Accounting, E-Business Tax, i-Expense modules combined with a unique combination of their integration with other modules like OM, INV, PO, Advanced Pricing, Shipping and Oracle Discoverer.
• Designed Custom Financials Statement Generator (FSG) reports and Oracle and Discoverer Reports
• Extensive experience with the Order to Cash (O2C) and Procure to Report (P2R) 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 AP, AR, GL, FA, Sub Ledger Accounting, E-Business Tax, i-Expense 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: AP, AR, GL, FA, Sub Ledger Accounting, E-Business Tax, i-Expense

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, Minneapolis, MN

Project Manager

Responsibilities:

• Study AS-IS Business Process of Confidential
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Carry out Data Mapping.
• Worked on the setups of AR, AP, GL, FA, CM, i-Expense, Sub Ledger Accounting, AGIS, e-Business Tax
• 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.
• Developed several Row Sets, Column Sets, Row Set Account Assignments, Row Set Calculations, Column Set Account Assignments and Calculation, Content Sets. Developed and defined more than 50 FSG reports and also created FSG report sets.
• Created and maintained FSG Financial Reports critical to company’s business process.
• Consolidation and mapping of FSG reports between different instances
• Transferring FSG reports to different instances
• Running and publishing of FSG reports for User Acceptance Testing.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• 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.1.3 AR, AP, GL, FA, CM, i-Expense, Sub Ledger Accounting, AGIS, e-Business Tax, FSG Reports, Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Confidential, Louisville, KY

Project Manager

Responsibilities:

• Managing of all of the Functional Specification Documents (FSD) prepared, Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on the entire Financials business process.
• Performed all of the setups for AR, FA, CM, AP and GL
• Developed several enhancements to the Business Processes on the Financials side.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
• Developed several FSG using reports using the Row Sets, Content Sets and Column Sets etc.
• Implemented the e-Business Tax module including configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
• Performed all of the setups for Sub Ledger Accounting and the Payments module.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Automation of Auto Lockbox through Account Receivables module
• 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 Cash Management and Account Payable Module

Confidential, Daytona Beach, FL

Project Manager

Responsibilities:

• Study AS-IS Business Process
• Worked on the setup of the Approval Hierarchies, Document Types, Matching rules, PO Options in Purchasing Module
• Created New FSG Reports, using multiple currency features including foreign currencies for multi-org structures.
• Worked on all of the setups in the AP module and worked on the integration of AP with Sub Ledger Accounting.
• Gathered and analyzed business requirements including process reengineering. Documented functional requirements pertaining to financial modules and security features.
• Performed all setups and configurations for Revenue Recognition process in AR module, including the setups of Accounting and Invoicing rules, AR Transaction types, Auto Accounting, etc.
• CRP and user acceptance test (UAT) were carried out for the above modules. Trained the end users and resolve problems during UAT.
• Prepared whole data conversion approach and cutover strategy for balances from their legacy system to Oracle Application.
• Developed ADI templates for data conversion to GL and FA. Converted Data from the legacy system to Oracle through Open Interface tables.
• Assisted the Client with Production Data Conversion, Reconciliation and Execute tasks for Go-Live activities.
• Developed and tested the financial statements as per requirement using Financial Statement Generator (FSG)
• Coordinated with technical and DBA team for resolving the customizations issues and documenting them
• Provided functional support to other teams and troubleshooting and maintaining the system

Confidential, Overland Park, Kansas

Oracle Functional Consultant

Responsibilities:

• SPOC for the Business in resolving their day-to-day issues in Advance Pricing (QP), i-Procurement, PO, INV, AP, AR.
• 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.

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Focused on supporting the rollout of separate Ledgers in GL, GIS, AP and Purchasing functionality
• Configure application modules based on existing setups and using requirements submitted by business partners, Modules included AR, AP, GL, FA
• Setup Organizations, Legal Entity required for the new Ledgers (primary and secondary)
• Hands on analysis, design, testing, implementation and post implementation support.
• Work with business resources, super users and onshore technical teams. Manage on-time project delivery and business expectations and ensure internal customer satisfaction.
• Prepare Setup documentation and conduct training sessions for business users. Build test cases & manage/conduct Conference Room Pilot/User Acceptance Tests.
• Provide global and cross-functional leadership to project teams. Provide day-to-day support and quality assurance for projects and tasks.

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, San Diego, CA

Oracle Applications Business Anlayst

Responsibilities:

• Prototype the business process by mapping against the functionality of the modules in a test database installed as a part of the Oracle Applications installation process.
• Set up OM Transaction Types, OM Parameters.
• Set up Inventory Organization for OM related items.
• Defined time limit for Booking of Order, Scheduling of Order, Closing Order Lines and Order Headers.
• Set up pricing parameters/list.
• Inventory On hand availability Checking, Pick Release Rules, and Back Ordering decision.
• Set up Shipping Parameters/Rules, Containers, and Granting Roles to Users.
• Document sequencing for Order Numbering.
• Modification/cancellation of Orders/Order lines.
• Created MD050 based on RD020 and RD050.
• Prepared TE020, TE040 based on MD050.
• Developing test scenarios and testing the code units developed
• Testing the system for specific scenarios after upgrade to 11.5.9
• Coordinating with the client for requirement related discussions.

Environment: Oracle Applications 11.5.9(AP, OM, GL, Oracle Workflow 2.6, PL/SQL)

Confidential

Oracle Applications 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