Smruti Shah

Business Analyst

Greater Toronto Area, Canada0 mo experience

Key Highlights

  • Expert in transforming business requirements into actionable insights.
  • Proven track record in automating reporting processes.
  • Strong background in data modeling and analysis.
Stackforce AI infers this person is a Data Analyst with expertise in SaaS and data-driven decision-making.

Contact

Skills

Core Skills

Data AnalysisData ModelingData VisualizationWeb DevelopmentUser ExperienceAutomation

Other Skills

Reporting & AnalysisETLAnalyticsGoogle AnalyticsUsability TestingUser StoriesHTMLCSSJavaScriptBootstrapCustomer ServiceResource ManagementExploratory Data AnalysisExtract, Transform, Load (ETL)Python

About

I am a Data Analyst & Business Systems with hands-on experience turning business requirements into structured documentation, scalable workflows, and data-driven insights. With a background spanning business analysis, data modeling, automation, and dashboard development, I bring a blend of analytical thinking, technical skills, and clear communication to every project I support. My journey began with building community-driven systems and AI-supported tools, where I contributed to requirement gathering, designed user workflows, analyzed datasets, and helped automate processes that improved efficiency and user experience. Over time, I expanded my technical expertise in SQL, Python, Power BI, and data validation, enabling me to support teams across the full SDLC—from clarifying requirements and mapping processes to assisting in UAT and continuous improvement. In my roles, I have: 🔸 Transformed business requirements into actionable deliverables Conducted stakeholder interviews, documented user stories and acceptance criteria, designed ERDs and BPMN diagrams, and created SOPs that reduced ambiguity and improved delivery quality. 🔸 Improved operational efficiency through data and automation Built ETL workflows, optimized manual processes, created automated reporting scripts, and enhanced data quality—resulting in faster reporting cycles and reduced manual workload. 🔸 Supported data-driven decision-making Developed dashboards, performed EDA, validated datasets, tracked KPIs, and prepared detailed insights reports that helped leadership understand trends, performance, and areas for improvement. 🔸 Enhanced user and customer experience Worked closely with community members, developers, and cross-functional teams to refine website features, streamline workflows, improve search relevance, and support business listings in a community platform. 🔸 Collaborated in Agile, Scrum, and Waterfall environments Participated in sprint planning, retrospectives, UAT cycles, and daily stand-ups—ensuring alignment with product owners, testers, and developers. I’m passionate about building systems that are intuitive, reliable, and driven by accurate data. Whether it’s documenting requirements, validating data pipelines, building dashboards, or optimizing user flows, I strive to make processes clearer and decisions smarter. With growing expertise in automation tools and emerging AI technologies, I aim to contribute to teams looking for a detail-oriented analyst who can bridge business needs with technical execution.

Experience

0 mo
Total Experience
--
Average Tenure
--
Current Experience

Walmart canada

Associate

Feb 2025Oct 2025 · 8 mos · Mississauga, Ontario, Canada · On-site

  • Built and maintained strong one-on-one relationships with 200+ daily customers, acting as the primary point of contact for issue resolution and service optimization.
  • Partnered with cross-functional teams and managers to analyze recurring operational challenges, reducing self-checkout downtime and customer wait times by 20%.
  • Served as a technical liaison to escalate and troubleshoot system errors, ensuring consistent operational uptime and adherence to SLA targets.
  • Conducted customer feedback analysis to identify process improvement opportunities and enhance user satisfaction.
  • Produced detailed compliance and refund reports to support audit readiness and governance requirements.
  • Promoted financial solutions (e.g., Mastercard program) through data-driven communication, strengthening customer engagement and trust.
  • Supported change management initiatives by training new associates and standardizing front-end operations for consistent service delivery.

Jain bizhub

Data Analyst

Jan 2025Present · 1 yr 4 mos · Toronto, ON · Remote

  • Analyzed client case data in Salesforce Service Cloud to identify recurring patterns and operational gaps, achieving a 95% client satisfaction rate while meeting all SLA requirements.
  • Contributed to the development of an AI-powered business directory designed to help local businesses reach customers more efficiently.
  • Analyzed existing business listing workflows and identified data gaps, improving directory structure and search relevance.
  • Designed data models and entity-relationship diagrams (ERDs) to support backend architecture for the Flask-based AI system.
  • Created process flow diagrams (BPMN) to map user journeys, reducing requirement ambiguities during development.
  • Automated ETL data pipelines for business listings, user activity logs, and category mappings, reducing manual effort.
  • Improved reporting efficiency by 30% through optimized data transformations and automated scripts.
  • Built analytics dashboards using Google Analytics and internal data to track user visits, clicks, and conversion trends.
  • Performed A/B testing on key directory features, helping refine search filters and improve user engagement.
  • Prepared weekly insights reports summarizing traffic trends, business sign-ups, and campaign performance.
  • Collaborated with the AI development team to ensure data readiness and structured inputs for the recommendation engine.
  • Documented requirements, data dictionaries, SOPs, and change logs to support long-term scalability.
Data ModelingReporting & AnalysisData Analysis

Jain community services canada (jcs)

Web Analyst

Jan 2024Dec 2024 · 11 mos · Ontario, Canada · Remote

  • Collaborated with business stakeholders to gather, analyze, and document functional and non-functional requirements, achieving 91% accuracy in initial solution releases.
  • Designed, developed, and maintained a responsive community website using HTML, CSS, JavaScript, and Bootstrap.
  • Conducted requirement-gathering sessions with community members to understand functional needs and define priorities.
  • Documented user stories, acceptance criteria, and feature specifications, reducing rework during development.
  • Built a real-time event registration dashboard enabling users to sign up and track participation effectively.
  • Created an internal volunteer management module, improving coordination and reducing manual tracking.
  • Improved website speed by 25% through image optimization, code minification, and caching configurations.
  • Integrated Google Analytics to monitor traffic, engagement patterns, and event performance.
  • Developed SOPs and knowledge base articles to support volunteer onboarding and site maintenance.
  • Conducted usability testing and implemented UI/UX improvements based on user feedback.
  • Ensured cross-browser compatibility and mobile responsiveness across various devices.
  • Served as the primary liaison for pre-production and production support, leveraging technical expertise to resolve issues and enhance client satisfaction by 65%.
Usability TestingUser StoriesWeb DevelopmentUser Experience

Conestoga college

Operational Coordinator

Jan 2024May 2024 · 4 mos · Waterloo, Ontario, Canada · On-site

Customer ServiceResource Management

Mentorpower software

Data Analyst

Jun 2020May 2021 · 11 mos · Ahmedabad, Gujarat, India · Remote

  • Created data quality reports and performance summaries for leadership using Excel and SQL, enabling better visibility into operational KPIs.
  • Gathered, cleaned, and transformed raw datasets using SQL queries and Python scripts, ensuring accuracy for analysis.
  • Assisted in designing and maintaining Power BI dashboards to track sales, operations, and performance KPIs.
  • Conducted exploratory data analysis (EDA) to identify trends, anomalies, and business opportunities.
  • Automated Excel-based manual reporting workflows using Python, enabling faster monthly reporting cycles.
  • Supported senior analysts in interpreting KPIs, preparing insights decks, and presenting findings to stakeholders.
  • Created data mapping sheets, workflow diagrams, and requirement documents for analytics projects.
  • Collaborated with cross-functional teams to define data requirements and ensure robust data quality.
  • Wrote SQL queries to validate data pipelines and troubleshoot inconsistencies between source and reports.
  • Developed Python scripts for ETL tasks, improving data refresh speed and reducing dependency on manual updates.
  • Assisted in building predictive models by performing feature selection, preprocessing, and model evaluation.
  • Ensured proper version control and documentation of code, queries, and dashboards to support reusability.
  • Engineered Excel templates and Power Query workflows to optimize task allocation processes, reducing manual data handling by 80% and improving operational efficiency.
Exploratory Data AnalysisExtract, Transform, Load (ETL)Data AnalysisData Visualization

Education

Conestoga College

Postgraduate Degree — Reporting System and Database Development

May 2024Dec 2024

Conestoga College

Postgraduate Degree — Software Quality Assurance and Test Engineering

May 2023Dec 2023

Indus University Ahmedabad

Bachelor's of Computer Applications — Computer and Information Sciences and Support Services

Jun 2019Aug 2022

H B Kapadia new high school

Higher Secondary — Commerce

Jan 2016Jan 2018

Indus University Ahmedabad

Bachelor of Computer Applications

Jun 2019Aug 2022

Stackforce found 100+ more professionals with Data Analysis & Data Modeling

Explore similar profiles based on matching skills and experience