# Otto Kats

Otto Kats is a remote worker on Himalayas, Senior Performance & Data Analyst at City of Vancouver, based in Canada.

Source: https://himalayas.app/@ottokats

```text
Data analyst and BI developer delivering actionable Power BI insights.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Canada |
| Authorized to work in | Canada |
| Job categories | Data Analyst, Data Analyst, Business Analyst |
| Skills | Power BI, Power Query, DAX, Dataflow, Excel, SQL, Python, Pandas, Power Automate, Data Modeling, ETL, Alteryx, Ideas, Tableau, VBA, Genexus, Alteryx Designer |

## What I'm looking for

```text
I seek a role where I can lead BI initiatives, build scalable Power BI solutions, automate reporting workflows, and partner with stakeholders to deliver clear, operational insights.
```

## About

```text
I am a Data Analyst and Business Intelligence Developer with over 10 years of experience delivering analytics and dashboard solutions across consulting, insurance, and the public sector.

I specialize in Power BI (Service, Dataflows, DAX, Power Query/M), Excel, SQL, and Python (Pandas), and I build reusable KPI models that automate reporting workflows and translate stakeholder needs into decision-ready insights.

My background includes end-to-end dashboard delivery, multi-source financial modelling, and automating reporting processes with Power Automate to reduce reporting cycles from weeks to same-day delivery.

I bring a service-oriented approach shaped by prior business analysis and QA experience, with a focus on requirements clarity, data quality, governance, and strong stakeholder partnership.
```

## Experience

### Senior Performance & Data Analyst

City of Vancouver. Mar 2023 - Dec 2025

```text
Delivered end-to-end Power BI dashboards for 100+ users, built a multi-source cost-based financial model that reduced manual reporting from weeks to days, and automated reporting workflows to achieve same-day refresh and distribution.
```

Skills: Power-BI, DAX, Power-Automate, Data-Modeling, SQL, Report-Automation

### Senior Data Analyst

[KPMG](https://himalayas.app/companies/kpmg-india). May 2020 - Aug 2021

```text
Managed ETL and analytics for ~120 clients per year from ERP sources (Oracle, SAP), created and optimized SQL procedures and consolidated multi-source reports, and contributed to an internal analytics application used by ~150 staff.
```

Skills: ETL, SQL, Alteryx, Data-Consolidation, Genexus, Reporting

### Business Intelligence Analyst

AXA Group Operations. Jan 2016 - May 2020

```text
Built Power BI and Excel-based dashboards to track operational KPIs, modeled multi-department data to inform capacity and cost insights, and delivered a Tableau/SharePoint prototype that reduced technical request response times by 60%.
```

Skills: Power-BI, Power-Query, Tableau, Data-Modeling, KPI-Design, Reporting-Server, Capacity-Planning

### Test Coordinator / Business Analyst

Insurance Technology Solutions. Sep 2014 - Dec 2015

```text
Coordinated testing activities and performed business analysis to support insurance technology projects, improving QA processes and requirements clarity across teams.
```

Skills: Business-Analysis, QA, Requirements-Gathering

### Business Analyst

[Accenture](https://himalayas.app/companies/accenture). Aug 2012 - Sep 2014

```text
Performed business analysis for technology projects, translating stakeholder requirements into functional specifications and supporting solution delivery.
```

Skills: Business-Analysis, Requirements-Gathering, Process-Mapping, Stakeholder-Management, Functional-Specifications

### Functional Tester

[Softtek](https://himalayas.app/companies/softtek). May 2011 - May 2012

```text
Executed functional testing and defect tracking for software projects, contributing to quality assurance and release readiness.
```

Skills: Functional-Testing, Test-Execution, Test-Cases, Quality-Assurance

## Education

### University of British Columbia Sauder School of Business

Certificate, Behavioural Insights. 2025 - 2025

```text
Completed the Behavioural Insights: Fundamentals certificate through UBC Sauder in 2025.
```

### Langara College

Post-Degree Diploma, Data Analytics

```text
Completed a Post-Degree Diploma in Data Analytics at Langara College in Vancouver in Fall 2022.
```

### Udemy

Coursework, Data Science. 2021 - 2021

```text
Completed professional development coursework in Data Science (Statistics, AI & Machine Learning) on Udemy in 2021.
```

### Johns Hopkins University

Certificate, Data Science. 2019 - 2019

```text
Completed the online course "A Crash Course in Data Science" (certificate A4FLYSS5H2BC) in 2019.
```

### Instituto Tecnológico Superior de Poza Rica (ITSPR)

Bachelor of Engineering, Computer Systems Engineering

```text
Completed a Bachelor of Computer Systems Engineering at ITSPR in Poza Rica, Mexico.
```

## Tech stack

- Pandas
- Gmail
- SQL
- Alteryx Designer
- Jan

To contact Otto, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Phaneendra User](https://himalayas.app/@phaneendrauser): Sr. Data Analyst/Power BI Developer, Canada Life
- [Adunoluwa Olutola](https://himalayas.app/@adunoluwaolutola): Data & Reporting Analyst, Agio Inc.
- [Adunoluwa Olutola](https://himalayas.app/@adunoluwaolutola1): Data & Reporting Analyst, Agio Inc.
- [Adarsh Shailesh Gupta](https://himalayas.app/@adarsh_gupta): Business Intelligence Analyst, Ornge
- [John Martin Ajay Kumar Sama](https://himalayas.app/@johnmartinajaykumars): Sr. Data Analyst, Manulife
- [Charles Okereke](https://himalayas.app/@charlesokereke): Business / Data Analyst, Land Works Resources
- [Abinaya Kalaiarasan](https://himalayas.app/@abinayakalaiarasan): Data Analyst, Huron Perth Healthcare Alliance
- [Rimple Dabas](https://himalayas.app/@rimpledabas): Business Intelligence Analyst, Western Union
- [Vaibhav Verma](https://himalayas.app/@vaibhavverma5): Business Data Analyst, Manulife
- [Ashik Kulanjaraveliyil Shajimon](https://himalayas.app/@ashikkulanjaraveliyi): Senior Business Analyst, DXC Technology