Oscar Lee

Data Architect at Pacific Basin Shipping Limited
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Harris Park, AU
Languages
  • English -
  • Mandarin -
  • Cantonese Native or bilingual proficiency
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • AI for Everyone
    Coursera
    May, 2020
    - Nov, 2024
  • Introduction to Big Data (2015)
    Coursera
    Oct, 2015
    - Nov, 2024
  • Piwik Certified Professional - Digital Analytics
    Piwik
    Mar, 2018
    - Nov, 2024
  • SAS 4 Days Technical Training
    SAS
    Aug, 2011
    - Nov, 2024
  • Oracle Performance Analyzer Release 4.5
    Oracle
    Sep, 2009
    - Nov, 2024
  • Certificate of Completion - Automate the Boring Stuff with Python Programming Course
    Udemy
  • Certificate of Completion - The Ultimate Excel Programmer Course
    Udemy

Experience

  • Pacific Basin Shipping Limited
    • Hong Kong
    • Maritime Transportation
    • 100 - 200 Employee
    • Data Architect
      • Apr 2018 - Jun 2022

      Duties: • Design and implement the big data analytic platform – Automatic Identification System (AIS) analytic system. • The AIS analytic system collects vessel position data through data provider’s API every 15 mins, processes and analyzes over 20,000 vessels globally for their speed, oil consuming, ballast laden condition, cargo information. Provide analytic dashboard and self-service visualization to over 100 active business users in 12 company regional offices: Hong Kong, London… Show more Duties: • Design and implement the big data analytic platform – Automatic Identification System (AIS) analytic system. • The AIS analytic system collects vessel position data through data provider’s API every 15 mins, processes and analyzes over 20,000 vessels globally for their speed, oil consuming, ballast laden condition, cargo information. Provide analytic dashboard and self-service visualization to over 100 active business users in 12 company regional offices: Hong Kong, London, Vancouver, Santiago, Stamford, Rio De Janeiro, Durban, Melbourne, Auckland, Tokyo, Manila and Dalian. • Design architecture for near real time data analytic workflow included data cleansing rules, ETL logic, data mart and data pipeline logic design. • Design architecture and develop Business Intelligence (BI) system and vessel detail data store. • Manage internal development resources and external vendors on multiple project implementation. Projects / Tasks Completed: • AIS analytic system. A near real time analytic system on position, speed destination analysis on over 20,000 vessels globally. • Business intelligence system which provided dashboard and visuals for vessel performance optimization. • Vessel detail data store for global vessels with their performance and latest cargo information. Major Achievements: • The AIS analytic system became a daily work tool of Chartering, Operation and Technical teams for their job. Over 70 weekly active users on average along with the 12 global offices. • Over 80% of business users rate the highest score on the AIS analytic system as a helpful tool to their work in a company internal survey. • Successfully assisted the Chartering team and Technical team on business decision making related vessel chartering, insurance claims, with the use of AIS platform for data analytic. • Successfully assisted the operation team to improve vessel operation efficiency, with the development of BI dashboard to closely monitor vessel condition. Show less Duties: • Design and implement the big data analytic platform – Automatic Identification System (AIS) analytic system. • The AIS analytic system collects vessel position data through data provider’s API every 15 mins, processes and analyzes over 20,000 vessels globally for their speed, oil consuming, ballast laden condition, cargo information. Provide analytic dashboard and self-service visualization to over 100 active business users in 12 company regional offices: Hong Kong, London… Show more Duties: • Design and implement the big data analytic platform – Automatic Identification System (AIS) analytic system. • The AIS analytic system collects vessel position data through data provider’s API every 15 mins, processes and analyzes over 20,000 vessels globally for their speed, oil consuming, ballast laden condition, cargo information. Provide analytic dashboard and self-service visualization to over 100 active business users in 12 company regional offices: Hong Kong, London, Vancouver, Santiago, Stamford, Rio De Janeiro, Durban, Melbourne, Auckland, Tokyo, Manila and Dalian. • Design architecture for near real time data analytic workflow included data cleansing rules, ETL logic, data mart and data pipeline logic design. • Design architecture and develop Business Intelligence (BI) system and vessel detail data store. • Manage internal development resources and external vendors on multiple project implementation. Projects / Tasks Completed: • AIS analytic system. A near real time analytic system on position, speed destination analysis on over 20,000 vessels globally. • Business intelligence system which provided dashboard and visuals for vessel performance optimization. • Vessel detail data store for global vessels with their performance and latest cargo information. Major Achievements: • The AIS analytic system became a daily work tool of Chartering, Operation and Technical teams for their job. Over 70 weekly active users on average along with the 12 global offices. • Over 80% of business users rate the highest score on the AIS analytic system as a helpful tool to their work in a company internal survey. • Successfully assisted the Chartering team and Technical team on business decision making related vessel chartering, insurance claims, with the use of AIS platform for data analytic. • Successfully assisted the operation team to improve vessel operation efficiency, with the development of BI dashboard to closely monitor vessel condition. Show less

  • Viu
    • Hong Kong
    • Entertainment Providers
    • 300 - 400 Employee
    • Data Architect
      • Mar 2016 - Jan 2018

      Duties: • Design and implement VIU mobile app analytic platform on AWS cloud. Daily collect, process and analyze 50 million app user behavior messages which generated from the mobile devices from the 700k daily active users. Launched regions: Hong Kong, Singapore, Philippines and Thailand. • Weekly meeting with 4 region’s business and management team to collect data analytic requests and requirements. • Design architecture for big data analytic workflow included data cleansing rules… Show more Duties: • Design and implement VIU mobile app analytic platform on AWS cloud. Daily collect, process and analyze 50 million app user behavior messages which generated from the mobile devices from the 700k daily active users. Launched regions: Hong Kong, Singapore, Philippines and Thailand. • Weekly meeting with 4 region’s business and management team to collect data analytic requests and requirements. • Design architecture for big data analytic workflow included data cleansing rules, ETL logic, data lake and data pipeline logic design and • Design architecture for Business Intelligence (BI) and reporting system. • Manage internal development resources and external vendors on various project implementations. • Co-work with business analysts and data scientists to perform big data analysis included KPI analysis and predictive analysis. • Lead a data management team of 2 system analysts and 2 developers. Weekly communication with 8 regional users. Projects / Tasks Completed: • VIU mobile app analytic platform design and implementation. • Tibco Jaspersoft Business Intelligence platform design and implementation. • Weekly data analysis tasks and reports on app user behavior and business opportunities study. Major Achievements: • Designed, developed and launched a terabyte size data analytic platform for the VIU product team. The platform became a solid foundation for data analysis to support critical business decision making in management, and core business KPI monitoring. • Performed business potential analysis with business analysts and generated various result reports to management. Successfully assisted management to gain venture capital funding for a hundred million US dollars. Software / Programming Languages involved: • Amazon Web Service (AWS) cloud platform: Simple Workflow (AWS), Redshift Database, EMR to execute Hive script, Athena, S3, EC2 for compute service. • Python 3, SQL, Tibco Jaspersoft Business Intelligence. Show less Duties: • Design and implement VIU mobile app analytic platform on AWS cloud. Daily collect, process and analyze 50 million app user behavior messages which generated from the mobile devices from the 700k daily active users. Launched regions: Hong Kong, Singapore, Philippines and Thailand. • Weekly meeting with 4 region’s business and management team to collect data analytic requests and requirements. • Design architecture for big data analytic workflow included data cleansing rules… Show more Duties: • Design and implement VIU mobile app analytic platform on AWS cloud. Daily collect, process and analyze 50 million app user behavior messages which generated from the mobile devices from the 700k daily active users. Launched regions: Hong Kong, Singapore, Philippines and Thailand. • Weekly meeting with 4 region’s business and management team to collect data analytic requests and requirements. • Design architecture for big data analytic workflow included data cleansing rules, ETL logic, data lake and data pipeline logic design and • Design architecture for Business Intelligence (BI) and reporting system. • Manage internal development resources and external vendors on various project implementations. • Co-work with business analysts and data scientists to perform big data analysis included KPI analysis and predictive analysis. • Lead a data management team of 2 system analysts and 2 developers. Weekly communication with 8 regional users. Projects / Tasks Completed: • VIU mobile app analytic platform design and implementation. • Tibco Jaspersoft Business Intelligence platform design and implementation. • Weekly data analysis tasks and reports on app user behavior and business opportunities study. Major Achievements: • Designed, developed and launched a terabyte size data analytic platform for the VIU product team. The platform became a solid foundation for data analysis to support critical business decision making in management, and core business KPI monitoring. • Performed business potential analysis with business analysts and generated various result reports to management. Successfully assisted management to gain venture capital funding for a hundred million US dollars. Software / Programming Languages involved: • Amazon Web Service (AWS) cloud platform: Simple Workflow (AWS), Redshift Database, EMR to execute Hive script, Athena, S3, EC2 for compute service. • Python 3, SQL, Tibco Jaspersoft Business Intelligence. Show less

  • Quality HealthCare Medical Services Limited
    • Hong Kong
    • Hospitals and Health Care
    • 200 - 300 Employee
    • Senior Business Intelligence Analysis
      • Oct 2014 - Jan 2016

      Duties: • Manage enterprise data warehouse (EDW) and business intelligence (BI) platform as a technical lead. • Provide technical solutions for user requests on data analysis and business performance study. • Manage EDW and BI platform enhancement projects with external vendors, ensure the project is delivered on-time within budget. • Provide design on EDW architecture change to meet requirements on platform enhancements. Works included logical and physical data model design. •… Show more Duties: • Manage enterprise data warehouse (EDW) and business intelligence (BI) platform as a technical lead. • Provide technical solutions for user requests on data analysis and business performance study. • Manage EDW and BI platform enhancement projects with external vendors, ensure the project is delivered on-time within budget. • Provide design on EDW architecture change to meet requirements on platform enhancements. Works included logical and physical data model design. • Provide system architecture design for infrastructure, including database, application servers and network, to meet requirements on platform enhancements. • Produce Informatica Powercenter ETL logic specification, IBM Cognos framework and report logic specification for product development by IT service vendors. Projects / Tasks Completed: • Enterprise data warehouse (EDW) and business intelligence (BI) platform enhancement. • Cognos Dynamic Cube implementation with corporate financial data. • Clinic and doctor performance dashboard on mobile device. Major Achievements: • Successfully improved the daily night batch ETL job’s performance for 50% by designing, implementing multiple enterprise data warehouse system enhancement. • Successfully shortened the generation effort of multiple monthly revenue reports from 5 days to 1 day by designing, implementing a series of revenue reports automation projects. Software / Programming Languages involved: • Oracle Database 11g, Oracle SQL • IBM Cognos 10.2, Informatica PowerCenter 8 Show less Duties: • Manage enterprise data warehouse (EDW) and business intelligence (BI) platform as a technical lead. • Provide technical solutions for user requests on data analysis and business performance study. • Manage EDW and BI platform enhancement projects with external vendors, ensure the project is delivered on-time within budget. • Provide design on EDW architecture change to meet requirements on platform enhancements. Works included logical and physical data model design. •… Show more Duties: • Manage enterprise data warehouse (EDW) and business intelligence (BI) platform as a technical lead. • Provide technical solutions for user requests on data analysis and business performance study. • Manage EDW and BI platform enhancement projects with external vendors, ensure the project is delivered on-time within budget. • Provide design on EDW architecture change to meet requirements on platform enhancements. Works included logical and physical data model design. • Provide system architecture design for infrastructure, including database, application servers and network, to meet requirements on platform enhancements. • Produce Informatica Powercenter ETL logic specification, IBM Cognos framework and report logic specification for product development by IT service vendors. Projects / Tasks Completed: • Enterprise data warehouse (EDW) and business intelligence (BI) platform enhancement. • Cognos Dynamic Cube implementation with corporate financial data. • Clinic and doctor performance dashboard on mobile device. Major Achievements: • Successfully improved the daily night batch ETL job’s performance for 50% by designing, implementing multiple enterprise data warehouse system enhancement. • Successfully shortened the generation effort of multiple monthly revenue reports from 5 days to 1 day by designing, implementing a series of revenue reports automation projects. Software / Programming Languages involved: • Oracle Database 11g, Oracle SQL • IBM Cognos 10.2, Informatica PowerCenter 8 Show less

  • Tata Consultancy Services
    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Assistant Consultant
      • Mar 2014 - Oct 2014

      Duties: • Provide project management on project planning, resource allocation and task execution. • Collect user requirements, produce data model design (star schema) to meet business requirements. • Produce ETL specification for India development team to extract source data from user existing reports and SAP reports then transform and load into data mart in MS SQL Server 2014. • Manage the development tasks of the India development team (around 5 developers) to develop ETL jobs by… Show more Duties: • Provide project management on project planning, resource allocation and task execution. • Collect user requirements, produce data model design (star schema) to meet business requirements. • Produce ETL specification for India development team to extract source data from user existing reports and SAP reports then transform and load into data mart in MS SQL Server 2014. • Manage the development tasks of the India development team (around 5 developers) to develop ETL jobs by using MS SSIS according to ETL specification in order to meet the project schedule and requirement. • Weekly progress update to data architect in US, IT director and project manager in HK client site. • Design and propose data governance approach to client, include data ownership, data security level and data quality approach on best practice of manual load data Projects / Tasks Completed: • Johnson Control Asia Business Intelligence Project Phase 1 Software / Programming Languages involved: • MS SQL Server 2014, MS SSIS, SQL Show less Duties: • Provide project management on project planning, resource allocation and task execution. • Collect user requirements, produce data model design (star schema) to meet business requirements. • Produce ETL specification for India development team to extract source data from user existing reports and SAP reports then transform and load into data mart in MS SQL Server 2014. • Manage the development tasks of the India development team (around 5 developers) to develop ETL jobs by… Show more Duties: • Provide project management on project planning, resource allocation and task execution. • Collect user requirements, produce data model design (star schema) to meet business requirements. • Produce ETL specification for India development team to extract source data from user existing reports and SAP reports then transform and load into data mart in MS SQL Server 2014. • Manage the development tasks of the India development team (around 5 developers) to develop ETL jobs by using MS SSIS according to ETL specification in order to meet the project schedule and requirement. • Weekly progress update to data architect in US, IT director and project manager in HK client site. • Design and propose data governance approach to client, include data ownership, data security level and data quality approach on best practice of manual load data Projects / Tasks Completed: • Johnson Control Asia Business Intelligence Project Phase 1 Software / Programming Languages involved: • MS SQL Server 2014, MS SSIS, SQL Show less

  • Airport Authority Hong Kong
    • Airlines and Aviation
    • 700 & Above Employee
    • Data Warehouse Specialist
      • Jan 2013 - Jan 2014

      Duties: • Assist project manager on BI project included provide business logic, arrange meetings, monitor schedule and troubleshoot issues. • Collect user requirements and produce functional requirement specifications. • Co-work with vendor on Baggage Analysis and Statistics Information System (BASIS) related design tasks, include real time data replication flow implement by IBM Change Data Capture (CDC), data modeling (snowflake schema), ETL logic to extract source data from multiple… Show more Duties: • Assist project manager on BI project included provide business logic, arrange meetings, monitor schedule and troubleshoot issues. • Collect user requirements and produce functional requirement specifications. • Co-work with vendor on Baggage Analysis and Statistics Information System (BASIS) related design tasks, include real time data replication flow implement by IBM Change Data Capture (CDC), data modeling (snowflake schema), ETL logic to extract source data from multiple systems and load into target data mart in IBM DB2, IBM Cognos dashboard design. • Prepare and review documents with the project manager included vendor selection and solution architecture review. • Discuss data governance procedure with the data governance team and prepare a data dictionary. • Prepare test plan, test case document and arrange UAT for the verification on ETL logic and IBM Cognos report implementation. • Support project implementation included identifying and generating source data, examining data mart data according to business logic. Projects / Tasks Completed: • Baggage Analysis and Statistics Information System Project (BASIS) • Pier Information Management System (PIMS) Enhancement Project Software / Programming Languages involved: • IBM Datastage v8.5, IBM Change Data Capture (CDC), IBM Cognos 10.1 • IBM DB2 v10.2, Oracle 11g Database Show less Duties: • Assist project manager on BI project included provide business logic, arrange meetings, monitor schedule and troubleshoot issues. • Collect user requirements and produce functional requirement specifications. • Co-work with vendor on Baggage Analysis and Statistics Information System (BASIS) related design tasks, include real time data replication flow implement by IBM Change Data Capture (CDC), data modeling (snowflake schema), ETL logic to extract source data from multiple… Show more Duties: • Assist project manager on BI project included provide business logic, arrange meetings, monitor schedule and troubleshoot issues. • Collect user requirements and produce functional requirement specifications. • Co-work with vendor on Baggage Analysis and Statistics Information System (BASIS) related design tasks, include real time data replication flow implement by IBM Change Data Capture (CDC), data modeling (snowflake schema), ETL logic to extract source data from multiple systems and load into target data mart in IBM DB2, IBM Cognos dashboard design. • Prepare and review documents with the project manager included vendor selection and solution architecture review. • Discuss data governance procedure with the data governance team and prepare a data dictionary. • Prepare test plan, test case document and arrange UAT for the verification on ETL logic and IBM Cognos report implementation. • Support project implementation included identifying and generating source data, examining data mart data according to business logic. Projects / Tasks Completed: • Baggage Analysis and Statistics Information System Project (BASIS) • Pier Information Management System (PIMS) Enhancement Project Software / Programming Languages involved: • IBM Datastage v8.5, IBM Change Data Capture (CDC), IBM Cognos 10.1 • IBM DB2 v10.2, Oracle 11g Database Show less

  • Teradata
    • United States
    • Software Development
    • 700 & Above Employee
    • Data Warehouse Consulant
      • Dec 2011 - Dec 2012

      Duties: • Collect client requirements on enterprise data warehouse (EDW) design. • Data modeling, design logical and physical data models (LDM and PDM) according to the Teradata standard industrial data model. • Design and develop ETL workflow, ETL jobs according to PDM design. • Produce ETL specification for development team to implement ETL jobs in scripts. • Design and develop IBM Cognos framework and package for the implementation of query studio. • Provide user… Show more Duties: • Collect client requirements on enterprise data warehouse (EDW) design. • Data modeling, design logical and physical data models (LDM and PDM) according to the Teradata standard industrial data model. • Design and develop ETL workflow, ETL jobs according to PDM design. • Produce ETL specification for development team to implement ETL jobs in scripts. • Design and develop IBM Cognos framework and package for the implementation of query studio. • Provide user training and production launch support. • Provide pre-sales support to the sales team. Projects / Tasks Completed: • China Mobile Hong Kong Data Warehouse Project • Macau SJM Data Warehouse Enhancement Project Software / Programming Languages involved: • Teradata Database v12, Teradata SQL • IBM Congos v8 Show less Duties: • Collect client requirements on enterprise data warehouse (EDW) design. • Data modeling, design logical and physical data models (LDM and PDM) according to the Teradata standard industrial data model. • Design and develop ETL workflow, ETL jobs according to PDM design. • Produce ETL specification for development team to implement ETL jobs in scripts. • Design and develop IBM Cognos framework and package for the implementation of query studio. • Provide user… Show more Duties: • Collect client requirements on enterprise data warehouse (EDW) design. • Data modeling, design logical and physical data models (LDM and PDM) according to the Teradata standard industrial data model. • Design and develop ETL workflow, ETL jobs according to PDM design. • Produce ETL specification for development team to implement ETL jobs in scripts. • Design and develop IBM Cognos framework and package for the implementation of query studio. • Provide user training and production launch support. • Provide pre-sales support to the sales team. Projects / Tasks Completed: • China Mobile Hong Kong Data Warehouse Project • Macau SJM Data Warehouse Enhancement Project Software / Programming Languages involved: • Teradata Database v12, Teradata SQL • IBM Congos v8 Show less

  • Hong Kong Disneyland
    • Hong Kong
    • Entertainment Providers
    • 700 & Above Employee
    • Business Analyst
      • Dec 2010 - Nov 2011

      Duties: • Co-work with SAS vendor on development of the Annual Pass Campaign Management (APCM) Project and the roll-out of SAS system in the company. • Develop APCM data mart by using SAS Data Integration Studio • Develop APCM manual import workflow on MS Access files by using SAS Enterprise Miner • Work with data analytic team users to collect data warehouse enhancement requirements. • Modify logical and physical data model according to data warehouse enhancement… Show more Duties: • Co-work with SAS vendor on development of the Annual Pass Campaign Management (APCM) Project and the roll-out of SAS system in the company. • Develop APCM data mart by using SAS Data Integration Studio • Develop APCM manual import workflow on MS Access files by using SAS Enterprise Miner • Work with data analytic team users to collect data warehouse enhancement requirements. • Modify logical and physical data model according to data warehouse enhancement requirements. • Develop ETL jobs in IBM DataStage to extract, transform and load data from source systems into the data warehouse operational data store (ODS) layer. • Create technical specifications to internal developers for project development tasks. • Create system support documents, user training material and perform user training to data analytic team users. • Prepare testing documents. Perform unit test and system integration test (SIT). • Support and update Business Object (BO) report according to new business requirements. Projects / Tasks Completed: • Hong Kong Disneyland Data Warehouse Enhancement • Annual Pass Campaign Management (APCM) Project Software / Programming Languages involved: • MS SQL Server 2008, IBM Datastage v6 • SAS v8, SAP Business Object Show less Duties: • Co-work with SAS vendor on development of the Annual Pass Campaign Management (APCM) Project and the roll-out of SAS system in the company. • Develop APCM data mart by using SAS Data Integration Studio • Develop APCM manual import workflow on MS Access files by using SAS Enterprise Miner • Work with data analytic team users to collect data warehouse enhancement requirements. • Modify logical and physical data model according to data warehouse enhancement… Show more Duties: • Co-work with SAS vendor on development of the Annual Pass Campaign Management (APCM) Project and the roll-out of SAS system in the company. • Develop APCM data mart by using SAS Data Integration Studio • Develop APCM manual import workflow on MS Access files by using SAS Enterprise Miner • Work with data analytic team users to collect data warehouse enhancement requirements. • Modify logical and physical data model according to data warehouse enhancement requirements. • Develop ETL jobs in IBM DataStage to extract, transform and load data from source systems into the data warehouse operational data store (ODS) layer. • Create technical specifications to internal developers for project development tasks. • Create system support documents, user training material and perform user training to data analytic team users. • Prepare testing documents. Perform unit test and system integration test (SIT). • Support and update Business Object (BO) report according to new business requirements. Projects / Tasks Completed: • Hong Kong Disneyland Data Warehouse Enhancement • Annual Pass Campaign Management (APCM) Project Software / Programming Languages involved: • MS SQL Server 2008, IBM Datastage v6 • SAS v8, SAP Business Object Show less

  • Bank of China (Hong Kong)
    • Banking
    • 700 & Above Employee
    • Analyst Programmer
      • Sep 2009 - Aug 2010

      Duties: • Design data model modification and develop ETL jobs in IBM Datastage according to business requirement and compliance with enterprise architecture standards. • Attend business requirement sessions, system design sessions and produce related business and system documents. • Create allocation rules in Oracle Performance Analyzer 4.5 to divide corporate revenue according to business logic. • Produce system integration test (SIT) and user acceptance test (UAT) test cases and… Show more Duties: • Design data model modification and develop ETL jobs in IBM Datastage according to business requirement and compliance with enterprise architecture standards. • Attend business requirement sessions, system design sessions and produce related business and system documents. • Create allocation rules in Oracle Performance Analyzer 4.5 to divide corporate revenue according to business logic. • Produce system integration test (SIT) and user acceptance test (UAT) test cases and related test SQL. • Execute SIT and assist business team testers in UAT. Produce system support documents. Projects / Tasks Completed: • Financial Risk Management System (FRMS) - Profitability Analysis Software / Programming Languages involved: • Oracle Database 10g, Sybase IQ, • IBM Datastage v6, IBM Cognos v8 Show less Duties: • Design data model modification and develop ETL jobs in IBM Datastage according to business requirement and compliance with enterprise architecture standards. • Attend business requirement sessions, system design sessions and produce related business and system documents. • Create allocation rules in Oracle Performance Analyzer 4.5 to divide corporate revenue according to business logic. • Produce system integration test (SIT) and user acceptance test (UAT) test cases and… Show more Duties: • Design data model modification and develop ETL jobs in IBM Datastage according to business requirement and compliance with enterprise architecture standards. • Attend business requirement sessions, system design sessions and produce related business and system documents. • Create allocation rules in Oracle Performance Analyzer 4.5 to divide corporate revenue according to business logic. • Produce system integration test (SIT) and user acceptance test (UAT) test cases and related test SQL. • Execute SIT and assist business team testers in UAT. Produce system support documents. Projects / Tasks Completed: • Financial Risk Management System (FRMS) - Profitability Analysis Software / Programming Languages involved: • Oracle Database 10g, Sybase IQ, • IBM Datastage v6, IBM Cognos v8 Show less

  • Cathay Pacific
    • Hong Kong
    • Airlines and Aviation
    • 700 & Above Employee
    • Analyst Programmer
      • Jul 2007 - Mar 2009

      Duties: • Design table structure and data flow logic for data warehouse. • Implement ETL logic according to requirement to generate report figures with the use of Oracle PL/SQL. • Design project plan, functional specification according to user requirement. • Produce web interface by Java and PL/SQL package to perform data entry, enquiry and update. Projects / Tasks Completed: • Acceptable Deferred Defect IBM Cognos Dashboard • Aircraft Condition Monitoring (ACM)… Show more Duties: • Design table structure and data flow logic for data warehouse. • Implement ETL logic according to requirement to generate report figures with the use of Oracle PL/SQL. • Design project plan, functional specification according to user requirement. • Produce web interface by Java and PL/SQL package to perform data entry, enquiry and update. Projects / Tasks Completed: • Acceptable Deferred Defect IBM Cognos Dashboard • Aircraft Condition Monitoring (ACM) project Software / Programming Languages involved: • MS SQL Server 2000, Oracle 9i, IBM Cognos • PL/SQL, SQL, JAVA Show less Duties: • Design table structure and data flow logic for data warehouse. • Implement ETL logic according to requirement to generate report figures with the use of Oracle PL/SQL. • Design project plan, functional specification according to user requirement. • Produce web interface by Java and PL/SQL package to perform data entry, enquiry and update. Projects / Tasks Completed: • Acceptable Deferred Defect IBM Cognos Dashboard • Aircraft Condition Monitoring (ACM)… Show more Duties: • Design table structure and data flow logic for data warehouse. • Implement ETL logic according to requirement to generate report figures with the use of Oracle PL/SQL. • Design project plan, functional specification according to user requirement. • Produce web interface by Java and PL/SQL package to perform data entry, enquiry and update. Projects / Tasks Completed: • Acceptable Deferred Defect IBM Cognos Dashboard • Aircraft Condition Monitoring (ACM) project Software / Programming Languages involved: • MS SQL Server 2000, Oracle 9i, IBM Cognos • PL/SQL, SQL, JAVA Show less

  • INFINITE FINANCIAL SOLUTIONS LTD
    • Wan Chai, Hong Kong
    • Programmer
      • Apr 2006 - Jul 2007

      Duties: • Develop extract, transform, load (ETL) jobs by using Oracle PL/SQL for Shanghai Commercial Bank’s data warehouse. • Implement ETL logic based on business logic in design documents. • Design data work flow in the data warehouse system. • Create test cases and perform unit testing. • Produce financial reports according to specification provided by the Shanghai Commercial Bank Financial Control Department. Projects / Tasks Completed: • Shanghai Commercial Bank… Show more Duties: • Develop extract, transform, load (ETL) jobs by using Oracle PL/SQL for Shanghai Commercial Bank’s data warehouse. • Implement ETL logic based on business logic in design documents. • Design data work flow in the data warehouse system. • Create test cases and perform unit testing. • Produce financial reports according to specification provided by the Shanghai Commercial Bank Financial Control Department. Projects / Tasks Completed: • Shanghai Commercial Bank Financial Reporting Project Software / Programming Languages involved: • Oracle 10g, Oracle Warehouse Builder • PL/SQL, SQL Show less Duties: • Develop extract, transform, load (ETL) jobs by using Oracle PL/SQL for Shanghai Commercial Bank’s data warehouse. • Implement ETL logic based on business logic in design documents. • Design data work flow in the data warehouse system. • Create test cases and perform unit testing. • Produce financial reports according to specification provided by the Shanghai Commercial Bank Financial Control Department. Projects / Tasks Completed: • Shanghai Commercial Bank… Show more Duties: • Develop extract, transform, load (ETL) jobs by using Oracle PL/SQL for Shanghai Commercial Bank’s data warehouse. • Implement ETL logic based on business logic in design documents. • Design data work flow in the data warehouse system. • Create test cases and perform unit testing. • Produce financial reports according to specification provided by the Shanghai Commercial Bank Financial Control Department. Projects / Tasks Completed: • Shanghai Commercial Bank Financial Reporting Project Software / Programming Languages involved: • Oracle 10g, Oracle Warehouse Builder • PL/SQL, SQL Show less

Education

  • Deakin University
    Master of Data Science, Data Science / Data Engineering
    2022 - 2023
  • Monash University
    bachelor of computing, Computer Programming, Specific Applications
    2003 - 2005
  • Deakin University
    Diploma of Computing, Computer Engineering
    2002 - 2003

Community

You need to have a working account to view this content. Click here to join now