SUMMARY

• Overall 3 years of total work experience in Functional Consulting experience in experience in Oracle E business suite i.e Extensive Upgrade Experience in Finance Modules (AP, GL, FA and CE).
• Handling Month - end close activities and reconciliation for GL, AP, PO and FA modules.
• Resolving Finance issues that occurred during production and provide Month end support to teh above financial modules along with delivering teh reports of teh close.
• Loaded, imported and auto-reconciled teh bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Conducted CRP1, CRP2 and tested teh customized components.
• Configured teh Sub Ledger Accounting (SLA) setups.
• Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.
• Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Created teh MD50 documents for each RICE components
• Procurement Setups,Types of PO,Buyer Work center, Approved Suppliers List, Sourcing Rules.

TECHNICAL SKILLS

Oracle Applications: R12 (12.0.3, 12.0.5, 12.0.6, 12.1.1 and 12.1.3) GL, AP, AR, FA, CEEB-Tax, i Expenses 11i (11.5.8, 11.5.9, 11.5.10

Languages and Tools: PL/SQL, Discoverer Viewer, Web ADI, SQL Loader, Data Loader

PROFESSIONAL EXPERIENCE

Oracle Financials Consultant

Confidential, NY

Responsibilities:

• Resolved teh issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, and customer statement report.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Worked with technical team regarding RICE components.
• Created work around for unsolved issues.
• Supported Post-Implementation phase for all Oracle Financials Modules.
• Worked with Oracle Support to resolve teh critical issues through SR/TAR.
• Customization of Promise Date of Sales Order form after creation of Depot Repair Service Request.
• Procedure is used to call teh API OE ORDER PUB which updates Request Date, Promise Date and Schedule Ship Date of RMA line on Sales Order form as per teh business logic using CUSTOM.PLL
• Co-ordinate between Onsite and Offshore teams for Effective Delivery
• Completely responsible for all development OM, Service Contracts, Install Base, AR, OM, AP, i-Expense and INV modules.
• Performed teh expense report data conversion into i-Expense from a legacy system.
• Worked on i-Expense customizing teh functionality for expense approval
• Customization of Reports of various modules like Receivables (AR), Inventory (INV), and Order Management (OM) modules.
• Designed and developed teh Auto Lockbox interface program to import receipts from 3 banks. Developed teh import program and used SQL Loader to load data into teh AR PAYMENTS INTERFACE ALL table.
• Escalate and derive teh logical conclusion, of all technical issues, that may impact teh project schedule.
• Post Production support after GO-live.
• Create TARS and follow-ups with Oracle for product related issues
• Worked on Development using custom PL/SQL Package for Suppliers Data Extract File.
• Production Support for purchasing issues involving Workflow enhancements (sourced from stock).
• Designing, implementing and supporting business processes in an Oracle environment;
• Designing, building, testing and deploying various Oracle solutions;
• Identifying and addressing client needs by building relationships with clients, developing an awareness of Firm services, communicating with teh client in an organized and knowledgeable manner, delivering clear requests for information, demonstrating flexibility in prioritizing and completing tasks and communicating potential conflicts to a supervisor;
• Developed solutions in Fusion Cloud applications pertaining to Allocations, BPM Approval rules, Intercompany, Travel and Expenses.
• Lead design efforts to modify and add new functionality to Oracle Cloud ERP application, including designing functional specifications for RICE (Reports, Interfaces, Conversions, Extensions) items/
• Participate in business requirement sessions, perform gap analysis and provide level of effort estimates
• Work with business/ business analyst to understand teh functional requirements
• Create functional and technical specifications
• Perform unit testing and validate testing results meet requirements
• Partnered with finance, operations leaders, and users to evaluate and improve business processes and arrive at mutual, cost effective solutions
• Involved in technical discussions for migrating teh code and validated teh code by testing in Test and QA before moving teh PPM Packages to Production.
• Worked closely with offshore team for Testing and Development work.
• Coordinated teh effort for teh Monthly Releases (Release Management).
• Coordinated with teh team for teh Monthly Release Regression testing
• Worked on teh Root cause for teh incorrect accounting for Refunds (No accounted amount is being populated in ar distrubtions table for some refunds.)
• Worked closely with teh business on Quota Allocation, Claim Research, and Claim Settlement.
• Involved in data cleanup for teh year end closing (Remittance Account, Cash clearing Account, Prepayment Account, Revenue Account)
• Involved in technical discussions for migrating teh code and validated teh code by testing in Test and QA before moving teh PPM Packages to Production
• Worked on teh Root cause for teh incorrect accounting for Refunds (No accounted amount is being populated in AR distributions table for some refunds.
• Worked closely with Banks, Bank Accounts for internal purpose and Payment Formats for Manual Check and Electronic Fund Transfer (EFT) in single and multiple currencies.