Harpreet Kang Email & Phone Number

As a forward-thinking people leader at Scotia Dealer Advantage (SDA). I spearheaded a project to provide our executives with unparalleled insights into our competitive landscape. Utilizing my expertise in Power BI, I designed and implemented a parametric paired/matched design experiment that meticulously compared Scotiabank with its key competitors. This analysis was anchored on a comprehensive matching strategy, focusing on the various blocks/products offered within our fiercely competitive market.Key Contributions:Hypothesis Testing: Initiated and executed sophisticated hypothesis testing to rigorously evaluate whether there were statistically significant differences in pricing strategies between SDA and its competitors. This analysis provided a foundational understanding of our pricing position in the competitive landscape.Algorithm Development: Leveraged my expertise in logistic regression to develop a cutting-edge pricing algorithm. This tool was meticulously crafted to predict competitive pricing strategies.Data-Driven Strategy: My work played a pivotal role in transitioning SDA towards a more data-driven approach in its pricing strategy, ensuring decisions were backed by solid statistical evidence.My role in this project has refined my skills in statistical analysis, predictive modeling, and strategic implementation, making me an invaluable asset to any organization looking to leverage data science for competitive advantage.

Advanced Data Analysis: Authored sophisticated SQL scripts to extract, analyze, and interpret large datasets. This involved performing comprehensive time series analysis to uncover patterns, trends, and seasonality, enabling the business to anticipate market movements and adjust strategies accordingly.Dashboard Development: Spearheaded the creation of Tableau dashboards, prioritizing visual perception and encoding to ensure that complex data was accessible and actionable for stakeholders. My dashboards served as essential tools for strategic planning, operational improvements, and performance monitoring across the sales domain.Collaboration and Leadership: Collaborated closely with cross-functional teams to align data analytics efforts with overall business objectives.

Python Programming and Automation: Engineered advanced Python algorithms to automate the compilation of data frames from multiple database connections. These algorithms were crucial in generating formatted MS Excel reports, which were then automatically distributed to designated lists via Outlook, ensuring that stakeholders received timely and accurate information.Efficient Reporting Systems: Designed and implemented sustainable reporting processes that significantly reduced manual interventions. By utilizing unary and binary operations in SQL, triggered by Python scripts, I established a highly efficient, automated reporting environment. This innovation not only saved valuable time but also minimized the potential for human error, leading to more reliable data insights.Collaboration and Innovation: Worked closely with business units to understand their data needs and challenges. By fostering a collaborative environment, I was able to design solutions that were not only technically sound but also aligned with the strategic goals of the organization.Process Optimization: My efforts in automating and optimizing reporting processes led to a noticeable improvement in operational efficiency within the Automotive Finance division.

Data Analytics, Big Data, And Predictive Analytics Certificate, 4.22/4.33

Python Development 1

Introduction To Machine Learning (Python)

Post Graduate Certificate, Financial Planning

Bachelor Of Commerce - Bcom, Accounting And Finance