SUMMARY

• 9+ years of IT Experience, which includes experience as Confidential Functional Consultant/Business Analyst with specialization in Oracle Financial and Distribution Systems Her industry experience revolves around Oracle ERP Applications - Implementation, Support and Upgrade.
• Well conversant Oracle Financial Modules AR, AP, GL, Fixed Assets, OM, INV, Project Costing, Project Billing, Project Resource Management and Advance Pricing
• 2 full life cycle implementations in Release 12.
• She well understands for both the “Record to Report”, “Quote to Cash” process as well as the “Procure to Pay” process.
• Well conversant with Configuring Oracle Application modules as well as understanding the underlying schema, which give her Confidential better insight into converting user requirements into functional and technical specifications.
• Very good understanding of the Revenue Recognition Process and US Accounting Standards ofUS GAAP, Best Estimated Selling Price (BESP) Analysis, Relative Selling Price Allocation, Residual Allocation (SOP 98-9), VSOE Discounts, and VSOE.
• Experience with Revenue Management tool - RevPro.
• Worked on Oracle Discoverer reporting - Worked on versions 4i and 10g
• Worked on Oracle Financials Statement Generator reports.
• Extensive experience with Training of End Users and Business Super Users using Oracle Tutor, WebEx virtual training and well as conducting of CRP’s and UAT’s. Well versed in preparing training material and training manuals.
• Responsible for testing of the functionality of Oracle ERP Application.
• Worked on documentation as per the AIM methodology.
• Involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions.
• Involved Conference Room Pilots and User Acceptance Testing.
• Responsibilities also include building, testing & development as per Business Requirements.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior Financials Functional Analyst

Responsibilities:

• Actively involved in implementation and integration activities with modules such as- General Ledger, Account Receivables, Accounts Payable, Fixed Assets, Project Accounting, Inventory and Advance Pricing
• Automated procurement processes significantly and Leveraged Buyers work center and i-Procurement to perform daily procurement activities.
• Worked on the configuration and testing of the Project Costing and Project Billing Modules.
• Worked on the setups of Oracle Advance Pricing - setting up the modifiers, qualifiers, primary and secondary pricelists, custom attributes, attribute mapping, formulas.
• Worked on the setups of Ledgers, Ledger Sets, Data Access Sets, Chart of Account Design, Calendar, Secondary Ledgers, etc. in Oracle GL
• Worked on Translation and Revaluation process in GL Module
• Worked on Consolidation process in GL Module
• Worked on ACH Process bank integration within the AP module, worked on the file mapping with the bank, worked on defining business rules for data interpretation, etc.
• Worked on the Lock Box setup in Oracle AR with Bank of New York
• Worked on the Auto Invoice Setups in Oracle AR - setting up the sources, line ordering rules, grouping rules and line transaction flex field
• Worked on the setup of Tangible and Intangible items on Item Master in Oracle Inventory
• Worked on configuring the Master and Child Orgs in Inventory module
• Worked on setup of Min Max and Re Order point planning in Oracle Inventory.
• Worked on the Depreciation, Mass Additions, Setup of the Tax book and Corporate book in Oracle Fixed Assets.
• Worked on the Revenue Recognition process in AR module
• Worked on the TCA Setups in Oracle AR Module
• Actively communicated with Buyers, Controllers, Budget Managers and CFO’s, to optimize the approval workflow for requisitioning within the company.
• Worked on the design of the EUL in Oracle Discoverer 10G
• Worked on developing around 20 reports in oracle Discoverer 10G
• Created and maintained all functional design documents and Visio process flow diagrams
• Identified existing gaps, worked on solutions, and collaborated with the technical team to develop workarounds and customizations to enhance efficiency of existing business process.
• Initiated Global training sessions and walk-throughs within the application.

Confidential, Seattle, WA

Senior Financials Functional Analyst

Responsibilities:

• Responsible of business requirements gathering and definition, gap analysis and process mapping
• Prepared detailed use cases to capture the interaction between user and software, visually present Confidential flow of business model and to determine functional design expectations during systems and environment testing
• Created and Maintained releases of Functional design documentation for the GL Configuration team, GL reporting strategy, to design key Financial Statement Generator (FSG) reports
• Performed all the setups for Advance Collections, Fixed Assets, Inventory, Advance Pricing, GL, Sub Ledger Accounting, AP, AR modules
• Worked on ACH Process bank integration in AP.
• Worked on the integration of RevPro with Oracle EBS Financials.
• Worked on Revenue Management module of RevPro.
• Worked on the setups of the Key Flex fields in Oracle Fixed Assets
• Worked on the Corporate Book and Tax Book Setups in Oracle FA
• Worked on the Mass Additions process in FA
• Worked on the Formula based depreciation in oracle FA
• Worked on the Depreciation in Oracle FA
• Worked on the setups of Oracle Inventory module - defined the items on Item Master
• Worked on the setups of Oracle Inventory - Item Master setups, category setups, catalog setups, etc.
• Worked on the setups of Modifiers, Qualifiers, Formulas in oracle Advance Pricing.
• Effectively designed and deployed Confidential new Chart of Accounts and Ledger structure that best supports external and internal corporate management reporting requirements, while simplifying transaction entry.
• Interacted with key stakeholders and gathered requirements to perform corporate financial consolidations, and associated reporting, for numerous corporate entities
• Work directly with the system developers to implement and maintain system changes
• Overseeing day to day performance and schedules, communication to financial community, and security administration tasks
• Issue maintenance requests for all system and balance errors
• Key responsibilities also include management of User Acceptance Testing cycles and end user documentation; Efficiently organized test plan and scenarios for functionality testing and conducted business end-to-end manual testing
• Implemented and identified improvements to the existing interfaces and processes
• Responsible of post-production support for Oracle Financials Suite R12 (GL, Reporting).

Confidential, LA, CA

Senior Financials Business Analyst

Responsibilities:

• Understanding the existing business processes including GL, INV, Advance Pricing, AP, PO, Fixed Assets, i-Procurement, AR modules
• Preparing existing business process documents
• Mapping the business processes with Oracle standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of GL, AP, Advance Pricing, PO, Fixed Assets, i-Procurement, AR to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for GL, AP, PO, Advance Pricing, Fixed Assets, i-Procurement, AR Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for GL, AP, Advance Pricing, PO, Fixed Assets, i-Procurement, AR
• Preparing BR100 and Completing the Setups and configurations for GL, AP, OLFM, Fixed Assets, PO, i-Procurement, AR
• Preparing the test cases for GL, AP, PO, Advance Pricing, Fixed Assets, i-Procurement, AR modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for GL, AP, PO, Advance Pricing, Fixed Assets, i-Procurement, AR modules

Environment: Oracle Apps 11.5.9/11.5.10 e-Business suite (GL, OLFM, Fixed Assets, AP, AR)

Confidential, San Diego, CA

Senior Financials Business Analyst

Responsibilities:

• Understanding the existing business processes including AR, AP, PO, Fixed Assets, i-Procurement, GL, & Cash Management
• Preparing existing business process documents
• Discussing with business users and preparing BP80 for future To Be Process documents for AR, AP, PO, i-Procurement, Fixed Assets, GL, & Cash Management
• Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of AR, AP, GL, PO, and i-Procurement, Fixed Assets & Cash Management to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for AR, AP, GL, FA & Cash Management Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for AR, AP, GL, PO, i-Procurement, FA & Cash Management
• Working closely with developers to develop code for data migration using Oracle APIs and wrapper programs
• Preparing technical specification documents for AR, AP, GL, PO, i-Procurement, FA & Cash Management
• Preparing BR100 and Completing the Setups and configurations for AR, PO, i-Procurement, AP, GL, PO, i-Procurement, FA & Cash Management
• Preparing and using data loader script to load the data and completing setups for Service Request module.
• Preparing the test cases for AR, AP, GL, PO, i-Procurement, FA & Cash Management modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for AR, AP, GL, PO, i-Procurement, FA & Cash Management modules

Environment: Oracle Apps 11.5.10 e-Business suite- AR, AP, GL, FA & Cash Management

Confidential, Sunnyvale, CA

Functional Consultant

Responsibilities:

• As Confidential Functional Consultant implemented financial modules: i-Expense, GL, AP, AR, Fixed Assets of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on Confidential 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.
• Created the Collections Administrator, Collections Manager, Collections User profiles in AR module
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• 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.
• Implemented Auto Lock box Functionality in AR for Confidential & Royal Bank of Canada.
• 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 i-Expense, GL, AP, AR, Fixed Assets modules as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Environment: Oracle E-Business Suite 11.5.10.2

Confidential

Oracle App Functional Consultant

Responsibilities:

• As Confidential Functional Consultant implemented financial modules: GL, AP, AR, Cash Management, iExpense, Fixed Asset, 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.
• Worked on Confidential 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 on all crosses modules.

Environment: Oracle E-Business Suite 11.5.10, Manual Testing, and Windows 2003 server.