Learn Data Skills
Beta
Michael Lara

Michael Lara

Senior Data Scientist

BC Public Service

Technologies

My Portfolio Highlights

My New Track

Python Fundamentals

My New Course

Introduction to Python

My New Track

Python Fundamentals

Data virtuoso, orchestrating symphonies of information.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

course

Introduction to R

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to Power BI
Introduction to R
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

BC Public Service | May 2022 - Present

Senior Business Intelligence Analyst

N/A

BC Public Service | Nov 2021 - Present

Business Data Analyst

N/A

TELUS | Apr 2017 - Sep 2021

Market Intelligence Manager

- Led the Market Model program: TELUS’ competitive intelligence tracker and forecast in the wireline division. During my time in the role, I modernized the program: moving it from Excel to Google Sheets, automating processes and reducing the time to update files from 3 days to 5 minutes. - Summarized and reported internally on competitor’s financial and business results, synthesizing data in order to make detailed estimates relating to their internal operations. For example, I sent out a quarterly email summarizing the results of TELUS’ main competitor that was filled with insights and research not found anywhere else in the company. - Led a project to create reporting on product intensity. Set up the reporting and data requirements from the ground up, worked with a variety of other teams to ensure data accuracy. Summarized complex data sets and forecasted future performance and then reported monthly on progress to leadership. - Automated business processes & marketing projects using JavaScript and Google Apps Script. For example, I built a program that automatically downloaded data from the Statistics Canada website, saved it on Google Drive and updated my dashboards. - Conducted research on various marketing related strategic areas, evaluated company performance and presented findings to a wide variety of audiences. For example, I did a market sizing of the company’s performance within different multicultural groups, age groups, and in rural areas that helped the company achieve significant market share gains. - Significantly expanded the scope of research conducted, all while creating interactive dashboards on websites to make KPIs and estimates easy to read to a wide variety of internal customers. - Analyzed data (for example from surveys) using statistical methods and sound research principles to identify actionable insights that helped inform strategic decisions across the business.
Show More

Doublet SA | May 2014 - Dec 2014

Strategic Marketing Assistant

-Analyzed company sales using graphs, pivot tables, advanced excel formulas, and statistical methods to find trends and identify key customers, products and services. -Conducted further research on each client, product or service identified using: national statistical databases, industry publications, and other business databases (such as Euromonitor). -Set up customer profiles based on key characteristics -Prepared detailed powerpoint presentations summarizing findings, then presented these to top management, including the company CEO. -Created strategies for targeting key customers and increasing sales of products and services. -Improved the company’s website by brainstorming possible modifications, researching the effect of these changes on the website user experience and user habits, and communicating changes to an external web development company for implementation.

Brasseries Kronenbourg | Jun 2012 - Jun 2013

Assistant Customer Marketing

•Developed point of sale displays from concept stage all the way to their delivery in bars and restaurants. Some examples: placemats, street boards, serving trays, flying banners, table covers, parasols, textiles, sunglasses, plastic cups, writing slates, and beer coasters. •Researched market trends and competing brands (Heineken, Leffe) in order to create new and effective promotions, POSDs, kits for salespeople, and special events. •Collaborated closely with the marketing department, the sales force, the legal department and external suppliers in France and China in order to execute customer-marketing strategy. •Created a beer menu development program for the sales force from the ground up, which remunerated points of sale for using the company’s logos in their menus. •Designed promo kits used by bars, cafe’s and restaurants during more than 15 special events in France (including 24h du mans, the Armada de Rouen, the Braderie de Lille, Printemps de Bourges, Garorock, Nancy Jazz Pulsations, etc). •Prepared detailed excel reports summarizing POSD inventory, stock, consumption and projected trends for future periods.

Service Canada | May 2009 - Aug 2009

Youth Service Officer

• Presented effectively to high school students in groups of up to 100 on job search skills, labour standards and work safety. • Supervised media relations for the centre and acted as official media spokesman. • Co-ordinated the purchase of advertising for the centre by negotiating with media companies. • Designed and constructed a large parade float with a tropical theme for the Capital Ex parade that was seen by over 200,000 people.

My Education

Take a look at my formal education

Diploma in Accounting, AccountingMcMaster University | 2016
Master in Management, Business Administration and Management, GeneralEDHEC Business School | 2015
Bachelor of Arts (BA), PsychologyThe University of British Columbia | 2010

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free