Summary
Overview
Work History
Education
Skills
Certification
References
Timeline
Generic

Will Dappa

Calgary,AB

Summary

Results-driven Data Analyst with over 6 years of experience in overseeing complex projects from inception to completion. Expertise in database management, data analysis, and the software development lifecycle (SDLC), consistently delivering high-quality results on time and within budget. Proficient in business intelligence tools such as Microsoft Power BI and Tableau, alongside advanced skills in Excel, Power Queries, and SQL. Aiming to leverage analytical skills to drive strategic decision-making in a dynamic organization.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Analyst

Nutrien
Calgary, AB
05.2023 - Current
  • Achieved a significant increase in both data accuracy and reporting efficiency via comprehensive BI solution rollout.
  • Analyzed requirements for creation of effective data models and dashboards.
  • Analyzed trends to identify cost reduction strategies and revenue growth areas.
  • Developed automation solutions using data cubes.
  • Generated real-time business intelligence for executives through dynamic dashboard maintenance.
  • Resolved quality issues through cross-team collaboration.
  • Identified and addressed gaps in product processes to enhance security.
  • Supported initiatives for data integrity and normalization.

Data Analyst

TC Energy
Calgary, Alberta
01.2020 - 05.2023
  • Utilized SQL and Python for detailed analysis of large datasets, enhancing decision-making processes.
  • Utilized Tableau to design dynamic dashboards and reports, highlighting important metrics for stakeholders.
  • Enhanced data retrieval efficiency through the management of database systems and optimized queries.
  • Converted gathered business needs into technical specifications.
  • Applied SAP in mapping business processes, configuring systems, and executing IT solutions meeting company needs.
  • Facilitated the integration of Agile processes including sprint planning, backlog grooming, and stand-up meetings.
  • Worked closely with management to prioritize business and information needs.

Project Coordinator / Data Analyst

Can-Ak Industrial Services
Calgary, AB
01.2018 - 01.2020
  • Oversaw the implementation and refinement of project changes with multiple teams.
  • Guaranteed maximum efficiency through dedicated technical support and troubleshooting for various systems.
  • Organized stakeholder meetings to facilitate understanding of business needs and ensure data quality.
  • Developed and implemented client solutions.
  • Provided client support services utilizing SAP.
  • Participated in the creation and application of test plans, maintaining software standards.
  • Engaged in pilot testing to ensure operational safety compliance.
  • Delegated tasks to chosen team members to maintain efficient operations.

Education

Bachelor of Applied Science - Petroleum Systems Engineering

University of Regina
Regina, SK

Skills

  • Skilled in Microsoft Office Applications
  • VBA Macro Development
  • Data Architecture Development
  • Skilled in Python Programming
  • Experience with SAP HANA Solutions
  • Data Modeling with HANA Studio
  • ERP Solution Optimization
  • SAP System Knowledge
  • Experience with Microsoft Dynamics
  • Salesforce Integration Skills
  • Analytical Data Insights
  • Power BI Report Development
  • Tableau Data Analysis
  • AWS Quicksight Analytics Expertise
  • Snowflake Analytics Solutions
  • Cognos Dashboard Development
  • Spotfire Reporting Skills
  • SQL Query Optimization

Certification

  • Microsoft Certified: Power BI Data Analyst Associate
  • Salesforce Administrator
  • Certified ScrumMaster (CSM), Scrum Alliance
  • Data Science and Machine Learning: Making Data-Driven Decisions, MIT IDSS
  • IT Support Professional, Google

References

References available upon request.

Timeline

Data Analyst

Nutrien
05.2023 - Current

Data Analyst

TC Energy
01.2020 - 05.2023

Project Coordinator / Data Analyst

Can-Ak Industrial Services
01.2018 - 01.2020
  • Microsoft Certified: Power BI Data Analyst Associate
  • Salesforce Administrator
  • Certified ScrumMaster (CSM), Scrum Alliance
  • Data Science and Machine Learning: Making Data-Driven Decisions, MIT IDSS
  • IT Support Professional, Google

Bachelor of Applied Science - Petroleum Systems Engineering

University of Regina
Will Dappa