SUMMARY

• Excellent consultant with over 8 years of experience in implementing Oracle EBS R12/11i financial suite of applications.
• Exceptional in working with business users and all levels of management in gathering analyzing business requirements, identifying bridging gaps between business needs and product functionalities/capabilities.
• Proficient in configuring an delivering functionalities and RICEFW objects in Accounts Payables AP, Accounts Receivables AR, Cash Management CM, Fixed Assets FA, Project Accounting PA, E - Business Tax EBTax/ZX and General Ledger GL applications.
• Worked on 3 full life cycle implementation projects and in a multi-org and multi-currency environment.
• Authored business documents such as BP-040, to-be BP080, setups BR-100, test cases TE-020, 030, 040 and gap analysis MD050 .
• Trained the client's business users on using the application, conducted conference room pilot testing CRP, system integration testing SIT, user acceptance testing UAT, design validations and setups of the distributed ERP applications.
• Liaison between project management office, steering committee, cross-teams, on-site/off-shore personnel, development, DBAs and Oracle support team.
• Good functional knowledge system administration, security and MOAC.
• Effectively managed client's expectations and successfully rolled-out functional and technical solutions.
• Worked extensively with development team members in resolving issues by Creating SRs/TARs and obtaining one-off solutions using Oracle Metalink.
• Demonstrated leadership, problem solving, research, inter-personal and organizations, written and verbal skills.
• Able to work both independently and/or as part of a team, prioritize tasks and work on multiple assignments.

WORK EXPERIENCE

Confidential

Oracle Business Analyst /Oracle financial Functional Consultant

Environment: Oracle Applications R12 -12 GL, AP, CM, i-expenses, System administrator

• Working closely with business users for gathering business -requirement for SAP-R12 integration project for implementing oracle financials Modules GL/AP/CM
• Worked on the Full life cycle Implementation of SAP-R12 integration project and involved with various Business and Accounting teams.
• Authored functional design documents BR.100, BR.110. MD.050, T.E.020 for General ledger, Accounts payables and cash management modules.
• Developed the functional Designing documents for the Expense Feed Transactions Out bound Interface from Oracle r12 to SAP.
• Reviewed and uploaded the COA values for R12-SAP Reverse Mapping values for the expense feed Program.
• Involved in Uploading the Suppliers from SAP to Oracle using the Web-Adi template.
• Involved in configurations of general ledger, payables for the new legal entities as part of Integration between oracle-R12 SAP.
• Involved in designing providing the solution for data security requirement in general Ledger and accounts payables Module between Athene Business Units.
• Configured the banks, bank accounts, pay groups, payables documents, payment templates and payment process profiles for processing of payments for Athene Holding.
• Configured new security rules, new responsibilities and new profile options for Athene Holding.
• Managed and Co-ordinate with the offshore team on daily basis for assigning work and helping them to understand the functional design documents.
• Reviewed the Technical design documents and was involved in multiple walk-through sessions with Business and I.T teams.
• Provided end user training Accounting professionals and prepared end users for go live.
• Opened managed the SR's for resolving the issues by co-coordinating with ORACLE SUPPORT DBA'S.
• Involved in the post production support phase for trouble shooting issues and helping development team in bug fixing.

Confidential

Oracle Financials functional Consultant

Environment: Oracle Applications R 11i AP, GL, CM, AR, E-bTax, SLA

• Worked closely with the business users in defining scope of the project, gathering business requirements, understanding business processes and business requirement documents at a detailed level with Variations.
• Created As-Is and To-Be Gap Analysis documents system documents to show the current state and future state processes and functionalities of the system.
• Developed functional designed documents MD50's based on business requirements.
• Developed training documents and user guides.
• Defined suppliers, invoices, payments, 1099, transferred AP accounting to GL.
• Managed invoices and invoices work bench, holds and distributions, reviewed and processed new suppliers from acquisitions, resolved payment batch issues for end-users, implemented 1099 reporting, supported period close and ran reconciliation reports in AP.
• Maintained accounting periods and performed/supported period end closings in AP.
• Trained users on how to enter maintain and perform actions on invoices in AP.
• Defined transaction sources, transaction types and memo lines for implementing 'Auto Invoice'.
• Assisted developers in developing code for processing customer invoices.
• Defined customer profile classes, customer account relationships, invoices, AutoInvoice, customer invoices receipts and tax accounting.
• Defined banks, bank branches, bank accounts, transaction codes and bank account signing authorities in CM.
• Performed bank accounts reconciliation in CM with integration to AP and AR.
• Implemented EBTax with integration to Vertex for OTC and PTP business processes, uploaded tax rates and rules files from the Vertex updates.
• Defined tax rules, customer exemption, product category exemption, tax exemptions based on user define code to stop calculation tax on some of the imported invoices and some of the manual invoices.
• Configure self-assessment in EBTax and designed MD050 to capture use tax calculated for non registered supplier.
• Developed interfaces to convert vendors/suppliers using supplier interface in AP, vendor invoices using invoice import and converted payments using payables interface in AP.
• Took ownership of an incomplete design and successfully implemented code to process transactions for unbilled revenue and revenue account coding interface, cost of goods sold allocation interface, statistics interface and postage interface in AR and GL,
• Prepared specifications for around 10 customized reports: Printed Purchase Order Portrait Report, Performance Review Profile Report, Monthly Performance Review Extraction Report, Print Purchase Order Report, Vendor Accuracy Report and many more.
• Co-ordinated with the developers during development and customization of reports as per the business requirement.
• Conducted CRP and UAT sessions with the business users
• Addressed and closed many open issues with varying criticality.
• Assisted developers in helping them to understand functional requirements, reviewed technical design documents and testing the enhancements and customizations of RICEFW objects.
• Provided training to the end users and accounting professional and prepared end-uses for go-live.
• Opened, managed and resolved SRs/TARs with Oracle Support team and DBAs.
• Involved in the post production support phase for trouble shooting issues and helping development team in bug fixing.

Confidential

Oracle Financials Functional Consultant

Environment: Oracle Applications R12 12.1.2 AP, PO, GL, iexpenses, i supplier, SLA

• Worked with R12 Implementation team to study the existing client's systems, preparing the functional design documents to extract the data from legacy system Passport into Oracle Applications open interface tables.
• Involved in gathering business requirements, analysis and design the future business process for AP and iExpenses applications.
• Involved in setups financials and payables options, payment system, payment profiles, payments templates options including all key configurations in AP.
• Involved in setups expense report templates, expense report options, policies allocations, receipt notifications rule set, mileage expense type definitions in AP,
• Assigned responsibilities to internal users, enabling function security, enabling profile options and other key configurations in iExpenses and iSupplier applications.
• Designed and setup inbound process to import invoices from external sources.
• Designed the functional specification documents for customized interfaces EDI, reports and extensions.
• Prepared documents for setup configuration BR 100, training manuals in AP and iExpenses applications.
• Responsible for end-end internal testing, CRP/UAT and regression testing, including obtaining the sign off from the business stake holders sponsors at various stages of project.
• Performed unit testing and helped the user with the testing, identified and fix the bugs before the go-live
• Resolved period close issues in AP.
• Performed functional testing, worked with off-shore teams and Oracle support team to resolve the issues.
• Worked extensively on production support role, supporting end users and provided solutions to the bugs/enhancements.

Confidential

Oracle Financials Functional Consultant

Environment: Oracle Applications 11i 11.5.10.2 GL, AR, PA, CM

• Worked with a team for gathering business requirements BR030 for custom revenue sub ledger ALE Auto Accounting Lookup Engine, using Oracle project accounting auto accounting lookups and posting summary amounts to GL.
• Mapped client business requirements to Oracle functionalities and identify the gaps based on the study and preparations of BR030 business requirements document and BR100 Setup document for project accounting module as per Oracle AIM methodology.
• Prepared functional design document MD050 to extract data from external system to custom revenue sub ledger and then to Oracle GL interface table and then to post to GL.
• Implementation of project billing and project costing including organizations, implementation options, expenditure categories/ types, event types, non labor resources, cost rates, bill rate schedule, budget entry methods, project classifications, project types/ templates, auto accounting rules/lookup sets.
• Involved in set-up of invoices, debit and credit memos, guarantees, deposit transaction types, receipt class, receipt methods, auto applications and auto cash rule sets, setup customers and customer profiles.
• Created payment terms and assigned them to customer profiles.
• Designed custom forms and reports for the requirements of the clients and integrated them with ALE system.
• Involved in complete cycle testing of process flow and reconciliation of revenue data received from external system and transferred to ALE and posted to GL.
• Worked on the journal import process from sub ledgers to GL.
• Conducted CRP, SIT and UAT sessions for implementations.
• Prepare test script for and train the end users with the new process.
• Resolved period end and year end closing issues.
• Providing production support of Oracle project accounting, including following up SR's with Oracle Metalink.

Confidential

Oracle Financials Functional Consultant

Environment: Oracle Applications 11i 111.5.10.2 AP, PO, AR, CM, GL, FA

• Responsible for resolving production issues for oracle apps 11.5.10.2 financial modules.
• Responsible for prioritizing the defects and expedite them within SLA timelines.
• Involved in the super users global calls in prioritizing the change requests.
• Responsible for cut-over plan for the change requests, validation of test scripts and documentation
• Configured the AP/AR netting process for the intended suppliers and customers as a part of change request
• Cleared the transactions made in AR cash receipts and AP payments in CM.
• Created clearing and reconciling bank statements in AP and AR.
• Solved the currency problem for freight in the invoice transaction.
• Replicate issues in latest cloned copy of production instance and provide impact analysis with an appropriate documentation.
• Involved and discussed with client's 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.
• Tracked all client and Oracle support activity related to service request SR issues and documented it in the client issue tracking system Clear Quest as well as the project implementation logs.
• Worked as functional tester to write test scripts, test cases and test conditions to perform end-to-end testing of the application.
• Worked extensively on production support role, supporting end users and provided solutions to the bugs/enhancements.

Confidential

Oracle Financials Functional Consultant

Environment: Oracle Applications 11i 11.5.10.2 AP, PO, GL, FA

• Worked with an implementation team for phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of P2P modules in 11i environment.
• Implemented the purchasing module along with iProcurement to create purchase requisitions with approvals and turning them into purchase orders.
• Implemented complete setup for purchasing/buyers/standard and blanket PO's.
• Configured accounting Flexfield, account maintenance, calendars, currencies, ledger and legal entity setups, data access sets, document sequences, mass allocations, GL Profile options and transactions processing.
• Configured payable system and payables options, vendors and sites, bank and bank account for fund disbursements.
• Created mapping documents for supplier, supplier sites, items, open PO, AP invoices conversions.
• Created documents for month-end process to transfer transactions from various sub-ledgers and close/open accounting periods.
• Unit/integration test and review of deliverables ensuring knowledge building sessions at regular intervals for the team members.
• Participated in CRP and UAT, supporting the users to create business test scripts and help resolution and review of defects reported along with triaging the defects.
• Trained the new users on using buyer's work center, purchase requisitions, purchase orders, payment batches, and supplier setup.
• Coordinating with technical team on delivery and support for customization and developments.
• Provided production support for day to day business issues and Sev1 SRs with Oracle support team.

Confidential

Oracle Business Analyst / Oracle financial Functional Consultant

Environment: Oracle Applications 11i 11.5.10 GL, AP, AR, FA

• Involved in reviewing the current business model BP040 and had presentation of future business model BP80 during CRP phase.
• Presented demos of new features of R12 financials to key stakeholders during design workshops.
• Prepared application setups BR100 and applications extensions functional design documents MD50 .
• Configured the chart of accounts structure based on the current company's structure of the as-Is process of the business post CRP session with finance team IT team process champions.
• Involved in setup for AP, PO, GL based on deep understanding of the functional processes.
• 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.
• Created responsibilities, functional securities, user assignments and set the profile options in FND.
• Set up suppliers, locations, and purchasing quick codes in AP.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Defined profile options to specify certain implementation parameters.
• Configured user management using FND to setup users and assign responsibilities and set profile options.
• Testing of all functionalities like creation of journals, posting the journals, reversing the journals, creation of asset, and depreciation calculations etc in the testing environment.
• Trained business users and troubleshooting during user acceptance Test UAT .
• Prepared end user training material with specific business cases and conducted end-user training.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities.
• Worked with the system administrator and DBA to resolve issues like concurrent manager queues, conflict etc..
• Prepared system integration test scripts TE.040 for UAT sessions and training documents with screenshots for end users.
• Participated in testing, user accepting testing in test instance and worked with certain key super users.

Confidential

Oracle Financials Consultant

Environment: Oracle Applications 11i 11.5.10 GL, AP, AR, PO

• Reviewed and analysed the business requirements and functional specification documents.
• Setups meeting with business analysts and developers to clarify the design, flow and functionality of application.
• Involved in requirement gathering and analysis and design of the application.
• Worked with the client team to understand the current business process.
• Involved in implementation and testing of Oracle Applications financial applications.
• Setting up AP for PO matching and non-matching supplier invoices, payment profiles for check and wire, sub ledger accounting of payables transactions.
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Defined GL budgets and budget organization.
• Defined the approval limit for new employees.
• Modified PO requisition workflow, AR notification workflow as per business requirement.
• Developed test plans and scripts and conducted testing for quality assurance.
• Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances.
• Developed the customer invoice, statements and dunning letters.
• Supported and modified existing purchasing and receiving interfaces in PO and AutoInvoice in AR.
• Designed AutoInvoice import process and documented the import process in AR.
• Setting up and customizing dunning letter, statement cycle in AR.
• Corrected customer profile class setup statement to avoid multilingual statement printing.
• Configured and scheduled standard request submission for standard APIs wherever required.
• Configured the setups for prepayment to employees and defined employee expense report.
• Involved in the post production support activities for GL, AP and AR.

ORACLE E-BUSINESS SUITE SKILL SET:

Release

Release: 11i 11.5.3 11.5.10 and R 12 .0.6

Applications

• Financials FIN: Accounts Payables AP, Accounts Receivables AR, Cash Management CE, Fixed Assets FA, Project Accounting PA Project Costing PJC, Project billing PJB, General Ledger GL, SLA and EBTax.
• Human Resources Management Systems HRMS : Oracle Time and Labour OTL .
• Self Service Web Applications SSWB: iExpenses, iSupplier, iProcurement and iReceivables.
• System Administration SysAdmin: Application Object Library AOL/FND, System Administration SYSADMIN/FND and Oracle Alerts ALR .
• Architecture: Multi-Org MO, Flex fields KFF DFF and Trading Community Architecture TCA .

Tools:

• Oracle Databases: Oracle SQL PL/SQL 9i, 10G and 11G.
• Oracle Tools: Oracle Developer Forms Reports 6i, 9i and 10G, Oracle Discoverer 4i, 10G and 11G and Oracle BI/XML Publisher.
• Oracle Methodologies: Applications Implementation Methodology AIM and custom client-specific methodologies.
• Operating Systems/Platforms: Windows, AIX, UNIX, Linux and Sun Solaris.

Other Products: SQL Navigator, Toad, Vertex, Sabrix and Data Load.