SUMMARY:

• Having 12 years of experience as a technical consultant in Application Design, Development, Customization,Upgrade,Maintenance and Support of Oracle Applications E - Business Suite 11i and R12
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Supply Chain Management (PO, OM), Manufacturing (INV, WIP, BOM,ECO), Financials (AP, AR, FA,SLA,GL,CM), ), Project Accounting (PA)
• Involved in full life cycle implementations, Maintenance and support of Oracle Applications EBS R11i and R12 in various modules.
• Having technical expertise in SQL, PL/SQL, and Oracle Developer Forms & Report Builder, Workflows 2.6, Oracle Application Framework (OAF), Desktop integrator (WebADI), BI/XML Publisher, Forms Personalization, Discoverer and CUSTOM.pll.
• Experience in developing new RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) components. Experience in developing Inbound and Outbound Interfaces using Standard Open Interfaces, Oracle Public API’s and CEMLI components of Oracle Applications.
• Possess good knowledge on the AIM-Documents like BR-100, MD-050, MD070, CV040, CV060 and User Training manual and TE-020 with hands on expertise in process mapping, GAP Analysis, functional design.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.
• Supported quarterly releases, data fixes, patch analysis and resolving issues on priority basis.
• Handled implementation and Maintenance Support of Oracle application (R12) related to Supply Chain and Financial modules like Purchasing order, Oracle Inventory and Order Management, Account Receivables, General Ledger, Account Payables etc.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications
• Excellent understanding of Order to Cash (O2C), Procure to pay (P2P) business cycles an Inventory Management.
• Provide solutions on a daily basis with regards to Oracle technical and functional issues to the end users.
• Has very good experience in Requirements gathering, Design, and Development, Testing, Go-live preparation, Go-live, Post live support and training.
• Significant experience in migration from oracle 11i to Oracle R12
• Has very good experience in customizing existing OAF Screens, FORMS and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.

TECHNICAL SKILLS:

EBS: Oracle Applications 11.5.9, 11.5.10.2,12.0.3,12.1.3,12.2.3

Modules: General Ledger, Payables, Receivables, Purchasing, Inventory, Order Management, Bills f Material and Work in Process, Oracle Alerts, Application Developer, Enterprise Asset Management Project Accounting, Supply Chain Management (SCM)

Software/Tools: TOAD, SQL Loader, SQL Optimizer, WEBADI, EDI, D2K, Discoverer 4i, SQL, PL/SQL, OAF,SQL Loader and Data Loader, 10.3, Clear case, BMC, Remedy, kintana, JDeveloper9i,10g,11g and 12c, Winscp3, Putty

Languages;: JAVA, C, C++, SQL, PLSQL

Forms & Reports: Forms 6i/10g, OAF, Reports 10g/6i, XML Publisher, BI, Discoverer

Databases: Oracle 10g/8i/9i

Operating Systems;: DOS, Win 2003/Vista/XP/NT/2000/98/95, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Technical Consultant /Development

Responsibilities:

• Developed Item, BOM and ECO interface to import data from Oracle to SAP according to the business requirement
• Developed PTD, YTD, QTD Custom Financial Statement Generator (FSG) reports for balance sheets
• Designed and developed Intercompany accounts maintenance form
• Created triggers to update trading partner number on journal tables from various sources (Purchase Order, Payables, Receivables and Inventory)
• Developed Purchase Order outbound interface to export data from Oracle to SAP.
• According to the business requirement developed PTD, YTD, QTD Custom Financial Statement Generator (FSG) reports for Income statements.
• Developed an item outbound interface to export from Oracle to SAP.
• Developed Purchase Orders interface to import data from SAP to Oracle according to the business requirement
• Developed UNIX Shell scripts to copy flat file from External Server to Oracle UNIX Server using FTP and automated archiving and encryption.
• Developed custom form to upload files to server and prepared SQL*Loader to load data into staging tables.
• Responsible for Configuration/Setup, testing, maintenance and support of custom components.
• Prepared functional/technical design for development and supported unit and system testing

Environment:: Oracle 9i Database, Oracle Apps R12 (12.1.1), Kanata - Version Control, PL SQL Developer, TOAD, Discoverer, forms, reports and Workflow Builder

Techno-Functional Consultant

Responsibilities:

• Worked on AR Data Conversion for Receipts, Reverse Receipts, Adjustments, Reverse Adjustments and Receipt Write off using API’s Feasibility checks and Impact Analysis w.r.t to technical during upgrade from 11.5.10.2 to 12.2.3

• Retrofitted custom AP supplier, PO, AR, interface programs in 11i to fit in R12.
• Preparing the documents on data flow between PO, AP and GL.
• Custom program to calculate period end and Period average rate for GL Daily Rates Interface.
• To identify the process improvements in clients’ business and suggest enhancements by means of customization of reports, and interfaces.
• Developed update and backup scripts (Data fix) as per the business requirement.
• Involved in end-to-end rollout including requirements gathering, technical design, analysis, development, testing, implementation and go-live support.
• Retrofitted Requisition Workflow according to R12.
• Involved in design, development and testing of Employee Creation and Employee Address creation API, Employee Termination API, Employee Address Update API, Employee Assignments API, conversion & Interface
• Worked on business events when Triggered R12 GL interface program whenever GL posted in 11i
• Customized OAF I-procurement checkout page to display item category filed and allow users to change item category during checkout
• Developed custom OAF pages to active and deactivate employees in HRMS.
• Customized PO Workflow (POAPPRV) to send PO PDF for Punch-out Vendors.

Environment: Oracle Apps Implementation Release R12 (12.1.3), Modules: SQL, PL-SQL, Forms 10g, Reports 10g, and discoverer, Putty, Winscp 3 and UNIX.

Confidential

Techno-Functional Consultant

Responsibilities:

• Involved in design, development and testing of Order Management related FSO(forecast Sales orders), BSO (Buffer Sales Order) conversion & Interface

• Development of New Reports (Report to print item, item description, order information, Customer information, Order Status, Lot details, UOM. Report to print the amount details, item details, Status details of the Order based on conversion rates. Report that shows the RMA Details for a certain period.
• VO extension for ship to location lov in I-Procurement and Buyers Work center.
• Involved in design, development and testing of ATP related conversion & Interface
• Performed setups like Item assignment to Locator/Sub inventory, creating new responsibilities, assigning responsibilities to holds in OM.
• Analyzed, designed and developed the Item Cross Reference conversion program for importing data from legacy systems into Oracle.
• Communicating with client /onsite functional personal on business requirements.
• AP Aging report - Customized standard report to meet client requirement.
• Developed Separate Remittance configuration for Vendors and Individual contractors.
• Retrofitted Purchase order print Form
• Created Periodic Alerts for AP Invoice Custom Validation program and Payable Open interface programs when invoice got struck.

Environment: Oracle Apps Implementation Release R12 (12.1.3), Modules: PO, AP, INV, OM, SQL, PL-SQL,Forms 10g, Reports 10g, and discoverer, Putty, Winscp 3 and UNIX.Arrow Electronics

Confidential

Techno-Functional Consultant

Responsibilities:

• Actively handling Order Management Shipping Production issues in areas like stuck SO lines, Workflow issues, RMAs, Pick Release, Pick slip Shipping documents, Adjustments maintaining setups.

• Created Periodic Alert to notify users when Department is added/removed to Approver.
• Created Form Personalization to throw error for Duplicate Invoice for same Supplier and different site.
• Created Periodic Alert to notify INPROCESS Requisition over a week and Workflow error.
• Customized Arrow Finance and Department Form to add/remove Departments for Approver.
• Renamed all 11i Responsibility and End Dated Responsibility by using PL/SQL Script.
• Handled Production Support in I-Expense, PO, AP, IBY, Alert issues.
• Ran GDF to identify data corruption like unable to cancel invoice, unable to match credit memo to PO line.
• Extended Customer VO in customer site level to handle custom validations.
• Enhanced Sales Order Acknowledgement and pick list Reports.
• Developed sub inventory Interface.
• Created 20+ XML reports as per business requirement (PO end to end report, PO history report, check printing (IBY)

Environment: Oracle Apps Implementation Release R12 (12.1.3), PL-SQL, workflow, Forms 10g,Reports 10g, discoverer, Putty, Winscp 3 and UNIX.

Confidential

Techno-Functional Consultant

Responsibilities:

• Developed Asset Group, Asset Number, Meter, Meter Reading Conversion Programs.

• Implemented Requisition workflow for EAM orders
• Worked on PO, Requisition Extensions and Requisition alert
• Developed routing and operational attachments Conversion Programs.
• Developed RFQ Print report by using XML Publisher and Email bursting.
• Developed EAM Work Order Print report.
• Involved in the development of Custom Shipping form to show the Registration details, registration details with respect to PO and also capture lot of other user entered data in the custom form.
• Preparing Technical Documentations
• Developed SQL*LOADER program and written PL/SQL package for validations.

Environment: Oracle Apps Implementation Release R12 (12.0.6), SQL, PL-SQL, Forms 10g, Reports 10g, discoverer, Putty, Winscp 3 and UNIX.

Confidential

Technical Consultant

Responsibilities:

• Worked on Sales Orders, Price list, Supplier and supplier Bank, Bank Branches conversion.

• Provided mapping document and developed PL/SQL packages for program that extracts and generate a flat file with the information from Third Party. Automate the data load process from Third party by scheduling a concurrent program.
• Prepared data templates and Technical Documentations for Customer, Purchase Orders, Suppliers and item cost
• Developed SQL*LOADER program and written PL/SQL package for validations.

Environment: Oracle Apps Implementation Release 11i (11.5.10.2), SQL, PL-SQL, Forms 10g, Reports 10g, discoverer, Putty, Winscp 3 and UNIX.

Confidential

Technical Consultant/R11.5.10 Rollout

Responsibilities:

• Developed inbound interface in Inventory module to upload the Item Details from the flat file to Oracle Apps base tables using the Item Import Open interface.

• Developed inbound interface in Inventory module to upload the Item cross reference, and MFG, MFG parts and Conversion from the flat file to Oracle Apps base tables.
• Developed SQL*LOADER program and written PL/SQL package for validations.
• Preparing CV 60 Technical document as per the client methodology.
• Involved in extensive unit and system testing activities. The testing involved in functional and performance testing.

Environment: Oracle 9.2.0.5.0 Database, Oracle Apps 11.5.10, PL SQL Developer, Discoverer, Report Builder 6i (for developing custom reports), Form Builder 6i (for developing custom forms)

Confidential

Senior Software engineer

Responsibilities:

• Discoverer10g reports, XML Reports 10g and Forms10g.

• Analyzed, designed and developed the Open Purchase Orders Conversion for importing data from legacy systems into Oracle Interface tables.
• Analyzed, designed and developed PO interface to upload the purchase Order data From legacy to PO Base Tables by using SQL*LOADER, PL/SQL Package and Standard purchase Order open interface Import Concurrent Program.
• Analyzed, designed and developed the supplier conversion, Purchase Order, Banks, Bank Branches, Bank Accounts, Bank Account Uses program for importing data from legacy systems into Oracle.
• Analyzed, designed and developed the EAM conversion programs for importing data Asset Activity Associations, Asset Attribute Conversions, Meter reading from legacy systems into Oracle.
• Involved in extensive unit and system testing activities. The testing involved in functional and performance testing.
• Created in the product technical documentation.
• Analyzed, designed and developed Projects, Events and tasks for importing data from legacy systems into Oracle.
• Worked on the technical design and development of GL Interface, Items Conversion, Asset Activity Conversion Program for importing data from legacy systems into Oracle
• Analyzed, designed and developed the Employee Creation and Employee Address creation API, Employee Termination API, Employee Address Update API, Employee Update API, Employee Assignments Conversion Program

Environment:: Oracle 10g Database, Oracle Apps 12.0.0, PL SQL Developer, TOAD, Forms and Reports 10g, XML Reports, Discoverer, Workflow Builder

Confidential

Senior Software engineer

Responsibilities:

• Coding - To implement the business solution design as per technical specification.

• Testing - Testing the solution implemented during coding phase to ensure that it meets the business expectation.
• Actively handling Order Management Shipping Production issues in areas like stuck SO lines, Workflow issues, RMAs, Pick Release, Pick slip Shipping documents, Adjustments maintaining issues.
• Involved in customized development of SGP Organization setup.
• Developed and customized OM reports and interfaces
• Testing - unit testing, integration testing and acceptance testing.
• Writing Unit Test Cases and Unit Test Results
• Involved in all types of Apps related work like forms, reports, coding using API .
• Also working in AMAT internal tools like ACR (ACCES Change Request), Kintana (This tool is used for code migration).
• Resolved many cases logged by users as a part of Day-to-Day support.
• Developed enhancements in the code to suite the business requirements and documented the same.
• Analyzing the root cause of the issues and fixing them permanently.
• Effectively interacted with the end users to resolve the issues quickly.
• Developed and customized OM forms( Ex: Price Adjustable, Maintain and specific Customer Price List access)
• Involved in offshore maintenance and support of Oracle Apps.
• Dealt with issues regarding PO, OM, INV, WIP, BOM, MRP and Custom Modules (MSM, P2P) in Oracle.
• Responsible for development of pl/sql programs and Customization of reports and forms

Environment:: Oracle 9i Database, Oracle Apps 11.5.10 Kanata - Version Control,PL SQL Developer, TOAD Discoverer Report Builder 6i (for developing custom reports) Form Builder 6i (for developing custom forms) Workflow Builder

Confidential

Senior Software engineer

Responsibilities:

• Analysis of the Functional Specification Documents specified by client, providing estimates for the same.

• Designing Technical Design Documents based upon the Functional Specification documents provided by the client. Development of customizations as per the requirements.
• Involved in technical design & development of GL Inbound Interface & GL Inbound Validation Form.
• Involved in the development of Standard Purchase Orders Conversion Program.
• Involved in the development of RDF reports (Outstanding Items PO not created). This report will list all the approved requisition lines, which are pending action by the buyer.
• Involved in the development of discoverer report (Shipping Costing Report for Shipping PO Creation).
• Preparation of Technical Design document for the enhancements
• Prepared the code review checklists and Unit test review documents

Environment: Oracle 9.2.0.5.0 Database, Oracle Apps 11.5.10 Kanata - Version Control, PL SQL Developer, TOAD Discoverer Report Builder 6i (for developing custom reports) Form Builder 6i (for developing custom forms) Workflow Builder

Confidential

Programmer

Responsibilities:

• Customized SOWB and Service Information forms of OM module

• Unit Test Cases and Unit Test Results.
• Involved in all types of Apps related work like forms, reports, coding using API and setup related things.
• Analysis of the requirement provided by the clients and transforming them in to functional and Technical specification
• Coding - To implement the business solution design as per technical specification.

Environment:: Oracle 9.2.0.5.0 Database Oracle Apps 11.5.10, TOAD Report Builder 6i, Form Builder 6i

Confidential

Programmer/ Oracle Apps implementation

Responsibilities:

• Developed several reports based on user special criteria using Reports 6i.

• Developed a customized program for inventory aging report
• Development of PL/SQL packages and procedures for data conversion.
• Developed purchase requisitions report.
• SQL*Loader control file to transfer data from flat file to pre Interface tables

Environment:: Oracle 9.2.0.5.0 Database Oracle Apps 11.5.10, TOAD Report Builder 6i, Form Builder 6i