Use arrow keys to move, Enter to jump, Esc to close.

Atlanta, GA

Deepa Shenoy

Data Analyst

3+ years building pipelines, data models, and dashboards with SQL, Python, Snowflake, AWS, and Power BI.

Portrait of Deepa Shenoy

Profile

I’m a Data Analyst with 3+ years of experience in analytics, ETL/ELT development, and business intelligence.

I build scalable data pipelines, dimensional models, automated reporting workflows, and interactive dashboards. The work has improved reporting efficiency by 35%, cut data errors by 20%, and contributed to roughly $1M in cost optimization.

Based in
Atlanta, GA
Experience
3+ years
Graduate degree
MS in Information Systems, Northeastern University
Certifications
Databricks SQL Analyst Associate · AWS Solutions Architect – Associate
  • Data engineering

    Kafka ingestion, dbt models in Snowflake, and Airflow orchestration for insurance claims, policy, and billing data at Technocolabs.

  • Business intelligence

    Power BI, Tableau, and Looker Studio dashboards for claims anomalies, campaign KPIs, and event operations.

  • Research & AI/ML

    NLP and stylometric analysis on AI-generated text detection and hallucination patterns at Northeastern University.

Experience

Four roles, most recent first.

  1. Sep 2025 to presentBoston, MA

    Data & Operations Analyst

    Northeastern University

    50+ university events consolidated into standardized KPI dashboards

    • Built Tableau, Looker Studio, and Excel dashboards consolidating operational and digital metrics across 50+ events, improving recurring reporting efficiency by 20%.
    • Automated Python-based extraction, cleansing, and reporting workflows on Google Cloud, integrating multi-platform event and engagement data.
    • Ran regression analysis, audience segmentation, and trend analysis with Google Analytics, YouTube Analytics, and Tableau, contributing to 15–20% gains in campaign effectiveness.
    • Analyzed staffing, attendance, and shift coverage with SubItUp and advanced Excel to find bottlenecks and standardize scheduling.
    • Reconciled event, web, and social datasets and partnered with coordinators and directors to define operational KPIs and turn findings into recommendations.
    • Tableau
    • Looker Studio
    • Python
    • Google Cloud
    • Google Analytics
    • Excel
  2. Jan 2025 to May 2026Boston, MA

    Research Assistant, AI/ML & Data Analytics

    Northeastern University

    35% gain in research-analysis efficiency

    • Supported faculty-led research on AI-generated text detection and hallucination patterns using Python, Pandas, and exploratory data analysis.
    • Prepared and validated text datasets for NLP and stylometric analysis: readability, lexical diversity, and sentence structure.
    • Ran preprocessing, missing-value analysis, feature exploration, and data-quality checks to keep analysis reproducible.
    • Reconciled 100+ academic and administrative records in Workday and Canvas, improving data accuracy by 25%.
    • Contributed to literature reviews, methodology documentation, and presentation materials for publication preparation.
    • Python
    • Pandas
    • NLP
    • Workday
    • Canvas
  3. Sep 2022 to Aug 2024Remote

    Data Engineer

    Technocolabs Software

    ~$1M in cost optimization supported by Power BI insights

    • Engineered Python and Apache Kafka pipelines processing 100K+ insurance policy, claims, and billing records daily into Snowflake.
    • Developed reusable dbt staging, intermediate, and mart models, producing analytics-ready fact and dimension tables.
    • Orchestrated ETL/ELT with Apache Airflow DAGs, automating recurring reporting and improving efficiency by 35%.
    • Implemented SQL/Python reconciliation checks and dbt tests, reducing downstream reporting errors by 20%.
    • Traced incorrect claims KPIs through SQL root cause analysis, logged defects in ServiceNow, and validated fixes in Power BI.
    • Designed Snowflake dimensional models for claims, policies, and billing, improving reporting efficiency by 25%.
    • Built Power BI dashboards for claims anomalies, loss trends, and portfolio KPIs that contributed to about $1M in cost optimization.
    • Snowflake
    • dbt
    • Apache Airflow
    • Apache Kafka
    • Power BI
    • ServiceNow
  4. Jan 2022 to Jun 2022Remote

    Data Analyst Intern

    DLithe

    30% less manual data preparation

    • Built Python and SQL ETL pipelines on AWS S3 and AWS Glue for donor, campaign, and beneficiary data, cutting manual prep by 30%.
    • Built PySpark transformation workflows in Databricks to standardize multi-source records for reporting.
    • Optimized PostgreSQL and Amazon Redshift queries with reconciliation checks, improving data accuracy by 25%.
    • Automated validation with AWS Lambda, S3, and Python: duplicate detection, null checks, and consistency controls.
    • Analyzed campaigns with Google Analytics, Athena, and Pandas, supporting 15–20% improvements in resource allocation.
    • Designed Power BI dashboards with Power Query and DAX for campaign KPIs and donor engagement.
    • AWS Glue
    • Databricks
    • PySpark
    • Redshift
    • Lambda
    • Power BI

Query my impact

Every figure on my résumé sits in one table. Pick filters and the SQL writes itself, then runs in your browser.

Quick questions

Category

Query results from résumé metrics
CompanyMetricValue

Skills and tools

Tools marked with a dot are named in a specific role above.

Data engineering and analytics

SQL

Snowflake, PostgreSQL, Amazon Redshift, NoSQL; joins, aggregations, reconciliation checks

Python

Pandas, Flask, FastAPI, Streamlit, scikit-learn

  • Snowflake
  • dbt
  • Apache Airflow
  • Apache Kafka
  • Apache Spark
  • Databricks
  • Alteryx

BI and visualization

  • Power BI (DAX)
  • Tableau
  • Looker Studio
  • QuickSight
  • Advanced Excel
  • Excel VBA Macros
  • Google Analytics

Cloud platforms

  • AWS S3
  • AWS Lambda
  • AWS Glue
  • Athena
  • EC2
  • RDS
  • DynamoDB
  • EventBridge
  • IAM
  • CloudWatch
  • SNS
  • SES
  • Azure
  • Google Cloud

Languages, tools and ways of working

  • R
  • JavaScript
  • Git
  • GitHub
  • Docker
  • n8n
  • ServiceNow
  • Workday
  • Canvas
  • Google Sheets
  • Agile
  • Kanban
  • Sprints

Core skills

  • ETL/ELT Development
  • Dimensional Modeling
  • Dashboard Development
  • KPI Reporting
  • Trend Analysis
  • Forecasting
  • Root Cause Analysis
  • Data Quality
  • Data Governance
  • Ad Hoc Analysis
  • Business Analysis
  • Documentation

Education & projects

Master of Science · Sep 2024 to Apr 2026

Information Systems

Northeastern University

Boston, MA

Data Management & Database Design · Data Architecture & Business Intelligence · Business Analysis · Data Science Methods

Certifications

Databricks & AWS

  • Databricks SQL Analyst Associate
  • AWS Certified Solutions Architect – Associate

Projects

E-Commerce Data Pipeline (Medallion Lakehouse)

Built a Bronze → Silver → Gold PySpark pipeline over 100K+ Olist orders, with StructType schema enforcement, null-rate and row-count quality gates, 16 pytest tests, and 7 Gold KPI domains including RFM segmentation.

  • PySpark
  • Databricks
  • pytest
  • Data quality
View on GitHub

Marketing Campaign Performance Dashboard

Cleaned 120 campaign records to 104 in Python (deduplication, IQR outliers), then built an interactive dashboard with 13 KPI cards, 11 Chart.js visuals, and filters for ROI, CAC, CTR, and funnel drop-off across 6 ad platforms.

  • Python
  • JavaScript
  • Chart.js
  • KPI reporting
View on GitHub

Stock Market Analytics & Automated Reporting

Pulls daily prices from the Alpha Vantage API, calculates RSI and volume bounds, and renders Matplotlib charts into HTML reports emailed through Amazon SES, with recipients in DynamoDB and AWS mocked in unit tests.

  • Python
  • AWS SES
  • DynamoDB
  • Docker
View on GitHub

AWS IoT Heart-Rate Streaming Prototype

Generates synthetic heart-rate events for Amazon Kinesis, computes 60-second per-device averages and threshold flags in streaming SQL, and lays out a serverless data lake design with S3, Glue to Parquet, Athena, and QuickSight.

  • Kinesis
  • SQL
  • Bash
  • AWS Glue
View on GitHub

Exploratory Data Analysis Portfolio

Three Jupyter studies: 353K Boston crime records (2015–2018), 6,435 Walmart store-weeks, and Netflix daily returns and volume, backed by an offline script that runs all 100 notebook cells to check they reproduce.

  • Pandas
  • Matplotlib
  • Jupyter
  • Time series
View on GitHub

AI Workflow & Business Process Automation

Engineered 6 AI-powered workflows with n8n, OpenAI, and vector search, applying prompt engineering to automate business processes.

  • n8n
  • Docker
  • OpenAI
  • Groq

Financial Analysis & Investment Strategy Simulation

Ran scenario analysis and forecasting across 12 business cases in Excel to weigh cost optimization, supplier tradeoffs, and investment outcomes.

  • Excel
  • Financial modeling
  • Forecasting

Leadership

Presented analytics workflow optimization strategies to the Women in Data community and competed in a Tableau Hackathon on dashboard usability and data storytelling.

  • Women in Data
  • Tableau Hackathon