Data Analyst · Power BI Developer · Ontario

Turning operational data into trusted business decisions.

I combine SQL Server, dimensional modeling, DAX, and Power BI with firsthand manufacturing and data-operations context to build reporting that is clear, validated, and useful.

Actively seeking Data Analyst, BI Analyst, Reporting Analyst, and Power BI opportunities
Released · Service validatedNovaTrade v1.0.0
NovaTrade Power BI Executive Overview with sales, orders, units, distributor reach, trends, and regional performance
SQL Server → Star Schema → Power BI ServiceOpen case study
1.35M+validated fact records
81documented DAX measures
5decision-focused report pages
12 / 12validators passed

One project, shown with enough depth to prove the work.

NovaTrade is a synthetic, independently built portfolio case study. It demonstrates technical delivery and analytical thinking without being presented as employer work.

Released · Service validated

NovaTrade Sales & Inventory Analytics

A multi-branch distribution business needs one trusted view of sales, products, distributors, ownership, and inventory movement.

I built the analytical path from generated operational files through SQL Server staging, normalized OLTP, a dimensional warehouse, and a governed Power BI semantic model.

Source filesSQL ServerStar schemaDAX + RLSPower BI Service
  • Business: executive, sales, product, inventory, and management decisions
  • Engineering: PBIP/TMDL, dynamic branch-level RLS, 12 automated validators, and CI
  • Evidence: public repository, release package, Service deployment, synthetic-persona RLS proof, and case-study site
NovaTrade Management Insights report showing performance exceptions and management actions
Management Insights · one of five released report pages

Technical training, grounded in real operations.

My profile is built honestly: project work proves my BI capability; employment experience gives me practical business context.

I know the difference between understanding a business process and claiming analytics work that was never performed.

My manufacturing roles exposed me to production flow, target-versus- actual output, defects, rework, bottlenecks, inventory movement, and quality checkpoints. My data education and NovaTrade work show how I translate that context into models, measures, and decision-ready reporting.

I am now targeting Canadian Data Analyst, BI Analyst, Reporting Analyst, and Power BI Developer roles where reliability and clear communication matter as much as visual polish.

A practical Business Intelligence toolkit.

Core strengths in SQL Server and Power BI, supported by business analysis and reliable delivery practices demonstrated through NovaTrade.

01

SQL & Data Systems

Designing reliable structures from operational data.

  • T-SQL and SQL Server
  • Staging and OLTP design
  • Star-schema modeling
  • Views and analytical queries
  • Data quality validation
02

Power BI & DAX

Building governed models and usable reporting experiences.

  • Power Query and data shaping
  • Relationships and filter context
  • DAX measures and time intelligence
  • KPI and report design
  • Navigation and accessibility
03

Business Analysis

Connecting data work to the decision behind it.

  • KPI definition
  • Requirements translation
  • Operational reporting
  • Trend and variance analysis
  • Insight communication
04

Delivery & Governance

Making analytical work secure, testable, and ready to share.

  • PBIP and TMDL source structure
  • Dynamic row-level security
  • Git and GitHub workflows
  • Documentation and release checks
  • CI validation fundamentals

Looking for a Data & BI professional who understands operations?

I am based in Ontario, authorized to work in Canada, and open to onsite, hybrid, and remote-friendly opportunities.