SUMMARY

• Oracle e - Business Suite Functional expert with 10 years of IT Experience including in-depth experience in design, support and implementation of software applications.
• Expertise in AR, AP, GL, FA, Cash Management, i-Expense, Advance Collections, Deductions Management, Sub Ledger Accounting, AGIS, e-Business Tax, OM, INV and PO modules.
• Extensive experience in the Functional aspects of Oracle Applications 11i, Release 12.0.3. 12.1.1 and 12.1.3
• Developed several Business Requirement Documents (BRD), Functional Specification Documents (FSD)
• Experience in and end-user .
• Experience includes execution of 4 full lifecycle Oracle Applications implementations including the exposure to e-Business Suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Over 7 years of extensive experience on Oracle Financials Applications consulting including Quote to Cash, Record to Report and Procure to Pay Executed critical projects as Business Analyst, Functional Consultant, Onsite Coordinator, Designer on Functional & Techno-Functional roles.
• Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
• Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
• Strong communication & leadership skills with an ability to interact with business users and lead business projects.

PROFESSIONAL EXPERIENCE

Confidential, NH

Financial Functional Lead

Responsibilities:

• Study AS-IS Business Process of C&S Process.
• Analyze the Upgrade Requirements and strategize the migration of customizations to Release 12 instance.
• Worked on two new business process implementation and managed a small team during the GO-Live phase.
• Worked with end users to document the business processes & functional requirements also providing them with materials
• Worked on the setups of the AR Module - defining the Auto Invoice, Auto Lock Box, Revenue Recognition rules, worked on the Collection process of AR, worked on Auto Accounting, etc.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Prepared business requirements documents for AR, Advance Collections, Deductions Management, GL, OM modules
• Worked on the Auto Invoice, Auto Lock Box, Revenue Recognition, Auto Accounting setups in Oracle AR
• Worked on the AR/AP Netting process in Oracle AR module
• Configured the Trading Community Architecture (TCA) - defined the Parties, Accounts, Party Types, Account Types, Contacts, Contact Points, Party Relationships, etc.
• Worked on Sub Ledger Accounting setups and customization
• Worked on Inventory and Gross Profit Accounting, designed custom processes and converted Trial Balance as a part of new business acquisition project.
• Worked on the setups and configurations for AR, Advance Collections, Deductions Management, GL, OM modules
• Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track.
• Provide inputs and part of the team for new solution.
• Understand Division-specific business processes from the end users and implement the same.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams. Provide user & documentation

Environment: Oracle applications 12.1.3 AR, Advance Collections, Deductions Management, GL, OM

Confidential, Minneapolis, MN

Financials Functional Lead Analyst

Responsibilities:

• Performed AS IS Analysis for the 11.5.10 setup and Identified GAPs with R 12.1.3
• Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
• Involved in dealing with all the stakeholders on the project to gather requirements, firm up the requirements and then get the signed off by the stakeholders for each functional track.
• Involved in designing the Project Plan for the individual modules
• Involved in developing the Process flows for the Record to Report flow - including AR, FA and GL modules
• Worked on the setups of the AR, Advance Collections, Deductions Management, GL, OM modules.
• Involved in the Functional Analysis of designing and developing a custom licensing module called e-licensing, which was primary designed to provide license keys for products sold and tie back to Install Base.
• Worked on the Trading Community Architecture (TCA) - defined parties, accounts, party sites, account sites, contacts, contact point, relationships (reciprocal and non reciprocal)
• EDI - Worked on the EDI Inbound and Outbound for Purchase Orders, Invoices, ASNs and ASBNs.
• Worked on the complete setup AR module including the setups of the Auto Invoice, Auto Accounting, Revenue Recognition, Auto Lock Box functionality
• Worked on the setups of the Refund Functionality in AR module
• Worked on the AR/AP Netting functionality in AR module
• Worked on the definition of the transaction types and system options in AR Module
• Worked on the setups of Ledgers, Ledger Sets, Chart of Accounts, Currencies, Calendars, Journal sources in Oracle GL
• Worked on the setups of the definition of the Cross Validation and Security rules in GL
• Worked on the Translation and Revaluation process in GL module
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
• Responsible for developing and maintaining documentation like BR-100, CV-40, test scripts and results
• Worked on designing the power point presentations for the business requirements and solutions for the GAPs that were identified.
• Worked with Oracle support for Oracle functionality issues by raising Service Requests.
• Was involved in developing Use Cases for testing of the Quote to Cash business process
• Was involved in designing the communication plan for any changes that were made to the system, any changed that were made to any of the functional processes.
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.

Environment: Oracle applications 11.5.10.2 (Technology: AP, AR, GL, e-Business Tax, FA, Cash Management, Grants Accounting, Project Costing, Project Billing, Sub Ledger Accounting, Service Contracts, AGIS, Install Base, Project Accounting, Project Costing, Project Billing) Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Confidential, Los Angeles, California

Oracle Financials Functional Analyst

Responsibilities:

• As a Functional Consultant implemented Financials Business flows including AP, AR, GL, I-Expense, and Cash Management modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, TCA, GL, OM, CM, OM
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Worked on the Worked on the Record to Report flow
• Was involved in setting up Orgs - Setting up Legal Entities (LE), Operating Unit (OU), Ledgers, Inventory Orgs, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User 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 Approval Hierarchies in Purchasing 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.
• Worked on the Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi currency setup, setting up itemization in i-Expense, Setting of i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate i-Expense access, assigning signing Limits, etc
• 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, Account Payable, AGIS, Service Contracts, Install Base Modules
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, Service Contracts, Install Base, CM and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: - Oracle Applications Release 12.1.3 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East OM, AGIS, AR, AP, GL, INV, PO, i-Expense, i-Procurement, AOL, System Administrator

Confidential

Financials Functional Consultant

Responsibilities:

• As a Functional Analyst Supported the financial modules: Service Contracts, Install Base, GL, AP, AR & FA Release 11.5.10.2
• Worked on Conversions & Enhancements for Service Contracts, Install Base, OM, AR, AP and GL module
• 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.
• Setting up Orgs - Setting up Legal Entities (LE), Operating Unit (OU), Set of Books, Inventory Orgs, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured AR, AP 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.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful to the users in Order to Cash, OM, AR, GL, AP, CM, 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, San Diego, CA

Oracle Financials Functional Anlayst

Responsibilities:

• Prototype the business process by mapping against the functionality of the modules in a test database installed as a part of the Oracle Applications installation process.
• Set up OM Transaction Types, OM Parameters.
• Set up Inventory Organization for OM related items.
• Defined time limit for Booking of Order, Scheduling of Order, Closing Order Lines and Order Headers.
• Set up pricing parameters/list.
• Inventory On hand availability Checking, Pick Release Rules, and Back Ordering decision.
• Set up Shipping Parameters/Rules, Containers, and Granting Roles to Users.
• Document sequencing for Order Numbering.
• Modification/cancellation of Orders/Order lines.
• Created MD050 based on RD020 and RD050.
• Prepared TE020, TE040 based on MD050.
• Developing test scenarios and testing the code units developed
• Testing the system for specific scenarios after upgrade to 11.5.9
• Coordinating with the client for requirement related discussions.

Environment: Oracle Applications 11.5.9(AP, OM, GL, Oracle Workflow 2.6, PL/SQL)

Confidential

Functional Consultant

Responsibilities:

• Process Architecture & Enhancement.
• Designed Approach Document for Data Migration from Legacy to 11i
• Customer Interaction and Issue Tracking
• Have Migrated Customer/Items/Item Relationship/Cross
• Have Done Unit Testing/User Acceptance Testing/System/Integration testing for the Loaded data
• Have worked on key tasks such as Sub-Inv Transfer
• Have worked on Writing and Customizing Interfaces.
• Complete Process flow knowledge on INV, PO, and WIP.
• Concurrent Manager Administration, Interface monitoring
• Application Users creation.
• Performance Tuning for Reports & Interfaces.
• User’s on Key issues.

Environment: Oracle Apps 11.5.7, Oracle PL/SQL, Developer 2000, Toad and SQL navigator as tools for SQL queries