SUMMARY

• Having 8 years of IT experience in complete SDLC (gathering Business Requirements, Analysis, Design, Implementation and Testing) cycle using Oracle Applications R12, 11i, SQL, PL/SQL, Oracle RDBMS.
• Extensively worked on Oracle ERP modules like Supply chain Modules (INV,WMS,PO,OM),Manufacturing modules(WIP,BOM,WSH), Financial Modules (AP,AR,GL,FA), and AOL Objects.
• Strong knowledge on business flow’s in Order - to-Cash, Procure-to-Pay, ISO and Dropship cycles.
• Technically proficient in RICEW (Reports, Interfaces, Conversions, Extensions, workflows) Components.
• Implemented advanced methodology like Integrated SOA Gateway (ISG) approach and Advance Queueing (JMS-AQ) approach in Oracle Interfaces.
• Expertise in Design and Development of Interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and external Tables.
• Managing Onsite Technical Team & Project deliverables, Customer Interaction and coordination with team at both Onsite and Offshore.
• Having Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, External Tables, collections, records, views, materialized views and Packages using PL/SQL.
• Extensively worked on Oracle Forms, Oracle Reports, XML Publisher, Oracle Application Development Framework (OAF), Oracle Workflow Builder, Oracle Apex, Form Personalization and Application Development Framework(ADF).
• Good Working Experience on all the Standard EDI process like EDI 850 and EDI 810 to handshake with EDI customers.
• Extensive experience in developing and customizing Reports using XML/BI Publisher with xml data template and Oracle Reports data template.
• Expertise on designing and implementing Oracle Alerts, AME and Lookups.
• Expertise in System Administration including oracle application activities like application user setups, defining responsibilities, request groups, value sets, registering, menus, forms, reports, Concurrent programs and providing support to apps users for any technical and functional issues.
• Good working experience with Service Desk (Assigning Tickets and entering work log and tracking the status of a Defect and update Service Desk).
• Experience using project management tools such as AIM Methodology, Microsoft Project and Visio.
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• Well versed with Unix Shell Scripting and Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader or External table scripts.
• Experienced in Developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV060) and Migration documents (MD0120).
• Tuning of customized application including reports and backend customization by using different application tuning techniques.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Thorough knowledge of Oracle Apps Data model and how to leverage the data for effective Reporting.
• Possess strong technical skills and business knowledge coupled with product knowledge in Oracle E-Business Suite.
• Interact with people at all levels. Possess excellent communication and problem solving skills, and work ethics.

TECHNICAL SKILLS

ERP: Oracle Applications EBS R12, 11i

Databases: Oracle Database 9i, 10g, 11g

Languages: SQL, PL/SQL, Java, HTML, JavaScript, XML, C,C++

ERP Processes: Order-2-Cash (O2C), Procure-2-Pay (P2P), DROPSHIP and Quote to Order(Q2C)

Technical Applications: Oracle Forms, Oracle Apex, Oracle Workflow, Oracle Application Framework (OAF), AOL .Application Development Framework (ADF), Oracle Alerts and SYSADMIN

Supply Chain Applications: Oracle Warehouse management system, Order Management, Oracle Purchasing, Oracle Inventory, Bill of Material and Work in progress.

Financial Applications: GL, AP, AR

Reporting Tools: Reports Developer, XML Publisher and Discoverer

Development Tools: TOAD, SQL Developer and SQL*Plus

Operating System: Windows NT, UNIX

Other Tool: SVN

Multimedia: Flash, Adobe Photoshop

PROFESSIONAL EXPERIENCE

Java Developer

Confidential

Responsibilities:

• Team Lead for Supply Chain modules - Application Support and Maintenance.
• Taking care of Oracle EBS related Support activities and he is specialized in Warehouse management system mobile GUI.
• Modifying R12 Reports and XML Publisher (RICE Components) and Bug Fixing on PL/SQL codes
• Worked on Interface and API’s using Integrated SOA Gateway (ISG) and Advance Queue (JMS-AQ) approach.
• Good experience customizing and personalizing the forms, oracle Alerts and approvals using Oracle Approval Management (AME).
• Customized and developed Oracle Forms/Reports, workflow and Data conversion in INV, WMS, OM, PO, BOM & WIP Modules. Interacted with the business users and collected the technical requirements and Involved in Development, Customization of the Interface Applications.
• Worked intensely on Item Conversions and Onhand Conversion during new company acquisition.
• Implemented many form personalization and OAF personalization as per the client need.
• Worked on decommissioning the ASCP Collection Plans.
• Customized many standard Workflows as per the user business requirements.
• Extended EDI 810 via Custom Hook and implemented EDI 810 and 850.
• Automatic mailing system is achieved by Alerts with Workflow Builder and Data Bursting.
• Customized and extended standard Purchase order Document in many approaches.
• Involved in application rollouts for new regions and LOBs, designing solution for different business requirements and map it within oracle EBS and bug fixes through code enhancements.

Environment: E-Business Suite Release 12.1.3, R12.2.5, WMS,OM,PO,INV,BOM & WIP,AP,AR,GL, Oracle Forms 10g, Oracle Reports, Oracle Workflow, Oracle Apex, PL/SQL, SQL*Loader, SQL*Plus, TOAD, SQL Developer, JIRA, and UNIX

Confidential

Oracle Apps Techno-functional Consultant

Responsibilities:

• Involved in the Retro fitment of 70 custom interfaces from 11i to R12 upgrade.
• Taking care of Oracle EBS related development and retro fitment activities
• His main activities are working closely with onsite counterpart and client SME and involving in requirement analysis, design, build, production deployment phase and in translating business needs to solutions.
• In addition to the project activities, he is also involved in daily routine activities like client interaction, status Call and execution control.
• Developed Purchase order report, Sales Order Report and many custom reports using XML Publisher.
• Designed, documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Created Staging tables, and custom PL/SQL API’s.
• Worked intensely on customer import from third party system (MIDAS) and updating them in Oracle to interface them into TCA API’s in AR.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Ordered., from legacy system.
• Developed a XSL template for customizing the PO document XML/BI Publisher.
• Customized and developed Oracle Forms/Reports, workflow and Data conversion in INV,WMS, OM, PO, BOM & WIP Modules. Interacted with the business users and collected the technical requirements and Involved in Development, Customization of the Interface Applications

Environment: E-Business Suite Release 12.1.3, R12.2.5, WMS,OM,PO,INV,BOM & WIP, Forms 10g, Oracle Reports, Oracle Workflow, Oracle Apex, PL/SQL, SQL*Loader, SQL*Plus, TOAD, SQL Developer, JIRA, and UNIX

Confidential

Oracle Apps Techno-functional Consultant

Responsibilities:

• Developed BI reports and Oracle Application Framework reports as per the Client Requirement.
• Developed many RICEW components as per the client requirements.
• Migrated all the legacy data and setup data using pl/sql programming and data loader.
• Implemented many form personalization and OAF personalization as per the client need.
• Prepared high level and detailed technical design documentation.
• Customized Templates In Standard Modules(Contract Terms Template and Check Printing)
• Written PL/SQL procedures function to handle the system Migration activities.
• Developed SQL scripts to create temporary tables and SQL*Loader control files to load the item legacy data into the temporary tables
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Zoom feature is enabled using custom.pll and whenever user in sales order form clicks the zoom button. It displays the discount amount calculated for that order basing on the payment terms of the order.
• Development/modification of custom reports in purchasing and inventory by calling sub templates in XML/BI Publisher.
• Experienced in Performance Tuning of SQL queries & Views using Explain Plan, Hints and indexes.

Environment: E-Business Suite Release 12.1.2, WMS,OM,PO,INV,BOM & WIP, Forms 10g, Oracle Reports, Oracle Workflow, Oracle Apex, PL/SQL, SQL*Loader, SQL*Plus, TOAD, SQL Developer, JIRA, and UNIX