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
<ul><li>I lead the global data protection office for the Company and set the strategy around the appropriate use of personal data. Building a strong privacy posture in both the first and second lines of defense to ensure that privacy risks are mitigated and supporting business in remaining compliant.</li><li>Facilitate compliance with a complex and evolving privacy regulatory requirements arising from the collection, use, sharing, storage, and international data transfer and securing ISO27701 and TRUSTe Privacy Certification for the Company.</li><li>Monitor Data Processing Addendum obligations, spearhead responses and negotiations of complex contracts on data protection and privacy related clauses.</li><li>Revitalized the Privacy Policies, Procedures and Privacy Notice, streamlining and simplifying the language to accurately reflect the business requirements for data processing and Company’s Practices.</li><li>Meet compliance obligations and mitigate exposures arising from the use of new technologies (including cloud-based technologies, predictive analytics, social marketing, and Generative AI) and effectively manage vendor risk.</li><li>Leading Company’s global privacy program and ensure that privacy is embedded into the business' personal data collection, storage, use and sharing practices through integration at the ideation stage. Effectively balance risk management and the interests of the business while building programs, policies, procedures, and governance.</li><li>Working closely with key stakeholders like Chief Risk Officer, the General Counsel’s Office, Chief Information Security Office, the Global Marketing and Communication Team, Global Procurement Team, and other leaders to operate the privacy program and enable the business while mitigating risk.</li><li>Implemented robust privacy controls and monitor compliances that includes conducting Data Protection Impact Assessments, Privacy review for internal systems, processes, portals, and performing Transfer Impact Assessments.</li></ul> at Virtusa<ul><li>I lead the global data protection office for the Company and set the strategy around the appropriate use of personal data. Building a strong privacy posture in both the first and second lines of defense to ensure that privacy risks are mitigated and supporting business in remaining compliant.</li><li>Facilitate compliance with a complex and evolving privacy regulatory requirements arising from the collection, use, sharing, storage, and international data transfer and securing ISO27701 and TRUSTe Privacy Certification for the Company.</li><li>Monitor Data Processing Addendum obligations, spearhead responses and negotiations of complex contracts on data protection and privacy related clauses.</li><li>Revitalized the Privacy Policies, Procedures and Privacy Notice, streamlining and simplifying the language to accurately reflect the business requirements for data processing and Company’s Practices.</li><li>Meet compliance obligations and mitigate exposures arising from the use of new technologies (including cloud-based technologies, predictive analytics, social marketing, and Generative AI) and effectively manage vendor risk.</li><li>Leading Company’s global privacy program and ensure that privacy is embedded into the business' personal data collection, storage, use and sharing practices through integration at the ideation stage. Effectively balance risk management and the interests of the business while building programs, policies, procedures, and governance.</li><li>Working closely with key stakeholders like Chief Risk Officer, the General Counsel’s Office, Chief Information Security Office, the Global Marketing and Communication Team, Global Procurement Team, and other leaders to operate the privacy program and enable the business while mitigating risk.</li><li>Implemented robust privacy controls and monitor compliances that includes conducting Data Protection Impact Assessments, Privacy review for internal systems, processes, portals, and performing Transfer Impact Assessments.</li></ul> at Virtusa