Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Timeline
Generic

KOMAL GANDHI

Brampton

Summary

A Business Intelligence Analyst with a focus on leveraging data insights to drive business strategy. Experienced in data analysis, process improvement, and reporting. Proficient in using tools like Tableau, Power BI, and SQL to extract actionable insights.

Overview

8
8
years of professional experience

Work History

BI Analyst/QA Analyst

Indigo
01.2020 - Current

Indigo Books and Music is a Canadian-based retailer of books, gifts, and toys.

  • Manage data analytics initiatives values at upto $1.5M,transform KPIs into business insights, and identify data trends to inform business decision making for the organization
  • Improve data visualization for senior leadership and finance teams, which includes developing a new dashboard to provide key insights on financial performance
  • Supported change management initiatives by developing communication materials that improved employee understanding and buy-in by 25%.
  • Collaborated with cross-functional teams to improve operational workflows,reducing inefficiencies by 10%.
  • Created visualization reports in Microsoft Power BI that highlighted consumer patterns, contributing to a strategic overhaul of the electronics sales floor layout resulting in a 12% rise in foot traffic.
  • Developed communication and engagement plans that kept stakeholders informed and engaged, leading to a 20% improvement in change initiative support.


Business Analyst/QA Analyst

Bank of Canada
03.2020 - 07.2020
  • Supported the implementation of business intelligence solutions and improvements.
  • Communicated and documented the IT Impact for diverse operational projects, ensuring all changes are accurately communicated and understood.
  • Participating in agile ceremonies like sprint planning, backlog grooming and team leading standup.
  • Analyzed sales data and prepared reports for marketing and finance departments
  • Increased productivity by 25% by aligning conflicting needs and prioritizing key projects.
  • Conducted impact analyses to identify risks and benefits, ensuring informed decision-making in change initiatives.
  • Participated in the annual systems upgrade project by accurately mapping business requirements to the technical specifications, ensuring seamless adoption by the sales analysis team.

QA Lead/Consultant

BMO
01.2017 - 01.2020
  • Saved 50% time and cost of testing by creating automation scripts.
  • Increased productivity by 50% by planning and defining test strategy and identify risks for critical product launch team.
  • Achieved many appreciations for coordinating and rectify a few situations for one of the production release.
  • In depth knowledge of all QA activities including development of test strategies and test plans, defect reporting and management, creation of various test and execution matrix, risk analysis and status reporting using ALM/JIRA.
  • Identified test cases to automate, prioritized suitable candidates for automation and automated test cases using Selenium/Java framework and Web services using SOAP UI.
  • Solid Experience in Agile process to plan, create and manage the backlog items, participate and organize scrum meetings.
  • Serving as a key member of the software development team as QA Automation, QA focused DevOps and leading QA activities for various Digital Acceleration team.
  • Plan, review and executed DevOps and software testing in Agile approach & aggressive project schedules providing input on project schedule risks, testing risks and dependencies.
  • Leading the Test Automation activities. Creating test automation framework, writing and executing test automation scripts using Perfecto and Selenium Web driver to support Functional end-to-end, cross browser testing, System and Regression testing of the legacy & new features.
  • Defect prevention activities, Agile Scrum team meetings, performing code reviews, defect Triage meeting and collaborate with developers to resolve software defects.
  • Facilitated Continuous Integration for scenarios tagged as Sanity & Regression and Continuous Delivery – CICD including GitHub, Jenkins.

IT Consultant

PointClickCare
03.2017 - 10.2017
  • Company Overview: PointClickCare is a EHR software for senior and assisted living, continuing care retirement communities and skilled nursing facilities.
  • Created Test strategy and plan, create test data and organize test plans and test runs for automation.
  • Developed customized automation testing frameworks including Page Object Model but not limited to Data driven, Keyword & Hybrid frameworks depending on the project/client needs.
  • Performed various testing activities like GUI testing, functional testing, browser compatibility testing, regression testing.
  • Participating in Scrum activities including sprint planning, daily scrums, retrospective.
  • Using GIT as a source repository system for version controlling and sharing codes with team.
  • Documenting framework Guidelines, Process, configurations, Installations and maintenance.
  • PointClickCare is a EHR software for senior and assisted living, continuing care retirement communities and skilled nursing facilities.

Education

Bachelor of Engineering - Mechanical Engineering

L.D. College of Engineering

Data Science foundation course - undefined

University of Toronto
01.2019

Skills

STRENGTHS

  • Analytical Thinker Excelled at providing analytical insights and practical solutions in my previous role, leading to improvements in decision-making procedures
  • Proactive Proactively took on additional responsibility as team lead, managing and coordinating multiple projects simultaneously with successful outcomes
  • Experienced in SQL Extensive experience manipulating data using SQL to uncover actionable insights, improve processes and drive business goals

SKILLS:

Front End: Azure DevOps, Python, Salesforce CRM Platform, JavaNet framework, Power BI

Tools: SQL, Data lineage, Data mapping ,snowflake, Selenium, Bitbucket, JIRA, Confluence

Domain Knowledge: Ecommerce, Banking, Procurement Credit Cards, Insurance and financial services, HealthCare-Senior Care

Databases: MS-SQL Server 2022, DB2, MS Access

Technical Writing: Requirements gathering, Project Planning, Risk management, Technical Documentation in Jira/Confluence

Hobbies and Interests

  • Data Analysis: I have a passion for making sense of data, it's satisfying to turn raw data into actionable business insights.
  • Hiking: I enjoy hiking, it helps me to unwind and keep fit, and I love exploring nature.

Timeline

Business Analyst/QA Analyst

Bank of Canada
03.2020 - 07.2020

BI Analyst/QA Analyst

Indigo
01.2020 - Current

IT Consultant

PointClickCare
03.2017 - 10.2017

QA Lead/Consultant

BMO
01.2017 - 01.2020

Data Science foundation course - undefined

University of Toronto

Bachelor of Engineering - Mechanical Engineering

L.D. College of Engineering
KOMAL GANDHI