I turn messy data into decisions teams act on.

SQL + PythonSnowflake + dbtTableau + Power BIOpen to roles
analyst_search.sqlsnowflake
SELECT name, role, years, focus
FROM   analysts
WHERE  metrics_are_trusted = TRUE
  AND  dashboards_get_used = TRUE
  AND  city = 'Philadelphia';
1 row returned · 0.04s
nameroleyearsfocus
Nakshatra AgarwalSenior Data Analyst5+BI, AML, forecasting
Nakshatra Agarwal
Nakshatra AgarwalSenior Data Analyst at Protiviti, MS Machine Learning Engineering, Drexel ’23

Results, with the source attached

Every number here comes from work I owned end to end. The case studies below explain how a few of them happened.

ResultWhat changedWhere
$1.2MBudget reallocated based on growth insights from healthcare product analyticsE-Solutions, 2025
+18%Conversion lift after I built the KPI framework and A/B testing setup from scratchE-Solutions, 2025
$175KExcess cost cut per year by forecasting models that improved accuracy 15%E-Solutions, 2024
−27%Churn, after funnel and cohort analysis found what was driving itSpectrum WebApps, 2021
2Suspicious activity reports supported by anomaly analytics I built on Snowflake and AWSProtiviti, 2025–26
−35%Documentation time, after bringing AI tools into SQL and documentation workProtiviti, 2026

Case studies

Each one follows the same path: the question someone needed answered, the data I had, what I did with it, and the decision it led to.

The dashboards were fine. Nobody agreed on what they measured.

QuestionWhy did five analytics consumers report five different values for the same KPI?
DataCompeting SQL logic, undocumented filters and dashboards built on different definitions.
AnalysisTraced each number back to its query, agreed one definition per metric and documented it.
DecisionOne shared set of definitions. Reporting discrepancies gone and teams trusting the numbers again.

Anomaly analytics that held up in front of regulators.

QuestionWhich behavioral patterns point to real money-laundering risk, and how do regulators see them?
DataTransaction data on Snowflake and AWS, modeled into AML features with dbt.
AnalysisAnomaly detection plus AI-assisted text analytics for root cause, shown in 4+ Tableau dashboards with row-level security.
DecisionFindings directly supported two SAR filings, and three non-technical teams now self-serve their reports.

A better forecast turned out to be a cost-cutting tool.

QuestionCan sales and operations plan from forecasts instead of padding for uncertainty?
DataHistorical sales and operational data in SQL.
AnalysisBuilt forecasting models in Python and SQL, with automated validation checks on the inputs.
DecisionForecast accuracy up 15%, which removed $175K a year in excess cost.

Experience

Consulting, product and compliance analytics, in that order.

  1. Senior Data Analyst

    Protiviti, Philadelphia

    AML compliance analytics on Snowflake and AWS, dbt models for AML features, and regulator-facing Tableau dashboards. Moved Excel reporting to automated SQL workflows.

  2. Data Analyst II, Analytics & BI

    E-Solutions, San Francisco

    Healthcare product analytics, KPI frameworks and A/B testing. Owned the monthly reporting cycle through to VP-level presentations.

  3. Data Analyst I, Analytics & BI

    E-Solutions, San Francisco

    Forecasting models and self-serve Tableau and Power BI dashboards for Finance, Marketing and Product, which shortened executive decision cycles by 32%.

  4. MS, Machine Learning Engineering

    Drexel University, Philadelphia
  5. Data Analyst

    Spectrum WebApps, Gurgaon

    Funnel and cohort analysis that cut churn 27%, and reporting frameworks that made product teams 30% more self-sufficient.

  6. Data Analyst

    ZS Associates, New Delhi

    SQL and BI dashboards for healthcare and life sciences clients across 15+ accounts, plus VBA automation and time-series forecasts.

Side projects

Built to get hands-on with tools before I needed them at work.

Credit card transaction pipeline

End-to-end analytics engineering: distributed cleaning in PySpark, warehouse models in Snowflake and dbt, automated quality checks.

13/13
data quality checks passed
49K
clean rows processed
PySpark, Snowflake, dbt, Great Expectations
View code on GitHub

Retail demand forecasting

ARIMA and ETS compared across 5 stores, with hypothesis tests to measure what promotions actually do to sales.

76.6%
average forecast accuracy
+593
units a day from promotions (p<0.001)
R, ARIMA, ETS, hypothesis testing
View code on GitHub

AWS inventory ETL pipeline

Event-driven pipeline that cleans inventory data and sends low-stock alerts. Tested locally with moto at zero AWS cost.

785/808
rows cleaned automatically
132
low-stock alerts triggered correctly
S3, Lambda, DynamoDB, SNS
View code on GitHub

Earlier research: cell segmentation with SVMs (98.3% training accuracy) and sentiment analysis of film reviews weighted by each character’s impact.

Tools I use

Grouped by the part of the job they cover.

Analysis

  • SQL
  • Python (pandas, NumPy)
  • R, SAS
  • A/B testing
  • Forecasting
  • Statistical modeling

Data and cloud

  • Snowflake
  • dbt
  • Databricks, PySpark
  • AWS (S3, Lambda, EC2)
  • Data quality and governance
  • Git

BI and reporting

  • Tableau
  • Power BI, DAX
  • Looker
  • Microsoft Fabric
  • KPI frameworks
  • Executive reporting

AI and automation

  • Claude Code
  • OpenAI API
  • GitHub Copilot
  • Excel VBA and macros
  • Agile and Scrum

Have a metric nobody trusts?

I’m open to senior data analyst, BI and analytics engineering roles. If your teams report five different numbers for the same thing, I’d like to hear about it.