SUMMARY:

• Over 20 years of Oracle Financials experience serving as Oracle Financials Functional Consultant. Primary modules includes General Ledger, Payables, Receivables, iReceivables, Fixed Assets, Cash Management, Advanced Collections, EB - Tax, AGIS and SLA
• Worked as Lead/Principal consultant in full life cycle implementation of Financial Modules release 10.7SC, 11.03, 11i and R12 using AIM, OBA (Oracle Business Accelerator) and R2i Methodology.
• Worked on Functional Planning, System Design, Chart of Account Design, Gathering Requirements, Gap Analysis, Configurations, and Interfaces design, Conversion, Data Migration using API, Chart of Accounts Mapping, Confidential Consolidation, Intercompany, Taxation, Sub Ledger Accounting, Localizations, Mass Allocations, Multi Org, Multi Currency, Grants and Fund accounting, Encumbrance Accounting, CRP, Testing and User Training.
• Employed with big 4 consulting companies Confidential, Confidential, Confidential serving top tier Fortune 500 client.

TECHNICAL SKILLS:

Applications: Oracle Financials 10.7SC, 11.03, 11i and R12

Modules: Confidential, Confidential, Confidential, FA, CE, iReceivables, Advance Collection, EB-Tax & SLA

Environment: Windows NT, UNIX

Others: MS word, Excel, PowerPoint, Visio, Data Loader, Toad and ADI

Methodology: AIM, FFRPM (Fast Forward Rapid Implementation), R2i Methodology

PROFESSIONAL HISTORY:

Confidential

Financials Lead

• Lead a team for General Ledger, Receivables, Payables, Fixed Assets and eB-Tax for the implementation of R12.
• Responsibilities include requirements gathering, design and configuration using BRD and BR100
• General Ledger: Design Chart of Accounts, Security Rules, Cross Validation Rules, Consolidations, creation of FSG reports with Report Managers
• Payables: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor and open Invoice conversion from legacy systems.
• Receivables: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing, Revenue Recognition and Advanced Collections.
• Engaged in the configuration of Sub Ledger Accounting (SLA) for Fixed Assets, Projects and OPM Financials. eB-Tax: Setup Use Tax, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules, Recovery Tax and Self Assesed Tax
• Fixed Assets: Configuration and Conversion
• Engaged in the workshops, CRP, SIT, UAT and training of end users

Confidential, Dallas, TX

Business Analyst

• Demonstrate & influence business partners to leverage industry standard processes & out-of-the-box configuration capabilities in Oracle EBS R12 to satisfy business needs.
• Provide recommendations to address and resolve business issues for a specific business group.
• Support Finance team in closing month end, year end of the books.
• Stream line the process of Journal entry, Payable Invoices, Billing and Revenue recognition.
• Developed reports and training documents.
• Assisted in data integration from Inventory, Project Costing/Billing to General Ledger.
• Modified/corrected Manufacturing Accounting (Inventory, Costing and Billing).
• Develop FSG reports with maximum number of columns, Row Orders and Content Sets.
• Use Oracle Support to search for solutions and open service requests when needed. Coordinate functional activities with Oracle Support.

Confidential, Rockville, MD

Financials Functional Lead

• Lead a team for General Ledger, Receivables, iReceivables, Collections and Payables for a Global implementation of R12
• Responsibilities include requirements gathering, design and configuration using BRD and BR100
• Engaged in functional design of interfaces, conversion, Chart of Accounts Mapping using CV10, MD50 and BR100
• Confidential Configuration: Configured 10 Ledgers with 10 Legal entities, Localizations in EMEA and LATAM, setup Cross Validation Rules, Mass Allocation, Recurring Journals, Auto Reversal, Document Sequencing, Data Security and Intercompany Transactions. Performed Consolidation including Revaluation and Translation
• Configuration of AGIS (Advanced Global Intercompany System).
• Payables configuration: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor and open Invoice conversion from legacy systems.
• Receivables configuration: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing, Revenue Recognition and Advance Collections iReceivables configuration: Responsible for performing the end to end testing of iReceivables integration with Receivables, Payments and other related modules; Design/created Functional Specs BR30, BR100 and TE40 for iReceivables; Configured disputes and created credit memo and customer cross payments.
• Conduct Workshops, Demo, CRP, SIT, UAT and User training

Confidential

Confidential Functional Lead

• Lead a team for General Ledger for a Global implementation of R12
• Responsibilities include requirements gathering, design and configuration using BRD and BR100
• Engaged in functional design of interfaces and conversion using CV10, MD50 and BR100
• Configured 4 Ledgers with 40 Legal entities, setup Cross Validation Rules, Mass Allocation, Recurring Journals, Auto Reversal, Document Sequencing, Data Security and Intercompany Transactions
• Configure AGIS (Advance Global Intercompany System)
• Configured and performed Consolidation including Revaluation and Translation
• Conduct Workshops, Demo, CRP, SIT, UAT and User training

Confidential, Dallas, TX

• Responsibilities include requirements gathering, design and configuration of R12.03 Fixed Assets
• Engaged in functional design of the using BRD, BR100
• Conduct workshop, prototype to show the functionality of R12 Fixed Asset
• Conduct CRP, SIT, UAT and training of users
• Engaged in Conversion and reconciliations of 15K assets from legacy system into Oracle.
• Setup Tax Authority, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules Engine, Product Classifications, Party Classification, Tax Recovery Rates, Tax Determining Factor Sets and Tax Condition Sets

Confidential

• Engaged in the project of integration of Power Plan (Assets legacy system) into Oracle General Ledger.
• Prepared MD-50 functional design document.
• Completed FERC (Federal Energy Regulatory Commission) training during the assignment.

Confidential

• Lead financial team for Confidential, Confidential, Confidential and Confidential . Responsible for designing chart of accounts, Multi currency and Currency translation, cross validation rules, SLA configuration for Payables, Receivables, iReceivables, consolidation and reporting using ADI, FSG and Report Manager tool.
• Engaged in designing, gathering requirements, gap analysis using AIM documentation BR30/BR100.
• Engaged in conversion/interfaces of Confidential data, Customers and Suppliers. Prepared functional design document MD-50 and CV-40
• Performed CRP and prepared test script for testing and design training document.
• Involved in go-live support and closing process.
• Payables configuration: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor and open Invoice conversion from legacy systems.
• Receivables configuration: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing, Revenue Recognition, handling of disputes and payments with iReceivables; deductions and adjustments.
• Develop Test Scripts, performed CRP testing, end user training
• Resolved open SR’s and support Post go live issues, month end closing and user training

Confidential

• Implementation of Confidential, assisted client in cleansing customer data, analyzed current Business Process, resolving customer duplication issues and application of discounts.
• Created Match Rules for Customer Search and for Identifying and Preventing Customers Duplications using DQM (Data Quality Management).

Confidential

• Lead a team in a project of re-organization; mapping new structure; creation of cross validation rules; alignment of resources and expenses into their natural account / department by activity; Confidential Allocations for Shared Services/Indirect expenses; identified account generation changes to support new structure; eliminations/ consolidations, AGIS functionality within Confidential ; Update the IS Reporting Tool for the structure changes.
• Financials implementations using Oracle Business Accelerator. Involved in Designing, Planning, Data Conversion, CRP, UAT, SIT and end user training.
• Responsible for Cash Management configurations, Bank setup, bank reconciliations, cash forecast, cash pools and cash positioning.
• Transfer and posting of cash transactions into Confidential
• Configured Revenue Recognition.
• Responsible for Receivables, iReceivables configurations, customer setup and conversion; customization for cash application, collections and rebates.
• Developed user’s security using MOAC functionality
• Configuring EB-Tax: Setup Tax Authority, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules Engine, Product Classifications, Party Classification and Tax Recovery Rates
• Resolved open SR’s and post-go live issues
• Engaged in month end close process, reporting, reconciliations using Report Manager and FSG reporting tools

Confidential

• Engaged in the assessment of R12 upgrade from 11i
• Reviewed business process of Grants accounting and Disbursement of Funds.
• Analyzed existing Assets systems, gathered information, and performed Gap analysis.
• Design, plan, proposed, and made recommendations based on the R12 features of Fixed Assets. Assist technical team in the process of conversion.

Confidential, Redwood Shore, CA

• Engaged in implementing Financial Accounting Hub (FAH) for a major International Bank.
• Involved in Planning, Designing, Business Process Review, created Functional Documents (MD 50), BR 100.
• Made recommendations based on the Business Process Review and Gap Analysis.
• Setup includes: Event Entity Model, Process Categories, Event Classes, Event Types, Event Class options, User Transaction Identifiers, Assign Transaction Objects, Create and assign Sources, Sources and source options, Source Assignments, Accounting Attributes, Journal Line Types, Journal Line Descriptions, Journal Line Definitions, Application Accounting Definition and Account Derivation Rules, Create Subledger Accounting Method

Confidential

• Responsibilities include designing business processes, defining user requirements, conducting fit-gap analysis, designing functional specifications for interfaces/conversions from legacy into Oracle application, CRP and end-user training.
• Engaged in setup of Fixed Assets, successfully resolved issues on Conversion of assets, Corporate and Tax Depreciation, Group Asset, Group Depreciation, Mass Addition, Tax upload and closing Corporate and Tax books. Reviewed Business process and recommended changes to resolve the issues.
• EB-Tax: Setup Tax Authority, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules Engine, Product Classifications, Party Classification, Tax Recovery Rates, Tax Determining Factor Sets and Tax Condition Sets
• Receivables: Customer/Party relationship, Invoice and Customer conversion, customization of billing, cash application rebates and deductions.

Confidential

• Lead a team to plan and design General Ledger interfaces with multiple third party partner and non-partner products and reports. Responsible for business process review, GAP analysis, and configuration of General Ledger, AGIS (Advance Global Intercompany System), Localizations of EMEA, configuration for Global Implementation using AIM methodology.

Confidential

• Conducted 5 day workshop on Release 12 for a major transportation industry and addressed following areas:
• Multi Org Access Control (MOAC), A/R, FA Subledger Accounting setup and process, EB-Tax, Data security, posting to Confidential process and Confidential to Subledger Drilldown

Confidential

• Responsible for setting up Customers, Bank, Auto Accounting, Intercompany Transactions, Multiple Currencies, Auto lockbox processing, Cash Applications, Discounts, Claims, Revenue Recognition and Collections.
• Setting up Scoring, Strategies, Dunning Plans, Delinquencies and Workflow for Promise Approval, Reconciling payments/promises and Automate communication, actions and timing for Advanced Collections.
• Create new Categories and Books in Fixed Assets for new companies and engaged in resolving issues and closing the book.
• Reviewed Business process and recommended changes to resolve the issues.

Confidential

General Ledger, Receivables, Payables and Cash Management (Reimplementation from Release 11i to Release 12)

• Financials lead, responsible for full life cycle implementation, planning, system design, Gap analysis and requirement gathering.
• Involved in functional design of interface and configuration of General Ledger, designing Chart of Accounts, made recommendations on new segments for financial reporting.
• Updated Client accounting policies and procedures to support compliance with the IFRS standards, as well as ensure consistency throughout the operations.
• Involved in Intercompany transactions and reconciliation.
• Performed Consolidations, documented Functional design of conversion of Confidential balances, Receivables and Payables from legacy (third Party) system using AIM documents.
• Involved in data conversion from legacy system to Oracle application of customers, vendors and General Ledger balances.
• Responsible for CRP; creating/developing Test Scripts and Training Materials.
• Conducted Testing, End User training, developed month end closing process for the client and resolved post go-live issues.

Confidential, Dallas, TX

General Ledger, Fixed Assets and Receivables Release 11i

• Responsibilities included functional design of General Ledger interfaces and reports, Setups of General Ledger, Fixed Assets and Accounts Receivable in Multi-Org, Multi currencies. Consolidation of data and unit testing for version 11.5.10.2 using AIM methodology.

Confidential, Dallas, TX

• Engaged in a project of Setup of Mass Allocation, made correction of allocations, formulas, which facilitate the reporting and closing process.
• Responsibilities included maintaining Chart of Accounts; creating Financial Reports using FSG and Business Object; creating Recurring Journal entries; Upload Journal Entries using ADI; maintaining and uploading Budget, uploading Confidential, Confidential into Confidential through interface;
• Implement Encumbrance Accounting; configure Grants and Fund accounting; Disbursement/allocation of Grants and Funds using Oracle ‘Mass Allocation’ feature.
• Updating and creating Cross Validation and Securities Rules; Reconciling sub ledger with Confidential and closing the sub ledger.
• Assisted team in the upgrade of Confidential, Confidential and Confidential from 10.SC to 11.5.10.
• Lead a team in implementing Fixed Assets in compliance with GASB 34/35. Design/develop the conversion process and reconciliation.

Confidential, Dallas, TX

General Ledger, Receivables, Payables Release 11i

• Responsibilities included Track lead for General Ledger, Accounts Payable and Fixed Assets and related activities such as configuration of all functional setups of Set of Books with Multiple Currencies, Intercompany Transactions, Conversion of Assets, Vendor, Open Invoices and Employees. Co-coordinated with client resources. Interfacing with the client’s management team and implementing new processes. Created Financial Reports using FSG. Resolved “go-live” issues and end-user training.

SENIOR CONSULTANT

Confidential, West Orange, NJ

General Ledger/FSG/ADI Release 11.03

Confidential

• Lead a team implementing Oracle Financials version 11.03 using Fast Forward Financials RPM methodology.
• Responsibilities included activities such as solution design; configuration of all functional setups of Set of Books with Multiple Currencies, Mass Allocation, Intercompany, Securities Rules and Cross Validation Rules.
• Other responsibilities included preparation of Financial Reports using FSG and ADIMonth and year-end closing process, conversion, testing and end-user training.
• Resolved “go-live” issues and end-user training.

ACCOUNTANT

Confidential, Santa Monica, CA

• Maintained and follow up sales of 20 outlets throughout Confidential (average sales volume $ 6.5 million per month).
• Maintained General ledger and served as project manager of several projects.
• Projects include internal auditing of accounts, cash and inventory management.
• Supervised Accounts receivable and Accounts payable of foreign and local suppliers.
• Implemented and monitored internal control systems and Inventory management.