Experience

UnionBank of the Philippines

• Philippines
• Banking
• 700 & Above Employee

• Master Data Management Lead

  • Apr 2020 - Present



SM Retail

• Philippines
• Retail
• 700 & Above Employee

• IT Specialist/Supervisor 3

  • Jul 2018 - Apr 2020

  • Part of Business Intelligence Department that handles the Data Warehouse and develop reports an dashboards using Vertica DB, ARC BI and Tableau • Administration and maintenance of Tableau Server • Design and develop reports and dashboards using Tableau • Supports Tableau Server upgrade and designed Tableau data source rationalization • Develop batch scripts for Tableau Housekeeping and Refresh operationalization • Develop and extract ad hoc or operational KPI Reports upon users’ request • Develop ETL using SQL, Shell Scripting and ARC BI Tools for Data Integration and Aggregation • Lead a team of specialists in ETL, Reports and Dashboard developments. Show less



Smart Communications, Inc.

• Philippines
• Telecommunications
• 700 & Above Employee

• Senior Software Engineer

  • Aug 2015 - Jul 2018

  • Part of Business Intelligence Department that develops data visualizations and operational reports using Oracle, OBIEE, Power BI and Tableau • Develops reports and dashboards using Oracle BI Enterprise(OBIEE) and Tableau • Develops data extracts for Power BI Visualizations • Supports Reports Migration from OBIEE to Microsoft SSRS • Develops Oracle Packages and Procedures for Report Extractions • Develops ETL jobs using Oracle and Unix Shell Scripting for Data Integration and Aggregation • Optimization of SQL for better performance • Develops Control Framework to ensure data integrity in ETL • Develops and models DataMart’s that consolidates and correlates data into the data warehouse for the purpose of analyses and reporting. Show less



Software Laboratories Incorporated

• Software Development
• 1 - 100 Employee

• Oracle PL/SQL Consultant

  • Aug 2012 - Aug 2015

  • Develops reports/report cubes using Shell Script, Oracle SQL, PL/SQL, PROCEDURE, FUNCTION, PACKAGE and OBIEE Reporting tool to be used by proponents for their business analysis, sales strategy and decision making. • Develops ETL jobs for Aggregating/Transforming raw data into aggregated and simplified information and provides better extraction performance. • Production Support/Monitoring: Monitors deployed script and procedures for possible user issues, bugs, delays and performance issues • Script Migration(Oracle 10g to Oracle 11g) • SDLC: Coordination with Clients, Business Analysts and Project Managers to gather requirements and provide development timeline for the project. Debugging and creation of test scenarios with Test Analysts until the program meets the requirements. Deploy the program to production and provides production support/maintenance. Show less