Prince Nhiel Cada
ETL Developer
Valenzuela City
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
7
7
years of professional experience
9
9
years of post-secondary education
Work History
SR. ETL Developer
Personal Collection Direct Selling Inc. - Head Office
Quezon City
11.2023 - Current
- Solved complex business problems by developing custom ETL strategies tailored to specific needs.
- Evaluated new technologies as potential solutions for enhancing current ETL processes, providing recommendations based on research findings.
- Integrated disparate data sources into a cohesive system for more efficient analysis and decision making.
- Reduced maintenance costs by creating reusable components within ETL pipelines.
- Implemented automation within ETL processes to reduce manual tasks and improve efficiency.
- Conducted thorough testing of developed solutions, ensuring optimal performance upon deployment.
- Developed complex SQL queries for improved data extraction and accurate reporting.
- Tuned systems to boost performance.
Data Engineer
IT Managers Inc - Client (Toyota Motors Philippines Corp.)
09.2021 - 11.2023
- Analyzed and organized raw data
- Developed and maintained datasets
- Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
- Data Migration
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Conducted complex data analysis and reported on results
- Built data systems and pipelines
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
Associate Data Analyst
Taisho Pharmaceuticals (Philippines), Inc.
12.2020 - 08.2021
- Responsible for capturing data, analyzing data, creating quality checks on the data to ensure accuracy
- Monitored big data tables in our BI SQL stack and performed simple data queries
- Identified problems as it relates to quality, quantity, and completeness of data
- Built and maintained reporting using excel.
- Strengthened interdepartmental communication by serving as a liaison between the Data Analytics team and other business units within the organization.
- Ensured compliance with all applicable privacy laws and regulations while handling confidential customer information during analysis projects.
- Enhanced data accuracy by conducting thorough data validation and cleaning processes.
Software Developer
Genie Technologies Inc.
01.2020 - 08.2020
- Modified existing software to correct errors and add new functionality to improve the system (POS)
- Handled projects for Kenny Roger (Migrations of version 6.7 to version 12, Integration of third-party app, GC, B-code, Sodexo and Void Function) and Mary Grace (Fix the Computation for BIR, Add Ceiling Computation).
- Achieved faster development cycles using Agile methodologies, including Scrum processes.
- Optimized application performance by conducting regular code reviews and refactoring when necessary.
Software Programmer
TWA Inc. – Flying V Head Office
04.2018 - 12.2019
- Trained OJT in MS SQL Server and VB.Net Basic Fundamentals
- Created software program, such as VB.Net, writing codes and testing programs to ensure optimal performance and accuracy
- Developed code fixes and enhancements for inclusion in future code releases and patches
- Monitored and updated back-end data by inter-communicating between [VB.Net] and [MS SQL Server]
- Modified existing software to correct errors, adapt to new hardware and improve performance.
Encoder
Estrella Ice Cold and Plant
08.2017 - 01.2018
- Managed documents by organizing forms, making photocopies, filing records, preparing correspondence and creating reports
- Added documents to file records and created new records to support filing needs.
Education
High school -
St. Joseph School of Lawang Bato Valenzuela City
01.2008 - 04.2012
Bachelor of Science: Computer Science - undefined
St. Louis College of Valenzuela
01.2013 - 04.2017
Skills
Performance Tuning
Data Migration
Data Modeling
NoSQL Databases
ETL development
Data Warehousing
SQL Expertise
SQL and Databases
SQL Programming
RDBMS
Python Programming
ETL Modeling
OLAP and OLTP systems
Power BI Expertise
Proficient SSRS reporting
Projects
Point of Sales w/ Barcode Scanner (My Thesis), Can issue Sales Invoice/Receipt
Inventory
Reports
Traps in Inventory Like (Detecting the low stocks and out of stocks)
Can backup and restore Database
Created using VB.net with SQL Database Sales and Inventory Reporting System (SIRS) – Project Created in TWA Inc., Have Server and Client Side
Can generate SQL Data with Text File Format
Can generate reports
Have Inventory
Two GUI for Admin and User
Have 3 mode of payment namely (CASH, PO Accounts, Credit Card)
Created using VB.net with SQL Database
Input daily transaction in User side or I called it Cashier Side
Can Setup and Configure Tank, Pump and Nozzle with Price
Can register PO Clients with Logs
Can correct variance or wrong input
Another module can be explained in personal
Continuous Learning
I want to keep myself occupied by learning as much as I can about the RDBMS, SQL, ETL, and other aspects of my current line of work. This will make myself and the business I work for more dependable and knowledgeable.
Timeline
SR. ETL Developer
Personal Collection Direct Selling Inc. - Head Office
11.2023 - Current
Data Engineer
IT Managers Inc - Client (Toyota Motors Philippines Corp.)
09.2021 - 11.2023
Associate Data Analyst
Taisho Pharmaceuticals (Philippines), Inc.
12.2020 - 08.2021
Software Developer
Genie Technologies Inc.
01.2020 - 08.2020
Software Programmer
TWA Inc. – Flying V Head Office
04.2018 - 12.2019
Encoder
Estrella Ice Cold and Plant
08.2017 - 01.2018
Bachelor of Science: Computer Science - undefined
St. Louis College of Valenzuela
01.2013 - 04.2017
High school -
St. Joseph School of Lawang Bato Valenzuela City
01.2008 - 04.2012