Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Saurabh Raghuvanshi

Saurabh Raghuvanshi

Kanpur

Summary

An enthusiastic, self-determined Data professional having hands on experience working on large and complex datasets of Crime Data , sales analysis, my proactive and adaptable approach help me work on multiple projects at the same time. I have an active approach towards Data, eager to assist in design and development of new business solutions by bringing strong Analytical mindset and extreme dedication to help the organization comprehend its long-term goals. Having solid foundation in statistical analysis, data visualization and data analytics. Technical skills: Python, SQL, Advance Excel and visualization.

Overview

4
4
Certifications
2
2
Languages

Work History

Data Analytics (Engineer)

NA
05.2025 - Current
  • Performed data cleansing, normalization, aggregation, and transformation using complex SQL queries and Python functions.
    Leveraged open-source datasets to simulate real-world business scenarios.
  • Data Analysis & Reporting
    Utilized advanced Excel functions (VLOOKUP, HLOOKUP) for efficient data management and retrieval.
    Created and automated Excel reports in Power BI, improving efficiency and minimizing manual errors.
    Built pivot tables and dashboards to analyze, summarize, and present key business metrics.
  • SQL Data Analysis
    Conducted data validation and trend analysis using SQL subqueries, joins, window, and analytical functions.
    Ensured data accuracy through comprehensive SQL methodologies.
  • Exploratory Data Analysis (EDA)
    Performed in-depth EDA to identify customer behavior and trends.
    Applied statistical methods (descriptive statistics, probability distributions) to uncover insights.
    Visualized findings using Seaborn and Matplotlib; presented outcomes to peers and mentors.

Education

Masters in Data Science With Power BI - Data Analytics

ConsoleFlare - Online Data Analytics And Data Science
Noida, India
04.2001 -

Bachelor of Technology - Electronics And Communications Engineering

Dr. A. P. J. Abdul Kalam Technical University, Lucknow
Lucknow, India
04.2001 -

Skills

  • Postgre SQL

  • Data Visualization

  • Reporting

  • Problem Solving

  • Time Management

  • Data Management

  • Written and Oral Communication

  • Attention to detail

  • Programming & Tools: Python, SQL Server, Power BI, Advanced Excel

  • Python Libraries: Pandas, NumPy, Seaborn, Matplotlib

  • Data Handling: Data Cleaning, Transformation, Normalization, Aggregation

  • Statistical Analysis: Descriptive Statistics, Probability Theory, Distributions (Normal, Binomial)

  • Business Intelligence: Pivot Tables, Report Automation, Data Visualization

  • ETL & Data Processing: End-to-end pipeline design, SQL queries, data validation

Certification

PostgreSQL By Udemy

Timeline

Data Analytics (Engineer)

NA
05.2025 - Current

Masters in Data Science With Power BI - Data Analytics

ConsoleFlare - Online Data Analytics And Data Science
04.2001 -

Bachelor of Technology - Electronics And Communications Engineering

Dr. A. P. J. Abdul Kalam Technical University, Lucknow
04.2001 -
Saurabh Raghuvanshi