Dhiraj Dharankar

Experience

• 

  MITESH AUTO ANCILLARY PRIVATE LIMITED

  Jun 2019 - Jun 2019

  Summer Intern

  Worked in Quality Control department performing Quality checks on various types of finish worked shafts, performing acceptance sampling and analyzing check sheets.

• 

  Defence Research and Development Organisation (DRDO)

  Jul 2019 - Mar 2020

  Project Trainee

  • Design and production of milling cutter for special purpose milling machine at ACEM DRDO.• Optimization of parameters for cutting of HTPB based solid propellant on special purpose millingmachine at ACEM DRDO using Design of Experiments, Regression Analysis and Data Visualization.

• 

  KPMG

  Jul 2021 - Aug 2021

  Virtual Data Analyst Consulting Intern

  Assessment and cleaning of data. conducting Exploratory Data Analysis to find out future prospects of creating new branches of Sprocket Central, segmentation of customers based on demographics and visualization of data.Tools used: Microsoft Excel, MS SQL Server, Tableau.

• 

  Infosys

  Dec 2021 - Apr 2024

  Systems Engineer

  • Utilized Power BI to create organizational level reports based on ITSM data for clients. • Created SLA monitoring system using Power BI to keep track of SLAs. Used tools such as Power Query for data transformation. Created DAX measures for Aggregating data, Time Calculations, custom calculations, etc.• Used SSIS for ETL purpose to extract raw data from source and transform it for final production tables.• Transformed in SQL to create views, Stored Procedures, etc.• Used Python to extract data using APIs.• Mentored 3-member team to create Power BI reports as per customer requirements. Show less

• 

  Gallagher

  Apr 2024 - now

  Business Intelligence Analyst

  • Updating monthly financial reports for various divisions.• Creating internal reports for monitoring organization level Kaizen activities using Power BI.