Elliot Lui

Experience

• 

  Canada Place Dental & Wellness

  Jan 2014 - Apr 2019

  Office and Inventory Assistant

  • Organized and updated patients’ records within a database of over 3500 people to relay crucial info to supervisors in real time; received up to 5 new patients per day.• Compiled 20+ insurance documents, warranty claims, and relevant medical records daily to maintain information flow around clinic.

• 

  Haskayne Students' Association

  Oct 2018 - Apr 2020

  • Managed 3 monthly student-led initiatives with 100+ attendants each in Scurfield Hall that included promoting student life, mental health, and personal well-being on campus. • Led a sub-committee of 5 club directors to plan the HSA’s first-ever case competition for Winter 2019. Logistics involved 40 attendants, 6 teams, and 12 weeks of planning.• Professionally maintained communication with Haskayne professors and academic departments to plan 6 different academic workshops/events per semester averaging 4 hours per week.

  • Student Life Director

    Sept 2019 - Apr 2020

  • Academic Director

    Oct 2018 - Aug 2019
• 

  Camps Reservations Canada

  Jan 2019 - Apr 2019

  Student Consultant

  • Cooperated with a team of 6 students consulting for our client to develop industry-standard strategy for market penetration worldwide to over 3200+ campsites in North America.• Directed the key messaging and brand guide strategy committee as team lead. Delivered comprehensive slide deck and deliverables to clients in an 8-week time frame.

• 

  University of Calgary

  May 2019 - Sept 2019

  IT Risk and Compliance Analyst

  • Examined risks and support control frameworks for software and program acquisitions totaling up to $20,000 value per project.• Provided technical guidance to both IT department and clients on the assessment and mitigation of risk.• Worked in a cross-functional environment with the ServiceNow, IT Architecture, and IT Security teams to ensure effective IT governance throughout the University.

• 

  Husky Energy

  Jan 2020 - Dec 2020

  IS Project Controls Analyst

  • Created a new Monthly Status Report (MSR) Dashboard with Power BI to improve project reporting by tracking financials and KPI metrics of 20+ IS projects totaling over $150 M of funds. • Developed and maintained an Excel VBA Tool containing 40+ employees to assist Project Managers with work allocation.• Supported the IS PMO (Project Management Office) with: improving the IS SharePoint site, monitoring monthly reporting, and verifying SAP financials. • Actively used Excel, SharePoint, and Project Management software to improve daily tasks. Show less

• 

  Dakota Analytics Inc.

  Dec 2021 - Jan 2023

  Business Intelligence Consultant

  • Established ETL operations through Microsoft Azure Synapse pipelines to modernize the client’s data flow.• Implemented 5+ Power BI applications (which included integrated Power Apps and paginated reports) for over 2 O&G clients to aid finance and volumes related decision-making.• Performed daily extensive maintenance and creation of SQL objects (schemas, views, stored procedures) with databases totaling over 300 objects.• Built 500+ DAX measures within tabular editor to upgrade old legacy reporting to Power BI. Show less

• 

  ATCO

  Mar 2023 - now

  Metrics Analyst