Data analyst → automation & agents

From SQL
to agents.

I'm Shah, a data analyst turning repeatable analysis into automated, tested workflows, with a person approving what matters.

See the work Download resume

Open to Data & BI Analyst roles · New York, NY

The workflow I build toward

  1. 01 · Query

    SQL on tested, documented tables

  2. 02 · Agent

    Drafts the analysis and flags what looks off

  3. 03 · Human review

    I check the result before it ships

  4. 04 · Decision

    Stakeholders get a clean, repeatable answer

  • 5+

    years in analytics

  • 700+

    NYC schools on automated dashboards

  • 80%

    faster report turnaround

  • +35%

    website traffic from market analysis

01

Selected work

Case study 01 · NYC Department of Health

Manual reports → automated school dashboards

700+ dashboards · 80% faster

A VBA macro and Power Query pipeline that turns staff spreadsheets into per-school PDF dashboards, filed by district in SharePoint.

  • Excel VBA
  • Power Query
  • SharePoint
Read the case study
Problem
School Medical Directors needed each school's health data (asthma rates, screening results) before site visits. Compiling it was a manual, file-by-file process, and 10+ staff editing shared inputs risked overwriting each other's work.
Approach
Designed a Power Query pipeline that consolidates inputs from 10+ staff into one dataset without touching the source files. Built an Excel VBA macro that formats a dashboard for every school, exports each one as a PDF, and files it into district-organized SharePoint folders.
How I checked it
Source files stay read-only, so every dashboard can be traced back to its inputs, and a single consolidated dataset removed overwrite conflicts.
Result
Dashboards for 700+ NYC public schools, delivered straight to Medical Directors, with report turnaround improved by 80%.

Case study 02 · NYC Department of Health

Gut-feel priorities → validated risk model

700+ schools · 6 weighted indicators

Co-built a School Risk Prioritization Model and independently re-ran it in Python before it reached management.

  • Python
  • Excel
  • PowerPoint
Read the case study
Problem
The Bureau of School Health needed a defensible way to decide which of 700+ public schools to prioritize, using several health and risk indicators at once.
Approach
Partnered with a colleague on a model ranking schools across 6 weighted indicators. Built a parallel analysis in Python to reproduce the ranking independently.
How I checked it
Compared the Python results against the model output and quality-checked the final ranked list before presenting it.
Result
A ranked, validated list of 700+ schools presented to management to guide where support goes first.

Case study 03 · Mirimus Inc.

Spreadsheet guesswork → forecasting dashboards

+20% forecast accuracy

Weekly test-volume, capacity and staffing forecasts for a COVID-testing lab serving B2B partners and NJ public schools.

  • SQL
  • Excel
  • Tableau
  • Shopify Analytics
Read the case study
Problem
A biotech startup's testing supply chain had to plan lab staffing and inventory around demand that changed week to week.
Approach
Designed weekly test-volume, capacity and staffing forecasting dashboards in Excel and SQL, plus recurring KPI dashboards on inventory and lab staffing in Shopify Analytics and Tableau.
How I checked it
Reviewed the dashboards in daily and weekly team meetings, where the operations team checked them against what actually happened.
Result
Forecasting accuracy improved by 20%, letting a team of 10+ lab technicians adjust schedules ahead of time.

Case study 04 · Serino Coyne (Omnicom)

Market research → holiday pricing strategy

+35% traffic · +25% conversion

Competitor and consumer analysis behind a new holiday-season pricing and promotion plan.

  • Excel
  • SQL
  • Market research
Read the case study
Problem
A client needed a holiday-season pricing and promotional strategy grounded in market data, not instinct.
Approach
Ran market trend research and competitor analysis, and analyzed 1,000+ consumer demographic and financial data points in Excel (SUMIFS, VLOOKUP, PivotTables) to inform pricing adjustments. Automated the recurring reports with SQL and Excel.
How I checked it
Recurring reports were automated rather than rebuilt by hand, so stakeholders saw consistent numbers every cycle, 20% faster.
Result
35% more website traffic, a 25% higher conversion rate, and a 20% increase in ticket sales.

Details are generalized. No confidential data is shown.

02

How I work

Trusted data

Pipelines that protect their sources: one consolidated dataset from 10+ contributors, and models re-checked independently in Python before anyone acts on them.

Automated workflows

If a report runs twice, it should run itself: VBA, Power Query and SQL replacing manual compiling, formatting and filing.

Human on the loop

Automation drafts; a person decides. I quality-check outputs and present them so stakeholders can act with confidence.

03

Experience

  1. Apr 2025 – Present

    NYC Department of Health (DOHMH)

    Data Analyst, Bureau of School Health

    • Co-built a School Risk Prioritization Model for 700+ schools and validated it with a parallel Python analysis.
    • Automated per-school health dashboards (VBA + Power Query) with PDF export to SharePoint, improving turnaround by 80%.

  2. Oct 2023 – Nov 2025

    Apple

    Product Specialist (Part-Time)

    • Analyzed customer purchasing patterns to recommend tailored bundles, averaging $250K in quarterly sales with 95+ NPS.
    • Connected 50+ local business prospects per quarter with Apple's Business Team, contributing to a 20% boost in B2B conversion.

  3. Mar 2022 – Apr 2023

    Serino Coyne by Omnicom

    Analyst, Client Insights

    • Market and competitor analysis behind a holiday pricing strategy: +35% traffic, +25% conversion.
    • Automated recurring reports with SQL and Excel, speeding up analysis turnaround by 20%.

  4. Feb 2022 – Nov 2023

    COOP Careers

    Data Analytics Instructor

    • Designed and taught a semester-long Excel, Tableau and SQL curriculum to 17+ students per semester, with 93% retention.

  5. Apr 2021 – Mar 2022

    Mirimus Inc.

    Junior Analyst, Sales & Operations

    • Built forecasting and KPI dashboards (Excel, SQL, Tableau) that improved forecast accuracy by 20%.
    • Streamlined 300+ weekly B2B inquiries in HubSpot and Monday.com, improving operational efficiency by 15%.
04

Skills & education

Analysis & BI

  • SQL (MySQL)
  • Python
  • Excel
  • Power BI
  • Tableau
  • PowerPoint

Automation

  • VBA
  • Power Query
  • Data pipelines
  • Report automation
  • Git
  • Google Colab

Methods

  • Dashboard design
  • KPI reporting
  • Forecasting
  • Cohort analysis
  • Market research
  • Competitor benchmarking

Platforms & domains

  • SharePoint
  • HubSpot
  • Shopify Analytics
  • Monday.com
  • Public health data
  • B2B sales analytics

Education

  • Zicklin School of Business, Baruch College (CUNY)M.S. Information Systems, Data Analytics concentration · Expected May 2027
  • Queens College (CUNY)B.A. Economics, Minor in Urban Planning · 2021

Certifications

  • Advanced Formulas and Functions in ExcelNASBA · 2024
  • AI for Data ProfessionalsAnalyst Builder
  • SQL coursework: Intermediate SQL, Joining Data, Hierarchical & Recursive QueriesDataCamp · 2025
05

Contact

Let's talk data.

Hiring for a data or BI analyst role, or have a reporting process that should run itself? Send a note and I'll get back to you.

shahariarshadab07@gmail.com linkedin.com/in/shahariar-shadab github.com/shahariar-shadab Download resume (PDF)