Summary
Overview
Work History
Education
Skills
Languages
personal information
hobbies and interests
Timeline
Generic

Jaime Lorenzo B. Prats

Balwyn North,VIC

Summary

Talented Analyst and Team Leader with a penchant for problem-solving and delivering valuable, data-driven insights to improve operational processes. Demonstrates strong communication and analytical skills and the ability to build healthy work cultures and relationships in diverse and dynamic business environments. Hardworking team player bringing necessary experience and knowledge to tackle any operational demand.

Overview

5
5
years of professional experience

Work History

ANALYTICS AND REPORTING TEAM LEAD

UBER
03.2023 - 09.2023
  • Managed a team of analysts and ensured they could deliver consistently on tasks, alongside providing stakeholders with deep-dive analyses, insights, and data solutions.
  • Worked closely together with stakeholders from multiple operating units in order to address their data concerns and issues.
  • In charge of overall data for Australia and New Zealand and showcasing them in Weekly and Monthly Business Reviews and providing insights.
  • Improved team productivity by implementing efficient project management strategies and streamlining communication channels.
  • Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.

SENIOR ANALYST, BUSINESS INTELLIGENCE (BUSINESS TECHNOLOGIES)

SHOPEE
09.2021 - 03.2023
  • Worked on both data gathering and visualization tools, as well as many quality-of-life solutions for Shopee as a whole; including, but not limited to data-scraping, inventory tools, and data forecasting.
  • Set up scraping automations for multiple competitor sites with Python.
  • Helped create email send-out tools to ease disseminating information from teams to 3rd party services (such as logistics companies), or to sellers themselves.
  • Managed, maintained, set-up, and constantly updated MySQL databases used in numerous Business Technologies Projects and Portals.
  • Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.

SENIOR ANALYST, BUSINESS INTELLIGENCE (R&A)

SHOPEE
07.2020 - 09.2021
  • Managed data needs and handle reports for key parts of Shopee's business infrastructure including Shopee Xpress and ShopeePay.
  • Devised Rider Productivity reports as well as Rider Incentive trackers for both general Rider activity and bonus incentives from participating in project pilots.
  • Improved company efficiency with the development of key performance indicators and tracking metrics for pioneer projects for ShopeePay such as rider P2P wallet top-ups and COD QR Payments.

DATA ANALYST

UBER
08.2019 - 06.2020
  • Leveraged SQL queries and Python scripts to pull and form data used to generate valuable business insights
  • Performed analysis of data regarding the efficiency of Uber's Greenlight concept, which was used to help push for the transition to a virtual Greenlight amid the current pandemic
  • Devised a script for summarizing daily ticket dumps which was successfully implemented.
  • Streamlined data processing and automation for faster results by implementing more robust queries and back-end systems.

MANAGEMENT TRAINEE

BANK OF THE PHILIPPINES ISLANDS (BPI)
12.2018 - 04.2019
  • Part of the bank's officership training program, to be assigned to the newly set-up Data Science team after completion
  • Learned storytelling and utilized data visualization of data sets together with other data analysts to present about client transaction patterns and banking fee conditions
  • Participated in group consultations and individual learning to gain banking industry knowledge.

COSTING OFFICER

AIRSPEED PHILIPPINES INC.
09.2018 - 11.2018
  • Identified and optimized the costs of different types of services

Education

Bachelor of Science - Applied Mathematics W/ Specialization in Finance

ATENEO DE MANILA UNIVERSITY
01.2018

Skills

  • SQL
  • Python
  • Agile Methodologies
  • JIRA
  • Matlab
  • Scilab
  • R Fundamentals
  • WSL/Linux/Ubuntu
  • Data Visualization
  • Google Cloud Platform
  • Firebase
  • MS Office
  • Performance Monitoring
  • Production Monitoring
  • Process improvement
  • Stakeholder Management

Languages

English
Native or Bilingual
Filipino
Native or Bilingual

personal information

Date of Birth: 03/22/95

hobbies and interests

  • Mathematics
  • Programming
  • Film
  • Sports
  • Music
  • Video and Card Games

Timeline

ANALYTICS AND REPORTING TEAM LEAD

UBER
03.2023 - 09.2023

SENIOR ANALYST, BUSINESS INTELLIGENCE (BUSINESS TECHNOLOGIES)

SHOPEE
09.2021 - 03.2023

SENIOR ANALYST, BUSINESS INTELLIGENCE (R&A)

SHOPEE
07.2020 - 09.2021

DATA ANALYST

UBER
08.2019 - 06.2020

MANAGEMENT TRAINEE

BANK OF THE PHILIPPINES ISLANDS (BPI)
12.2018 - 04.2019

COSTING OFFICER

AIRSPEED PHILIPPINES INC.
09.2018 - 11.2018

Bachelor of Science - Applied Mathematics W/ Specialization in Finance

ATENEO DE MANILA UNIVERSITY
Jaime Lorenzo B. Prats