We provide IT Staff Augmentation Services!

Lead Oracle Ebs Technical Consultant Resume

SUMMARY

  • Oracle Certified with 11+ years of experience as an Oracle Applications Technical Consultant.
  • Extensive experience in Analysis, Design, Development, Testing and post - production support for Oracle EBS Suite R11 and R12 version
  • Project experiences include, multiple full life cycle implementations, new functionality deployment and R12 Upgrades
  • Experienced in the Order-to-Cash and Procure-to-Pay business flows. Good Knowledge in Data Model of Order Management (OM), TCA Architecture, Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), Inventory (INV), WMS, Credit Management, Advanced Collections, Approvals Management
  • Experienced in writing AIM/OUM Documents
  • Technical Expertise in SQL, PLSQL, Oracle Reports 6i/10g, Discover, Oracle Forms 6i/10g, (XML) BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning.
  • Experience in development and customization of forms in Oracle applications using standard AOL functionality and CUSTOM.pll and Template.fmb.
  • Experience with OAF page customization and personalization
  • Experience in System Administration & AOL: Application user/responsibility setup, value sets, flex fields, registering menus, forms, reports, concurrent program
  • Excellent business knowledge across multiple verticals with the ability to understand the business process, perform a Gap Analysis and recommend an Oracle Solution across multiple modules
  • Prior experience as a technical lead in conducting CRP’s, test strategy & plans, training and post go-live support. Hands on experience in interface design, customizations, integrating and data conversion.
  • Worked with Oracle Support to identify issues that arise and created Service Requests (SRs) with Oracle Support and tracking them to closure to track them to closure.
  • Experience with the following tools: Forms Personalization, TOAD, SQL Developer, Putty, Win SCP and version control, PVCS, Kintana.
  • Experience in Onshore-Offshore model Implementation

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle EBS Technical Consultant

Responsibilities:

  • Working at client site as Technical lead responsible for managing the Custom Reports Development
  • Understanding the legacy reports and data mapping
  • Creating Pseudo Code for custom report based on Data conversion as part of Implementation
  • Creating XML publisher / Oracle Reports to convert the existing Main Frames reports in Oracle
  • Customizing existing oracle reports to add the custom columns
  • Writing PL/SQL Packages for reports required in CSV format.
  • Coordinating with the Implementation team for all Conversions and data mapping
  • Managing Offshore deliverables
  • Unit testing of all reports
  • Peer review on Developed reports and testing.
  • Writing migration scripts and managing the migration to all instances.

Environment: Oracle Reports 6i, Oracle 11g, SQL, PLSQL, XML Publisher Reports

Confidential

Oracle EBS Technical Lead Consultant

Responsibilities:

  • Working at client site as Technical lead responsible for managing 6 offshore resources.
  • Responsible for all technical deliveries.
  • CEMLI identification and remediation (3400 CEMLI objects)
  • Managing all CEMLI Objects for remediation
  • Effort estimation and work allocation.
  • Analysis and solution design for changed functionality from R11 to R12.
  • Code Review and Unit testing
  • Participating in User testing and Integration testing
  • Preparing DS140 for Change functionality
  • Preparing user training documents
  • Managing Code Migration across instances
  • Working with DBA’s on Databases changes related to Editioning Objects
  • Managing all Technical SR’s with Oracle
  • Customizing Seeded reports as per Business needs
  • Requirement gathering and designing custom reports
  • Remediating existing personalization and Creating new personalization in order to achieve desired functionality
  • Working closely with Functional leads on testing functionality impacted by CEMLI objects
  • Involved in Auto Invoice Interface to import Invoice, Credit Memo, Demit Memo, On account Credits into Interface table in Account Receivables.
  • Managing CEMLI objects across different technologies like PlSql, Java, JSP,OAF, Forms, Reports, XML and AOL objects
  • Maintaining Sharepoint for all CEMLI objects
  • Post production support for all Modules

Environment: Oracle Forms 10g, Oracle Reports 6i, Oracle 11g, SQL, PLSQL, XML Publisher Reports

Confidential

Oracle EBS Technical Lead Consultant

Responsibilities:

  • Receiving the interface file from API system
  • Validating the Data
  • Creation of receipts and applying them.
  • Writing Technical Design Document (MD070) for all Interfaces
  • Unit testing and Code Migration for all Interfaces.
  • Customizing Customer Form to add additional attributes to facilitate additional fields coming in from 3rd party system.

Confidential

Oracle EBS Technical Lead Consultant

Responsibilities:

  • Involved in designing the prototype, preparing MD60 technical specification, Unit Test cases document, coding and Unit Testing.
  • Involved in Customizing Invoice Approval Workflow to embed multiple approval Hierarchy.
  • Work with DBA team and cross functional application teams for application change control and system performance Issues. Involved in Quarterly releases code deployment and post live support.
  • Customization of business critical Forms and Reports. Solution Designing for all technical tasks
  • Identify and Purpose best practice methods, Coding standards, Standard for documentations.
  • Timely resolution of incidents based on the estimate and agreed date/ time and delivering Objects with High Quality. Code review for offshore and onsite developers.
  • Created test scripts for every level of testing from unit testing stage to integration testing.
  • Unit testing and Integration testing. Provide support for business critical application problems and issues. Involved in deployment activities, and supported go-live migrations.

Environment: Oracle Applications R11 (AP, AR, GL) BI/XML Publisher, Oracle 11g/10g, SQL, PL/SQL, Forms 10g, Reports 10g, Oracle Alerts, SQL Loader.

Confidential

Oracle EBS Technical Lead Consultant

Responsibilities:

  • Designed the application flow and Integration between multiple systems.
  • Designed the Database (ERD) for all systems and defined the relationship and mappings with existing applications.
  • Requirement gathering and understanding existing Ms-Access system.
  • Preparation of MD50 and MD70 documents based on Business requirement documents.
  • Designing the Forms layout to suit the business requirement.
  • Attachment functionality
  • Hierarchical Tree
  • Multi Block /Multi Tab Form Layouts
  • Enhanced the Reporting by introducing XML Publisher reports.
  • Management reporting enhanced by creating business critical reports in Oracle Discoverer.
  • Leading the project at Offshore and overall responsible for all project deliverables.
  • Daily statuses update meeting with Client about the progress of the project deliverables.
  • Code reviews to ensure coding standards are followed and business requirement are fulfilled.
  • Preparing Migration scripts and single point of contact for all migrations activities.
  • Creating Custom Oracle Forms. Oracle Reports, XML Publisher reports, Discoverer Reports.
  • Performing Sys Admin Activities like creating Concurrent programs for Report execution, Registering Form, Function and Menus.

Environment: Oracle Forms, Oracle Reports 6i, Oracle 11g/10g, SQL, PLSQL, XML Publisher Reports, Oracle Discoverer Reports.

Confidential

Senior Oracle EBS Technical Consultant

Responsibilities:

  • Identified changed objects in R12 as compared with R11.Identifying custom objects and retrofitting them as per R12 application.
  • Done Performance Tuning on all the objects that are running for more time than expected time. Created LDT files for further migration on another Instance.
  • Developed SQL*Loader control files to load the legacy data into the temporary tables.
  • Retrofitting objects like Procedures, Functions, Packages, Oracle Forms, Reports, and Workflows.
  • Retrofitted custom PL/SQL interfaces - Import Suppliers, Banks, Payable Invoices, Requisitions, Purchase Orders, and Receipts.
  • Developed solution for Custom Check Printing using XML Publisher.
  • Involved in testing the developed objects. Developed MD70 Technical document for all the developed reports. Designed complex reports by coordinating with end users for the requirements.
  • Form Personalization in Order Management.
  • Customizing, Designing and Developing XML Publisher Reports.
  • Unit testing and System integration testing.
  • Preparation of installation files. Migrating and installing code to higher instances.
  • Involved in the maintenance and support of existing applications with the users.
  • Raised Oracle SR’s for seeded product related issue and proactively followed to bring them to closure.
  • Creating migration scripts for all objects and setting up automation for migration to reduce time required for migration and compilation of DB objects and Forms.
  • Development of Technical Design (MD070), Test Case Documents (TE020) and Installation Document (MD120) and installation files.
  • Mentored new joiner’s on projects with development and migration process.

Environment: Oracle Applications R12 (AP, AR, GL, OM and PO), Oracle 11g/10g, SQL, PL/SQL, SQL Loader, Unix shell scripting, Oracle Forms and reports, Oracle Workflow.

Confidential, Austin, TX

Senior Oracle EBS Technical Consultant

Responsibilities:

  • Worked with business to map legacy sales order system to oracle order entry.
  • Development of Inbound Interface and Conversion Program, Customization and Development of XML Publisher Report.
  • Developed outbound interface to extract sales order delivery details.
  • Developed inbound interface to update sales order reservations.
  • Developed Multi-language xml publisher report - AR Invoice Print, Purchase Order print, Voucher print report.
  • Created SQL Scripts to create and drop database objects like tables, sequence, PL/SQL package and grant script.
  • Developed Unix Shell Scripts automate to installation of table, PL/SQL code, concurrent program, value set. Utilized the Application Object Library (AOL) to register PL/SQL package as concurrent programs, value sets. Migrating and installing solutions.
  • Development of technical design document (MD070, CV060), Installation document (MD120), Installation files and Unit Test Plans (TE020).
  • Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures and reports.
  • Wrote SQL scripts to create staging tables and developed SQL*LOADER Control files to load the legacy data into the staging tables
  • Migrated and installed code components in higher instances.
  • Participations in the code reviews and Technical design reviews.
  • Worked actively to troubleshoot defects and problem during CRP and UAT testing.
  • Performed Post-Production support post Go-Live.
  • Presenting documentation to customer for Review.

Environment: Oracle Applications R12 (OM) Oracle 11g/10g, SQL, PL/SQL, Workflow Builder, Order Management.

Confidential

Senior Oracle EBS Technical Consultant

Responsibilities:

  • Interacted with the business users on understanding requirements for development of interfaces and reports.
  • Development of Inbound and Outbound Interface.
  • Customization and Development of XML Publisher Report and Oracle Form Personalization.
  • Development of technical design document (MD070, CV060), Installation document (MD120), Installation files and Unit Test Plans (TE020).
  • Wrote SQL Scripts to create, alter, and drop database objects like tables, views, and sequences.
  • Developed Unix Shell Scripts to migrate the Form Personalization code, XML Publisher definitions, Concurrent programs, Value sets to different instances.
  • Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures and reports.
  • Wrote SQL scripts to create staging tables and developed SQL*LOADER Control files to load the legacy data into the staging tables. Migrated and installed code components in higher instances.
  • Participations in the code reviews and Technical design reviews. Worked actively to troubleshoot defects and problem during CRP and UAT testing.
  • Performed Post-Production support post Go-Live.

Environment: Oracle Applications 11i and R12 (OM, INV, PO), BI/XML Publisher, Oracle 11g/10g, SQL, PL/SQL, Forms 10g, Reports 10g, Oracle Alerts, SQL Loader.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

  • Meeting with customer to understand issues.
  • Post-Production Support. Bug fixing in Interfaces, Reports and Form.
  • Development of change management document-CM040, Installation document (MD120), Installation files and Unit Test Plans (TE020). Unit testing.
  • Solved user queries, and maintained clear explanations of problems and resolution logs.
  • Preparation of Installation Files. Migrating and installing solutions in QA and PROD instance.
  • Presenting documentation to customer for Review.

Environment: Oracle Applications 11i (OM, AP, AR and GL), BI/XML Publisher, Oracle 9i, SQL, PL/SQL, Forms 6i, Reports 6i, SQL Loader.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Worked extensively on Interfaces, Conversions and Extensions.
  • Analysis of Functional design Document and preparation of Technical design document for the same.
  • Coding & creating the workable solution to achieve the desired functionality.
  • Defining or Modifying Responsibilities, Menus, Functions, Request Groups, Reports, Forms, Concurrent Requests, Request Sets and Procedures.
  • Preparation of Unit test Cases.
  • Unit testing of the component for the desired functionality.
  • Peer to Peer review of Code & documentation.

Environment: Oracle Applications GAT (AP, AR, GL and OM), Oracle 9i/10g, SQL, PL/SQL, SQL Loader, Receivables, General Ledger, Purchasing.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Interacting with onsite team in deriving delivery dates of components and driving team in a direction to achieve the same deadlines and Conducting Technical Review& Code Walk through.
  • Simulating and analyzing the reported Problem. This usually involves a code walkthrough of Interfaces, Forms & Reports and SQL Scripts.
  • Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.
  • Perform the action plans given by Performance Team. Generated the Debug file, trace file etc.
  • Defining or Modifying Responsibilities, Menus, Functions, Request Groups, Reports, Forms, Concurrent Requests, Request Sets and Procedures.

Environment: Oracle Applications R12 Oracle 11g/10g, SQL, PL/SQL, Order Management.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Analyzing user requirements
  • Doing Impact analysis on other functionalities and objects.
  • Preparing Technical Design Document.
  • API, AOL Objects Development and coding.
  • Creating Unit Test Case and Test Reports.
  • Worked on Migration and version control tools like Kintana and PVCS
  • Migration of the developed Objects.
  • Production Scheduling & Control of the Programs using Dollar Universe ($U).

Environment: Oracle Applications R12\Oracle 11g/10g, SQL, PL/SQL, Order Management.

Hire Now