Rishi Singh

Data Analyst

Delhi-110088, India 80 · Excellent

About

Results-driven Data Analyst with comprehensive expertise in Power BI, Advanced Excel, MySQL, and Python. Proven track record in designing automated MIS reporting frameworks, engineering end-to-end interactive KPI dashboards, and building robust relational database schemas. Highly adept at optimizing multi-source ETL pipelines, formulating complex DAX calculations, and translating high-volume raw transactional data into actionable business intelligence that accelerates strategic decision-making.

Skills & Expertise (37)

Power BI Advanced

8.5/10

Years Exp

Power Query Advanced

8.0/10

Years Exp

DAX Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Complex SQL queries Advanced

7.5/10

Years Exp

ETL Architecture Advanced

7.5/10

Years Exp

Data Cleansing Advanced

7.5/10

Years Exp

Exploratory data analysis Advanced

7.5/10

Years Exp

Python Advanced

7.5/10

Years Exp

MySql Advanced

7.5/10

Years Exp

Query Optimization trend forecasting Root Cause Analysis Data Validation Star Schema KPI Tracking Statistical Modeling Snowflake Schema Data Wrangling Drill-through Bookmarks NumPy Pandas Row-Level Security INDEX Aggregations Subqueries CTEs Window Functions Scheduled Refresh Relational Database Management XLOOKUP Executive Reporting Slicers Power Pivot Dynamic Arrays MATCH

Work Experience

Data Analyst

Enterprise Business Intelligence & Sales KPI Dashboard Suite

Present - Present

Architected multi-page interactive Power BI dashboards tracking executive revenue metrics, regional sales KPIs, and product performance trends across 100K+ transactional records. Automated multi-source extraction, data cleansing, and ETL workflows using Power Query, reducing weekly manual MIS reporting turnaround time by 40%. Engineered 25+ custom DAX measures utilizing Time Intelligence, Year-over-Year (YoY) growth calculations, dynamic filtering, and KPI targets to support executive decisions. Structured normalized Star Schema data models with defined one-to-many relationships and surrogate keys, optimizing report rendering speed and query execution by 35%. Built synchronized Excel MIS reporting workbooks with XLOOKUP, INDEX/MATCH, and Power Pivot for rapid ad-hoc variance and operational tracking.

Data Analyst

Automated Python & MySQL Analytics Pipeline

Present - Present

Engineered normalized (3NF) relational database schemas with robust primary/foreign key constraints and indexing rules to ensure strict data integrity. Developed automated Python ETL scripts leveraging MySQL Connector to query, transform, and update high-volume operational databases without manual overhead. Formulated and tuned complex SQL queries utilizing Window Functions (ROW_NUMBER, RANK), subqueries, and multi-table joins to generate backend analytics tables. Conducted comprehensive Exploratory Data Analysis (EDA) with Pandas and Matplotlib, identifying data anomalies, outlier patterns, and actionable commercial trends.