Summary
Overview
Work History
Education
Skills
Accomplishments
Software
Certification
Character Reference
Timeline
Generic

Jeffrey Arambulo

BI Developer
B7 L18 Santorini Estates,Calumpang, Binangonan

Summary

Skilled BI Developer with more than 10 years of industry experience in collecting, organizing, interpreting, and disseminating various types of statistical figures. Creative in finding solutions to problems and determining modifications for optimal use of organizational data. Expert at providing realistic projections and establishing various scenarios to determine viable process strategies to utilize. Organized and timely in providing management with reports on specific data findings and their impact on organizational growth and success.

Overview

17
17
years of professional experience
8
8
years of post-secondary education
4
4
Certifications

Work History

Data Analyst/BI Developer

Firstmac
07.2024 - 03.2025
  • Develop Datamart using Python scripting and Terraform deployment on AWS
  • Write and configure Terraform plan for Glue Jobs (AWS)
  • Monitor the workflow on AWS if the orchestration from terraform plan configure correctly
  • Develop SQL queries based on HUDI framework (with hash_key and hash_diff) for insert and update
  • Maintain the develop PowerBI report

BI Developer

RCG Information Technology
02.2022 - 03.2024
  • Monitor Azure Data Factory pipelines, Snowflake Task and PowerBI workspace
  • Monitor tickets on ServiceNow assigned to our group
  • Develop and maintain PowerBI/Paginated reports
  • Create tables and views on Snowflake

Reporting Senior Analyst

Teletech Customer Care Management Philippines Inc
06.2019 - 02.2022
  • Build centralized SSAS model that can be use by other department or clients for reporting.
  • Build PowerBI Dashboard and SSRS Report for executive and clients.
  • Build Machine Learning Algorithm for detection of Attrition
  • Create Code Change Task for Architech Review and Checkin to TFS Server.

Software Engineer(MS BI Developer)

Sykes Asia Inc
08.2018 - 06.2019
  • Building ETL procress using microsoft flow, python, vba macro, sharepoint and etc
  • Automate aggregation and archiving csv file using Python as daily, monthly or yearly batch execution.
  • Build PowerBI Dashboard to analyze agent data and make a recommendations.
  • Build a web app for agent inquiry and complaints using MVC Framework.
  • Manage Azure VM to schedule task that needs daily pulling of data from Azure Datawarehouse.

Data Quality Analyst

MeteoGroup Philippines Inc
07.2014 - 08.2018
  • Weather data quality assurance and monitor weather condition on Europe and Asia
  • Collecting data from satellite images, radar, remote sensors and weather stations all over the world
  • Gathering of data from database using web application query and excel tool
  • Applying physical and mathematical relationships and sophisticated computer models to make short and long range weather forecasts
  • Create dashboard for performance of weather stations
  • Enter weather station data info to database and update list
  • Make a ticket for maintenance of station by our colleagues in Europe Area

Weather Data Quality Analyst

MeteoMedia Philippines Inc
05.2012 - 07.2014
  • Corrects wrong weather measurements with realistic values
  • Fill in realistic weather data when measurements are missing
  • Perform mathematical operations for weather data

Meteorologist Assistant

SGS Gulf LTD-ROHQ
11.2011 - 05.2012
  • Monitor weather condition here in Philippines and Europe
  • Check output of forecast model if accurate and compare to actual weather condition

Junior Underwriter

AsianLife General Insurance
02.2011 - 11.2011
  • Perform risk manage base on their mortality rate
  • Review previous contract for consolidation of benefits
  • Prepare Master Policy

Part Time Math Teacher

Kumon
04.2008 - 03.2010

Education

Bachelor of Science - Mathematics

Polytechnic University of The Philippines
06.2006 - 05.2010

High School Diploma -

Janosa National High School
06.2002 - 05.2006

Skills

Dashboard Reporting

SSIS, SSAS, SSRS

SQL, Oracle SQL, Big Query

C#, Python, VBA

API Integration

Hadoop

Accomplishments

Business Intelligence Development

Procurement Report Project

  • Requirements gathering, Dev Stage, UAT, Prod

Fixed Assets Project

  • Requirements gathering, Dev Stage, UAT, Prod

NHTP Alert Project

  • Requirements gathering, Dev Stage, UAT, Prod
  • Build Machine Learning Algorithm using Python

Text Analytics Project

Convert PowerBI python script to DAX and SSAS Model


Upwork

Financial Statement Project

  • Directly reporting to CEO and Owner
  • Requirements gathering, Dev Stage,UAT, Prod

Power Query Consulting Work, DAX calculations, Tabular Model

Software

Power BI

Visual Studio, VS Code

SQL Management Studio

AWS, ADF, Synapse Analytics,Data Lake, Microsoft Flow, Key Vault

Tabular Editor

Ask Now, Jira, Confluence, Azure DevOps

TFS, Git

Certification

Udemy Statistics for Business Analytics A-Z

Character Reference

Michael Magsino - Technical Lead API

AXA Shared Services

0917-626-4629


Amie Canales- TL Software Release

Titanium Technologies

0917-890-7236


Norman Aloba

System Admin

0926-752-7610

Timeline

Data Analyst/BI Developer

Firstmac
07.2024 - 03.2025

Microsoft Certified: PowerBI Data Analyst Associate

02-2023

BI Developer

RCG Information Technology
02.2022 - 03.2024

Reporting Senior Analyst

Teletech Customer Care Management Philippines Inc
06.2019 - 02.2022

Software Engineer(MS BI Developer)

Sykes Asia Inc
08.2018 - 06.2019

Mastering SQL Server 2016 Integration Services (SSIS)

06-2018

Udemy Statistics for Business Analytics A-Z

12-2017

Udemy Machine Learning A-Z: Hands-On Python & R in Data Science Online Course

11-2017

Data Quality Analyst

MeteoGroup Philippines Inc
07.2014 - 08.2018

Weather Data Quality Analyst

MeteoMedia Philippines Inc
05.2012 - 07.2014

Meteorologist Assistant

SGS Gulf LTD-ROHQ
11.2011 - 05.2012

Junior Underwriter

AsianLife General Insurance
02.2011 - 11.2011

Part Time Math Teacher

Kumon
04.2008 - 03.2010

Bachelor of Science - Mathematics

Polytechnic University of The Philippines
06.2006 - 05.2010

High School Diploma -

Janosa National High School
06.2002 - 05.2006

Similar Profiles

CREATE PROFILE
Jeffrey ArambuloBI Developer