SUMMARY:

• 8.4 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, Advance Collections, Project Costing, Project Billing, Project Resource Management, FA, i-Expense, Cash Management, OM, INV and PO.
• 3 full life cycle implementations in Release 12.
• Worked on both the “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.
• 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.
• Good knowledge and understanding of general accounting principals “GAAP”.
• Excellent planning and organizational skills.
• 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.
• Interacted with Oracle Support to resolve application issues.
• Worked on Revenue Recognition and Deferred COGS functionality.
• 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.
• Team oriented, self-motivated and Confidential 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), Treasury Management, Purchasing, Payroll, Advance Collections, General Ledger (GL), Fixed Assets (FA) 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 Projects

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Finance Functional

• Actively involved in implementation and integration activities with modules such as- General Ledger, Account Receivables, Accounts Payable, Advance Collections, Project Accounting, Bill Presentment Architecture, Cash Management, FA
• 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 Bill Presentment Architecture
• Worked on the setups of Oracle Advance Collections - setting up the scoring engine, scoring strategies, dunning letters, statements, credit limit management, etc.
• 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 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 AR/AP Netting process in Oracle AR module
• Worked on the Line Level Cash Application functionality in AR module
• Worked on setting up and testing of the Project Costing and Project Billing modules
• Worked on the Depreciation process 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 Roll Back feature of Oracle FA
• Worked on the Revenue Recognition process in AR module
• Worked on the TCA Setups in Oracle AR Module
• Led & coordinated tasks related to conversion and mapping of requirements from Ariett & Softrax (old system) into Oracle Financials R12.
• 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, NY

Oracle Financial Functional Consultant

• 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, Bill Presentment Architecture, Project Costing, Project Billing, GL, Sub Ledger Accounting, AP, AR modules
• 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

Distribution Functional Consultant (PO, i-Procurement, AR, AP, GL, FA, CM, I-EXPENSE, OM, Supplier Hub, INV, Shipping, Advanced Pricing,)

Responsibilities:

• Understanding the existing business processes including GL, AP, PO, 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, PO, 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, 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, PO, i-Procurement, AR
• Preparing BR100 and Completing the Setups and configurations for GL, AP, PO, i-Procurement, AR
• Preparing the test cases for GL, AP, PO, 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, i-Procurement, AR modules

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

Confidential, San Diego, CA

Distribution Functional Consultant

Responsibilities:

• Understanding the existing business processes including AR, AP, PO, 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, 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, FA & 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, i-Procurement, INV, PO and OM 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.
• 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.

Environment: Oracle E-Business Suite 11.5.10.2

Confidential

Oracle App Functional Consultant

• 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.

Confidential

Oracle Applications Functional Consultant

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Implemented financial modules: GL, AP, AR, INV, OM along with PO integrated with internal e-Procure system, Release 11i of oracle (11.5.10.2).
• Implemented 14 SOB’s (20 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Worked on Revenue recognition in AR.
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc.
• Implemented Party Relationships in the TCA.
• Implemented the Data Quality Management in TCA.
• Setup document validation, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created New FSG Reports, using mutli-currency features including foreign currencies for multi org structures.

Environment: Oracle e-business Suite 11.5.7