Harsimarpreet Singh Sahota, Business Analyst

Turning Business Requirements Into Data-Driven Solutions

Harsimarpreet Singh Sahota

Business Analyst Data Analytics Agile Delivery AI-Enabled Business Solutions

I'm a Business Analyst with experience translating stakeholder needs into actionable requirements, improving business processes, and delivering data-driven insights. I bring together SQL, Tableau, Excel, Agile delivery, and AI-enabled workflows to help teams make better decisions and deliver better solutions.

Based in Calgary, Alberta — open to Business Analyst opportunities across Canada.

View ProjectsExplore ExperienceLet's Connect
18+Stakeholders Engaged
120+User Stories Across 2 Internships
35 hrsWeekly Reporting Saved
35%Defects & Rework Reduced
Analytics & BI Projects

Featured Projects

Business analysis and BI case studies focused on requirements, data modeling, actionable insights, and measurable decision support.

GitHub

Northwind Traders Sales Analytics & Business Intelligence

Problem

Leadership needed clearer visibility into revenue drivers, customer spending patterns, and logistics inefficiencies across end-to-end sales operations.

Analysis

Analyzed end-to-end sales operations across customers, products, orders, and logistics and applied advanced SQL techniques (joins, aggregations, subqueries, CTEs) to translate sales trends into actionable business insights.

Business Impact

Translated findings into strategic recommendations for revenue optimization and shipping efficiency, supporting data-driven commercial decisions.

Key Insights

Surfaced customer spending behaviors, product revenue contributions, and operational delivery patterns to prioritize commercial opportunities.

Tools Used

SQLMySQLCTEsSubqueriesAggregationsBusiness Intelligence
GitHub

Retail Profitability Analysis Dashboard

Problem

Retail leadership lacked an executive view of profitability across products, categories, regions, and time periods to guide portfolio optimization.

Analysis

Built an interactive Tableau dashboard analyzing 4 years of Superstore sales data and designed drill-down and geographic mapping to identify loss-making products and present profitability recommendations.

Business Impact

Delivered an executive-ready strategic review with clear product profitability recommendations and geographic performance visibility.

Key Insights

Identified critical loss-making products and regional performance variances to guide product mix adjustments and margin protection.

Tools Used

TableauInteractive DashboardsGeographic MappingDrill-Down AnalysisProfitability Modeling
GitHub

HR Analytics Dashboard

Problem

HR leadership needed self-service visibility into workforce KPIs and attrition risk to support retention planning for 1,470 employees.

Analysis

Developed a self-service HR analytics dashboard in Excel analyzing workforce data for 1,470 employees and identified high-risk attrition segments to present retention strategy recommendations.

Business Impact

Presented data-driven workforce retention recommendations to leadership, enabling proactive management of employee turnover risk.

Key Insights

Identified high-risk attrition segments across job roles, departments, salary bands, and tenure to target HR intervention strategies.

Tools Used

Advanced ExcelPower QueryPivot TablesWorkforce AnalyticsKPI Dashboards
Professional Experience

Professional Experience

Requirements analysis, stakeholder collaboration, and data-driven process improvement in Agile delivery environments.

Headway Software Solutions

Business Analyst Intern

Internship

Oct 2025 – Sep 2026

Calgary, Canada

  • Elicited, analyzed, and documented business requirements from 18+ cross-functional stakeholders and SMEs, translating business needs into 80+ user stories, acceptance criteria, BRDs, and FRDs, improving sprint delivery efficiency by 20% across 20+ two-week sprints.
  • Used SQL, Excel, and Tableau to analyze operational data, develop 4 interactive dashboards, and reduce weekly manual reporting efforts for leadership teams by 35 hours.
  • Conducted business process analysis using stakeholder interviews, BPMN process models, swimlane diagrams, and current-state/future-state mapping for 25+ workflows, identifying automation opportunities that reduced dependencies by 30% and improved operational efficiency.
  • Reduced post-development defects and rework by 35% by coordinating requirements validation, UAT activities in Jira, project risk tracking, and stakeholder communications with product owners, developers, and QA teams.
Requirements ElicitationStakeholder ManagementUser Stories & Acceptance CriteriaBRD / FRDSQLTableauAdvanced ExcelBPMN 2.0 / SwimlanesUAT CoordinationJira & ConfluenceAgile & Scrum

Alberta AI & Tech Innovation Club

Business Analyst Intern

Internship

Dec 2024 – Jul 2025

Calgary, Canada

  • Facilitated product discovery workshops with platform leads, academic mentors, and 50+ pilot student users, managing the Jira backlog and translating high-level platform epics into 40+ detailed user stories with Gherkin-based acceptance criteria and technical API specifications.
  • Mapped end-to-end student onboarding and intake journeys in Microsoft Visio, standardizing operational handoffs between advisors and the automated system to accelerate consultation turnaround times by 35%.
  • Developed Power BI tracking models using SQL and Excel to evaluate student engagement funnels and drop-offs, translating user feedback into prioritized backlog enhancements that increased user retention by 20%.
  • Directed UAT across 3 AI simulation releases, authoring 80+ test cases to evaluate generative prompt accuracy, edge cases, and response latency, and collaborating with developers to reduce post-release defects by 30%.
Product DiscoveryUser Stories (Gherkin)Backlog ManagementProcess MappingMicrosoft VisioPower BISQL & ExcelUAT & Test CasesAI Simulation TestingAPI Specifications
Recommendations

Recommendations

Endorsements from industry professionals and SAIT faculty — including a Certified Business Analyst Professional (CBAP).

FeaturedCBAP Recommendation
LinkedIn recommendation from Mamta Verma — Software Projects: Analysis, Design, and Management — SAIT

Mamta Verma

Certified Business Analyst Professional (CBAP) · Instructor & Mentor

Software Projects: Analysis, Design, and Management — SAIT

View LinkedIn Profile →
LinkedIn recommendation from Navpreet Singh — Industry Recommendation

Navpreet Singh

Technical Architect | Senior Full Stack Developer | .NET, Python, AWS Cloud

Industry Recommendation

LinkedIn →
LinkedIn recommendation from Mohamed E. — Advanced Database Programming

Mohamed E.

Passionate Software Engineering Educator | Ph.D. (ECE) | Instructor, SAIT

Advanced Database Programming

LinkedIn →
LinkedIn recommendation from Harinder Kaur — Website Development

Harinder Kaur

Instructor, SADT at Southern Alberta Institute of Technology (SAIT)

Website Development

LinkedIn →
LinkedIn recommendation from Osama Alhaj, MBA — Object-Oriented Programming

Osama Alhaj, MBA

Data Analyst | Technical Curriculum Developer | Software & Programming Instructor

Object-Oriented Programming

LinkedIn →
Core Competencies

Skills & Technical Capabilities

Organized into three functional pillars: Business Analysis & Agile delivery, Systems & Business Intelligence, and AI-enabled workflow automation.

Business Analysis & Agile

Core requirements engineering, stakeholder alignment, process modeling, and Agile delivery.

Requirements ElicitationStakeholder AnalysisUser Stories & Acceptance CriteriaBRD/FRD DocumentationProcess Mapping (BPMN 2.0 / Swimlanes)Gap AnalysisCurrent-State/Future-State ModelingUAT CoordinationRequirements Traceability (RTM)SDLCAgile & Scrum

Systems, BI & Data

Business intelligence platforms, backlog systems, relational database querying, and modeling.

JiraConfluenceMicrosoft VisioLucidchartAzure DevOpsSQLTableauPower BIAdvanced Excel

AI & Workflow Automation

Modern AI productivity, prompt engineering, and automated workflows to accelerate delivery.

Prompt EngineeringWorkflow AutomationMicrosoft CopilotChatGPTClaudePerplexity
Professional Profile

About Me

I’m a Business Analyst with hands-on experience translating business needs into actionable requirements, supporting Agile delivery, and driving measurable process improvements. At Headway Software Solutions, I collaborated with 18+ cross-functional stakeholders, developed 80+ user stories, BRDs, FRDs, and acceptance criteria, and contributed to a 20% improvement in sprint delivery efficiency.

Previously, at Alberta AI & Tech Innovation Club, I supported AI-driven product development by facilitating discovery workshops, gathering insights from 50+ pilot users, and translating product requirements into detailed user stories and acceptance criteria. I coordinated UAT across three AI simulation releases, helping reduce post-release defects by 30%, while data-driven backlog improvements contributed to a 20% increase in user retention.

My core skills include requirements elicitation, stakeholder analysis, BRD/FRD documentation, Agile/Scrum, BPMN 2.0 process mapping, gap analysis, UAT, SQL, Advanced Excel, Tableau, Power BI, Jira, Confluence, Visio, and Azure DevOps. With a Diploma in Software Development from SAIT and experience across business intelligence, workflow optimization, and AI-enabled solutions, I bring analytical thinking and a strong technical foundation to business problem-solving.

I’m passionate about bridging the gap between business and technology, turning complex requirements into practical solutions, and using data to improve business performance. I continue to strengthen my business analysis expertise through hands-on projects, professional development, and my pursuit of the Entry Certificate in Business Analysis (ECBA™) through IIBA.

Education & Credentials

Education

Southern Alberta Institute of Technology (SAIT)

Diploma in Software Development

Calgary, Alberta, Canada

Built strong analytical and problem-solving foundations through intensive coursework in systems analysis, database design, software engineering methodologies, and structured documentation. Applied this technical background to business process modeling, requirements elicitation, data analysis, and bridging stakeholder needs with technical implementations.

Certifications

Entry Certificate in Business Analysis (ECBA™)

IIBA (International Institute of Business Analysis)

In Progress

Foundations of business analysis practice based on the BABOK® Guide — covering requirements analysis, elicitation, stakeholder management, and solution assessment. Actively in progress.

PwC Technology Consulting Simulation

PwC

Certificate

Created client discovery interview guides, prioritized user stories, and built an MVP roadmap for legacy compliance system modernization.

KPMG Advisory & Data Analysis Simulation

KPMG

Certificate

Evaluated supplier performance data using AI to deliver strategic growth recommendations to leadership.

Leadership & Community

Thought Leadership

19,000+ Followers

Shares practical insights on analytical thinking, AI productivity, and professional growth with a LinkedIn community of over 19,000 followers.

Conference Volunteer

Alberta Tech Ecosystem

Actively supported major tech conferences and startup showcases with Alberta Innovates, Platform Calgary, and TechConnect Alberta, assisting founders, investors, and speakers.

Community Volunteer

GDG Calgary

Managed event logistics and supported workshops for over 300 attendees at DevFest 2024, contributing to one of Calgary's key community tech events.

Get in Touch

Let's Connect

I'm a Business Analyst open to opportunities across Canada — interested in Business Analysis, Business Intelligence, Data Analytics, Digital Transformation, and Process Improvement.

If you're hiring for a Business Analyst role or want to discuss how I can support requirements, stakeholders, and data-driven decisions, I'd love to hear from you.

harsimar1288@gmail.com+1 (368) 299-8325
Discuss Opportunities