SUMMARY

• Having 15 years of diversified techno functional expertise in Confidential Applications R12/11i, with extensive exposure in design and development of Custom interfaces, APIs, dealing with Application Object Library, customizing forms and reports.
• Proficient in all phases of Confidential Applications R12/11i implementation with major focus in Confidential Manufacturing (INV, BOM), Supply Chain Module (OM, PO, Shipping, WMS), Confidential Process Manufacturing (OPM),financials (GL, AR, AP), CRM,AOL, Advance Pricing and System Administration modules.
• Having experience in Confidential Cloud - worked on Conversion by using FBDI.
• Expert in Gathering Requirements to understand client’s needs and generate, modify existing data in Confidential Applications according to the specifications.
• Well experienced in design of Forms, Reports, Interfaces, Conversions and Extensions (RICE), Implementation, Develop and Support of various Confidential Apps modules. Involved in implementing versions/upgrades of Confidential Applications 11i, and Confidential ApplicationsR12upgrade for Confidential Business.
• Designed Interface/Conversion Programs and good experience in Confidential backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Worked on Confidential Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller Confidential and entity object EO.
• Experience in designing and developing project plans for complete SDLC from gap analysis to postproduction support. Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Prepared the Designs for Gaps, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents and Sysadmin setups documents.
• Experience in full life cycle implementation projects covering Business Requirement Gathering, Conducting sessions, Gap Analysis, Configuration Setup, Conference Room Pilot (CRP), User Acceptance Test (UAT), Go live and Production support in Multi-Org environments.
• Experience in preparations of AIM documents, Business Requirements gathering (RD020), Application Setup (BR100), Solution Design (MD050), Test Scripts (TE040), and End User Manuals.
• Registering of Custom Applications/Table/Schemas in Confidential Applications.
• Expertise in implementing and strong knowledge of order to cash (O2C) and procure to pay (P2P) business flows.
• Good Communication, Confidential -ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Confidential Support. Managed and monitored TAR’s for several P1 issues.
• Very Good understanding of Multi-org & TCA architectures.
• Expert in System Administrator and Applications Developer responsibilities such as Creation of Users, Responsibilities, Functions, Menus, Request Sets, Value Sets, Flex Fields, Working with Profile Options and Registration of Concurrent Programs.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Experienced in Application Support in Production Environment and working with business users to implement or enhance the solutions into ERP system.
• Hands on experience in troubleshooting issues and resolving tickets on priority.

TECHNICAL SKILLS

ERP: Applications 10.7, 11i, R12(11.5.10.2,11.5.10, 11.5.9, 11.0.5, (12.1.3) )

E-Business Suite Modules: INV,OM, OPM, PO, WSH, BOM, WIP, AP, AR, GL, PO, AOL, SYSADMIN

RDBMS: Confidential Version 12.1.0.2.0, 10g, 9i, 8i

Operating Systems: LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL, XML, OAF,C, C++, Java, VB

Tools: & Utilities: Forms 6i/9i/10g, Reports 10g/6i/2.5, SQL*Loader, JDeveloper, Confidential Workflow Builder, TOAD and SQL*Plus, XML Publisher, Confidential EDQ

Documentation: AIM Documentation (MD50, MD70, MD120, CV60, CV40)

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Team Lead/Team Member

Responsibilities:

• Designed solution using Confidential MDM.
• Build MDM repository.
• Facilitate Data load and syndication.
• Develop MDM solutions for workflows, de-duplication, validations etc
• Perform Unit tests.
• Complete MDM Project documentation.
• Aid integration tests.
• Confidential Cloud Conversion by using FBDI (Customer, Supplier, Blanket Purchase Agreement, Contact PurchaseAgreement)
• Worked on the implementation, Upgrade of Confidential EBS R12 modules OM, INV, OPM and O2C, involved in all phases of the implementation and postproduction support.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Arranged the Clients Calls with Business team to understand their Business Process for migration.
• Prepared the Designs for Gaps, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents and Sysadmin setups documents.
• Good experience in study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of functional data process flow charts.
• Excellent experiences to train end users on the system and provide post go live support.
• Coordinated with Technical and Business teams in order to meet the Business Requirements for identified Customizations.
• Worked on the enhancements and customization of Item Import, Item Assignment jobs to publish the data from Confidential to other systems.
• Involved in the users, providing the feasible solutions, played a major role in cross functional meetings and gathered/provided necessary information for P1 issues.
• Worked on the configuration/issues related to inventory setups including inventory organizations, UOM’s, item categories, product catalogs, locations, freight carriers, item parameters.
• Expertise in the setting up the Inventory Hierarchy Structure and creation of new organizations as per the need.
• Hands of experience on maintaining data and data analysis.
• Good Experience and knowledge on Item Creation, Item Categories, Item Assignment and Organization Assignment and publishing the item to third party systems.
• Worked on the design of the Item Import Conversion program using Import Item Open Interface. Using this program, we created Master items and assign those items to child Organizations along with Item category assignments.
• Worked on day - to day activities and coordinating with users, super users, WMS, Management, technical and business teams to process the orders from order entry till shipping and make sure they are invoiced. (O2C Cycle).
• Performed Tier I/II system troubleshooting in a production support environment for the Confidential SCM,OPM modules. Assisted users in solving both functional and system issues within agreed-to service level agreements (SLAs Provide end-user instruction, and support to resolve application issues during Red Hat Period.
• Provided techno functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Provided techno functional support in the research and analysis of application stability improvements, requests and problems for internal users and external customers and vendors (Users).
• Created and Managed Service Requests with Confidential Support in different scenarios, for providing Solutions to the Bugs identified during Production Support. Conducted OWC sessions and resolved various bugs, working in collaboration with Confidential Support.
• Expert in identifying the issues and providing the feasible solutions on priority.
• Monitor Month end close process for Inventory, OM, Receiving and Shipping modules. Performed post-installation system review and ongoing support.
• Maintain, tune and repair applications in a proactive manner in order to keep them performing according to technical and functional specifications, performing preventive activities.
• Participated in on-going live projects and supported red hat issues.
• Expert in review and understating functional documents like MD50 and BR100 as per the client need.
• Assisted users in solving functional and system issues within agreed-to service level agreements (SLAs Provide end-user instruction, and support to resolve application issues.
• Worked on Form Personalization’s and creating or modifying the existing forms using Form Builder.
• Worked on Confidential Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller Confidential and entity object EO.
• Worked on the system options, profile options, flex-fields, setups to provide functional expertise and existing, new project releases.
• Expert in implementing the solutions and supporting red Hat Issues and production issues after Go- Live.
• Good experience to work remotely and worked as Lead for offshore and onsite team.
• Excellent skills on debugging and troubleshooting the technical RICE objects and provided the solution.

Environment: Confidential Applications R12 (12.1.3) (OPM, INV, OM, PO, WIP, AP, AR, GL, AOL, SYS ADMIN), Confidential Database 9i/10g, PL/SQL, Toad, Confidential EDQ.

Confidential, New York, NY

Sr.  Application Developer

Responsibilities:

• Worked on the implementation of Confidential EBS R12 modules OM, INV, OPM, O2C and P2P and was involved in all phases of the implementation.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Involved in development of RICE components using SQL, PL/SQL Developer 2000, XML Publisher as per Confidential Applications coding.
• Involved in setups like creating lookups, Profile options, DFF’s and value sets based on the requirement in Confidential Application Object Library (AOL).
• Actively participated in technical review, testing and CRP meetings to assist the cross-functional teams as and when needed.
• Participated in on-going live projects.
• Worked on creating the Pl/SQL objects and scripts as per the client requirements.

Environment: Confidential Applications R12 (12.1.3) (INV, OM, PO, AP, AR, GL, OPM, AOL, SYS ADMIN), Confidential Database 10g, PL/SQL, Toad.

Confidential, Pittsburgh, PA

Team Lead

Responsibilities:

• Development in using Confidential Developer Tools, PL/SQL and related software tools. Work activities include DB Objects development, data validation and analyzing existing processes and procedures, Optimization and Tuning of exiting PL/SQL stored procedures and packages. Optimization of physical data model. Participate as Team member on defined standards and working practices, identify and improve existing functions, prepare technical documentation. Monitors and tracks quality related issues and problems through to resolution.
• Designed and documented the technical specifications of an Interface (MD70) using the available functional specification (MD 50).
• Prepared the conversion strategy and managed Conversions. Involved in identifying the data sources, mapping the data, design and develop the feeder system using SQL*Loader and PL/SQL and implementing the conversion.
• Developed Confidential Process Manufacturing (OPM), Order Management (OM), Payables (AP) and Receivables (AR).
• Developed several concurrent programs utilizing the APIs and created Request sets with several requests to be run at different stages.
• Involved in development of inbound interface custom package to validate and import Order details data into Confidential Applications OM Order interface tables from external system.
• Involved in the Development of Conversions and added new functionalities as per the client’s requirements.
• Worked on Confidential standard API in Confidential Process Manufacturing, Order Management and Inventory modules
• Created SQL* Loader scripts to load data from legacy systems to Confidential Apps.
• Expertise in testing the flow of Order to Cash and Procure to Pay cycles.
• As per the company requirements, created and implemented XML Publisher reports for different products like OPM, AP, AR and OM.
• Customized standard reports like packing slip and pick slip report in shipping module.
• Customized some of the Reports using Xml publisher.
• Worked on performance tuning of various views/tables for better report execution time.
• Created Request Groups and Value sets for reports.
• Developed the AOL forms using the TEMPLATE.fmb and built the code as per the AOL coding standards.
• Involved in Production Support, issue and production ticket resolution, bug fixing & maintenance. Involved in Enhancements, Customization & Performance Tuning.
• Performance Tuning of Custom PL/SQL Packages and Standard Confidential APIs.
• Developed new reports using Report Builder 10g and also customized seeded reports in OPM module.

Environment: Confidential Applications R12 (12.1.3) (OPM, INV, OM, PO, AP, AR, GL, AOL, SYS ADMIN), Confidential Database 10g, Forms10g, Reports10g, PL/SQL, Toad.

Confidential, Irving, TX

Sr.  Application Developer

Responsibilities:

• Worked on the implementation of Confidential EBS R12 modules OM, INV, OPM, O2C and P2P and was involved in all phases of the implementation.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Involved in setups like creating lookups, Profile options, DFF’s and value sets based on the requirement in Confidential Application Object Library (AOL).
• Actively participated in technical review, testing and CRP meetings to assist the cross-functional teams as and when needed.
• Participated in on-going live projects.
• Worked on creating the Custom Forms, Reports, PL/SQL objects and scripts as per the client requirements.

Environment: Confidential Applications R12 (12.1.3) (INV, OM, PO, AP, AR, GL, OPM, AOL, SYS ADMIN), Confidential Database 10g, Forms10g, Reports10g, PL/SQL, Toad.

Confidential, Sunnyvale, CA

Sr. Confidential Application Developer

Responsibilities:

• As a Team Member Involved in Design, Coding & Unit Testing
• Developed the Supplier loading interface scripts.
• Developed the Purchase order (Quotation, Standard, Blanket and Attachments) Loading interface scripts
• Registering Concurrent programs as a part of the project with execution method “SQL*Plus”.
• Involved in the preparation of the MD-70, MD-120& Unit Test Case documents.

Environment: Confidential Applications Release R11i (PO, INV, GL, AOL and Sys Admin), Confidential 10g (SQL, PL/SQL), & TOAD.

Confidential, Weston, MA

Sr. Application Developer

Responsibilities:

• Worked extensively on Confidential R12 Upgrade activities and retrofitment.
• Migrated Form6i to Form10g as per Confidential EBS R12 Standard.
• Migrated Report6i to Report10g as per Confidential EBS R12 Standard.

Environment: Confidential Applications R12 Upgrade (INV, BOM, WIP, OM, PO, WSH, AP, AR, GL), PL/SQL &TOAD.

Confidential, Toronto, CA

Sr. Application Developer

Responsibilities:

• Developed Service Request Interface using PL/SQL
• Developed Install base conversion using PL/SQL
• Developed Customer Conversion using PL/SQL
• Customized Service Request Detail Report using PL/SQL
• Preparation of Technical Design Documents
• Preparation of Unit Test Plans.

Environment: Confidential Applications Release R12 (Field Service, Install Base, AOL and Sys Admin), Confidential 10g (SQL, PL/SQL), & TOAD.

Confidential, Sunnyvale, CA

Sr. Application Developer

Responsibilities:

• Involved in development of RICE components using SQL, PL/SQL Developer 2000, XML Publisher as per Confidential Applications coding/ Customization/ User Interface standards and Coding techniques in Confidential Applications.
• Proficient in development of interfaces and conversion programs to integrate Confidential Applications modules to import data from various sources into Confidential Applications using PL/SQL, SQL*Loader
• Deliver various RICE components specifically Conversion/Interfaces, XML Reports
• Design and Deliver Interfaces between multiple systems using Inbound and Outbound interface.
• Worked on development of Customer facing document such as ‘Order Acknowledgement’, ‘Performa Invoice’ etc.
• Worked on Confidential Sales order Form personalization.
• Translate customer requirements into formal requirements and design technical specifications, establish specific solutions, and lead the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of Technical experience in Confidential ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customers.

Environment: Confidential Apps Implementation Release 11i (11.5.9), Modules: PO, INV, Shipping, OM, AP, AR, GL, SQL, PL-SQL, Forms 6i, Reports 6i.

Confidential, Etobicoke, ON

EBS Developer

Responsibilities:

• Worked on the implementation of Confidential EBS R12 modules OM, INV, AR and CRM and was involved in all phases of the implementation.
• As a Team Member Involved in Design, Coding & Unit Testing.
• Developed the Supplier loading interface scripts.
• Developed the Purchase order (Quotation, Standard, Blanket and Attachments) Loading interface scripts
• Registering Concurrent programs as a part of the project with execution method “SQL*Plus”.
• Involved in the preparation of the MD-70,MD-120,TE-50 and Install Scripts.
• Involved in setups like creating lookups, Profile options, DFF’s and value sets based on the requirement in Confidential Application Object Library (AOL).
• Actively participated in technical review, testing and CRP meetings to assist the cross-functional teams as and when needed.
• Created templates for seeded Confidential report such as Customer Invoice, Purchase order, Request for quotation, Dunning letter.
• Utilized FND REQUEST API to submit concurrent Program from Confidential Report after Report Trigger.
• Developed several new forms using TEMPLATE.fmb & Customized standard forms through custom.pll.
• Worked on form Personalization.
• Unit & System testing for the developed components.
• UNIX shell scripting to move the files between interface directories.
• Worked in Service Contracts, Install Base and order management conversions
• Developed Service Contracts integration and various scripts using PL/SQL for Various operations like: Data validation, Data conversions.
• Participated in on-going live projects.
• Created and Managed Service Requests with Confidential Support in different scenarios, for providing Solutions to the Bugs identified during Production Support. Conducted OWC sessions and resolved various bugs, working in collaboration with Confidential Support.
• Worked on creating the XML Publisher Reports, Confidential Reports, PL/SQL objects and scripts as per the client requirements.

Environment: Confidential Applications Release R12 (Field Service, Service Contracts, Install Base, OM & AR, AOL and Sys Admin), Confidential 10g (SQL, PL/SQL), Forms10g, Reports10g, XMLP, SQL * Loader & TOAD.

Confidential, Fort Worth, TX

EBS Developer

Responsibilities:

• Involved in development of RICE components using SQL, PL/SQL Developer 2000, XML Publisher as per Confidential Applications coding/ Customization/ User Interface standards and Coding techniques in Confidential Applications.
• Proficient in development of interfaces and conversion programs to integrate Confidential Applications modules to import data from various sources into Confidential Applications using PL/SQL, SQL*Loader
• Deliver various RICE components specifically Conversion/Interfaces, XML Reports
• Design and Deliver Interfaces between multiple systems using Inbound and Outbound interface.
• Worked on development of Customer facing document such as ‘Order Acknowledgement’, ‘Performa Invoice’ etc.
• Worked on Confidential Sales order Form personalization.
• Translate customer requirements into formal requirements and design technical specifications, establish specific solutions, and lead the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of Technical experience in Confidential ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customers.

Environment: Confidential Applications Release R11i (PO, INV, Shipping, OM, AP, AR, GL, AOL and Sys Admin), Confidential 9i/10g (SQL, PL/SQL), Forms 6i, Reports 6i, XMLP, SQL * Loader & TOAD.

Confidential, Atlanta, GA

EBS Developer

Responsibilities:

• Wrote scripts in PL/SQL to download data into text files from various tables using DBMS UTL file package and procedures.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Developed PL/SQL Packages, Procedures, Functions for validating the Invoices and Payment information from the legacy system and imported into Confidential Application using the Payables Open Interface Import program (AP) and populated the base tables.
• Created a PL/SQL package to consolidate multiple invoices (orders) to print on a single invoice based on the PO number in order to mimic the original customer PO.
• Responsible for converting all the PO vendors, vendor sites and vendor contacts into Production.
• Wrote CV40, MD50, MD70 documents, design and develop conversion routines, staging tables, PL/SQL API’s for Converting Suppliers, Supplier sites, Open Purchase Orders (PO).
• Performed Extensive Application Tuning for order to cash business process.
• Developed Order Management, Inventory, Pricing queries to compare summary information of the standard and custom reports
• Designed and developed ad-hoc Confidential Discoverer workbooks and reports and also trained the End Users.

Environment: Confidential Applications Release R12 (PO, AR, AP, GL, AOL and Sys Admin), Confidential 9i/10g (SQL, PL/SQL), Forms 6i, Reports 6i, Discoverer Reports, XMLP, SQL * Loader & TOAD.

Confidential, Pasadena, CA

Tech Lead

Responsibilities:

• Created templates for seeded Confidential report such as Customer Invoice, Purchase order, Request for quotation, Dunning letter.
• Utilized FND REQUEST API to submit concurrent Program from Confidential Report after Report Trigger.
• Developed several new forms using TEMPLATE.fmb & Customized standard forms through custom.pll.
• Unit & System testing for the developed components.
• UNIX shell scripting to move the files between interface directories.

Environment: Confidential Applications Release R12 (PO, AR, AP,GL, AOL and Sys Admin), Confidential 10g (SQL, PL/SQL), Forms 10g, Reports 10g & TOAD.

Confidential, Mason, OH

EBS Developer

Responsibilities:

• Assisted in creation of table spaces, tables, and indexes.
• Creation of Users, Passwords and Roles and Front-end design using Developer 2000.
• Used features like procedures, functions, packages, database triggers in PL/SQL.
• Loaded data into Confidential tables using SQL*Loader.
• Registration of new forms, Creation of concurrent executable and concurrent programs for reports, Opening up Descriptive Flex fields.
• Developed PL/SQL scripts to load order data from external system to OM interface tables.
• Troubleshooting of the Order Management (OM/ONT), and Inventory (INV) modules within Confidential Applications.
• Development of Confidential Order Management Inbound interface to load massive amount of Open Purchase Orders Programmatically by running user-friendly concurrent programs.
• Created a PL/SQL package to consolidate multiple invoices (orders) to print on a single invoice based on the PO number in order to mimic the original customer PO.
• Responsible for converting all the PO vendors, vendor sites and vendor contacts into Production.
• Developed reports in AP and AR modules using Reports 6i.
• Performed Extensive Application Tuning for order to cash business process.
• Developed Order Management, Inventory, Receivables, Shipping, Warehouse Management, Pricing queries to compare summary information of the standard and custom reports.

Environment: Confidential Applications Release R11i (PO AP, OM, INV, AOL and Sys Admin), Confidential 9i (SQL, PL/SQL), Forms 6i Reports 6i, SQL*Loader & SQL Plus.