PROFESSIONAL SUMMARY

Over * years of industry experience as Oracle Financials Functional Consultant in Accounts Payable, Accounts Receivable, Projects, Cash Management, General Ledger and Fixed Assets.

Extensive Oracle Financials experience in Implementations, roll-outs, system upgrades, integrations, process re-engineering, requirements gathering, design, fit and gap analysis, system setups, interfaces, extensions, training & support.

Successfully implemented complete (end-to-end) life cycle projects in Oracle Financials solutions designing and rollout to different geographical regions - GL, AR, AP, CE, FA, PO and OM.

Participated in multiple Oracle apps 11i and R12 implementations in multi org/multi-currency scenarios, Order management and worked on Pricing, Purchasing, and Inventory.

Experience in all phases of the system development/implementation life cycle.

Experience in using Oracle AIM of project implementation methodologies particularly Gather Business Requirements (BR.100), Functional Documents (MD.50), Data mapping conversions( CV 040) deliverables and Test Cases (TE.40) for GL, AP, AR, FA and CE modules

As an Oracle Apps Implementation specialist, excellent experience with Sub-Ledger Accounting(SLA), E-Business Tax, AGIS, UPK, MOAC, Payments, FSG, PA and TCA

Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation (including BRD and BR100s) for financial modules AR and AP.

Good experience customizing and personalizing approvals using Oracle Approval Management (AME)

Have good knowledge on I modules like iProcurement and iExpense.

Excellent support experience on period closing process and troubleshooting for AP,AR, Inventory and Purchasing (Sub-ledger reconciliations with GL)

Worked on Upgrade Projects from 11.5.10 to 12.1.3 and 12.1.3 to 12.2.4

Worked and contributed in data conversion, data Interfaces, reporting requirements.

Self-Motivated; able to work independently and in teams; handle multiple projects paying attention to details; accomplished problem solving, leadership & analytical skills.

Education

Bachelors in Computer Science from JNTU, India.

SKILLS:

Oracle E-Business Suite 11i & R12: Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Cash Management(CE), Fixed Assets (FA), Advanced Collections, Inventory (INV), Purchasing (PO), iProcurement, Order Management (OM), Purchase Order (PO), Time & Labor, Sub-ledger Accounting (SLA), HRMS, Project Accounting (PA), E-Business Tax, Multi Org Access Control (MOAC), Web ADI, TCA, AME, AGIS, ITIL.

Management/Leadership Skills: Finance Functional Consultant & Business Analyst

PROJECT EXPERIENCE

Vantiv, Cincinnati, OH Jan’15 to Till Date

Finance Functional Analyst

Environment: Oracle Applications upgrading & Support on R12.2.4

Modules Involved:

Financials: Procure to Pay (P2P), iProcurement, General Ledger, AME, AGIS, PO, Web ADI.

Responsibilities:

Planned and executed the full cycle: requirement definition, gap analysis, solution design, UAT, user training, using AIM methodology for Oracle iProcurement and Purchase modules.

Worked extensively on AP, PO, iProcurement and iExpenses modules. Played key role in developing Invoice Approval workflows in PO.

Conducted customer-focused user training course for Purchasing, iProcurement, Sourcing, iSupplier and PO modules.

Application Enhancement and Support for finance modules like AP, AR, PO.

Good experience in FSG’s and Web ADI and standard reports.

Testing the new functionality, identifying and resolving the issues in AP, AR, PO, CM, GL, Advanced Pricing modules

Troubleshooting the Production issues on Accounts Payable, Accounts Receivable, and General Ledger and Purchase.

Defined Tax features such as Codes, Rates, Exceptions and Exemptions. Customize FSG’s (Financial Statement Generator), Web ADI reporting.

Performed application support in single and multi-Org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP), iExpense and iProcurement modules).

Worked on customizing iProcurement Requisition and Receiving pages.

Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page.

Imported items to iProcurement using Catalog Extract and Bulk Load Requests.

Developed business procedures and supported application configurations.

Worked on iProcurement production fixes, raised and resolved many oracle service request issues.

Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules

Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing.

Designed the Test Scripts and Test Scenarios for iProcurement and iSupplier Portal.

Worked on iExpense creating reports, sending reports to AP, converting reports to invoices.

Set up iProcurement, Train, Troubleshoot and debug iProcurement Modules. Load Items, Set-up and Maintain Punch-out Sites.

Participated in gap analysis and executed application mappings.

Working with Users on gathering requirements through Sharepoint SD Tickets and assist technical in development.

Defining the Purchasing, Receiving and Financials Options as part of the setup

Worked on Multi Currency conversion setup in Purchasing and Order Management Applications

Enabling descriptive Flexfields and key Flexfield segments on some forms in Oracle Purchasing Application.

Experience in design of RICE (Reports, Interfaces, Customizations and Extensions) objects to as per the custom business process within Oracle implementation.

Requirement definition, gap analysis, solution design, UAT, user training, using AIM methodology.

Customizing and personalizing approvals using Oracle Approval Management (AME)

Provide solution for complex issues like pay groups and Operating Units through SLA.

Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle

Prepared MD 050, RD020, BR100, TE040 (Test Scripts) and End User Training Manuals.

Extensively worked and resolved the issues on Work Flows (AP, Requisition, Purchase Order, RMA Order, Standard Sales Order, Internal Sales Order, Drop Ship Order)

Worked on the different Purchase Order setups, generated the invoices, and resolved the pending transactions

Configured the setup for AGIS (Advance Global Inter-company Systems) and transit the entries at sub-ledger (AR & AP) and GL level.

Testing of Web ADI which had custom validations built to take care of rules based FAH controls

Tested end to end upload of GL Journals using Web ADI and staging them onto FAH and then running Request Set to populate data along with approval controls built around it.

Performed CRP & UAT for Financials modules, which includes AGIS, Advanced Collections, Accounts Receivable and GL.

Developed stored procedures, functions and packages in augmenting the business using PL/SQL. Involved in transferring the reports from one instance to another instance

Involved in the development of new reports and Customization of reports.

Mitsubishi, OH Jun’14 to Nov’14

Oracle Financial Functional Consultant

Environment: Oracle Applications Upgrade to R12.1.3

Modules Involved:

Financials Account Payables, Account Receivables, Cash Management, Project Accounting, SLA

SCM Order Management, Purchasing, Payables, BOM, Inventory

MFG Flow Manufacturing

HCM HRMS, OTL, AME

Responsibilities:

Involved in setup of Project Management, Project Accounting and Project Manufacturing module.

Successfully Implemented Oracle SCM, MFG, FIN, HCM modules in R12.1.3, which have Order-to-Cash (O2C), Procure-to-Pay (P2P) cycles

Worked on SLA (Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.

Setting up the Project and collecting the cost against Project Task through various sources like OTL, PO, and Inventory.

Supported Project Accounting-Project Costing, Project Billing, GL, AP & AR modules.

Defined Project related setup options, Project calendar, Project Period and identified Project types, Project Templates, Task related setup and Project related workflow and profiles.

Worked as a Business Analysts in gathering functional requirements (MD50) and helped in creating technical documentation(MD70)

Designed customizations, fit gap analysis, interface/conversion mapping, pre production testing, and related documentation and deliverables

Providing functional support in various Oracle EBS modules like Order Management, Inventory, Accounts Receivables, Accounts Payables, Quality, Purchasing, Flow Manufacturing

Troubleshooting the order management, invoices, intercompany, WIP transactions etc.

Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO

Creating Inter-org transfer setups for Inventory application in Oracle R12

Part of Requirement Handoff call from Client for collecting and reviewing Functional Specifications (MD50)

Assist technical team to develop RICE Components such as Reports, Interfaces using Oracle PL-SQL, SQL.

Worked on Payment Process, EFT transaction customizations, Banking setups etc.

Extensively worked on Spreadsheet upload, Multi Item Extract form tools to create / update / delete the SKU for various Inventory Organizations.

Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules.

Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules.

Worked on setting up AME rules for iProcurement transaction approval.

Defining Data Groups, Menus and Report Security Groups. Defining Responsibilities, attaching Menu and assigning it to end-users.

Developed new SQL reports, customized and optimized existing ones in Accounts payables

Review Functional Specifications (MD50) to identify Gaps before team starts Technical Designs (MD70).

Track Daily status and attend Daily status call to provide updates, along with functional lead.

Wyndham, NJ Oct’13 to May’14

Techno Functional Consultant

Environment: Oracle Applications R12.2

Modules: Procure to Pay (P2P), Order to Cash (O2C), GL, AP, AR, FA, PO, CM, Trading Community Architecture (TCA/HZ), Multi Org (MOAC), FSG, OAF & Projects Accounting, HRMS, OTL.

Responsibilities:

Worked as techno functional consultant for the implementation of Projects Accounting (PA) module (Project Costing/Project Billing).

Responsible for Projects requirements gathering, fit and gap analysis, functional design, Projects application configuration and development of Work Breakdown Structure, system integration and user acceptance testing, user training and production support.

Worked on implementation setup processes of Oracle E-business HRMS applications -HR, iRecruitment, SSHR, OLM, Payroll, OTL and OAB.

Conducted CRPs and interacted with business managers to gather requirements and understand the business process in the company around the modules.

Prepared Functional Design Document by studying existing business process

Prepared the documents like RD50s (Requirement Gathering), Business Process flows (BP), BR100s (Application Configuration), MD50s (Functional Design), and TE40(Test Scripts)

Configured GL, AR, AP, FA,PO, Costing and cash management applications

Prepared Data mapping sheets for Supplier, Customer, AP invoices, AR Invoices, Open Orders, and GL Balances Conversions

Worked on Grants accounting. (Multi funded projects & Award management, Budgetary control, Burdening)

Integrated projects with many other modules like Account Receivables (AR), Account Payable (AP), Purchasing (PO), Order Management (OM) and General Ledger (GL).

Developed Customer Data Import program for data loading from different systems to Oracle TCA tables.

Development of customer interface using Oracle standard TCA APIs including DQM rules

Worked on Report manager to configure report templates

Working on Report requirement analysis and testing of reports

Worked on consolidations.

Worked on Financial Statement Generator reports and templates to publish in excel.

Working on Post production support

Components designed and tested include: (i) Customer conversion into TCA; (ii) Invoice conversion into AR; (iii) Install Base instance conversion into IB; (iv) Service Request and Task conversion into CS; (v) interfaces to and from IB; (vi) customization to auto-generate service requests; and (vii) various reports.

West Corp, NE Feb’13 to Oct’13

Oracle Business Analyst

Environnent: Oracle Applications R12.1.3

Modules : GL, AP, iProcurement, AR, CE

Responsibilities:

Involved in the Up-gradation of the Application for all financial modules like GL, AP, AR, CE, Purchasing and the Self-Service Modules like iExpenses, iSupplier.

Prepared and updated CV40, BR100 documents and created MD 50 Functional Design documents according to AIM.

Designed and created new CHART OF ACCOUNTS and set of books.

Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.

COA Restructuring for newly acquired sister concerned company. (COA redesign)

Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.

Implemented EB-tax integration for Procure to Pay and Order to Cash cycles with One-Source Indirect Tax product line.

Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.

Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,

Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.

Created users and modified the privileges for users, rollup group and summary accounts.

Created suspense accounts for automatic balancing journal entries from particular sources and categories.

Set-up supplier and supplier sites for suppliers in payables.

Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close.

Involved in setting up Project resources and roles to the project, Jobs and organizations for project Organizations, creating and maintaining Project budgets and worked on PA costing Import Process as part of project costing and billing.

Conducted orientation training, CRP, UAT and Rollouts strategies for System up gradation.

Worked on Unit/Functional Test of iProcurement Requisition and Receiving pages while developing the customized pages. The pages involving functional test would be creating iProcurement Requisitions based on different test scripts scenarios.

Provided production support for day to day business issues and worked on SRs with Oracle.

Neste Oil, TX May’11 to Jan’13

Oracle Business Analyst

Environnent: Oracle Applications upgrade 11.5.10 to R12.1.3

Modules: GL, AP, AR, CE, FA, EB Tax, AGIS & Advanced Collections, ITIL.

Responsibilities:

Coordinate with onsite to collect requirement

Coordinating with client on daily basis for project Deliverables

Working on JIRA tickets for financial modules

Worked on documents (BP080, MD050, and TE-40 & BR-100).

Involved in customers & open Invoice and receipt conversions for different rollouts

Supporting multiple R12 EBS application, monitor, analyze, resolve support tickets, provide weekly Status report

Involved in customer and invoice migrations from 11i to R12

Prepare estimates, release plan and road map for future releases and participate in cut over activities

during every roll out.

Involved in custom payment formats.

Working on Report requirement analysis and testing of reports

Natus Medical Inc., CA Jun’10 to Apr’11

Oracle Financial Functional Consultant

Environnent: Oracle Apps. R12.1.3

Modules: GL, AP, AR, FA, AGIS and CE

Responsibilities:

Involved in testing all the financial processes in Upgrade test instance and conducted CRP-Conference Room Pilots.

Preparing the training manuals by using UPK

Publishing FSG reports by using Report Manager

Involved in testing of financial (GL, AP, AR, FA and CE)

Implemented advanced features Balance forward billing, Cash pool and multi period accounting

Worked on AGIS requirements gathering, configurations and testing

Involved new customization based on the new requirements especially asset transfer across books

Mapping 11i process to new R12 features

Ansell Health Care Limited, NJ Mar’09 to May’10

Business Analyst

Environnent: Oracle Apps. R 12.1.3

Modules: GL, AP, AR, CE and FA

Responsibilities:

Worked on Documents (RD-50, BP-80, TE-40, MD-50 and BR-100) and was responsible for configuring the application’s module under strict Revision Control based upon the various discussions, and the CRP’S.

Participated in requirement gathering and made setup for all financial modules

Prepared the Technical Architecture document (TA040)

Facilitating the testing of the solution (designed as a part of To Be) by users in Conference Room Piloting

Gathered the requirement for the report development

Coordinating with client on daily basis for project Deliverables

Participate in Weekly Status Review Meetings with IT Team

Worked on consolidations

Developed FSG reports and templates to publish in excel

Facilitating super-user training and developing the various user manuals

Canon Business Solutions, NJ Jan’08 to Feb’09

Oracle Analyst

Environnent: Oracle Applications Upgrade 11.5.7 to 11.5.10.2

Modules: GL, AR, AP, FA and CE

Responsibilities:

Worked with R12 implementation team, gathering requirements and authoring business requirement documents and functional specifications.

Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes, etc.,

Worked on setting up of accounting method builder (AMB) for Financial accounting hub for various pass through Journal applications.

Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.

Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.

Supported Procure to pay and FA issues during month end performing additional configurations.

Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.

STRYKER CORPORATION, NJ Feb’07 to Dec’07

Business Analyst

Environnent: Oracle Applications 11i

Modules: GL, AR, AP, FA and CE

Responsibilities:

Requirements Gathering, Data Migration, Extensive work on RICE, CEMLI components that include Reports (RDF and XML Publisher), Conversions, Interfaces, Customizations, Data Mapping, Technical Design, Code/Script Development, issues resolution, Performance Tuning, Documentation(AIM).

Analyzing the requirements.

Prepare MD 70 for the SRS.

Define and set up DFF's using Application Developer responsibility for Purchase Order Header to identify Contract Retention Invoices.

Created and customized reports using XML Publisher/BI Publisher in AP, PO, OM, AR and INV like Item use up date Report, General Inventory Report, Po Distribution Report, Expected Receipt Report, Product Transaction Listing Report, Invoice on hand Report.

Contact this candidate