Anita Ly

Senior Analytics Engineer

Spearheaded development of a LTV:CAC metric for the subscription business by designing a derived fact model for tracking monthly subscription payments, credit usage and channel spend, which influenced leadership to increase investment in high-performing marketing channels, netting to an average LTV:CAC of 1.29 in the first month.

Enhanced BigQuery observability by implementing Elementary monitors, orchestrating an Airflow DAG for dbt test executions, and setting up Slack channel alerts, delivering near real-time anomaly detection to the data platform team.

Mentored analytics engineering interns quarterly by developing personalized growth plans and coaching them on engineering best practices, resulting in each intern earning transformative impact recognition during their internships.

Senior Analytics Engineer

Gained annual savings of $36k via migrating from Snowflake to BigQuery by redesigning the data warehouse schema, transforming Datastream event data into 300+ dbt models using custom macros and a programmatic Python script.

Championed and designed an abstraction to automate data quality testing in BigQuery using the Datafold hashdiff algorithm, enabling trust and positive feedback in quarterly business reviews amongst data reporting users.

Remodeled Snowflake infrastructure using Terraform, automating the provisioning of warehouse roles, objects and role-based access controls through GitHub Actions, resulting in a streamlined and scalable data platform.

Analytics Engineer

Enabled real-time visibility of customer billing results by scripting metrics using dbt and Snowflake for 3 pricing models, which resulted in better documentation and improved self-service revenue reconciliation beyond month-end.

Enhanced accuracy of monthly customer invoicing by developing a comprehensive telephony usage report using dbt that consolidates and catalogs 4 carrier datasets, resulting in a 95% reduction in reconciliation time.

Streamlined Looker issue resolution from 3 hours to 5 minutes by designing tooling dashboards to assess Looker's performance, and setting up alerts to monitor for failed scheduled jobs and long-running queries.

Manager, Business Intelligence Engineering

Reduced issue detection time from 24 hours to 30 minutes by scheduling Python and SQL based integration tests with 20 edge cases using GitHub Actions to ensure data integrity in a point-of-sales database with over 1.6 billion records.

Built a prototype acronym dictionary using Javascript, Node.js and PostgreSQL to standardize a single source of truth for industry terminology for new-hire onboarding. Received green-light from the leadership team to implement solution globally.

Developed a web data visualization platform using Python, Flask and Azure App Services to connect to consumer panel data in Snowflake for media planning optimization by interviewing teams on problems to solve, developing wireframes to review UX designs, and testing prototype web application with 500+ visits during beta-run.

Established a proof of concept for A/B testing geo-targeted social ads by conducting data discovery sessions with 5 vendors for web/mobile signals while leading brainstorming sessions with digital team to design user stories, receiving an incremental $120k budget for in-year data purchase.

Mentored 10 new hires in data warehouse schemas by creating interactive content and case studies using Articulate 360 (online module development) and supporting learners with office hours to answer questions.

Associate Manager, Business Intelligence

Accelerated ELT time for 40GB data ingestion to 4 hours by implementing dbt transformations, leading agile sprint planning with data engineering, and conducting regular code reviews to drive continuous improvement.

Launched a standardized innovation tracker by creating an efficient reporting layer in Hadoop, defining KPIs across sales, marketing and finance, designing front-end solution in Tableau, and implementing cross-channel training thereby removing siloed reporting.

Served as a corporate trainer for SQL and Snowflake, mentoring data enthusiasts across several functions in the organization by documenting new user guides in Confluence, showcasing examples of view builds and working on live cases with each student.

Senior Analyst, Revenue Management

Saved 5 hours per month by overhauling financial reports via gathering user requirements, consolidating disparate data sources using Spark SQL, mapping UX wireframes, and collaborating with stakeholders to refine the prototype.

Managed the development of a data library across multiple customers by standardizing the product prices and their derivatives, organizing data input from various sources and recommending areas to optimize pricing to maximize profitability.

Corporate Management Trainee, Operations

Mitigated $0.4 million in supply chain risks by correcting material bills for co-manufactured items and standardizing a material change form using workflow analysis to support change management with procurement and co-packers.

Removed 100 hours per month of inefficiency by initiating process of transitioning a copacker from a consignment to a turnkey manufacturing model, allowing for more time allocation to value engineering and continuous improvement activities.

Corporate Management Intern, Marketing

Gained 1 million organic PR impressions from initiating experiential marketing activation for the Kraft Hockeyville winning community featuring Ottawa Senators defenceman Dion Phaneuf, equating to 25% above target.

Sales Analytics & Forecasting Intern

Improved forecast accuracy from 80% to 86% by applying new statistical techniques that assisted senior management forecast demand and organize plant production for following three consecutive months.

Corporate Social Responsibility Co-op

Reduced paper usage by 12% at River Rock Casino by creating user-friendly Salesforce Cloudapps dashboards with pareto analysis of resource use to assist managers in informed decision making in lean operations.

Full Stack Engineer

Initiated the technical architecture for a loan management application which included wireframing front-end, back-end and CI/CD components, drafting the database schema, and engaging with a product designer on application workflow.

Learn More

Content Coordinator

Generated 30 story submissions to share online by planning and executing out-reach initiative to gaming clubs, societies, and small businesses while interviewing industry participants on the positive impacts of gaming.

Learn More

Managing Director

Tripled client leads to 22 in a year by establishing a clear value proposition, rebranding marketing assets to craft a modernized brand, and pitching personalized services to prospects in untapped client verticals with a team of six.

Learn More

Project Director

Diverted 35,000 pounds of UBC’s used cooking oil waste from landfills by raising $23,000 in additional funding used to streamline biodiesel and organic soap production via preliminary feasibility analysis and product demonstrations.

Learn More