Leif Francisco

About

Data Analyst

Bachelor of Science in Industrial Engineering, Mapua University

Email: leif.francisco@yahoo.com

Phone: (09) 610840232

Hi! I'm a Data Specialist that is currently working with a tech-enabled B2B start-up called Growsari. I have previously worked for a Fortune 500 Financial Technology (FinTech) company called Global Payments.

Skills

Excel

Knowledge of VLOOKUP, pivot tables, basic VBAs.

SQL

Basic SQL functions such as SELECT, FROM, WHERE, GROUPBY, COUNT, etc.

Microsoft Power BI

Dashboard for Portfolio Analytics and Aircon Analysis.

Statistics

Proficiency in Minitab and Excel. Knowledge of common statistical tests.

Python

Backtest Cryptocurrency trading strategy using MV and SF model.

HTML and CSS

Basic Web Design knowledge.

Resume

Education

Bachelor of Science in Industrial Engineering

2018 - 2022

Mapua University

Mapua Badminton Men's Team Captain (2021-2022)
Mapua Badminton Men's Athlete (2018-2022)
4th Year Batch Representative - Philippine Institute of Industrial Engineers (PIIE) Mapua Student Chapter (2021-2022)
Member - Honor Society of Mapua (HSM) Batch 139 (2020-2022)
External Vice President - Productions and Operations Management Association of the Philippines (PROMAP) Mapua Chapter (2020-2021)
Half Academic Scholar (3rd and 4th Quarter AY:20-21)

Publication/s

Automated Online Job Finder using MS Access

2020

Used the database management features of MS access and applied it to a job finder system to match company preferences.

Professional Experience

Data Specialist

April 2023 - Present

Growsari

Assist with data-driven decisions by generating SQL queries (PostgreSQL) to retrieve, manage, and manipulate the data from our database as needed by internal stakeholders.
Manage metrics and KPIs by building and handling reports and dashboards using Redash and Looker Studio.

Data Analyst

August 2022 - April 2023

Global Payments Inc.

Utilize basic Extract, Transform, Load (ETL) process using Google Sheets to transform raw extracted data from Verint, Talkdesk, AVAYA and Nice Incontact and load it to dashboards, scorecards and reports.
Manage automation of daily end-of-day (EOD) reports using Google Apps Script or JavaScript.
Manage monthly Performance Analytics dashboards and scorecards from established KPIs/metrics.
Perform SQL queries to retrieve, manage, and manipulate the data from the database as needed.
Perform data-related ad hoc tasks.

Operations Intern

April - June 2022

Manila Ocean Park

Managed stock requests using Electronic Hotel Operations and Reservation System (E-HORS).
Applied Excel Automation for reports using VLOOKUP function and pivot tables.
Proposed and presented revised systems for Job Order Forms, Personnel Request Forms and Stock Request Forms.
Proposed and implemented waste management projects.

Data Visualization Volunteer

June 2022

East Baltimore Research Project

Generated a Power BI Dashboard that summarizes the activities of the employees in the organization.

Data Analyst Volunteer

June 2022 - Present

Model Earth

Used R programming to retrieve import and export data from UN comtrade API.
Extensive data cleaning of global import and export data according to specified format.
Used Github to update the model.earth website at https://github.com/modelearth/country-data.