Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Karan Goyal

Calgary,AB

Summary

Self-starter, organized and dependable candidate successful at managing multiple priorities in a fast paced environment with a positive proactive attitude and proven results. Willingness to take on added responsibilities to thrive and exceed team goals. Eager to contribute to team success through hard work, attention to detail, strong communication and excellent organizational skills.

Overview

3
3
years of professional experience

Work History

Business Analyst

Edmonton Police Service
01.2025 - Current
  • Developed an AI sentiment analysis tool in Python to evaluate public perception of the Edmonton Police Service, eliminating a recurring manual process that previously required two months to complete
  • Automated project administration workflows in Smartsheet, streamlining processes and improving efficiency for Senior Project Managers
  • Built AI agents using Microsoft Co-Pilot Studio to analyze charge report summaries, providing leadership with insights to identify gaps and mitigate risks such as case dismissals, reduced charges, or wrongful convictions
  • Partnered with the Business Analytics Intelligence Reporting (BAIR) team to design and develop dashboards, including Divisional Crime Trends and Organizational structure
  • Analyzed operational data from sources to uncover trends and support evidence-based strategic and operational planning
  • Created data-pipelines through Microsoft Fabric to orchestrate policing data to help with ad-hoc queries for team members

Data Analyst Intern - Finance & Business Unit Serv

Chevron
01.2024 - 08.2024
  • Contributed to a large section of strong data validation, cleanup, and reports for the Virtual Data Room of Kaybob Duvernay assets
  • Contributed to physical warehouse inventory counts at vendor warehouse and assisted in data investigation
  • Initiated a streamline data-flow project and fully revamped metrics to provide accurate & live insights of logistics performance which resulted in an savings of $60,000 annually within 4 PSL
  • Collaborated with leadership to align business values and revamp key performance metrics, driving strategic improvements within SCM core functional teams.
  • Provided mentorship on current data visualizations along with a guidebook with developed SQL queries to enable a smooth transition process for future SCM interns
  • Reviewed and evaluated student resumes as part of the student hiring, ensuring alignment with organizational needs and expectations
  • Conducted candidate interviews to assess qualifications, skills, and cultural fit, contributing to effective selection decisions
  • Developed custom algorithms to optimize and automate data analysis processes, resulting in accurate reports for daily usage and monthly reporting
  • Optimized SQL queries within Snowflake for accurate insights, increasing overall data clarity for payload logistics within team and other stakeholders
  • Utilized data visualization techniques to present and explain complex data sets including but not limited to sand frac performance & additional logistic services
  • Developed automated workflows using Power Automate to monitor sand frac performance, ensuring stakeholders received timely notifications of additional non-productive time (NPT) for prompt investigation and review

Supply Chain Management Advisor Student

Suncor Energy
09.2023 - 12.2023
  • Ensured completeness of RFP/RFQ documents, record proponent's/bidder's communication during the RFP/RFQ stage, and maintain communication and records during contract administration and closeout for Syncrude Operations
  • Utilized data analytics to identify and resolve supply chain issues and improve overall performance
  • Provided training and mentorship on a variety of tools which improved performance and confidence
  • Assisted in developing sustainable supply chain strategies through market research, business unit needs analysis, risk and commercial analysis through the use of Microsoft Excel, along with a variety of software's
  • Provided support and led a team to transition over 300+ Syncrude contractors along with 13,000+ workers into S/4HANA
  • Examined and compared vendor contract terms to identify and address potential risks

Contracts Management Student - Major Projects

Canadian Natural Resources Limited
01.2023 - 08.2023
  • Provided support to the contracts group at all phases of the sourcing cycle, including Requests for Proposals (RFP)/Requests for Quotations (RFQ), proposal evaluations, awards, contract administration, and expediting and close-out activities for DRU-1, DRU-2 & Scotford Upgrader.
  • Ensured completeness of RFP/RFQ documents, recorded proponent's/bidder's communication during the RFP/RFQ stage, and maintained communication and records during contract administration and closeout.
  • Assisted in developing sustainable supply chain strategies through market research, business unit needs analysis, and risk and commercial analysis through the use of Microsoft Excel, along with a variety of software.
  • Identified cost-saving opportunities / avoidance as suggested by SMP team initiatives, saving up to $500K CAD
  • Acted as a liaison between Leads and SMP regarding monitoring progress and team milestones through the use of data reports.
  • Reviewed change order proposals and made approval or rejection recommendations based on AFE.
  • Provided training and mentorship on a variety of tools, improving performance and confidence.
  • Supported the Engineering Team in identifying suppliers for sourcing and acted as the leading point of contact for all commercial issues.
  • Developed go-to-market strategy, bid evaluation, and selection criteria for all levels of complexity, integrating market intelligence from historical supplier performance and contract compliance information.

Education

Bachelor of Commerce - Operations Management

University of Alberta
Edmonton, AB
12.2025

Skills

  • SAP
  • PowerBI / Tabelau
  • SQL
  • SmartSheet
  • SharePoint
  • Ivalua
  • Maximo
  • VBA
  • Power Automate
  • Critical Business Analysis
  • Python / VSCode
  • Data Storytelling
  • SMART
  • Snowflake
  • Microsoft Excel
  • Microsoft Fabric

Websites

Timeline

Business Analyst

Edmonton Police Service
01.2025 - Current

Data Analyst Intern - Finance & Business Unit Serv

Chevron
01.2024 - 08.2024

Supply Chain Management Advisor Student

Suncor Energy
09.2023 - 12.2023

Contracts Management Student - Major Projects

Canadian Natural Resources Limited
01.2023 - 08.2023

Bachelor of Commerce - Operations Management

University of Alberta

Similar Profiles

CREATE PROFILE
Karan Goyal