Shashank Gubba
AI Data Analyst | Business Analyst
Open to Work
Denver, CO
2 weeks notice
Open to remote
Identity verified
Links
Looking for
- Role
- Data Analyst
- Experience
- 4 years
- Time zone
- Mountain Time (US & Canada)
Skills
Expert
AWS Lambda
Excel
Google BigQuery
Google Sheets
SQL Server
Advanced
Amazon Redshift
Data Modeling
Data Quality
Data validation
GCP
Looker Studio
NumPy
Pandas
PostgreSQL
Power BI
Python
Reporting Automation
SQL
Intermediate
A/B Testing
ETL pipelines
FastAPI
LLM integration
LSTM forecasting
REST APIs
Scikit-learn
Tableau
TensorFlow
dbt
Beginner
Anthropic SDK
Beautiful Soup
Confluence
Docker
Document Chunking
Embeddings
FAISS
Git
Jira
LangChain
LangSmith
OpenAI API
PII Redaction
Prompt Engineering
RAG
Selenium
Semantic Search
Experience
-
Data Analyst
JP Morgan Chase
01/2024 – 06/2025
- Built Tableau dashboards and recurring reports backed by Amazon Redshift to surface transaction patterns across a $35M card portfolio, reducing report delivery time by 35%.
- Developed Redshift SQL queries to pull, clean, and integrate transaction data from multiple sources for recurring credit-card KPI reporting, reducing audit preparation time by 30%.
- Automated SQL and PostgreSQL data-quality checks for business and regulatory reporting, standardizing review processes and improving dataset accuracy by 25%.
- Analyzed transaction patterns using spending, location, device, and timing data to refine criteria for flagging unusual activity across a $35M portfolio and reduce false positives by 22%.
- Automated transaction ETL with Python and AWS Lambda, reducing transformation latency by 15% and accelerating data availability for near-real-time evaluation.
- Standardized reporting workflows in Jira and Confluence and automated audit-preparation tasks, saving 24 analyst hours per sprint or 576 hours annually.
-
Data Analyst
Macy's
08/2022 – 12/2023
- Designed and evaluated segmented A/B tests using SQL and Bluecore across 12+ seasonal campaigns, translating campaign performance into insights that increased campaign ROI by 18% and conversion by 22% under a flat budget.
- Built TensorFlow LSTM demand forecasts using BigQuery campaign and demand data to support seasonal planning, improving forecast accuracy by 25% over the prior season.
- Automated sales and promotion reporting with Python and Looker Studio, centralizing campaign performance insights and eliminating more than 10 hours of manual work per week.
- Optimized BigQuery workloads through query rewrites, materialized views, and clustering across a $600K GCP footprint, reducing annual BigQuery spend by $80K and contributing to $240K in cross-functional savings.
- Standardized dbt attribution workflows with validation tests and clarified data ownership with governance and engineering leads, enabling self-service BI and reducing post-deployment defects by 40%.
-
Data Analyst
Deloitte
05/2020 – 07/2021
- Analyzed subscriber cohorts and authentication failures with SQL and Python, presented findings in clear business terms to product and engineering teams, and helped develop retention experiments that increased subscriber lifetime value by 15%.
- Delivered Power BI executive dashboards using consolidated payment, subscription, and revenue data, enabling self-service access to transaction and cash-flow metrics and reducing report turnaround time by 40%.
- Built Python and SQL Server ETL pipelines with automated reconciliation to consolidate financial data, supporting on-time monthly close and reducing refresh cycles by 35%.
Education
- Belhaven University PhD · Business Administration and Management
- University of Colorado Denver Master's · Business Analytics Class of 2023
- JNTU Hyderabad Bachelor's Class of 2020
app.talnflo.com/u/shashank-gubba