OKOtto Kats
@ottokats
Data analyst and BI developer delivering actionable Power BI insights.
CanadaWhat I'm looking for
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
Work history, roles, and key accomplishments
Senior Performance & Data Analyst
City of Vancouver
Mar 2023 - Dec 2025 (2 years 9 months)
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.
KPManaged 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.
Business Intelligence Analyst
AXA Group Operations
Jan 2016 - May 2020 (4 years 4 months)
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%.
Test Coordinator / Business Analyst
Insurance Technology Solutions
Sep 2014 - Dec 2015 (1 year 3 months)
Coordinated testing activities and performed business analysis to support insurance technology projects, improving QA processes and requirements clarity across teams.
ACPerformed business analysis for technology projects, translating stakeholder requirements into functional specifications and supporting solution delivery.
SOExecuted functional testing and defect tracking for software projects, contributing to quality assurance and release readiness.
Education
Degrees, certifications, and relevant coursework
UBUniversity of British Columbia Sauder School of Business
Certificate, Behavioural Insights
2025 - 2025
Completed the Behavioural Insights: Fundamentals certificate through UBC Sauder in 2025.
LCLangara College
Post-Degree Diploma, Data Analytics
Completed a Post-Degree Diploma in Data Analytics at Langara College in Vancouver in Fall 2022.
UDUdemy
Coursework, Data Science
2021 - 2021
Completed professional development coursework in Data Science (Statistics, AI & Machine Learning) on Udemy in 2021.
JUJohns Hopkins University
Certificate, Data Science
2019 - 2019
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
Completed a Bachelor of Computer Systems Engineering at ITSPR in Poza Rica, Mexico.
Tech stack
Software and tools used professionally
Availability
Location
CanadaAuthorized to work in
Job categories
Interested in hiring Otto?
You can contact Otto and 90k+ other talented remote workers on Himalayas.
Message OttoFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
