SUMMARY:
Represents the Maintenance Systems Support Department (MSS) facilitating technical support and expertise in Maintenance Systems (MS) applications and Data Analysis as it applies to Fleet Business and Engineering units. Work with clients to identify requirements, gather information, propose, and implement new procedures, applications, enhancements, configuration changes, procure hardware and software, and liaise with BTS to ensure standards and procedures comply within company policy. Develop business centric applications utilizing various programming languages as required by operating units. Provides guidance and support to Maintenance Systems Coordinators. Coordinates with external support teams to ensure organizational systems are functioning in accordance with business needs. Provides guidance, expertise, and recommendations to various stakeholders in CMBC and TransLink on various reporting systems, analytical tools, processes, and requirements. Conducts complex analysis, forecasting, reporting and documentation to improve effectiveness and to support continuous improvement of the various maintenance related systems for the division. Provides training to various stakeholders on MS, various reporting systems, analytical tools, processes, and requirements.
DUTIES AND RESPONSIBILITIES:
Work with clients to identify requirements, gather information, propose, and implement new procedures, business centric applications, enhancements, configuration changes, procure hardware and software, and liaise with BTS to ensure standards and procedures comply within company policy by:
Identifying the requirements, assessing the impact of changes, maintaining, developing, and refining related Maintenance Systems including, but not limited to: Annual Workplan for Planning, Brake Reline Management, Maintenance Reporting, Fuel and KM systems, Power BI Dashboards, as well as new and developing Maintenance business processes.
Configuring, testing, improving, and troubleshooting new, or updated systems that have been implemented.
Liaising with BTS units in assessing recommendations and its impact on infrastructure.
Understanding the application technical infrastructure and the BTS Enterprise Architecture plans and future directions, for example: participating in the conceptual workshops and provide technical insights for MS in upgrading and advancement of Enterprise Resource Planning directly affecting the betterment of future versions.
Providing guidance and advice to maintenance system users to ensure information availability, quality, integrity, and reliability is maintained.
Reviewing and monitoring various maintenance information sources and systems to identify and resolve issues as well as verify their operation and data quality.
Driving to various CMBC locations to respond to issues and troubleshoot problems with systems.
Providing demos, training and knowledge transfer to end users, peers, and other Business units.
Develop business centric applications utilizing various programming languages as requested by internal and external customers:
Obtaining information, assessing requirements, proposing solutions, and coordinating hand-off for updates and support developing application files and reports using programs such as Cognos, Crystal Reports, Microsoft Excel, Access, Power Query, Power Pivot, Power BI
Utilizing programming languages such as, but not limited to: Structured Query Language (SQL), Visual Basic for Applications (VBA), Power Query M, and Data Analysis Expressions (DAX).
Liaising with BTS and Data solutions teams to collaborate and ensure applications adhere to development and support standards.
Maintaining the health of applications by providing continuous support, enhancements, and customizations throughout the application’s lifecycle.
Provides guidance and support to Maintenance Systems Coordinators by:
Assigning day to day tasks, checking for accuracy and completion of work in a timely manner.
Verifying scheduled reports on vital business metrics avoiding service disruptions that can affect scheduled operational functions.
Monitoring and escalating change requests in the ticketing queue affecting the safety and security of revenue and non-revenue vehicles, for example: modifying inspection points and related parts avoiding critical failure costing unforeseen corrective maintenance.
Assisting the Assistant Manager in allocating tasks and providing guidance.
Responding to emergency callouts for immediate operation support as required, including off hours.
Coordinates with external support teams to ensure organizational systems are functioning in accordance with business needs by:
Liaising with external companies such as fuel vendors, software vendors, tank monitoring providers, and vendor for oil analysis to understand, assess and determine requirements relating to maintenance systems.
Keeping up to date on the application technical infrastructure and coordinating with TransLink support team ensuring requests submitted to them are in line with business processes and needs.
Identifying and assessing the impact of the changes requested by business users to ensure it meets organizational need/requirement and provides recommendation for improvement/adjustments.
Coordinate with external service provider in troubleshooting maintenance required systems to ensure functionality is up to organizational standards.
Ensure functionality of maintenance systems associated hardware, such as trouble shooting, diagnosing, repairs, and/or replacements.
Advancing knowledge and skills to become subject matter experts of the relevant supported applications.
Provides guidance, expertise, and recommendations to various stakeholders in CMBC and TransLink on various reporting systems, analytical tools, processes, and requirements by:
Liaising with internal stakeholders such as Engineering, Training, Maintenance, Planning, Finance, Inventory, BTS, TransLink and CMBC Service Planning, HR, Performance Reporting, Infrastructure, and Bus Services.
Working with internal customers collaboratively to resolve issues and improve existing processes, including making recommendations for changes to reflect current conditions and ensure accurate results.
Providing recommendations to internal project teams as required, not limited to business processes and practices, detail design on systems, user requirements for efficiencies/functionalities.
Conducting and participating in maintenance cost/benefits analyses, derived from reporting or statistical solutions, typically from ad-hoc requests or abnormal behavior within data.
Providing guidance as needed in the use of best practices relating to Asset Management information, Work Management information and Workflow Management within MS and Maintenance Business Processes, to support change management.
Conducts complex analysis, forecasting, ad-hoc reporting, and documentation to improve effectiveness and to support continuous improvements of the various maintenance related systems for the division by:
Designs, develops, tests, implements, and maintains business solutions as required by the division.
Developing, maintaining, and refining the Fleet Maintenance Work Plan environment, modelling tools, and business processes.
Conducting in-depth analysis and studies involving advanced methods and techniques and statistical software, of current fleet MS and processes to identify problematic systems or procedures that need to be reworked, to improve efficiency, effectiveness and recover resources where possible.
Documenting all analysis, findings, and recommendations for improvement.
Developing, reviewing, and updating maintenance system processes, procedures, documentation, guidelines, and manuals, ensuring accuracy, current, and easily accessible to the maintenance team, to increase retention of processes within Fleet Maintenance.
Maintaining these documents to ensure information is current and up to date with ease of reference.
Liaising with other departments and external suppliers to determine requirements needed to create, test, and implement operational and statistical maintenance reports using various tools and maintenance systems.
Provides training to various stakeholders on MS, various reporting systems, analytical tools, processes, and requirements by:
Providing training on various maintenance systems for various user groups including but not limited to garage staff, other team members, and individuals that may need to use MS.
Developing training materials on emerging technologies and updates to current applications ensuring data quality and integrity are maintained.
Performs related duties as assigned, such being items of a minor nature that do not affect the value of the job.
