Rohan Singh

Data Analyst

Lucknow, India 3+ yrs exp 93 · Outstanding

About

Data Analyst with hands-on project experience building end-to-end BI dashboards and uncovering business insights from large datasets using Power BI, SQL, and Python. Skilled in data modeling, KPI development, and pipeline automation, with a strong foundation in statistics and machine learning from a B.Tech in Computer Science (AI Specialization).

Skills & Expertise (40)

Pivot Tables Advanced

7.0/10

Years Exp

Microsoft Excel Advanced

7.0/10

Years Exp

Python Intermediate

6.8/10

Years Exp

Pandas Intermediate

6.8/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Exploratory data analysis Intermediate

6.0/10

Years Exp

Data Cleaning Intermediate

6.0/10

Years Exp

Data Transformation Intermediate

6.0/10

Years Exp

Data Wrangling Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

XLOOKUP Intermediate

6.0/10

Years Exp

Dashboard Development Intermediate

6.0/10

Years Exp

Seaborn Intermediate

5.5/10

Years Exp

Matplotlib Intermediate

5.5/10

Years Exp

Data Modeling Intermediate

5.5/10

Years Exp

Power Query Intermediate

5.5/10

Years Exp

DAX Intermediate

5.5/10

Years Exp

Feature Engineering Intermediate

5.5/10

Years Exp

Statistical Analysis Intermediate

5.5/10

Years Exp

Tableau Intermediate

5.5/10

Years Exp

Jira Intermediate

5.0/10

Years Exp

Git Intermediate

5.0/10

Years Exp

SQL Query Optimization Intermediate

5.0/10

Years Exp

Aggregations Intermediate

5.0/10

Years Exp

Window Functions Intermediate

5.0/10

Years Exp

CTEs Intermediate

5.0/10

Years Exp

Joins Intermediate

5.0/10

Years Exp

Fact & Dimension tables Intermediate

5.0/10

Years Exp

Star Schema Intermediate

5.0/10

Years Exp

Postgresql Intermediate

5.0/10

Years Exp

Data Integration Intermediate

5.0/10

Years Exp

ETL Pipelines Intermediate

5.0/10

Years Exp

Data Pipelines Intermediate

5.0/10

Years Exp

Warehouse Intermediate

5.0/10

Years Exp

Lakehouse Intermediate

5.0/10

Years Exp

OneLake Intermediate

5.0/10

Years Exp

Microsoft Fabric Intermediate

5.0/10

Years Exp

FastAPI Intermediate

4.5/10

Years Exp

Streamlit Intermediate

4.5/10

Years Exp

Work Experience

Membership Chair

IEEE Student Branch – BBDU

Nov 2024 - Present

Coordinated technical workshops and events, and led member recruitment through interviews and candidate shortlisting, to grow participation in the university’s technology community. Managed member engagement initiatives and role assignments, improving communication and collaboration between students and faculty.

Social Media Head

National Service Scheme (NSS)

Nov 2022 - Sep 2024

Led a team of 10 volunteers to manage social media campaigns and digital outreach, completing 240+ hours of community service through volunteer-driven initiatives and special camps. Analyzed engagement metrics to optimize content performance and improve reach across campaigns.