We provide IT Staff Augmentation Services!

Oracle Applications Team Lead Resume

SUMMARY:

  • Confidential has more than fifteen years of IT experience in software, manufacturing, pharma, chemical & media industries which includes nearly twelve years of experience in Oracle Applications 10.7/11.0.3/11 i & R12.
  • This includes extensive experience as Sr.Techno - Functional consultant/Tech Lead in Oracle Apps (OPM, BOM, WIP, INV, PO, OM, AR, AP, GL, EDI, TM, IEX,ICOMP,i-Store,i-Expenses and Workflow) using AIM methodologies, Interfaces, Business Intelligence, XML Publisher, EDI’s,DBI and Oracle Applications Framework.
  • Also worked on the technical areas of Oracle CRM Service Requests (CS), Install Base (CSI/CSE), Service Contracts / Contracts Core (OKS/OKC).
  • He has been involved in varied roles during implementation, development, and support projects as Techno-functional consultant/Team Lead in various Oracle Apps modules.
  • Further he is conversant at managing these projects using the AIM methodology standards.
  • His experience includes also in Account translators in GL, Forms customizations, Form Personalization and data conversion using open interfaces for commercial applications as well, Oracle Discoverer 10g, XML Publisher, Oracle applications Framework and have worked on some challenging Oracle Apps (Mfg, Fin, OPM & EDI) 10.7/11.0/11 i /R12 projects.

TECHNICAL SKILLS:

Hardware: Sun Sparc RS6000, Compaq Prosigina 300, Compaq, Proliant 800, Intel Pentium, IBM Compatibilities

ERP Applications: Oracle Apps (OPM,MFG & FIN) Ver. 10.7/11.03/11 i/R12 (INV,OM,PO,BOM,WIP,AR,AP,GL,TM,ALERTS,WF,OPM,IEXi-procurement), EDI, Siebel 99 Ver5.5 & Siebel 2000 Ver 6.0

Operating Systems: Sun Solaris, UNIX, SCO Open Server Enterprise, Windows 98/2K/NT/XP

Databases: Oracle 7.x/8i/9i/10g/11g,SQL Server 7.0

GUI: Forms 3.0/4.5,Reports 2.0/2.5,Developer 6i (Forms 9i & Reports 9i), Discoverer Reports 4i/10g, XML Publisher, Daily Business Intelligence, Oracle applications Framework-Developer.

Languages: SQL, PL/SQL, C, C++, Java

Tools: Oracle Data Warehouse Builder (ETL)

PROFESSIONAL ORACLE APPLICATIONS EXPERIENCE:

Confidential

Oracle Applications Team Lead

Responsibilities:

  • Working on Oracle Apps R12 migration/conversion project
  • Leading the data migration team of 4 consultants on various modules like INV, AR, BOM, and OM.
  • Developed strategy documents for St Paul & Akron Vista project.
  • Worked on the acquisition projects like Ascension,St Paul,Akron/Vista (These are companies acquired by Integra in last 18 months)
  • Worked on conversions of Items, Bill of materials, Customers, Salesreps.
  • Involved in solution designing.
  • Worked on customer facing reports (customizations).
  • Worked on custom report in Inventory, Bill of materials, Purchasing, Costing, WIP & AR.
  • Designed & implemented SOI (Sales order integration project from Oracle - Surgisoft)
  • Developed Custom form, daily sales & invoice reports to implement territory management module for salesreps.
  • Worked on dealer’s setup in resource management for the replenishment orders.
  • Used AIM methodology for the whole development, consolidated status reports of the whole team, had regular status calls with the Integra team.

Confidential

Oracle Applications Team Lead

Responsibilities:

  • Working on Oracle Apps R11.5.10.2 Demand to build application custom module
  • Leading a team of 8 consultants on various applications like EDI, D2B.
  • Involved in the development of custom forms like View setup, Attribute management, Material disposition & Actual weight.
  • Developed PL/SQL programs for the piece type operations and integration project in D2B.
  • Used AIM methodology for the whole development, consolidated status reports of the whole team, had regular status calls with the Worthington team.
  • Worked on customization of i-expenses web page using oracle workflow and OAF.

Confidential

Oracle Applications OAF Technical Consultant

Responsibilities:

  • Working on Oracle Apps R12 (RUP8) E-Business suite applications Incentive Compensation.
  • Developed an OAF page for Compensation Plan and Commission statements by integrating incentive compensation and added BI publisher features.
  • Developed features like adding/downloading attachments from OAF page, created web beans showing links for useful links and Dashboard reports.
  • Developed another OAF page to show the Disclaimer and link to the main OAF page.
  • Created Dashboard reports for Sales Compensation and Attainment reports in Incentive Compensation.
  • Worked on customization of Service contracts reports like XXNS service Contract booking report, SC Details repots & Service Contract summary report.

Confidential, Dallas

Oracle Applications R11.5.10 Production Support

Responsibilities:

  • Worked on Oracle Apps R11.5.10 Oracle e-Business suite applications consisting of OPM, FINANCE, ADVANCE COLLECTIONS, INCENTIVE COMPENSATION and SCM.
  • Working as Technical Lead and Onsite Co-coordinator.
  • Working in Production Support with a team of 10 consultants from offshore India.
  • Worked on all types of production issues related to modules like OPM Inventory, Finance, Advance Collections, SCM and Workflow related modules.
  • Issues used to be logged in as Track IT tickets using the same software and were termed with priority. Resolved all the tickets within the set timed SLA’s
  • Worked on all Oracle tools like Forms, Reports (9i & XML Publisher), Discoverer 10g, Workflow builder and Oracle Framework (For i-Expenses Customizations).
  • Also involved in the development & Performance tuning of the above technical objects
  • Performed unit testing, user training & created all technical documents for all the enhancements and change requests as per AIM standards.

Confidential, CA

Tech Lead

Responsibilities:

  • Working on Oracle Apps R12 Oracle e-Business suite applications AR, AP, OM, PO, GL
  • Working as Technical Lead in AR, AP, OM, PO, GL modules.
  • Worked on critical reports like Commercial Invoice, Performa Invoice, Clinical Shipment & Certificate of Origin Report in OM using Reports 9i & XML Publisher.
  • Worked on AR Customer Statement & BACS Payment in AP
  • Another critical report worked was SO Outbound email to 3PL
  • Worked on Reports 9i and Discoverer 10g.
  • Worked on Customization of Workflows in OM and PO.Added new nodes in Order Line Workflow and Notifying PO to Buyer Workflows.
  • Also involved in the development & Performance tuning of the above technical objects
  • Performed unit testing, user training & created all technical documents as per AIM standards.

Confidential, CA

Sr. Business Consultant

Responsibilities:

  • Working on Oracle Apps 11.5.10.2 Oracle e-Business suite applications AR,AP,FA,PO,GL,CE & i-procurement modules.
  • Worked as Sr.Techno-Functional consultant in AR, AP, FA, PO, GL, CE modules.
  • Worked on the migration of Gemstar data into Confidential instances.
  • Migrated Gemstar EUL to Confidential instance
  • Worked on more than 20 discoverer reports in various modules at Confidential EUL.
  • Critical reports worked upon are GL Balances,GL Journal details, Cash Management & FA Depreciation Reports
  • Worked on Form Personalization’s in i-Procurement modules.
  • Worked on Reports 9i and Discoverer 10g.
  • Also migrated Gemstar EUL reports into Confidential instances
  • Also involved in the development & Performance tuning of the above technical objects
  • Perform unit testing, user training & got the final acceptance for all the technical objects from the users.

Confidential, CA

Senior Business Consultant

Responsibilities:

  • Working on Oracle Apps 11.5.10.2 Oracle e-Business suite applications OM,AR,INV,OM,BOM,WIP,GL modules
  • Working as Techno-Functional consultant in INV, PO, BOM, OM, FIN modules.
  • Worked on the Functional design for Agile - Oracle integration.
  • Developed all programs, code, reports for the import of Items, BOM from Agile to Oracle.
  • Worked on Manufacturing Reports in Inventory, HR, WIP using Discoverer 10g.
  • Worked on Form Personalization’s in AR, OM modules.
  • Worked on Reports 9i and Discoverer 10g.
  • Also involved in the development & Performance tuning of the above technical objects
  • Perform unit testing, user training & got the final acceptance for all the technical objects from the users.

Confidential, Dallas

Sr. Systems Analyst

Responsibilities:

  • Working on Oracle Apps 11.5.10.2 Oracle e-Business suite applications OPM,AR,AP,OM,GL modules
  • Worked as Techno-Functional consultant in OPM & FIN modules.
  • Worked on Functional design for New AR Print Invoice report, Item Usages, Pricing & Availability apart from Production support activities.
  • Solved lots of critical & high priority tickets related to Prod support.
  • Worked on Form Personalization’s in OPM, AR, OM modules.
  • Also involved in the development of the above technical objects
  • My main responsibilities will be developing functional design docs after meeting up with the business users, maintaining version control for the code developed, and use AIM methodologies in preparing the documents.
  • Perform unit testing, user training & got the final acceptance for all the technical objects from the users.

Confidential, NC

Sr. Systems Analyst

Responsibilities:

  • Working on Oracle Apps 11.5.9 Oracle e-Business suite applications & Reports6i for Confidential
  • Working on Reports 6i & XML Publisher and Discoverer Reports.
  • Worked on Market Report, Invoice Adjustments Report, Purchase Variance, and Sales Details Reports from Oracle OM, AR modules.
  • Created new EUL’s, business areas & folders for the reports Customer blanket agreement, IPV & PPV Variance Reports.
  • Leading a team of 4 resources. Main responsibilities will be maintaining version control for the code developed, review AIM docs & do code walk through, final sign off the code and docs.
  • Perform unit testing, user training & get final acceptance from the client.

Confidential

Sr. Systems Analyst

Responsibilities:

  • Working on Oracle Apps 11.5.9 & Discoverer Reports 10g enhancement project.
  • Worked as Techno-Functional consultant in INV,CRM,GL modules
  • Created new EUL’s & new business areas in Oracle Discoverer.
  • Worked on RME tracking report & Cycle counting report in Oracle Inventory.
  • Worked on Daily units in use & Market Activity Report based out of Service Requests in Oracle CRM.
  • Prepared functional design documents for GL FSG’s so that they can be executed using Discoverer 10g.
  • Worked on developing Discoverer Reports for all the existing FSG reports at Confidential UK.Previously ADI was being used for generating the FSG’s.

Confidential, CA

Sr. Systems Analyst

Responsibilities:

  • Worked on Oracle Apps 11.5.10 support project for Confidential at Onsite
  • Developed new 855 PO Acknowledgement EDI program which was based on other functionality called FILL/KILL logic based on trading partner rules.
  • Developed new form for capturing TP rules
  • Worked on Trade Management API’s for creating Offers, Budgets. Created new published API’s according to the clients needs.
  • Worked on Load Building API in shipping module as NAE was WMS enabled organization.

Confidential

Sr. Systems Analyst

Responsibilities:

  • As a senior team member was responsible for delivery onsite development activities. Preparing required documentation using AIM’s Methodology as a part of deliverables.
  • My role in this project is to take up all development activities in GL. This is currently an ongoing project & till date I have been working on Account translators in Oracle GL module for Confidential Industrial, Appliances, Lighting and Supply.
  • I worked on Industrial, Appliances, Lighting and Supply Translators which are part of Confidential businesses.
  • The complex objects I worked were Appliances translator, FI History Load (Journals) which involves COBOL, PL/SQL, and FORMS and Discoverer Report.

Confidential

Sr. Systems Analyst

Responsibilities:

  • Worked on Oracle Apps 11.5.10 implementation project for Confidential .
  • As a senior team member was responsible for delivery onsite development activities.
  • Preparing required documentation using AIM’s Methodology as a part of deliverables.
  • Role in this project is to take up all Development activities in EDI (Inbound & Outbound) to offshore.
  • This is currently an ongoing project & till date I have completed around Seven EDI programs.
  • Apart from EDI I have also worked on Oracle Trade Management. Developed 3 Custom Reports in this module using Oracle Discoverer 4i. Created EUL’s & business areas for the development of reports. The Reports are Aging Report, Customer Statement Report and Pass Thru Reconciliation Report.
  • Also worked on Conversions such as AR Invoices and AP Invoices.
  • Leading a team of three consultants currently in this EDI & TM requirement.

Confidential

Sr. Systems Analyst

Responsibilities:

  • Worked on Oracle Apps 11.5.9 implementation project for Alkhorayef companies at Onsite.
  • Was working on technical side of the project.
  • As a senior team member was responsible for delivery onsite development activities.
  • Preparing required documentation using AIM’s Methodology as a part of deliverables.
  • My role in this project was purely technical.
  • I was responsible in creating new functionality called Uniform Average Costing (UAC), Payroll Cheques (Data was migrated from Oracle Payroll-Oracle Payables) printing for both salaries & Individual payments, Retail Sales Report (Report to be printed from Sales Order Form in OM), Order Line Workflow & Forecast Load in MRP.
  • Used Workflow API's extensively to instantiate workflow processes.
  • Customized Standard Order Management Workflow for Shipment notification to Sales Representative after the order is shipped so that he can be keeps a follow up.
  • Customized OM Order line Workflow for Confidential .
  • Oracle Standard Workflow requires manual submission of Purchase Release and Requisition Import Program. The Client required to run above concurrent program manually as well as automatically. To achieve this Profile was set up which will decide the branching in Workflow.
  • Also worked with functional consultants in resolving minor technical issues

Confidential

Sr. Systems Analyst

Responsibilities:

  • Worked as Team Member, using Oracle Applications 11.5.9 for Confidential.
  • This offshore Data purging for all Manufacturing, Distribution and Finance Modules.
  • Responsible for delivery offshore development activities.
  • Preparing required documentation using AIM’s Methodology as a part of deliverables.
  • Role in this project was to provide technical solutions for the custom objects identified during this project.

Confidential

Staff Consultant

Responsibilities:

  • Provided Applications & System support to the production system.
  • Monitored various processes (WSM, PLANNING, OPR) for the Prod instance.
  • Provided technical Solutions for the tickets that were created by the BPE/Users of Agilest.
  • Provided Code fixes where ever Code changes were required.
  • Worked on EDI programs 850,865 etc.
  • Used custom PL/SQL procedures that can be executed as automated functions in a workflow process.
  • Modified default OM & PO Workflows to meet client requirements.
  • Customized Standard Order Management Workflow of Comprehensive type for automatic creation of Work Order when Sales Order is booked.
  • Customized Standard Order Management Workflow to accommodate Order as well as Return in same Sales Order.
  • New Transaction Type had to be created.
  • Worked with Product Support TAR’s and performed Cemli Patch analysis.
  • Technical Solutions were provided for INV, OM, BOM, PUR, AR, and Workflow modules.

Hire Now