Mahhin Shahzad

Logo

Resume | LinkedIn | GitHub

BI Lead · Analytics Engineer specialising in financial data infrastructure and BI.

More about me

I'm Mahhin Shahzad — Analytics Engineer & Financial Data Specialist.

With a Computer Science foundation (3.8 CGPA) and 3 years leading BI in Fintech, I specialise in turning messy financial data into scalable, trustworthy architecture — bridging the gap between raw numbers and the systems that make sense of them.

My domain is financial data: Budgeting, ARR/MRR tracking, and AR/AP analysis — built on a Single Source of Truth that the whole business can rely on.

I work at the intersection of modern Analytics Engineering and smart data infrastructure, going beyond dashboards to deliver the executive and operational insight that drives real decisions.

Projects

7+
PowerBI
3
Python
4
Excel
sql-server 2
SQL

L’AMOUR Enterprise Data Architecture & BI Pipeline

📅 February 2025
Project Explanation Video by MAHHIN GAMING GATE
  • Architected an end-to-end Python and SQL ETL pipeline to bypass a legacy ERP system (Sage 50), transforming locked financial data into a scalable Bronze-Silver-Gold database architecture.
  • Engineered an advanced Power BI Composite Model combining historical Data Imports with live DirectQuery, enabling real-time budget scenario planning.
  • Implemented dynamic, multi-tenant Row-Level Security (RLS) across 12 global subsidiaries to ensure strict data governance and regional isolation.
  • Eliminated 60+ hours of manual monthly reporting and reduced decision latency by 95%, directly contributing to the retention of an at-risk enterprise subscription and contract renewal.

L’AMÒUR CFO View Dashboard

📅 January 2025

  • Utilized 24+ ratios for a comprehensive financial overview, focusing on risk, efficiency, capitalization, and liquidity.

  • Developed a beautiful, tailored dashboard providing a specific, high-level view for a Chief Financial Officer.

  • Integrated the ability to see benchmarking figures against specific industry standards for competitive analysis.

L’AMÒUR Events & Suites: YoY Comparison Dashboard

📅 Late 2024
View LinkedIn Post

  • Connected directly to Excel through SharePoint to create near real-time updating dashboard, eliminating manual refresh processes

  • Implemented 30+ complex DAX queries and 15+ bookmark states behind 5 button clicks

  • Created interactive Data Visualization with drill-through capabilities, custom tooltips, and KPI metrics

  • Saved client team 8 hours of weekly manual reporting work by upgrading their Excel dashboard into self-reporting Power BI dashboard

S&P 500 Comprehensive Recent Stocks Analysis

📅 Mid 2024
Open Notebook Download Dashboard

  • Conducted in-depth analysis of top S&P 500 tech companies (2019-2024) using fundamental, quantitative, and technical approaches.

  • Performed extensive EDA on recent changes, computing metrics and values, and executed 7+ time series analyses (volatility, risk, PE ratios, moving averages and many more).

  • Developed a live, dynamic candlestick dashboard for stocks and ETFs, offering real-time insights and dynamic visualizations.

  • Open Notebook to Checkout the Analysis in depth

S&P 500 Analysis Overview
S&P 500 Data Visualization
S&P 500 Stock Performance Chart
S&P 500 Technical Analysis
S&P 500 EDA Results
S&P 500 Key Metrics

<– THIS IS WHERE IT GOES

Hate Speech Data Analysis with Python

📅 Early 2024
Open Notebook View on GitHub

  • Developed a comprehensive Python project using 7+ major libraries (Pandas, Matplotlib, NLTK, Gensim, re, NetworkX, etc.).

  • Depicted complex Roman Urdu language with advanced techniques to make intricate patterns and meanings visually clear and understandable.

  • Built a pipeline for cleaning and standardizing Roman Urdu/Hindi multi-labeled datasets.
  • Conducted label distribution analysis and visualized Top Label with word clouds.
  • Trained Word2Vec embedding models and visualized embeddings with Matplotlib and Plotly.
  • Open Notebook to Check out Everything.

Enhanced Coffee Shop Sales Dashboard in Excel

📅 Mid 2024
LinkedIn Post View on GitHub

  • Used advanced Excel lookup functions such as XLOOKUP and INDEX-MATCH to smoothly merge data from Multiple sheets

  • Advanced visualizations, such as filled maps and scatter plots, were created to effectively depict branch performance across multiple nations while offering a clear geographic perspective.

  • Discovered recurring patterns, leading to strategic recommendations to reduce churn and boost profits (Check out LinkedIn post to see them all)

Data Analytics Job Survey Analysis with Power BI

📅 Late 2023

Read on Medium View on GitHub

  • Created an in-depth analysis of data-related jobs, with a particular focus on data analytics roles.

  • Implemented DAX queries to analyze and visualize rating questions, providing deeper insights into job satisfaction levels.

  • Conducted an in-depth analysis of the top priorities for the highest-earning individuals in the data field.
  • Visualized various complex textual aspects of the survey data, making it easier to comprehend and derive insights.

Walmart Sales Analysis

📅 2023

View on GitHub

Walmart Sales Analysis: Analyzing sales data for Walmart branches to optimize sales strategies.

  • Utilized advanced Joins and views to extract data from five Walmart branches.
  • Applied complex SQL functions for data aggregation and filtering, improving the reporting process.
  • Used Various Window Functions and CTE’S in the process
  • Created detailed visualizations with Python using Matplotlib and Seaborn, highlighting sales trends and key insights to optimize sales strategies.