Summary
Overview
Work History
Education
Skills
Certification
Projects
Accomplishments
Timeline
Generic
Pranshu Dhyani

Pranshu Dhyani

Hyderabad

Summary

Dedicated and process-oriented software engineer with a strong focus on data engineering and a passion for transforming raw data into actionable insights. Seeking a role that leverages my expertise in data analytics, predictive analysis, data migration, data warehousing, and ETL to build robust data pipelines and systems. Proficient in data gathering, cleansing, and organization, I excel at structuring chaotic datasets to enable accurate predictions and analyses.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Program Analyst/Automation Analyst

Cognizant
Hyderabad
08.2020 - 08.2022
  • Working as an offshore Automation Engineer for a top US based MNC(KPMG)
  • Assisting the robust functioning of client's online audit portal with the help of robot framework scripts
  • Working with programming languages and tools namely Python, Java and Selenium

Data Analyst

Procure Analytics
Hyderabad
08.2022 - Current
  • Implemented a data lake architecture using Azure Synapse Analytics, PySpark, and Apache Spark to create ETL pipelines, reducing data processing time by 30%.
  • Proficient in data engineering methodologies.
  • Led the migration of Packaging/Freight spend of ~130 mil from Domo to Power Bi and Azure Gen2 Blobs using Azure Pipelines and MySQL DB following medallion architecture.
  • Creating custom automation scripts using Advanced Python and Power Automate to ease the company's workload.
  • Scraping web with UiPath and Power Automate to get the latest SKU prices for suggesting better alternatives to members.
  • Produced detailed savings analysis reports on PowerBI using Azure to create insights for the team.
  • Proficiently executed complex SQL queries on Panoply to extract, manipulate, and analyze large datasets.

Education

B. Tech. - Electronics And Communication Engineering

V.I.T. Chennai
Chennai, Tamil Nadu
05.2020

Skills

  • Python
  • SQL
  • Pyspark
  • Power Automate
  • Azure
  • Machine Learning
  • Azure Synapse
  • Pipelines
  • AWS
  • Data Analysis
  • ETL
  • Data Warehousing
  • Web Scraping
  • Data validation
  • Data Science
  • Predictive Analysis
  • Data Modeling

Certification

Scored 94% in "Data Science and ML" certification offered by Coding Ninjas (6 month rigorous course)

Projects

Image Recognition using C.N.N., Aether box Optimization, Instagram Bot, Packaging File Checker

Accomplishments

  • 5-star Badge in MySQL on Hackerank.
  • 5- star Badge in Python on Hackerank.
  • Awarded best paper for "Gesture Controlled Surveillance Rover" in the 18th VICFNT and got published in Springer.
  • Took part in Graduate Rotation Program from the Sparks Foundation and completed the internship with appraises.

Timeline

Data Analyst

Procure Analytics
08.2022 - Current

Program Analyst/Automation Analyst

Cognizant
08.2020 - 08.2022

B. Tech. - Electronics And Communication Engineering

V.I.T. Chennai

Similar Profiles

CREATE PROFILE
Pranshu Dhyani