SUMMARY:

• Highly experienced in the financials domain with over 8 years as an Oracle Financials and SCM Functional consultant with extensive experience in all financial modules in Oracle E - business suite.
• Expertise in Oracle Applications Functional experience in multiple implementations, Upgrade and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials and SCM including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax), AGIS, Purchasing (PO), iProcurement, iExpenses, iSupplier, Order Management and Inventory.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Expert level knowledge on FAH (Financial Accounting Hub) for integration third party applications with Oracle General Ledger and creating highly efficient AADs.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R), Record to Report (R2R) etc.
• Extensive experience in using Trading Community Architecture (TCA).
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
• Extensive business experience in Procure-to-pay, Order-to-cash, Quote to Cash and Assets to GL Record to Report.
• Extensive experience in using Trading Community Architecture (TCA) APIs to create/Update parties and relationships.
• Experience in maintaining documentation and using the Application Implementations Methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80,RD20, BR30, BR 100, BR 150, MD 50, CV 40, TE 40)
• Create SR’s with Oracle Technical Support, coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Conducted CRP’s and provided wide range of functional training to multiple business user groups and Co-ordinate UAT sessions.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

TECHNICAL SKILLS:

Oracle ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, iExpense, iProcurement, iSupplier, Sourcing, Inventory, AGIS, Sys Admin, SLA/FAH, P2P, O2C and A2R.

Other Tools: Web ADI, ADI, Toad, Data Loader, Hyperion, Discoverer, Hyperion, OBIE, SQL*Loader, SQL*Plus and MS Office.

Oracle R12 Financials Expertise

Expert on P2P, OTC and R2R processes.

Expert in Oracle Procurement Suite of applications including Sourcing, iSupplier, Contracts, iProcurement, OSN, etc.Extensive System Development Life Cycle

Expert in Application Object Library and AME

Implementing Financial Accounting Hub (FAH).

Implementing EB: TAX and integrating with SABRIX

MOA and MRC (Multi Reporting Currency)

TCA (Trading Community Architecture)

11i Support and Upgrade Experience

AIM Methodology and documentation

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

Oracle Financials/ SCM Functional SME

Responsibilities:

• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Testing of various test scenarios of Quote to Cash, Requisition to Purchase Order cycle in Oracle Purchasing. Working on various Alerts related issues.
• Involved in implementation of Trade Management (gathering requirements, preparing documents, prepared the functional design document, prepared the test cases and deployed to production).
• Implemented FAH for integrating 6 external applications with complete entity model and Application accounting model with complex mapping rules design.
• Resolved various issues in Projects accounting as part of the production support team.
• Handled various issues and provided solutions for Flow from AP to LCM and then to OPM
• Trained users about the Projects and FA coordination to GL and solved the issues on them.
• Involved in functional testing of various bug fixes.
• Prepare issue and risk tracker and submit to client weekly basis.
• Writing / executing scripts to perform various extracts from database.
• Handling daily tickets related to various user problems in FA, AP, AR, GL, CE modules
• Working on CR's (Understanding the requirement, prepare understanding document, prepared technical design document, preparing test cases and UAT).
• Fully involved in month end closing process of financial modules.
• Raising SR on Oracle metalink for various issues related to AR, AP and GL.

Confidential, East Greenville, PA

Oracle Fusion Reports/Testing Lead

Responsibilities:

• Modified and analyzed various Process flow diagrams to in corporate business logic for the newly implemented Oracle Fusion financials.
• Performed data mapping for various conversions and prepared spreadsheets for uploading data.
• Authored and maintained MD50, BR100 documents for various financial modules primarily in Procure to Pay area.
• Involved in making the detailed Oracle Financials Test Plan regarding the scope and focus of the testing.
• Conducted Workshops for the new fusion instance training users and Solution demos for new features and Prepared Functional Design documents for several Extensions and Reports.
• Conducted testing for all business components and business processes. Supported End User Testing and Training activities.
• Developed test scripts, process flows and strategies for testing various modules and their integration including AP, AR, GL, FA, iProcurement.
• Created various scripts for validating and reconciliation of financial data for pre and post implementation using Smart View and OBIEE reporting layers.
• Designed and Documented requirements for various reports like Account Analysis, Fusion Accounting and Invoice Register in R12 and worked through testing and deploying them into Production.
• Designed and deployed solutions for import and reconciliation of bank statement, and Bank file integration/mapping.
• Worked on document repository tools like e-Room, Web Center, Clear Quest, Clear Case.
• Proactively involved in identifying and troubleshooting the data and configuration related issues. Coordinated with various Business Stake Holders and conducted and participated in status meetings

Confidential, East Greenville, PA

Oracle Financials Functional SME

Responsibilities:

• Analyze the business requirements and functional specifications for creating Requirements Traceability Matrix (RTM) and testing of the major modules like Account payables, Account Receivables, General Ledger, Purchasing modules.
• Developed Training Material for various financial modules and prepared impact analysis for critical issues
• Defined Subledger accounting (SLA) as per business accounting needs in various modules, including and not limited deriving accounts for Tax and Price variances, rules to handle third party transactions in Receivables, un invoiced receipts accounting during month end, FA depreciation account derivation etc.,
• Supported extended Procure to Pay process (including PO, iProcurement, AP, iExpenses, iSupplier, AME, CM, FA) in Production both in 11i and upgraded R12 instance and resolved various issues working in collaboration with Oracle Support.
• Authored and maintained MD50, BR100 documents for various financial modules.
• Involved in making the detailed Oracle Financials Test Plan regarding the scope and focus of the testing.
• Extensively involved in systems testing of production fixes related to Setups, Data fixes, Month End Data fixes, Code Changes, Patch application, and supported business during regression and UAT phases.
• Conducted Workshops for new R12 features and Solution demos for new features and Prepared Functional Design documents for several Extensions and Reports. Conduct testing for all upgraded components and business processes to ensure all RICELS work as expected after upgrade. Supported End User Testing and Training activities.
• Round trip testing/Autosys/WCC for the following EDI inbound interfaces 271, 274, 811R, 811S, 837, 810 and outbound interfaces of 835 and 811V as part of the daily work basis.
• Worked on Sabrix integration with Oracle EBS R12 EB-Tax module for both Sales (OTC) and Use Tax (P2P) calculation and maintenance. As per the business needs integrated iSupplier module to work in conjunction with Sabrix.
• Developed test scripts, process flows and strategies for testing all processes of oracle financials including AP, AR, PO, CM, FA, OM, INV.
• Created various scripts for validating and reconciliation of financial data for pre and post upgrade using SQL queries.
• Configured Payment Process Profiles, Bank Accounts, Payment Documents, Payment Process Templates, Request Sets etc., for upgrading payment process to R12.
• Designed and Documented requirements for various reports like Payment Registers and Invoices Register in R12 and worked through testing and deploying them into Production.
• Extensively created various test cases and scripts in Mercury Quality Center for various phases of the project including CRP, UAT and Performance Testing.
• Involved with all phases and stages of software life cycle including end-to-end system testing and business requirements analysis
• Performed all Pre-Upgrade and Post-Upgrade steps for iProcurement module for upgrading catalogs and migrating images from 11i to R12.
• Fixed various issues related to GBPA processing and Catalog Authoring in R12 post upgrade.
• Integrated Cash Management with Payables, Receivable modules for reconciliation.
• Designed and deployed solutions for import and reconciliation of bank statement, and Bank file integration/mapping.
• Designed and developed custom Back to Back Sales Order process for incorporating business rules to avoid sales order update prior to communicating with buyer and vendor.
• Defined various Processing Constraints in OM, to in corporate business logic for processing order lines.
• Involved in Month-end support for close and reconciliation for AP and AR modules in the R12 environment
• Resolved issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables.
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report.
• Worked on document repository tools like e-Room, Web Center, Clear Quest, Clear Case.
• Proactively involved in identifying and troubleshooting the data /code related issues. Coordinated the Development team and conducted and participated in status meetings
• Updates to the Financial Reconciliation FSD documents to reflect the R12 Changes

Confidential, Stamford, CT

Oracle Public Sector E-Business Suite Functional SME

Responsibilities:

• Supervising the process and functional design activities
• Identified functional requirements as an input to application design
• User Support Analysis: Research solutions to problems, answer client questions and provide consulting and training as required. Track software and documentation issues.
• Identify, diagnose and document system issues.
• Assess how well a product adheres to its design.
• Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.1.3.
• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identified standard system functionality, analyzed GAP document and designed solutions for GL & AP, PO depending on Business requirement.
• Defining and setting up of complete Procure to Pay cycle setups from entering the requisition in purchasing to entering the receipts and creating of the invoice in account payables module to support business requirements.
• Defined payment terms, Accounting Rules, Accounting Periods, and Invoice Sources.
• Defined Bank information, receivables quick code, auto invoice grouping rules, transaction types.
• Setup AP payable system option, financial options, and payable options.
• Conducted several user-training sessions on the system upgrade tasks- Trained in Sub Ledger Accounting, Budgets, Encumbrances and terminology changes from 11i to R12.
• Responsible for preparing upgrade plan for GL, AP, PO, AR, and I-Expenses with all customizations and form personalization.
• Worked on the entire Procure to pay business process. Performed all of the setups for i-Procurement, PO, AP and GL. Developed several enhancements to the Business Processes on the Procure to Pay side.
• Day to day support of GL and AP interfaces
• Raised SR for several issues and resolved them
• Prepared impact analysis document for the upgrade of financial module.
• Assisted users with training sessions and documentation
• Facilitating end-user training and developing the various users training manuals and conducted the UAT sessions.

Confidential, Long Island, NY

Sr. Oracle ERP Consultant

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP and Purchasing Modules.
• Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle GL & AP configuration (12.1.3).
• Strong understanding of R2R process integration with other business processes and areas
• Record to Report Finance Process (L1 through L4) with focus on intercompany transactions
• Recorded many journals in GL and supported the reporting based on business needs.
• Identify & Document Gap Business Requirements for Oracle GL, Purchasing & Oracle Payables Applications.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items.
• Developed Functional design documents to support to-be business processes.
• Create & updating BR100 / setup documents for GL, AP, PO & iProc.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Involved in design and configuration of chart of accounts, calendar and currency.
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Developed new FSG reports and customized various standard FSG reports.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Prepared Integration & Customization Unit Test Plans & supported Business / Functional users in testing Integration with Oracle GL, Purchasing & Oracle Payables Applications.
• Conduct CRP’s and work on open items to accomplish within the timelines.
• Create and update test plans and test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.

Confidential, Seattle WA

Oracle Financials Subject Matter Expert

Responsibilities:

• Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents BR 100, BR 30, functional extension and design document MD 50 and identified GAPS.
• Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL (General Ledger) and AP (Accounts Payable)
• Coordinated CRP’s and was involved in Test Scripts preparation (TE 40), for GL & AP.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Configured the Multi-Organization Access (MOAC), Ledger Setup, and Legal Entities
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Training Super users & power users before start of CRP2.
• Involved in Period Closing & Reconciliation with GL
• Setting up Global consolidation & multi reporting currency & developed FSG Reports for customized Financial Statements.
• Setup MOAC for Payables module to restrict access to different operating units
• Created users and granted responsibilities to the defined users.
• Setting up legal entity, business group and operation unit.
• Setup AP payable system options, financial options, payable options, suppliers and operating units.
• Defined Invoice attributes, payment attributes - Approve, hold and release, special calendar, payment formats, pay group, payable document.
• Worked in Payment process profiles, defined banks, bank accounts & documents.
• Setup CE and created CE Responsibilities
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.

Confidential, Salt Lake City, UT

Oracle Functional Lead

Responsibilities:

• Supported Post-Implementation phase for Oracle Financials Modules.
• Resolved issues raised in Bugzilla.
• Involved in post production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions
• Involved in Month end support for the period close for AP, AR & reconciliation through CE.
• Improved Labor Costing and billing utilizing Oracle Project Accounting
• Resolved the issues related to payment processing, payment authorization, and suppliers.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Resolved the issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report.
• Supported Project Accounting-Project Costing, Project Billing, GL, AP & AR modules.
• Involved in setup of Project Management, Project Accounting and Project Manufacturing Modules.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Setup PO module and matching options with AP invoices.
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Involved in customizing the Project Accounting suite for reporting activities
• Prepared integrated test cases for each setup and End User training material on the Project Accounting module
• Setup the iExpense Module for different Operating Units.
• Set up the approval hierarchy for the expense reports and created signing limits for iExpense users in Payables.
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register.
• Converted the customer information from legacy system into oracle Applications using custom program and API to affect the HZ tables in TCA.
• Configured auto Bank Reconciliation process via CE (Cash Management) module & Automatic Reversal of rejected receipts, and the ability to clear payments and receipts before Reconciliation with the bank.
• Extensively used Toad and SQL Developer to view the tables to troubleshoot production issues.
• Coordinated with the offshore technical team when needed.
• Ran diagnostic scripts using toad and then gave input to technical team.
• Worked with Oracle Technical Support to resolve the critical issues through SR/TAR.
• Run Diagnostic scripts and coordinated with oracle tech support through OWC session.

Confidential, Des Moines, Iowa

Sr. Oracle Financial Functional Analyst

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Mapped the future state process requirements in AP and iExpense
• Setup the iExpense Module for different Operating Units
• Set up the approval hierarchy for expense reports and created signing limits for iExpense users in Payables
• Involved in the project scoping of the iExpense implementation
• Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage
• Worked closely with the users to define Daily limits, roles, and locations in Expense reports
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source& types
• Define system options, Accounting Option, Lookups, Payment and Billing term templates
• Worked with the business users, technical team to enable conversion of the lease from legacy system
• Performed developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Created test documents, performed unit, End to End and User Acceptance Tests for AP

Confidential, Rochester, NY

Oracle Functional Consultant

Responsibilities:

• Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Month end support in financial modules GL, AP and FA
• Gathered, analyzed and wrote detailed business requirements, user profile, created workflow processes documents and charts.
• Knowledge of Performance tuning of various queries and stored procedure
• Developed several BR 100s of GL & AP to fulfill the business need.
• Worked with business users to define their business requirements in preparation for developing program solutions and translated the requirements into 11i Processes
• Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested features Translation, Reevaluations, and consolidation.
• Prepared end user training material with specific business cases and conducted end-user training.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities.

Confidential

Oracle Financial Analyst

Responsibilities:

• Complete Assessment of Solectron Business Process. To understand existing COA structures.
• Setup and tested ACH/Wire transfer.
• Gap Analysis between existing Application and Customization, using Oracle EMM Methodology
• Training User on New Rel.11i Application Functionality, GL, AP and Purchasing
• Identify the patches that need to be applied to prepare the Release 11i environment for implementing Oracle Internet Procurement.
• Complete Setup that must be completed before setting up Internet Procurement.
• Steps needed to setup catalogs Workflows and custom packages used by Internet Procurement Setup required for shopping at external sites.
• Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines.
• PO matching options, invoice tolerances, distribution options, terms, holds, etc.
• PO setup and matching options with invoices.
• Designed and configured setups in Inventory, Purchasing and AP modules to meet the Purchase Requisition.
• Setup the workflow for creating purchasing documents automatically to PO Create Documents.
• Setup CRP-II and training, expand core Team knowledge of Oracle11i.