John Liebnitz Cabaluna

Data Engineer

Responsibilities:
• Develop Python scripts to analyze, clean, and transform data from various sources;
• Process and extract data from APIs, Excel files, external server directories, and databases (MySQL & PostgreSQL);
• Automate and optimize data processing workflows for efficiency;
• Implement data validation, error handling, and logging for data accuracy;
• Develop Python scripts to fetch and process data from APIs;
• Utilize GraphQL to extract relevant data from the Shopify API;
• Work with third-party APIs to gather and enrich business data;
• Ensure secure and optimized API calls with proper authentication and rate-limiting strategies;
• Design, develop, and manage ETL (Extract, Transform, Load) pipelines using Apache Airflow;
• Automate and schedule data workflows for seamless integration;
• Monitor pipeline execution, identify failures, and implement robust recovery mechanisms;
• Optimize data pipeline performance for scalability and reliability;
• Manage MySQL & PostgreSQL databases for efficient data storage and retrieval;
• Write optimized SQL queries and implement indexing, partitioning, and caching strategies;
• Ensure data integrity, consistency, and security across databases;
• Develop database scripts to automate maintenance and reporting tasks;
• Maintain, troubleshoot, and optimize WordPress and Laravel applications;
• Develop custom plugins, scripts, and integrations for WordPress;
• Debug and resolve technical issues related to PHP-based frameworks;
• Utilize Docker to containerize applications and ensure consistency across environments; and
• Use Laravel Homestead for managing local development environments.

Backend Web Developer

Responsibilities:
• Manage the entire application lifecycle, focusing on coding and debugging;
• Integrate user-facing elements developed by a front-end developers with server side logic;
• Build reusable code and libraried for future use;
• Write clean code to develop and improve functionality of web applications;
• Optimize application for maximum speed and scalability including planning and implementing model data structures for scalability;
• Create database schemes that represent and support business process as well as maintenance and improvement of existing data structures;
• Administer data migration, transformation, and scripting;
• Implement automated testing platforms and unit tests;
• Design and Implement data storage solutions;
• Execute user authentication and authorization between multiple systems, servers, and environments;
• Manage hosting environment including database administration and scaling an application to support load changes;
• Setup and administer backups;
• Implement security and data protection;
• Operate cutting-edge technologies to improve legacy applications;
• Gather and address technical and design requirements;
• Provide training and support to internal teams; and
• Liaise with developers, designers and system.

Backend Developer

Responsibilities:
• Develop, maintain, and optimize backend services using Yii2 framework;
• Design and manage efficient MongoDB database structures for performance optimization;
• Implement and maintain RESTful APIs to support frontend and third-party integrations;
• Implement authentication, authorization, and security best practices;
• Debug, troubleshoot, and optimize backend processes for seamless performance;
• Conduct code reviews and enforce clean, maintainable coding standards;
• Collaborate with frontend developers to integrate Yii2 APIs with Next.js;
• Optimize frontend performance and ensure a seamless user experience;
• Troubleshoot and resolve technical issues related to Next.js and API consumption;
• Ensure proper implementation of SSR (Server-Side Rendering) and SEO strategies;
• Maintain and manage Shopify store configurations, themes, and settings;
• Develop and integrate custom Shopify apps and features to enhance functionality;
• Troubleshoot and resolve Shopify-related technical issues;
• Implement and manage webhooks to automate order shipment updates;
• Integrate Shopify API webhooks for real-time tracking of orders and shipment status;
• Work with multiple shipping carrier APIs (e.g., UPS, Canpar, FedEx, DHL, Canada Post) for seamless order fulfillment;
• Ensure proper error handling, logging, and monitoring of webhook events; and
• Optimize webhook performance to ensure real-time and reliable updates.

Information Technology Officer

Responsibilities:
• Perform research and analysis on the front-end and back-end coding and workflow;
• Perform Database Tuning, Backup and recovery;
• Designing and implementing database structures to meet the organization's data storage and retrieval needs;
• Monitoring and optimizing database performance to ensure efficient and fast query execution;
• Identifying and resolving performance bottlenecks through indexing, query optimization, and other tuning strategies;
• Developing and maintaining comprehensive backup and recovery strategies to safeguard against data loss and ensure business continuity;
• Testing and executing recovery procedures to validate the effectiveness of backup systems;
• Ensure documentations on all System Maintained and Databases;
• Managing the migration of data between different systems and databases;
• Integrating databases with other applications and platforms to facilitate seamless data flow;
• Enhance the process workflow and interface of the POPSP-PCMS and POIS;
• Manage, maintain and monitor the database management system of POPSP-PCMS and POIS;
• Develop other related monitoring system, as the need arises;
• Closely monitor all LGU and partner agencies reports submitted through the POPSP-PCMS, POISand other related monitoring systems, and provide monthly, quarterly, semestral and annual summary reports;
• Establish linkages between and among all government and non-government agencies;
• Provide direct technical assistance to the DILG Regional and Field Offices;
• Assist in the implementation and achievement of all Interim NPOC Secretariat programs, projects and activites and other related tasks;

Junior Back-End Web Developer

Responsibilities:
• Maintain & improve a system built by a former developer (WordPress - Divi Builder & Extra Theme)
• Manage Web and Database servers using (AWS EC2, LIGHTSAIL, RDS)
• Manage and Maintain Company existing Sites.
• Administrate Company Accounts.
• Integrate tools and Third-party API's (Google Ads)
• Convert mockup's done by front-end developer into HTML and deploy to WordPress.
• Develop Web application (PHP Framework)
• Manage and Maintain Email Server

Junior Back-End Web Developer

• Maintain & improve a system built by a former developer (WordPress - Divi Builder & Extra Theme)
• Integrate tools and Third-party API's (Google Ads)
• Convert mockup's done by front-end developer into HTML and deploy to WordPress.

Junior Back-End Web Developer

• Maintain & improve a system built by a former developer (WordPress - Divi Builder & Extra Theme)
• Integrate tools and Third-party API's (Google Ads)
• Convert mockup's done by front-end developer into HTML and deploy to WordPress.

Junior Web Developer

Research and Develop School Management System using Mysql as database and Django Framework for existing Web Application that is on PHP / Codeigniter with Javascript, JQuery and Bootstrap 4

Software Engineer

Maintain and Develop web application using PHP frameworks such as Phalcon and Codeigniter. Use Mysql and CouchDb as database. Use Git as versioning tool. Use Linux (ubuntu) environment for development

Web Development Intern

Web Development Intern

Develop Inventory plugin in Craft CMS using PHP programming, HTML, CSS, Vue JS, Javascript and MySQL. QA the existing site. finding and verifying existing site for a 404/Internal Server Errors.

University of Science and Technology of Southern Philippines

• Basic Fundamental of Programming
• PC Hardware and Software
• Complete Course of CCNA 1-4 plus Cybersecurity Essentials
• Web Design, Web and Mobile Application
• Management Information System
• System Analytics and Design
• Operating System
• Computer Interface (IoT)
• Programming (Java, C, C++, Python)