09/16/2023 updated

**** ******** ****
100 % available

Oracle Apps Technical Consultant, Oracle Apps Technical Consultant, Oracle Apps Technical Consultant

Noida, India
Worldwide
B.Tech
Noida, India
Worldwide
B.Tech

Profile attachments

CV - santosh kumar

Business AnalysisBusiness RequirementsComputer ProgrammingPersonalizationCursor (Graphical User Interface Elements)Discrete ManufacturingEnterprise Resource PlanningFinancesManufacturingProject ManagementOracle ApplicationsPL-SQLSQL DatabasesExtensible Markup Language (XML)Oracle SoaXml PublisherOracle EbusinessDatabase Rules and Triggers
PROFESSIONAL SUMMARY:                        
  • IT professional, having overall 10+ years of experience as an Oracle Apps Technical Consultant  in Implementation, Support, Development & Customization of different oracle apps modules of Financials & SCM.
  • Specialized in the Technical aspects related to the Implementation and Support of Oracle Apps R12 Applications (OM, PO, GL, AR, AP, iExpense and AR).
  • Very Strong exposure to RICE (reports, interfaces, conversions, and enhancements/ extensions) components.
  • Worked on Oracle Discrete Manufacturing & Oracle Process Manufacturing ERP methodology.
  • Extensively Worked on P2P Cycle and O2C Cycle.
  • Good Functional Knowledge in R12 MOAC and Financial module (AP, GL, PO).
  • Sound Understanding and working experience with Oracle AIM Documents for Module Design and Build MD [050] MD [070], CV60 etc.
  • Worked on Oracle Workflow & Oracle Alerts also.
  • Worked on XML Publisher Reports and Forms developments using Template.fmb
  • Worked on XML Bursting.
  • Worked on Forms Personalization as per business requirements.
  • Have light weight work knowledge on Oracle SOA.
  • Extensive Programming experience in writing Packages, Procedures, Functions, Database Triggers, Cursors, Ref Cursor and Complex Query using SQL and PL/SQL.
  • Effective communicator and versatile team player with excellent business analysis and interpersonal skills. Good people & project management skills with consistency of delivering tasks on time. Good focus and follow through abilities, with proficient efficiency and productivity.

Experience

Professional experience10+ years
Freelancer since2022

Languages

EnglishFluent

Project history

Oracle Apps Technical Consultant

PROJECT: - 2 Oracle Apps Production Development/Support

Module Inventory
Client Solgenie Technologies for HNI Corporation (USA).
Role Oracle Apps Technical Consultant
Team Size 4
Environment Oracle Applications R12 (12.1.3)
Duration Jun 2021 to Nov 2021.


As a Technical Consultant Team Member, involved in:
* HNI Physical Inventory Tag Generation Process.
* It is a process to generate the Physical Inventory Tags Including the Physical Inventory
Report into Oracle APPS R12 Inventory Module.
* HNI Scrap Assembly Report.
* It is a report to generate the scrapped assembly items into Oracle APPS R12 Inventory
Module.

* HNI Autofas Process.
* It is a process to create the work orders automatically from the sales order into Oracle
APPS R12 Inventory Module.

Oracle Apps Technical Consultant

PROJECT: - 3 Oracle Apps Production Development/Support

Module Inventory
Client Wipro for AIC
Role Oracle Apps Technical Consultant
Team Size 2
Environment Oracle Applications R12 (12.1.3)
Duration Sep 2020 to Apr 2021.


As a Technical Consultant Team Member, involved in:
* FSO User Approval Hierarchy
* It is a custom workflow to define FSO user(s) approver hierarchy.
* AP Invoice Approval is controlled by FSO approver hierarchy.
* In this users cross department mapping facility is given to approve the invoice.

Oracle Apps Technical Consultant

PROJECT: - 4 Oracle Apps Production Development

Module GL,AR,CM
Client Sunic Technologies for Container Corporation of India Ltd.
Role Oracle Apps Technical Consultant
Team Size 10
Environment Oracle Applications R12 (12.1.3), Oracle SOA.
Duration Aug 2019 to Aug 2020.


Responsibilities:
As a Techno Functional Team Member, involved in:
* CONCOR Oracle Apps AR Integration.
* It is an Integration project. We have integrated three different source legacy systems
into Oracle APPS R12 AR Module.
* Gathering all data as per business logics and re arrange them as per Oracle EBS
requirement to migrate all AR objects (AR Cash Receipts, AR Transactions and Cash
Management data for bank reconciliation.) including AR customer creation with update,
from source systems to Oracle EBS was primary task.
* Oracle SOA is used as a middleware and we fetch all concerned data from all three
different legacy systems into our staging tables through Oracle Job Schedulers.
* We call Oracle SOA web service from source staging servers and Oracle AR API(s) are
called from SOA web service which creates AR objects into Oracle EBS.
* Some custom reports are developed one important report which I have developed having
functionality to track each record of AR object/transaction from all different legacy
system via SOA to EBS.
* Light weight work knowledge in ORACLE SOA for project support purpose.

Oracle Apps Technical Consultant

PROJECT: - 5 Oracle Apps Production Development

1. Production Support - Oracle Financials (12.1.3).
Module GL, AP,OM,AR,Oracle Workflow
Client Pathinfotech Pvt Ltd for Godfrey Phillips India Ltd, Uflex India Limited.
Role Oracle Apps Technical Consultant
Team Size 4
Environment Oracle Applications R12 (12.1.3),Oracle Apps 11i
Duration Feb 2019 to Jul 2019



Responsibilities:
As a Techno Functional Team Member, involved in:
* GPIL SPC : Sales Price Create/Update(Development)
* Worked on GPIL Sales Price Create/Update : There is two custom form and Oracle workflow
used accordingly for approval to create/update Oracle Sales Price List.
* GPIL SPC has the functionality to maintain two price list parallel for GPIL one is Old
and another is current.
* The current Price from current price list will be maintained as a new price in Old
price list upon Update in current price.
* Under each price list exception prices are maintained for few exception states.

* Bausch & Lomb (B&L): Customer Profile Update:
* Worked on B&L to update the customer profile data using Oracle workflow approval and
customer update oracle api.
* Uflex : AP Invoice with GST taxes Interface, RMA Sales Order.

* Oracle prepayment invoice using open interface AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE for uflex.
* Automatic GST Taxes and TDS with debit note creation
* In RMA Sales Order sales order creation, automatic receipt program development using
Oracle api(s)

Oracle Support Analyst

PROJECT: - 6 Oracle Apps Production Development/Support

1. Production Support - Oracle Financials (12.1.3), Oracle Fusion.
Module GL, AP
Client EXL India, Noida.
Role Oracle Support Analyst
Team Size 12
Environment Oracle Applications R12 (12.1.3),Oracle Fusion
Duration Aug 2017 to Feb 2019



Responsibilities:
As a Techno Functional Team Member, involved in:
* MJE : Journal Entry Approval Custom Oracle Workflow (Development)
* Worked on MJE workflow to develop a custom oracle workflow.MJE uses HRMS supervisory
hierarchy structure and custom authorization limit for approval system based on employee
position and currency.
* MJE has the functionality to transfer the approval notification to provided member
instead of journal batch submitter's supervisor across all ledgers defined in EBS.

* eVoyage(WEB & Mobile version)(Development) :
* Worked on eVoyage to develop fully operational ticket booking application for all EXL
employees & contract employees.
* To develop all functional common api services which are fully compatible for both user
interface including mobile front end(android & IOS) as well web frontend (Oracle ADF)
using advance Oracle Pl/SQL.
* Develop Synchronization between eVoyage application and oracle iExpense.
* AP Invoice Interface(Development)

* Oracle prepayment invoice using open interface AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE for eVoyage application.


* XML Report(Development)
* Oracle XML eVoyage report to show all TRF(ticket) raised data including their travel
detail and approval detail having source of raise (web or mobile).
* Oracle XML MJE report to show all the MJE journal batches approved or yet to be
approved having their all level of approvers.

* Oracle Cloud(Suppliers Import & Export)(Technical Support)

* Migration of suppliers defined in Oracle EBS to Oracle cloud (Fusion) using the Oracle
cloud supplier migration templates
* Migration of suppliers defined in Oracle cloud(Fusion) to Oracle EBS using the custom
conversion programs registered in Oracle cloud.


PROJECT: - 7 MOLTS: Oracle Apps R12 Implantation/Rollout and Enhancements & Support

1. MOLTS
Module PO,AP,AR,GL,ASCP, Quality, OM, iExpense,
Client Motherson Summi, Noida
Role Oracle Support Analyst
Team Size 15
Environment Oracle Applications R12 (12.1.3)
Duration May 2016 to May 2017


Responsibilities:
As a Techno Functional Team Member, involved in:

* Conversion Activity
* Item Conversion
* Items On hand Conversion
* Quality Specification Conversions
* Quality Kit Lot Criteria Setup and Conversion
* TCA Conversion - Customer
* AP Invoice Conversion
* AR Invoice Conversion
* Reports (XML Publisher)
* MOLTS :: PO Printing Revision Report
* MOLTS :: Remittance Advice Report
* MOLTS :: Payment Voucher Report
* MOLTS :: Warehouse Stock Aging Reports
* MOLLTS :: Graph Implementation in Report
* Process Design
* WIP Job Complete Process
* WIP Child Quantity Issue Process
* Form Design (Template.fmb) and Forms Personalization
* Back Flush Quantity Form
* WIP Job Creation and Complete Custom Form
* Remittance Advice Form
* Invoice Challan Form(Custom Form)
* Created Loader Custom Program to update PO Line Location Field
* MOLTS: Item Descriptions Update Program.
* MOLTS: Quality Specification attachment Program.
* MOLTS :PO Printing attachment Reports
* MOLTS : AP Statement Reports

Oracle Support Analyst

PROJECT: - 8 Oracle Apps Production Support

1. Production Support - Oracle Financials(12.1.3)
Module PO,AP,AR,OM,iExpense,GL
Client Wipro for Telenor Myanmar.
Role Oracle Support Analyst
Team Size 10
Environment Oracle Applications R12 (12.1.3)
Duration Aug 2015 to May 2016



Responsibilities:
As a Techno Functional Team Member, involved in:
* WIP Component Issue Interface(Development)
* Worked on WIP Component Issue interface to issue components against job numbers in bulk
using MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE &
MTL_SERIAL_NUMBERS_INTERFACE.
* Wip Component issue automation: This functionality automates the Wip component issue in
background one by one.
* GRN Interface(Development)

* This is a custom program through which we may do the GRN against internal sales order.
* Inventory Depletion Interface(Development)
* Inventory Serial Number depletion loader loads serial numbers into custom table.
* Interface Program a custom program through which we may do the miscellaneous issue in
bulk using MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE &
MTL_SERIAL_NUMBERS_INTERFACE.

* Iproc Purchase Requisition Update Alert
* Apply the current rate from GL Daily Rates at requisition made from Quotation using IPROC
Module.
* Requisition Rate/Date Update Program
* Apply the current rate from GL Daily Rates at requisition made from Quotation using IPROC
Module.

* SQL Scripts
* Develop Script Displaying PO-Invoice-GRN (Receive, Deliver Amount wise) Amount Deviation
Report.

* XML Publisher Report
* TNM Accounting Entries Extended Report
* TNM PEARL Report
* TPCO Payment Detail Reports
* Telenor Purchase Order Report Bursting.
* Involved in query tuning activities.
* Modules supported were Oracle PO, AP, GL and AR.
* Responsible for Period Close in AP/GL/AR.
* Resolving the tickets raised by the end users with in time and facilitates the running of the
system in smooth manner.
* Coordination with the Onsite team to fix the issues and also to report progress.
* Resolving client's issues in the Development and Test Instances.
* Cut Over documents to move changes into Prod.
* Evaluating technical specifications for customizationsfor new enhancements.


PROJECT: - 9 Oracle Apps Production Support-R12/Enhancements

1. Production Development & Support - Oracle OPM(12.1.3)
ERP Methodology Oracle Process Manufacturing.
Module OPM Inventory, OPM Quality, OPM Finance.
Client Path Infotech Pvt Ltd for SRF Limited Gurgaon.

Oracle Support Analyst

Team Size 8
Environment Oracle Applications R12 (12.1.3)
Duration Jun 2014 to Aug 2015



1) Custom Reports:
a) Certificate of Analysis Yarn (RTF Reports): These are four reports specific for each
operating unit of SRF, are concerned with OPM Quality. These show the data of quality tested
of various samples for Specific or all test properties.
b) TCF RM Test Report (RTF Reports): These are three reports concerned with the OPM Quality
Testing Common in all units as operating units wise.
c) Certificate of Analysis Grey Fabric (RTF Reports): These are four reports specific for each
operating unit of SRF, are concerned with OPM Quality. These show the data of quality tested
of various samples for Specific or all test properties.
d) Production Cost Sheet (RTF Report): This is a RTF report concerned with the OPM Production.
It shows costing data of production period wise.
e) Inventory Cost Sheet (RTF Report): This is a RTF report concerned with the OPM Inventory. It
shows costing data of Inventory period wise.
f) Sales Cost Sheet (RTF Report): This is a RTF report concerned with the OPM Sales. It shows
costing data of sales period wise.

2) Custom Forms:
a) TCF Mass Lot Status Change: This custom form is concerned with OPM Inventory. Using this
form we change the lots status in bulk.
b) TCF Mass Lot Grade Change: This custom form is concerned with OPM Inventory. Using this form
we change the lots grade in bulk using the workflow approval procedure to change.
c) IYB Mass Lot Status Change: This custom form is concerned with OPM Inventory. Using this form
we change the lots status in bulk.
d) IYB Mass Lot Grade Change: This custom form is concerned with OPM Inventory. Using this form
we change the lots grade in bulk using the workflow approval procedure to change.

3) Work Flow :
a) Grade Approval Workflow for IYB: This is a custom work flow fired from a custom form to
provide the approval system to grade change in bulk.
b) Grade Approval Workflow for TCF: This is a custom work flow fired from a custom form to
provide the approval system to grade change in bulk. Here we maintain the date tracking to
each change.

4) Conversion:
a) Item Master: Loaded the item master into oracle application from flat file using the Item
conversion program.
b) Price List: Loaded the price list using the price list conversion program.
c) Item cost: Loaded the item cost using the Item cost conversion program.
d) Item On Hand: Loaded the item on-hand using the Item on-hand conversion program.
e) Supplier conversion: Loaded the suppliers using the supplier conversion.
f) Customer conversion: Loaded the customers' data into the oracle application using the
customer conversion program.
g) Employee conversion: Loaded the employees date into oracle application using the standard
HRMS APIs.
h) AP Invoice/AR Invoice Conversion: Loaded the AP and AR Invoice using the corresponding
conversion program.
i) OPM Quality Specification: Loaded the quality specifications into oracle application.
j) OPM Quality Samples & Validity Rule: Loaded the quality samples date with the validity rules
into oracle application using the OPM Sample conversion program.
k) OPM Formula Conversion: Loaded the Formulas into oracle application using the Formula
conversion program.
l) OPM Recipe conversion: Loaded the Recipes into oracle application using the recipe
conversion program.

Oracle Support Analyst

Aditya Birla Group
PROJECT: - 10 Oracle Apps Production Support-R12/Enhancements

1. Production Support - Oracle Financials(12.1.3)
Module PO,AP,GL,OM,AR
Client Aditya Birla Group, Mumbai
Role Oracle Support Analyst
Team Size 7
Environment Oracle Applications R12 (12.1.3)
Duration July 2013 to Jun 2014



1) Reports:
g) RMS to GL Report (RTF Report): This report is concerned with GL Interface. IT shows the data
of amount difference from staging table to General Ledger base tables.
h) Debit Note XML Bursting Report: This report is concerned with the XML Bursting of Debit Note
Reports. It is capable to add its recipient email address at run time.
i) TDS Exception Report (RTF Report): This is a RTF report. It is concerned with the payables.
It shows the TDS Tax details of vendors for Miscellaneous Invoice type.

2) SQl Queries:
a) Customer Tax Payer: This is a SQL query concerned with Receivables. It gives the customer
details with Customer Tax Payer information.
b) Customer CST VAT Details: This is a SQL query concerned with Receivables. It gives the
customer details with CST VAT information.
c) Unit Price for Purchase Requisition: This is a SQL query concerned with purchasing .It gives
the data of all Purchase Requisition with the Item unit Price.
d) Payables_SLA_GL_Amount Difference: This is a SQL query concerned with Payables. It gives the
data of all Invoices with amount comparison from PAYABLES, SLA and GL.
e) Unique Vendor with CST VAT: This is a SQL query concerned with Payables. It gives the data of
all vendors with CST VAT information. This query has the map of several old vendor codes with
a newly generated unique vendor code as per business requirement.
f) Tax Details: This is a SQL query concerned with Payables. It gives the data of all Taxes
(Indian Localization) applied to vendors.
g) Open PR with Amount: This is a SQL query concerned with purchasing .It gives the data of all
Open Purchase Requisition with amount details.
h) Supplier Bank Information: This is a SQL query concerned with Payables. It gives the data of
all vendors with their Bank Information.
i) All Item Unit Price: This is a SQL query concerned with purchasing. It gives the data of all
Items which has Purchase Order with their unite price rate.
j) Vendor Site with Local Site (CST site): This is a SQL query concerned with Payables. It gives
the data of all Vendors Site with corresponding Local Site Details with CST VAT.
k) Vendor Tax Payer Tax Region: This is a SQL query concerned with Payables. It gives the data
of all Vendors with Tax Payer and Tax Region for all old vendors and corresponding newly
generated unique vendors and vice-versa as per business requirement.

3) Programs
c) Sundry Creditors MIS Invoice Data Migration: This is a Program modification concerned with
Payable. It consists new field for old Vendor Codes for Corresponding newly generated unique
vendor code.
d) Sundry Creditors MIS Invoice Data Migration Prepayment Program: This is a Program
modification concerned with Payable. It consists new field for old Vendor Codes for
Corresponding newly generated unique vendor code.
e) Sundry Creditors MIS Invoice Data Migration Prepayment adjustment Program: This is a Program
modification concerned with Payable. It consists new field for old Vendor Codes for
Corresponding newly generated unique vendor code.

Oracle Support Analyst

PROJECT: - 11 Oracle Apps Production Support

1. Production Support - Oracle Financials(12.1.3)
Module PO,AP,iExpense,GL
Client Thomas Publishing, USA (Offshore)
Role Oracle Support Analyst
Team Size 5
Environment Oracle Applications R12 (12.1.3)
Duration Mar 2013 to June 2013



Responsibilities:
As a Technical Team Member, involved in:
* Purchase Order Interface
* Worked on Purchase Order interface to transfer Open PO from flat file to Oracle Apps
using PO_HEADERS_INTERFACE and PO_LINES_INTERFACE.
* AP Invoice Interface:
* Loaded Payable AP Invoice using open interface AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE.
* AR Interface:
* Worked on Auto Invoice Interface to upload sales invoice from flat file to Oracle Apps
using Auto Invoice Interface RA_INTERFACE_LINES.
* Employee Expense Upload Program (iExpense)
* Wrote Programs to upload Employee Expenses from staging table to
AP_EXPENSE_REPORT_HEADERS_ALL AP_EXPENSE_REPORT_LINES_ALL
* Wrote Validation program to import invoices in Payables.
* GL Interface
* Loaded data from Flat File to Staging table Using SQL*Loader
* Wrote Validation Package to validate the data before inserting into GL_INTERFACE.
* Error Handling & Resolution
* Registered in Oracle Apps
* GL Daily Rates Interface
* Loaded Daily Rates using Open Interface table using GL_DAILY_RATES_INTERFACE.
* XML Publisher Report
* TPCO Purchase Order Detail Report
* TPCO Employee Expense Report
* TPCO Payment Detail Reports
* TPCO Vendor Detail Reports
* TPCO Good Receipt Note Report
* Oracle Alerts
* TPCO Vendor Payment Alert
* TPCO Code Combination Alert
* TPCO Rejected Vendor Alert
* TPCO Vendor Creation Alert
* TPCO Period Status Alert
* Setup Activity
* Defined CVR Rule in GL
* Security Rule in GL
* Defined Distributions Sets in AP
* Payments Terms (AP)
* Payments Batch (AP)
* Defined Document Sequencing for Payable invoices
* Involved in query tuning activities.
* Modules supported were Oracle PO, AP, GL and AR.
* Responsible for Period Close in AP/GL/AR.
* Resolving the tickets raised by the end users with in time and facilitates the running of the
system in smooth manner.
* Coordination with the Onsite team to fix the issues and also to report progress.
* Resolving client's issues in the Development and Test Instances.
* Cut Over documents to move changes into Prod.
* Evaluating technical specifications for customizationsfor new enhancements.

Oracle APPS Technical Consultant

Idha Soft
PROJECT: - 12 Oracle Apps Support/Enhancements (12.1.3)

Platform & Skills: Oracle Applications R12, Report10g, PL/SQL, TOAD 9.0, UNIX,
SQL * LOADER
Module: GL, AP, PO,AR, SYSADMIN, AOL
Role: Technical Consultant
Client: Idha Soft, Gurgaon
Duration: Apr 2012 to Feb-2013
Team Size: 7



Role & Responsibility:

Bank EFT Process Design:
* Wrote Package to generate file in Excel format as required by Banker to process NEFT/RTGS by
using UTL_FILE and call reports in it and Registered in Oracle Apps.
* Wrote Package and Register in Oracle Apps to generate Payments file with the help of UTL_FILE
Package.
* Developed Reports in XML Publisher to generate file in PDF Format for all processed records.

Supplier Master Conversion:
* Migrate Supplier/Sites with Contacts from Excel for Operating Unit Green Truck.
* Wrote Validation Program to validate data before inserting into open interface
* Responsible for Setup like Pay Group, Source and Payment terms for processing Suppliers.
* Wrote control file and call this using Shell Scripts to upload data into staging table.

Invoice Interface
* Wrote Validation Program and call standard open Interface to upload Payable invoices to Oracle
Apps.

AR Invoice Interface:
* Develop Program to transfer AR invoices from legacy to EBS R12.
* Wrote Validation before inserting data into Interface table.
* Wrote Validation Program and call standard open Interface to upload sales invoices to Oracle
Apps.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in