SUMMARY

• 6+years of proven IT experience in Design, Development, and implementation of software Applications using Oracle Applications 11i and R12 spreading across Implementations, Data conversions and customizations.
• Extensive Technical experience in Oracle applications modules GL, FA, EB - Tax, Purchasing, I- expense, I-Procurement, I-supplier, INV, AR, AP, Shipping and Pricing.
• Good understanding and implementation experience of Oracle Financial and Procure to Pay life cycles.
• Hands on Experience in Application core technologies (system administrator, Application developer, concurrent processing, Reporting).
• Strong programming experience in creating procedures, packages, functions, triggers and other database objects using SQL
• Prepared the SM010, RD045, BR100, TE040 and MD050 documents and helped business users in UAT (User Acceptance Test) testing and post implementation support.
• Coordinated all rounds of CRP and SIT testing with the business users
• Excellent analytical, inter-personal and communications skills and ability to work in a fast-paced and team-oriented environment.
• Strong experience in Functional Specification Design and writing clear Business Specifications, understanding of project life cycles and methodologies and problem-solving abilities, including the ability to troubleshoot effectively
• Ability to work in a professional manner, be flexible, and handle interactions with all levels of the organization and with external clients.

TECHNICAL SKILLS

ERP: Oracle e-Business Suite (11i and Release 12) - General Ledger (GL), Fixed Assets (FA), E-Business Tax, Cash Management, Payables (AP), Inventory (INV), Purchasing (PO), Receivables (AR), Shipping (WSH), and HRMS

Tools: SQL*PLUS, SQL*LOADER, XML Publisher, Form Builder 6i, Report Builder 6i

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Financial Consultant

Responsibilities:

• Created a base template to gather country specific localization requirements. Managed team in India to implement the P2P Business flows including GL, FA, I-Procurement, PO, AP, I-expense, EB-Tax modules, Cash Management and Bank Integration.
• Prepared SM010, BR100, MD050, TE40, TE050 and conducted CRP execution, User training and UAT successfully.
• Configurations and setups for Ledger, Legal Entity, Operating Unit and Locations for new countries. Worked on setting up the new tax rates including VAT and withholding taxes as localization requirements, I-expense templates (parking, per diem, corporate cell phone and mileage rates), Approval Hierarchies in Purchasing Module, and Fixed Asset Books and Categories
• I procurement/Purchasing: Setup the approval hierarchy, approval groups and approver assignment and designed workflow customization. Prepared the custom PO Print Program - MD050 and worked on custom PO Detail Report.
• Involved in the Item Master Setups in Inventory module including setting up of Item templates, defining Item attributes, enabling the items in various orgs and adding items to the Catalog in I-procurement.
• Worked on Romania bank integration - ability to make payment from OFA to Deutsche Bank (DBI) Online system. Conducted meetings with AP and Treasury to decide the payment methods and further, prepared MD050 and payment generation files for Domestic and International Wire payment methods. Also completed Mexico bank integration with HSBC for ACH and WIRE payment methods.
• Conducted Regression testing and OATS testing
• Prepared the CRP plan, conducted kick off meetings, created testing trackers and metadata for reference.
• Post-production live support.

Confidential, Newport Beach, CA

Financial/Procure to Pay Functional Consultant

Responsibilities:

• As a Procure to Pay Functional Consultant implemented the P2P Business flows including i-Procurement, PO, Pricing, INV, AP and GL modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for i-Procurement, PO, Pricing, INV, AP and GL
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Worked on customizing existing GL account for write offs with a product line of DVD.
• Customized existing AR Contra Cogs Clearing Account Report by adding additional fields.
• Developed AR Contra COGS Email Statements for Canada which Email’s statements as an electronic statement to be distributed to external customers to inform them about open invoices and unapplied receipts
• 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.
• In Advance Pricing, Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• 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.
• Worked on the Auto Lock Box process in AR.
• I procurement: Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• 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

Confidential, Bedford, MA

Financial/Procure to Pay (testing) Functional Consultant

Responsibilities:

• As a Functional Consultant in the Procure to Pay business flows, implemented modules - GL, AR, i-Procurement, PO, INV of Oracle e-Business Suite.
• Involved in troubleshooting issues on Auto Invoice Import Program. Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing. Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Provided with useful training to the users in GL, AR, i-Procurement, PO, INV

Confidential, Costa Mesa, CA

Procure to Pay Functional Consultant

Responsibilities:

• As a Functional Consultant in the Procure to Pay business flows, implemented modules - GL, AR, i-Procurement, PO, INV of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi-currency along with 1 Consolidation SOB. Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system. Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database. Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Developed different reports as per the client’s requirement.
• Trained business owners and business end-users on OM, INV, PO, AR, AP and GL modules as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Confidential, Atlanta, GA

Functional Consultant

Responsibilities:

• Configured the I-procurement module with non-catalog feature.
• Configured the Organization Hierarchy.
• Set up of Inventory Organizations, Sub inventories, Shipping networks, Transaction Sources.
• Configured the tax setups in payables and receivables.
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and
• Approval Management.
• Review the existing Business Processes / Activity Cycles and firming up the “To Be” business processes.
• Configuring the position based Requisition and PO hierarchies for approval management as per the Procurement Policies.
• Implemented the drop-shipment feature of Order management and purchasing.
• Performed the Month end close process involving the intercompany transfers and reconciliation process and maintaining the account code combinations.

Confidential

Order to Cash Functional Consultant

Responsibilities:

• As a Functional Consultant implemented financial modules: GL, AP, and AR, OM, INV and PO Release 11.5.10.2
• Performed all the Configurations and Setups for INV, PO, OM, AR, AP and GL Modules
• Preparing BR30, 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 from BAAN & D1.
• Created New FSG Reports, using multi-currency features including foreign currencies for multi org structures.
• Worked on a customization for Deferred Revenue is AR using Revenue Recognition process. Implemented internal control features using Form Personalization’s for modules GL, AP, and AR. Configured Auto Invoice in AR to import data from the non Oracle ERP instance in Japan.
• Implemented TCA - for AR customer master conversions. Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks.
• Designing and executing ‘Data migration’ strategy for Master and Transactional data. Migrated GL Balances, Budgets, Suppliers, AP open Invoices, Customers, AR open Invoices, Fixed Assets by using ADI tools and loader scripts.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing across all modules.

Confidential

Functional Consultant

Responsibilities:

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Implemented modules: INV, Shipping, Pricing, OM along with PO integrated with internal e-Procure system, Release 11i of oracle (11.5.7).
• Implemented 3 SOB’s (3 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Worked on Revenue recognition in AR.
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc. Implemented Party Relationships in the TCA.
• Setup document validation, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.7, OM, PO, AR & INV).

Confidential

Order to Cash Functional Consultant

Responsibilities:

• Gathering business requirement by having detailed discussions with business team.
• Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
• Review other functional Specifications.
• Worked on the set ups all the modules in Order to cash cycle.
• Preparing various functional requirement and propose high-level design details for programs to keep data in Order Management
• Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
• Prepared high-level technical design document.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, conversions, customizations, testing, training, documentation and implementation of modules.
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements.