Business Analyst Power Bi

VISHAL JAGGA

Dartmouth, MA • +1-970-***-**** • ************@*****.*** • LinkedIn

SUMMARY

An Experienced Business Analyst and Business Strategist with 6+ years of expertise in delivering data-backed strategies in diverse industries, including banking, IT services, eCommerce, healthcare, fashion & textile. Skilled in SQL, Tableau, Power BI, and Excel for decision support, with expertise in Agile delivery, process optimization, and stakeholder alignment. Proven ability to translate complex requirements into scalable solutions that enhance performance, reduce costs, and drive business growth. WORK EXPERIENCE

Business Strategy Analyst - Consultant, Charlton College of Business, Dartmouth, MA February 2024 – May 2025

• Applied critical thinking to five years of admissions data using SQL and Excel insights from the analysis contributed to a 17% uplift in graduate program intake efficiency.

• Directed the design of a Power BI dashboard integrating faculty workload and student demand data the solution was embedded in academic planning cycles and reduced redundant course offerings by $100K.

• Delivered a strategic assessment report through Tableau, incorporating peer institution benchmarking and competitor analysis influenced the successful launch of two certificate programs aligned with labor market demands.

• Implemented cross-functional workflows in Slate and PeopleSoft for course registration and faculty scheduling, minimizing administrative delays and supporting smoother semester transitions.

• Facilitated team collaboration and led status syncs with academic staff, applying interpersonal and soft skills to align project milestones and ensure stakeholder engagement throughout decision-making.

• Built dynamic Excel-based scenario models incorporating tuition elasticity and demand forecasts output supported budget realignment toward online education, optimizing capital deployment.

• Managed the deployment of SQL-based reporting suites and Tableau dashboards for AACSB accreditation tracking these enhancements decreased compliance preparation time by over 60%.

Senior Business Analyst, Zentek Infosoft, Jaipur, IN September 2020 – July 2023

• Drove the transformation of business needs into Jira-based user stories and acceptance criteria, enhancing delivery precision across 5 Agile teams and cutting clarification loops by 35%.

• Outlined client-specific CRM workflows using BPMN and Figma for a leading textile manufacturer, reducing scope deviations and accelerating stakeholder approvals by two sprints on average.

• Supported product strategy for a global banking client by identifying feature adoption trends and sprint bottlenecks, informing backlog prioritization and contributing to a 20% increase in quarterly release velocity.

• Enabled insight-driven decision-making by structuring Tableau dashboards covering sprint performance, customer engagement, and usage trends across multiple SaaS offerings in the financial services domain.

• Formalized Confluence-based documentation standards to reinforce process improvement efforts, increasing cross-functional alignment and improving global team collaboration productivity by 45%.

• Managed release planning and UAT coordination for two enterprise-scale product rollouts, ensuring all QA test cases aligned with business scenarios, resulting in 100% client acceptance and zero major production issues post-deployment. Business Analyst, Sigma InfoSolutions Ltd., Bengaluru, IN June 2018 – August 2020

• Analyzed eCommerce customer funnel data using SQL and Excel, identifying a 12% cart abandonment drop-off linked to mobile UI issues, which informed redesign decisions and increased conversion rates by 18%.

• Designed and documented detailed BRDs, SRS, and user stories in Confluence and JIRA for a FinTech client’s loan approval engine, reducing processing errors by 35% and enabling an 8-hour SLA commitment.

• Mapped legacy business processes into optimized workflows using Visio and Lucidchart, improving inter-departmental task handoffs and reducing delays by 25% across a client’s HR operations.

• Coordinated bi-weekly Agile ceremonies (sprint planning, demos, retrospectives) for a multi-country BI dashboard rollout, enhancing stakeholder transparency and maintaining a 95% sprint delivery rate.

• Developed executive dashboards in Tableau to track vendor performance and identify savings opportunities for a U.S. retail client, which helped reallocate procurement budgets and improved supplier scorecard visibility.

• Conducted UAT planning and execution for a product recommendation engine, aligning with marketing teams and logging over 50 actionable test cases in JIRA, which reduced go-live bugs by 70%.

• Created low-fidelity prototypes using Balsamiq for a healthcare appointment booking portal, expediting client approvals and reducing UI design iterations by 40%.

TECHNICAL SKILLS

Languages & Methodologies: SQL, R, SDLC, Agile, Scrum, Kanban, Waterfall Project & Product Management Tools: Jira, Rally, Trello, Asana, MS Project, Salesforce, Gantt Charts, MS Office Suite (Word, Excel, PowerPoint)

Data Visualization & BI Tools: Tableau, Power BI, Alteryx, Google Analytics Documentation & Tracking Tools: Confluence, FRD, BRD, SRS, Test Plans, User Guides, HP Quality Center, Rational ClearQuest, RTM ERP & CRM Systems: SAP, MS Dynamics NAV, Salesforce, HubSpot Operations & Process Optimization: Vendor Performance Tracking, Inventory Optimization, Workflow Mapping, Process Improvement, JAD, KPI Development, UAT, Time Motion Studies

Business & Data Analysis: Cost/Benefit Analysis, GAP Analysis, Impact Analysis, Risk Analysis, SWOT Analysis, Data Modeling, Requirement Gathering, Database Management, UX Understanding, Prototyping, QA Knowledge, Problem Solving, GTM Strategies, Financial Modelling Cloud Technologies: Microsoft Azure, Snowflake

Operating Systems & Version Control: Windows, macOS, Linux, Git, GitHub, GitLab EDUCATION

Master of Business Administration (MBA), Business Analytics – GPA: 3.93/4 May 2025 University of Massachusetts Dartmouth - Commonwealth Honors College Dartmouth, MA Awards: Graduate Assistant Scholarship, 1st Place in Business Strategy Simulation, 2nd Place in Tech Startup Event Bachelor of Technology in Textile Engineering – GPA: 3.74/4 May 2018 Maharshi Dayanand University Haryana, IN

Contact this candidate