Shiva Chauhan

Oracle Apps Technical Consultant with 1+ years of experience in oracle EBS R12 and Oracle Fusion. Experienced in Procure-to-Pay (P2P) business processes, Accounts Payable (AP), Purchasing (PO). Skilled in SQL, PLSQL development, XML/BI Publisher, Interfaces, Reports, Conversions, and Extensions. Basic exposure to Oracle Fusion Cloud, including new user, roles, BIP reports and ESS jobs.

Oracle Applications Technical Consultant - Oratree Solutions Pvt Ltd

Project: Motherson sumi

• Worked on AP and PO module in Oracle EBS R12 as part of the P2P cycle.
• Created custom DB objects – tables, sequences, synonyms and indexes – as needed for interfaces and reports.
• Developed AP Invoice Details report pulling data from AP_INVOICES_ALL, AP_INVOICES_LINES_ALL, and AP_INVOICE_DISTRIBUTIONS_ALL.
• Created Purchase Order report fetching data from PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL and PO_DISTRIBUTIONS_ALL.
• Wrote PL/SQL procedures, functions, packages and triggers for data validation and insert records into Oracle Standard interface tables.
• Configured Concurrent Programs, Request Sets, Value Sets, and Responsibilities through System Administrator.
• Configured Periodic Alerts to send email notifications and worked on Forms and Reports using AOL.
• In Oracle Fusion: created users, assigned roles, built BIP Reports with LOV/Parameters and linked ESS jobs.
• Prepared Technical Design Documents (MD070) for custom development work.

Bachelor of Technology (B.Tech) - Computer Science and Engineering - Galgotias University (2021-09 - 2025-07)

12th - CBSE - Rishikul Vidyapeeth Sonipat, Haryana (2020-04 - 2021-03)

10th - CBSE - Rishikul Vidyapeeth Sonipat, Haryana (2018-04 - 2019-03)