Outliers Consulting Ltd., Edmonton, AB 2021 - Present
Outliers Consulting provides business intelligence, system delivery, and analytics best practice consulting for clients in the Utilities (ATCO Electric), Sports & Entertainment (Edmonton Oilers & StellarAlgo), Government (Government of Alberta), and Biopharmaceutical (Aurora) industries.
Senior Business System Analyst (ATCO Electric) October 2022 - Present
Support ATCO Electric WAM-E Program that involves the integration of ATCO’s Enterprise Maximo Cloud with Oracle Field Services (OFS), and the new Customer Information System- Oracle Customer Cloud Services (CCS).
ATCO Electric’s WAM-E Program is responsible for implementing a standard IPSECA target operating model for all Electricity fieldwork.
Primary business analyst on the Distribution Scheduling (DIBS) project for bringing all customer initiated, metering, transmission emergency, and underground locate field work into the IPSECA target operating model.
Led definition of requirements for all DIBS field work initiated and planned in Maximo Cloud, scheduled and executed in OFS, and then closed & analyzed in Maximo Cloud. Responsibilities included requirements gathering, process mapping, vendor management, design review/approval, and quality assurance.
Senior Business System Analyst (Aurora Cannabis) April 2021 - October 2022
BI & Data Science Initiatives
Gathered requirements for dashboards serving all business areas across the organization
Defined features in consultation with business SMEs for an engagement scoring model for patient base. Responsibilities included requirements gathering, QA, and code reviews
Marketing Initiatives
Led definition of loyalty and referral program for Aurora's medical patients.
Assisted in development of organization's marketing strategy for all digital media. Documented current state customer journey and assisted in definition of future state strategy
Defined segmentation strategy and implemented within Dynamics 365 Customer Insights
CRM Initiatives
Gathered requirements for Targeted Sales Channel initiative built in Dynamics 365 and synced to Shopify
Led survey platform transition from Qualtrics to Dynamics 365 Customer Voice
E-commerce Initiatives
Conducted market & solution evaluation for product recommendation engine that would provide cross/up-selling opportunities on Shopify platform
Conducted workshops to optimize lead funnel and conversion for new and returning patients
Microsoft Azure
Conducted an audit on all Azure resources and spend to identify $100k in annual cost savings
Implemented Azure Synapse proof of concept to demonstrate alternative semantic layer that would result in cost-savings and improved performance
Customer Success Consultant (StellarAlgo) June 2021 - December 2021
Short-term engagement to develop an onboarding process for new sports and entertainment clients for StellarAlgo's data warehouse product offering.
Conducted a current state evaluation of onboarding process. Defined a scalable future state onboarding process and assets for new data warehouse clients as they are brought online.
Senior Business Intelligence Analyst (Government of Alberta) January 2021 - March 2021
Short-term engagement to develop a SAS Visual Analytics reporting package for Tax Revenue and Administration. Completed under budget and ahead of schedule (2 weeks).
Oilers Entertainment Group, Edmonton, AB 2015 - 2021
Oilers Entertainment Group (OEG) owns the 5-time Stanley Cup Champion Edmonton Oilers, and operates Rogers Place, North America’s premier and most technologically advanced sports and entertainment venue. Headquartered in Edmonton, Alberta, OEG’s growing staff of over 1,600 full- and part-time employees help to deliver exceptional sports, entertainment and other special event programming to fans and patrons in Canada and the United States.
Business Intelligence (Data) Architect 2018 - Present
Responsible for guiding organization’s data strategy and ensuring data flows are accurate, consistent and timely between core data systems while developing technical solutions to achieve department objectives
Collaborate and contribute to a cross-functional team including Ticket Service, Ticket Sales, Ticket Operations, Product Marketing, and BI responsible for reaching all ticketing revenue targets for Edmonton Oilers, Edmonton Oil Kings and Rogers Place.
Responsible for one direct report (Marketing Automation Specialist/Eloqua Administrator, BI) and one indirect report (CRM Administrator/Inventory Manager)
Responsible for designing and maintaining all of OEG’s data architecture including:
Completed market evaluation of all potential solutions for organization’s email marketing platform from business case to final executive recommendation and contract negotiation with Oracle
Transitioned OEG’s email marketing platform from ClickDimensions to Eloqua during peak tactical period for organization with no disruption in service for key IIHF World Junior Championship campaign
Responsible for designing and maintaining all of OEG’s data architecture including data flows, between data systems, data governance and data security. Architecture was designed by gathering requirements and incorporating feedback from system owners and system power users to ensure required data was accessible in each system without exposing any extraneous data to limit liability for the organization
Manage relationship with 3rd party provider to develop and maintain Data Warehouse for operational reporting used to manage and optimize Oilers, Oil Kings, and Rogers Place operations
Manage relationship with 3rd party providers for best practices consulting on email marketing platform and CRM plugins
Maintain awareness of best practices and emerging trends in business intelligence and analytics. Work closely with peers within the industry to leverage potential opportunities and lessons learned
Tools & Technologies: Tableau Online & Desktop, Dynamics CRM 365 Online, Dynamics CRM 2013, Kore Pro Sports, Excel, Access, Word, Visio, Teams, SQL Server 2016, Microsoft Azure, Ticketmaster Archtics, Tibco Scribe, Oracle Eloqua, Python
Business Intelligence Analyst 2015 - 2018
Collaborate with Product Marketing team to develop solutions to meet evolving business requirements for Oilers, Oil Kings, Rogers Place, Ice District and Live Entertainment marketing initiatives
Coordinate the collection and import of customer data into CRM, ensuring maximum accuracy at all times
Design, develop, implement and report on CRM launch of Rogers Place ENEWS and Rogers Place Premium Insider newsletters. Subscriber base has grown to over 15k subscribers resulting in over $1 million in online sales
Perform database segmentation, generating target groups and prospect lists for various marketing, sales and service initiatives
Collaborate with Ticket Sales and Services team to develop solutions to meet evolving business requirements for Oilers, Oil Kings, Rogers Place, Ice District and Live Entertainment marketing initiatives
Key contributor to relocation of all Oilers and Oil Kings season ticket holders from Rexall Place to Rogers Place to provide smooth customer experience during transition
Generate targeted sales campaigns to grow Oil Kings and Oilers ticket base leveraging look alike modeling, ticket activity, and engagement metrics to score and prioritize leads
Researched, tested and implemented touchpoint plans so that customers receive service levels commensurate with investment level with OEG
Automate and empower team to own process to every extent possible when launching customer events & gifting
Tools & Technologies: Tableau Online & Desktop, Dynamics CRM 365 Online, Dynamics CRM 2013, Kore Pro Sports, ClickDimensions, Excel, Access, Word, Visio, SQL Server 2016, Microsoft Azure, Ticketmaster Archtics, Tibco Scribe, Python
Dynamics CRM Administrator, Business Intelligence 2017 - 2018
Administration, development, support and training for the organization’s CRM (customer relationship management) system
Primary technical liaison between OEG and 3rd party vendors; responsible for deploying system and 3rd party upgrades and providing best practice support as business departments launch new features
Research and test Microsoft Dynamics CRM, ClickDimensions and Kore Sports module updates
Contribute to CRM best practice documentation by continually looking for process improvements and new features to share with team members
Optimize and maintain underlying system data structure for operational and reporting needs
Technical lead responsible for migration from Dynamics 2013 on premise to Dynamics 365 Online implementation
Tools & Technologies: Dynamics 365, Microsoft Dynamics 2013, SQL Server 2016, SharePoint, Tibco Scribe
Fujitsu Consulting, Edmonton, AB 2008 - 2015
Fujitsu is the fourth largest information and communications technology (ICT) companies in the world offering a full range of technology products, solutions, and services.
Technical Business Analyst 2008-2015
Responsible for guiding clients and our development team through the entire solution life cycle, from opportunity analysis through to application maintenance for the Ministry of Municipal Affairs
Defined requirements, specifications, and process enhancements to deliver a municipal elections system that brought the branch from a purely paper and telephone system for election management to a web-based solution that was paperless with the exception of legislated signatures
Resulted in a direct reduction of man hours to manage the 2013 general election
Publicly recognized by municipalities for making election reporting more efficient
First application to be integrated into Ministry’s external portal, system delivery success directly led to greater municipality adoption rates of portal
Defined requirements, specifications, and process enhancements to deliver a grant management system for a gas tank remediation program managing $90 million in provincial funds. Client moved from a system that required technical staff to manage remediation in an end of support application with finance exporting data to Excel to a system that allowed the entire team managed technical, financial, and reporting aspects in a web-based application that interfaced with the ministry’s IMAGIS payment system
Resulted in increased accuracy of financial bookkeeping
Reduced manual handoffs between technical and finance team
Raised awareness of Fujitsu's capabilities within division which led to a $2 million solution project
Primary business analyst responsible for defining requirements and specifications for all enhancements to and maintenance of:
All business applications in the Assessment Services Branch used to manage assessments, equalization calculations for education levies, and CRLs for all property in the province including ASSET and ALPAS
Multiple applications in the Public Safety Division including the Tank Site Remediation System and Public Safety Payment Application System
Multiple applications in the Municipal Services Branch including Elections Database, Stakeholder Information Management System, & Municipal Financial Indicator System
Administration, development, support and training for the ministry’s standard reporting tool, Cognos Express. Responsible for growing user base to approximately 100 users across seven different business areas using ten different applications within the ministry from nothing
Design denormalized data model to facilitate better analytical capabilities with star & snowflake schema models
Facilitate requirements gathering sessions with multiple business areas to identify key performance indicators for their business
Create reports, key performance indicators, and dashboards for business areas
Manage security model tailored to each business’ desire to share within the ministry to the degree permitted
Develop training materials and facilitate training courses targeted at empowering client to take ownership of their data
Establish best practices for development, implementations, environment deployments, and quality assurance for Cognos Express practice within Fujitsu Edmonton branch
Responsible for support, maintenance and development of new applications and enhancements to applications for the client, Alberta Municipal Affairs. Various applications were supported across the ministry using multiple technology platforms
Reduced load time of external data files into the linear property assessment system by 600% while transitioning to newer technology
Developed an emergency alert system that received two international awards from the International Association of Emergency Managers
Delivered multiple new components into the linear property assessment system to help the business accommodate an ever-changing political landscape
Maintained two property assessment systems responsible for producing and consolidating assessments for all of the property in Alberta, ASSET and ALPAS
The University of Alberta is a top five Canadian university and one of the top hundred in the world, internationally recognized for its ground breaking research and exemplary students and staff.
Technical Business Analyst, Software Developer 2010 - 2013
Tasked with developing a transition strategy while providing enhancements and maintenance as required for a billing application integrated with PeopleSoft for the Marketing and Communications Department at the University of Alberta
Responsible for replacing entire in-house application support team including technical architect, business analyst and developer
Responsible for documenting existing functionality, identifying risks and proposing solutions for moving forward
Provided break-fix support and enhancements to the application
Matrikon (acquired by Honeywell), Edmonton, AB 2004 - 2007
Before being acquired by Honeywell, Matrikon was a world leading provider of advanced software solutions to the process industries. Matrikon produced solutions that allowed the industry to acquire, store, analyze and present (ASAP) process data to make timely and informed decisions.
Software Developer – Mobile Equipment Monitor 2007
Part of a hand-picked development team tasked with integrating Matrikon’s product offering into one solution for monitoring and analyzing heavy equipment data acquired in real-time for the mining industry
An initiative sponsored by the CEO and directly reporting to the CIO to integrate Matrikon’s entire product suite into one solution
Solution provided a competitive cost advantage to clients allowing them to identify break points in their heavy equipment before costly repair and downtime was required
Part of a team responsible for developing a web application to monitor, analyze, and predict pipeline reliability for an oil sands producer. The application allowed the client to collect and upload pipeline thickness readings from hand-held devices and use historical (or predicted) wear rates to predict future thicknesses and make recommendations on future maintenance
The first solution to interface four Matrikon products to deliver a custom solution for a major oil sands producer
Developed changes to increase defined threshold of Matrikon product passed specifications to accommodate solution. Changes were incorporated into product and Matrikon qualified for Scientific Research and Experimental Development (SR&ED) tax credits due to enhancement
Facilitated UAT of application on-site
Developed computer-based training modules for all major areas of functionality in the PRS