SUMMARY

• Working for around 8 years as an Oracle Financials Functional Analyst with broad exposure on multiple implementations, Upgrades, and Post - Production Support projects in both R12 and 11i versions of Oracle Financials including integration of relevant modules in distribution areas as well.
• Broad working knowledge in Design, Implementation, Customization and Testing of Oracle E-Business Suite (EBS) Financial modules which include System Administration, General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets(FA), Cash Management(CE), Purchasing (PO), and Order Management (OM).
• Extensive experience with all phases of Oracle Financials project life cycle including requirements definition, GAP analysis, fit-gap analysis, system configuration and testing, user training, and post-production support.
• Experience in upgrade and conversion/migration of data from legacy systems to Oracle Financials system.
• Interaction with all levels of business owners and users during the various stages of project lifecycle.
• Competent in understanding the functionality of the core Oracle Financial modules (GL, AP, AR, FA, CE, PO) and their interplay in the overall accounting structure of an organization.
• Experience with Oracle AIM methodology documents including RD20, BP80, BR30, BR100, MD50, CV40, and TE40.
• Extensive experience in working with global implementations involving Advanced Global Intercompany System (AGIS) and multi-currency revaluation and translation.
• Thorough technical and theoretical understanding of Multi-Org Access Control (MOAC), Sub-Ledger Accounting (SLA).
• Conducted and evaluated process review and gap analysis to resolve requirements not addressed by Oracle apps.
• Extensive work experience on the full life cycle implementation of Procure to Pay (P2P), Order to Cash (O2C), and Acquire to Retire (A2R).
• Created financials report using FSG (Financial Statement Generator).
• Implemented approvals using the Approval Management Engine (AME) functionally built into Oracle.
• Experience with Application Object Library (AOL) workflow process
• Interacted with Oracle support using Metalink and Oracle Web Conference (OWC) to resolve application issues and bugs; maintained follow-up with Oracle in regards to Technical Assistance Request (TAR)/Service Request (SR).
• Created mapping for interfaces to existing systems and conversion of legacy data.
• Conducted Link, System and Integration testing and involved with User Acceptance Trainings (UAT).
• Created and maintained user manuals and held training sessions for large user groups.
• Involved with all phases of Conference Room Pilot testing (CRP1, CRP2, and CRP3).
• Excellent verbal communication and presentation skills.
• Follow up with off-shore technical team for timely deliverable and ensure to meet the aggressive time lines.

TECHNICAL SKILLS

Applications: Oracle Versions 11.5.8, 11.5.10, 11.5.10.2, R12.0.3, R12.0.5, R12.0.6, R12.1.1, R12.1.3

Module Knowledge Tools: GL, PO, AP, AR, CE, FA, SLA, iExpense, iProcurement

System Administration: Data Loader, Toad, Oracle MetaLink, 9g, 10g, Bugzilla, ADI, Web ADI, OBIEE, Hyperion, Discoverer.

Microsoft Office: Access, Excel, Outlook, PowerPoint, Visio, Word

Languages: SQL, PL/SQL, RDBMS, HTML, XML, C/C++

Operating systems: Microsoft Windows, MS DOS, Sun Solaris, Linux/Unix

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Financials Functional Support Analyst

Responsibilities:

• Facilitate the translation of business requirements into detailed functional requirements within EBS and work with other IT staff to arrive at optimal best practice solutions
• Develop ad-hoc queries or reports to address operating needs of end-users
• Provide training and support to Finance end users for application functionality, enhancements, upgrades and improvements
• Research, analyze, recommend and execute improvements to current processes and systems.
• Develop, coordinate, and implement test plans for functional changes, bug fixes, enhancements, patches and upgrades
• Configure, modify and develop accounting rules, application configurations and integrations within the Oracle Financial modules
• Analyze data, design and integration points to upstream and downstream applications that feed into and require data from Financial applications
• Understand and adhere to IT quality controls, including development of test plans and scripts, providing proper documentation, respect of access and change control processes
• Collaborate, cooperate and interact with various IT support staff and project team members
• Provided solution direction for Procure to Pay (P2P) processes being implemented on an already existing 12.1.3 Global footprint
• Developed Test Plan / Test Cases and conducted User Acceptance Testing (UAT) sessions in various modules to monitor and approve patches and bug fixes
• Participated in collaboration with technical team to establish user requirements, develop, and test BI reports and Web ADI templates
• Defined additional rules using Approval Management Engine (AME) to improve PO to AP alerts.
• Use Toad to run diagnostic scripts for troubleshooting AP/AR invoices, Trial Balance issues, and patch upgrades
• Write SQL queries in Toad to examine flow of data from various modules to Subledger Accounting to General Ledger

Confidential, Tinley Park, IL

Financials Functional Analyst

Responsibilities:

• Adopted to the project since the requirement gathering stage and involved in the full life cycle of the project.
• Conducted various meetings in order to gather questionnaire for business team (RD20).
• Performed requirement analysis and gap analysis for implementation of GL and AP. Prepared documents for business requirements mapping (BR30) and functional specifications (MD50).
• Created and maintained application setup document (BR100) throughout the project.
• Collaborated with business team to configure and finalize cost center segment for chart of accounts and defining security rules.
• Tracked and communicated project tasks progress against deliverables and timelines and furnished updates to steering committee and Project management by using MS Project.
• Maintained the regular interaction with the Client, End users, Technical team, participated in the meetings on regular basis and followed up the progress of work.
• Worked with the technical team for custom reporting requirements of the business users across different business departments of the various functions within the organization.
• Designed and analyzed processes for Procure to Pay (P2P)
• Set up accounting period types and accounting calendars.
• Worked on inbound interfaces in PO and AP module to import the data from legacy system to Oracle Application.
• Set up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
• Set up Catalogs, Stores, and Categories for iProcurement.
• Set up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Configure Financial, Accounting, and Purchasing options for setting up inventory organization.
• Developed and maintained user training procedures and documentation and conducted presentations covering user training sessions in GL, Purchasing, and iProcurement.
• Implemented approvals using the Approval Management Engine (AME)
• Participated in Conference Room Pilot (CRP1, CRP2, and CRP3) testing.
• Involved in defining Month End Close Processes.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Prepared and trained users for UAT in GL and AP.
• Involved in Post Production Support for Oracle Financials Modules and maintaining regular follow-up with Oracle Support Team and helped development team with bug fixing.
• Write ad-hoc queries in SQL/PLSQL using Toad to generate financial reports.
• Worked to resolve issues by analyzing transactions at the table level for financials modules.

Confidential, Jeannette, PA

Financials Functional Analyst

Responsibilities:

• Defined Business requirements for Oracle GL and AR. This involved identifying GAPS.
• Involved in finding effective solutions that involved both work around and customizations to the forms and reports.
• Interacted extensively with the end-users to understand and define a precise accounting flexfield structure in Oracle General Ledger.
• Defined the Chart of Accounts, the accounting calendar and the currency for each legal entity as per the client requirement.
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client's requirement.
• Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.
• Defined Budgets, Budget Organizations, Budget Formulas, and Defined Budgetary control options, Created Master/Detail budgets, Defined Mass Budgets and Mass Budget formulas.
• Designed and created reports for client using the Financial Statement Generator.
• Defined setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states.
• Defined Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets.
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources.
• Defined System Item Flex field, Defined Organization and worked with customization of forms and reports.
• Defined accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning.
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets.
• Define items, item attributes, advanced pricing and sourcing options under Order Management (OM).
• Setup inventory organizations.
• Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes.
• Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types.
• Participated in testing, user accepting testing in production and test instance
• Conducted CRP training for users and senior management as well.

Confidential, Englewood, CO

Financials Functional Analyst

Responsibilities:

• Participated in the deployment of Oracle Financials modules within Oracle EBS as a functional resource in the project team, and relayed new and existing processes to process owners and users.
• Developed and maintained positive and strong internal consulting relationships with managers and end-users in serviceable areas.
• Conducted various meetings in order to gather questionnaire for business team (RD20).
• Performed requirement analysis and gap analysis for implementation of GL and AP. Prepared documents for business requirements mapping (BR30) and functional specifications (MD50).
• Created and maintained application setup document (BR100) throughout the project.
• Defined Customers and attached customer profile classes, Invoice rules, Sales Persons, Transaction types, Payment Terms in AR.
• Handled system integration testing and UAT during Oracle Financials Release 11i (11.5.10.2) upgrade to R12.1.3, in various Oracle Financials modules.
• Completed the validation and testing of various new procedures and recommendations, and researched the efficiency of different complex accounting procedures
• Ensured that all enhancements are carefully and properly planned and tested prior to implementation in the production environment.
• Loaded, imported, and set up auto-reconciliation for bank statement transactions against payments in AP and AR in Oracle Cash Management module.
• Supervised the fabrication of reports for refund management and payment to third party vendors processes after business process owners' interviews
• Examined out of balance scenarios in the Oracle GL, and instigated proper actions to correct them within time constraints and managed the logging of exceptions report to Oracle DBA and escalated as needed.
• Involved with creating test cases to integrate Vertex Q series tax engine with Oracle EB Tax.
• Reviewed and confirmed location based tax setups to meet business requirements.
• Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules, Transaction Types, Sales Tax Location Flexfield, Tax Codes and Rates, Customer Profile Classes, Customers, Customer Banks, Lock Boxes, UOM for Procure to Pay (P2P) and Order to Cash (O2C)
• Write ad-hoc queries in SQL/PLSQL using Toad to generate financial reports.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Trained super users in new R12.1.3 AR, AP, GL, FA, EB-Tax and CE and also created detailed user manual.

Confidential, Beaverton, OR

Financials Functional Analyst

Responsibilities:

• Responsible for mapping business processes to Oracle Financial modules and performing functional analysis, requirements, definition, ERP module configuration and testing.
• Designed Financial Reports using Financial Statement Generator (FSG) tool
• Creating new OU and responsibilities and assigning to users and Setting profiles as needed
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals
• Monitoring cash application process through lockbox and manual receipts
• Writing test scripts TE40 and working with users to execute test scripts
• Developed Chart of Accounts in consultation with business owner and created value sets for the accounting flexfield structure.
• Developed functional documents for customizations in Procure to Pay (P2P) processes
• Trained users in the AP, AR, GL & CE processes and created detailed user manual.
• Fixing issues in TEST environments and Closely interacting with users for final testing before solution migration to production
• Involved in gathering and analyzing the user requirements in coordination with Business and formulate planning, budgeting, forecasting and reporting strategies.
• Tested system to meet invoice to cash process applying manual and Auto Lockbox receipts, and revenue reorganization in Receivables.
• Verified and tested Cash Management system to meet the bank file reconciliation processes.
• Performed system administrator role, and created users and custom menu, responsibilities
• Documented business processes, system design after the requirements gathering phase.
• Developed Test Plan / Test Cases and conducted User Acceptance Testing (UAT) sessions.

Confidential, San Diego, CA

Financials Functional and Support Analyst

Responsibilities:

• Assisted in primary setup steps for GL and AP modules using the business mapping document (BR30) provided by the Oracle Finance EBS team.
• Responsible for requirement gathering, requirement analysis, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP's for Accounts Payable.
• Set up Order Types, Invoice types, credit memo types, connecting invoice types to order types, order numbering, carriers, tax codes, set up items.
• Set up Revenue Recognition Invoices to recognize the revenue over period of time.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Involved in setting up Project Costing module - expenditure, category, revenue category, auto accounting, non-labor resource/cost rate, labor multiplier, rate schedule.
• Integrate Oracle Payables with iExpense and Oracle Project Billing.
• Used Accounting Rules to determine the number of periods and percentage of total revenue to be recognized (Revenue Recognition) in each accounting period.
• Involved in the setup of intercompany balancing and global intercompany system.
• Reviewing setups of Oracle Cash Management to use with Oracle Payables or Oracle Receivables.
• Perform the related setup tasks in the applications that work together with Internet Expenses to create an integrated environment for expenses reporting.
• Prepared the setup documents and configured system according to business requirements.
• Defined the chart of accounts, currency and accounting calendar. Created summary accounts and rollup groups. Created cross validation rules and security rules.
• Involved in developing test scripts (TE40) and user manuals for the entire Order to Cash cycle.
• Worked on inbound interfaces in PO and AP module to import the data from legacy system to Oracle Application.
• Defined system options, payment terms, banks, customers, transaction types and source, auto accounting.
• Setup customer profile class and customer relationships, dunning letters, aging buckets, defined collectors, receipt classes, source and program.
• Created test documents, conducted Unit, Integration and UAT of O2C and AR.
• Assisted in Conference Room Pilots (CRP) testing and created users manuals.
• Performed knowledge transfer/training for the users.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of GL and AR modules.
• Documented and presented procedures and training material to users in GL, AP, and AR.
• Trained users with closing the month in AR, AP & GL Modules and reconciling with GL.
• Worked with technical consultant for data conversion.
• Reviewed and confirmed location based tax setups to meet business requirements.
• Provided user and business level support for issues pertaining to Vertex tax interface.
• Write ad-hoc queries in SQL/PLSQL for various modules to troubleshoot issues during post production support.
• Directed and involved in process mapping of significant transactions and risk and control identification
• Conducted extensive tests as per test plans to evaluate the design and operating effectiveness of controls and mitigation of identified weaknesses.
• Organized training of four team members on business processes and Oracle Financials.

Confidential, Carlsbad, CA

Financials Functional Analyst

Responsibilities:

• Carried out module configuration, solution design, process analysis, and implementation of GL, AP, AR, and OM.
• Performed setups for GL, AP, and CE modules including system options.
• Responsible for the documentation including BR30, BR100, and TE40.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted for accurately and on a timely basis in Oracle GL.
• Developed Custom reports using FSG, Standard Interfaces, and Custom Interfaces linked to different modules of Oracle Applications from third party.
• Supported the implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements in the system.
• Created an interface to load Prime Vendors as Customers, match Vendor Invoices to Credit Memos from AP to AR in order to reduce vendor payments in AP and generate Customer Invoices to vendors in AR to interface with GetPaid.
• Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes.
• Assisted in design and development for interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management.
• Setup receivables to integrate with order management within Oracle E-Business Suite (EBS).
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Set of Books, Assigning Set of Books to a Responsibility, Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.
• Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules, Transaction Types, Sales Tax Location Flexfield, Tax Codes and Rates, Customer Profile Classes, Customers, Customer Banks, Lock Boxes, UOM.
• Setups included Defined Invoice attributes- Payment Terms, Approve, Hold & Release and Distribution Set, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplier and Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Integrate Oracle Payables with iExpense and Oracle Project Billing.
• Integrate Oracle Project Costing with Oracle Payables.
• Used Accounting Rules to determine the number of periods and percentage of total revenue to be recognized (Revenue Recognition) in each accounting period.
• Reviewing setups of Oracle Cash Management to use with Oracle Payables or Oracle Receivables.
• Perform the related setup tasks in the applications that work together with Internet Expenses to create an integrated environment for expenses reporting.

Confidential, Schaumburg, IL

Financials Functional Analyst

Responsibilities:

• Conducted meetings with Business users to perform the requirement analysis and developing functional specifications for the module including interaction with other modules.
• Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Involved in design and configuration of chart of accounts, calendar and currency.
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
• Set up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Involved in Integration between different Modules like Order Management and purchasing.
• Setting up banks, bank branches and bank accounts.
• Defining security rules and cross validation rules.
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to functionality as per requirement.
• Set up descriptive flexfields per business requirements.
• Generated financial statements like income statements, balance sheets using financial statement generator (FSG).
• Participated in Conference Room Pilot (CRP1, CRP2, and CRP3) testing.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Prepared and trained users for UAT in GL and AP.
• Defined payment terms and recurring invoice templates. Set up employee expense template.
• Perform the related setup tasks in the applications that work together with Internet Expenses to create an integrated environment for expenses reporting.
• Authored AIM documents for accounts Payable module including Business Requirement mapping (BR020), Setup (BR100), Conversion (CV40), and Test Scripts (TE40).