EXPERIENCE SUMMARY:

• An experienced Oracle E - Business Suite Functional Lead having over 14 years of experience in 3 countries.
• 12 years managing and implementing Oracle Financials, Project Accounting and Supply Chain Apps in implementation, global roll-outs, enhancements and support projects.
• 3 yrs Executive - Accounts as Oracle user in manufacturing company.
• Industries include IT Consultancy, Utility (Electricity Generation, Transmission & Distribution), Oil & Gas, Manufacturing and Telecommunications.
• Multiple full project life cycles with Oracle Applications Releases 11i & 12.1.3 through SDLC model from requirement gathering to deployment phase and post go-live support.
• Global solution design & rollouts of core solutions for Financial, Supply Chain and Subledger Accounting based on US GAAP, IFRS and Tax ledgers requirement
• Data Conversion for Vendor & Customer Master, Open Transactions of PR, PO, Receipts, AP Invoices, AR Invoices & Receipts, FA and TB Load.
• Proactively working to achieve project objectives within defined project scope.
• Prepared and coordinated Unit Testing, System Integration and User Acceptance Tests
• Creating Issue Log and documented testing issues, assigning to the team and proper follow up.
• Coordinated reporting on the various aspects of the project such as data conversion, document management (SharePoint), training material preparation with screen shots and training schedules, testing, production readiness, and post-production support.
• Multi-Org structure, Legal Entity, OU, Ledger, SOA, Inventory, Purchasing, AP, AR, PO, FA, OM, Project Costing & Billing, Inventory and Intercompany Oracle EBS R12 setup.
• Subledger Accounting - Standard and Custom based on local requirement
• Procure to Pay processes for both expense and inventory requirements; including PR-PO, Purchase Accounting, Receiving, Transaction Flows and Accruals
• Oracle Receivables System Options, Auto Accounting, Transaction Types & Sources, Receipt Classes & Payment Method and Auto Lockbox. iSupplier Portal - PO, Invoice, Notification based on SOA hierarchy
• Inventory config, Material Transactions, Item Master upload, MIN-MAX & ROP Planning
• Billing Workbench to Revenue and invoicing cycle for Oil & Gas industry
• Assets Management through Fixed Assets; Depreciation Acctg, FA Book & Category setup
• Projects Costing, Capitalization and Billing cycle
• Created custom interfaces, reports, programs and scripts while working on custom business processes on required functionality.
• Worked on cross-application integration across Oracle Financials and SCM modules.
• Oracle HCM Payroll Costing JE interface to Oracle GL in different ledgers with SLA rules
• Oracle Application Implementation Methodology (AIM) and Oracle documentation - Functional Specs, BR100, MD50, Test Scripts, SOP documentation.
• SQL*PLUS and P/L*SQL cursors (TOAD, PL/SQL Developer)
• EIS Reporting Tool; Writing report queries and table mapping
• Complete and detailed functional and technical designs (MD50s and MD70s)
• Thorough understanding for Oracle’s open interface tables and related data conversions for Purchasing, GL, Payables, Receivables, Fixed Assets and Projects.
• Database schema knowledge for Oracle Inventory, Purchasing, Payables, General Ledger, Receivables, Projects and Fixed Assets.
• Oracle Environment, Deliverables and Document Repository:
• Managed different Oracle instances to complete SDLC phases. Worked on DEV, TEST, QA, UAT and PROD instances during project including refresh and patch application.
• Worked on TFS to manage custom components during project management with version control and review of documentation.
• Capture, prioritize and track work items to ensure transparency and reporting
• SharePoint document management for every Project Management, Managing Processes and User Access.
• Prepared Test Schedules, Test Plans (TE050), Test Scripts (TE020)
• Documentation of Issue Log and coordinated with team and business users. professional experience

SKILLS SUMMARY:

Business Process End-to-End Skills:

Record to Report - Accounting

Acquire to Retire - Capital

Procure to Pay - Inventory, Purchasing, iProcurement & iSupplier, AP, Payments

Projects Costing & Billing - Project Accounting and Capitalization cycle

Order to Cash - Order Management

Microsoft Office Suite: Word, Excel, PowerPoint, Visio, Projects

Oracle E-Business Suite Functional & Development

PROFESSIONAL EXPERIENCE:

Confidential

Functional Lead

Responsibilities:

• Functional Lead of global roll-outs based on SDCL cycle.
• Setup for new legal entity, COA, Primary and Secondary Ledgers (IFRS, STAT & USD)
• Configuration of Inventory, GL, Purchasing, AP, AR, FA, EBTAX
• Config, testing and sign off for custom SLA rules for foreign and local vendor base invoices, Payables, Receivables and Accounting Report to display Customer Name.
• Setup Suppliers’ sites and Customer Master
• Inventory Item upload for PO and IR, Defining Item Standard Costs, Open Transactions
• PR, PO & RCPT upload for new org (open for receiving), SOA definition for approvals and customize PO Charge & Accrual Accounts based on business requirement.
• Preparing Test scenarios, UAT sign off, Data Migration and co-ordination with business partners for requirement gathering, documentation and managing Share Point.
• Post Go-Live Support, Month end closure activities for multiple ledgers and produce FSG reports for business. Manage Issue Tracker.
• Provided intercompany (Lease Revenue & Expense) processes solution and mapped in Oracle EBS and .NET custom application.
• Oracle Payroll Journals (HCM) - INTERNATIONAL & LOCAL - interface to GL INTERFACE with custom SLA rule for Primary & Secondary Ledgers
• Worked on custom tables to create Financials reports for month-end close and other financial / operational reporting requirements.
• Reconciliation of Oracle Subledgers (AP, AR, FA, PO, INV, PA) to GL
• Developed interface from Oracle Purchasing to pull PO cost / qty for each activity of Project
• Interface developed for Payables (Act Cost) and General Ledger to import data in Primavera
• Decommission of Discoverer and EIS - Enterprise Information System implementation
• Worked and managed technical configuration and migration of 700+ Oracle EBS (PO, AP, AR, FA, GL & custom) reports to EIS eXpress based on prioritizing business requirement.
• Worked extensively on ARM - Account Reconciliation Mgt for all Oracle EBS modules.
• Worked on Financial Planning model in Hyperion.
• Co-ordination with business leads, documentation of requirement gathering and dealing with third party implementation partner.
• Worked on data migration strategy through FDMEE, EBS adopter and ETL for ARM and EPM
• Working on iSupplier Schedule and requirement gathering to migrate .NET business processes to Oracle EBS.
• Project Scope includes iSupplier portal - iSupplier User Registration, Purchase Order (Standard & Blanket), Revision and change history of PO, Invoice creation (PO & Non-PO), Payment status and information, Supplier Contact Information, Notification (Communication) From/To Buyers and Customization of Payment Request form.
• Customized Billing Workbench application to interface billing and invoice data into AR.
• Worked on enhancement for Job/Contract data base to bill based on services and contract.

Confidential, NY

Functional Lead (Oracle EBS Financials & Projects)

Responsibilities:

• Setup for new legal entity addition in existing Oracle EBS environment
• Config and testing for SLA rules, Payables, Receivables, Projects and EBTAX and provide UAT results to the business for sign off.
• Prepared Test Schedules, Test Plans (TE050), Test Scripts (TE020)
• Documentation of Issue Log and coordinated / managed with team and business users.
• Month end closure activities for multiple ledgers and produce FSG reports for business
• Lead role in Support Team for monthly Financial and Projects modules closure for 115 OUs across world in collaboration with technical team.
• Month End closure functional/technical issues, co-ordination with DBAs and Business users
• Managed custom programs (Per Diem Differential Calculator etc) through documentation, testing and moving in production.

Confidential, Houston, TX

Functional Lead (Oracle Financials & Projects)

Responsibilities:

• Worked on upgrade project to Release 12.1.3 for Oracle Financials through AIM.
• Prepared and coordinated Unit Testing, System Integration and User Acceptance Tests
• Creating Issue Log and documented testing and fixing UAT issues.
• Coordinated reporting on the various aspects of the project such as data conversions, document management (SharePoint), training material preparation with screen shots and post-production support.
• Prepared Functional Documents and Test Scripts for Oracle Financials, Project Costing & Billing in Multi Org and MRC environment for UAT.
• Created BR100 and set up Test & Production environment for SLA, Ledgers (Primary & Reporting), Purchasing, Inventory, GL, Payables, Receivables, Order Management, Fixed Assets, Project Costing and Billing.
• Open PR, PO, Receipts data migration, Inventory Item upload with std costs
• Used Cross Charge functionality and billing form customization in Project Accounting through events, addition of new Expenditure Orgs, Types, Auto Accounting rule, Provider & Receiver control and Bill Rate Schedules.
• Handled Data Migration of Vendor & Customers Masters, Open AP & AR Invoices Load, Fixed Assets book creation (Web ADI) and Open POs & Receipts load.
• Worked on Order Management: Entering SO to Ship Confirm (COGS Account), interface to AR (Invoice & Receipt), Cash Management (Bank Reco) and m/end AR-GL Reconciliation.
• Handled month end closure support for Revenue and Cost of Sales and Project Billing through reconciliation.
• Oracle Financials and Project Costing implementation through AIM methodology.
• Separate Legal Entity, Operating Unit and ledger setup during Oracle EBS R12 roll out
• Data Conversion & sign off of Vendors / Customers / PO/ Inventory / AP / AR / OM/ GL TB and Projects
• Prepared Config document (BR100), MD.50 and done set up in SIT / UAT and Production for Accounts Payables, Fixed Assets and Projects Costing & Billing.
• Legacy to Oracle COA mapping and trial balance upload.
• Performed test scripts during SIT & UAT test cycles with issue tracker and sign off.
• Made changes at Vendor Site level to change payment Term Date Basis based on Invoice Received Date for invoices. Updated Global Vendor Master through rollout.
• Mass Retirement of Assets in one book and addition to new book with remaining life and NBV in resp. countries’ currency through Tax Interface table as a part of global assets sale.
• Worked on consolidation and created different books based on legacy financial structure (FCS COA) and mapped with International Oracle COA.
• Worked on legacy to Oracle AR & AP integration on Interco tranx created in Lawson system
• Created and interfaced to Lawson Intercompany Suppliers & Customers Master database.
• Oracle AR & AP setups, testing, sign off and global roll out for intercompany transactions.

Confidential

Functional Consultant

Responsibilities:

• Used Project Management to map Project Program reporting requirement. Handled data interfaced from Project Costing to Project Management.
• In Procure-to-Pay and Order-to-Cash cycle, prepared Functional Documents (FD), Test Scripts for Inventory, PO, PA, FA, GL, AP, AR and conducted CRP & UAT.
• Developed functionality of the Custom Account Generators for Project Auto Accounting.
• Primarily responsible for config / setups of Oracle EBS Financials & SCM modules, testing, BR.30, BP.50, BP80, MD 50/70 and BR.100 documentations and workflows. Prepared Functional Documents (FD), Test Scripts and handled Custom Report.
• Configured set up for Test, Dev, UAT and Production instances for Financials - Ledgers, GL, Payables, Receivables, Fixed Assets and Project Costing & Billing and developed Project Fund Status Report including budgeting and forecasting data.

Confidential

Package Solution Consultant

Responsibilities:

• Worked in Implementation & Production support for 11i instance as a Team Lead.
• Responsible for leading a functional team for Procure-to-Pay and Order-to-Cash cycles in E-Business Suite - Project Costing & Billing, AP, FA, AR, GL, CM modules. Lead the team of 8 resources. Had been to France with the team during Knowledge Acquisition phase.
• Business Requirement mapping for Fixed Assets and Project Costing and developed Functional Specs (MD.50) for RICE Components.
• Performed functional testing for existing business processes and developed test scenarios
• Implemented Fixed Assets and Project Costing for Michelin Russia as roll out in R12.
• Responsible for Daily Production Planning reports of all the modules and weekly Support Status meeting with the client as business requirement.
• Handled complex issues in Accounts Payable, Project Costing, Fixed Assets and General Ledger as functional & technical aspects of the project. Handled PA to GL Reconciliation.
• Prepared documents for different business processes, AID (interfaces) and related issues.

Confidential

Consulting Analyst

Responsibilities:

• Worked as a Functional Analyst in providing support in Oracle Applications Financials & Projects to prestigious Communication sector giant BT.
• Had been to UK for enhancement work on project of Chorus–a group company of BT.
• Handled Capitalization cycle - Project Costing, Accounts Payable, Fixed Assets, General Ledger & iExpense modules during project.
• Prepared test documents based on test scenario and got sign off for release in production.
• Handled Performance Appraisal of Functional team during 2007-08.
• Handled transactions issues related to BT legacy system and transformation to Oracle Apps. (Various interfaces to Oracle Projects, AP and GL interface tables)
• Handled Change Management & Release Management processes to migrate any functional or technical change into production environment.