Rey Lawrence Torrecampo Email & Phone Number

Burnaby, British Columbia, Canada

Led the QC Data Migration Initiative: Managed the end-to-end data migration for the Quality-related data and ensuring smooth integration with minimal disruption.Developed an Automated ETL Process: Built a fully automated ETL pipeline using SQL and Python which cuts down manual intervention by 90% and greatly boosting team productivity.Designed an Advanced Data Analysis Tool: Developed a sophisticated SQL-based tool that employs fuzzy logic and weighted averages that helped SMEs gain a clearer understanding of data complexities and improve their strategies.Automated the HR Data Unlinking Process: Optimized the HR data migration by automating the unlinking of records with a Python script. it includes SMTP alerts through Mailgun and led to efficient identification and removal of unnecessary records.

Vancouver, British Columbia, Canada

Quezon City, National Capital Region, Philippines

I instructed a Data Analytics and Business Intelligence course where students applied SQL and Python (particularly Pandas). Through the course, students acquired hands-on experience in conducting drill-down analytics and crafting dashboards.

Pasig, National Capital Region, Philippines

Primary responsibilities involve analyzing, maintaining, and automating reports for first-mile and RTS (return to seller) operations. Played a key role in optimizing routes and networks, enhancing service speed and reliability, reducing costs associated with hub expansions, and automating seller operation tasks. Additionally, collaborated with various stakeholders to create dashboards and monitor performance effectively.

Taguig, National Capital Region, Philippines

I engaged as a Pre-sales Engineer with dbWatch, working remotely from the Philippines. My role encompassed two main responsibilities:1. In the technical capacity, I provided customer support, developed product documentation, and conducted product testing across various database environments such as Oracle, MS SQL Server, MySQL, and Postgres.2. In the non-technical aspect, I focused on customer acquisition and retention, as well as executing multi-channel marketing and sales strategies.

Makati, National Capital Region, Philippines

During the initial six months of employment, I served as an interim project manager, collaborating with stakeholders to plan and strategize the development of a new system. Following this, my role transitioned to Database Administration, where I undertook the following responsibilities:1. Maintenance of both the legacy database (SQL Server) and the new database environment (Postgres).2. Creation of Stored Procedures and Functions for facilitating data migration and replication across both environments.3. Documentation of all ETL scripts, mappings, and definitions.4. Provision of ad-hoc reports for the Project Management team.

Taguig, National Capital Region, Philippines

Engaged in three projects, wherein I crafted and implemented BODS workflows for data migration. Provided ongoing support for data migration BODS jobs, ensuring the successful deployment of all developed workflows to go-live.

Bachelor'S Degree, Business Administration And Management, General

Master'S Degree, Information Systems, 3.79

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

Bachelor Of Science - Bs, Electrical, Electronics And Communications Engineering

Activities and Societies: Ateneo Reserve Officer Training Course (Department of Air Science and Tactics) AECES (Ateneo Electronics.