Andrew P. work email
- Valid
Andrew P. personal email
- Valid
● 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
-
Senior Analytics Engineer (L4)TelusToronto, On, Ca -
Analytics Engineer (L3)Telus Digital Jul 2023 - PresentToronto, Ontario, CanadaTransitioned 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 -
Data Analyst (L3)Telus Digital Oct 2021 - Jul 2023Toronto, Ontario, CanadaIncorporated 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 -
Owner/Portrait And Concert PhotographerIlldefined Photography Jun 2011 - PresentToronto, Ontario, CanadaPart-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
-
Customer Insights Analyst Ii - Customer Experience, Insights & AnalyticsMoneris Jul 2018 - Oct 2021Toronto, Canada AreaPromotion 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 -
Reporting Analyst - Customer Experience, Insights & AnalyticsMoneris Jan 2017 - Jul 2018Toronto, Canada AreaTook 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 -
Technical Support Specialist - Customer ExperienceMoneris Oct 2014 - Dec 2016Toronto, Canada AreaPromotion 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 -
Technical Service Representative - Customer ExperienceMoneris Solutions Sep 2013 - Oct 2014Toronto, 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 -
Produce Service ClerkMetro Inc. May 2007 - Mar 2014Toronto, 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 -
Customer Experience Representative (Cer)Indigo Nov 2012 - Jan 2013Toronto, Canada AreaHoliday 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 -
Customer Experience Representative (Cer)Indigo May 2011 - Aug 2011Toronto, Canada AreaSummer 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
Andrew P. Education Details
-
Bachelor Of Science (B.Sc.) -
The Remix Project -
Michael Power St. Joseph High SchoolHigh 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?
-
Andrew Elnazir, MBA, P.Eng., BASc
Toronto, On -
Andrew Milne, P. Eng
Canada -
Andrew Philip, P.Eng.
Richmond Hill, On -
Andrew Melchers
Brockville, On
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial