SUMMARY:

• Working for around 8 years as an Oracle Financials Functional Analyst wif 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 knowledge 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 wif 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 wif all levels of business owners and users during teh various stages of project lifecycle.
• Competent in understanding teh functionality of teh core Oracle Financial modules (GL, AP, AR, FA, CE, PO) and their interplay in teh overall accounting structure of an organization.
• Experience wif Oracle AIM methodology documents including RD20, BP80, BR30, BR100, MD50, CV40, and TE40.
• Extensive experience in working wif 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 teh 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 teh Approval Management Engine (AME) functionally built into Oracle.
• Interacted wif Oracle support using Metalink and Oracle Web Conference (OWC) to resolve application issues and bugs; maintained follow-up wif 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 wif User Acceptance Trainings (UAT).
• Created and maintained user manuals and held training sessions for large user groups.
• Involved wif all phases of Conference Room Pilot testing (CRP1, CRP2, and CRP3).
• Follow up wif off-shore technical team for timely deliverable and ensure to meet teh 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 teh project since teh requirement gathering stage and involved in teh full life cycle of teh project.
• Created and maintained application setup document (BR100) throughout teh project.
• Collaborated wif 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 teh 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 teh regular interaction wif teh Client, End users, Technical team, participated in teh meetings on regular basis and followed up teh progress of work.
• Worked wif teh technical team for custom reporting requirements of teh business users across different business departments of teh various functions wifin teh 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 wif Oracle Support Team and helped development team wif bug fixing.
• Worked to resolve issues by analyzing transactions at teh table level for financials modules.

Confidential, Jeannette, PA

Financials Functional Analyst

Responsibilities:

• Defined teh Chart of Accounts, teh accounting calendar and teh currency for each legal entity as per teh 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 teh 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 teh forms and reports.
• Interacted extensively wif teh end-users to understand and define a precise accounting flexfield structure in Oracle General Ledger.
• Defined setup steps of teh 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 wif 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 teh deployment of Oracle Financials as a functional resource in teh project team, and relayed new and existing processes to process owners and users.
• Developed and maintained positive and strong internal consulting relationships wif 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 teh 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 teh validation and testing of various new procedures and recommendations, and researched teh efficiency of different complex accounting procedures
• Ensured that all enhancements are carefully and properly planned and tested prior to implementation in teh 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 teh fabrication of reports for refund management and payment to third party vendors processes after business process owners' interviews
• Examined out of balance scenarios in teh Oracle GL, and instigated proper actions to correct them wifin time constraints and managed teh 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 teh 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 wif business owner and created value sets for teh accounting flexfield structure.
• Developed functional documents for technical customizations
• Trained users in teh AP, AR, GL & CE processes and created detailed user manual.
• Fixing issues in TEST environments and Closely interacting wif users for final testing before solution migration to production
• Involved in gathering and analyzing teh user requirements in coordination wif 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 teh bank file reconciliation processes.
• Performed system administrator role, and created users and custom menu, responsibilities
• Documented business processes, system design after teh requirements gathering phase.
• Developed Test Plan / Test Cases and conducted User Acceptance Testing (UAT) sessions.
• Writing test scripts TE40 and working wif 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 teh business mapping document (BR30) provided by teh 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 teh revenue over period of time.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Integrate Oracle Payables wif iExpense and Oracle Project Billing.
• Used Accounting Rules to determine teh number of periods and percentage of total revenue to be recognized (Revenue Recognition) in each accounting period.
• Involved in teh setup of intercompany balancing and global intercompany system.
• Reviewing setups of Oracle Cash Management to use wif Oracle Payables or Oracle Receivables.
• Perform teh related setup tasks in teh applications that work together wif Internet Expenses to create an integrated environment for expenses reporting.
• Prepared teh setup documents and configured system according to business requirements.
• Defined teh chart of accounts, currency and accounting calendar. Created summary accounts and rollup groups. Created cross validation rules and security rules.
• Setup receivables to integrate wif order management.
• Involved in developing test scripts (TE40) and user manuals for teh entire Order to Cash cycle.
• Worked on inbound interfaces in PO and AP module to import teh 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 teh users.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation wif detailed testing of GL and AR modules.
• Documented and presented procedures and training material to users in GL, AP, and AR.
• Trained users wif closing teh month in AR, AP & GL Modules and reconciling wif GL.
• Worked wif 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 teh 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 teh documentation including BR30, BR100, and TE40.
• Business communications for teh system updates and meeting teh deadlines for teh implementation.
• Supervised teh 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 teh implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on teh changing requirements in teh 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 wif 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 Wifholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Integrate Oracle Payables wif iExpense and Oracle Project Billing.
• Used Accounting Rules to determine teh 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 wif Oracle Payables or Oracle Receivables.
• Perform teh related setup tasks in teh applications that work together wif Internet Expenses to create an integrated environment for expenses reporting.

Confidential, Schaumburg, IL

Financials Functional Analyst

Responsibilities:

• Conducted meetings wif Business users to perform teh requirement analysis and developing functional specifications for teh module including interaction wif other modules.
• Involved wif study of existing system, preparing teh 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 teh related setup tasks in teh applications that work together wif 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 teh project.
• Instrumental in Project Accounting and GL design and integration wif 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 wif GetPaid.
• Trained users wif 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 teh business mapping document (BR30) provided by teh 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 teh instance.

Confidential, St Paul, MN

Financials Functional Analyst

Responsibilities:

• Implementation of teh Accounts Receivables module, trouble-shooting and conducted demos for teh 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 teh 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 teh Cash Discounts, which will calculate teh discounts for teh customers for early payments. They were manually adjusting teh discounts for teh 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 teh system updates and meeting teh deadlines for teh 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 Wifholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Supervised teh 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 teh implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on teh changing requirements in teh 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.