SUMMARY

• Around 8 years working as an Oracle Financials Functional Analyst with vast exposure on multiple implementations, Upgradation, 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 Financial modules which include General Ledger (GL) & AGIS, E-B.Tax, Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets(FA), Cash Management(CE), Purchasing (PO) Financial Accounting Hub (FAH), 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, AGIS, E-B.Tax, FA, CE, PO and System Administrator) and their interplay in the overall accounting structure of an organization.
• Experience with Oracle AIM methodology documents like, RD20, BP80, BR30, BR100, MD50, CV40 & TE40
• Extensive experience in working with global implementations involving Advanced Global Intercompany System (AGIS) and multi-currency revaluation and translation.
• Thorough technical and functional understanding of Multi-Org Access Control (MOAC) and SLA.
• Conducted and evaluated business process review and gap analysis to resolve business requirements not addressed by Oracle applications.
• 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).
• Conduct meetings with business to understand the functional change proposals and create documentation with detailed functional Impact Analysis with the change proposal as part of Change Management Process
• 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 Requests.
• 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 communication and presentation skills.
• Vast experience in working onsite and offshore model projects with aggress time lines and critical deliverables.
• 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: GL, AP, AR, CE, E-B.Tax, AGIS, FA, SLA, FAH, IExpense, PO, System Administration

Other Tools: Data Loader, Toad, PLSQL Developer, Bugzilla, ADI, Web ADI, OBIEE, Hyperion, Discoverer Microsoft Office: Access, Excel, Outlook, PowerPoint, Visio, Word

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

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Oracle Financials Techno Functional Consultant

Environment: Re Implementation, Implementation and Production Support of R12.1.3

Responsibilities:

• Lloyds Managing Agent Integration
• Responsible for ensuring the technical design is delivered to spec including full test execution and validation with sign off by finance.
• Played a leading role in ensuring delivery of the attributes from IRIS, working with the relevant PM and ADM leads.
• Delivered the functional solution for the FAH and Ledger configuration changes.
• Provide the project management updates and status for functional and technical deliverables
• Played an active part in debugging calls driving resolution.
• Worked with finance to help them define the functional finance close steps, and complete business analysis of the finance close data and steps.
• Lead the technical and functional to enhance the FAH Application and development WEBADI to enter Sub Ledger Accounting journals
• Configures mass allocations for Lloyds integration
• Future Insurance Platform Integration
• Act as the CIT lead on all FIP related project calls.
• Demonstrate proactive review of Oracle integration solution design.
• Demonstrate an ability to effectively escalate overall solution design flaws.
• Drive the coordination of overall end to end testing by engaging with finance and Insurance IT staff.
• Derived Oracle Outbound integration
• Facilitated the reporting team like ASLOB, IDP (Insurance data Platform), OBIEE, HFM by building views for outbound integration
• SICS Harrington Re Insurance Integration
• Conducted end-user meetings to review current and future business processes and requirement gathering
• Performed on-site requirement analysis and developed functional specifications for the modules and customized processes
• Prepared the various documents required under the AIM methodology
• Conducted Business Process Review (BPR) and GAP analysis to determine business requirements
• Member of the core team responsible for implementing GL and FAH
• Prepared and maintained migration checklist and worked with Application Maintenance to migrate all the components across environments
• Trained the users for UAT and conducted UAT.
• Created Test Scripts (TE-40’s) for UAT sessions
• Ongoing Production support
• Continued to provide specialist support on the Confidential Oracle finance applications (GL, AP, FA, FAH).
• Reviewed design component of Application enhancements/updates.
• Guided the Application Maintenance & development teams on day to day queries in relation to the existing platform.
• Worked with Application Maintenance teams the to bring together the cross functional resources during crisis issue resolution.
• Aided internal Audit to reconcile across applications
• Data management lead
• Ensured that the Functional Change Management review for Meta data changes is executed in a timeline fashion.
• Communicated overall deployment status to the CIT leads on business critical functional changes required as part of the Meta data review.
• Worked to identify key functional and data risks and provide risk mitigation alternatives for proposed Meta data changes.
• Enhancement delivery
• Drive the delivery of specific key enhancements such as the ULAE, supporting reference looping (I.E., cell, Domicile Location, Exposure location, risk code..) & Fixed Assets developments.
• Demonstrate that adequate development protocol has been followed covering requirements definition, analysis, solution design, development and testing.
• Work closely with Application Enhancement to ensure an effective team dynamic exists that can promote efficient implementation of enhancements.
• Involved in Configuring the Functional setup for inbound and outbound interfaces like (GRD, Concur, Paypilot..)
• Involved in 11g to 12c upgrade functional testing
• Worked as a lead technical and functional developer to design and develop Re Insurance solution for mortgage Business
• Amended WEBADI templates and code to include additional attributes required for reporting
• Participated in testing Active Data Guard (ADG)
• Developed and delivered oracle alert to notify users
• Provided solution for supplier security (Approval process)
• SUN Decommission
• Worked on developing and testing claim and expense checks (Payment template, Payment format, Payment Document
• Configured the Bank account setup
• Prepared and maintained checklist for various migration components
• Involved in UAT testing and receiving Sign off
• Aided in configuring Fixed Asset and handled change required
• Modifying SLA for AP and FA.
• Prepared custom 1099 report for year-end reporting.
• Drafted requirement and mapping document for FAH
• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials FAH and GL related components
• Involved in setting up Fixed Asset
• Worked with the .NET and technical lead to developed custom FAH solution for Confidential Re Insurance (Outbound and Inbound solution)
• Built FAH solution design and maintained Documents I.E., Functional Design, BR100
• Supported finance to reconcile Oracle to legacy application
• Confidential Data Warehouse Integration
• Member of the core team responsible for implementing GL and FAH owning the functional delivery
• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials GL and FAH
• Work with development team to ensure end user requirements are met
• Conducted CRP1, CRP 2 and post production support
• Created BR100 documentation for GL and AP
• Created Customized responsibilities, customized menus, customized request groups
• Created and followed up with service request with Oracle Support to get multiple patches, partitions and bug fixes applied and fixed.
• Aided finance validation process by creating Ad-hoc Reports
• Trained User to
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for SIT, UAT, user feedback integration.
• Assisted finance to explain the data flow/ validations and essential oracle accounting methodology

Confidential, Miami, Florida

Oracle Financials Functional Consultant

Environment: Implementation of R12.1.3

Responsibilities:

• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents
• Designed chart of accounts to meet the client’s business requirements
• Set-up accounting period types and accounting calendars
• Developed cross-validation rules
• Set up Fixed Assets including defining category, location, and asset key flexfields
• Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar, book controls and system controls
• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
• Performed Asset Transfer, Mass retirement, Reinstate the retirement and Mass Changes in Assets
• Worked on Construction in Process (CIP) assets, adjustments, and classification of assets
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization
• Participated in planning and set-up of accounting flex-field structure and chart of accounts
• Setup Oracle Payments for Check, ACH, and Credit Card Payment Methods
• Set up the financials and payables options and created different bank accounts for Payables
• Involved with migration of historical data for Account Payables
• Created newer FSG reports depending on the business requirements
• Involved with study of existing system, preparing the Functional (MD50) with Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components
• Configuration of CRP2, CRP3, and UAT instances
• Preparing test scripts and performing smoke testing prior to user testing
• Keeping track of and updating issues with proposing resolution in Bugzila issue tracker
• Involved in month-end closings, interfaces maintenance, and change management
• Designing of user-manuals for the modules and training the end users
• Providing post production support to the business users

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 flex field 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.
• 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, Boston, MA

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
• 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 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.

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.
• 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.
• 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.

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.
• 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.
• 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.
• 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).