We provide IT Staff Augmentation Services!

Senior Oracle Ebs Developer Resume

TX

SUMMARY:

  • Over 11 years of proven IT experience and around 10 years in Design, Development, and implementation of software Applications using Oracle Applications R12/11i spreading across Implementations, Data conversions and customizations.
  • Extensive Technical experience in Oracle applications modules GL, AR, AP, FA, PO, OM, Inventory, ASCP and Demantra .
  • Extensive hands on experience in development and support of Logility Voyager application.
  • Experience in performing Data interfaces/Conversions in Oracle Financials.
  • Good understanding and implementation experience of Oracle order to cash, procure to pay and Value chain planning life cycles.
  • Worked on Demand Management ( DM ) and Real - time Sales and Operations Planning for implementation of Demantra and supported Demand, Inventory and Replenishment Planning using Logility.
  • Extensively worked in Oracle back-end programming along Front-end development using PL/SQL and tools like SQL*plus, Oracle Forms 6i, Oracle reports 6i.
  • Developed forms using TEMPLATE.fmb, CUSTOM.pll in accordance to Oracle Applications coding standards.
  • Knowedge and Experience working in SaaS in HCM of Oracle EBS Cloud service.
  • Hands on Experience in Application core technologies (system administrator, Application developer, concurrent processing, Reporting).
  • Strong programming experience in creating procedures, packages, functions, triggers and other database objects using SQL and PL/SQL along with XML.
  • Excellent analytical, inter-personal and communications skills and ability to work in a fast-paced and team-oriented environment.
  • Self motivated and successful in promoting effective working relationships.

TECHNICAL SKILLS:

ERP: Oracle Applications R12 (12,2,7,12.2.5,12.2.4,12.1.3), 11i (11.5.10.2, 11.5.10) General Ledger (GL), Receivables (AR), Payables (AP), Fixed Assets (FA)Inventory (INV), Purchasing (PO), Order Management (OM), Shipping (WSH), Project Accounting (PA), HRMS, ASCP, Demantra.

Tools: SQL*PLUS, SQL*LOADER, XML Publisher, Form Builder 6i, Report Builder 6i, Workflow, Toad, ITG, ESP, Autosys, Logility Voyager 7.0/7.6/8.3.

Databases: Oracle 9i/ 10g/11g, MY SQL, MS SQL Server 2000

Languages: SQL, PL/SQL, JAVA, HTML, XML, Perl.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle EBS Developer

Responsibilities:

  • Design, development and customization of RICE components.
  • Migration of vendor data from bill.com legacy system to Oracle EBS R12.1.3 in AP.
  • Development of supplier interface in AP so that new suppliers and sites gets imported from Legacy into EBS.
  • Migration of new assets to Oracle in Fixed assets FA .
  • Worked on Form Personalization to restrict Asset books based on responsibility in FA.
  • Worked on upgrade project rom R12.1.3 to R12.2.7
  • Worked on Payables open interface for creating pre-note invoices a part of Broker channel project in AP .
  • Worked on changes to NACHA format for Bank of America to process supplier payments in AP .

Environment: Oracle Database 11g, Oracle EBS R 12.1.3/12.2.7 , AP, PO, GL, FA, CM, OM, AR, Reports 10g, Forms 10g, SQL, PL/SQL.

Confidential

Oracle Apps Techno functional consultant

Responsibilities:

  • Design, development and customization of RICE components.
  • Part of upgrade for iprocurement from R12.1.3 to R12.2.5.
  • Handled all the Go live issues related to approval process in iprocurement and handled customizations required.
  • Dealt with Billing issues to ensure that Billing users access related issues are addressed on time.
  • Support day to day errors related to OM that is interfaced to third party external system HVOP.
  • Worked on customization of Oracle standard reports.
  • Handled SR’s related to iprocurement upgrade.
  • Handled user tickets related to AR.
  • Worked on setting up scheduled programs using ESP and developed shell script programs to enable automation.

Environment: Oracle Database 11g,Oracle EBS R12.2.5, AP, PO, OM, AR, Reports 10g, Forms 10g, Finance, SCM, SQL, PL/SQL.

Confidential

Oracle EBS Project Head

Responsibilities:

  • Design, development and customization of RICE components.
  • Managing the Oracle development team along with subcontractor for development activities.
  • Handle all Database admin related activities and ensure that Oracle Database is up and running.
  • Review design and participate in design review meetings for any of applications directly and indirectly linked to Oracle EBS.
  • Handle all contract related communications for Oracle related activities.
  • Guide development team with programming challenges related to Oracle plsql.
  • Act as single point of contact for any of Oracle related concerns.
  • Worked on GST Implementation as part of new tax regime proposed in India.
  • Worked on mobile application which integrated to Oracle and responsible for development and modifications needed to create invoices in Oracle AR.
  • Worked on form customization related to order entry process in Oracle OM.
  • Worked on Advance Pricing and customized such that older stock takes older price irrespective of the current active pricelist defined in the system.
  • Help the team with requirement gathering for Oracle reports and delivery of Report modifications/customizations.
  • Review the design and propose changes to any of Applications that are interfaced with Oracle (Incentives solution).
  • Handling Oracle Cloud related activities along with maintenance of Cloud SAAS and PAAS.
  • Conduct Team meetings and review work of team of (8 members) on daily basis.
  • Act as Architect to review the proposed design and be the owner for any of Oracle related implementations.
  • Take care of all Database management activities and responsible for approval of user maintenance and creation
  • Activities.
  • Manage Database administration team which includes activities like patching, cloning, etc.
  • Look after recruiting and interviewing for IT related Oracle roles.

Environment: Oracle Database 11g,Oracle EBS R12.2.4,OBIEE,Reports 10g, Finance, SCM, OPM, SQL, PL/SQL, Forms 10g.

Confidential, TX

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Prepare Technical and Functional specification documents as per Business per requirement.
  • Setting up Demantra data model and perform set ups.
  • Technical work related to collection of data and download to Demantra staging tables.

Environment: Oracle Database 11g, Oracle EBS R12, Demantra 12.2.3, SQL, PL/SQL, Forms 10g.

Hire Now