Azhar Rauf

Experienced Data Modeler with over 10 years of expertise in conceptual, logical, and physical data modeling, dimensional modeling, metadata management, data governance, data profiling, and source-to-target mapping across enterprise data warehouse environments. Skilled in ERWIN, ER/Studio, Visio, SQL Server, Oracle, MySQL, Databricks, and cloud data architecture.

Experience in translating complex business requirements into scalable conceptual, logical, and physical data models. Strong background in data quality, ETL validation, data migration, canonical modeling, and data integration for financial, telecom, healthcare, and higher-education systems.

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.

Master of Science - Software Engineering - Colorado Technical University (2008-12)