Power Bi Business Analyst

Ashvita Chourey

CA, USA +1-217-***-**** ****************@*****.*** LinkedIn

PROFESSIONAL SUMMARY

Analytical and detail-oriented Business Analyst with around 5 years of experience leveraging tools like Power BI, Tableau, Python, and SQL to deliver actionable insights across advertising, operations, finance, and marketing domains. Skilled in ETL automation, dashboard development, and predictive modeling, with hands-on expertise in Azure, AWS, Snowflake, Synapse, and Informatica. Demonstrated success in streamlining analytics workflows, enhancing reporting accuracy, and supporting cross-functional teams through Agile and SDLC methodologies. Certified in Microsoft Power BI and Tableau Data Analysis, with project experience in machine learning models, ad revenue optimization, and credit risk prediction. EDUCATION

University of Illinois at Urbana Champaign Illinois, USA Master of Science in Information Management GPA: 3.91/4 August 2021 - May 2023 Medi-Caps Institute of Technology and Science Indore, India Bachelor’s of Engineering Computer Science and Engineering GPA: 9.0/10 August 2015 - June 2019 TECHNICAL SKILLS

Programming & Scripting Languages: SQL, Python, DAX, M, C++, HTML, CSS, Excel (Advanced), Google Sheets Frameworks & Libraries: pandas, NumPy, SciPy, TensorFlow, Statistics, Bootstrap Data Warehousing & Processing: Azure Synapse, Snowflake, Databricks, SSAS, Informatica Cloud Platforms & DevOps: Microsoft Azure (Cloud, Synapse, Storage), AWS, GitHub Databases & Tools: MySQL, SQL Server Management Studio (SSMS), Visual Studio, Eclipse BI & Data Visualization: Power BI, Tableau, Power Query, DAX, Excel Dashboards Project Methodologies & Collaboration: Agile (Scrum), JIRA, Confluence PROFESSIONAL EXPERIENCE

ZS Associates (Microsoft) San Francisco, CA, USA

Business Technology Associate Consultant June 2023– Present

Engineered 6+ executive-level dashboards in Power BI and Azure Cloud, enabling leadership to track KPIs and accelerate performance reviews across multiple Microsoft Azure campaigns.

Trained XGBoost and Random Forest models using Python to identify top contributors to gross ad revenue, guiding onboarding of 10+ new publishers to the Microsoft Advertising network.

Devised A/B testing frameworks for marketing experiments using SQL and Azure DevOps, shortening decision cycles and optimizing targeting for 3 product categories.

Integrated cross-functional feedback from Finance, Sales, and Marketing teams into centralized reporting architecture, aligning data outputs with evolving business priorities.

Automated analytics pipelines with Python, SQL, and Azure Data Factory, reducing manual reporting efforts by 12 hours per week and improving on-time delivery.

Partnered with engineering and advertising teams to validate campaign performance insights, supporting accurate forecasting for multi-million-dollar revenue streams.

Developed reusable templates for campaign performance analysis using Python Notebooks, improving data team efficiency during high-volume campaign cycles.

Documented technical processes in Confluence and GitHub, enabling onboarding for 3 new analysts and improving cross-team collaboration across ongoing Azure initiatives.

ZS Associates San Francisco, CA, USA

Business Technology Associate Intern May 2022– August 2022

Designed KPI dashboards using Power BI and Excel, supporting Finance and Operations leaders in tracking performance across 12+ metrics.

Authored BRDs and FRDs to automate reporting pipelines using SQL and Azure DevOps, eliminating 10+ hours of manual effort weekly.

Executed ad hoc data analyses and business modeling in Python and Excel, guiding compensation strategy for 3 business units.

Collaborated with offshore Agile teams across 2 time zones, ensuring sprint deliverables aligned with stakeholder priorities and timelines.

Validated reporting logic using SQL queries against enterprise data sources, ensuring consistency across dashboards and operational reports.

Streamlined reporting formats for operational data, enhancing usability for cross-functional teams and improving communication efficiency.

Conducted system testing on automated data flows using Python scripts, reducing errors in scheduled reports for senior leadership.

Facilitated client workshops to gather analytics requirements, influencing the design of scalable and maintainable reporting products. Tata Consulting Services Pune, India

SystemEngineer/Analyst June 2019 – June 2021

Constructed Tableau-based reporting infrastructure to support Inclusion Data initiatives within the insurance domain, enabling executive-level insights.

Automated processing of millions of data rows using AWS Glue, SSAS cubes, and ETL workflows, supporting real-time analytics across 5+ insurance products.

Developed 10+ interactive dashboards with global filters and KPI indicators in Tableau, enhancing clarity in monthly performance reviews.

Integrated AWS-based pipelines with on-premise databases, establishing seamless data synchronization for cross-platform reporting.

Defined data validation rules and transformation logic in SQL and Power BI, ensuring reporting accuracy for strategic insurance metrics.

Collaborated with data architects and product managers to align analytics design with business requirements and compliance standards.

Conducted UAT sessions for dashboard rollouts, collecting feedback from 5 stakeholder groups and implementing iterative improvements.

Streamlined quarterly reporting cycles, reducing turnaround time and improving retention analysis accessibility for business leads. Oil and Natural Gas Corporation India

Data Analyst Intern June 2018 – August 2018

Designed real-time monitoring dashboards in Power BI using global filters, enabling visibility into refinery operations across 3 processing units.

Analyzed chemical process logs using SQL and Excel, identifying delays and supporting performance optimization in crude distillation.

Collaborated with cross-functional refinery teams to define KPI metrics, aligning reporting outputs with operational safety standards.

Implemented data wrangling techniques with Python (Pandas) to clean 50,000+ records, improving data accuracy for monthly analysis reports.

Streamlined reporting workflows by automating data ingestion from refinery systems, saving 6 hours/week of manual effort.

Documented data sources, ETL logic, and reporting dashboards, enabling seamless handovers and supporting future scalability.

Conducted root cause analysis of production anomalies using trend analysis, contributing to corrective action plans with the engineering team.

Delivered findings in stakeholder meetings with chemical and refinery heads, translating raw analytics into actionable process improvements.

PROJECT AND LEADERSHIP

Research Assistantship - Agriculture department, UIUC

Collaborated with the USDA to analyze farmer stress data across 50 U.S. states, identifying regional mental health trends using Python and SQL.

Managed and updated content for FarmStress.org, integrating Tableau dashboards with live datasets to reflect real-time stress metrics by demographic segments.

Built automated data pipelines to process survey inputs and visualize insights via Tableau, supporting public health reporting and academic publications.

Credit Score Predictor Personal Project

Cleaned and analyzed 300,000+ credit records using Python (Pandas, NumPy), extracting key statistical features such as kurtosis and skewness to assess variable distribution.

Designed and tuned classification models using Logistic Regression, SVM, Random Forest, and k-NN, optimizing hyperparameters to boost recall and precision on imbalanced datasets.

Visualized model performance using ROC curves and confusion matrices, selecting the best-performing algorithm for production deployment based on F1 score and AUC metrics.

Mentor Girls Who Code – Online Summer Camp

Instructed 15+ girls aged 12–17 in Python programming fundamentals, data visualization, and algorithm design through virtual workshops and weekly coding challenges.

Provided one-on-one guidance on final capstone projects, enabling students to develop interactive web applications using HTML, CSS, and JavaScript.

Promoted inclusion and engagement by creating a collaborative learning environment, leading group discussions and troubleshooting code errors in real time.

CERTIFICATION

Microsoft Tableau Coursera: Certified: Certified: Data Science Data Power Specialization Analyst BI Data : Analyst by Johns Associate Hopkins University

Contact this candidate