Ashish Kumar Sahoo Email & Phone Number

Bhubaneswar, Odisha, India

Kolkata, West Bengal, India

Worked for National oil well Varco as independent oracle apps developer and oracle apps in modules order management , receivables, payables and inventory.• Created custom PL/SQL stored procedures, functions, and packages for calling standard APIs mostly related to O2C cycle processes as per client requirement.• Created several XML publisher and oracle reports having multiple groups and connections along with XML bursting mostly for the Jacmel invoicing and receipts which is being printed for business users.• Worked on shell scripts for various requirements.• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.Worked for Clarivate analytics as independent oracle apps developer in service contract module.• Created custom PL/SQL stored procedures, functions, and packages mostly related to service contracts O2C cycle processes as per client requirement.• Created several XML publisher and oracle reports having multiple groups and connections along with XML bursting mostly for the Clarivate, ProQuest and Exlibris invoicing and receipts which is being printed for business users.• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.• Created various concurrent programs and concurrent executables for execution of stored procedures, reports.• Simultaneously did creation of various objects of Oracle e.g. sequences, views, grants.

Hyderabad, Telangana, India

Worked for Jacmel US as a oracle apps technical consultant in WIP, order management, inventory modules and also worked in support part of Jacmel.• Created custom PL/SQL stored procedures, functions, and packages for calling standard APIs mostly related to P2P cycle processes as per client requirement.• Worked on end-to-end P2p process e.g. creating requisition, purchase orders, invoice, receipts in application along with backend related base tables, interface tables and associated standard APIS and developed custom APIs as per business requirement.• created several custom backend APIs as per client requirement.• Worked on shell scripts for various requirements.• Created several XML publisher and oracle reports having multiple groups and connections along with XML bursting mostly for the Jacmel invoicing and receipts which is being printed for business users.

Hyderabad, Telangana, India

Worked for Resmed US and Resmed online store as an oracle apps technical consultant.• Created custom PL/SQL stored procedures, functions and packages for calling standard APIs mostly related to P2P cycle processes as per client requirement.• Worked on end-to-end P2p process, creating requisition, purchase orders, invoice, receipts in application along with backend related base tables, interface tables and associated standard APIS.• Worked on form personalization based on the requirement. • Worked on workflow builder and have created several custom workflow processes which were attached to several order types.• Worked on several packages which are having oracle to TIBCO and TIBCO to middleware connectivity and vice versa, also have worked on TIBCO and middleware platform along with business analyst and user.• Created several packages for calling FedEx Web services and TNT web services from oracle package by configuring the connection and packages.• Created several XML publisher and oracle reports having multiple groups and connections along with XML bursting mostly for the ResMed invoicing and receipts which is being printed for business users.• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.• Developed and modified advanced PLSQL packages associated with ROS processes which were being called exclusively based on customers activity in ROS platform e.g. customer books or cancels order, checking the warranty period of purchased product.• Worked on end-to-end O2C cycle (order management, inventory, general ledger modules) in application along with backend related base tables, interface tables and associated APIS.• Have generated several XML publisher and oracle reports for the custom service module which were not only accessible from oracle also from ROS application with XML bursting facility for sending emails to ResMed Customers directly

Hyderabad, Telangana, India

Successfully cleared the generic and stream training in python and oracle apps at Infosys Mysore.Worked for Sony as oracle apps developer in the Sony conversion team of 11i to r12.Worked for Verizon as oracle apps resource to convert the existing code or sql with c++ to postgresql with java.Worked for Harmonic to convert the oracle rdf and xml reports into oracle cloud reports.• Worked as a PLSQL developer to Create and modify several UNIX shell Scripts according to the changing needs of the project and client requirements to create different flat files in CSV and Excel format.• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package. and SQL*Loader and created different CTL files to load data from flat files obtained from various facilities to required tables.• Worked in Conversion team and Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from 11i to R12.• Worked as a PLSQL developer for developing the stored Procedures e.g. validation procedures, import procedures, wrapper procedures conditions in accordance with requirement for data import from custom to oracle base tables.• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Bachelor Of Technology - Btech, Electrical And Electronics Engineering

Intermediate, Science, 78.33%