Gurpreet Ghotra

About Me

4+ Years Exp | 15+ Projects | 15+ Certifications

Hey! I'm Gurpreet. I work at the intersection of analytics, automation, and data engineering, building reporting ecosystems that bring clarity and structure to complex operational environments. My focus is on creating scalable solutions using Power BI, Dataverse, Databricks SQL, and the Power Platform to turn fragmented data into governed, end-to-end workflows that teams rely on every day. I'm drawn to messy problems, ambiguous requirements, and high-impact reporting challenges where strong data modeling and thoughtful design make the difference.

I'm known for taking ownership, collaborating closely with cross-functional partners, and delivering solutions that business teams actually adopt. My work blends technical depth with product thinking—prioritizing usability, automation, and long-term sustainability. As I continue growing toward advanced analytics and data science, I'm committed to building intelligent systems that scale and elevate operational decision-making.

Let's build something impactful together.

experienceeducation

July 2025 - Present

Data Analyst

Manulife

At Manulife, I deliver scalable Power Platform, Databricks, and Power BI solutions that modernize reporting, reduce manual dependencies, and enhance transparency across Retail Wealth Operations. I drive efficiency gains and empower data-driven decision-making through intelligent automation using Dataverse, Power Automate, and Copilot Studio.

May 2024 - June 2025

Business Intelligence Developer

Alpha Tickets

At Alpha Tickets, I designed intuitive Power BI dashboards and crafted data models that brought clarity to complex sales and customer behavior data. I built and maintained robust data pipelines using Python and Airflow, connecting multiple platforms to streamline analytics. By optimizing databases and implementing governance tools like data dictionaries, I ensured data was not only fast but also reliable for decision-making across the organization.

July 2022 - Aug 2023

Business Data Analyst

HSG Packaging Industries

In this role, I applied machine learning models to solve real-world forecasting challenges, helping the business better align inventory with demand. My work involved analyzing production processes, uncovering inefficiencies, and turning insights into action. I developed dynamic dashboards and conducted customer behavior analyses that informed strategic planning, from operations to marketing.

Jan 2022 - June 2022

Data Science Co-Op

ThinkNEXT Technologies

During my co-op, I focused on automating and enhancing the way data was handled—from collection to reporting. I created clean, efficient pipelines and interactive dashboards that supported marketing and client retention efforts. It was a hands-on experience that sharpened my technical foundation and sparked my passion for using data to drive meaningful outcomes.

Master of Computer Engineering

University of Windsor

Key Highlights: Deep Learning, Computational Methods & Modeling for Engineers, Automotive Sensor Systems, Connected Autonomous Vehicles, Engineering Mathematics, Engineering Project Management

Bachelor of Electrical and Electronics Engineering

Panjab University

Key Highlights: Programming and Data Structures, Databases, Microprocessors & Microcontrollers, Industrial Automation, Mathematics & Calculus, Circuit Theory & Network Analysis

Skills