Особисті дані приховані

Viktoriia Kapkanets
Surrey, BC, Canada · Remote · Available as a remote contractor
[відкрити контакти](див. вище в блоці «контактна інформація») · [відкрити контакти](див. вище в блоці «контактна інформація») · github.com/Viktoriia-Kapkanets · [відкрити контакти](див. вище в блоці «контактна інформація»)

2026-10-16

Recruitment Team
Allo (allo.ua), CRM Analytics
Ukraine

Dear Recruitment Team,

I'm applying for the remote Data Analyst CRM position. Building the analytics for how customers are acquired,
developed and retained is the area of data work I find most interesting, and my strongest project is about exactly
that.

Customer analytics. In a self-directed project I analysed about 100,000 real marketplace orders in SQL (SQLite
and Google BigQuery). Before any analysis I fixed a customer key that made every buyer look new, then built
cohort retention and RFM segmentation: only 3% of customers ever reordered. I also showed that late delivery
sharply lowers satisfaction, with 83% of on-time orders rated 4 or 5 against 35% of late ones (two-proportion
z-test, p < 0.001). For a CRM team this is the starting point for retention and reactivation decisions.

Power BI and data modeling. I am a Microsoft Certified Power BI Data Analyst (PL-300). For a youth services
nonprofit I designed a star-schema model with fact and dimension tables and a six-page weekly Power BI report
with DAX measures (running totals, week-over-week changes, distinct counts). Before building it I gathered
requirements from the coordinators and documented every metric definition, the same way your role asks to
document metrics and report logic.

SQL, documentation and AI. In another project I joined two government datasets with CTEs and conditional
aggregation, and traced three hidden defects that silently returned zero rows. I use Python, Git and Claude Code
daily to automate routine tasks, and I check every AI output.

To be honest about gaps: I have not yet worked with Azure, Microsoft Fabric, Bloomreach or Jira, and window
functions are something I am still deepening. I live in Canada (Pacific time), so I would like to discuss how my
working hours can overlap with your team's schedule. I am a native Ukrainian speaker and happy to interview in
Ukrainian.

Thank you for your consideration.

Sincerely,
Viktoriia Kapkanets

VIKTORIIA KAPKANETS
Data Analyst CRM - Power BI, SQL, Customer Retention and Segmentation
Surrey, BC, Canada · Remote · Available as a remote contractor
[відкрити контакти](див. вище в блоці «контактна інформація») · [відкрити контакти](див. вище в блоці «контактна інформація») · github.com/Viktoriia-Kapkanets ·
public.tableau.com/app/profile/viktoriia.kapkanets · [відкрити контакти](див. вище в блоці «контактна інформація»)
PROFESSIONAL SUMMARY
Microsoft Certified Power BI Data Analyst (PL-300) focused on customer data: built cohort retention and RFM
segmentation on ~100,000 real marketplace orders and found that only 3% of customers reorder. Designs
star-schema models and DAX measures in Power BI, writes SQL in SQLite and BigQuery, and documents every
metric and report. Gathered requirements and built a weekly Power BI report for a youth nonprofit. Native
Ukrainian speaker.
TECHNICAL SKILLS
• Power BI: PL-300 · DAX (CALCULATE, FILTER, ALLSELECTED, running totals) · Power Query ·
star-schema models (facts and dimensions)
• SQL & data: SQL (CTEs, joins, conditional aggregation) in SQLite & BigQuery · Python (pandas) ·
advanced Excel
• Customer analytics: cohort retention · repeat purchase · RFM segmentation · satisfaction drivers (z-test) ·
Google Analytics (certified)
• Requirements & documentation: business requirements · metric definitions · report logic notes · learning:
Jira · Languages: Ukrainian, Russian (native), English
• AI & automation: Python, Git and Claude Code workflows · AI tools with every output reviewed · learning:
Azure, Fabric
PROJECTS
E-Commerce Customer & Marketing Analytics Mar 2026 - Jun 2026
Self-Directed Project (SQL · BigQuery · Python · Power BI · Tableau)
• Analysed ~100,000 real orders end to end: joined nine source tables into one model in SQLite and
BigQuery (SQL).
• Defined "customer" by a person-level key, not per-order ID, so repeat customers were counted correctly.
• Built cohort retention, RFM segmentation, and a delivery-vs-satisfaction hypothesis test (two-proportion
z-test): on-time orders scored 4+ in 83% of cases vs 35% for late (p < 0.001); only 3% reorder.
• Built interactive Power BI and Tableau dashboards, published live on Tableau Public.
• GitHub: github.com/Viktoriia-Kapkanets/olist-ecommerce-analytics · Live Tableau dashboard
BC Education Funding vs Enrolment Jan 2026 - Mar 2026
Self-Directed Project (Python · SQL/SQLite · Power BI)
• Built an end-to-end data pipeline (ETL) joining two government datasets across 60 BC school districts
(2022/23-2025/26).
• Cleaning & validation: cleaned 137,581 raw rows to 360 district-year records in Python (pandas),
applying one consistent definition so nothing was double-counted.
• Analysed in SQL using CTEs, conditional aggregation, and a multi-source JOIN; debugged three key/type
issues (format mismatch, type promotion, integer division) that were returning zero rows.
• Insight for decision-makers: found funding rose 20.9% vs enrolment 3.2% (r = 0.91) - every district losing
students still gained funding; built a 3-page Power BI dashboard and a README documenting sources and
steps.
• GitHub: github.com/Viktoriia-Kapkanets/BC-education-data-pipeline
PROFESSIONAL EXPERIENCE
Data Analyst (Volunteer / Project-Based) Oct 2025 - Jul 2026
YRES - Youth Services Nonprofit, Canada
• Requirements from the business: asked coordinators what they needed to see and decide, then turned
their answers into KPIs and dashboard layouts before building anything.
• Indicator definitions: agreed with coordinators what counts as a signup and a cancellation by type, so the
same question always returned the same number, and documented the definitions for reuse.

• Performance reporting (Power BI): built a six-page weekly report tracking weekly signups and
cancellations across two regional programs (BC/AB, ON), giving coordinators one weekly view that
previously lived in separate Excel files.
• Data model & DAX: designed a star-schema model and authored DAX measures - Running Total,
week-over-week cancellation breakdowns by canceler type, and DISTINCTCOUNT for engagement
counts.
• Program engagement: analysed 13 months of 1:1 coaching data in Power BI to show engagement trends
over time.
• Access for every staff member: built Tableau and Looker Studio versions for license-free access, with a
written guide.
• Data quality: cleaned, validated and transformed the program's Excel data in Power Query for weekly
reporting.
• Portfolio: github.com/Viktoriia-Kapkanets/YRES-data-analytics-portfolio
Resource Parent (Volunteer Consultant) Feb 2025 - Present
Family Support Institute of BC
• Stakeholder liaison & records: coordinate communication between families, schools, therapists and
support services; organize and track case information and documentation accurately and confidentially.
• Support newcomer families navigating BC's health, disability and funding programs (BC Autism Funding, At
Home Program, Disability Tax Credit, RDSP).
Behaviour Interventionist Apr 2024 - Oct 2024
Private Family - White Rock, BC
• Outcome tracking: collected structured behavioural data across target skill areas in an ABA program;
tracked progress and adjusted approaches based on observed patterns and trends.
• Provided one-on-one, ABA-based intervention support for a child at home, documenting results
consistently.
SEO Content Specialist Sep 2014 - Sep 2015
Freelance / Contract - Ukraine
• Data-driven decisions: analyzed competitor websites and traffic data using SEMrush and Similarweb, and
built the site's semantic core (keyword mapping) to inform content and structure decisions.
• Wrote and edited SEO articles; restructured the site's content architecture (hierarchy, internal linking).
Deputy Editor & Journalist Jan 2011 - Sep 2021
Azovstal Iron & Steel Works (Corporate Media) - Mariupol, Ukraine
• Coordinating across teams: assigned work to journalists and reviewed it for quality across several print
and radio products at once, under fixed deadlines.
• Plain-language communication: interviewed engineers, managers and production staff and turned
technical material into clear articles, press releases and radio segments for diverse audiences.
Senior Lecturer & Department Administrator Sep 2009 - Nov 2010
Mariupol State University - Mariupol, Ukraine
• Records & data management (Excel): kept grade sheets, diploma supplements and state examination
documentation, and built the department's timetable and lecturers' workload, ensuring precise data entry.
• Facilitation & education: lectured in foreign literature, explaining complex topics simply, and served as
academic advisor for a student group; supported the admissions committee, verifying applicant records.
CERTIFICATIONS & EDUCATION
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• A/B Testing & Optimization - completed training
• Google Analytics for Beginners - Google Analytics Academy (valid through May 2027)
• Power Automate Quick Tips - LinkedIn Learning, 2026
• Front-End Basic (HTML, CSS, JavaScript, Node.js) - Hillel IT School, Ukraine, 2019
• Master's Degree in Philology and Computational Linguistics - Mariupol State University, Ukraine (2008)
VOLUNTEER EXPERIENCE
Brochure Designer & Content Creator (Volunteer) May 2024 - Aug 2024
Flourishing Foundation - Vancouver, BC
• End-to-end delivery: research to finished Canva product for a charity supporting newcomer and
Indigenous women.