SUMMARY

• An Oracle Financials Functional Consultant with over 8.5 years of functional accounting, business analysis in various industries and sectors of the economy in Oracle Applications expertise.
• Possess strong verbal and written communication skills.
• A strong team player, and adaptable to a variety of roles in the Corporate Information System area has great working knowledge of Client/Server technology, and financial applications.
• Also possess the ability to analyze situations and offer innovative cost - effective solutions.
• Conducted and evaluated several Business Process Reviews (BPR) and GAP Analysis to resolve business requirements not addressed by the application.
• Competent in various modules in Oracle Financials 11i.
• Very good experience in the 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 the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Prepared Business Requirements Definition (RD) and Module Design (MD) documents required under the 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 knowledge and interpretation of financial statements such as retained earnings and balance sheet statements
• Configured and implemented applications as per the clients request and the business requirements.
• Created Use-Manuals for programs and user procedures.
• Provided postproduction support.
• Interacted with Oracle Support to resolve application issues.
• Developed business process flows, identified risk points and suggested risk mitigating control measures.
• Good knowledge and understanding of general accounting principal’s “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: Accounts Payables (AP), SLA, Advance Collections, Cash Management, AGIS, Accounts Receivables (AR), Purchasing, Payroll, Advance Collections, General Ledger (GL), Fixed Assets (FA), Costing (CST) and Purchasing.

Methodology: AIM (Applications Implementation Methodology)

Business Intelligence: Working knowledge of Oracle Discoverer

Language: Reasonable understanding of SQL

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

PROFESSIONAL EXPERIENCE

Confidential, Minnesota, MN

Oracle Financials Functional Analyst

Responsibilities:

• Responsible for the complete setup and implementation of AR, FA, Mark View 170 Systems, i-Expense, GL, AP, PO, OM, INV
• Worked on all the setups for the AR, GL, AP, OM, INV, i-Expense, FA Modules
• Worked on conducting JAD Sessions, UAT Sessions, CRP Sessions with the users
• Involved in AS IS and TO BE Process flow development
• Worked on AGILE Life cycle - part of the product backlog development, product backlog grooming, daily standup meetings, retrospective meetings, etc.
• Worked on the business requirements gathering around the Oracle Financials modules
• Worked on Oracle Financials (GL, Payables, Receivables, Assets, Expenses, Collections and Cash Management)
• Worked with Testing team on finalizing the requirements for the functional and end to end scenarios used by the business for users and QA testers.
• Cross Functional Interaction with various teams for information gathering and effective performance delivery.
• Performed all the setups for the GL Module including the setup of the Ledgers (Primary, Secondary and Reporting), define the Calendar and Accounting Flex Field for the Chart of Accounts, Data Access Sets, Ledger Sets, etc.
• Worked on the configuration of AR, GL, Cash Management, INV, PO and FA modules.
• Performed organizational set ups including inventory organizations, locations, freight carriers, items, parameters etc.
• Worked on the Item Master Setups in Inventory module, defining of item templates, categories, catalogs, defining item attributes, enabling items in various organizations, controlling item attribute changes by implementing controls, etc.
• Defined product catalogs and categories in Inventory module

Confidential, Warrensville Heights, OH

Oracle Financials Functional Analyst

Responsibilities:

• Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Canonical Model Definitions, Deriving Use Case scenarios, Flow Diagrams, Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on the setups of the Revenue Recognition process - including define the 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 the COGS as per deferred Revenue schedule.
• Worked on the AP setups of the payment manager
• Worked on the AP Module Invoice approval process
• Worked on the setups of the AR Module - Configuring Auto Invoice, Auto Lock Box, Revenue Recognition (Invoicing and Accounting rules), Collection process, etc.
• Worked on the Advance Collections module - Worked on the 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 the Dunning Letter Setups in Oracle Advance Collections
• Worked on the design of the dunning letters in Oracle AR module and setup the statement cycles.
• Costing - Worked on Standard and Average costing - defined the cost elements, defined cost types, defined activities and activity codes, cost groups, material sub elements, defined overheads, associate expenditure types with cost elements, defined category accounts.
• Worked on the configuration of the Payment Process Profiles in Oracle AP
• Worked on the Retroactive pricing functionality in Oracle PO.
• Worked on the setups of the GL Ledgers (Primary and Secondary), defining Ledger Sets, Data Access Sets, Translation, Revaluation, Designing of the Chart of Accounts, setting up cross validation rules and security rules, etc.
• Worked on the setups and configurations for of the Sub Ledger Accounting module - Accounting Method Builder, Line Types, Account Derivation rules, Journal Line Types, Sub Ledger Accounting methods, Application Accounting Definitions, etc.

Confidential, Seattle, WA

Oracle Financials Analyst

Responsibilities:

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

Confidential, Berkeley, CA

Oracle Finance Analyst

Responsibilities:

• As a Business Analyst Supported the financial modules: GL, Costing, Advance Collections, AP, AR & FA Release 12.1.3
• Lead Conversions & Enhancements for GL, Advance Collections, AP, Costing, AR & FA module
• Worked on the CRM Module of Service Contracts and Install Base modules.
• Worked on the Setups of the Service Contracts module - worked on the 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 the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• Worked on the Revenue Accounting process in Oracle AR
• Worked on the integration of Revenue Accounting software RevPro with Oracle AR
• Worked on the design of a Revenue Forecasting system using Hyperion HFM and Discoverer reports.
• Worked on the setups of Accounting and Invoicing rules in Oracle AR
• Worked on the setups customer acceptance process for revenue contingencies in Oracle AR.
• Worked on the setup of Advance Collections module by setting up the Collection Engine, Collection Rules, Collectors and Dunning Plans.
• Worked on the Mass Additions and Depreciation process in oracle Fixed Assets.
• Worked on the Mass Copy process in Oracle Fixed Assets
• Worked on the depreciation rollback process in Oracle Fixed Assets
• Worked on the Retirement process in oracle Fixed Assets.
• Worked on configuration of the 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
• Worked on Oracle Costing - configuring standard and average costing
• Worked on setting up Cost Elements, Cost Categories, cost types, activities, cost groups, overheads, expenditure types, etc.
• 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 the setups.
• 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, 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 the configuration of AR, AP, Fixed Assets, Costing, Advance Collections, Service Contracts, Install Base, Sub Ledger and GL modules.
• Performed Requirement and GAP analysis.
• Configurations and Setups for AR, AP, GL, Revenue Recognition, Costing, Advance Collections, Sub Ledger Accounting
• Worked on the 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 the Setups of Revenue Recognition including the setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up the Daily Revenue Rule that are new in R12.
• Worked on the Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
• Worked on the Auto Lock box process in Oracle AR module.
• Worked on Auto Accounting in the AR module
• Worked on the Auto Invoice Process in AR 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.

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

Confidential, San Jose, CA

Oracle Financials Functional consultant

Responsibilities:

• As a Functional Consultant implemented the Order to Cash Business flows including OM, AR, AP, GL, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, OM, Advance Collections, GL and AP modules
• Worked on the setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined the Auto Lock Box process in AR module
• Defined the Auto invoice process in AR module
• Worked on the Mass Addition process in Oracle Fixed Assets.
• Worked on the Depreciation process in Oracle Fixed Assets
• Worked on all of the configurations of Oracle Fixed Assets.
• Worked on the setups of the Corporate Book and Tax Book in Fixed Assets
• Worked on the formula based depreciation in Fixed Assets
• Worked on the depreciation roll back process in Fixed Assets
• Worked on the Mass Copy functionality in Fixed Assets
• Worked on the 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 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.
• 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 the SOD Document in System Administration.

Confidential

Oracle Financials Techno Functional Consultant

Responsibilities:

• Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Defined Journal Sources, Journal Categories, Shorthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.

Environment: Oracle Applications - 11.5.10