Aabid Quazi

// 01

Technical Stack

🗄️

Databases & SQL

MySQL PostgreSQL SQL Server Advanced SQL Query Optimization Stored Procedures

📊

BI & Visualization

Power BI DAX Power Query Tableau Advanced Excel VBA

🐍

Programming & Analytics

Python Pandas NumPy Data Cleaning EDA

⚡

Power Platform

Power Apps Power Automate Dataverse Workflow Automation

🤖

Automation & Macros

Excel VBA Macros Macro Development Process Automation Image Resolution API Reporting Automation

// 02

Featured Projects

01 Existing

SalesInsights — AtliQ Hardware

Data Analyst · SQL Developer · BI Developer

End-to-end sales analytics solution for a hardware distributor operating across multiple Indian markets. Designed a MySQL database schema, wrote complex analytical queries, and built an interactive Tableau dashboard that replaced manual Excel reporting across regional teams.

MySQL SQL Tableau Data Modelling ETL Star Schema

15+

SQL Queries

Dashboards

∞

Manual Hours Saved

Designed normalized MySQL schema with fact & dimension tables using star schema
Wrote advanced SQL queries — JOINs, CTEs, window functions for revenue trend analysis
Built Tableau dashboard with drill-down by region, product, and time period
Uncovered top 5 revenue markets and flagged underperforming zones for management
Replaced manual Excel MIS reports, saving hours of weekly reporting effort

02 New · Real World

FinGuard — Expense Fraud Detection

Data Analyst · SQL Developer · BI Developer · DBA

A real-world financial analytics system to detect anomalous and potentially fraudulent corporate expense claims. Uses SQL pattern analysis, Python-based statistical outlier detection, and a Power BI risk dashboard — giving finance teams a live fraud monitoring tool with zero manual effort.

PostgreSQL Python Pandas Power BI DAX IQR Method Z-Score

94%

Detection Accuracy

₹2.1L

Flagged Value

Faster Review

Designed PostgreSQL schema for 50,000+ expense transactions across departments
Built SQL rules engine: duplicate claims, weekend submissions, round-number anomalies
Implemented IQR + Z-Score outlier detection in Python to flag statistical anomalies
Created Power BI risk dashboard with color-coded risk tiers and department drilldowns
Identified ₹2.1 lakh in potentially fraudulent claims across 3 departments in test dataset

// 03

Work Experience

Feb 2025 — Present
Airoli, Mumbai

eClerx Service Limited

Data Analyst

Analysed large product datasets including attributes and categories; performed data cleaning, transformation, and visualization using SQL and Power BI
Built advanced Excel reports using Pivot Tables, complex formulas, and Macros for structured daily and weekly reporting to stakeholders
Developed a standout VBA Macro that fetches image resolution directly from URL links — eliminating a manual, time-consuming QC bottleneck and saving significant hours per week
Built multiple automation macros across teams to streamline repetitive reporting and audit workflows
Travelled to Coimbatore office to train 45 employees on data tools, workflows, and best practices — and continues to lead and support this team remotely
Performs daily Audit, QC, and research; leads a team and oversees quality of data deliverables

Mar 2024 — Feb 2025
Airoli, Mumbai

Schneider Electric Limited

Project Engineer

Maintained structured project documentation, daily progress reports, and data records for a large-scale data center installation
Supervised and led installation teams; tracked operational data for HVAC systems including chillers, ODUs, and PAHU units
Coordinated cross-team reporting and ensured data accuracy across commissioning and testing phases
Developed strong analytical thinking and team leadership skills applied directly to current data analyst role

// 04

About Me

I'm a Data Analyst based in Mumbai with 2+ years of analytical experience. My engineering background from SVKM's Institute of Technology gave me a structured, systems-thinking mindset — which I now apply to databases, dashboards, and automation.

I specialize in the full analytics stack: from SQL query design to Power BI dashboards, Python-based analysis, and Excel VBA macro development. One of my proudest builds is a macro that retrieves image resolution directly from URLs — a real productivity win that saved my team countless hours.

I've also trained and led a team of 45 analysts, which means I understand data from both the builder and the communicator's perspective. Currently looking for roles in Data Analytics, BI Development, SQL Development, or Database Administration where I can build systems that genuinely improve how teams make decisions.

Certifications

Data Analysis with Python IBM

MySQL — Database Management Great Learning Academy

Data Analytics Job Simulation KPMG AU · Forage

Financial Analyst Job Simulation NY Jobs CEO Council · Forage

Excel Skills Job Simulation JPMorgan Chase · Forage