Joel Knapp Email & Phone Number

Burlington, On, Ca

Burlington, Ontario, Canada

• Leveraged advanced statistical methods and data visualization tools to analyze large datasets, uncover trends, and effectively communicate insights to stakeholders.• Extracted, cleaned, and preprocessed data from diverse sources, ensuring accuracy and integrity for analysis, while creating and maintaining interactive dashboards and reports in Power BI.• Collaborated closely with internal business partners to define and gather flock performance metrics, produce impactful Power BI reports, and conduct in-depth data analysis.• Maintained comprehensive documentation of methodologies, data sources, and assumptions to ensure reproducibility and transparency, while utilizing Agile project management methodologies to keep projects on track.

Toronto, Ontario, Canada

• Responsible for the creation, deployment, and maintenance of the I&IT Portfolio Enterprise Vendor of Records Database via Power BI on the cloud, resulting in a 50% reduction in the completion time of Business Intelligence data requests• Developed and maintained a reporting tool incorporating a Random Forest classification model built in Alteryx which achieved a provincial goal of allocating 40% of total Ontario Public Service expenditures to Small and Medium Enterprises• Lead the data extraction, transformation, and loading processes for Federal Trade Agreements, Consulting Services, and Ethical Apparel reports, creating interactive visualizations and dashboards while maintaining data integrity and accuracy• Executed complex SQL queries to extract and transform data from Oracle Integrated Financial Systems and Enterprise Vendor of Records Arrangement databases, enhancing data accessibility and usability• Consolidated disparate I&IT Portfolio datasets into a unified data source and constructed interactive Power BI dashboards, enabling efficient exploratory data analysis for Contract Managers

Toronto, Ontario, Canada

• Established a comprehensive Project Database tailored for the Law Clerks of Ontario, leveraging Microsoft Access and MySQL databases alongside VBA queries for efficient data management and analysis• Executed the extraction, transformation, and loading (ETL) process for thousands of datasets, delivering valuable data assets to the Superior Court of Justice shared drive

Toronto, Ontario, Canada

• Wrote a series of macros for Data Entry Clerks resulting in a 42% increase in processing speed• Created VBA formula-driven dashboards for Data Entry Coordinator streamlining human-resources coordination