SUMMARY:

• Oracle Certified with 9 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 teh 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
• Experienced in writing AIM Documents - MD 50, MD70, CV60, CM40, MD120, TE020
• 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 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 teh ability to understand teh 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 dat arise and created Service Requests (SRs) with Oracle Support and tracking them to closure to track them to closure.
• Experience with teh following tools: Forms Personalization, TOAD, SQL Developer, Putty, Win SCP and version control, PVCS, Kintana.
• Experience in Onshore-Offshore model Implementation

PROFESSIONAL EXPERIENCE:

Confidential, Boston MA

Lead Oracle EBS Technical Consultant

Responsibilities:

• Worked at Client location, Involved in requirements gathering, Client discussions and Knowledge sharing. Involved in teh Interface scope of work, and acted as key point of contact to offshore development team.
• Involved in developing complex objects in accordance with technical development standards and best practices. Involved in design and development of Interfaces and conversions
• Involved in reviewing team deliverables i.e. Technical Design documents, Build artifacts, Unit Test plan and Installation guide, and suggest teh best practice methods for a quality deliverable.
• Retrofitted XML Publisher and D2k Reports
• Involved in Functional clarification meeting and ensured teh gaps are not trickled down to Functional design documents.
• Involved in designing teh prototype, preparing MD60 technical specification, Unit Test cases document, coding and Unit Testing.
• Involved in Customizing Interfaces:
• Developed an API for Converting teh Invoice Payments (AP) and was able to convert all teh Historical Invoice Payment History.
• Involved in Customizing standard GL programs like:
• 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.
• Involve in daily and weekly meetings with offshore team to discuss project status.
• Scheduled and participated in weekly client status call and updated with teh project status.
• Timely resolution of incidents based on teh 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, Houston TX

Lead Oracle Applications Technical Consultant

Responsibilities:

• Designed teh application flow and Integration between multiple systems.
• Designed teh Database (ERD) for all systems and defined teh 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 teh Forms layout to suit teh business requirement.
• Enhanced teh Reporting by introducing XML Publisher reports.
• Management reporting enhanced by creating business critical reports in Oracle Discoverer.
• Leading teh project at Offshore and overall responsible for all project deliverables.
• Daily statuses update meeting with Client about teh progress of teh 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, Denver, CO

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 teh objects dat are running for more time than expected time. Created LDT files for further migration on another Instance.
• Developed SQL*Loader control files to load teh legacy data into teh 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 teh developed objects. Developed MD70 Technical document for all teh developed reports. Designed complex reports by coordinating with end users for teh 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 teh maintenance and support of existing applications with teh 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 joinee’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 teh 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 teh 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 teh legacy data into teh staging tables
• Migrated and installed code components in higher instances.
• Participations in teh 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 teh 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 teh Form Personalization code, XML Publisher definitions, Concurrent programs, Value sets to different instances.
• Extensively utilized teh 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 teh legacy data into teh staging tables. Migrated and installed code components in higher instances.
• Participations in teh 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.
• Worked extensively on Interfaces, Conversions and Extensions.
• Analysis of Functional design Document and preparation of Technical design document for teh same.
• Coding & creating teh workable solution to achieve teh 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 teh component for teh 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 teh same deadlines and Conducting Technical Review& Code Walk through.
• Simulating and analyzing teh 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 teh action plans given by Performance Team. Generated teh Debug file, trace file etc.
• Defining or Modifying Responsibilities, Menus, Functions, Request Groups, Reports, Forms, Concurrent Requests, Request Sets and Procedures.
• 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 teh developed Objects.
• Production Scheduling & Control of teh Programs using Dollar Universe ($U).

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