Overview
Work History
Education
Skills
Technical Skills
Phone
Training
Personal Information
History Buff
Timeline
Generic

Christopher J. Lalonde

Overview

33
33
years of professional experience

Work History

Senior Systems Analyst – Data Analytics & AI Engineering & Ops

Synapxe Systems Pte Ltd
10.2006 - 06.2024
  • Managing areas of the implementation of the SingHealth data warehouse encompassing Clinical and Business subject areas
  • Helping to implement and supporting an infection control & quality surveillance system for the Singapore General Hospital
  • Managing the implementation for the National Cancer Centre Singapore (NHCS)
  • Managing the implementation of a web-based scorecard dashboard and reporting system based using Oracle Essbase and the Oracle Business Intelligence Enterprise Edition (OBIEE) for SGH
  • Implementing and supporting the REDCap application for building and managing research databases and surveys for two Singapore healthcare clusters
  • Building dashboards and reports with the SingHealth Cluster enterprise data warehouse
  • Performing data requests via OBIEE front end tool and SQL for SingHealth institutions
  • Managing incoming data requests for SingHealth cluster for both the data warehouse and other applications
  • Managing support of two data warehouses for Singapore public health data warehouses
  • Assigning data warehouse issues to Synapxe staff

Senior Consultant

Oracle Systems Singapore Pte Ltd
04.1997 - 06.2006
  • Implemented business intelligence and data warehouse solutions for various customers in banking, manufacturing, education, telecommunications and other industries
  • Analyzed customer requirements, designed and developed a financial management reporting system using the Oracle Financial Analyzer OLAP application for the Singapore Tourism Board
  • Designed and implemented an ERP-based data warehouse using Oracle Warehouse Builder ETL tool for a Japanese electronic MNC
  • Implemented a data mining POC for a Singaporean media corporation
  • This project was the first data mining project implemented by Oracle Consulting Services in South-East Asia
  • Designed and built Net Economic Value (NEV) model using the OLAP budgeting application, Oracle Financial Analyzer, and Oracle Express multi-dimensional database for a Singaporean Polytechnic
  • Analyzed customer requirements, designed and developed the front-end BI reporting interface of the Oracle Financial Services (OFSA) modules for OUB, UOB and OCBC
  • Supported various pre-sales initiatives in data warehousing, ROLAP, MOLAP and balanced scorecard

Contractor

Oracle Systems Singapore Pte Ltd
06.1996 - 03.1997
  • Analyzed customer requirements, designed and implemented the front-end BI interface and reports using Cognos Impromptu ad-hoc reporting tool for a sales and marketing data warehouse of the regional headquarters of a chemical manufacturing MNC

Pre-Sales Consultant

Cognos Singapore Pte Ltd
09.1995 - 05.1996
  • Provided pre-sales, education and customer support for Cognos PowerPlay and Impromptu business intelligence products

Sales Manager

Innosys Pte Ltd
07.1994 - 08.1995
  • Facilitated sales of air/sea freight and warehouse software

MIS Support Consultant

International Development Research Centre (IDRC)
09.1993 - 06.1994

Software Support Analyst

IBM Singapore Corporation
05.1991 - 03.1993
  • June 1992 – May 1993: Software Support Analyst
  • May 1991 – May 1992: Programmer/Analyst

Education

Bachelor of Commerce (Honours) - General business degree with courses taken in IT, Finance, Accountancy, Economics, Statistics and Management

Carleton University
01.1991

Skills

  • RDBMS
  • Oracle RDBMS
  • Microsoft SQLServer 2005
  • MySQL 55
  • ETL Tool
  • Oracle Warehouse Builder (OWB) 9i / 10g
  • SQL
  • PL/SQL
  • Transact-SQL
  • BI Reporting Tools
  • Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g
  • Oracle Discoverer 31 / 41
  • Cognos Impromptu 45
  • OLAP
  • Oracle (Hyperion) Essbase 931
  • Oracle Financial Analyzer (OFA) 64
  • Oracle Express 632 / 634
  • Cognos PowerPlay 5
  • Balanced Scorecard
  • Oracle Balanced Scorecard
  • Data Mining
  • Web Application for building and managing online surveys and databases in Healthcare
  • Oracle Data Mining 10g
  • REDCap

Technical Skills

Oracle RDBMS, Microsoft SQLServer 2005+, MySQL 5.5, Oracle Warehouse Builder (OWB) 9i / 10g, PL/SQL, Transact-SQL, Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g, Oracle Discoverer 3.1 / 4.1, Cognos Impromptu 4.5, Oracle (Hyperion) Essbase 9.3.1, Oracle Financial Analyzer (OFA) 6.4, Oracle Express 6.3.2 / 6.3.4, Cognos PowerPlay 5, Oracle Balanced Scorecard, Web Application for building and managing online surveys and databases in Healthcare, Oracle Data Mining 10g, REDCap

Phone

HP, (65) 9683-7747

Training

  • Python, 06/30/24
  • OBIEE 10g Architect Professional
  • Project Management Professional (PMP), 10/01/10
  • Project Management Institution (PMI), 11/01/07

Personal Information

  • Singapore Permanent Resident
  • Canadian Citizen

History Buff

Find me on Quora under Chris Lalonde from Canada.

Timeline

Senior Systems Analyst – Data Analytics & AI Engineering & Ops

Synapxe Systems Pte Ltd
10.2006 - 06.2024

Senior Consultant

Oracle Systems Singapore Pte Ltd
04.1997 - 06.2006

Contractor

Oracle Systems Singapore Pte Ltd
06.1996 - 03.1997

Pre-Sales Consultant

Cognos Singapore Pte Ltd
09.1995 - 05.1996

Sales Manager

Innosys Pte Ltd
07.1994 - 08.1995

MIS Support Consultant

International Development Research Centre (IDRC)
09.1993 - 06.1994

Software Support Analyst

IBM Singapore Corporation
05.1991 - 03.1993

Bachelor of Commerce (Honours) - General business degree with courses taken in IT, Finance, Accountancy, Economics, Statistics and Management

Carleton University
Christopher J. Lalonde