We provide IT Staff Augmentation Services!

Oracle Developer Resume

2.00/5 (Submit Your Rating)

NY

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 the above financial modules along with delivering the reports of the close.
  • Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
  • Conducted CRP1, CRP2 and tested the customized components.
  • Configured the 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 the 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 and

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

WORK EXPERIENCE:

Oracle Developer

Confidential, NY

Responsibilities:

  • Resolved the 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 the 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 the API OE ORDER PUB which updates Request Date, Promise Date and Schedule Ship Date of RMA line on Sales Order form as per the 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 the expense report data conversion into i-Expense from a legacy system.
  • Worked on i-Expense customizing the functionality for expense approval
  • Customization of Reports of various modules like Receivables (AR), Inventory (INV), and Order Management (OM) modules.
  • Designed and developed the Auto Lockbox interface program to import receipts from 3 banks. Developed the import program and used SQL Loader to load data into the AR PAYMENTS INTERFACE ALL table.
  • Escalate and derive the logical conclusion, of all technical issues, that may impact the 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 the 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 the 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 the code and validated the code by testing in Test and QA before moving the PPM Packages to Production.
  • Worked closely with offshore team for Testing and Development work.
  • Coordinated the effort for the Monthly Releases (Release Management).
  • Coordinated with the team for the Monthly Release Regression testing
  • Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in ar distrubtions table for some refunds.)
  • Worked closely with the business on Quota Allocation, Claim Research, and Claim Settlement.
  • Involved in data cleanup for the year end closing (Remittance Account, Cash clearing Account, Prepayment Account, Revenue Account)
  • Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production
  • Worked on the Root cause for the 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.

We'd love your feedback!