Sanjana Aitham
Analyst
4+ years exp
4+ years ML exp
Python
SQL
Active 1 day ago
+1 (520) 4910650 Invite to interview
Message
Download CVCV
Overview
Technical skills
Timeline
Roles
Overview
Data analyst with 3+ years of experience working with credit card rewards and ERP datasets. Proficient in SQL and Python (Pandas, NumPy) and building analytics pipelines and models with dbt and Apache Airflow for curated reporting. Builds dashboards in Power BI and Tableau and uses statistical methods such as A/B testing and regression-style modeling for promotion and conversion analysis.
Technical skills
Python• Middle • 4y+
SQL• Middle • 4y+
Python
Hypothesis
Databases
PostgreSQL
Snowflake
MySQL• 4y+
Amazon Redshift
Google BigQuery
AI/ML
Pandas• 4y+
Airflow
dbt
NumPy
Scikit-learn
DevOps
Azure
GCP
Rest API
AWS
Git
Analytics
Power BI• 4y+
Tableau
Timeline
Data Analyst
•
Middle
Capital One
•
Full-Time
Analyzed daily application, activation, transaction, and redemption data for a rewards program using SQL and Amazon Redshift to inform post-launch portfolio decisions. Automated Python-based dataset transformations for S3-to-Redshift workflows with Apache Airflow, cutting weekly reporting effort while preserving scheduled refreshes. Built KPI-consistent dbt models and dimensional schemas to support reporting across Power BI and Tableau, and performed data validation with SQL/dbt tests to reduce reporting exceptions. Ran A/B and hypothesis-driven evaluation of promotions and used basic regression modeling to identify factors behind application completion and early card usage.
SQL
Python
Pandas
NumPysince 2026
Google BigQuery
Airflowsince 2026
dbtsince 2026
AWSsince 2026
Power BI
Tableausince 2026
Scikit-learnsince 2026
Jirasince 2026
Confluencesince 2026
Gitsince 2026
Data Analyst
•
Middle
Capital One
•
Full-Time
Analyzed daily application, activation, transaction, and redemption data for the T-Mobile Visa rewards program to support post-launch portfolio decisions. Automated Python transformation workflows using Pandas and NumPy for AWS S3 to Amazon Redshift, orchestrated with Apache Airflow to cut weekly reporting preparation time. Built and maintained dbt models and dimensional schemas to standardize KPIs across Power BI, Looker, and Tableau, and validated datasets using SQL, Python, and dbt tests. Evaluated conversion and redemption trends with dashboards and applied A/B testing and regression-style modeling to compare reward promotions.
SQL
Python
Pandas
NumPy
AWS
Amazon Redshift
Airflow
dbt
Power BI
Tableau
Scikit-learn
Git
Jira
Confluence
Northern Arizona University
Master's Degree •
Information Technology
Data Analytics Associate
•
Middle
SageSoft Technologies
•
Full-Time
Analyzed ERP sales and inventory data with SQL to identify discrepancies and improve reporting accuracy. Built ETL workflows in Python using Pandas to extract, transform, and process transactional data, reducing weekly manual processing time. Created Power BI dashboards for AR aging and cash flow analysis to reduce Days Sales Outstanding, and performed data validation on MySQL datasets to resolve duplicates and improve data quality. Coordinated with sales, finance, and operations teams to deliver weekly reports and insights that reduced stockouts.
SQLsince 2022
Pythonsince 2022
Pandassince 2022
MySQL
Power BIsince 2022