Toronto, Ontario, Canada
Hello there! My name is Jennifer and I am a graduate of the Smith School of Business, at Queen's University. I have always been fascinated by coding and technology, mainly stemming from my love for video games from a young age. My work experiences have allowed me to combine coding and creativity. I work with SQL to build large datasets and then use Tableau to create visualizations that tell a story with the data. I provide these dashboards to various business teams and execs in teams such as Marketing, Operations, Pricing, CRM and Production. I also have experience as an ETL developer due to a rotational program, so I have a good understanding of the end to end data pipeline, from ingestion to reporting. I also believe in continuous learning, so I am constantly developing my skills and trying to learn new things! I am developing my skills in Final Cut Pro, JavaScript, HTML and Photoshop/Illustrator with my hobbies of videography, streaming and keycap design. However, I am also interested in learning photography, UX/UI design and continuing to practice my Mandarin and French. With that in mind, my goal is to pursue a career in something that will allow me to combine my interests of business and technology!
Support A/B tests for live game features, promotions, and events by defining success metrics, building Tableau dashboards and analyzing player behavior to generate insights on player engagement, retention, and monetization; providing recommendations to game teams that inform future experiments and live ops strategy. Support analytics across 10+ live games, partnering with producers, designers, product teams, partner studios, and marketing to deliver both ad hoc analyses and scalable dashboards. Build reports and dashboards analyzing in-game promotions, player segmentation, feature performance, and event outcomes. Develop and maintain Redshift SQL data marts, transforming raw gameplay and transactional data into clean, reliable datasets for reporting and deep-dive analysis. Operate within Agile workflows using JIRA, managing tickets, organizing 2-week sprints, leading stand-ups, and contributing to sprint planning. Collaborated with product leadership, including the Chief Product Officer, to propose new game features and promotional ideas through data-driven one-pagers focused on improving player experience and revenue.
Developed and maintained Tableau dashboards showing player activity and campaign channel metrics, which provided key users with insights into critical metrics Revitalized old dashboards by improving the look and feel in a new standardized dashboard template, to enhance user experience and facilitate more intuitive data interpretation Increased team’s support ticket triage efficiency by analyzing patterns from issues and creating a flowchart to indicate the correct contact team and appropriate resolution path Used Snowflake SQL to investigate data issues in tables across data domains used by CRM, Game Production and Legal teams; ultimately resolving the issues through collaboration with internal team developers and external data source teams Authored comprehensive specifications for new data tables, working with the data source and end-user teams to ensure the accuracy and relevance of the collected data within tables
Affiliate streamer, usually streams 1-2 times per week, playing video games or doing IRL things like cooking, chatting, opening Pokemon cards or building mechanical keyboards! Gained over 260 followers and over 3000 total views for 160+hours streamed from 2020-2022
Use Teradata SQL to build datasets that are visualized in Tableau, to create reporting and dashboards for clients in the Customer Operations, Marketing, Pricing and IT teams Create and send weekly and monthly decks to be used by Director, VP and C-suite executives, detailing metrics like customer base, churn, loyalty rate and WoW/YoY % Used JIRA to manage tasks; completing projects in 2-week sprints following the agile methodology Created and managed a Confluence space to document team’s knowledge; to be used for onboarding and training new hires and educating clients about topics Completed two 8-month work rotations during this time. Analyst - Microstrategy Self Serve: Supporting MicroStrategy self-serve initiatives by coding in Teradata SQL and MicroStrategy Developer to build and maintain ~8 key dashboards, being used by ~100 unique users weekly on MicroStrategy ETL Developer - Data Engineering: Created and modified scripts using Teradata SQL and SAS to extract, transform and load data into a large scale data warehouse, to be used by BI and business teams Coordinated with data users and deployment team members to bring the requested data into the production environment