SUMMARY

• Member of the functional focus team and about 7+ years of IT experience, with primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Functional Consultant specializing in Oracle Application implementations, specifically Oracle Financials modules of AR, AP, e-Business Tax, GL, Fixed Assets, Payments, Sub Ledger Accounting (SLA) and Cash Management.
• Worked on i-Expense and i-Receivables modules.
• Extensive engagement work and project implementation experience has given him an insight into the interactions between Oracle’s modules and project implementation methodologies.
• Business experience and background has helped to foster a detailed knowledge of best practices regarding the accounting and finance functions.

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Oracle Cloud Financials Functional Analyst

Responsibilities:

• As a Cloud Fusion Financials Functional Consultant implemented the Oracle Fusion Cloud Financials modules -General Ledger, Intercompany Accounting, Payables, Receivables, Payments, Cash Management, Tax, Expenses, Assets
• Configured the Enterprise Structure for financials including the setup of the enterprise structure, bank, branches and accounts, ledgers, business units, financial reporting, payables and payments, expense reporting, receivables and payments.
• Worked on the AP Invoices, AR, Billing, Advance Collections and Fixed Assets work areas.
• Used the Functional Setup Manager to perform all the setups for the financials modules.
• Worked on the common financials’ configurations - managing geographies, file import activities, setting up enterprise structure, created the chart of accounts, legal entities and business units.
• Worked on the Revenue Recognition process in AR Module - setting up Accounting and Invoicing rules, defining the daily revenue rules, setting up Customer Acceptance process, deferred revenue, deferred COGS process, etc.
• Worked on the expense configuration - defining the expense system options, defining the expense report templates, setting up expense approval rules, defining conversion rates and polices, etc.
• Worked on the Fixed Assets configurations - defined asset categories, locations and asset books.
• Worked on the Receivables Configuration - defined the common AR configuration, defined the receivables system options, defined customer billing configuration, define customer payments, defined funds capture, defined customers, etc.
• Prepared MD050 and performed functional testing for custom report enlisting compensation details along with YTD summaries for each salesperson
• Prepared and implemented smoke test scripts to test each upgraded instance
• Assisted in rigorous testing of the upgraded instance to identify FITS and GAPS
• Assisted in End User Training and conducting Training Workshops
• Actively involved in preparing cut-over activity tasks, practice upgrades & dry runs

Environment: Oracle Cloud Fusion Financials R13 Implementation - General Ledger, Intercompany Accounting, Payables, Receivables, Payments, Cash Management, Tax, Expenses, Assets

Confidential

Oracle Financials Functional Analyst

Responsibilities:

• As an IT Analyst implemented the following modules: AR, AP, e-Business Tax, GL, Vertex, Fixed Assets, Payments, Sub Ledger Accounting (SLA) and Cash Management modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP and GL modules.
• Worked on the Auto Invoice Setups in the AR module, defining Line Ordering rules, Grouping Rules, Line Transaction Flex Field and Invoice Sources.
• Working on the Functional Design Document for Vertex implementation.
• Working on the Technical Design document for Vertex implementation.
• Building AP and AR Tax processes for the to-be system for Vertex
• Working with business team and gathering Tax requirements for North America for Vertex
• Consulting to ERP business process related to Tax and Vertex components.
• Working on Training modules and process building for the WPI tax department.
• Worked on configuring E-business Tax module for Vertex.
• Defined Customer Master (TCA) module
• Worked on Revenue Recognition Process
• Designed and setup the Accounting and Invoicing rules
• Worked on the customer acceptance process in Revenue Recognition
• Worked on the SOP 97-2 and VSOE Rules in Revenue Recognition process
• Worked on the Deferred COGS and Deferred Revenue process.
• Worked on setting up Auto Lock Box in the AR Module.
• Worked on the AGIS Module
• Worked on the Cash Management setups of Bank Statement Interface, Reconciliation Process.
• 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.
• Configured Oracle AR, OM and Shipping from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for SCEA by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AR, OM, INV and Shipping Modules.

Confidential, Columbus, OH

Oracle Finance Functional Analyst

Responsibilities:

• Worked as a Finance IT Consultant implemented modules - GL, AR, Vertex, e-Business Tax, AP, Sub Ledger Accounting and FA of Oracle e-Business Suite.
• Implemented 12 Ledgers, 4 Reporting Ledgers (10 Operating Units) using MOAC structure, multi currency along with 1 Consolidation Ledger.
• Worked on the oracle General Ledger module - defined the ledgers, data access sets, ledger sets, cross validation rules, security rules, consolidation rules, translation rules, revaluation rules, etc.
• Writing Functional Design Document (FDD) for Functional configurations globally in Vertex.
• Working with adjustments and credits team to ensure taxes are reversed/recalculated as per the adjustments and credits in Vertex
• Working on the conversion of Exemption certificates into Vertex ECM
• 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.
• Functional Designing and executing ‘Data migration’ strategy for Master and Transactional data.
• 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, Emeryville, CA

Oracle Finance Functional Analyst

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 Oracle General Ledger module - designing the chart of accounts, calendar, cross validation rules, security rules, etc.
• 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 the Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing across all modules.