PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Oracle applications in Design, Implementation, Customization and up gradation of Manufacturing, Distribution, Supply Chain, and Financials modules as an Oracle Applications Developer.
• Strong Experience in all the phases of SDLC right from requirement gathering, POC, Design, Development, SIT and UAT.
• Expert in Oracle Development Tools, Technologies and Oracle E - Business Suite (Oracle Applications) RICE ranging the different versions of oracle applications from version 11.5.8 to 11.5.10, R12 (12.1.3) and R12 (12.2.3)
• Worked extensively in Oracle Applications R12/11i implementation, enhancement & customization of various modules.
• Accounts Receivables (AR)
• Accounts Payables (AP)
• General Ledger (GL)
• Sub ledger Accounting (SLA)
• Fixed Assets (FA)
• Order Management (OM)
• Shipping (WSH)
• Bill of Materials (BOM)
• Work in Process (WIP)
• Oracle Inventory (INV)
• Oracle Payments (IBY)
• Purchasing (PO)
• Work flow Development
• Oracle Complex Report Development
• Oracle Complex Forms development
• Data Conversions in (AP, AR, GL, INV,PIM OM, PO, BOM,FA, WIP)
• XML Reports / BI Publisher
• Personalization (Forms/ HTML Pages)
• SQL Loader / Shell Scripting / Unix / PLSQL
• TOAD / SQL developer / WF builder
• Strong working knowledge of business flows like Order-to-Cash (O2C) and Procure-to-Pay (P2P) and Drop Ship along with the dependencies and relationships between Oracle Applications modules.
• Knowledge and Experience in concepts of TCA(Trading Community Architecture), AOL(Application Object Library) and MO(Multi Org).
• Expert level knowledge and experience in developing objects for implementation and upgrade in Oracle Applications.
• Involved in 1 complete system development life cycle projects and 1 production support projects having analytical skills necessary to satisfy development, testing documentation, and Change Management requirements.
• Expertise in Translating functional specifications into technical specifications for development of Oracle Applications R12 extensions, modifications and integrations including system interfaces, reports, data conversions (Customers, Suppliers, Item Master,PO)and custom extensions.
• Proficient in developing Forms and Reports using Oracle Forms 6i, 10g Reports 6i, 10g Discoverer 10g/4i, BI Publisher, Oracle Applications Express(Oracle APEX), Jdeveloper, Oracle Application Framework(OAF). Deploying them to various instances, coordinating with DBA’s and testing analysts
• Expertise in developing packages, procedures, functions, database triggers, interfaces and data Conversion using PL/ SQL, SQL * Plus and SQL* Loader.
• Sound knowledge on Systems Integration, Interfaces and Conversions between Oracle Applications and legacy systems, Customizations of Oracle Financials modules and Development of Custom Oracle modules/applications.
• Worked extensively on preparing AIM documents like MD020, MD060, MD070 and CV040s
• Expert in Data Conversion of Item Categories, Item Relationships, Cross references, Item Cost conversions, Item Conversion for PIM, Customer Conversion, Supplier Conversion, External Banks Conversion and assignment etc
• Developed custom pick lease form (Order Management),custom pick confirm form (Order Management).
• Developed program to assign item to child inventory org and restricting sub inventories.
• Developed Oracle Alerts for MFG system to send email notifications and Customized AP Check Printing Report.
• Coordinated with the Development Team to identify product gaps by creating SRs and ERs to resolve various issues and well experienced in working.
• Highly experienced with personalization without effecting the standard Oracle featured based on requirement.

TECHNICAL SKILLS:

ORACLE APPLICATIONS: Oracle Applications R12 (12.1.3)/11i e-Business Suite, Oracle Order Management (OM), Oracle Receivables (AR), Oracle Inventory (INV),Oracle Payables (AP), Oracle Purchasing (PO), Shipping Execution, Fixed Assets (FA)Oracle General Ledger (GL), Application Objects Library (AOL).

RDBMS: Oracle 11g/10g/9i/ 8i and MS-Access.

GUI’s: Forms 10g/6i, Reports10g/6i, Discoverer 4i/10g, BI Publisher 5.6Oracle Workflow 2.6.

LANGUAGES: SQL, PL/SQL.

TOOLS: PL/SQL developer, Oracle Enterprise Manager, TOAD, Forms BuilderReports Builder.

OPERATING SYSTEMS: Windows NT/2000/98/95, UNIX, HP UX.

PROFESSIONAL EXPERIENCE:

Confidential, Racine, WI

Lead Developer

Responsibilities:

• Responsible as a primary Technical Lead/owner for designing and developing CEMLIs in General Ledger (GL), Account Receivables (AR), Account Payables (AP), Oracle Payments (IBY), Cost Management (CM), Fixed Assets (FA), Sub Ledger Accounting (SLA), Trade Community Manager, Order Management (OM), Inventory(INV), Purchasing (PO) and Manufacturing (MFG).
• Involved in Registration/Migration of concurrent programs, executable, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Worked actively in requirement gathering, POC, Design documentation and development
• Worked on Resources Conversion using Data Loader
• Worked on Custom workflow node to append the standard Oracle Payment Workflow
• Designed and developed the Conversion/Inbound interfaces for Product, Customer and Supplier Data Hub and Price list conversion.
• Designed and Developed Interface to import the Legacy AR Invoices into EBS using Auto Invoice Import Program.
• Designed and developed the very complex extensions like Monetization Analysis Program.
• Developed conversion scripts for Reps, AR Invoices, Customers and Commissions
• Developed three custom forms for Account Receivables (AR) named Sales Commission form, Sales Adjustment forms and sales Process form to server the customized commission process of Confidential .
• Customized the Sales Acknowledgement Report
• Design and developed the XML reports like Order Status report, Item creation report, Pack Slip report etc.
• Communicated with the offshore team and maintained daily status meetings with offshore and Onsite technical team to meet the deliverables.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Achieved custom functionality in OM Sales Order form through Forms personalization and Custom.pll.
• Performed the job as a Technical Architect and designed brand new solutions for successful implementation as per business requirements.
• Involved in various RICE components, some of them are mentioned below:
• Reports: Item Creation report, Order status Report, Pack slip etc…
• Interfaces: IR - ISO Automation.
• Conversions: Item Conversion (PIM), Customer Conversion (TCA), Supplier Conversion (TCA), Price List Conversion etc.

Environment: Oracle Applications R12.1.3, OM, AR, INV, PIM, AP, PO, GL,AOL,FA Oracle11g, BI Publisher 5.6, Oracle Workflow 2.6, Reports 10g, forms10g, OAF, JDeveloper 10g.

Confidential, Columbus, OH

Technical Lead/Architect

Responsibilities:

• Provided production support for AR, AP, GL, INV, IB, FS,FA, PO,WSH and OM with constant interaction with the end users.
• Implemented ACP (Application Change Management Pack) in one of the GE Energy business for code/setup migrations.
• Customized Several Forms using Custom.pll and Form personalization.
• Extensively Used AOL, FNDLOAD and System Administrator along with Alert manager.
• Designed and Developed Sales Invoices Conversion program using Auto Import Functionality.
• Designed and developed customized Lockbox Program, lockbox input data file has been validated prior to processing the input file using Auto Lockbox program.
• Setup Descriptive Flex Fields, Value sets for the developed interface to store information as per business requirements in AP and AR modules.
• Provided efficient and quick Root cause analysis for High priority Issues.
• Developed new enhancements starting from gathering requirements, writing CR060s, development and assisting users in UAT.
• Developed customization and enhancements in Oracle technologies like Oracle Reports 6i/10g, Oracle Forms 6i/10g, PL/SQL and Oracle EBS.
• Involved in developing new reports and customizing standard reports in Order Management, Oracle Shipping, Inventory, Purchasing, Payables, Receivables, Install Base, Field Services and General Ledger Modules
• Worked on creating XML Publisher reports.
• Worked on many DFF at Account level, Site Contact Level, Master Items form and many other forms.
• Experience in maintaining DFF with child tables. Experience in using Attribute category to maintain many DFF.

Environment: Order Management, Application Receivables, Oracle Inventory, Install Base, Field Services, AOL, Oracle Purchasing, Oracle 11.5.10, Oracle Forms 6i, Oracle Reports 6i, Windows, Unix.

Confidential, Atlanta, GA

Oracle Apps Techno Functional Developer

Responsibilities:

• Developing and Customizing Oracle reports in OM, OPM, AR, AP, GL, PO,FA and INV.
• Developing and customizing forms related to Exports.
• Developed custom pick lease form (Order Management),custom pick confirm form (Order Management).
• Developed extension program to add backorder line to ready to release line (Order Management) and )extension program to split order line (Order Management).
• Designed and developed the Conversion/Inbound interfaces for Pricing, Customer and Orders (Purchase Orders and Sales Orders).
• Developed program to assign item to child inventory org and restricting sub inventories.
• Developed Oracle Alerts for MFG system to send email notifications and Customized AP Check Printing Report.
• Upload the data from legacy system into Oracle base tables using procedures, Packages and Standard APIs.
• Developed Procedures, functions, packages and triggers on conditional requirements.
• Developed and Customized invoice related reports.
• Interacting with end users and implemented their requirements.
• Excellent knowledge in customization of existing functions, adding new functionality.
• Giving support across 52 locations of Hindalco and solving their issues.

Environment: Oracle Applications Release 11i (OM, AR, OPM, INV, PO, AP), Oracle Forms 6i, Oracle Reports 6i, Windows, TOAD

Confidential

Developer

Responsibilities:

• Worked on Interfaces and data conversions from Legacy system to Oracle 11i
• Developing and Customizing Oracle reports, forms in OM, OPM, AR, AP, GL, PO and INV.
• Interacting with end users and solving their problems like duplicate lot allocation, back order the lot from the delivery etc.
• Developing the reports like Excise Clearance report, Service tax report, Payments Journal Voucher, Receivable Journal Voucher and invoice related reports etc.
• Developed Excise clearance report, Invoice report using India Localization modules.
• Generating the periodic and event alerts.
• Worked on Payables open interface and GL Interface.
• Worked on Suppliers Conversion in Payables AP.
• Responsible for creating, registering and enabling the DFFs.
• Creating PL/SQL programs like functions, procedures and packages etc.
• Interacting with end users and implemented their requirements.
• Excellent knowledge in customization of existing functions, adding new functionality.

Environment: Oracle Applications Release 11i (OM, AR, OPM, INV, PO, AP), Oracle Forms 6i, Oracle Reports 6i, Windows, TOAD