Suraj Girase - Resume

Profile

Data Analyst with hands-on experience building end-to-end analytics solutions using SQL, Python, Excel, and Power BI. Experienced in data cleaning, exploratory data analysis, dashboard development, KPI reporting, and translating business problems into actionable insights through real-world analytics projects. Co-authored a published research paper in deep learning.

Projects

Retail Intelligence & Business Analytics Platform

Python · SQL · MySQL · Power BI · Streamlit · Pandas · DAX

GitHub: github.com/SurajGirase8210/retail-intelligence-platform

Built an end-to-end retail analytics platform with a modular Python ETL pipeline for data extraction, transformation, validation, feature engineering, and MySQL database loading
Designed an optimized MySQL analytical database with SQL queries, indexes, views, stored procedures, data-quality validation, and performance optimization for analytical reporting
Developed interactive Power BI and Streamlit analytics dashboards covering executive performance, sales, customers, products, inventory, stores, promotions, and data exploration

Banking Loan Analytics Dashboard

SQL · Python · Power BI · DAX

GitHub: github.com/SurajGirase8210/Banking-Loan-Analytics-Dashboard

Integrated 307K+ customer records from multiple banking datasets (customer, bureau, previous application, installment payments) using Python for data cleaning, feature engineering, and EDA to create a unified dataset with 150+ features
Designed and executed 35+ business-focused SQL queries analyzing customer risk, loan portfolio quality, approval trends, repayment behavior, and outstanding debt
Developed a 6-page interactive Power BI dashboard (Executive Overview, Customer Risk, Credit Portfolio, Loan Applications, Payment Behavior, Navigation) with dynamic KPIs, DAX measures, slicers, drill-through, and cross-filtering
Delivered actionable insights supporting credit risk assessment and lending decisions

Supply Chain Analytics Dashboard

Power BI · Python · SQL · MySQL · DAX · Power Query

GitHub: github.com/SurajGirase8210/Supply-Chain-Analytics-Dashboard

Developed a 7-page interactive Supply Chain Analytics Dashboard using Power BI to analyze 180K+ global supply chain records across sales, customers, logistics, products, and geographic performance.
Designed a star schema data model, transformed data using Power Query, and created 30+ DAX measures to monitor KPIs such as Sales, Profit, Profit Margin, On-Time Delivery, Late Delivery %, and Average Order Value.
Implemented interactive navigation, bookmarks, slicers, KPI cards, maps, conditional formatting, and drill-through-ready dashboards to deliver actionable business insights and support data-driven decision-making.

HR Analytics Dashboard

Power BI · Python · SQL · DAX

GitHub: github.com/SurajGirase8210/HR-Analytics-Dashboard

Built an end-to-end HR analytics solution analyzing 3,000 employee records across attrition, performance, training, and workforce demographics
Developed 25+ DAX measures, interactive multi-page dashboards, KPI cards, and drill-down analysis to identify attrition drivers and workforce trends
Applied business storytelling techniques to generate actionable insights for workforce planning and executive reporting

Blinkit Business Intelligence Dashboard

Power BI · DAX · Power Query · Excel

GitHub: github.com/SurajGirase8210/Blinkit-Business-Intelligence-Dashboard

Designed an interactive Power BI dashboard analyzing 8,500+ sales records and built 10+ KPI reports evaluating sales performance, outlet efficiency, and inventory trends
Created 15+ DAX measures including Total Sales, Average Sales, Inventory Turnover, and MoM Growth metrics, reducing manual reporting effort
Generated actionable business insights to support inventory optimization and operational decision-making

Technical Skills

Data Analytics: Data Cleaning, EDA, KPI Development, BI Reporting, Data Visualization, Problem Solving

Tools: Power BI, SQL, Python, MySQL, MS Excel, Power Query, DAX, Git, GitHub

Cloud & Platform: Microsoft Azure, MS Fabric, Streamlit, Jupyter Notebook

Python: Pandas, NumPy, Matplotlib, Seaborn, Plotly, Scikit-learn

SQL: Joins, CTEs, Window Functions, Subqueries, Aggregations, MySQL

Excel: Pivot Tables, Conditional Formatting, VLOOKUP/XLOOKUP, Dashboards, Data Validation

Data Engineering: ETL Processes, Data Modelling (Star Schema), Data Warehousing

Statistics: Probability, Hypothesis Testing, Regression, A/B Testing

Education

Bachelor of Technology (B.Tech) — Computer Engineering

SSVPS's BSD College of Engineering, Dhule

Dr. Babasaheb Ambedkar Technological University (DBATU), Lonere

2022–2026
CGPA: 7.6/10

HSC (XII) — Science

North Maharashtra University

2020–2022
71%

SSC (X)

North Maharashtra University

2020
94%

Certifications

Python Certification — SevenMentors (2026)

SQL Certification — SevenMentors (2026)

Microsoft Excel Certification — SevenMentors (2026)

Power BI Certification — SevenMentors (2026)

Probability & Statistics — SevenMentors (2026)

Achievements

Co-authored a published research paper: "Image-Based Food Classification and Nutritional Estimation Using MobileNetV2" — developed a transfer learning model achieving 93.6% test accuracy across 101 food categories

Winner of College-Level Cricket Tournament, SSVPS's BSD College of Engineering — demonstrating teamwork, leadership, and competitive spirit