SUMMARY

• An Oracle Financials Functional Consultant with over 9.5 years of functional accounting, business analysis in various industries and sectors of teh economy in Oracle Applications expertise.
• Possess strong verbal and written communication skills.
• A strong team player, and adaptable to a variety of roles in teh Corporate Information System area has great working noledge of Client/Server technology, and financial applications.
• Also possess teh ability to analyze situations and offer innovative cost TEMPeffective solutions.
• Conducted and evaluated several Business Process Reviews (BPR) and GAP Analysis to resolve business requirements not addressed by teh application.
• Competent in various modules in Oracle Financials 11i.
• 3 Full Life Cycle in Release 12
• Very good experience in teh Order to Cash, Record to Report and Procure to pay flow.
• Extensive experience with Oracle CRM Modules of Service Contracts and Install Base.
• Competent in understanding teh functionality of teh core Oracle Financial modules and their interplay in teh overall accounting structure of an organization.
• Prepared Business Requirements Definition (RD) and Module Design (MD) documents required under teh AIM methodology.
• Developed test case, test plan and resting process and conduct core team and end user training.
• Worked on Revenue Recognition and Deferred COGS functionality.
• Experience with Vertex Tax Software integrating it with Oracle AR Module.
• Conducted several UAT’S and CRP’S in Oracle Applications
• Good working noledge and interpretation of financial statements such as retained earnings and balance sheet statements
• Configured and implemented applications as per teh clients request and teh business requirements.
• Created Use - Manuals for programs and user procedures.
• Provided post production support.
• Interacted with Oracle Support to resolve application issues.
• Developed business process flows, identified risk points and suggested risk mitigating control measures.
• Good noledge and understanding of general accounting principals “GAAP”.
• Excellent planning and organizational skills.
• Team oriented, self-motivated and a disciplined individual.

TECHNICAL SKILLS

Functional: Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup

ERP: Oracle Financials (12.0.5, 10.7 and 11i)

Modules: Advance Pricing, Accounts Payables (AP), SLA, Advance Collections, Cash Management, AGISAccounts Receivables (AR), Treasury ManagementPurchasing, Payroll, Record-to-Report, Advance Collections, General Ledger (GL), Fixed Assets (FA),, me-Expense, e-Business Tax and Purchasing.

Methodology: AIM (Applications Implementation Methodology)

Business Intelligence: Working noledge of Oracle Discoverer

Language: Reasonable understanding of SQL

Oracle and Other Tools: Data loader, ADI, Web ADI and MS-Office tools including Visio / MS Projects

PROFESSIONAL EXPERIENCE

Confidential, Ada, MI

Oracle Financials Functional Analyst

Responsibilities:

• Preparing of all of teh Functional Specification Documents (FSD), Business Requirement Documents (BRD), Canonical Model Definitions, and Deriving Use Case scenarios, Flow Diagrams, Data Mapping Documents (DMD) and Functional Testing Documents.
• As a Functional Consultant implemented teh flows for Record to Report Track - AR, Treasury Management, Cash Management, Fixed Assets, Enterprise Asset Management (EAM), e-Business Tax, GL and AGIS modules.
• Worked on teh AR, Advance Pricing, Treasury Management, Cash Management, Fixed Assets, Enterprise Asset Management (EAM), e-Business Tax, GL and AGIS
• Actively participated in Requirements Gathering, System Analysis, Gap Analysis, Data Cleansing, Data Conversion and Business Process mapping to Oracle Applications for teh Record to Report track
• Worked on teh setups of teh Revenue Recognition process - including define teh Revenue Rules, defining Rule Base and Event based Revenue Recognition, defining customer acceptance process - pre and post billing, setting up customer contingencies, setting up daily revenue rules, deferring teh COGS as per deferred Revenue schedule.
• Worked on teh AP setups of teh payment manager
• Worked on teh AP Module Invoice approval process
• Worked on teh setups of teh AR Module - Configuring Auto Invoice, Auto Lock Box, Revenue Recognition (Invoicing and Accounting rules), Collection process, etc.
• Worked on teh Advance Collections module - Worked on teh process flows for strategies, process flows for dunning plans, process flow later stage delinquencies, process flows for campaigns, etc.
• Worked on Advance Collections module - Collections Engine, Bankruptcy, write offs, litigation, repossession, changing work items in a strategy, reporting and transferring cases to external parties, using preconfigured components, etc.
• Worked on teh Dunning Letter Setups in Oracle Advance Collections
• Worked on teh design of teh dunning letters in Oracle AR module and setup teh statement cycles.
• Worked on setups of Advance Pricing
• Worked on teh configuration of teh Payment Process Profiles in Oracle AP
• Worked on teh Retroactive pricing functionality in Oracle PO.
• Worked on teh setups of teh GL Ledgers (Primary and Secondary), defining Ledger Sets, Data Access Sets, Translation, Revaluation, Designing of teh Chart of Accounts, setting up cross validation rules and security rules, etc.
• Worked on teh setups and configurations for of teh Sub Ledger Accounting module - Accounting Method Builder, Line Types, Account Derivation rules, Journal Line Types, Sub Ledger Accounting methods, Application Accounting Definitions, etc.
• As part of teh Production Support team - worked on handling teh help desk tickets
• Routinely involved with period close and book closure activities.
• Worked on prioritizing teh help desk open requests
• Worked on teh support of teh users for new enhancement requests.
• Supported teh users for developing ad hoc reports as part of teh reconciliation process
• Supported teh interface issues and resolved teh errors
• As part of teh production support team - worked on resolving workflow issues
• Supported teh users for developing of new error reporting alerts (periodic and event)
• Supported teh users in resolving performance issues in teh system
• Worked on teh close process with teh users
• Supported teh streamlining of closing of teh modules in oracle e-business suite
• Resolved issues on a daily basis with interfaces dat we coming in from suppliers with ASN Information
• Worked on teh support of teh Auto Invoice interface dat loaded invoices from external sources into oracle
• Supported teh Auto Lock box interface with Wells Fargo Bank
• Supported teh ACH process in teh AP Module
• Supported teh AP Payment Manager process
• Supported teh Loading of journal into GL from external sources using teh GL Interface
• Supported teh FSG report development in GL module
• Supported and resolved issues with teh Approval process in Purchasing module
• Supported teh users in closing teh books - helping with reconciliation issues, interface issues, ad hoc reports needed to support reconciliation, etc.
• Supported teh users with resolving performance related issues
• Supported teh Order to Cash and Procure to Pay processes
• Supported new code introduction into production - by having code review meetings, business impact meetings with teh users, etc.

Confidential, Houston, TX

Oracle Financials Analyst

Responsibilities:

• Actively involved in implementation of E-business suit for SGP Operating Unit including gathering teh requirements from teh user and understanding their business model teh modules worked on includesAR, AP,, me-Expense, e-Business Tax, Advance Collections, Advance Pricing, FAH, GL and FA Modules
• Worked on all teh Business Analysis of developing teh GAP Analysis, Business Requirement Documents (BRD’S), Functional Specification Documents (FSD), MD050, BR100, TE020, Te030, etc.
• Performed all of teh setups for teh AR Module including teh setups Lock Box, Auto Invoice, Revenue Recognition Process, Invoicing and Accounting rules.
• Supported teh Invoice to Cash and Record to Report Flows (AR, FA, GL) modules.
• Developed teh Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all of teh customizations and data conversions.
• Worked on teh Advance Collections module - process flows for strategies, dunning plans, later stage delinquencies, campaigns, etc.
• Worked on teh configuration of Advance Collections module - defining teh collection elements, setting up teh scoring elements, defining teh scoring engine, etc.
• Worked on teh Advance Collections reports like campaign outcome summary, collector outcome summary, payment campaign summary report, etc.
• Worked on teh Dunning Letter Setups in Oracle Advance Collections
• Configured teh cycles for dunning letters, setup categories of dunning letters for different customers.
• Worked on teh Payment Manager in AP Module.
• Worked on teh Payment Process profile in AP Module
• Worked on teh configurations of teh Payable Options in Oracle AP
• Worked on teh configurations of AR, AP and GL module.
• Reviewing Functional Specifications / Change requests with teh client.
• Worked on teh Revenue Recognition process in AR Module.
• Worked on teh integration of Revenue Recognition software RevPro with Oracle AR
• Worked on defining Revenue Rules in RevPro
• Worked on teh setups of Accounting and Invoicing rules for Revenue Recognition.
• Defined Revenue Contingencies for Revenue Recognition
• Worked on Daily Revenue rules in Oracle revenue recognition
• Worked on teh Ledger Configuration (Primary and Secondary) in Oracle GL
• Worked on defining Ledger Sets and data Access sets in GL
• Worked on teh design of teh Chart of Accounts in GL module
• Worked on Revaluation and Translation in Oracle GL Module
• Communicating teh requirements to teh technical team
• Preparing design document as per teh functional requirements
• Preparing System / Integration Test cases and carrying out Integration testing
• Supporting teh users with teh User Acceptance Testing (UAT)
• Taking part in teh review of test cases and giving necessary inputs.
• End-user training
• Updating teh client on teh status of teh project at offshore, almost everyday.
• Reviewing and giving inputs on all teh developed components, Unit test Plan and Unit test report.

Confidential, Milpitas, CA

Oracle Finance Analyst

Responsibilities:

• As a Business Analyst Supported teh financial modules: GL, Advance Collections, Advance Pricing, AP, AR & FA Release 12.1.3
• Lead Conversions & Enhancements for R2R, GL, Advance Collections,, me-Expense, e-Business Tax, AP, AR & FA module
• Worked on teh CRM Module of Service Contracts and Install Base modules.
• Worked on teh Setups of teh Service Contracts module - worked on teh Contracts Main Billing Program, defining billing streams, coverage templates, service items, worked on usage based billing, etc.
• Worked on setting up of Revenue Recognition process in AR Module
• Defined teh Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• Worked on teh Revenue Accounting process in Oracle AR
• Worked on teh integration of Revenue Accounting software Rev Pro with Oracle AR
• Worked on teh design of a Revenue Forecasting system using Hyperion HFM and Discoverer reports.
• Worked on teh setups of Accounting and Invoicing rules in Oracle AR
• Worked on teh setups customer acceptance process for revenue contingencies in Oracle AR.
• Worked on teh setup of Advance Collections module by setting up teh Collection Engine, Collection Rules, Collectors and Dunning Plans.
• Worked on teh Mass Additions and Depreciation process in oracle Fixed Assets.
• Worked on teh Mass Copy process in Oracle Fixed Assets
• Worked on teh depreciation rollback process in Oracle Fixed Assets
• Worked on teh Retirement process in oracle Fixed Assets.
• Worked on configuration of teh Ledger in oracle GL
• Worked on Translation and Revaluation in Oracle GL
• Worked on Mass Allocation process in GL Module
• Worked on defining cross validation and security rules in GL Module
• 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 OM, Advance Collections, AR, INV and GL modules from scratch and simultaneously created BR100 documentation for teh setups.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all teh above modules.
• Provided with useful training to teh users in GL, Advance Collections, AP, AR & FA.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, NJ

Oracle Finance Analyst

Responsibilities:

• Worked in teh configuration of AR, AP, Fixed Assets, Advance Collections, Service Contracts, Install Base, Sub Ledger and GL modules.
• Performed Requirement and GAP analysis.
• Configurations and Setups for R2R, AR, AP, GL, Revenue Recognition, Advance Collections, Sub Ledger Accounting
• Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• 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.
• Involved in teh Setups of Revenue Recognition including teh setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up teh Daily Revenue Rule dat are new in R12.
• Worked on teh Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
• Worked on teh Auto Lock box process in Oracle AR module.
• Worked on Auto Accounting in teh AR module
• Worked on teh Auto Invoice Process in AR Module.
• Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work.

Environment: - Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US and Canada OM, AR, AP, GL, Advance Collections, INV and PO modules

Confidential, San Jose, CA

Oracle Financials Functional consultant

Responsibilities:

• As a Functional Consultant implemented teh Order to Cash Business flows including OM, AR, AP, GL, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, OM,, me-Expense, Advance Pricing, e-Business Tax, Advance Collections, GL and AP modules
• Worked on teh setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined teh Auto Lock Box process in AR module
• Defined teh Auto invoice process in AR module
• Worked on teh Mass Addition process in Oracle Fixed Assets.
• Worked on teh Depreciation process in Oracle Fixed Assets
• Worked on all of teh configurations of Oracle Fixed Assets.
• Worked on teh setups of teh Corporate Book and Tax Book in Fixed Assets
• Worked on teh formula based depreciation in Fixed Assets
• Worked on teh depreciation roll back process in Fixed Assets
• Worked on teh Mass Copy functionality in Fixed Assets
• Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• 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.
• Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work.
• 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
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per teh SOD Document in System Administration.

Confidential, Sunnyvale, CA

Oracle Apps Functional consultant

Responsibilities:

• As a Functional Consultant implemented teh following modules: AR, AP, GL, Advance Pricing, me-Expense, e-Business Tax, OM, INV, Shipping and Advance Pricing modules.
• Worked on teh Functional mapping of data Conversions & Enhancements for OM, INV, PO, AR, AP and GL modules.
• 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 - Including teh setups of Revenue Recognition process, defining of Accounting and Invoicing rules.
• 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 teh 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.
• Conducted Regression testing to examine teh TEMPeffects of a new Org on teh previous Org.
• Conducted Multi-Org Revert Testing to create an TEMPeffective Revert Plan for WVI, as and when required.
• Successfully provided Technical and Functional support to teh users, testers and Business System Analysts.
• Provided with useful training to teh users in GL, AR, WMS, OM, INV and Shipping Modules.

Confidential, San Francisco, CA

Oracle Apps Techno Functional resource

Responsibilities:

• Requirements gathering from end users, Requirement analysis
• Mapping teh functionality in Oracle product and performing Gap analysis
• Configuring teh product in teh system
• Key user training and user manual preparations
• Preparation of test methodology, test guidelines
• Preparations of System test plans and integration test plans
• Preparing BRD document, BR100, CV040
• Preparing Functional Specification document for Extension, Customization & Reports
• Assisting Conversion team with data analysis and data preparation
• Post Production support