Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Aaron Patrick Tansengco

Aaron Patrick Tansengco

Data Analyst
Manila, Metro Manila

Summary

An inquisitive individual striving for excellence by forever honing skills in order to provide the best.

Always on the look out for a challenge, always asking the "Why" and "How" of it in order to overcome complex problems with complex solutions.

Overview

2
2
years of professional experience
17
17
years of post-secondary education

Work History

Operations Assurance Analyst

GCASH (G-XCHANGE)
9 2023 - Current

Assisting in day-to-day operations and offer additional support to critical functions concerning risk avoidance with the use of SQL via adhoc data pulls.

Lending SQL expertise within the team by assisting in the creation of controls, control rediscovery, and control enhancements via automation.

Weekly, fortnightly and monthly execution of said controls to produce insights to be used by various teams within Gcash to be able to avoid / monitor any unnecessary risk the company is facing.

Fraud Data Analyst

SHOPEE PHILIPPINES
09.2022 - 06.2023

Produced data reports using SQL to produce actionable insights to be able to mitigatate / eliminate fraud altogether.

Not limited to adhoc activities, but to also develop controls / automated reports used by internal teams within shopee to be able to monitor any signs that could indicate fraud via the creation of dashboards to easily visualize data and to easily gain insights at a whim.

Day-to-day function also included assisting in major projects involving anti-fraud initiatives by producing the necessary data in order to identify which critieria can be used to mitigate or stop fraud altogether. Once identified, will be turned into automated blockers or tracker reports to be used by the tactical side of the anti-fraud department.

Education

Bachelor of Science in Information Systems - Business Analytics Track Specialization (SAS)

MAPÚA UNIVERSITY
Makati City
07.2015 - 05.2022

Secondary Education -

Concordia College
Manila City
06.2011 - 05.2015

Primary Education -

Concordia College
Manila City
06.2005 - 05.2011

Skills

Fraud Investigation

Project Management

Proficient in SQL (Presto / Maxcompute Alibabacloud)

Fraud Analysis

Risk Management

Stakeholder Management

Data Analytics

Communication

Google Suite of applications (sheets, slides etc)

Microsoft Excel

Power BI

Negotiation

Basic Python

Storytelling

Accomplishments

DAY TO DAY:


  • Automation of processes using in-house tools that allow such functions or through the use of Python.


  • Daily ADHOC reports through the use of SQL to provide reports to support various functions within the company.


  • Involved in high-level projects with the goal in mind to avoid millions of pesos worth of losses.


  • Identify a cohort of individuals to be able to more accurately predict which bad actors will commit fraud against the company and avoid any unnecessary risk.


  • Identify through specific behaviors , patterns and parameters to create controls / monitoring reports that target weakpoints within the company that may cause unnecessary risk.


  • Ensure that promotions / campaigns being conducted are airtight and will not cause revenue leakages / reputational harm through script review.

Timeline

Fraud Data Analyst

SHOPEE PHILIPPINES
09.2022 - 06.2023

Bachelor of Science in Information Systems - Business Analytics Track Specialization (SAS)

MAPÚA UNIVERSITY
07.2015 - 05.2022

Secondary Education -

Concordia College
06.2011 - 05.2015

Primary Education -

Concordia College
06.2005 - 05.2011

Operations Assurance Analyst

GCASH (G-XCHANGE)
9 2023 - Current
Aaron Patrick TansengcoData Analyst