Yashwanth Velpoori

Yashwanth Velpoori

About

Detail

Senior Analytics & BI Engineer at AWS | Helping Teams Make Faster Decisions with Data | SQL · Snowflake · Redshift · Python · Tableau · Airflow
Austin, Texas, United States

Contact Yashwanth regarding: 
work
Full-time jobs
Starting at USD100k/year

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Amazon Web Services
    Business Intelligence Engineer
    Amazon Web Services
    Oct 2024 - Current (1 year 7 months)
    • Led end-to-end sales operations analytics initiative for AWS services sales tracking, partnering with program leaders, defining KPIs and delivering SQL views and Tableau dashboards, reducing manual tracking activity by 60%. • Re-architected a Redshift analytical model into a star schema by consolidating 3 data sources into a single source of truth, building a semantic layer with data quality validations, and reducing query runtime from 8+ min to 3 min. • Designed Python ETL pipelines using AWS Glue (Apache Spark) and Airflow for CI/CD to orchestrate Salesforce-to-Redshift ingestion, applying data quality checks across 1B daily records, ensuring zero data loss and reliable pipeline availability. • Led root-cause analysis and troubleshootin
  • K
    Senior Business Analyst
    Kraft Analytics Group
    Aug 2023 - Aug 2024 (1 year 1 month)
    • Built SnapLogic ETL pipelines using Python and Prefect for orchestration, to extract, transform and aggregate 800 million fan records from flat files, SFTP, and APIs into Snowflake, enabling reliable attendance and revenue reporting. • Led a cross-functional team to build and deploy Tableau dashboards integrated with Snowflake for real-time game day attendance and revenue analysis across 4 NFL teams, improving revenue tracking accuracy by 70%. • Designed and executed A/B tests for email marketing using Salesforce Marketing Cloud and Snowflake, Python to validate a 27.5% CTR lift, generating $100K in incremental annual concessions revenue.
  • University of Connecticut
    Data Analytics Student Assistant
    University of Connecticut
    Apr 2022 - May 2023 (1 year 2 months)
    Skills: A/B Testing · Web Analytics · E-Commerce Consulting · e-commerce sales · Tableau
  • Accenture
    Senior Analyst
    Accenture
    Aug 2020 - Jan 2022 (1 year 6 months)
    • Engineered real-time Spark-based ETL pipelines processing 1B daily events, ingesting and validating raw data into AWS Redshift with automated data quality and governance checks, enabling data scientists to build and deploy credit risk models. • Led a team of 3 to build a real-time Tableau dashboard powered by Redshift, tracking delinquency rates and default probability KPIs for credit risk analysts, saving 25 hours of manual reporting per week.
  • Accenture
    Business Intelligence Analyst
    Accenture
    Feb 2018 - Jul 2020 (2 years 6 months)
    • Developed 7+ Power BI dashboards using DAX calculated columns and measures to analyse claim denial rates, reimbursement cycles, and adjudication status, reducing manual reporting for claims analysts by 80%. • Optimised SQL queries using CTEs, joins, and window functions to clean and aggregate medical claims data, establishing a reliable data foundation for claims analysts to track approval rates and processing turnaround time.
Education verified_user 0% verified
  • UNIVERSITY OF CONNECTICUT SCHOOL OF BUSINESS
    Masters, Business Analytics and Project Management, , Business Data Science
    UNIVERSITY OF CONNECTICUT SCHOOL OF BUSINESS
    Jan 2022 - May 2023 (1 year 5 months)
    Coursework: Data Management and Business Process Modeling (SQL) Predictive Modeling (Machine Learning) Statistics in Business Analytics (R Programming Language) Data Science using Python (Numpy, Pandas, Seaborn, Matplotlib, Scikit-Learn) Visual Analytics (Tableau) Advanced Business Analytics and Project Management (Capstone Project) Big Data Analytics with Cloud (AWS) Data Mining and Business Intelligence (SAS) Business Decision Modeling (Optimization techniques) Web Analytics (Google Analytics) Introduction to Project Management (MS Project, Project Charter, Gantt Chart) Project Risk Management and Agile Methodologies (JIRA) Project Leadership and Communication Technical Communication in Business Analytics