Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Vikash Kumar Sharma

Delhi

Summary

Oracle Developer with 9 years of experience in PL/SQL, SQL, and enterprise application development (Apex). Expertise in building scalable applications, interactive dashboards, and dynamic reports using Oracle APEX. Hands-on experience in REST API integration, AI-based solutions, and implementing secure role-based access control (RBAC). Strong knowledge of performance tuning, query optimization, and database design. Experienced in Oracle 19c and APEX 22.2, 23.2, and 24.2 in cloud environments. Proven ability to deliver high-quality, efficient, and business-oriented solutions.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Analyst Programmer

Path Infotech Ltd
Noida, India
05.2022 - Current

Fortis Healthcare Ltd

1. Project Name: User Management System
Noida
01.2026 - 03.2026
  • Developed User Management System for managing application users and roles.
  • Implemented AI-based chatbot to assist users for application navigation and support.
  • Created User Registration, Login, Role-based Access Control (RBAC) modules.
  • Developed Dynamic Reports and Forms in Oracle APEX.
  • Used PL/SQL packages, procedures, and functions for business logic.
  • Implemented Authorization Schemes for role-based page and report access.
  • Integrated REST APIs for AI chatbots responses.

Financial Management System (FMS)

2. Project Name:-
Noida
01.2025 - 12.2025
  • Worked on migrating the D2K (Oracle Forms) application to Oracle APEX 24.2.
  • Developed finance modules such as Vendor Bill, Voucher Generation, Journal Voucher (JV), and Bank Payment Voucher (BPV).
  • Created and maintained financial reports for daily accounting and management use.
  • Developed Purchase Order screens and related processes.
  • Maintained master data such as vendors, accounts, and other finance masters.
  • Converted existing D2K logic into APEX pages, processes, and validations.
  • Fixed issues, improved performance, and supported testing and UAT.
  • Coordinated with the finance team to understand requirements and deliver solutions.

Phonepe With PWC Pvt Ltd

3.Project Name:-
Noida, India
10.2024 - 12.2024
  • Created and deployed cloud-based reports using Oracle APEX, optimising reports.

Performance and enhancing the user experience for business stakeholders.

  • Built custom APEX reports and visualisations on Oracle Cloud to support data-driven insights for cross-functional teams.
  • Lead the end-to-end development of new reporting modules in Oracle APEX, leveraging cloud infrastructure for scalability and accessibility.

(NTU) With Oracle Singapore Ltd.

4.Project Name: Nanyang Technology University
Singapore
04.2024 - 09.2024
  • Migrated Oracle APEX applications from version 4.1 to 23.2, ensuring a smooth transition and compatibility with the latest features.
  • Developed new Oracle APEX forms and reports based on enhanced business requirements.
  • Performed development and customisation of various PL/SQL packages, procedures, and functions.
  • Optimised SQL queries to improve performance and efficiency.

Asset Transfer

5.Project Name:
Noida
01.2024 - 03.2024
  • In this project, you can transfer assets.
  • If you transfer an asset during the period in which it was added, the transfer date,It automatically defaults to the asset's date placed in service, and you cannot change it.
  • In the Units Change field, enter a negative number for the assignment line from which you want to transfer the asset.
  • Create one or more new lines by entering a positive number in the Units Change field for the assignment lines to which you want to transfer the asset. Data entry will be the new records from Fusion.

Item Master

6.Project Name:-
Noida, India
09.2023 - 12.2023
  • The client required the development of the Item Master Apex Application. All the conditions are added, such as new items being entered manually and copied from other items.
  • Developed an Apex application for the Item Master.
  • Development of Oracle Apex forms, drilldown, and flexi reports.
  • Developments and customisation of various PL/SQL packages, procedures, and functions.

Customer MDM(Master Data Management)

7.Project Name :-
Noida, India
04.2023 - 08.2023
  • Designed and developed a Customer Master Data Management (MDM) application using Oracle APEX, enabling both manual entry of new customer records and duplication from existing customer profiles, with built-in validation rules.
  • Built and enhanced Customer Master APEX application modules, ensuring data consistency, standardization, and governance across customer records.
  • Developed interactive APEX forms, drill-down reports, and flexible (dynamic) reports for efficient customer data analysis, monitoring, and decision making.
  • Created and customized PL/SQL packages, procedures, functions, triggers, and views to support customer data processing, validation, integration, and business logic implementation.

With DCM Textiles

8.Project Name:-
Noida, India
09.2022 - 03.2023
  • The purpose of the Apex application work is to migrate the existing DCM ERP solution, which was developed in Oracle Forms, to Oracle Apex.
  • Development of the Apex application (POC).
  • Developed Oracle Apex dashboards, tickers, charts, drilldowns, and flexi reports.
  • Developments and customisation of various PL/SQL packages, procedures, functions, triggers, and views, etc.
  • RDF report configuration in Oracle APEX report.

Software Specialist

Eastern Software System (ESS)
Noida, India
05.2019 - 05.2022

1. Project Name :- Ebizframe Neo

Ebizframe Neo ERP software is more than a traditional 'system of record keeping.

Many organizations across the globe are leveraging ebizframe to transform their ageing ERP systems of ‘record keeping’ into an agile ‘system of innovation’, which can quickly and easily adapt to changes in markets, technology, and client needs.

2. Project Name :- Cedar (Mumbai)

  • Migrate the existing Sales, Inventory, Purchase, and Finance (SIPF) ERP, which was developed in Oracle Forms, to Oracle Apex.
  • Development of ERP application and SIPF (Sales, Purchase, Inventory, and Finance) module.
  • Development of Oracle Apex dashboards, tickers, charts, drilldowns, and flexi reports.
  • Developments and customization of various PL/SQL packages, procedures, functions, triggers, and views.
  • RDF report configuration in Oracle APEX report.

3. Project Name :- Warehouse Management System(WMS)

  • Development of Oracle Apex forms, reports, dashboards, charts, and mobile apps.
  • Development and customization of various PL/SQL packages, procedures and functions.
  • triggers, view, etc.
  • Query Optimization.

Oracle Consultant

TI Infotech Ltd
Noida, India
12.2016 - 04.2019
  • Travel Assist is a complete Tour Management Software and Tour Booking Software for Tour Operators, Destination Management Companies, Incoming Agencies, and MICE. It is designed to efficiently manage business operations of all segments, such as FIT Tours.
  • Series, ad hoc, charters, and excursion management.
  • Our Tour Operator Software follows an automated sales process that covers everything from inquiry to itinerary generation. It is very reliable, efficient, and secure, featuring.
  • flexibility and simplicity at the same time.

Education

Master of Computer Applications - Information Technology

IGNOU
Delhi
07-2011

Skills

  • Creation View, Sequence, trigger, Procedure, Function, Cursor, object Create, index, Oracle Reports Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views etc
  • Developed database scheduler scripts and PL/SQL, SQL
  • REST API Development & Integration
  • AI-based Chatbot Implementation
  • Multi-Level Approval Workflow Design
  • OIC Integration with APEX
  • Worked on Oracle Forms 6i/10g, Reports /6i/10g
  • Worked on Apex Application create form On Apex and Jasper report
  • Worked on oracle Reports Like RDF, Jasper Report 52, I-Report 56, CSV, RTF, Excel Report
  • Performed with strong knowledge of stored procedures, triggers, partitioning, commit levels, rollbacks, locking schemes, temporary spaces, sort areas etc
  • Oracle APEX, PL/SQL, SQL, REST API, RBAC, Oracle 19c, APEX 232, Performance Tuning, Query Optimization, Jasper Reports, Oracle Forms, Database Design

Certification

Certified Oracle Apex Cloud Developer (OCP)

Timeline

Fortis Healthcare Ltd

1. Project Name: User Management System
01.2026 - 03.2026

Financial Management System (FMS)

2. Project Name:-
01.2025 - 12.2025

Phonepe With PWC Pvt Ltd

3.Project Name:-
10.2024 - 12.2024

(NTU) With Oracle Singapore Ltd.

4.Project Name: Nanyang Technology University
04.2024 - 09.2024

Asset Transfer

5.Project Name:
01.2024 - 03.2024

Item Master

6.Project Name:-
09.2023 - 12.2023

Customer MDM(Master Data Management)

7.Project Name :-
04.2023 - 08.2023

With DCM Textiles

8.Project Name:-
09.2022 - 03.2023

Analyst Programmer

Path Infotech Ltd
05.2022 - Current

Software Specialist

Eastern Software System (ESS)
05.2019 - 05.2022

Oracle Consultant

TI Infotech Ltd
12.2016 - 04.2019

Master of Computer Applications - Information Technology

IGNOU
Vikash Kumar Sharma