Dhiraj Dharankar

Dhiraj Dharankar

Summer Intern

Followers of Dhiraj Dharankar982 followers
location of Dhiraj DharankarPune, Maharashtra, India

Connect with Dhiraj Dharankar to Send Message

Connect

Connect with Dhiraj Dharankar to Send Message

Connect
  • Timeline

  • About me

    Power BI Data Analyst | Azure Data Engineer | Fabric Analytics Engineer | SQL | ADF | Databricks | ETL | Pyspark

  • Education

    • K.K.Wagh Education Societys College of Engineering, Hirabai Haribai Vidyanagari, Panchavati, Nashik 422003

      -
      Bachelor of Engineering - BE
    • Rangubai Junnare English Medium School

      -
  • 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.

  • Licenses & Certifications

    • Microsoft Certified: Azure Data Engineer Associate

      Microsoft
      Feb 2023
      View certificate certificate
    • Microsoft Certified: Fabric Analytics Engineer Associate

      Microsoft
      May 2024
    • Certified Lean Six Sigma - Green Belt

      Fluid Controls Pvt . Limited. Mumbai
      Jun 2020
    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      Nov 2022
      View certificate certificate
    • Microsoft Certified: Azure Data Fundamentals

      Microsoft
      Dec 2022