Ryan Kusters Email & Phone Number

Edmonton, Alberta, Canada

As leader of this team I am responsible for the gathering of business data, its analysis, and application towards or support of department data driven decision making, process improvements, system improvements, and any other use case that occurs.In addition my team supports the business by providing expertise and coordination between operations and the business analysts representing the shared ticket system configuration team.Accomplishments-Established a client side team to… Show more As leader of this team I am responsible for the gathering of business data, its analysis, and application towards or support of department data driven decision making, process improvements, system improvements, and any other use case that occurs.In addition my team supports the business by providing expertise and coordination between operations and the business analysts representing the shared ticket system configuration team.Accomplishments-Established a client side team to organize and unify engagement with and requirements of multiple service line teams and provide clear common single-voice communications between the entire department and the Business Analysts of the shared ticket system, reducing confusion and enabling system improvements to proceed.-Founded an ad-hoc team by arranging with other team managers to borrow resources to perform User Acceptance Training. By doing so the team identified multiple issues with the release that Developer testing and Quality Control testing failed to find, these issues would have frustrated data entry causing losses in time, increased error occurrence, and additional distress on users.-Performed a historical audit of the requirement tracking system for a feature that had stalled for 2 years. Identified the root cause of the failure and escalated to senior management for resolution with the full timeline details, analysis, and conclusions including options to go forward. Show less

Edmonton, Alberta, Canada

Edmonton, Alberta, Canada

Edmonton, Alberta, Canada

Worked in the private car management team to provide data to account managers.Created car flow reports that are used to ensure bulk transport rail cars are in the right locations at the right time.Analyzed North American commodity transport traffic to reduce stockyard and terminal congestion by dynamically resizing fleet allocationsCreated reports to allow account managers to encourage dwell reduction.Learned how business intelligence impacts operations and to consider outside… Show more Worked in the private car management team to provide data to account managers.Created car flow reports that are used to ensure bulk transport rail cars are in the right locations at the right time.Analyzed North American commodity transport traffic to reduce stockyard and terminal congestion by dynamically resizing fleet allocationsCreated reports to allow account managers to encourage dwell reduction.Learned how business intelligence impacts operations and to consider outside actors and market forces impacting the business. Show less

Edmonton, Alberta, Canada

Designed and implemented to completion a replacement business intelligence architecture for a mission-critical legacy application. Collaborated with stakeholders, management, end-users to create new features and process enhancements to facilitate data-driven decisions.Designed ETL and Data Cube by sourcing stakeholder input Consolidated two separate Data Cubes into one searchable Cube after consulting with data entry clerks, learning the business workflow.Implemented the ETL Process… Show more Designed and implemented to completion a replacement business intelligence architecture for a mission-critical legacy application. Collaborated with stakeholders, management, end-users to create new features and process enhancements to facilitate data-driven decisions.Designed ETL and Data Cube by sourcing stakeholder input Consolidated two separate Data Cubes into one searchable Cube after consulting with data entry clerks, learning the business workflow.Implemented the ETL Process and consolidated Data Cube given Relational Database and Flat File sources using Microsoft SQL Server Integration Services (SSIS) & SQL Server Reporting Services (SSRS). Trained analysts to utilize the new Cube to make reports.Documented all project aspects in detail.Created an animated disease outbreak map report.Assisted team members with technical and data insight tasks. Show less

Bachelor Of Science (Bsc), Computer Software Engineering

Bachelor Of Science (Bsc), Physics