Summary
Overview
Work History
Education
Skills
Timeline
Generic

Krittika Sarkar

Seattle

Summary

Business Intelligence Analyst at Avid Technology with strong proficiency in advanced SQL and automated ETL processes. Reduced manual reporting time by 40% through effective dashboard development. Enhanced client satisfaction scores by 18% year-over-year through cross-functional collaboration and delivery of actionable insights.

Overview

8
8
years of professional experience

Work History

Business Intelligence Analyst

Avid Technology
03.2021 - Current
  • Took ownership of fragmented reporting processes, automating metrics tracking and creating executive dashboards that cut decision time in half.
  • Designed 10+ automated dashboards in Domo to track service utilization, onboarding efficiency, and customer engagement — reducing manual reporting time by 40%.
  • Partnered with product and operations teams to develop KPI frameworks, enabling faster identification of delivery bottlenecks and boosting client satisfaction scores by 18% YoY.
  • Implemented SQL-based ETL pipelines that processed over 1M records weekly, ensuring 99% accuracy in reporting and accelerating insights delivery.
  • Conducted ad-hoc deep dives into customer usage patterns, directly influencing a 12% improvement in subscription retention through targeted feature enhancements.
  • Built scalable data models and dashboards for cross-functional visibility, shortening executive decision-making cycles from weeks to days.

Data Science Consultant

Beam Data (Samsung Canada)
Toronto, Canada
01.2020 - 02.2021
  • Segmented high-value customer groups using predictive modeling, increasing campaign ROI by 22% through targeted device upgrade promotions.
  • Automated data pipelines with SQL and Python to feed real-time metrics into executive dashboards, cutting manual preparation time by 30 hours/month.
  • Delivered visualization-driven predictive model results, enabling marketing teams to launch 3 major campaigns with improved conversion targeting.
  • Partnered with product managers to align analytics insights with strategic initiatives, leading to 15% higher engagement in targeted user cohorts.

Business Data Analyst / Data Visualization Analyst

Delvinia
Toronto, Canada
09.2017 - 12.2019
  • Developed interactive Tableau dashboards for dynamic pricing strategies, leading to a 10% revenue lift in targeted product segments.
  • Created a suite of KPI dashboards that reduced reporting turnaround from 5 days to same-day access for leadership.
  • Conducted SQL-driven deep dives to uncover data anomalies, improving trust in internal reporting by eliminating 95% of metric discrepancies.
  • Collaborated with marketing and product teams to design user-friendly dashboards, increasing adoption by 70% among non-technical teams.

Health Research Analyst

Tata Institute of Social Sciences
India
05.2017 - 08.2017
  • Created Power BI dashboards that visualized key health program metrics, contributing to a 10% improvement in resource allocation efficiency.
  • Streamlined data cleaning and transformation processes, reducing preparation time for monthly reports by 50%.
  • Applied statistical analysis (segmentation, regression) to inform strategic interventions, leading to measurable increases in outreach effectiveness.

Education

Research Analyst - Post – Graduate Program

Humber College
Toronto, Canada
04.2017

Health Systems Management - Post – Graduate Program

Fanshawe College
London, Canada
08.2016

Associate of Science - Diploma Program

Toronto Institute of Data Science & Technology (WeCloud Data)
Toronto, ON

Skills

  • Advanced SQL and Python scripting
  • Automated ETL processes
  • Dashboard development and visualization
  • Tableau, Power BI, and Domo expertise
  • Excel data analysis
  • Business performance metrics and KPIs
  • Data storytelling techniques
  • Cross-functional collaboration
  • Predictive analytics and segmentation modeling
  • Compliance with PHIPA, PIPEDA, and HIPAA

Timeline

Business Intelligence Analyst

Avid Technology
03.2021 - Current

Data Science Consultant

Beam Data (Samsung Canada)
01.2020 - 02.2021

Business Data Analyst / Data Visualization Analyst

Delvinia
09.2017 - 12.2019

Health Research Analyst

Tata Institute of Social Sciences
05.2017 - 08.2017

Research Analyst - Post – Graduate Program

Humber College

Health Systems Management - Post – Graduate Program

Fanshawe College

Associate of Science - Diploma Program

Toronto Institute of Data Science & Technology (WeCloud Data)

Similar Profiles

CREATE PROFILE
Krittika Sarkar