Skip to content
Chayan Aggarwal Résumé

Chayan Aggarwal

Business Analyst · Bridgeport, CT

Chayan Aggarwal. A business analyst who finds the cause behind the numbers.

STEM MBA in Business Analytics at the University of Bridgeport, finishing December 2026. Before that, two-plus years in marketing. I read data the way a doctor reads test results, then recommend what to do about it.

  • STEM MBA in Business Analytics
  • BCA
  • 2+ years in the field
  • SQL
  • Python
  • Power BI
  • Available January 2027
Scroll

At a glance

Role
Business Analyst · Data Analyst · Marketing or Customer Analytics
Available
January 2027
Location
Bridgeport, CT · open to hybrid and remote
Education
STEM MBA, Business Analytics · University of Bridgeport · Dec 2026 · GPA 4.0
Experience
2+ years in marketing · Brand Thrust, TaskTracker.in
Tools
Excel · Python · R · SQL · SAS · Power BI

Case files

Case files

Six projects, each written up the same way. Where there was no measured result, the case says so.

Credentials

Training and residency

Experience

  1. Dec 2023 – Jul 2024 / New Delhi

    Brand Thrust

    Marketing Manager

    Managed client accounts end to end, from goals to performance analysis to reporting.

    • Diagnosed underperforming content using performance data and lifted engagement.
    • Built weekly KPI reports that moved spend toward what converted.
  2. Jan 2022 – Jul 2023 / Noida

    TaskTracker.in

    Marketing Executive

    Optimized customer acquisition for a task-management SaaS product.

    • A/B tested paid search to bring down cost per click.
    • Grew organic traffic with a data-led content strategy.

Education

Education
DegreeSchoolDates
MBA, Business Analytics (STEM) · GPA 4.0University of BridgeportJan – Dec 2026
PGDM, MarketingPune Institute of Business ManagementAug 2024 – Apr 2025
Bachelor of Computer ApplicationsJagan Institute of Management StudiesAug 2018 – May 2021

Leadership

Leadership roles
PresidentIndian Students Association, University of BridgeportApr 2026 – present
SecretaryIndian Students Association, University of BridgeportJan – Apr 2026
Speaker of the HouseStudent Government Association, University of Bridgeport

Toolkit

Diagnostics
  • Excel
  • Python (Pandas)
  • R
  • SQL
  • SAS
Reporting
  • Power BI
  • KPI dashboards
  • Executive summaries
Domain
  • Marketing analytics
  • Customer behavior
  • Campaign ROI
  • Market research
Certifications
  • SAS Programming
  • Power BI
  • Microsoft Excel
  • SAP
  • Six Sigma
  • Agile Project Management

Model lab

Eleven problems. Eleven methods.

Case work from Cases in Business Analytics during my PGDM at the Pune Institute of Business Management, 2024–25. Each one starts with a business decision, not with a model.

  1. Binary logistic regression

    Concentrix: who will miss a premium?

    Built a payment-default flag from auto-debit status and days past due, modeled it across 24,399 policy records, and read accuracy, sensitivity and specificity from the confusion matrix. Compared calls, SMS and email on a cost-versus-renewal-impact matrix.

    Logistic regression · Confusion matrix · Cost matrix

  2. Artificial neural network

    Wallet churn with a one-node network

    Min-max scaled usage and tenure, split the data 75/25, trained a neuralnet model to predict customer churn, plotted the network and checked it against a confusion matrix.

    R · neuralnet · caTools · Scaling

  3. Classification

    Scaleneworks: predicting offer renege

    Modeled whether 12,333 candidates who accepted an offer would actually join, using notice period, offered versus expected hike, joining bonus, relocation and sourcing channel.

    HR analytics · Behavioral modeling

  4. Retention modeling

    Scholastic Travel: will the group come back?

    Worked with 2,389 school trips and more than 50 variables, from parent meetings and payment plans to school size, to predict whether a group would re-book the next year.

    Customer retention · Feature engineering

  5. Demand forecasting

    iD Fresh Food: forecasting perishable demand

    Prepared beat-level daily sales for a short-shelf-life SKU, flagged outliers with the interquartile range, and framed a forecast where both stock-outs and waste are expensive.

    Excel · IQR outliers · Time series

  6. Linear programming

    Shawls or Stoles: the most profitable mix

    Costed seven woollen products, wrote the objective function to maximize gross profit, and solved for production quantities under 15 days of weaving and knitting labour.

    Excel Solver · Objective function · Constraints

  7. Scenario analysis and NPV

    Trionym Systems: should the RB-5000 launch?

    Built every combination of market size, share and production cost, projected five years of after-tax cash flow, and ruled out the scenarios that didn't clear the $50M investment by 10%.

    Scenario modeling · Depreciation · Present value

  8. Conjoint analysis

    What buyers trade off

    Used dummy-variable regression to turn preference rankings into part-worths: juice flavor, pack and size for a beverage brand, and city and plant size for Trionym's India factory.

    Excel regression · Part-worth utilities

  9. Analytic hierarchy process

    Choosing a brand ambassador

    Turned pairwise judgments on brand equity and fitness into weighted scores to choose among three Indian athletes for a sports-apparel launch, then applied the same method to a market-entry choice.

    AHP · Pairwise comparison · Weighting

  10. Market sizing

    ByteIQ: license it or build a platform?

    Estimated customers and first-year revenue for an analytics product under two business models, using the technology adoption curve for innovators and early adopters.

    TAM · Adoption lifecycle · Revenue model

  11. Apriori association rules

    BigBasket: "Did you forget?"

    Mined basket data for item pairs at 50% minimum support and 70% confidence, the logic behind a grocery app's Smart Basket and forgotten-item prompts.

    Market basket analysis · Support · Confidence

Symptoms

Sound familiar?

Industry research, not my results. This is the problem I want to work on.

  1. Symptom

    78%

    Data everywhere, answers nowhere.

    78% of executives say they struggle to use their data effectively. The dashboards exist, but nobody trusts them enough to act.

    Source: Talend executive data survey, 2021

  2. Symptom

    1 in 3

    Big calls made on gut feel.

    More than a third of executives still decide on instinct, and nearly half of sales and marketing leaders make most decisions without data.

    Source: Talend, via MediaPost

  3. Symptom

    26%

    A quarter of the marketing budget is leaking.

    One study puts waste at 26% of total marketing spend, roughly $1 in every $4. Another found 21 cents of every media dollar lost to poor data.

    Source: Rakuten via Entrepreneur; Forrester for Marketing Evolution

These aren't three problems. They're symptoms of one condition: decisions made without a clear reading of what the business is telling you.

Treatment

How I treat a business

Same discipline every time. No guesswork, no jargon.

  1. 01 / Intake

    Listen first.

    I start with the business goals and what's keeping leadership up at night. The real problem is rarely the one on the ticket.

  2. 02 / Tests

    Run the numbers.

    I pull and clean the data in SQL and Python, then look for where revenue leaks, costs creep and customers drop off.

  3. 03 / Diagnosis

    Find the root cause.

    This is where marketing and business experience matters. Numbers show what changed; experience explains why.

  4. 04 / Prescription

    One clear recommendation.

    A plain-English answer, the expected impact, and the next step.

  5. 05 / Follow-up

    Track the recovery.

    A dashboard to track whether the change is working.

Why me

Analyst skills, with marketing experience behind them

What Chayan brings, with the evidence for each
Reads the dataExcel, Python, R, SQL, SAS, Power BI
Knows why customers behave that way2+ years running campaigns at Brand Thrust and TaskTracker.in
Has worked with real spendA/B tested paid search; weekly KPI reports that moved spend toward what converted
A recommendation, not just a reportEvery case file ends in a prescription
Process disciplineSix Sigma · Agile

The data shows what changed. Field experience helps explain why. I bring both.

Second thoughts, answered

Are you early in your analytics career?

Yes. I worked in marketing first, so I know which numbers a business acts on. The STEM MBA added the technical depth.

Can you handle technical work?

My first degree is a Bachelor of Computer Applications. The case files list the tools and methods behind each project.

Will you fit our industry?

Every business runs on the same vital signs: revenue, cost, customers and retention. I've already changed fields once, from marketing into analytics.

About

Why I practice this way

I didn't start in analytics. I started in the field.

After a degree in computer applications, I spent two years in marketing, running campaigns for a SaaS startup and managing brands for agency clients. I watched smart people make expensive decisions on instinct. Some worked. Many didn't. And almost nobody could say why.

That's when it clicked. Businesses don't fail for lack of effort; they fail from problems nobody diagnosed in time. A doctor doesn't guess. They run tests, read the results and treat the cause. I wanted to bring that same discipline to business.

So I went back to school for a STEM MBA in Business Analytics. Now I combine both sides: the technical skill to read the data, and the field experience to know what it means for revenue.

Contact

Hiring an analyst for 2027?

I'm looking for Business Analyst, Data Analyst and marketing or customer analytics roles starting January 2027. Email is the fastest way to reach me.

Roles
Business Analyst · Data Analyst · Marketing or Customer Analytics
Start
January 2027 (MBA completes December 2026)
Location
Bridgeport, CT, open to hybrid and remote