Froilan Sia
Design
Hong Kong
Skills
Data Engineering
About
Froilan Ong Sia's skills align with System Developers and Analysts (Information and Communication Technology). Froilan also has skills associated with Programmers (Information and Communication Technology). Froilan Ong Sia has 20 years of work experience, with 10 years of management experience, including a low-level position.
View more
Work Experience
Sr Consultant - Solution Architect
Explora
May 2022 - June 2023
- He is part of the management technical team who is responsible for improving the organization's technical standard by influencing technologies, strategies and decisions with high level of expertise and knowledge. Role and Responsibilities: * Participate in Presales, system/architectural design, create POC to help client and team members understand the feasibility and impact of the solution design. * Conduct architectural evaluation, analysis and design and implement solution based on the client requirement. * Provide direction and support to ensure compliance with specification and standards * Lead team of staff developing products and address training needs when necessary. * Act as key contact within project teams who have technical issues. * Lead the AWS R&D initiative within Explora
Data Engineer
Acquia
January 2018 - December 2022
- As data engineer, he is responsible for creating and maintaining data pipeline that is used to unify retail customer data from multiple sources, equip cross-functional teams with machine learning insights, equip marketers build more effective segments and optimize the timing and targeting of campaigns across variety of customer touchpoints. Role and responsibilities as Data Engineer * Design and enhance data structure and strategy to use in ETL process * Write Java ETL code to create single source of truth for analysis and personalization campaigns while cleansing data and eliminating duplicate or inaccurate records. * Create and enhance Hadoop UDF using java * Create unit testing code * Performance tuning of existing Spark SQL, Java code * Work with internal team to assist with data-related technical issues and support their data needs. * Troubleshoot P1 issues related to performance and data quality. * Work with Platform operations with issues related to Cloudera Data Platform * Convert Existing Spark SQL into Snowflake PREVIOUS WORK EXPERIENCE
Big Data Consultant at HPE
Hadoop
January 2013 - December 2017
- Trainer * Build training materials for Hadoop architecture, Hive, Pig, Flume, Logsearch, HBase * Mentor for those who will be taking Hortonworks Certified Hadoop Developer * Conduct training once every quarter Oracle Trainer * Build training materials for Oracle SQL and Oracle Administration * Train trainers for Oracle Administration I and Oracle Administration II * Mentor for those who wants to get certified in Oracle SQL, OCA and OCP
Oracle Database Administrator team leader
DXC (HP/ HPE)
February 2010 - December 2017
- ensuring that the team is able to meet the technical, functional design and database performance requirements of the business. Since 2010, his role has evolved into various roles as team leader, problem manager, technical lead, to Big Data Consultant and gained solid experienced as data engineer in the aspect of Data Integration, Data Migration, Data Architecture and Data Warehousing.
Technical Support
Vertica
December 2016 - December 2017
Vertica
October 2016 - December 2017
- (01-Oct 2016 - Dec 2017) * Vertica Troubleshooting (during escalation of projects handled by other team) * Vertica Pre-deployment support for HPE Client in Australia (29-Jun 2015 - 03-Jul 2015) L2 Support For Vertica and Spotfire (16-Nov-2015 - 2017) * Spotfire user administration and maintenance * Administer IIS and SSL certificate * Process ETL Scripts for Vertica * Monthly reporting of Vertica database usage Teradata Offloading Support for HPE team handling Austrian Government * Help research on best practices and approaches to issues encountered by the project team * Provide Teradata and Hadoop VMs for testing * Collaborate with A&DM team in Warsaw on how to implement Kerberos security for Cloudera Ops Analytics Project (Feb 2014 - Dec 2015) * Create ETL using Talend to copy SM9 data from Oracle to Vertica * Create code to move QuickBase Data to Vertica * Analyze existing SSIS code for Data Mapping * Create scripts to load Lync Voice data from MSSQL to Vertica * Administer Spotfire for Prod and Development * Develop Spotfire Report
Database Administrator
HPE
June 2015 - June 2015
- * Netezza Offloading to Vertica Pursuit for Telco Industry in Philippines (01-Jun 2015 - 31-Jun 2015) * DB2 offloading to Hadoop and Vertica pursuit for a Banking Industry in Malaysia (June 2015) * Operation Analytics POC using SM9 data of an HPE account, Spotfire and Vertica (01-Jul 2013 - 31-Jan-2013) * Migrate Oracle database to Vertica Pursuit for Biggest Retailer in Philippines (Feb 2013) Role and responsibilities as Database Administrator at HPE
Tester for Data Migration Project
June 2014 - February 2015
- * Test the compatibility of existing scripts after * Migrating existing platform to cloud * Migrating Database from Oracle 10g to 11g * Migrating new version of COBOL * Trouble shoot loading scripts and coordinate with the team handling Cobol on which modules needed to be recompiled. * Provide expertise on migration issues pertaining to Oracle Pursuit * Help the sales team to win new account by providing technical expertise on Big data and help create Proof of Concepts when necessary. Big Data technologies include Hadoop, Vertica, Spotfire, Tableau and HPE private cloud (HAVEN). These pursuits are usually done on top of the current task. * Sample pursuits are as follows: * Operation Analytics POC using Tableau and Service Desk data for an HPE account (24-Oct to 30-Nov 2016) * Teradata Offloading to Hadoop Pursuit for Telco industry in Canada (01-Sept to 07-Oct 2016) * Advance Analytics Proposal for Banking Industry in Malaysia (15-Aug 2016 to 26-Aug 2016) * SAP Hana Offloading to Hadoop Pursuit for Telco Industry in Philippines (07-Mar - 31-Mar 2016)
Technical Lead
January 2011 - June 2013
- * Understand and influence technical design * Acts as communication proxy for the team * Responsible for technical skills improvement of the team * Acts as technical mentor
4th level support
December 2011 - May 2012
- * Review Incident Related Ticket * Find root cause and recommend fix as needed
Team Lead
February 2010 - November 2011
- care of team schedule * Help ensure proper resources during the shift * Improve team technical capabilities thru coaching and introducing best practice approach * Ensure that each team members follow the ITIL approach, comply with corporate and client policy
Oracle Database Administrator
September 2008 - November 2009
- 24/7 International 15-Sept-2008 -30-Nov-2009 24/7 International is an outsourcing company bringing in people and talents to companies to manage services and I.T infrastructure. Froilan was assigned to a pharmaceutical company as Oracle Database Administrator and the same time Team Lead for a group of .Net Developers building and maintaining Reimbursement system. Database Administrator and Team for .Net developers * Take care of team schedule * First level support for production database * Second level support for in-house system * Monitor database performance * Database Model designer * Resolve technical/ functional issues with project sponsors and developers * Manage development activities * Review and enhance stored procedures and poorly performing SQL statements * Debug applications as the need arise * QA test application as the need arise
IT consultant
Sysgen Philippines
February 2007 - March 2008
- for Unisys Philippines Development Lead * In charge of code review as needed * Coordinate testing activities of various government agencies as needed. * Conduct system review * Coordinate technical issues with suppliers as issues arises. * Create prototype and sample program for System integration with Philippine Customs Tariff system System Administrator * In charge of the maintenance of operating system (Linux) * Installation and administration of Oracle Database * Installation and Administration of third-party software as needed by the development team Technical Support for internal clients * Develop prototype as needed * Develop simple program to support internal needs
Java Technical lead
Leverage System Technologies
August 2004 - December 2006
- * In charge of technical design, Architecture decisions, application design, and function implementation * Conducted technical research on productivity tools/ software as needed with the purpose of increasing the productivity level of the development team * Mentored and guided Systems Analysts and Developers as needed Java Developer * Co-developed web-based Electronic Time-In System (eTime) using Java Servlet, JSP, Crystal Report 10, Apache-Tomcat and MySQL Technical Support * Configure/troubleshoot database server (Oracle 8i/9i), web server (Oracle 9iAS, Apache, Tomcat) of internal and external clients as necessary * Assisted the Business Development Team in formulating technical proposal * Developed proof of Concepts as required
System Architect
Ioptisys
February 2006 - June 2006
Visual Basic Developer
NEC Mobile LTD
November 2000 - March 2001
Visual Basic Developer
Asia United Bank
June 1999 - July 2000
- * Created draft of internet/intranet Security Policy * Evaluated and Recommend firewall solution * Migrated BSP GL system data to Computron General Ledger System * Customize, Administer and Maintain Computron General Ledger System * Conducted Training of General Ledger System for internal users. * Composed database migration script for CASA system.
Education
