Travis Doerksen
Summary
Travis has 29 years of experience in the information technology sector, including experience with relational databases, application development and maintenance, corporate reporting, data warehousing, data modelling, and business analytics. His diverse training and experience enable him to work effectively as a development team member. Travis has worked with various BI technology stacks including Microsoft, SAP Business Objects, IBM Cognos, Informatica and Oracle. He has experience creating and analyzing requirements and developing end-to-end decision support system solutions with an emphasis on Data Warehouses.
Professional ETL expert with keen focus on data integration, transformation, and loading processes. Adept at working collaboratively within teams to deliver high-quality, scalable solutions. Strong skills in SQL, data warehousing, and ETL tools, ensuring seamless data flow and reliable performance. Known for adaptability and consistent results in dynamic environments.
Overview
13
13
years of professional experience
Work History
ETL Developer/Reporting
Quartech Internal AI Projects
07.2025
- This project involved setting up a data warehouse using Azure and Fabric tools to adequately provide reporting statistics for an internal HR AI app. Travis’s responsibilities include:
- Setup of Azure/Fabric for data ingestion and replication
- Analyzing the LAPD data to support ETL development
- Technologies: Azure, Fabric, Terraform, GitHub
ETL Developer
Quartech/Los Angeles Police Department
04.2024 - 07.2025
- Commendations Modernization and Claims and Lawsuits Modernization
- This project involved developing an ETL that moves data to/from the LAPD database into the Vision application. Travis’s responsibilities include:
- Performing ETL development with Informatica and PL-SQL/Oracle
- Analyzing the LAPD data to support ETL development
- Supporting ETL and knowledge transfer with the client
- Technologies: Oracle, PL-SQL, MS SQL Server, MS SSIS, Informatica
Oracle Developer
Quartech/BC Ministry of Attorney General and Public Safety Sector
02.2024 - 07.2025
- JUSTIN Application Modernization Initiative
- This project involved migrating legacy Oracle Forms to modern application architecture. Travis’s responsibilities include:
- Developing and maintaining PL-SQL packages to support front-end development/data retrieval/updates/inserts/deletes
- Analyzing the JUSTIN database to support front-end requirements
- Supporting testing of front-end and packages
- Technologies: PL-SQL, Oracle
BI Developer
Quartech/Ministry of Emergency Management and Climate Readiness (EMCR)
01.2025 - 06.2025
- Various Internal Projects
- Travis was responsible for maintaining and developing ETL that moves data to/from the various EMCR databases into the EDW. Travis contributed in the following ways:
- Performed ETL development of the data warehouse using Microsoft SSIS
- Analyzed the EMCR data to support ETL development
- Supported reporting with the client
- Technologies: MS SQL Server, MS SSIS
ETL Developer
Quartech/Philadelphia Police Department/New Orleans Police Department
02.2024 - 12.2024
- Quartech Justice Solutions
- This is a vision application ETL support role, and Travis contributed in the following ways:
- Supported reporting and ETL business needs
- Performed ETL development of the data warehouse using Microsoft SSIS
- Contributed to report development using ETL data and SSAS
- Technologies: MS SQL Server, MS BI stack, MS SSIS, MS SSRS
Business Intelligence Developer
NTT/BC Assessment
04.2018 - 01.2024
- Various Internal Projects
- BC Assessment develops and maintains real property assessments throughout British Columbia and provides real property information. Travis contributed in the following ways:
- Worked with the business subject matter experts in the analysis, design and development of the Property Inventory, Assessment Valuation and Roll subject areas
- Developed yearly Notices sent out to property owners
- Developed technical specifications for subject areas
- Performed ETL development of the data warehouse using Microsoft SSIS
- Performed database work, including tables and scripts for all development using MS SQL Server
- Supported the Rolls and Notices team
- Technologies: MS SQL Server, MS BI stack, MS SSIS, MS Azure DevOps, MS Power BI
Business Intelligence Developer
NTT Data/BC Oil and Gas Commission
01.2017 - 03.2018
- Various Internal Projects
- The BC Oil and Gas Commission is the provincial, single-window regulatory agency responsible for regulating oil and gas activities in BC, including exploration, development, pipeline transportation and reclamation. Travis contributed to various projects in the following ways:
- Worked with the business subject matter experts in analyzing and designing the First Nations Consultations subject area
- Developed technical specifications for the BI subject area
- Performed ETL development of the data warehouse ETL using Microsoft SSIS
- Performed database work, including tables and scripts for all development using MS SQL Server
- Technologies: MS SQL Server, Microsoft BI stack
Business Intelligence Developer
NTT Data/DirectWest
07.2016 - 12.2016
- Various Internal Projects
- Direct West is a marketing firm for local and national businesses. Travis worked on various internal projects and contributed in the following ways:
- Worked with the business subject matter experts to analyze and design the initial BI subject area
- Developed business and technical specifications for the BI subject area
- Performed ETL development of the data warehouse ETL using Microsoft SSIS
- Performed database work, including tables and scripts for all development using MS SQL Server
- Technologies: MS SQL Server, Microsoft BI stack
Business Intelligence Developer
NTT Data/Ministry of Public Safety and Solicitor General
03.2013 - 07.2016
- Various Internal Projects
- Worked directly with various business groups in the design and implementation of BI subject areas
- Provided estimates and analysis for new subject areas and enhancements
- Performed subject area data modelling with input from the business
- Created technical documentation for BI subject areas
- Performed ETL development of the Data warehouse ETL development using IBM Cognos BI Suite.
- Performed database work, including tables and scripts for all development using Oracle
- Upgraded the Ministry’s Cognos BI Suite from 10.2.1 to 10.2.2
- Technologies: MS SQL Server, Microsoft BI stack, IBM Cognos BI, Oracle
ETL Developer
NTT Data/Altalink
10.2012 - 02.2013
- Miscellaneous Projects
- Responsible for ETL development using Microsoft SSIS and SQL Server
- Performed DB work, including tables and scripts for all development using SQL Server
- Technologies: MS SQL Server, PL-SQL, Microsoft BI stack
Education
Diploma (with Honours) - Computer Systems Technology
Northern Alberta Institute of Technology
01.1996
Skills
- Business Intelligence Tools
- Microsoft Power BI
- SQL Service Reporting Services (SSRS)
- IBM Cognos 10 BI Suite
- SAP Business Objects
- Oracle BI Developer
- Crystal Reports
- Informatica
- Tools Technologies
- MS Visual Studio
- SQL Service Integration Services (SSIS)
- Azure DevOps
- Database Platforms
- Oracle
- MS SQL Server
- DB2
- PL/SQL
Timeline
ETL Developer/Reporting
Quartech Internal AI Projects
07.2025
BI Developer
Quartech/Ministry of Emergency Management and Climate Readiness (EMCR)
01.2025 - 06.2025
ETL Developer
Quartech/Los Angeles Police Department
04.2024 - 07.2025
Oracle Developer
Quartech/BC Ministry of Attorney General and Public Safety Sector
02.2024 - 07.2025
ETL Developer
Quartech/Philadelphia Police Department/New Orleans Police Department
02.2024 - 12.2024
Business Intelligence Developer
NTT/BC Assessment
04.2018 - 01.2024
Business Intelligence Developer
NTT Data/BC Oil and Gas Commission
01.2017 - 03.2018
Business Intelligence Developer
NTT Data/DirectWest
07.2016 - 12.2016
Business Intelligence Developer
NTT Data/Ministry of Public Safety and Solicitor General
03.2013 - 07.2016
ETL Developer
NTT Data/Altalink
10.2012 - 02.2013
Diploma (with Honours) - Computer Systems Technology
Northern Alberta Institute of Technology