Summary
Overview
Work History
Education
Skills
Timeline
Generic

Liza Shatula

Edmonton,AB

Summary

Dedicated IT professional with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.

Overview

28
28
years of professional experience

Work History

Senior Data Engineer

Alberta Motor Association
11.2017 - Current
  • Contributed to internal activities for overall process improvements, efficiencies and innovation.
  • Collaborated with data and integration teams on ELT (Extract, Load, Transform) tasks, maintaining data integrity and verifying pipeline stability.
  • Performed large-scale data conversions, transferring structured and semi-structured data into standardize formats for integration into Snowflake.
  • Monitored incoming data analytics requests, executed analytics and efficiently distributed results to support strategic plan.
  • Prepared written summaries to accompany results and maintain documentation.
  • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
  • Developed, implemented, supported and maintained data analytics protocols, standards and documentation.
  • Designed and built data mart structures following Kimball methodology for data warehousing.

Systems Analyst - Data Warehouse

Alberta Motor Association
03.2004 - 11.2017
  • Planned and conceived computer systems using information engineering, data modeling and structured analysis.
  • Performed system analysis, documentation, testing, implementation and user support for platform transitions.
  • Evaluated and adopted new technologies to address changing industry needs.
  • Built data cubes, data marts and queries, maintaining every aspect of storage and translation.
  • Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
  • Documented data warehouse architecture to guarantee capacity met current and forecasted needs.
  • Assisted users in accessing databases, troubleshooting malfunctions and removing system-based barriers to task completion.
  • Developed applications and designed processes for transformation and data management from company-wide databases.
  • Cooperated fully with product owners and enterprise architects to understand requirements.
  • Mapped data between source systems and warehouses.

Owner/Operator

White Fox Hotel
White Fox, SK
10.2010 - 06.2017
  • Managed day-to-day business operations.
  • Assessed income and expenses and adapted plans to improve profit levels.
  • Developed and nurtured lasting customer relationships by responding quickly to logistical and scheduling issues.
  • Spoke professionally with customers regarding complaints, gathering all necessary information to make educated decisions and address issues.

Systems Analyst - HR, Payroll & Finance

Alberta Motor Association
05.2002 - 03.2004
  • Resolved or escalated problem tickets to resolve user issues.
  • Performed system analysis, documentation, testing, implementation and user support for platform transitions.
  • Resolved malfunctions with systems and programs through troubleshooting.
  • Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance.
  • Requirement gathering for developing custom reports.
  • Planned and performed Microsoft SQL Server database backups and restores.
  • Responsible for performing software testing, customizations and upgrades.

IT Technician

Alberta Energy
01.2000 - 12.2000
  • Performed maintenance tasks on PCs, networks and mobile devices.
  • Set up PCs, projectors, and microphones for use in video conferencing rooms.
  • Established, repaired and optimized networks by installing wiring, cabling and devices.
  • Responded to support requests from end users and patiently walked individuals through basic troubleshooting tasks.

Education

Bachelor of Applied Information Systems Technology -

NAIT ( Northern Alberta Institute of Technology
Edmonton, AB
05.2003

Computer Systems Technology -

NAIT ( Northern Alberta Institute of Technology )
Edmonton, AB
06.2001

Skills

  • Customer Relationship Management
  • User Documentation Production
  • Requirements Gathering and Analysis
  • Data Extraction, Loading and Transformation ( ELT )
  • Database Design and Development
  • Critical Thinking
  • Data Warehouse Processing
  • Process Efficiencies
  • Complex Problem-Solving
  • Snowflake, Databricks, T-SQL, Java, Python, R, C#, Pebble
  • Wherescape RED, Qlik Replicate, Jupyter notebooks

Timeline

Senior Data Engineer

Alberta Motor Association
11.2017 - Current

Owner/Operator

White Fox Hotel
10.2010 - 06.2017

Systems Analyst - Data Warehouse

Alberta Motor Association
03.2004 - 11.2017

Systems Analyst - HR, Payroll & Finance

Alberta Motor Association
05.2002 - 03.2004

IT Technician

Alberta Energy
01.2000 - 12.2000

Bachelor of Applied Information Systems Technology -

NAIT ( Northern Alberta Institute of Technology

Computer Systems Technology -

NAIT ( Northern Alberta Institute of Technology )
Liza Shatula