Business Analyst Power Bi

GUNEET SINGH ***************@*****.*** +1-419-***-****

PROFESSIONAL SUMMARY

Analytical and detail-oriented Business Analyst skilled in SQL, Tableau, Power BI, Excel, and SAS. Experienced in using data-driven methods to uncover insights, build predictive models, and support strategic decision-making. Proficient in Agile practices, stakeholder engagement, and visualizing KPIs through interactive dashboards. Backed by hands-on experience and certifications in business analysis, reporting tools, and project collaboration platforms. SKILLSET

• Business Analysis: SQL, Excel, Requirement Gathering, Use Cases, User Stories, Stakeholder Engagement, BPMN/UML

• BI and Reporting: Dashboarding (Tableau/Power BI), KPI Monitoring

• Data Management: Data Cleaning, Wrangling, and Extraction

• Project Management: JIRA, Agile, Scrum, Waterfall, Kanban, Confluence, Lucidchart

EDUCATION

Master’s in Applied Business Analytics

University of Toledo, Toledo Ohio (August 2024 - May 2025) GPA: 3.67

Bachelor of Management Studies

University of Mumbai, India (May 2020 - May 2023) GPA: 9.38

PROJECT WORK

Essentials of Business Analytics: Robust RFM Customer Segmentation using Tableau and Mysql – 05/2025

Used SQL to clean and prepare Superstore sales data for RFM segmentation

Built an interactive Tableau dashboard segmenting 5,000+ customers into VIPs, At-Risk, and others

Identified that VIPs made up 18% of customers but contributed 42% of total revenue, supporting targeted campaign strategies

Data Mining: Customer Churn Prediction for a Telecom Company – 11/2024

Analysed data of 7,000+ customers to find key reasons for churn using SAS Enterprise Miner

Built a model with 89.7% accuracy using HP Forest (ROC 0.965, Gini 0.93)

Found high churn linked to monthly charges, short contracts, and low tenure, guiding retention strategies

Business Analytics & Cases: Ticket Sales Optimization for Lollapalooza (Music Concert) – 04/2025

Forecasted 2025 Ticket demand (~386K) using Regression and Monte Carlo simulations

Found $1 price hike cuts demand by ~1,140 Tickets; 10% more marketing boosts it by ~3–4%

Recommended ~289K tickets (Critical Ratio = 0.881) using the Newsvendor Model to maximize revenue

PROFESSIONAL EXPERIENCE

Automobile Marketing & Sales Analyst, Prime Corporation – Mumbai, India June 2023 – November 2023

Analysed sales data in Excel and identified top-performing vehicle segments, increasing inventory efficiency by 12%

Maintained and organized 7,000+ customer and sales records, improving data accuracy and retrieval time by 25%

Created weekly reports and dashboards using pivot tables and charts, enabling the sales team to track performance and optimize pricing decisions

CERTIFICATIONS

Excel: Excel for Business Analysts by Project Management Institute ( PMI )

MySQL: MySQL Data Analysis ( LinkedIn Learning )

Tableau: Tableau 2024 Essential Training ( NASBA )

Power BI: Power BI Essential Training ( NASBA )

JIRA: Streamline JIRA Administration with Effective Governance ( Atlassian )

Requirements Elicitation and Analysis ( PMI )

Managing Project Stakeholders ( PMI )

Contact this candidate