CAREER OBJECTIVE:

Seasoned techno functional Oracle Applications Engineer for Business Analysis, Upgrades, Implementations, Migrations and Production support. To work and grow in an environment where performance is rewarded with new responsibilities and challenges to prove myself to be an asset to the organization and team.

SUMMARY:

• Having 8+ years of experience in Oracle Applications and designing Oracle APEX Reports. Strong experience in designing and developing technical solutions for Oracle Applications including conversions, Inbound/Outbound Interfaces, and reports development.
• Strong business function analysis skills in finance and supply chain management.
• Having knowledge in development of Reports, Interfaces, Conversions, Workflows, Discoverer, Oracle APEX and XML Publisher Reports.
• Expertise in modules like INV, ASCP, WIP, BOM, OM, PO, AR, AP, HRMS, Field Services, e - Commerce Gateway, and XML Gateway.
• Expertise in writing PL/SQL stored Procedures, Packages, functions and Triggers.
• Experienced in ARAS PLM system and quality process documentation.
• Experienced in Product Information Management (PIM) systems.
• Having good knowledge about AOL, System administrator and Coding standards in Oracle Applications.
• Knowledge in creation of Value sets, Executables, Concurrent Programs and Request sets.

TECHNICAL PROFICIENCIES:

ERP Applications: Oracle Applications 11i and R12

Oracle modules: HRMS, PO, INV, OM, AP, WIP, BOM, and XML Gateway

Database: Oracle10g/11g, SQL Server

Tools: Oracle APEX, TOAD, SQL*Plus, XML publisher, Discoverer

GUIs: Developer 2000 (Forms 10g and Reports 10g), OAF, ADF

Middleware: SOA, BPEL and B2B process

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle Application R11i and R12 and Oracle APEX

Modules: Supply Chain Management (ASCP, INV, OM, PO, BOM, WIP)

Responsibilities:

• Working on day to day issues in SCM modules.
• Developed Media and Inventory Application to Generate Forecasting using Historical Information based on Predictive Analytics and identifying the Data Anomalies in the historical Information.
• Worked in Oracle Upgrade Project from 11i to R12.
• Developed/enhanced ARAS PLM and Oracle EBS interface.
• Developed Oracle EBS to Product Information Management (PIM) interface.
• Developed BOM Engineering Change Orders and Mass Change Orders in Oracle APEX Pages.
• Developed approval flows for Engineering Change Orders and Mass Change Orders in Oracle APEX.
• Developed Creating New BOM and their Components and changing existing BOM Components using Oracle APEX Page with necessary approval flows.
• Developing new reports in Oracle APEX Environment.
• Worked on Work Orders and fixed issues on Work Orders.
• Developed Weeks of Supply Report in Oracle APEX.
• Developed Past Due Purchase Orders Report in Oracle APEX
• Developed On Time Delivery Report in Oracle APEX by including graph features and downloading feature on those graphs.
• Developed forms to upload the required data using Oracle APEX Pages.
• Developed Inventory Turns Report in Graphical Representation in Oracle APEX.
• Developed Engineering Change Orders Report in Oracle APEX to identify the Bill of Material Items which are changed.
• Developed Forecast Upload Form Feature in Oracle APEX to upload the Forecast Data to Oracle Base Tables by submitting concurrent programs after uploading the data in Oracle APEX.
• Developed Safety Stock Report for the Items based on the Weekly Demand for those items and Shipment information.
• Developed Internal Blanket Purchase Orders Report to display the records which are in Open/Close Status based on the parameters chosen.
• Developed Report to list out all the Items which are having Attachments with download option to them.
• Developed Time & Action Tracker Form in Oracle APEX to enter the projects information and their status.
• Developed Time & Action Tracker Report in Oracle APEX to display the Projects information based on the entered parameters
• Implemented EDI Process for Inbound Purchase Orders, Purchase Order Changes, and Purchase Order Acknowledgements, Advanced Shipment Notices (ASN) and Invoices Outbound Processes.
• Developing New Item Codes Creation UI through APEX Pages with certain approval flows on them.
• Implemented Custom Authorization Scheme to provide security to Reports and Forms in Oracle APEX

Confidential

Environment: Oracle Application R12

Responsibilities:

• Developed PO cost v/s standard cost report in discoverer reports.
• Customized the purchase price variance report in reports 10g.
• Customized the Invoice print selected invoice report in XML publisher.
• Worked on B2B cycle in order management.
• Developed un invoiced Receipts Report in xml published
• Developed HRMS API’s to create employees, update employees and their assignments. And designed API’s to create Jobs and Grades.
• Developed various reports on HRMS Information.
• Developed custom package to override the Line Type in Sales Order form based on the Item entered.
• Done some customizations on OAF Pages.
• Customized Approval process for Purchase Requisitions and Purchase Orders.
• Worked on Payables Invoice Validation Process by fixing bugs on the form.
• Worked on work flow triggers.

Confidential

Environment: Oracle Application R12

Modules: CRM, BOM, WIP, PO.

Tools: Oracle APEX 5.0 Reporting Tool

Responsibilities:

• Developed Service and Warranty/Extended warranty service contracts using API.
• Developed Discoverer Report for BOM cycle.
• Created WIP for the assembly items and generate the query.
• Developed Drop ship sales order report in Reports 10g.
• Created Different Types of Receipts for different purchase orders.
• Worked on bestselling price concept.
• Developed Reports on Sales Orders and Customer Information in Oracle APEX.
• Developed APEX Reports on BOM Items, Components under the BOM Items and their costs.
• Developed Active Users and Employees Information Reports in Oracle APEX.
• Developed Many reports which are built in Discoverer in Oracle APEX.
• Implemented Custom Authorization Scheme to provide security to Reports and Forms in Oracle APEX
• Customized the workflow to apply the holds whenever order is booked for particular customer.
• Worked on Service Contracts open interface program
• Loading Oracle price list to Oracle using custom process.
• Migrated reports from Oracle discoverer to Oracle APEX.

Confidential

Environment: Oracle Application R11i and R12.

Responsibilities:

• Customize the minmax planning report in reports 10g.
• Customize the auto invoice import program in reports 10g.
• Worked on items orderability rules.
• Worked on document sets.
• API to create new item.
• Creating bank account, bank branches and code combinations.
• Creation of Value sets in various modules of the application.
• Defining Concurrent Programs.
• Implemented Fixed Assets Module.
• Implemented XML Gateway Module.