Andrew P. Email & Phone Number

Toronto, ON, CA

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.
• 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)

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.

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

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

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.
• 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.
• Maintained 40+ recurring reports and PowerPoint presentations for external stakeholders

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

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

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

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

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

Bachelor Of Science (B.Sc.)

Education record

High School