Résumé

Rohan Hare

IT Systems Analyst · Business Systems · Enterprise Applications · SQL · Automation

Cross-functional technology professional with 17+ years of Canadian experience spanning business and systems analysis, enterprise application support, SQL/data and reporting, automation, Microsoft platforms, infrastructure operations, IT service management and project delivery. Strong at translating business needs into practical technical solutions, tracing system dependencies and data flows, coordinating delivery across business and technical teams, and carrying solutions through testing, implementation and operational support.

Download PDF Discuss a project

PDF, September 2026. Contact details are intentionally left off; please use the contact form. Figures such as report counts and lines of SQL are my own counts and are approximate.

Professional experience

RTH Tech Services Inc.

Vancouver, BC

Principal Consultant

Apr 2016 – Present

Lead client discovery to define business problems, requirements, scope, risks and deliverables across reporting, Microsoft 365, SharePoint and automation engagements for several legal firms, a strata corporation, and a sub-contracted role with a digital marketing agency. Work comes largely through repeat business and referrals, including a client relationship spanning more than a decade.
Design and develop reporting on SQL Server, SSRS, Excel and Power BI against Elite 3E ERP data. Built reporting from scratch for two law firms (79 reports, ~18,000 lines of SQL, about 12 months each) covering AR, WIP, billing, rankings and firm KPIs for ~500 users. Rewrote 200+ reports for a third firm’s migration from Enterprise 3.7 to 3E (a 10,000+ table schema change); the catalog now stands at 260 reports and ~40,000 lines of SQL for ~280 users.
Built SSRSVantage, a custom .NET application that replaced manual workflows and legacy VBScripts for SSRS schedules, report moves, RDL backups and various other SSRS Server management items. Also delivered 8 Excel dashboards, 50+ SQL ad-hoc data extracts and a custom exporter for monthly billing uploads of 600+ invoices.
Deployed 5 SharePoint intranet portals for four firms, replacing legacy intranets, comprising 100+ site collections and several hundred pages for ~400 users, covering information architecture, permissions, governance and workflow automation.
Developed a production Power Automate monitor for a law firm that checks Supreme Court of Canada feeds hourly, matches reusable user-defined scan profiles and sends triage-ready alerts with AI-assisted summaries.
Manage IT infrastructure for a client, including PCs, Microsoft 365 tenant administration, domains and AGM A/V support.
Assisting a digital marketing agency as a sub-contractor by leading a data-discovery and mapping engagement spanning 35 golf courses, covering financials, membership, bookings, point-of-sale, food and beverage, and resort-hotel data.

Powerex

Vancouver, BC

A wholly owned subsidiary of BC Hydro operating a highly available energy-trading environment across Western North America.

IT Project Analyst, PMO

May 2023 – Jun 2024

Promoted into a newly created cross-functional PMO role focused on continual improvement, technology adoption and practical problem-solving across IT.
Supported initiatives as a business analyst, tester, trainer and implementation resource, translating business needs into requirements, plans, risks, dependencies and supportable technical outcomes.
Maintained IT business-continuity and disaster-recovery plans and coordinated at least two annual exercises across critical applications, services, storage and replicated data.
Helped deliver a disaster-recovery exercise with 96% overall success, 92% of systems recovered within four hours and 98% within eight.
Contributed to Change, Incident, Problem, Service Continuity and Continual Improvement Management, producing project documentation, procedural manuals and status reports.
Analysed business and IT processes, working with architects, technical teams and executives to improve system efficiency, usability and support.

IT Operations Business Analyst

Dec 2018 – May 2023

Served as a cross-functional business and operations analyst in a complex energy-trading environment of interconnected applications, integrations and internally developed tools.
Led business-continuity and disaster-recovery activities, including plan maintenance, validation, recovery-site health checks and organization-wide exercises.
Administered Tableau Server, managing access, extract schedules, backups, platform health and capacity.
Supported rapid Microsoft 365 adoption during the shift to remote work, delivering company-wide training on Teams, OneDrive, Planner, To Do and Office Online.
Developed and maintained a self-service portal with technical guidance, training materials, FAQs and learning resources.
Investigated recurring operational friction and coordinated improvements across application, infrastructure, cybersecurity, database and business teams.

Infrastructure, Operations and Security

Dec 2017 – Dec 2018

Coordinated operating-system and application patching and maintained endpoint-protection, spam-detection and phishing-detection solutions.
Managed workstation updates, application deployment and monitoring through Microsoft System Center Configuration Manager.
Supported Windows infrastructure, Group Policy, server installations, IIS application pools and changes affecting clustered services.

Applications Support Analyst and IT Change Manager

Apr 2016 – Dec 2017 (Contract Apr – Nov 2016)

Supported hundreds of third-party and internally developed applications, services and integrations in an energy-trading environment.
Served as the intermediary between business users and technical teams during issue investigation and resolution.
Scheduled, tracked and reported on production changes, applied ITIL-aligned Change Management practices and supported annual change-management audits.

Harper Grey LLP

Vancouver, BC

Applications Analyst

Apr 2012 – Apr 2016

Facilitated stakeholder workshops with partners and senior management, documented business requirements and translated them into technical specifications for a firm-wide intranet initiative.
Managed external-vendor participation, requirements clarification, timelines and budget constraints while coordinating delivery with internal stakeholders.
Supported and optimized enterprise applications including document management, time tracking, cost-recovery and ERP systems, troubleshooting issues and coordinating production changes.
Developed an internal document-automation solution that streamlined lawyer/paralegal workflows and reduced printing and scanning associated with document finalization.

Core capabilities

Business & systems analysis

Requirements discovery, process analysis, current-state assessment, technical specifications, needs assessment.

Enterprise applications

Application ownership and support, configuration, upgrades, integrations, vendor coordination, production change.

Data & reporting

Report design and development, data validation, reconciliation, migration, dashboards, ad-hoc data extraction.

IT service management

ITIL-aligned Change, Incident, Problem, Service Continuity and Continual Improvement practices.

Project & workstream delivery

Lifecycle coordination, planning, risks and dependencies, implementation readiness, stakeholder communication.

Testing & change

Test planning, UAT, defect investigation, configuration changes, implementation, operational handover.

Automation & integration

Workflow automation, scripting, API-driven integrations, low-code solutions, data movement, process simplification.

Documentation & training

Business cases, procedures, SOPs, user guides, knowledge bases, training, adoption and support.

Technical profile

Data & reporting: MS SQL Server (T-SQL), SSRS/PBIRS, SSIS, Power BI, Tableau/Tableau Server, PostgreSQL, Azure SQL, Excel
Microsoft & collaboration: M365 administration, SharePoint, Power Automate, Teams, OneDrive, Exchange Online, Entra ID/AD
Automation & development: PowerShell, Python, .NET, REST/MS Graph/OData APIs, JSON/XML/YAML, Git/GitHub, Visual Studio
Enterprise applications: Elite Enterprise 3.7 / 3E (ERP), document management, time tracking and cost-recovery systems, ITIL-aligned incident, problem, change and service management
AI & workflow automation: AI-assisted document summarization, feed- and API-driven monitoring, profile-based alerting, low-code workflow design
Enterprise / operations: Windows Server, IIS, SCCM / Configuration Manager, Group Policy, endpoint operations, backup/recovery, DNS, networking fundamentals

Education & certifications

Advanced Diploma, Computer Systems Engineering — RMIT University, Melbourne, Australia (2006)
ITIL Foundation Certificate in IT Service Management — AXELOS (2018)
Microsoft Certified Technology Specialist: SharePoint 2010 Configuration; SQL Server 2008 Implementation & Maintenance; Windows 7 Configuration
Cisco Certified Network Associate (CCNA) — Cisco (2003)