SUMMARY:

• Over ELEVEN years of experience as Oracle EBS Techno - Functional Consultant/Lead in multiple Implementations, R12 Upgrades and Support projects in Oracle E-Business Suite 11i (11.5.10) & R12 (12.1.3, 12.2.5, 12.2.6)
• Experience in various modules such as Financial (AR, AP, FA, GL), Manufacturing & Supply Chain Management (WIP, BOM, QA, OM, INV, PO), PLM, HRMS, DR, Alert and AOL.
• Efficient programming skills in PL/SQL, Stored Procedures, Functions, Database Triggers, Packages with Oracle Database 9i/10g/11g/12c on Implementation/Upgrade/Support projects of Oracle 11i/R12 E-Business Suite.
• Good experience in full SDLC
• Experienced in design and developing integration between 3rd party systems like Concur and Workday with Oracle EBS
• Experienced in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) and performance tuning of SQL, PL/SQL and Views.
• Good experience in Data Conversions and design/development of Interfaces using Oracle open interfaces and Oracle Public API’s for various Financial and Manufacturing modules.
• Experience in creating and customizing existing and new reports using reporting tools like Oracle Reports 10g/6i and BI Publisher (XML Publisher).
• Experience in creating, customizing and administrating Discoverer reports/workbooks using Oracle Discoverer 10g/4i reports and Oracle Discoverer Administrator 10g/4i.
• Good exposer to Label printing solutions using Loftware and Bartender
• Experience in customizing Oracle Applications using CUSTOM.pll, Form Personalization, OAF personalization & Extension and MWA customizations.
• Experience in developing new custom pages using OAF in 11i and R12 versions of Oracle EBS.
• Extensive experience on AOL/System Administration tasks like Concurrent Programs, Registration & setup of Forms/OAF pages, Flex fields, Value Sets, Lookups, Menu and Responsibility.
• In-Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import, data fixes.
• Experience in working with the utilities like TOAD, SQL* Loader, Version Control System like Microsoft Visual Source Safe 6.0 and Serena PVCS VM 8.0.
• Good interpersonal skills, the ability to interact with people at all levels, and excellent communication skills.
• Ability to gather and understand user requirements and translate into technical/Functional specifications.
• Ability to learn quickly new technologies and solve problems in a team environment and multitasking.
• Experience in performing code reviews and ensure that all over programming quality as per standards.
• Experience in troubleshooting and resolving issues with technical, functional and DBA teams.
• Experienced working with Offshore-Onsite model with US clients.
• Capable of working independently and as well as a part of a team and working under pressure and deadlines.
• Excellent skills resolving issues in supply chain and finance modules of techno-functional nature
• Experienced in opening/following-up service requests (TAR or SR) with Oracle Support.
• Experienced in leading a team, mentoring team members towards common goal, delivery and testing.
• Knowledge in REST API, WSDL, JSON, Web Services, SOA

PROFESSIONAL EXPERIENCE

Oracle Apps Developer

Confidential, Englewood, CO

Responsibilities:

• Develop custom APIs packages using PL/SQL to create Sales Orders, inquire inventory on hand and item Pricing according to business requirements within Oracle EBS R12.2.6
• Unit testing and coordinate with SOA team to verify end to end functionality
• Participate in upgrading database objects for EBS 12.2.6 and 12c database from EBS 11.5.10
• Performance tuning for SQL and PL/SQL custom code to eliminate time bottlenecks in system
• Utilize TOAD, SQL, PL/SQL, Order management, Inventory, Pricing to enhance Oracle R12.2.6 with 12c database
• Design and develop technical solutions to a pre-defined requirement and develop components (e.g. extensions, views, customizations, modifications, reports, and workflows) independently or as a part of a team
• Developing solutions for Oracle’s e-business suite using Oracle’s development tools including reports, forms, BI publisher, Workflow Builder and JDeveloper
• Month End and Oracle technical support to resolve tickets in the Oracle Core financials (AP, AR, GL) & SCM/Manufacturing (OM, Inventory, Shipping, WIP, BOM)

Confidential

Oracle Applications R12 enhancement/support

Responsibilities:

• Develop and/or customize Oracle reports and forms to meet functional business requirements.
• Design, develop, and test custom extensions (e.g. packages, functions, procedures, and triggers)
• Work with end users and functional analysts to capture and document business requirements, perform unit and system testing.
• Assist in migrating code changes to production environment and perform code reviews.
• Provide techno-functional expertise necessary to support daily operations in Oracle Applications.
• Month End support on various financial and supply chain modules
• Architected and developed end to end solution for Label printing automation using Loftware and Oracle EBS
• Architected and Developed end to end integration of Concur (3rd party) system with Oracle Payable
• Architected and Developed end to end integration of Workday (third party) with Oracle HRMS
• Utilize Oracle tools, such as SQL, PLSQL, TOAD, Forms, BI Publisher and ALERTS to enhance Oracle applications.

Environment: Oracle EBS R12 (12.1.2 & 12.1.3), Oracle Database 11g/12c, Report10g, Forms 10g, Custom.pll, WIP, BOM, INV, QA, AR, AP, GL and PLM, PL/SQL, TOAD.

Confidential

Programmer Analyst - Oracle EBS (Onsite)

Responsibilities:

• Developed form personalization to allow Move Transaction to trigger quality result page
• Development of custom form using Oracle Forms 10g and reports using Oracle Reports Builder 10g
• Created a system using PL/SQL packages and triggers to interface quality data captured from legacy system into Oracle EBS
• Created an automated program to load daily exchange rate in GL from third party Web service
• Involved in writing Packages and Triggers to generate serial numbers, handle printing of label using Loftware and designed and developed end to end label printing solution using Bartender
• As a technical consultant, responsible for Communicating with the end users, Requirements analysis, Coding, Testing, Change Management and support of the Customizations and application extension.
• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle EBS.
• Worked on improving the performance of views and packages.
• Creation of LDT files to load Executable, Concurrent Programs and lookups from one instance to another instance.
• Developed conversion programs Item, Locator for Operating Unit merge
• Developed solution from scratch for label printing upon Receipt inspection and deliver, designed labels to print from Loftware.
• Worked with technical, functional teams to troubleshoot and resolve issues on offshore / onsite level.
• Worked with offshore team to assign/explain work, test and get it delivered to client.
• Responsible for effective communication to the client and peers. Provide day to day direction to the peers and provided project status to the client on a regular basis.

Environment: Oracle EBS R12 (12.1.3 & 12,2,5), Oracle Database 11g/12c, Report10g, Forms 10g, Custom.pll, WIP, BOM, INV, QA, AR, AP, GL and PLM, PL/SQL, TOAD.

Confidential

Sr. Oracle Apps Technical Consultant & Team Lead (Offshore)

Responsibilities:

• Developed XMLP reports for replacements of 11i RDF based reports which are obsolete in R12 as per user requirements (Dunning Letter, Packing Slip etc.)
• Extensive customization using Form Personalization to implement various functionalities.
• PLM (Product Lifecycle Management) Self-service (OAF) pages
• Involved in wide PLM module customization and testing and doing new setups for change management
• Extensive use of SQL & PL/SQL for Trigger, Procedure, Function and Packages
• Development of Trigger, Procedure, Function, View and Package for PLM, AP, AR, PO, OM, INV modules
• Development of data fixing for data issues, most of the time in PLM
• Testing and fixing and 11i reports/forms to work in R12
• Developed new reports in R12 using Reports 10g from scratch like Material distribution for WIP and other modules
• OAF personalization to change look and feel of the pages. Extension of CO for customizing functionality of self-service page
• Supporting of R12 related issues/ enhancements in reports, forms & self-service pages
• Team Management
• As lead I carried out following activities
• Assigning and distributing work among team members
• Technically mentoring team
• Training team on PLM module both functionally and technically and on customization done
• Analysis of the requirement and explaining to team members
• Testing solution developed by team
• Technical reviews of work done
• Day to day communication with onsite client regarding status update and new requirement discussion

Environment: Oracle EBS 11.5.10.2 & R12, PLM, AP, AR, GL, PO, OM and INV, PL/SQL, TOAD, Reports6i, BI Publisher OA Framework.

Confidential

Team Lead (Offshore)

Responsibilities:

• OPS Process implementation
• Client was using UNIX shell scripts to perform various business-related aspects. Analyzed, Identified,
• Transformed those script in as a PL/SQL based Concurrent programs and added Emailing
• Defined testing plans, assignment/review of work/code, communication with Onsite client
• And delivery
• Day to day, report scheduling, conference call, net meeting w.r.t. work and agenda, issue sheet updating
• To provide technical support, enhancement in existing objects

Environment: Oracle EBS R12, Oracle 10g, AP, UNIX, PL/SQL, TOAD.

Confidential

Oracle Apps Technical Consultant (Offshore)

Responsibilities:

• Reports (Report 6i, BI (XML) Publisher, Discoverer) development and Modifications
• New/existing reports and forms development/modifications using report builder and BI Publisher, Discoverer Desktop and Discoverer Plus reporting tools
• Worked on one of the complex Invoice Report from scratch and built layout using BIP.
• Form Personalization
• Extensive customizations using Form Personalization
• Implemented full SDLC of new forms using Oracle Forms Builder 6i
• Implemented full SDLC of new forms using form 6i in Oracle Apps.
• Defining Menu, Concurrent Program, Function and other AOL objects
• Discoverer Report
• Developed several Oracle Discoverer workbooks using Discoverer Admin, Discoverer Desktop and
• Discoverer Viewer.
• Defining Concurrent Programs, Executable, Value Sets, Request Group and other AOL objects
• Day to day, report scheduling, conference call, net meeting w.r.t. work and agenda, issue sheet updating
• To provide technical support, enhancement

Environment: Oracle EBS 11.5.10, Oracle 10g, General Ledger (GL), Accounts Payables (AP), Order Management (OM), Inventory.

Confidential

Oracle Apps Technical Consultant (Offshore)

Responsibilities:

• Using Report (6i and XML Publisher) created new and modified existing reports and forms development/modifications
• Created new Forms using Oracle Form Builder 6i in Oracle Apps.
• Extensive customizations using Form Personalization and custom.pll
• Conversions for Importing data for Invoice, Customer, Sales Order, Purchase Order, ASL, & Item from legacy system
• Developed data conversion for Importing Invoice, Sales Order, PO, BOM, Routing and Item
• NLS-MLS (Multilanguage Implementation in Oracle APPS)
• Involved in identifying, development, fixing and testing of NLS objects to MLS objects.
• Making DFF Context Sensitive
• Involved in design, development, and integration, fixing and testing of DFFs from 11.0.7 to 11.5.10, making it context sensitive.
• MWA Customization
• Customized MWA application for over-picking in WIP
• EDI 852 Enhancement and Development
• Involved in developing/Enhancing technical solutions for EDI Import Program
• Day to day, report scheduling, conference call, net meeting w.r.t. work and agenda, issue sheet updating
• To provide technical support, enhancement
• Resolving performance issues for existing objects like reports, views and packages.

Environment: Oracle EBS 11.0.7 & 11.5.10, Oracle 9i, Forms 6i, Reports 6i, XML Publisher, MWA, CUSTOM.pll, Barcode, FA OM, BOM, INV, HR, PLM, AR, AP.

Confidential

Oracle Apps Developer (Offshore)

Responsibilities:

• Worked on various aspect of Oracle Application during 4 phases of implementation. Implementation phases included Financial, Manufacturing, and Change Management.
• Created XML Publisher Report development cycle on number of XMLP reports and Involved in BARCODE solution using XMLP.
• Extensive customization using Form Personalization and CUSTOM.pll.
• Created/Customized new/existing Reports (RDFs) (Depot Repair, Fixed Assets, Account Receivables, Account Payables, Order Management, Inventory, BOM) using Oracle Report 6i.
• Created new Forms from scratch using Oracle Form Builder 6i
• Import/Synchronization program for Depot Repair to PLM (SR Interface)
• Designed and developed code for importing all complaints from Service Request in Depot repair to PLM and synchronizing program complaint from PLM to Depot Repair module. Created request sets and concurrent programs for scheduling synch program
• SQL, PL/SQL
• Developed of Trigger, Procedure, Functions and Packages for implementation
• Data Migration
• Developed data conversion programs for Importing HR, Customer, Invoice, Sales Order, PO, BOM, Routing and Item from legacy
• E-Signature OA Framework Pages
• Involved in development, deployment and testing of PL/SQL code and new custom OA framework pages to support new functionality.

Environment: Oracle EBS 11.5.10, Oracle 9i, Forms 6i, Reports 6i, XML Publisher, CUSTOM.pll, Barcode, FA OM, BOM, PO, INV, HR, PLM, AR, AP.