Priyanshu Singh

// data_analyst.py

Priyanshu Singh

 

Turning raw data into decisions. Experienced in Python, SQL & Power BI — across global salary benchmarks, job markets, physics experiments & enterprise data pipelines. India.

0
Records Processed
0
Major Projects
0
Data Points Analyzed
0
Certifications Earned
0
Tools & Technologies

// about_me

About Me

Priyanshu Singh

Experience

1+ Year
Data Analysis

Education

B.C.A & M.Sc.
Data Science

Scope

Global Projects
Multi-domain

Location

Gurugram, India

I'm a Data Analyst with hands-on experience using Python, SQL, and Power BI to analyze complex datasets and surface actionable business insights. I've worked with healthcare and pharmaceutical sales data, built executive dashboards, conducted a large-scale analysis of 69,000+ job postings across 26 industries, and explored high-energy physics event data using research-style workflows.

Currently pursuing M.Sc. in Data Science at Chandigarh University and actively seeking data analyst roles.

// work_and_education

Experience & Education

WORK

Jun 2025 – Feb 2026
Sales Data Analyst
Ikvans Healthcare Pvt. Ltd.
  • Analyzed ~30,000 batch-wise sales records using Excel & SQL
  • Prepared monthly reports on product trends & distributor performance
  • Identified fast & slow-moving products for inventory & pricing decisions
Jan 2025 – Jul 2025
Data Analyst Intern
AAM Infotech Pvt. Ltd., Gurugram
  • Cleaned & validated ~50,000 records using Python & SQL
  • Built Power BI & Excel dashboards to track KPIs
  • Performed EDA on ~20,000 records, identifying critical anomalies

EDUCATION

Aug 2024 – Jun 2026 (Expected)
M.Sc. in Data Science
Chandigarh University
Specializing in data analysis, machine learning and statistical computing.
Jul 2024 – Jul 2025
Data Analytics
Ducat IT Training School
Python, SQL, Power BI, Excel — hands-on analytics training.
2020 – 2023
B.C.A
L.N. Mishra College of Business Management
Foundation in computer science, programming and business applications.

// tech_stack

Skills & Expertise

Python (Pandas, NumPy, Regex)90%
SQL (Joins, CTEs, Window Functions)88%
Power BI (DAX, KPI Cards, Slicers)85%
MS Excel (Advanced)85%
Exploratory Data Analysis88%
Google BigQuery75%
Matplotlib & Seaborn80%
Git & GitHub82%

// recent_projects

Projects

// hover a card to flip and see details

Insurance Forecasting

Insurance Sales Forecasting

213K+ records · 3 ML models · Power BI dashboard

Python SQL Power BI Prophet Random Forest

[ hover to flip ]

Insurance Sales Forecasting

  • Analyzed 213K+ insurance agency records across 6 states (2005–2014)
  • Built 3 predictive models — Linear Regression, Random Forest (R²=0.848), Prophet
  • Identified incurred losses & new business as top premium predictors
  • SQL queries for YoY growth, top agencies & state-wise financial health
  • 3-page Power BI dashboard — descriptive + predictive analytics
India Job Market

India Job Market Analysis 2024

59,669 Naukri.com postings · 13 cities · Salary & skills insights

PythonMySQLPower BIRegex

[ hover to flip ]

India Job Market Analysis 2024

  • Collected 59,669 real Naukri.com postings across 13 cities — resolved duplicates & city name inconsistencies in 5 formats
  • Used Regex to extract min, max & avg salary from unstructured text across 4 different formats
  • Wrote 8 SQL queries with CTEs & RANK() — city pay, skill demand & experience vs salary
  • Delhi NCR pays highest (~15 LPA avg); Bangalore leads in job volume (20K+ postings)
  • SQL & Machine Learning are top in-demand skills; Tier-1 significantly outpays Tier-2
Malaysia

Malaysia Job Market Analysis 2024

69,024 job postings · 26 industries · Salary benchmarks

PythonSQLPower BIRegex

[ hover to flip ]

Malaysia Job Market Analysis 2024

  • Analyzed 69,024 JobStreet postings across 26 industries
  • Extracted salary data using Regex across 31,594 records
  • Found Penang pays 32% more than KL (RM 7,216 vs RM 5,468/month)
  • SQL CTEs & RANK() to rank industries by salary & demand
  • Interactive Power BI dashboard with KPI cards & slicers
HEP

High-Energy Physics Data Analysis

Particle collision events · Statistical analysis · Reproducible workflow

PythonNumPyPandasMatplotlibJupyter

[ hover to flip ]

High-Energy Physics Data Analysis

  • Analyzed synthetic particle collision data mimicking real detector output
  • Cleaned unphysical values, missing measurements & detector noise
  • Computed momentum magnitude & applied physics-motivated selection
  • Simulated detector resolution effects on energy measurements
  • Full reproducible Jupyter notebook with fixed random seeds
Global Salary

Global Data Salary Insights

Global salary trends · Data roles · Remote work impact

PythonBigQueryPower BIEDA

[ hover to flip ]

Global Data Salary Insights

  • Analyzed global salary trends across data roles internationally
  • BigQuery CTEs & window functions to identify hiring hotspots
  • Experience-level salary growth & remote work impact via EDA
  • Interactive Power BI dashboard with global compensation benchmarks
Pipeline

Large-Scale Data Validation Pipeline

1M+ records · Cleaning & validation · Reproducible workflow

PythonSQLJupyterPandas

[ hover to flip ]

Large-Scale Data Validation Pipeline

  • Built a cleaning pipeline for a dataset with over 1 million records
  • Validation rules: duplicates, missing values & invalid data
  • Automated referential integrity & format inconsistency detection
  • Full reproducible Jupyter notebook workflow

// languages

Languages

🇬🇧
English
Professional
🇮🇳
Hindi
Native
🇩🇪
German
Beginner / Learning

// certifications

Certifications

🏅
IBM Data Science
Coursera · IBM
Comprehensive data science program covering Python, SQL, data visualization and machine learning fundamentals.
View Certificate ↗
🏅
Career Essentials in Data Analysis
Microsoft + LinkedIn
Industry-aligned certification covering data storytelling, Excel and core analytics workflows.
View Certificate ↗
🏅
Journey into Data Science with Python
CodeSignal
Hands-on Python data science track covering Pandas, NumPy, data wrangling and exploratory analysis.
View Certificate ↗
🏅
SQL (Intermediate)
HackerRank
Verified SQL proficiency covering complex queries, joins, subqueries and aggregations.
View Certificate ↗

// get_in_touch

Contact Me

email

maanapriyanshu@gmail.com

LinkedIn

linkedin.com/in/maanapriyanshurajput