SUMMARY

• 8 years of experience as an Oracle Functional Consultant with expertise in both 11i and R12 versions.
• Functional experience in Oracle Financials Applications with multiple Implementations, Upgradations of General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AP), Cash Management (CM), Fixed Assets (FA).
• Knowledge in Software Development Life Cycle (SDLC).
• Three full life cycle Implementation in R12 with GL, AP, AR, FA and CM.
• Two full life cycle Implementation in 11i with GL, AP, AR, FA and CM.
• Interaction with Oracle support to resolve application issues.
• Business process analysis includes understanding the existing business processes and designing the future processes with the standard Oracle functionality using AIM methodology.
• Familiar with all the Standard Documents like MD 50, MD 60, BR 100.
• Hands on experience with Oracle R12 and Oracle 11i Implementation.
• Participated with Business / Functional users in set - ups for all financial modules.
• Experience on importing data from Sub-Ledger Modules( AR, & AP).
• Worked on Customization and Development Reports under Oracle Apps.
• Collaborated closely with customer teams to accelerate the speed of knowledge transfer and drive the highest value from the successful deployment of the Oracle E-Business Suite.
• Excellent interpersonal, communication, documentation and leadership skills. Strong presentation skills and the ability to communicate at different levels within the organization with exceptional problem solving and analytical skills at both application & system level and excellent attention to detail.
• Involved in documentation in accordance with AIM Standards (BP080, BR100 & TE040).
• Track test results for management, categorizing issues and creating/distributing defect reports and managing defect database using Quality Center.
• Responsible for monitoring resources technically and training QA Team Members and end users.

TECHNICAL SKILLS

Oracle Apps: Oracle E-Business suite R12/11i GL, AP, AR, FA, CE, iExpenses, iReceivables, iPayments.

Databases: Oracle 11g/10g/9i, MySQL

Tools: SQL*Plus, SQL*Loader, TOAD

Operating Systems: Windows Family, Linux, Mac

Other Tools: HP Quality Center, MS Office, MS Project, Microsoft Lync, BMP Remedy.

PROFESSIONAL EXPERIENCE

Confidential, Seal Beach, CA

Oracle Financial Functional Consultant

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP, GL, iExpense, FA etc.
• Participated in the Conference Room Pilot sessions to interact with users to analyze the business process and identify the gaps.
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes.
• Gather, manage and document functional requirements for technical customization including workflows and scripting.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Work with the business architect and other planners to assess current capabilities and identify high-level requirements.
• Identified the business requirements which need to be handled by the customizations and did the necessary analysis along with a technical resource.
• General Ledger (GL): Designed Ledgers, built chart of accounts, set up cross-validation rules and flex field segments. Defined journal sources, journal categories, Translation of balances from subsidiary units for reporting purposes and consolidation. Defined system controls and Set the profile options for GL, Creating of Sub ledgers and Globalization.
• Created the FSG reports for the balance sheet and the income statement.
• Loaded the trial balance data using the Web-ADI.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods.
• FA (Fixed Assets): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL. iExpense Setups: Define Accounting Flexfield, updated Internet Expense Messages, defined Contact us Information, Global Policy Information, define Employees, Security Profiles, System Profiles, Define Payable Lookups, Expense Clearing Account, Expense Report Options, Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority.
• EBtax Setups: Define Geography Hierarchy Structure, define Tax and Geography Validation, Defining Tax And TCA profile Options, define TCA geography hierarchy, Setting up TCA classification, define tax content services, define tax determination service and analyzing tax requirements. Define Tax Setups (Tax Regime, Taxes, Tax Statuses, Tax Jurisdictions, Tax Recovery Rates, Tax Rates and default tax rules), Define the party tax profile for Legal Entity and Operating Unit and Make tax available for Transactions in AP, AR, PO etc. Define tax accounts and accounting information. Setup lookup codes and tax classification codes, Implemented Ebtax for US as well as other countries for tax calculations.
• Accounts Payable (AP): Functional analysis and setup of AP. Defined Financial and Payable options, Defined descriptive flex fields for additional information for vendors details and invoice transactions and provided solutions for invoice matching. Defined Vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and schedule recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, invoice distributions, invoice validations and holds, Recurring Invoices, invoice aging report formats. Set the profile options for AP.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods.
• Account Receivables(AR): Setups for TCA Architecture, DQM, Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles etc.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods.
• Helped the Confidential Financial team in the Post production support in all the financial modules. Also involved in Troubleshooting with the issues in Financial Modules while supporting Finance Folks, troubleshooting various issues relating to performing the Month and year end close.

Environment: Oracle Application E-Business Suite R12, 12.1.2, 12.1.3 (GL, AP, AR, FA, CE, INV, OM, iProcurement and iExpenses), Order to cash, Procure to Pay, Oracle 11g, SQL*Loader

Confidential, San Diego, CA

Oracle Functional Consultant

Responsibilities:

• Perform internal analysis and implementation of R12 EBS. Develop Business process flows for AR and AP and identify the gaps.
• Present the identified gaps and work with business owners/users in the design sessions. Mapped the future state process requirements in GL, AP and AR.
• Develop project documentation including BR100 and Project Functional Design Documentation (MD.50).
• Configured GL, AP and AR. Worked extensively in Revenue Recognition functionality considering accounting and audit requirements.
• Worked with the technical team for developing customer interface, transaction conversion from legacy systems and Auto Lockbox interface.
• Define system options, Accounting Option, Lookups, Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types.
• Assisted in developing and testing of invoices from third party systems
• Led the test sessions for GL, AP and AR modules. Performed unit, End to End tests and assisted in UAT sessions.
• Perform develop and document systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Performed role of Primary support analyst providing production support of Oracle GL, AP, AR, modules covering huge client base.

Environment: 11i to R12 (12.1.3) Upgradation of the existing organization and R12 Implementation for new organizations.

Confidential, Detroit, MI

Oracle Apps Functional Consultant

Responsibilities:

• Supported in oracle financial modules such as AP, PO, AR and GL.
• Involved in post-production support.
• Performed unit testing and user acceptance testing at all stage and maintained detailed documentation for each stage.
• Involved in AR system setups and performed master data setups such as setup of new customer.
• Performed Auto Accounting, Payment terms, Approval limits, Setups of transactions.
• Knowledge on cash management, key and descriptive flex field, multi organization structure, multi reporting currencies.
• Performed system administrator tasks such as validation, profile options etc.
• Involved in defining natural account segment values, legal entity, segment values and cross validation rules.
• Attended and conducted Oracle Application knowledge sharing sessions in financial modules AP, AR and FA.

Environment: Oracle Application E-Business Suite R12, 11.5.10.2 (GL, AP, AR, PO, INV, OM, Fixed Asset, WIP, BOM and iProcurement, iReceivables, iExpenses), Order to cash, Procure to Pay. Oracle 9i, TOAD, SQL*Loader, Reports10g, Forms 10g

Confidential, Mason, OH

Oracle Financials Functional Consultant

Responsibilities:

• Analyze, redesign, develop, test, implement and support of customization prevalent in Oracle Applications 11.5.10.2 to Oracle Applications R12.1.1
• Implemented additional functionality in new release for GL, AP, AR, FA - Customized module for Interface of Oracle Apps with other NCR Applications) using NCR Standards and Methodology.
• Created documents like estimate document, execution plan, functional specifications, and design document and test plan.
• Understanding of mapped business processes: Order Creation Process, Order Change Process, Auto Sourcing, Auto Reservations, and Auto Receiving.
• Understanding Custom Interfaces - ADP, Time Keeper, WADT, IBS, SIDB, CSMS, TNT, SMD - and there mapping to AP, AR, GL, OE.
• Provided Support on System Acceptance testing, User Acceptance testing and production environment issues.
• Oracle Applications 11.5.10.2, Oracle 8i, PL/SQL, SQL*Loader, SQL Database Navigator, Sun Solaris, Windows NT

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Fixed Assets and Oracle Cash Management.

Confidential, Miami, FL

Responsibilities:

• Responsible for global implementation of GL, AP, AR, Assets and CM modules.
• Studied the business for Gap Analysis " As Is and To Be " analyzed the business requirements and setup System Options, Financial Options, Payable Options, Profile Options and all other mandatory Setup in the modules to achieve the business goal.
• Designed the Multi Org Structure, Chart of Accounts and Consolidation process.
• Defined the sequential values for Cost centers and Natural Accounts.
• Prepared FSG’s to show the Profit or Loss per Balancing segment, Cost center, Sales regions and Service Category segments.
• Gathered user requirements for all financial modules and suggested out of box solutions to meet the requirements.
• Prepared project plan and managed the functional and technical consultants.
• Designed Customizations for Check printing, AR invoice printing in XML templates and GL reports.
• Coordinated with technical and offshore team.
• Migrated GL journals form Legacy (Peach tree) for Two years, Fixed Assets using ADI.
• Migrated Suppliers and Customers by Data loader.
• Suggested Month end closing process.
• Provided post Go-Live support.

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Fixed Assets and Oracle Cash Management.

Confidential, Glenview, IL

Oracle Financials Functional Consultant

Responsibilities:

• Primary focus was to collect business requirements with the help of Questionnaires, Requisition document, Process flow diagrams, and Run CRP sessions.
• Implemented Oracle 11i Financials core modules like GL, AP, AR and Cash Management.
• Implementing COA, Multi Currency SOB, KFF, DFF, Parent/Child Hierarchies and Roll-Up groups for Summary Accounts, Security and Cross-Validation, FSG Reports.
• Documenting BR100 for GL, AP, AR, and CE.
• Setup design with flow-charts allowing clients to maintain their applications after implementation for Audit.
• Providing user support and maintenance of the online business interface.
• Support Financials IT team for sub ledger GL reconciliation activities.
• Created and executed test scripts for GL, AP and AR, CE, FA.
• Managing Responsibilities, Request Set, Menus and user access.
• Provided AP, AR, GL end-user training and prepared user documentation.

Environment: 11i to R12 (12.1.3) Upgradation of the existing organization and R12 Implementation for new organizations.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

• Worked as an Asst. Functional Analyst for Oracle Purchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets.
• Studied and evaluated functionalities of various modules.
• Defined Set of books, accounting flexfield structure.
• Prepared Setup documents (BR100) for Accounts payables & Accounts Receivable.
• Created Responsibilities with menu exclusions as part of SOD & tested all the menus & functions.
• Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Prepared functional Design Documents for application extensions and conversions (MD.050).
• Prepared Test Scripts for Integration Testing (TE040).
• Handled post go-live user support.
• Developed the training material for the users.

Environment: Oracle Application 11.5.9, GL, AP, AR, PO and Inventory, Oracle Applications Implementation 11i.

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Defining Fiscal Year and Calendar and Prorate Conventions.
• Defining Depreciation Methods.
• Creating and attaching Value sets to Key Flex fields (Asset Category FF, Asset Location FF & Asset Key FF)
• Defining corporate and Tax Books.
• Defining asset categories.
• Depreciation.
• Defining Asset Mass Additions, Asset Quick Additions, Asset Reclassifications, Transfer, Revaluation Adjustments and Retirements.
• Assets Transfer to GL.

Environment: Oracle Application (Ref 11.5.10), GL, AP, AR & FA