Data Analyst - BI, SQL, Python, ETL, dashboards

Aayush C.

Data Analyst

Kent, WA

*+ years experience React Spring Boot AWS Microservices

Work Authorization: F1 OPT (STEM eligible until 2027)

Open to relocation anywhere in the U.S

Email: *******************@*****.***

Phone: 928-***-****.

LinkedIn: https://www.linkedin.com/in/aayush-chaudhary-5339a61a2/

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience in data analysis, business intelligence, and reporting. Strong expertise in SQL, Power BI, Tableau, Python, and Excel, with hands-on experience building ETL pipelines, data models, KPI dashboards, and automated reporting solutions.

Proven ability to translate business requirements into actionable insights through data visualization, forecasting, and advanced analytics.

Experienced in Agile environments supporting operational, product, and leadership stakeholders.

Technical Skills:

Data Analytics & BI Tools

Power BI, Tableau, Excel (Advanced Formulas, PivotTables, Power Query, VBA), Google Sheets, KPI Dashboards, Data Visualization

Programming & Query Languages

SQL (Joins, Subqueries, CTEs, Window Functions), Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, Statsmodels), R (Basic)

Data Engineering & ETL

SSIS, ETL Pipelines, Data Warehousing, Data Marts, Data Cleansing, Data Validation, Reporting Automation

Data Modeling & Analysis

Star Schema, Snowflake Schema, Financial Forecasting, Time Series Analysis, A/B Testing, Ad-hoc Analysis, Root Cause Analysis

Tools & Methodologies

Power BI Service, JIRA, Confluence, Power Automate, Microsoft Office 365, Agile Scrum, SDLC

PROFESSIONAL EXPERIENCE:

Chatbot.team – Gurugram, India

Data Analyst Jan 2021 – Aug 2024

Designed and delivered 20+ Power BI and Tableau dashboards tracking chatbot performance, agent productivity, workflow efficiency, and operational KPIs used by operations, product, and leadership teams.

Built optimized Power BI data models (star schema) and advanced DAX calculations, improving dashboard load performance by 25–35%.

Developed interactive Tableau dashboards using LOD expressions, parameters, and actions, enabling leadership teams to perform self-service analysis and reducing ad-hoc reporting requests by ~30%.

Wrote and optimized complex SQL queries to process and analyze millions of chatbot conversation records from logs, CRM systems, and relational databases.

Implemented data validation and quality checks, reducing reporting discrepancies and data issues by ~40%.

Conducted root-cause and funnel analysis to identify conversation drop-offs and escalation drivers, contributing to a 10–15% improvement in chatbot resolution rates.

Automated recurring reports and data preparation workflows using Python and SQL, cutting manual reporting effort by 40–50% and improving report delivery SLAs.

Supported A/B testing and experimentation analysis for chatbot features and conversation flows, improving intent accuracy and user engagement.

Established single-source-of-truth dashboards and standardized KPI definitions, improving data governance and reducing metric mismatches across teams.

Partnered with product managers, operations, and leadership stakeholders to convert business requirements into actionable, data-driven decisions.

Environment: Power BI, Tableau, DAX, SQL, Python (Pandas, NumPy), SSIS, Star Schema, Data Warehousing, ETL Pipelines, KPI Dashboards, A/B Testing, Agile Scrum, JIRA, Confluence, SQL Server, Oracle

Chatbot.team – Gurugram, India

Junior Data Analyst Jan 2020 – Dec 2020

Supported end-to-end analytics projects in an Agile environment, from requirement gathering through deployment and production support.

Designed and maintained data warehouses and data marts, supporting reporting for multiple operational and product teams.

Developed and maintained Power BI and Tableau dashboards connected to SQL Server and Oracle databases for daily and weekly business reviews.

Created and optimized SQL queries, stored procedures, views, and indexes, improving query execution times by 20–30%.

Built and maintained SSIS ETL pipelines for data ingestion and transformation, ensuring reliable and timely data availability.

Performed ad-hoc analysis using SQL and DAX, supporting leadership decision-making and operational reviews.

Assisted in developing SSAS Tabular models for analytical reporting and dashboard consumption.

Provided backend data support to improve report accuracy, consistency, and performance across BI platforms.

Environment: Power BI, Tableau, SQL, DAX, SSIS, SSAS Tabular, SQL Server, Oracle, Data Warehousing, ETL, Excel, Agile Scrum

EDUCATION:

Master of Science in Business Administration (Business Analytics) (Northern Arizona University)

Bachelor of Technology in Civil Engineering

Contact this candidate