Senior Data Modeler - SaskCan IT Services Inc - Bradford, ON
(2024-01 - 2026-12)
Client: Greatway Financials Environment: ERWIN, SQL Server 16, Azure Cloud, PostgreSQL, Databricks, SSMS, Azure Data Studio
- Designed conceptual, logical, and physical data models supporting enterprise financial systems.
- Partnered with business analysts and architects to translate requirements into scalable data structures.
- Conducted data profiling and quality assessments to identify gaps and propose remediation.
- Implemented data governance standards, naming conventions, and modeling best practices.
- Documented metadata, lineage, and architectural diagrams for cross-team consumption.
- Migrated SQL Server workloads to Azure Cloud using DMA, Databricks, and SSMS.
- Developed SQL scripts and supported data ingestion pipelines.
Data Modeler – Operational Data Store (ODS) - Great West Healthcare - Denver, CO
(2021-01 - 2024-12)
Environment: ERWIN, SQL Server, Oracle, TOAD, PL/SQL, T-SQL
- Designed enterprise conceptual, logical, and physical data models supporting enterprise-wide applications.
- Developed dimensional models for enterprise data warehouse solutions.
- Collaborated with business stakeholders to gather and analyze data requirements.
- Designed and analyzed Claims Data Marts for enterprise reporting.
- Created Source-to-Target mapping documents and interface design specifications.
- Validated ETL transformations using complex multi-page SQL queries (10+ pages).
- Identified defects in ETL logic and collaborated with developers to resolve issues.
- Built stored procedures to automate data movement.
- Supported EOB/EOP and Member/Provider portals.
- Created normalized database designs to improve performance and maintainability.
- Worked closely with data architects and ETL developers throughout project lifecycles.
- Developed data dictionaries, metadata repositories, and business glossaries.
- Performed data analysis and data profiling for migration projects.
- Implemented naming standards and data governance best practices.
- Reviewed database performance and recommended optimization strategies.
Data Architect (Enterprise Systems) - Wilfrid Laurier University - Waterloo, ON
(2019-01 - 2021-12)
Environment: Banner 8.5, Oracle, Pro C, PL/SQL, VBA, Unix, PostgreSQL
- Participated in full SDLC for university systems including Student Awards and Accessible Learning.
- Designed enterprise conceptual, logical, and physical data models supporting enterprise-wide applications.
- Developed SSEN pages and updated Pro C packages and PL/SQL programs.
- Built SQL scripts and VBA applications for operational automation.
- Supported Phoneware and Loris applications running on SQL Server and Oracle.
- Authored requirements and design documents for system enhancements.
Data Modeler – Data Warehouse (Hawaiian Telecom) - Bearing Point Inc. - Denver, CO
(2016-01 - 2019-12)
Project: Hawaiian Telecom Data Warehouse Environment: ERWIN, Oracle 11g, PL/SQL, TOAD, DB2
- Gathered business requirements and converted them into technical specifications.
- Built ERWIN data models and data flow diagrams.
- Developed pseudo-code for ETL teams and maintained mapping documents.
- Wrote stored procedures, functions, and ad-hoc queries in Oracle.
- Loaded data from DB2 to Oracle and validated data quality across warehouse layers.
Data Modeler - Develop! International, Inc. - Colorado Springs, CO
(2014-01 - 2016-12)
Environment: Crystal Reports, SSRS, SQL Server 2005, Oracle 9i, PL/SQL, T-SQL
- Designed logical and physical database models for transactional systems.
- Worked with application developers to optimize database structures.
- Supported ETL development by defining source-to-target mappings.
- Maintained enterprise metadata repository.
- Developed entity relationship diagrams (ERDs).
- Conducted impact analysis for database changes.
- Assisted in data migration and modernization projects.
- Built Crystal Reports using sub-reports, formulas, parameters, and stored procedures.
- Developed SQL Server stored procedures and reporting views.
- Developed reports using SSRS.
TAR Analyst - Oracle Corporation - Colorado Springs, CO
(2013-01 - 2014-12)
- Created and troubleshot TARs using Oracle Intranet.
- Resolved customer technical issues using Oracle Web IV and Meta Link.
Technical Support Engineer - Actiontec Electronics - Colorado Springs, CO
(2010-01 - 2013-12)
- Supported Actiontec networking products including routers, gateways, and modems.
- Assisted customers with wireless security, port forwarding, VPN setup, routing, and firewall configuration.
- Provided LAN support for multi-device environments.
- Configured routers, VPNs, Active Directory, and network security components.
