SUMIT SHARMA
Saskatoon,SK
Summary
Experienced Manager in CRM and Marketing Technologies, BI Data Analyst with over 13 years of expertise in the casino and gaming industry. Specialized in data transformation, business intelligence, and process automation. Proficient in SQL, SSRS, SSIS, Python, .NET, and other BI tools. Strong ability to identify data patterns and trends to optimize marketing campaigns, financial reporting, and operational efficiency. Skilled at designing enterprise-scale reporting solutions, data pipelines, and system integrations that enhance business decision-making and streamline operations. Adept at bridging the gap between technical solutions and business strategy, delivering actionable insights that drive revenue growth.
Overview
13
13
years of professional experience
Work History
Mgr. CRM and Marketing Technology
Saskatchewan Indian Gaming Authority (SIGA)
01.2024 - Current
- Maximized team performance by mentoring staff, monitoring daily operations, and implementing process improvements to enhance efficiency.
- Led the migration of SQL-based reporting systems to a modern Business Intelligence platform, improving data accessibility, scalability, and decision-making from 1 week to 1 hour.
- Designed and implemented automated ETL workflows for Land Based, iGaming(Online casino) data pipelines, reducing manual effort, ensuring real-time insights, and enhancing data reliability.
- Spearheaded casino-wide Business Intelligence and reporting initiatives, enabling data-driven marketing, financial, and operational analytics.
- Conducted in-depth analysis of player behavior, marketing performance, and revenue trends, driving strategic decision-making and business growth.
- Partnered with executive leadership to leverage data insights for process optimization, improving efficiency, revenue forecasting, and customer engagement strategies.
Functional Data Analyst
Saskatchewan Indian Gaming Authority (SIGA)
09.2022 - 01.2024
- Utilized Python for data analysis, automation, and statistical modeling, reducing manual reporting time by 50%
- Applied statistical methods to analyze large datasets, identifying key performance drivers that increased marketing ROI by 5%.
- Developed Power BI dashboards and reports, integrating Python scripts and DAX calculations, resulting in 60% faster data visualization and improved executive decision-making.
- Created and maintained SQL-based reporting systems, optimizing data extraction and ETL workflows, which reduced query execution time by 20% and enhanced data accuracy by 30%.
- Designed and automated KPI dashboards, providing real-time insights that improved operational tracking efficiency by 45%.
- Implemented business intelligence solutions using SQL, Power BI leading to a 20% reduction in reporting errors and increased automation across departments.
Senior Programmer Analyst
Saskatchewan Indian Gaming Authority (SIGA)
06.2020 - 09.2022
- Developed and deployed a scalable, high-availability COVID-19 tracking system, ensuring compliance with regulatory requirements and supporting business operations.
- Designed and implemented a centralized authentication system using ASP.NET and C# to automate user account management across intranet applications.
- Enhanced and optimized existing software by resolving errors, improving performance, and adapting to new hardware environments.
- Maintained up-to-date project documentation, tracking system changes and deviations to ensure transparency and consistency.
- Collaborated closely with stakeholders to define system specifications, requirements, and design solutions tailored to business needs.
- Designed and built relational databases and optimized table structures to support web applications and improve data retrieval efficiency.
Gaming Data Analyst
Saskatchewan Indian Gaming Authority (SIGA)
08.2018 - 06.2020
- Developed and optimized 300+ custom reports and 20+ automation tools, reducing manual reporting efforts by 50%
- Created comprehensive documentation and data guides, enabling stakeholders to extract key performance metrics faster.
- Leveraged data visualization tools like Power BI, Tableau, improving data interpretation efficiency by 30%, leading to faster executive decision-making.
- Identified key patterns and trends in large datasets, providing data-driven recommendations that increased player engagement by 5%
- Designed, updated, and optimized SQL scripts and queries, improving data extraction and transformation accuracy by 99.9% .
System Analyst
Western Canada Lottery Corporation
08.2012 - 08.2018
- Partnered with senior leadership to develop and execute strategic initiatives, leading to a 15% improvement in operational efficiency and enhanced system performance.
- Designed and implemented a real-time services monitoring system in C#, reducing system downtime by 30% and improving incident response time by 40%.
- Successfully managed multiple projects under tight deadlines, delivering 100% of system updates on schedule in a fast-paced, high-stakes environment.
- Developed and maintained enterprise data warehouses enabling 60% faster data retrieval and supporting real-time reporting across key business operations.
Education
Post Graduate Diploma - Wireless Networking
George Brown College
Toronto, ON12.2011
Bachelor of Computer And Information Technology - Technology
Amritsar College of Engineering & Technology
Punjab, India04.2007
Skills
- Business Intelligence Reporting and Development
- Data Visualization with Power BI
- Data Analysis and Warehousing (SQL)
- Experienced in NET Database Solutions
- Python-Driven Analysis
- PowerShell Automation Skills
- Streamlined ETL Processes
- Data Pipeline and Workflow Development
- Cloud Systems Integration
- Analytical Problem Solving
- Stakeholder Engagement
- Market Research Expertise
- Collaborative Team Management
Key Accomplishments
- Enterprise BI Migration & Reporting Overhaul, Led the end-to-end migration of SQL-based reporting systems to a new Casino Management System and BI platform, improving data accessibility and operational efficiency., 08/2022
- Automated Casino Operations & Marketing Analytics, Designed 300+ custom reports and 20+ automation tools, including daily/monthly marketing reports, campaign performance dashboards, Gross Gaming Revenue (GGR) reports, system audit logs, and financial reports, reducing manual effort and enhancing decision-making across finance, marketing, and operations.
- ETL & Data Process Automation, Engineered ETL workflows and data pipelines to automate reporting and analytics, reducing report generation time from hours to minutes.
- COVID-19 Contact Tracing System, Developed and implemented a casino-wide COVID-19 contact tracing system using SQL and ASP, ensuring regulatory compliance across 7 SIGA casinos., 08/2020
- Data Pattern Recognition & Optimization, Applied advanced analytics to detect trends and anomalies in player behavior, marketing effectiveness, and operational performance, helping executives make data-driven strategic decisions.
Languages
English
Full Professional
Timeline
Mgr. CRM and Marketing Technology
Saskatchewan Indian Gaming Authority (SIGA)
01.2024 - Current
Functional Data Analyst
Saskatchewan Indian Gaming Authority (SIGA)
09.2022 - 01.2024
Senior Programmer Analyst
Saskatchewan Indian Gaming Authority (SIGA)
06.2020 - 09.2022
Gaming Data Analyst
Saskatchewan Indian Gaming Authority (SIGA)
08.2018 - 06.2020
System Analyst
Western Canada Lottery Corporation
08.2012 - 08.2018
Post Graduate Diploma - Wireless Networking
George Brown College
Bachelor of Computer And Information Technology - Technology
Amritsar College of Engineering & Technology
Similar Profiles
Raquel ShingooseRaquel Shingoose
Surveillance Operator at SIGA (Saskatchewan Indian Gaming Authority)Surveillance Operator at SIGA (Saskatchewan Indian Gaming Authority)
Trevor KequahtoowayTrevor Kequahtooway
Part-Time Security Officer at Saskatchewan Indian Gaming AuthorityPart-Time Security Officer at Saskatchewan Indian Gaming Authority
Paul John S. DizonPaul John S. Dizon
Slot Attendant at Saskatchewan Indian Gaming Authority Inc.Slot Attendant at Saskatchewan Indian Gaming Authority Inc.