Data Professional

REY LAWRENCE
TORRECAMPO

Find what you are looking for?

Professional Summary

I am an IT and Data Professional with more than 5 years of experience. In my professional career, I handled both technical and non-technical roles.​

For my IT-specific roles, my strengths lie in software and system development, data analytics, and database administration. Python, and SQL are my primary programming languages. While, my preferred tools for data analytics are Spreadsheets (especially Excel) and Transactional SQL. Likewise for Data Visualization, I am adept in utilizing data studio (looker), tableau and Power BI.

With my extensive background and experience in handling various relational database platforms such as Presto, MySQL, Postgres, and MS SQL Server, I can confidently write scripts (DQL, DML, DDL and DCL), stored procedures, and functions in their native query language. More importantly, I have a good background in data migration efforts and ETL projects where I successfully delivered on those fronts.

For my non-IT roles, I conducted webinars, wrote e-books, and drafted both technical handouts, and blogs about our product - a database monitoring and management solution. In addition, my experience as a Project Manager and Pre-Sales helped me communicate and collaborate with different stakeholders and clients.

Work Experience

BUSINESS INTELLIGENCE
August 2022 - June 2023

Shopee, Inc (Shopee Express)
Pasig City, Philippines
Logistics

Main role is to analyze, maintain and automate reports for first mile and RTS (return to seller) operations. Contributed to route and network optimization, improvements in service speed and reliability, cost-saving in hub expansions and automated seller operation tasks. Collaborate with different stake holders for dashboard creation and performance monitoring.

PART TIME LECTURER
August 2022 - June 2023

Ateneo De Manila University
Quezon City, Philippines
Education

Taught a course in Data Analytics and Business Intelligence where students utilize SQL and Python (specifically Pandas). Students were able to develop practical skills in drill down analytics and dashboard creation.

DBA PRODUCT SPECIALIST
June 2020 - July 2022

Eastvantage, Inc.
Taguig City, Philippines
Outsourcing

Outsourced to dbWatch as a Pre-sales Engineering remotely working in the Philippines. Two main responsibilities: 1) Technical role involves providing customer support, product documentation, and product testing in different database environments which includes Oracle, MS SQL Server, MySQL and Postgres. 2) Non-technical role involves customer acquisition and retention, and multi-channel marketing and sales.

DATABASE ADMINISTRATOR
February 2019 - May 2020

Medilink Network, Inc.
Makati City, Philippines
Healthcare

Acted as an interim project manager in first 6 months of employment. Responsible for planning and strategizing with stakeholders in the development of a new system. After 6 months of tenure, moved to Database Administration with the following responsibilities: 1) Maintained both the legacy database (SQL Server) and the new database environment (Postgres). 2) Develop Stored Procedures and Functions for data migration and replication for both environments. 3) Document all ETL scripts, mappings and dictions. 4) Provide ad-hoc and reports for Project Management team.

Involved in 3 Projects. Developed and deployed BODS Workflows for Data Migration. Supported Data Migration BODS Jobs. All developed workflows reached go-live.

ASSOCIATE SOFTWARE ENGINEER
March 2017 - January 2020

Accenture, Inc.
Taguig City, Philippines
Outsourcing

Education

Business Administration
July 2023 - Present

Acsenda School of Management
Vancouver, Canada
Bachelor's Degree

Currently taking Management Courses in a Canadian College with a concentration on Management Information Systems

Information Systems
August 2020 - December 2022

University of the Philippines Open University
Laguna, Philippines
Master's Degree

Professional Degree in Information Systems. Capstone Project: Asset Management for Database Management Systems.

Data Analyst Pathway
February 2019 - October 2021

Development Academy of the Philippines (SPARTA)
Pasig City, Philippines
Professional Certification

Under project SPARTA and a pioneer graduate with a Professional Certification for Data Analytics

Professional Regulatory Commission
Manila, Philippines
Professional License

Licensed Electronics Engineer
October 2016

Passed the Electronics Engineer licensure exam and authorized to practice engineering in the field of Electronics and Telecommunications

Electronics & Communication Engineering
June 2011 - June 2016

Ateneo De Manila University
Quezon City Philippines
Bachelor's Degree

Graduated with a University degree in Electronics Engineering, specializing in Telecommunications. Undergrad Thesis - Quality of Service and Quality of Experience: Measurements for Mobile Internet Users.

BADGES

Download Resume