Desired Job Title
AVP – Software Engineer Senior Data AnalystETL SpecialistStaff ConsultantSoftware Development AnalystSoftware EngineerWork Type
Full TimeLocation Preference
HybridLocation: Paranaque, NCR, PH
Open to relocation: Yes
Open To Work
NAPTHALI JULES BRIZO
Data Engineer
Paranaque,NCR
Work Preference
Summary
Results-driven Data Engineer and ETL Specialist with over 10 years of expertise in Oracle Database and Unix environments, and specialized experience in Pentaho and Oracle Data Integrator (ODI). Proven track record of designing robust data integration pipelines, automating complex backend processes, and supporting microservices architectures in the highly regulated financial and telecommunications industries. Seasoned programmer with a strong foundation in backend development, CI/CD deployment, and system automation.
Overview
1
1
Certification
14
14
years of professional experience
Work History
AVP – Software Engineer Senior Data Analyst
CITI NA ROHQ
01.2022 - Current
- Analyze, create and/or enhance Oracle packages, procedures and database objects to cater new business requirements, changed business processes and efficiency on the execution.
- Automated a manual GRID (recompiling user’s configuration after a patch deployment) process for REALM application using UNIX Shell scripting
- Engineered a custom PL/SQL and Unix shell scripting automation, integrating a file copy process of two partner applications through Oracle database and NAS mediums
- Developed a resilient Oracle DB package to automatically capture records that failed during historical backup for GDPR purpose during intermittent database server disconnections.
- Established a UNIX Shell Job that will capture REALM application project files that are 4 years or older from main NAS location and transfer them into an archive NAS to ensure application doesn’t face any storage issues.
- Prepare and build deployment pipelines for vendor application which is a BAU process, handling application bugs, data errors and production issues.
- Perform database production change request to handle bulk data uploads and data integrity fix though implementing update, delete and insert SQL scripts into production.
ETL Specialist
HOMECREDIT Philippines
09.2019 - 12.2021
- Architected and deployed Pentaho jobs and transformations using Spoon IDE to support Loan Origination microservices, managing critical data streams for point of sales, cross-selling, and paperless transactions.
- Implemented CI/CD pipelines using GIT for robust version control and automated deployment of ETL jobs.
- Engineered a custom PL/SQL and Unix shell scripting automation framework for Pentaho job execution, validating and evaluating requests via a reference table to eliminate manual server connections.
- Developed a Python and shell script solution to scrape job statuses and automatically update Confluence, drastically improving the service desk’s ability to assign issue tickets to the correct ETL teams.
- Built a resilient Job Execution Queue script to automatically capture and requeue failed jobs during intermittent database server disconnections.
Staff Consultant
ORACLE Philippines
02.2018 - 08.2019
- Spearheaded data migration efforts from Systematics to the Oracle FLEXCUBE core banking system for the MetroBank Data Integration project.
- Designed and optimized complex PL/SQL packages, functions, and ODI mappings to process critical bank loan, biller, and ledger data.
- Facilitated the generation and processing of input and handoff files between FLEXCUBE and EBS GL.
- Authored comprehensive functional specifications and conducted rigorous unit and volume testing to ensure data integrity.
Software Development Analyst
SMART Telecommunications
09.2014 - 12.2017
- Modernized a critical month-end billing program (Retail Threshold Reset) by reconstructing PL/SQL packages and C scripts, implementing a multi-stream processing approach to handle large-scale account volumes efficiently.
- Automated the 4-step permanent service disconnection process (Project Auto Write Off) using PL/SQL, TOAD, and SQL Loader for direct production updates.
- Developed automated UNIX shell FTP scripts to push and pull daily reports for canceled credit card payments (Project Mercury), streamlining partner system integrations.
- Provided Tier-3 operational support, resolving production data bugs, analyzing account conditions, and aiding customer relations with rapid incident resolution.
Software Engineer
CAPGEMINI PHILIPPINES CORP
05.2012 - 08.2014
- Developed the 'SkillPortal' J2EE application utilizing Struts 2 (MVC) and Hibernate (ORM) to manage data persistence and business logic.
- Built dynamic front-end interfaces using HTML, CSS, JavaScript, and JQuery to couple servlet requests and responses.
- Deployed application modules to JBoss servers via Maven, utilizing WinSCP and PuTTY.
Education
Bachelor of Science - Electronics Engineering
University of St. LaSalle
Bacolod01-2011
Skills
- Integration & ETL: Pentaho (Spoon), Oracle Data Integrator (ODI Studio), SQL Loader
- Databases: Oracle, MySQL
- Programming & Scripting: PL/SQL, Python, Unix Shell Scripting, Java (J2EE, Spring), C, JavaScript, HTML/CSS
- DevOps & Tools: GIT (CI/CD), Jenkins, Lightspeed, RLM, SVN, Maven, SQLDeveloper, TOAD, VSCode
Certification
Certified OCA Java SE 7 Programmer
Timeline
AVP – Software Engineer Senior Data Analyst
CITI NA ROHQ
01.2022 - Current
ETL Specialist
HOMECREDIT Philippines
09.2019 - 12.2021
Staff Consultant
ORACLE Philippines
02.2018 - 08.2019
Software Development Analyst
SMART Telecommunications
09.2014 - 12.2017
Software Engineer
CAPGEMINI PHILIPPINES CORP
05.2012 - 08.2014
Bachelor of Science - Electronics Engineering
University of St. LaSalle