SUMMARY:

• 8 years of experience as Oracle Applications Consultant in Implementations, Upgrading and Supporting of Oracle E-Business Suite (Oracle Applications Manufacturing and Financials).
• Proven Techno-Functional skills in all aspects of software development Life Cycle, Conversion, Testing, Installation, Support, troubleshooting and enhancements.
• Good expertise in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow, OA Framework) components, Integrating with 3rd party products to Oracle Applications.
• Working Knowledge in Oracle Applications (E-Business Suite 11i/R12) General Ledger (GL), Accounts Payables(AP), Accounts Receivables(AR), Fixed Assets (FA), Oracle Inventory (INV), Oracle Procurement(PO), iProcurement, Shipping (WSH), Order Management(OM), Oracle Advanced Supply Chain Planning, Oracle Advanced Pricing, e-Commerce Gateway(ECE) Trading Community Architecture (TCA), HRMS, BOM, WIP, Warehouse Management System(WMS), Oracle Product LifeCycle Management(PLM), System Administration, Application Object Library, and Oracle Alerts.
• Well Versed with the various versions of Oracle Applications viz. R12/11.5.10/11.5.9/11.5.8 /11.5.7/11.0.3.
• Worked extensively and has strong experience in the Oracle Application E-Business Suite development tool-set (Oracle 8i/9i/10g, SQL*Plus, PL/SQL, Developer 2000, Developer 6i (Forms and Reports), Jdeveloper 10g, Discoverer 4i/10g, TOAD, XML Publisher, Shell Scripting, Forms Personalization, Form Customization(CUSTOM.pll), Customizing and Developing Workflows and using Oracle Applications API’s).
• Performed various roles like Team Leader, Lead Developer, Analyst and Developer.
• Working knowledge in Performance tuning of the database using utilities like Explain plans, TKPROF.
• Good Knowledge of Implementation Methodologies like AIM (MD200/MD60/70/120, BR100, TE50, Process Documents)
• Excellent communications and interpersonal skills. Well versed in gathering requirements from customers/clients. Conversant with Project Management and Quality procedures and working with Oracle Support, Creating Service Requests, and Visual Safe Source to maintain source code.
• Worked in 10+ projects that spread across New Implementations, Upgrades, Conversion, Production Support and Rollouts of Oracle E-Business Suite 11i
• Has more than 3 years of overseas experience with various clients in USA, UK, Australia, UAE, Qatar, Bahrain and Jordan.
• Experienced in Customization and development of new Forms and Reports.
• Possess excellent communication skills and a smooth client handling and interaction experience.
• Strong proficiency in problem solving, Initiative taking and Time management.

CAPABILITIES:

• Extensively worked on Forms 4.5/6i and Reports 2.5/6i, Discoverer 4i/10g, WorkflowBuilder 2.6
• Expert in Developing Alerts, Custom Forms, Interfaces, Reports, APIs, ConversionPrograms
• Expert in Customizing Standard Forms, Reports and Workflows.
• Expert in Developing XML Publisher Reports.
• Worked with Oracle Business Intelligence Enterprise Edition (OBIEE)
• Personalization of Core Forms
• Worked with SQL*Loader, FNDLOAD
• Worked extensively in SQL, PL/SQL, UNIX, Sun Solaris, Linux and Shell Scripts usedfor Scheduling purpose.
• Well Experienced in various versions of Oracle Database (Oracle 7.3/8/8i/9i/10g)

WORK EXPERIENCE:

Confidential,MI, USA Aug, 2009 Present
Role: Senior Oracle Applications Consultant
Environment: Support and extensions of R12 Implementation.
Modules: General Ledger, Accounts Payable, Accounts Receivable, Inventory, Purchasing, Order Management, Advanced Product Catalog(Product Lifecycle Management), Order Management, Bills of Materials, Advanced Supply Chain Planning
Responsibilities:

• Responsibilities include production support, bug fixing, enhancements to existing reports and interfaces, developing new reports and interfaces, coordinating with business team and providing customized solutions, technical design, development and support business processes.
• Worked on iProcurement to add custom validations to check the charge accounts being used during the requisition creation process and default the charge account based on the business rules.
• Customized the Requisition Approval Notification through OAF personalization to show the charge account.
• Configured the Advanced Product Catalog(PLM) by creating new attribute groups and attaching them to item pages.
• Created import formats and imported item information through WebADI process.
• Customized the item creation process to automate some of the steps through OAF personalization to default field values, assign new item to child organizations and attach inventory item category.
• Modified the PLM new item creation workflow to change the header message of the reminder notification to show custom PLM attributes.
• Worked on components reports and interfaces related to the Order to Cash and Procure to Pay cycles.
• Worked on the Bursting functionality of the XML Publisher to send the output of a concurrent program as an attachment to a mail id.
• Developed Shell script to migrate components from Non-Prod instances to Production
  instance.
• Worked on Performance Tuning to increase the performance of the Label Printing programs and the Long term sales forecast reports.
• Worked on development of new reports using Reports 6i, XML/BI Publisher and Discoverer 10g
• Developed Custom reports for the Advance Supply Chain planning analysis like WIP Consolidated Supply Details Report Daily, WIP Consolidated Supply Details Report Weekly, Inventory On hand Days availability reports.
• Extensively worked on debugging and fixing productions issues in reports and interfaces.
• Worked with the end users to analyze the Business requirements and with Functional team to develop the MD50 documents.
• Documented all my work in the form of MD50, MD70, MD120 documents and Unit testing scripts.
• Improved the performance of existing reports by performance tuning the SQL and PL/SQL scripts.
• Developed the Container Relabel Program to re-print labels.
• Developed Consolidated Supply variance details report, Finished goods shortage report, Long term forecast report and Weekly Sales Forecast Report.
• Customized the WIP Job Instruction Report
• Involved in creating Installation documents and various test cycles.
• XML Publisher Reports Developed:
• OM Scheduled Shipping Report Weekly
• WSH ST Backorder Report
• US Purchasing Commodity Spend Analysis Report
• QA Collection Data Plan Export
• Purchasing Diversity Spend Report
• FND Responsibility or User Activity by Form
• Outdated Forecast Sets
• BOM Change Report
• PO Commodity Spend Analysis Report
• AR Aging Buckets Report (7 Buckets)
• Commercial Invoice Report
• Pro-forma Invoice Report
• Provided migration scripts for moving deliverables to Productions using FNDLOAD and Shell Scripts.

Confidential,MI,USA Sep, 2008 Jul, 2009
Role: Senior Developer and Analyst
Environment: Implementation of Oracle Applications 11.5.10, PL/SQL, Forms/Reports 6i, Discoverer 10g, Workflow Builder 2.6
Modules: General Ledger, Accounts Payable, Accounts Receivable, Inventory, Purchasing, Order Management,Bills of Material, Work in Process
Responsibilities

• Responsibilities included gathering the requirements, coordinating with business team and providing customized solutions, technical design, development and support business processes.
• Involved in requirement gathering, analysis and functional setup of Procurement Card Setup
• Developed a custom interface program to automate the process for validating and importing Procurement card transactions to Oracle Payables, create invoices, validate the invoices and automatically pay the invoices grouped by employee.
• Used Auto Invoice to Import Regular, Debit memo, Credit memo invoices from legacy system to Account Receivable tables using Auto Invoice import program
• Developed a custom interface to create internal requisitions for all the sales orders with no reservations.
• Developed a custom interface to complete WIP Assembly jobs (flow schedules and work order less completions).
• Defined Descriptive flex fields necessary for report and form customizations
• Worked on importing Sales Orders Using API’s and Order Import Open Interfaces in Order Management
• Developed a custom OAF page based on custom table for users to query and see data.
• Developed Custom Programs to Validate, Load and Import the following.
• Item Import
• Open Purchase Orders
• Inventory Transactions
• Import Suppliers and Supplier Sites
• Import BOM Bills of Material and Routings
• Import AP Invoices.
• Import AR Invoices
• Developed/Customized the following XML Publisher reports.
• Purchase Order Report
• Packing Slip Report
• Packing List Report
• AR Invoice Report
• Sales Order Acknowledge Report
• AR Proforma Invoice Report
• Job Sheet Report
• Customized the following reports
• Pick Slip Report
• Packing Slip Report (Standard report customized to include bar codes)
• Packing List Report (Standard report with full layout as per client requirement)
• Orders by Item Report
• Order Detail & Summary Report
• Developed the following outbound extract programs using UTL_FILE package
• Job Sheet Report(explode BOM and shown the data with operation sequences and order attachments)
• Flow Schedule Report
• EFT for check payments in payables
• Bank Reconciliation
• Sales Order Extract
• Purchase Order Extract
• Created Technical Design Documents based on the Specs and User Requirement

Confidential,Bahrain Mar, 2007 Aug, 2008
Role:Technical Lead and Onsite Coordinator
Environment: Implementation of Oracle Applications 11.5.10, PL/SQL, Developer 6i, Discoverer 4i, Workflow Builder 2.6
Modules: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Warehouse Management System, e-Commerce Gateway, Inventory, Purchasing, Order Management
Responsibilities:

• Responsibilities included gathering the requirements, coordinating with functional team and offshore team and providing customized solutions, technical design, development and support business processes.
• Involved in requirement gathering, analysis and functional setup of e-Commerce Gateway module.
• Setup the e-Commerce Gateway 850 Inbound, 810 Outbound and 832 outbound processes through customizations wherever required.
• Worked with a third party system to capture the field mappings between the EDI file format needed by Oracle e-Commerce Gateway and the legacy file format.
• Involved in the development of Custom Form for Landed cost solution for PO Receipts
• Developed a Custom Form to capture the Inventory Item and price details to generate an EDI file for outbound price catalog.
• Defined forms personalization to enforce complex business rules.
• Customized Sales Order form and Sales Order quick entry forms to hide and show fields based on the responsibilities using Forms Personalization.
• Developed Interface programs to import AP Invoices, AR Invoices and Item Information from legacy system.
• Customized the AP Check Printing Report and Publish Journal Voucher report.
• Customized the Item Quantities Summary report to include the Inventory Org Code and Subinventory.
• Customized Requisition workflow to show the charge account to the approver.
• Customized the Order Line workflow to put the order on hold if the order quantity exceeds the forecast quantity immediately after booking, but before pick release
• Developed Custom Programs to Validate, Load and Import Import GL Journals,Item Import,Purchase Requisitions,Inventory Opening Balances(including LPN ,created using API),Import Customers,Import Price List using API.
• Built Discoverer End User Layer, Business Areas and folders for custom report development.
• Worked extensively on Discoverer 10g reports and BI Publisher reports.
• Defined Modifiers and Qualifiers for the Advanced Pricing Module.

Confidential,Qatar Dec, 2006 Feb, 2007
Role: Lead Developer
Environment: Oracle Applications 11.5.10, PL/SQL, Developer 6i,
Modules: General Ledger, Accounts Payable, Accounts Receivable, Inventory, Purchasing, HRMS.
Responsibilities:

• Responsibilities included design and development of reports, stored procedures, packages and Data Migrations using PL/SQL
• Developed PL/SQL packages, procedures and functions to migrate the data from legacy systems for Inventory Items, Standard Purchase Orders and Material Transactions.
• Customized the Item Quantities Summary report, Customized the “Standard Check Printing Report”.

Confidential,UAE Sep, 2006 Nov, 2006
Role: Developer
Environment: Oracle Applications 11.5.10, PL/SQL, Developer 6i
Modules: Oracle Inventory module
Responsibilities

• Responsibilities included design and development of reports, stored procedures, packages and interfaces using PL/SQL
• Developed interfaces for Inventory Items, Material Transactions from third party system called MAXIMO.
• Developed the several custom reports for Inventory Module.
• Prepared technical design documents and wrote MD70, MD120, Unit Test Cases and Test Plans for the following deliverables

Confidential,UAE Mar, 2006 Aug, 2006
Role: Onsite Analyst and Lead Developer
Environment: Oracle Applications 11.5.10, PL/SQL, Developer 6i, Workflow Builder 2.3
Modules: GL, AP, AR, INV, PO, HRMS, Uniform Management System
Responsibilities:

• Responsibilities included gathering requirements, solution design and development of Custom Bolt on module called Uniform Management System integrated with Oracle Applications.
• Developed the following Custom forms
• Uniform Entitlement Definitions
• Uniform Requisitions
• Uniform Transactions
• Uniform Requisition Summary (includes query find window)
• Uniform Transactions Summary (includes query find window)
• Uniform Points History
• Developed Custom Workflow for the Uniform requisitions form to manage the approvals for the requisitions raised by the users.
• Developed custom reports like Employee Entitlement History, Employee Points History, Uniform Transaction History
• Developed migrations scripts to migrate the existing data to the new module built.

Confidential,UK Oct, 2005 Mar, 2006
Role: Developer
Environment: Oracle Applications 11.5.9, PL/SQL, Developer 6i, Discoverer4i
Modules: (GL, AP, AR, HRMS, IGS).
Responsibilities:

• As a developer worked on the enhancements and new requirements.
• Developed interface program for uploading the Student grades.
• Create business areas for Discoverer reports.
• Developed custom discoverer reports and shared them to users.

Confidential,Jordon Feb, 2005 Sep, 2005
Role: Onsite Analyst and Developer
Environment: Oracle Applications 11.5.10, PL/SQL, Developer 6i, Workflow Builder2.6
Modules: Oracle Inventory, Order Management, Oracle Receivables, Point of Sales
Responsibilities:

• Responsibilities included gathering requirements, solution design and development of Custom Bolt on module called Point of Sales integrated with Oracle Applications.
• Developed Custom Form called Dealer Sales to capture the sales orders of all the Dealers. Developed Custom workflow called Dealer Sales Workflow for approvals, which is triggered from the Dealer Sales form. This workflow uses the PO Approval Hierarchy for sending notifications. Developed Custom reports for Point of Sales Module.
• Developed AR auto invoice interface which is submitted through the Dealer Sales workflow based on the approval status.
• Developed the Inventory Transaction interface to deplete the inventory once the dealer sales order is approved.

Confidential,UK Jan, 2004 Jan, 2005
Role: Developer
Environment: Oracle Applications 11.5.9, PL/SQL, Developer 6i, Discoverer 4i,Workflow Builder2.6
Modules: (GL, AP, AR, PO, PA, INV, HRMS, Subcontractor)

Responsibilities:

• Involved in the development of Custom bolt on module called Subcontractor.
• Designed and developed customs forms like Contract Valuation, Subcontractor Timesheet entry and Certificate of Payment forms.
• Developed interfaces programs to interface the data from the custom forms into AR, AP and PA modules
• Developed custom Discoverer reports.
• Defined Descriptive flex fields necessary for report and form customizations, and distribution sets
• Developed PL/SQL Packages, procedures and functions for validating the data from existing systems and migrate to the oracle applications production instance.
• Used FND_LOAD scripts to move object/program definitions from once instance to another.

Confidential,USA Mar, 2003 Jul, 2003
Role: Developer
Environment: Upgrade of Oracle 11.0.3 to 11.5.8, PL/SQL, Developer 6i
Responsibilities:

• Responsibilities included preparing technical design document, documenting change history
• Executing the programs in 11.0.3 and 11.5.8 instances and comparing the results.
• Modify the reports, forms, PL/SQL packages and SQL * reports as per the table and view level changes.

Confidential,USA Sep, 2002 Feb, 2003
Role: Developer
Environment: Upgrade of Oracle 11.0.3 to 11.5.8, PL/SQL, Developer 6i
Responsibilities:

• Responsibilities included preparing technical design document, documenting change history
• Executing the programs in 11.0.3 and 11.5.8 instances and comparing the results.
• Modify the reports, forms, PL/SQL packages and SQL * reports as per the table and view level changes.

EDUCATION:

• Master of Computer Applications from Confidential,University
• Bachelor of Computer Sciences from Confidential,University