We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

PROFESSIONAL SUMMARY:

  • Oracle Applications Techno Functional Consultant with 9+ years of experience in development, testing, and deployment of custom forms, reports, BI Publisher reports, workflows and developing interfaces using PL/SQL in Oracle EBusiness Suite Modules like Finance, OLM and CRM.
  • Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
  • Excellent Technical Development skills in developing RICE (Reports, Interfaces, Conversions and Extensions) Components in the domain of Oracle Applications E - Business Suite.
  • Good experience in gathering requirements from the end user, performing gap analysis, providing custom solutions and managing the deployment.
  • Hands-on experience with Oracle Forms, Reports, BI Publisher reports, SQL, PL/SQL, Interfaces, Workflows and APIs.
  • Proven background developing packages, procedures and inbound/outbound interfaces.
  • Working knowledge on Informatica.
  • Worked on various Oracle Apps modules like AP, AR, GL, PO, FA, OLM, OM and CRM
  • Adept at P2P Cycle and Working knowledge of O2C Cycle.
  • Worked both on R11.5.10 and R12.1.3 versions of EBusiness Suite and worked on the upgrade of the same as well.
  • Good experience in leading team, guidance, reporting to senior level people, timely status reports and delivery management.
  • Excellent Communication, Inter-personal skills, work ethic and drive
  • Good hands on experience in AGILE methodology.
  • Extensive experience working at Oracle SSI, Confidential and Confidential .

TECHNICAL SKILLS:

Technology: Oracle Forms 10g, Oracle Reports 6i, Oracle Workflows, BI Publisher, Oracle Application Framework

Tools: Jdeveloper 10g, SQL Developer, JDK, Oracle Workflow Builder, Informatica

Languages: SQL, PL/SQL, Java, XML

Operating System: Microsoft Windows 98, 2000 and XP

Product: Oracle Lease Management, Financials, CRM and Project Accounting modules in EBS 11.5.10 and EBS12.1.3

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps TechniCAL Consultant

Modules: Oracle Financials (AP, AR, GL, PO, FA,OM,iExpense)

  • Involved in requirement gathering sessions with the clients to discuss on the needs and to determine the feasibility in the system
  • Involved in technical discussions with the team to decide if custom solutioning is required
  • Hands on experience with developing forms, reports, BI publisher reports, and PL SQL packages to address the requirements
  • Worked on setting up the system in cases of no customizations.
  • Worked with the system testing team to develop unit test cases and system test cases
  • Worked on implementing the solutions into the live production environment
  • Worked on AR Invoices conversions during acquisitions.
  • Worked on setting up WIRE payments for payables processing which involved interactions with multiple parties to set up the system. Payments setup was done both within the country and outside the United States sometimes using intermediary banks as well.
  • Hands on experience developing reports for the tax department to help them determine the USE tax that they have paid. The report helped the Tax department by showing the exact amount of tax that was paid on each payables invoice.
  • Worked on bringing payments from the JD Edwards ERP to oracle AR to integrate collections. Worthington’s Cylinder Industries was on JD Edwards ERP and the business wanted to use Oracle’s Collection module to help with scoring and receiving payments from the customer. I was one of the key resources to help move the payments into Oracle AR using standard Oracle APIs which helped the Cylinders Business Unit to analyze their data effectively in Oracle.
  • Developed FA reports to determine the tax to be paid on all the fixed asset goods at year end.
  • Provided solutions for payments automation and MOAC to speed up the payment processing.
  • Worked with Informatica to map the fields and modify the file sent to Confidential
  • Provided solutions to help the users to pay state taxes through oracle, which was primarily setup at an external portal
  • Worked on a Raw Material to Finished Goods report which also showed the shipment quantity for the past 90 days and the forecast quantity for next 90 days by integrating with Demantra.
  • Worked on a 360-degree solution for debit memo automation
  • Worked on a PO uninvoiced receipt report which helped the purchasing team to find all the POs with uninvoiced quantity and uninvoiced dollars
  • Involved in discussions around retroactive pricing for blanket PO.
  • Worked in migration of Cognos reports
  • Worked on an iExpense Accrual Report which was pulling credit card transaction details of various employees and bursting out the report to different levels of managers in the organization

Environment: Oracle applications R12 Implementation (AP, AR, GL, PO, OM, iExpense, PL/SQL, Reports, Interfaces, Forms)

Confidential

Oracle Apps Technical Consultant

Modules: Oracle Financials, Oracle Lease Management

  • Involved in customizations of Oracle Applications for De Lage Landen in Oracle Financials and Oracle Lease Management Module.
  • Developed outbound interfaces, forms, PL/SQL and BI Publisher reports in these modules.
  • Worked on custom PLL file
  • Worked as a mentor to the junior members of the team overlooking their assignments as well.
  • Unit and Integration Testing
  • User Trainings

Environment: Oracle applications R11i (OLM, AP, PL/SQL, Reports, Interfaces, BI Publisher)

Confidential

Modules: Oracle Financials

  • Involved in Bedrock project of Cisco which involved upgrade to R12.1.3
  • Also involved in customizations in AP, AR, GL modules
  • Was also part of the data merging team and was involved in automation of few SOX controls
  • Worked as a mentor to the junior members of the team overlooking their assignments as well.
  • Unit and Integration Testing

Environment: Oracle applications R12.1.3 (AP, AR, GL, PL/SQL, Reports, Interfaces, Forms, SOX)

Oracle Apps Technical Consultant

Confidential

Modules: Oracle Financials & SCM

  • A company in Ireland which creates and orchestrates global supply chain networks that design, build and deliver electronic products for its customers
  • Was involved in the R12 upgrade of Forms and reports
  • Orchestrated the upgrade to R12.1.3 from R11.
  • Also worked on the setups needed to migrate to R12.1.3

Environment: Oracle applications R12.1.3 (AP, AR, GL, PL/SQL, Reports, Forms)

Confidential

Modules: Oracle financials

  • Part of the expert services group on site in Chennai
  • Performed improvement initiatives on the existing solutions
  • Worked on few performance fixes and customizations
  • Involved in the estimations of CRs, communication with the client and weekly status updates
  • Unit and Integration testing.

Environment: Oracle applications R11.5.10 (AP, GL, PL/SQL, Reports, Interfaces, Forms)

Confidential

Modules: Oracle financials and Retail Merchandising system

  • Fourth largest retain giant in the UK
  • Worked on the customizations in the Finance and RMS modules
  • Worked on PL/SQL, forms and workflows
  • Customized the AR approval workflow to modify the approval hierarchy
  • Involved in registration/migration of concurrent programs, executables, Creation of Responsibilities, request groups, sets, menus, values sets, document sets, request sets, forms, Functions and printer types, printer styles in System Administration & AOL.
  • Worked on customizing the PO Approval Workflow.

Environment: Oracle applications R12.1.3 (AP, PO, GL, PL/SQL, Reports, Interfaces, Forms, Workflows)

Confidential

Modules: Oracle CRM OKC modules

  • Foreign ministry of Netherlands with over 1000 CEMLIs developed
  • Involved in the support of these CEMLIs
  • Was also involved in customizations in CRM OKC modules, BHC module and OSB module mainly on workflows
  • Worked on the custom PLL file
  • Worked on forms personalizations

Environment: Oracle applications R11.5.10 (CRM, PL/SQL, Reports, Interfaces, Forms, Workflows)

Confidential

Modules: Oracle HRMS, Finance and iRecruitment

  • Government Organization in the UK dealing with the provision of loans to students
  • Was the single point of contact and hence was involved in estimations, client updates and communications
  • Was also involved in change requests and bug fixes in HRMS, iRecruitment and Finance modules

Environment: Oracle applications R11.5.10 (HRMS, AP, iRecruitment, PL/SQL, forms and workflows)

Confidential

Modules: APM module

  • Private firm which has incorporated the Advanced production management module in Oracle for the manufacturing of potato chips
  • Involved in the installation and support of the APM module
  • Was also involved in the customization and support of CEMLIs across 5 countries of Confidential namely Russia, Spain, Portugal, Poland and Greece.

Environment: Oracle applications R11.5.10 (APM, PL/SQL, Reports, Forms)

Hire Now