Prashant Gaurav Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

• Data visualization using Power BI• Creation of SQL scripts for data extraction from SQL server database• Leveraging DAX functions to perform arithmetic and logical operations• L2 Production support for CTMS and EDC application• Validation documents creation and UAT execution for version upgrade of EDC application

Gurgaon, Haryana, India

• I have worked as a System Lead for a CTMS and EDC application. The work involves resolution of L2 tickets (Incident, Problem, Change and Release management). It requires interaction with Business and vendor for resolution of the application issues and performing changes in the application. The work includes extraction of data from database through custom SQL scripts.• The tool used for Incident, Problem and Change management is Service Now.• I have worked on the development of procedures and views.• It involves creating IT SLC documents in SAP ITEMS for any change. SAP ITEMS is an IT Validation documents repository.• Validation documents creation and UAT execution for version upgrade of EDC application• Knowledge Article and user manual creation for application.

Gurgaon, Haryana, India

• Worked on transforming data from OLTP to OLAP through ETL tool i.e., Oracle Warehouse Builder and then generating the reports from OLAP by using report generation tool i.e., Oracle Discoverer Desktop and Administrator.• It also involved development of query, procedures and functions depending on the requirement using SQL and PLSQL• Worked on Incident, problem and change management.

Gurgaon, India

• Worked in the project as a Data Warehouse Developer.• The work involved transforming data from OLTP to OLAP through ETL tool i.e., Oracle Warehouse Builder and then generating the reports from OLAP by using report generation tool i.e., Oracle Discoverer Desktop and Administrator.• It also involved development of query, procedures and functions depending on the requirement using SQL and PLSQL.

India