Data Engineer
Open To Work
NAPTHALI JULES BRIZO
CITI NA ROHQ
Paranaque,NCR
Work Preference
Desired Job Title
AVP – Software Engineer Senior Data AnalystETL SpecialistStaff ConsultantSoftware Development AnalystSoftware Engineer
Work Type
Full Time
Location Preference
Hybrid
Location:
Paranaque, NCR, PH
Open to relocation:
Yes
Important To Me
Work-life balanceCareer advancementCompany CultureHealthcare benefitsWork from home optionFlexible work hours
1
Certification
14
years of professional experience
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.
Work History
AVP – Software Engineer Senior Data Analyst
4 Years 10 Months- 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
2 Years 3 Months- 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
1 Year 6 Months- 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
3 Years 3 Months- 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
2 Years 3 Months- 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
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 - CurrentRead More
ETL Specialist
HOMECREDIT Philippines
09.2019 - 12.2021Read More
Staff Consultant
ORACLE Philippines
02.2018 - 08.2019Read More
Software Development Analyst
SMART Telecommunications
09.2014 - 12.2017Read More
Software Engineer
CAPGEMINI PHILIPPINES CORP
05.2012 - 08.2014Read More
University of St. LaSalle
Bachelor of Science from Electronics Engineering
Read More