Objective

To work in the field Enterprise Resource Planning systems and focus on Oracle E-Business Suite Applications to leverage my functional knowledge, analytical and programming skills. As a result, providing innovative and thoughtful solutions to solve the IT challenges faced in businesses.

Executive Summary

• Decisive and result-oriented professional offering proven client interfacing, business development and project delivery experience in sectors such as manufacturing, services and distribution.
• Strong knowledge of all the phases of Software Development Life Cycle SDLC , ERP Supply chain processes, Order to Cash, Purchasing.
• 10 years of analysis, design, and development experience in various Oracle ERP projects.
• Deep functional and technical experience in Oracle Applications 11i and R12 OM, Purchasing, Warehouse Management, Advance Supply Chain Planning, Bill of Material, Inventory, AR, Oracle Quotes, Shipping and Configurator
• Good Experience in custom development utilizing Forms, Reports and OA Framework
• Expertise in Oracle Reports, PL/SQL and BI XML Publisher, Jdeveloper, OAF.
• Process-focused with experience in preparing technical and functional design documents for customizations and conversions using AIM Methodology.
• Team-oriented with proven ability to provide functional and technical live support for all levels of Oracle EBS users.
• Oracle trained for Advance Supply Chain, Warehouse Management and OA Framework technology

Technology Skill Set

• ERP Modules: OM, Purchasing, Warehouse Management, Advance supply chain Planning, Bill of Material, Inventory, AR, Shipping and Configurator.
• ERP Systems: Oracle E-Business Suite R11i, R12
• Databases: Oracle 11g
• Programming and Reporting Tools: Oracle Forms, Reports, JDeveloper, Alerts, Workflow, BI XML Publisher, Oracle Forms
• Internet Technologies: JSP, OAF - Oracle Application Framework
• Quest Software products: TOAD, SQL Navigator
• Programming Languages: Oracle PL/SQL, Java
• Operating Systems: MS-Windows all versions, HP-UX, Compaq HP Tru64 Unix, Solaris, Red Hat Enterprise Linux, Fedora

Professional Experience

Confidential

Oracle EBS Oracle Application Developer R12 Oracle EBS Micros Systems

Responsibilities: Focus of the global reach project was to change the GL account structure using the Eprentice tool . As a core technical member in the project, I modified all reports, forms, packages, work-flow, flex-fields and value sets which were affected due to the change in GL structure. Some of the key functional areas where I made changes were -Inventory Order Management Receivables

Confidential

Responsibilities:

• Focus of the project was to transition Ireland, Germany, Confidential and all Nordic countries that were previously on legacy systems to Oracle R12. As a techno-functional expert on the team, I customized and developed reports on the basis of the business requirements and accomplished the following tasks -
• Developed all customer facing documents - purchase orders, customer invoice, dunning, delivery information for UK, Finland, Denmark, Norway and Sweden.
• Used Oracle TCA architecture for interfaces
• Developed customer facing documents using XML / BI Publisher to enable multi-language support
• Used OAF to achieved form personalization and customization on the oracle standard forms.
• Handled support issues after the implementation.
• Gained expertise on the customer collections module like - Dunning set up and customization of oracle standard processes related to credit memo and payments.
• Developed report to show full supply demand details for items on sales order or quote lines.
• Gained expertise in AOL functionality.
• Developed multiple PL/SQL packages/Triggers/Alerts as per projects requirements

Confidential

Responsibilities: For Micros Ireland, I customized multiple oracle standard Java forms. This involved adding custom attributes as per project requirements.

Confidential

Senior Oracle Application Developer R12 Oracle EBS NCR Corporation

Responsibilities:

• Developed new Outbound Interface programs to sent delivery and customer information to freight carriers once delivery get pick confirmed.
• Developed on hand migration program to load from legacy system to oracle base tables using SQL loader and PL/SQL procedures.
• Developed new all cycle count reports those helps the user at the time of physical inventory.
• Support on the monthly closing or physical inventory closing issue.
• Developed some costing reports.
• Customized xml publisher reports Bill of Lading and SMD Pack slip.
• Implemented customizations such form personalization.
• Developed database triggers.
• Customized Shipping Content label to print ship from or bill to address in ship from field based on business requirements.
• Involved in Item import interface code changes.
• Creation of new DFFs, value-sets, concurrent programs, Responsibilities for the project.
• Created new WMS rules for label format types and Label printer setups to print shipping content, material, location, serial number labels.
• Created new carriers, shipping methods, DFF setups and assigned to the organization.
• Setups, Configuration and coordination of activities involved in the above mentioned exercise.
• Involved in Unit, integration and system testing the development work.
• Supporting on Production issues on Logistics Module raised by process owners at various sites across the globe.

Confidential

Responsibilities:

• Developed new outbound interface programs to send delivery and customer information to freight carriers once delivery is ship confirmed.
• Developed PL/SQL program ASN Carrier Labels which prints barcoded label once delivery is ship confirmed.
• Customized standard reports shipping manifest and bill of lading to print ship to, bill to, and pallet and carton information based on the organization profiles.
• Developed custom wrapper around the standard APIs provided by Oracle for auto pick confirm and ship confirm in view with business requirements.
• Creation of new DFFs, value-sets, concurrent programs, Responsibilities for the project.
• Setups, Configuration and coordination of activities involved in the above mentioned exercise.
• Working in close coordination with the business partners and users to frame and refine the business requirements and also playing a key role in writing the design specifications and test cases and test data.
• Involved in Unit, integration and system testing the development work.
• Developed new labels in software application to print labels for the programs developed in ERP like Kanban cards labels, Kanban route labels, pre-kitting list labels programs etc.
• Supporting on Production issues on IST time zone on Logistics Module raised by process owners at various sites across the globe.

Confidential

Senior Oracle Application Developer R11.5.10 Oracle EBS HCL Technologies

Responsibilities:

• Worked as a Techno-functional consultant for Purchasing, Inventory, and WIP and BOM modules.
• Implemented Oracle ERP 11.5.7 with the help of HCL Technologies / Accenture consulting.
• Coordinated with Accenture consultants in the Business gathering / System Design phase.
• Supported the system post-implementation focusing manufacturing operations organizations.
• Led monthly Inventory closing cycles.
• Developed ad-hoc reports and forms for Inventory and Purchasing business users.
• Developed interfaces between PO and Supply Chain.