Andrew P.

Andrew P. Email and Phone Number

Senior Analytics Engineer (L4) @ TELUS
Toronto, ON, CA
Andrew P.'s Location
Greater Toronto Area, Canada, Canada
Andrew P.'s Contact Details

Andrew P. work email

Andrew P. personal email

About Andrew P.

● 7+ years of experience driving business insights through data analysis & analytics engineering in fintech & digital telecom organizations ranging from 500-100,000+ employees, & up to $20B in annual revenue● Increased data model performances by >30% a telecom’s digital analytics department in Canada● Produced an OPEX savings of 3 FTE by developing new ETL workflows for a fintech in Canada● Identified ~$0.5M in annual OPEX savings for the B2B segment of a telecom in Canada● Implemented domain specific denormalized data models increasing query performance, centralizing business intelligence logic & naturalizing the representation of data for a Canadian telecom’s digital analytics department● Award winning portrait & music photographer● 2016 JUNO R&B/Soul Recording of the Year Nominee

Andrew P.'s Current Company Details
TELUS

Telus

View
Senior Analytics Engineer (L4)
Toronto, ON, CA
Website:
telus.com
Employees:
35841
Andrew P. Work Experience Details
  • Telus
    Senior Analytics Engineer (L4)
    Telus
    Toronto, On, Ca
  • Telus Digital
    Analytics Engineer (L3)
    Telus Digital Jul 2023 - Present
    Toronto, Ontario, Canada
    Transitioned to new digital marketing Business Intelligence team post-business reorg. Incorporated Google BigQuery, Google Workflows (Similar to utilizing dbt and Airflow), Github, Pulumi Tableau and Looker Studio to transform raw web analytics data into actionable data models and executive dashboards • Design and implement scalable and secure cloud solutions using GCP cloud technologies, Github, and Tableau Cloud• Utilize GCP REST APIs to create and manage data structures and orchestrate Workflows• Define and implement data management strategies, including data standards, governance and data security measures• Technical lead for team of 5 analytics professionals (L2-L5)• Assess stakeholder requests to determine technical requirements, timelines, and solution design (data pipeline architecture as well as executive dashboard design)• Assess and refactor legacy logic for projects transitioning to the digital marketing Business Intelligence team Achievements• Built & designed efficient 1B+ row data models while producing organization leading data visualization solutions, reducing data processing costs by 15x• Led organization's PoC for Tableau Cloud, including vendor and external stakeholder collaboration to assess and resolve technical issues and roadblocks• Developed & maintained templated analytics frameworks for GCP, Github, & Tableau employed by 15+ digital product analysts (L2-L5) to support workflows & reports accessed by cross-functional stakeholders• Refactored offer personalization query (3700 lines of code) to optimize efficiency, remove legacy logic, and transition query to using a GCP project agnostic approach vs. locked-in approach• Coached & mentored department members on best/common practices through training sessions, code reviews, & 1:1 office hours• Explored strategic opportunities for further team optimization, from both a functional & technical resource perspective
  • Telus Digital
    Data Analyst (L3)
    Telus Digital Oct 2021 - Jul 2023
    Toronto, Ontario, Canada
    Incorporated Google BigQuery, SQL, Hive, Hadoop, Oracle, DOMO, Looker Studio, Adobe Analytics and Alteryx to transform raw web analytics data into actionable data models and dashboards supporting 2 digital product teams• Support the B2B MyTELUS product teams from initial planning to implementation and sustainment• Gather, assess and implement reporting requirements for new and ongoing analytics requests from business stakeholders• Present scorecard tracking KPIs and insights to key leaders and stakeholders where applicableAchievements• Collaborated with product, devs, and UX to launch & report on 20+ project releases across 2 product lines and 7 app and web experiences• Identified the success rate of individual online self-serve activities reducing contact centre calls by merging on-prem call data from an Oracle database with clickstream data stored in BigQuery implementing Ateryrx to serve as the data pipeline• Collaborated with product owners to develop business cases presented to senior leadership to establish team funding and product focus for the upcoming year• Continually reviewed & evolved data models to meet new business requirements, which led to 5% KPI increase through identifying missing business cases• Trained & mentored junior analysts, presenting new methodologies through a diverse analytics stack
  • Illdefined Photography
    Owner/Portrait And Concert Photographer
    Illdefined Photography Jun 2011 - Present
    Toronto, Ontario, Canada
    Part-time portrait and concert photography business in the entertainment industry• Photograph portraits of clients for social media/marketing purposes• Photograph concerts and events for select clientele• Edit photos as per specs using Photoshop• General accounting/invoicing of clients• Catalogue and maintain long term storage of content (10+ TB of data)Achievements• 2016 Juno Nominee (Photographer for DRU - Deja Vu, R&B/Soul Recording of The Year)• Judges Choice Award - 2018 Sound Image Exhibit at the Analogue Gallery in Toronto• In-house local photographer for 21 Entertainment (Alessia Cara, Fefe Dobson, Tyler Shaw)• Produced branding/marketing images for prestigious corporate clients such as Veeps, HP Canada, Toronto Raptors, TD Bank, Toyota Canada, & October's Very Own• Created international marketing content for live music & entertainment streaming platform Veeps, Ali Shaheed Muhammad (A Tribe Called Quest), and Juno award winner DRU• In-house local photographer for 21 Entertainment (Alessia Cara, Fefe Dobson, Tyler Shaw, etc
  • Moneris
    Customer Insights Analyst Ii - Customer Experience, Insights & Analytics
    Moneris Jul 2018 - Oct 2021
    Toronto, Canada Area
    Promotion to role from Reporting Analyst. Incorporated SQL Server, SQL, Tableau, Google Analytics, Microsoft Access and Excel to transition team into an organization leading analytics practice• Gathered requirements from stakeholders to build analytics reports, dashboards and/or adhoc data pulls• Maintain and automate recurring reporting/analytic production for stakeholders• Take on additional analytics projects as required• Mentor junior analystsAchievements• Automated and consolidated 180+ recurring reports through implementing Tableau, stored procedures, and custom SQL functions resulting in 2 FTE costs savings• Developed reporting using Google Analytics and BigQuery for Moneris' online customer self-serve portal, identifying OPEX savings opportunities• Co-developed, with Director of Corporate Data, the baseline training data that trained Moneris’s churn propensity scoring machine learning model, identifying potential churn and reducing customer churn through early intervention• Consulted with an external vendor to ensure new HR platform would be able to automate an existing manual report for submitting contact centre employee schedules to asses payroll implications. Resulting in reducing manual recurring work by 100+ hrs annually• Implemented analytics process using MS SQL Server, Microsoft Access, Python, and Excel for identifying, tracking and upgrading 170k POS devices that required upgrading due to an impending change in encryption standards. Saving potentially millions in fines• Mentored junior analyst through to promotion, training them on SQL and Tableau
  • Moneris
    Reporting Analyst - Customer Experience, Insights & Analytics
    Moneris Jan 2017 - Jul 2018
    Toronto, Canada Area
    Took on role as part of a 1 year secondment, promoted to full-time after 4 months. Incorporated SQL Server, SQL, VBA, shell scripting, Microsoft Access and Excel to develop operational reporting for the Customer Experience teams (Contact Center and back end teams) of Canada’s largest payment processor• Maintain production of recurring reports for Customer Experience, Operations, and Operational Risk teams• Query and analyze data providing insights for stakeholders• Gathered requirements from business stakeholders to complete adhoc analytics requestsAchievements• Manually coded VBA, shell scripting, and front end user interface to automate 6 manual excel reports serving as a proof of concept that led to the team introducing a mandate to automate all recurring reports, initial PoC saved 1.5hrs of manual work daily while reducing risks of manual errors• Maintained 40+ recurring reports and PowerPoint presentations for external stakeholders• Achieved promotion to full-time Reporting Analyst 4 months into a 1 year secondment (April 2017)• Promoted to Customer Insights Analyst II after 15 months promotion to full-time Reporting Analyst
  • Moneris
    Technical Support Specialist - Customer Experience
    Moneris Oct 2014 - Dec 2016
    Toronto, Canada Area
    Promotion to role from Technical Support Specialist• Second and third level POS technical support for stand alone, integrated, e-commerce & mobile app POS products• First level desktop support (Windows) for employees including software configuration, training, & troubleshootingAccomplishments• 1 of 3 Technical Service Specialists cross-trained to provide business operations support as part of an agent cross-training initiative proof of concept• Completed user acceptance testing for new telephony system, an upgrade to a cloud based version of our existing CRM & a custom Microsoft Dynamics CRM• 1of 5 Contact Center agents selected for overnight launch of new telephony system• Offered promotion to L2 Technical Support Specialist after 2 years (Summer 2019), declined promotion to continue to pursue analytics opportunities within the company
  • Moneris Solutions
    Technical Service Representative - Customer Experience
    Moneris Solutions Sep 2013 - Oct 2014
    Toronto, Canada Area
    • First level technical support for stand alone POS products• Quickly resolved complex requests through active listening and exception customer support• Coached colleagues through inquiriesAccomplishments• Stack ranked 3rd amongst Technical Support Representatives across 3 contact centers (~60 people)• Promoted to Technical Support Specialist after 15 months
  • Metro Inc.
    Produce Service Clerk
    Metro Inc. May 2007 - Mar 2014
    Toronto, Canada Area
    - Unload product deliveries and place in appropriate storage area- Extensive knowledge of department procedures ensuring quality, product allocation and customer support- Demonstrates commitment to working in a team environment with a positive approach while coordinating with peers and management
  • Indigo
    Customer Experience Representative (Cer)
    Indigo Nov 2012 - Jan 2013
    Toronto, Canada Area
    Holiday Season Contract (Yonge & Eglinton Location)- Kobo/Electronics- Extensive product and sales knowledge providing excellent customer service, actively resolving customer inquiries- Demonstrated commitment to learning other product areas- Provided cashier help during busy periods at the cash line
  • Indigo
    Customer Experience Representative (Cer)
    Indigo May 2011 - Aug 2011
    Toronto, Canada Area
    Summer Contract (Queensway Location)- Kobo/Electronics- Extensive product and sales knowledge providing excellent customer service, actively resolving customer inquiries- Demonstrated commitment to learning other product areas- Provided cashier help during busy periods at the cash line

Andrew P. Skills

Photography Social Media Photoshop Digital Photography Customer Service Social Networking Illustrator Portrait Photography Editing Software Development User Acceptance Testing Shell Scripting Html Java Programming Sql Capture One Quality Assurance Network Administration Microsoft Office Communication Tenacious Work Ethic Teamwork Time Management Leadership C Visual Basic For Applications Project Management Data Analysis Creative Problem Solving Brand Management Music Digital Media Branding And Identity Db2 Linux Unix C/c++

Andrew P. Education Details

  • York University
    Bachelor Of Science (B.Sc.)
  • The Remix Project
    The Remix Project
  • Michael Power St. Joseph High School
    Michael Power St. Joseph High School
    High School

Frequently Asked Questions about Andrew P.

What company does Andrew P. work for?

Andrew P. works for Telus

What is Andrew P.'s role at the current company?

Andrew P.'s current role is Senior Analytics Engineer (L4).

What is Andrew P.'s email address?

Andrew P.'s email address is an****@****ris.com

What schools did Andrew P. attend?

Andrew P. attended York University, The Remix Project, Michael Power St. Joseph High School.

What skills is Andrew P. known for?

Andrew P. has skills like Photography, Social Media, Photoshop, Digital Photography, Customer Service, Social Networking, Illustrator, Portrait Photography, Editing, Software Development, User Acceptance Testing, Shell Scripting.

Who are Andrew P.'s colleagues?

Andrew P.'s colleagues are Emerson Cho, Justin Mccormack, Jian Mao, John Zhang, Maryrose Pre, Korri Hogg, Janice Bolam.

Not the Andrew P. you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.