SUMMARY:

• Expertise in Implementation, Upgrade, Re - Engineering, Rollout and Support engagements on Oracle E-Business Suite of 11i & R12 versions.
• Adept in requirement gathering & Business process mapping, GAP analysis, Solution design, Module Configurations, Conversions, testing, Post Production Support.
• Interacted with the Process champions & Business owners during various stages of project lifecycle on each & every Toll Gate (TG) reviews.
• Expertise in the Oracle EBS modules: Oracle General Ledger, Oracle Accounts Payable, Accounts Receivable, Oracle Asset, Cash Management, Purchasing, iExpenses, iProcurement and System Administrator.
• Good Functional knowledge on Multi-Org, MOAC and Multi Currency concepts.
• Strong knowledge on the new enhancements of R12 such as Oracle Payments, Subledger Accounting (SLA), E-Business Tax (EBT) and the respective integrations with other modules.
• In-depth knowledge of all the aspects of Procure-To-Pay cycle.
• Familiar with SDLC (Software Development Life Cycle), AIM Methodology.
• Configure Business access as per SOX (Sarbanes-Oxley) compliance and setting up responsibilities accordingly to maintain the proper internal control mechanism
• Prepared Gap analysis document (BR010), configuration documents (BR100) and functional design documents (MD50)
• Proficient in Regime to Rate flow to get the taxation for the subledger transactions.
• Experience in conducting CRP, Unit Testing, System Integration testing.
• Well versed with Application Tools TOAD, Data loader, ADI & WebADI.
• Providing support to the users in different modules and support during month end closing.

TECHNICAL SKILLS:

E-Business suite: Oracle Financials R12/11i, SAP R/3

Office ApplicationsERP: GL, Receivables, Payables, Fixed Assets, Cash Management, Service Contracts, Install Base, iExpense, iProcurement and Purchasing

Operating Systems: SQL, PL/SQL, Oracle

Other Tools: TOAD, SQL*Plus, Data Loader, 170 Systems Kofax, PVCS, Kintana and Hp Quality Centre

Languages: Microsoft Outlook, Visio, MS Project, Excel, PowerPoint, AccessWindows 95/98/NT/2000/XP and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Valencia, CA

Oracle Financial Functional Analyst

Responsibilities:

• Represented global finance team to oversee issues, changes, enhancements, etc.
• Provided ad-hoc SQL queries to support business process needs and month end close.
• Gathered requirements, created functional designs and assisted business users with UAT.
• Troubleshooting user issues related to FSG, ADI and Web ADI.
• Involved in configuring the discoverer access reports.
• Involved in testing and validating the PO interfaces.
• Analyze daily production issues.
• Worked on Sysadmin activities such as creating custom responsibilities, securing attributes, functions, menus, creating PO buyers and approvers.
• Assist the users with month end closing activities.
• Assisted with mapping General Ledger balances to Hyperion.
• Worked with the internal auditors (RAAS) of the company to identify areas of risk and to ensure SOX compliance.
• Resolution of functional issues and interface issues assigned to the Support team.
• Responsible for addressing interface issues across GL, AP & AR and assisting month end closing.
• Work with Oracle Technical Support in follow up and conduct Web conferences for speedy resolution of High Priority issues with keep tracking through SEV1 and SEV2 SRs.
• Responsible for Disaster Recovery (DR) testing on Oracle financial modules.
• Trained Business Users as to how to leverage WebADI to upload journal entries to Oracle GL & addressed the issues during uploading data using WebADI.
• Conducted multiple meetings with business for critical issues and proposed change requests and responsible to get signoff for proposed changes, if any.
• Keep track of issues based on severity and provide functional analysis with proposed resolution.
• Replicate issues in latest cloned copy of production instance and provide impact analysis with proper documentation.
• Involved and discussed with Client IT team & DBA to identify the recent upgrade patches and test the same to ensure there is no impact with the existing functionality and or configuration.
• Updated the existing BR 100 with proposed module extensions approved through Change Management Process.
• Responsible to perform RCA for Business critical issues & prepare RCCA.
• Implemented process improvement initiatives for the recurring issues.
• Responsible for taking extracts of GL interface/ AP Period close exception & AR unposted Items reports along with recommended solutions and sent them to the Business Users asking to take action on the same for smooth period close.

Oracle Financial Functional Analyst

Responsibilities:

• Core responsibilities involved training Users and trouble shooting in the areas of Install Base/Service Contracts/PO/AP and AR modules.
• Familiar with the complete cycle of service contract creation to billing in AR.
• RCA prepared for wrong AR billing.
• Create and follow-up on multiple SEV1 & SEV2 SRs.
• Coordinate with DBA team to apply patches proposed by oracle after following up on existing issues.
• Production troubleshooting and analysis of business process issues within Service Contracts (OKS) and Install Base (CSI)
• Responsible for addressing interface issues across AR.
• Handled issues related to credit/ rebill process, creation, termination of Service Contracts.
• Designed the Test Scripts and Test Scenarios for iProcurement and iSupplier Portal.
• Update the Price Lists and Coin-Ins for various WAP contracts.
• Corrected various irregular billing periods and bad data in Install Base.
• Resolve system issues with the billing from service contracts and create a credit rebill process to clear incorrect invoices that have already been sent to the customer.
• Assist the business with month end closing activities in AP/AR.
• Implemented process improvement initiatives for the recurring issues.
• Involved in smoke testing, unit testing and regression testing in AP.

Oracle Financial Functional Analyst

Responsibilities:

• Worked with the COA team for configuration and maintenance of Chart of Accounts.
• Provided functional support to business users in Payables.
• Involved in resolving functional issues and setup issues as per Companies specific requirement.
• Worked with Oracle Technical Support and conducted Web conferences for speedy resolution through SEV1 and SEV2 SRs.
• Resolved high priority defects using Quality Center.
• Responsible for prioritizing the Defects and expedited them within SLA timelines.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup the tax rules
• Involved in configuration of CRP1, UAT and test instance.
• Part of Conference Room Pilot (CRP1), Prepared Setup documents, Test scenarios and Test scripts
• Involved with CRP, SIT, UAT, Conversion, Go- Live and Post Production Support.
• Extensively worked with technical teams, DBAs, SOA administrator during SIT.
• Prepared training documents and conducted user training.
• Performed functional testing and worked with the offshore teams to resolve issues.
• Involved in reviewing the Current Business Model (BP040) and had presentation of Future Process Model (BP80) during CRP phase.
• Presented Demos of new features of R12 financials to key stakeholders during design workshops.
• Prepared Application setup (BR100) and Application Extensions Functional Design documents (MD50) according to AIM.
• Configured the Chart of Accounts Structure based on the Reporting dimensions of the As-Is process of the Business post CRP session with Finance team & IT team process champions.
• Set up AP bank accounts, bank documents, bank codes and expense report templates.
• Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc and setting up Payment methods, Payment format and Payment Process Profile etc.
• Set up suppliers, locations, and purchasing quick codes.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Defined profile options to specify certain implementation parameters.
• Defined the Payables and Financials Options.
• Set up recurring journals template, recurring journals.
• Define Legal Entity, ledger with using Account Setup Manager (ASM).
• Configured User Management using System Administrator to setup users and assign responsibilities and set profile options.
• Instigated Segregation of Duties (SOD) to meet SOX compliances.
• Prepared System Integration Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users.
• Trained Business Users and troubleshooting during User Acceptance Test (UAT).
• Organized the Reporting Currencies at Balance & Subledger conversion levels.
• Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes.
• Deployed Auto-reversal feature for Accrual entries in GL.
• Designed and developed FSG reports in GL.
• Participated in testing, user accepting testing in test instance and worked with certain key super users.

Oracle Financials Functional Analyst

Responsibilities:

• Collected data from business users to complete set ups.
• Gathered accurate specifications from OSC.
• Understanding the client requirements for data migration of data related to 'Procure to Pay' process from business legacy to Oracle SSS which includes Items, POs and Suppliers.
• Prepared Tollgate PowerPoint’s, attended tollgate review calls and change control calls to move any new functionality/code going in to production.
• Involved in CRP session to understand the As-Is business process & presented Future Business Model (BP080).
• Configured Security rules to restrict specific segment values for different Users at responsibility level as per Business requirement.
• Responsible for fixing any type of setups and functional Issues in PO, iProcurement and Get Services Applications.
• Participated in Punchout setups and testing.
• Validated the Right Fax setups.
• Worked with the Sabrix tax team in testing of the tax rules set up in the Sabrix tax engine.
• Responsible for the configuration of Purchasing, Accounts Payable & General ledger modules.
• Major contribution in System Integration Testing (SIT) on Procure to Pay Cycle.
• Participated in forums, opened TAR’s with Oracle using metalink and resolved issues that were encountered during testing phase.
• Involved in preparation of release document with the summary of code changes & impact of the CR with rationale for PROD migration .
• Involved in data conversion from legacy systems into Oracle Applications using DATA LOADER, SQL*LOADER and PL/SQL.
• Implemented AP withholding tax functionality.
• System Administrator responsibilities like creation of Responsibilities, setting up the profile options, creating custom menus & setting up custom Request Groups etc.
• Browser compliance testing on SSS Applications like SSS Buy to Pay, ISupplier, GEtServices, Punchout Sites, Core Purchasing and Payables.
• Prepared the training material, SOPs for Custom features & conducted handholding sessions for Business users.

Oracle Financials Functional Analyst

Responsibilities:

• Worked as an Asst. Functional Analyst for Oracle Purchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets.
• Studied and evaluated functionalities of various modules.
• Defined Set of books, accounting flexfield structure.
• Prepared Setup documents (BR100) for Accounts payables & Accounts Receivable.
• Created Responsibilities with menu exclusions as part of SOD & tested all the menus & functions.
• Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Prepared functional Design Documents for application extensions and conversions (MD.050).
• Prepared Test Scripts for Integration Testing (TE040).
• Developed the training material for the users.

Accountant

Responsibilities:

• Prepared bills and passenger sales report, collection and credit control.
• Expedited collection of payments from customers and reduced receivables to target level.
• Handled Foreign exchange, Travel Insurance, Western Union and Moneygram Transactions.
• Prepared bank and loan statements and reconciliations.
• Collaborated and coordinated credit, vehicle loans, and bank guarantees.
• Handled payments to suppliers and prepared airline reports.
• Handled vehicle loans and allied matters.
• Prepared marketing strategies and business development plans.
• Supervised Passenger Sales Report, Ticket stock control and Airline payments.
• Maintained Books of Accounts and Credit Control.
• Handled auditor’s requirements.
• Co-ordinated with airline and agency staff to facilitate smooth working of the agency.
• Ascertained Service Tax, Income Tax and finalization of accounts.

Associate

Responsibilities:

• Identified and tagged various documents which are involved in process of a loan.
• Cleared broker payments.
• Updated MIS and prepared weekly & monthly efficiency and error reports.
• Obtained authorization from the asset managers in the US to conduct work on property.
• Attended and solved process related queries from US and India.