Consultant

Ashish Lakhmani

Senior Data Analyst & BI Engineer

Transforming complex data into executive-ready insights with Looker (GCP) and Power BI. 8+ years building enterprise dashboards, semantic data models, and AI-powered analytics pipelines.

Looker & LookML Power BI & DAX BigQuery & SQL Python ETL Statistical Analysis
View Live Demos Get in Touch
8+Years Experience
50+Dashboards Built
3Industries
About Me

Data Storyteller. BI Architect. GCP Enthusiast.

I'm a Senior Data Analyst currently working in agriculture technology, where I architect scalable LookML semantic models and self-service analytics platforms on Google Cloud Platform. Previously, I delivered Power BI intelligence solutions in the insurance and fintech sectors.

I hold a Master's in Computer Science (GPA 3.9, University of Manitoba) and a Master's in Quantitative Finance (GPA 3.92, University of Utah) — a unique combination that lets me speak the language of both engineering and business.

Beyond analytics, I've taught Power BI, SQL, and Data Analytics at the University of Manitoba and Robertson College, helping hundreds of professionals upskill in data.

M.S. Computer Science University of Manitoba • GPA 3.90
M.S. Quantitative Finance University of Utah • GPA 3.92
80%Looker / GCP
85%Power BI / DAX
90%SQL / BigQuery
Technical Stack

End-to-End BI & Analytics Expertise

Looker & GCP

  • LookML semantic modeling
  • BigQuery optimization
  • Looker Studio dashboards
  • AI/ML model integration
  • GCP IAM & access admin

Power BI

  • DAX measures & calculated tables
  • Power Query / M language
  • Row-Level Security (RLS)
  • Executive & operational reports
  • Live ML model dashboards

Data Engineering

  • Complex SQL & stored procedures
  • ETL pipeline development
  • Data quality & governance
  • Python automation scripts
  • AWS data services

Analytics & Strategy

  • Descriptive & diagnostic analytics
  • Executive stakeholder reporting
  • Statistical methods
  • Credit risk analysis
  • AI agent development

Statistical Analysis

  • Hypothesis testing & A/B tests
  • Regression & predictive modelling
  • Time series & forecasting
  • Churn & survival analysis
  • Quantitative finance methods
Career

Professional Experience

Sr. Data Analyst

Major Hog Meat Production Company • Manitoba, Canada
Jan 2025 – Present
  • Architecting scalable LookML semantic models and Looker explores for enterprise BI on GCP — reducing report development time by 60%.
  • Built AI Agents for self-service data models, enabling non-technical users to query petabyte-scale datasets autonomously.
  • Designed and enforced data quality & governance frameworks across feed and plant operations; administers GCP IAM and Looker access controls.
  • Engineered complex SQL pipelines for high-performance data transformation, supporting strategic decisions across the supply chain.
LookerLookMLBigQueryGCPSQL

Data Analyst (Contract)

Major Insurance Company • Winnipeg, MB
Aug 2024 – Jan 2025
  • Built interactive Power BI dashboards analysing customer demographics, tenure, and churn — directly informing Customer Experience strategy.
  • Developed a live ML model performance & usage dashboard in Power BI, giving stakeholders real-time visibility into model health.
  • Uncovered fraudulent address misrepresentation through investigative SQL analysis, saving hundreds of thousands in improper claims.
Power BIDAXSQLMachine Learning

Data Analytics Instructor

University of Manitoba & Robertson College • Winnipeg, MB
Jan 2024 – Oct 2024
  • Taught Power BI, SQL, Excel, Data Visualization, and Statistical Methods to 200+ students and working professionals.
Power BISQLExcelData Viz

Senior Data Analyst

Fintech Company • Boise, USA
Nov 2019 – Apr 2023
  • Delivered Power BI executive dashboards for product usage and gap analysis to C-suite stakeholders at a leading $4B fintech.
  • Engineered Python/SQL ETL pipelines, cutting data processing time by 40% and ensuring regulatory compliance.
  • Built a Python automation module that reduced manual report error-resolution workload by 70%.
Power BIPythonSQLETLJava

Data Analyst – Credit Risk

Global Financial Company • Salt Lake City, USA
May 2019 – Nov 2019
  • Assessed and monitored credit risk on institutional deals; automated Hedge Fund AUM extraction with VBA, SQL, and Python.
PythonSQLVBACredit Risk

SQL Developer

Tech Company • India
May 2015 – Apr 2017
  • Designed and optimized complex SQL queries and stored procedures to support business reporting and data pipeline workflows.
  • Collaborated with business stakeholders to translate requirements into data models and reporting solutions.
  • Maintained and improved database performance through indexing strategies and query tuning.
SQLT-SQLStored ProceduresData Modelling
Live Demos

Interactive Dashboard Showcases

Click to explore full interactive demos simulating real enterprise BI environments.

Sales Overview Operations
$4.2MTotal Revenue+18%
12,847Orders+9%
$326Avg Order-3%
Google Cloud Looker

Enterprise Sales Analytics

LookML-driven explore with real-time BigQuery data: revenue trends, order performance, regional breakdowns, and drill-through capabilities.

LookML semantic layer BigQuery backend Cross-filter drill-through Scheduled data delivery
Open Looker Demo
Customer Analytics Churn Model
98,240Customers+12%
6.4%Churn Rate-2%
4.7Avg Tenure (yr)+0.3
Microsoft Power BI

Customer Intelligence Dashboard

Insurance-grade customer analytics: demographic segmentation, churn prediction model monitoring, tenure analysis, and executive KPI scorecards with DAX measures.

Advanced DAX measures Row-Level Security ML model monitoring Slicer & cross-filter
Open Power BI Demo
Contact

Let's Build Something Great

Available for consulting and project-based engagements.

LocationWinnipeg, MB, Canada
Google ScholarResearch Profile
Looker / LookML Consulting Power BI Development GCP Data Architecture BI Training & Workshops Dashboard Audits & Optimization Data Modelling & Governance Statistical Analysis & Modelling