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 )