SUMMARY:

• Working for around 8 years as an Oracle Financials Functional Analyst with extensive expertise on all financial modules engaged on multiple Implementations, Upgradation, and Post - Production Support Projects in both Oracle R12 and 11i versions including integration of relevant modules in distribution areas as well. Also attained “Oracle Cloud Fusion Financials R9” training from Oracle University and comfortable working on any potential Oracle Fusion Cloud assignments.
• Extensive working noledge in Design, Implementation, Customization and Testing of Oracle E-Business Suite Financial modules which include General Ledger (GL) including Advanced Global Intercompany Systems (AGIS), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets(FA), Cash Management(CE), Purchasing (PO), E-Business Tax (E-B.Tax), and System Administration.
• 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).
• Evaluate business process & review including gap analysis to provide solution to key business requirements.
• Extensive work experience on the full life cycle implementation of Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R) and Record to Report (R2R).
• Created financials report using FSG (Financial Statement Generator).
• Implemented approvals using the Approval Management Engine (AME) functionally built into Oracle.
• 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).
• Follow up with off-shore technical team for timely deliverable and ensure to meet the aggressive time lines.
• Excellent communication and presentation skills.

TECHNICAL SKILLS:

Applications & Modules: Oracle Versions 11.5.10.2, R12.0.3, R12.0.5, R12.0.6, R12.1.1, R12.1.3, R12.2, Fusion R9

Tools: GL, AGIS, PO, AP, AR, CE, FA, SLA, E-B.Tax, iExp, Sys Admin, P2P, O2C, R2R Cycles

Data Loader: Toad, Bugzilla, Web ADI, OBIEE, Hyperion & Discoverer, Smart View, Hyperion

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

Languages: SQL, PL/SQL, RDBMS, HTML, XML, AUTO CAD, STAT12

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

PROFESSIONAL EXPERIENCE:

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.
• 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.
• 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).
• Tracked and communicated project tasks progress against deliverables and timelines and furnished updates to steering committee and Project management by using MS Project.
• 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 PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Developed and maintained user training procedures and documentation and conducted presentations covering user training sessions in GL and AP.
• 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.
• Set up accounting period types and accounting calendars.
• 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 halped development team with bug fixing.
• Worked to resolve issues by analyzing transactions at the table level for financials modules.

Confidential, Jeannette, PA

Financials Functional Analyst

Responsibilities:

• 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 Business requirements for Oracle GL and AR. dis 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 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.
• 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 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.
• 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.
• 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
• Developed Chart of Accounts in consultation with business owner and created value sets for the accounting flexfield structure.
• Developed functional documents for technical customizations
• 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.
• Writing test scripts TE40 and working with users to execute test scripts

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 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.
• 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.
• Setup receivables to integrate with order management.
• 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 noledge 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.
• 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, and AR modules.
• 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 has 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.
• 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.
• 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).

Confidential, Ann Arbor, MI

Financials Functional and Support Analyst

Responsibilities:

• 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.
• Instrumental in Project Accounting and GL design and integration with other modules.
• Review and improve Procure to Pay (P2P) and Order to Cash (O2C) processes.
• Responsible to set Accounting flexfields, Defining Journal Sources, Journal categories, Document Sequences and their assignment, Chart of Accounts maintenance.
• Created Oracle Standard reports developed using Financial Statement Generator (FSG), Account Analysis reports development, Trial balance reports development.
• Created an interface to load Prime Vendors as Customers, match Vendor Invoices to Credit Memos from Accounts Payable, AP, to Accounts Receivable, AR, to reduce vendor payments in AP and generate Customer Invoices to vendors in AR to interface with GetPaid.
• Trained users with month-end and year-end reconciliations for closure of subsidiary modules - AR and AP.
• Assisted in primary setup steps for GL, AP, and AR modules using the business mapping document (BR30) provided by the Oracle Finance team.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Documented and presented procedures and training material to users in GL, AP, and AR.
• Developed test cases on various functional scenarios and provided to users and conducted UAT sessions on the instance.

Confidential, St Paul, MN

Financials Functional Analyst

Responsibilities:

• Implementation of the Accounts Receivables module, trouble-shooting and conducted demos for the end users.
• Worked in Revenue Cycle in Accounts Receivable module.
• Set-up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Assigning receivable account, revenue account, unbilled account, freight account, clearing account, and unearned account to transaction types.
• Defined business requirements for Oracle General Ledger, Accounts Receivables, carried out gap analysis, and mapped the client's requirement in Oracle.
• 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.
• Set-up Oracle Receivables and Oracle Payables including System Options.
• Defined the Cash Discounts, which will calculate the discounts for the customers for early payments. They were manually adjusting the discounts for the customers previously and were giving discounts to all customers.
• Defined split payment terms for invoice installments that has different due dates and assigned multiple discounts to each payment line.
• Defining sales person. Defining customer.
• Transferring Receivable transactions to General Ledger.

Confidential, West Port, CT

Financials Functional Analyst

Responsibilities:

• Business communications for the system updates and meeting the deadlines for the implementation.
• 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.
• Set-up Oracle Receivables and Oracle Payables including System Options.
• 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.
• Supervised the period close and quarter close processes by ensuring that all financial transactions has been accounted for accurately and on a timely basis in Oracle GL.
• Developed Custom reports, Standard Interfaces, 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 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.
• Took active participation in SOX (Sarbanes-Oxley) compliance for auditing purposes.