Sarthak Jain
Arlington
Summary
IT professional, having 3.9 years of experience as an Oracle Apps Technical Consultant in Implementation, Support, Development & Customization of different oracle apps modules of Financials and SCM modules. Specialized in the Technical aspects related to the development and Support of Oracle Apps R12 Applications (PO, GL, iProcurement, Inventory, AP, OM,HR and AR). Very Strong exposure to RICE (reports, interfaces, conversions, and enhancements) components. Extensively Worked on P2P Cycle. Worked on XML Publisher Reports and Forms developments using Template.fmb Worked on Forms Personalization as per business requirements. 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.
Overview
4
4
years of professional experience
Work History
Oracle Apps Technical
HEURISTICS INFORMATICS PVT. LTD.
02.2023 - Current
- Efficiently managed and optimized the processing of various files, including Vendor Upload, Invoice Upload, and GL Upload, ensuring data accuracy and timeliness, and enhancing overall data integration processes
- Loaded Payable AP Invoice using open interface AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE
- Managed the end-to-end process of loading data from flat files to staging tables using SQL
- Loader
- Implemented advanced error handling and resolution mechanisms, minimizing data processing disruptions
- Identify and resolve technical issues and bugs in Oracle Applications modules
- Monitor and raise Service Requests (SR) to Oracle support for standard Forms and Reports issues
- Communicate with functional team members to understand and provide backend data requirements
- Manage and facilitate various file and data uploads (Vendor Upload, Invoice Upload, GL Upload, etc.)
- Oversee scheduled processes within Oracle Applications
- Assign incoming tickets to respective departments based on their nature
- Handle and resolve assigned tickets, providing timely updates to stakeholders
- Monitor email alerts generated by Oracle Applications to ensure correct functioning
Software Engineer
AWC SOFTWARE Pvt. Ltd.
09.2022 - 12.2022
- Worked on Purchase requisition interface to transfer Ebiz generated PO from flat file to Oracle Apps using PO_REQUISITIONS_INTERFACE_ALL
- Loaded Payable AP Invoice using open interface AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE
- Loaded data from Flat File to Staging table Using SQL
- Loader
- Wrote Validation Package to validate the data before inserting into GL_INTERFACE
- Applied GST Related Changes In Invoice Report
- Resolving the tickets raised by the end users with in time and facilitates the running of the system in smooth manner
- Resolving client’s issues in the Development and Test Instances
- Evaluating technical specifications for customizations- for new enhancements
- Worked on move order form in inventory module and applied personalization as per user requirement
- Worked on xml report bursting, because user wants report in mail attachment
Software Engineer
QSPEAR Consultancy Services Pvt. Ltd.
11.2021 - 09.2022
- Modules support Oracle PO, AP, AR, GL
- Resolving the tickets raised by the end users with in time and facilitates the running of the system in smooth manner
- Resolving client’s issues in the Development and Test Instances
- Evaluating technical specifications for customizations- for new enhancements
- Done the enhancements in multiple Pl-SQL programs as per business requirements
- Create new Reports and also done the enhancements on multiple reports
- Worked on the PO migration
- Worked on the Form personalization on AP Invoice
- Worked on ERM project and EFS project
Software Engineer
PRKRISHNA & COMPANY.
11.2020 - 10.2021
- Modules support Oracle PO, AP, AR, GL
- Done the enhancements in multiple Pl-SQL programs as per business requirements
- Create new Reports and also done the enhancements on multiple reports
- Worked on the Custom report tuning
- Resolving the tickets raised by the end users with in time and facilitates the running of the system in smooth manner
Education
B.Tech. -
Chandigarh Group of Colleges
Landran01.2020
Higher Secondary -
Lord Mahavira Academy
Saharanpur01.2016
High School -
Lord Mahavira Academy
Saharanpur01.2014
Skills
- ERP
- Oracle Applications R12
- PO
- AP
- IProcurement
- OM
- Inventory
- AR
- GL
- AOL
- Reports Development
- Customization
- Interfaces
- Forms Developments
- XML Reports
- Oracle Alerts
- Oracle 11g
- Oracle 10g
- SQL
- PL/SQL
- Oracle Reports 10g
- Oracle Forms
- XML Publisher
- Work flow Builder
- TOAD 9x
- Loader
- PLUS
- Windows 95
- Windows 98
- Windows XP
- Windows NT
- UNIX
Proud Of
- Track record of achievements
- Social Involvements
- Quick Learner
- Coordination of Events
Timeline
Oracle Apps Technical
HEURISTICS INFORMATICS PVT. LTD.
02.2023 - Current
Software Engineer
AWC SOFTWARE Pvt. Ltd.
09.2022 - 12.2022
Software Engineer
QSPEAR Consultancy Services Pvt. Ltd.
11.2021 - 09.2022
Software Engineer
PRKRISHNA & COMPANY.
11.2020 - 10.2021
B.Tech. -
Chandigarh Group of Colleges
Higher Secondary -
Lord Mahavira Academy
High School -
Lord Mahavira Academy
Similar Profiles
Annith Kumar TAnnith Kumar T
Production Support Analyst at Surya Informatics Solutions Pvt LimitedProduction Support Analyst at Surya Informatics Solutions Pvt Limited
Manisha V SalteManisha V Salte
Asst. Manager Accounts & Finance at Suraj informatics Pvt. Ltd.Asst. Manager Accounts & Finance at Suraj informatics Pvt. Ltd.
MUSKAN SENMUSKAN SEN
Associate Software Engineer at Sansys Informatics Pvt. Ltd.Associate Software Engineer at Sansys Informatics Pvt. Ltd.
Mayed LealMayed Leal
Shift Leader at WingstopShift Leader at Wingstop
Lyana KatzLyana Katz
Freelance Photographer at SelfFreelance Photographer at Self