Open to opportunities

Awantika Shah

@awantikashah

Message

Business Intelligence Analyst turning complex data into measurable insights.

United States

Message

What I'm looking for

I’m looking to drive data-informed decisions by building scalable BI/analytics, designing KPIs, automating reporting, and running A/B tests—so teams get measurable impact and better forecasting.

I’m a data professional with 6+ years of experience transforming complex datasets into actionable business and product insights. I bring advanced proficiency in SQL, Python, Tableau, and statistical analysis to drive KPI visibility and decision-making.

In my most recent role as a Business Intelligence Analyst at Audi of America, I automated reporting workflows using SQL, Tableau, and Power BI, reducing reporting time by 40%. I also built executive dashboards leveraging Snowflake and AWS S3 to deliver real-time visibility into KPIs.

I’ve consistently paired deep data work with cross-functional collaboration—partnering with finance and operations to translate business requirements into scalable analytics solutions. I conduct trend, variance, and forecasting analysis using Python and Excel, and I implement data validation and quality checks within ETL pipelines to improve reporting reliability.

Earlier, I worked as a Data Analyst at Stop Online Puppy Mills, analyzing structured and unstructured datasets in Python and SQL to find anomalies and trends, and creating Tableau data stories to support stakeholder decisions. I also bring experience across business analysis and application development, including building interactive Power BI dashboards and designing A/B testing strategies that improved conversion performance.

Experience

Work history, roles, and key accomplishments

After sales Business Intelligence Analyst

Audi of America

Jul 2023 - Jan 2026 (2 years 6 months)

Automated and maintained reporting workflows and executive dashboards to provide real-time KPI visibility. Performed customer behavior and forecasting analysis, and implemented ETL data validation checks to improve accuracy and reliability.

SQL Tableau Power BI Snowflake Python Excel ETL Data Validation KPIs Forecasting

Data Analyst

Stop Online Puppy Mills

May 2022 - Jun 2023 (1 year 1 month)

Analyzed structured and unstructured dealer datasets to identify anomalies and trends and performed root-cause analysis. Created Tableau data stories to communicate KPIs to stakeholders for data-informed decisions.

Python SQL Tableau Data Anomalies Root Cause Analysis

Business Data Analyst

Tuljaram Chaturchand College

Jan 2018 - Jan 2021 (3 years)

Produced reports for Finance, Admissions, and Student Affairs using SQL and Excel. Built Power BI dashboards and collaborated with stakeholders to define data needs and improve insights on enrollment and retention.

SQL Excel Power BI Dashboarding Data Reporting

Business Analyst

Ferrero India Pvt. Ltd.

May 2016 - Dec 2016 (7 months)

Completed ad hoc data requests using Excel and created interactive dashboards using SSRS to deliver insights. Conducted market research and competitive analysis using Qualtrics to identify market trends and improve marketing campaign performance.

Excel Qualtrics Market Research Competitive Analysis Dashboarding

Application Developer

Feelsofts

Aug 2014 - Aug 2015 (1 year)

Developed and maintained web-based applications for corporate systems using HTML5, ASP.NET, and SQL. Designed and executed an A/B testing strategy and used statistical analysis to compare interface versions and improve conversion rate.

HTML5 ASP.NET SQL A B Testing Statistical Analysis Web Application Development