Experience

Total ETO

• Canada
• Software Development
• 1 - 100 Employee

• Consultant

  • Jan 2020 - Present



Questica

• Canada
• IT Services and IT Consulting
• 1 - 100 Employee

• Reporting Analyst

  • Mar 2018 - 2019

  Gathered and analyzed business requirements for development of SSRS financial reports. Primarily focused on presenting forecasting data for Operating, Capital, and Salaries modules.  Built and maintain SQL 2012, 2014, and 2016 database servers, scripts, indexes, and complex queries in SSRS for data analysis and extraction.  Experienced in performance tuning, monitoring, troubleshooting, and optimization of SQL databases using tools such as SQL Database Engine Tuning Advisor, SQL Profiler, and SentryOne Plan Explorer.  Created and maintained Stored Procedure ETL mappings between Questica Budget and other financial data sources (.csv, Excel Files, Dynamics GP, SoftVelocity: Clarion) Show less



The Alberta School Employee Benefit Plan (ASEBP)

• Canada
• Wellness and Fitness Services
• 100 - 200 Employee

• Applications Analyst

  • May 2013 - Mar 2018

  Responsible for major upgrades of customized software, SQL development and maintenance, and gathering technical business requirements. Key Contributions:  IT lead of major disability process management system upgrade. In charge of deployment, data migration, and integration of multiple enterprise systems. Three year project costing roughly $3,000,000.  Implemented new claim type within Disability Management System in six months utilizing product base functionality. Provided solutions and alternatives in lieu of third party customizations, saving the company over $100,000.  Gathered business requirements and developed solutions using C#, SQL, .bat scripts, and PowerShell. Identified and automated slow business processes with in house applications collectively saving hundreds of hours of manual work annually.  Passionate about saving time and money, utilizing SQL Jobs Scheduler and Windows Task Scheduler to automate redundant tasks. Show less



TerraTap Technologies Inc.

• Canada
• Software Development
• 1 - 100 Employee

• Database and Web Developer (Work Term)

  • Apr 2012 - Jun 2012

  Created a web service that allows partnered companies to provide their information for a database operated by TerraTap. These companies would then be able to view other partners and their services offered from a TerraTap website. - Developed a normalized SQL database to store company and contact information. - Connected back end Java to communicate with front end PHP using RESTful web services. - Implemented GET, PUT, POST, and DELETE Java functions to handle URI requests. Created a web service that allows partnered companies to provide their information for a database operated by TerraTap. These companies would then be able to view other partners and their services offered from a TerraTap website. - Developed a normalized SQL database to store company and contact information. - Connected back end Java to communicate with front end PHP using RESTful web services. - Implemented GET, PUT, POST, and DELETE Java functions to handle URI requests.



British Columbia Institute of Technology

• Canada
• Higher Education
• 700 & Above Employee

• Developer (Work Term)

  • Jan 2011 - Apr 2011

  Produced two visually appealing desktop applications to help students learn aspects of coding. - Two animated applications would prompt the user to either: • Select the correct block of missing code from a list provided. • Place mixed up code into the correct order. - Developed the front end of the application using ASP.NET and C# for the back end. - Questions for the game would be remotely uploaded by the professor using a Microsoft Excel file. - The user would be given a rating based on their score and the time taken to complete the questions. - Users would be required to log in and their stats would be recorded on a separate server. Show less