Chi Yam Lam
ETL Data Engineer/BI Reporting
North York, Toronto,Ontario
Summary
Focus in business intelligence at banking industry, expert in building ETL/Reporting for banking products, such as risk analyst, current, saving, etc. Good at conducting user requirement and transform to end products. Also excellent at linux/window server environment initial setup, server tuning, control, shell script/power shell for task control. Experience with vendor coordination, document developer guide, user guide, server support documents, backup plan designs. Enthusiastic in team building, work with different peoples.
Overview
7
7
years of professional experience
3
3
years of post-secondary education
Work History
System Analyst
Excel Technology
Hong Kong
07.2021 - 08.2022
- Achievement: Leading roles in BI reporting tools replacement project in big bank (Hyperion report to Oracle BI Publisher & OBIEE).
- Collaborated with Oracle Vendor for server setup, server support documentation. (Server backup plan, JDBC connect with big data, stop/start)
- Server custom: using python scripts(WLST) to setup user roles, DB connection, user authentication, single sign-on.
- Web application(JSP) develop/support for user login.
- Developed linux shell scripts for auto deployment jobs.
- Created a development documents from scratch for the other developers. such as how to implement on it compare with Hyperion.
- Documented user guide on BI publisher/OBIEE, educate user how to user in new platform.
Assistant Manager - IT Department CRM
DahSing Bank
North Point, Hong Kong
04.2019 - 07.2021
- Achievements: building more than 100 ETL jobs (OWB) for core banking revamp project. (Current, Saving, loans, fixed deposits,)
- Perform Data analysts role in core banking revamp project, check and validate data consistent, dup key, it benefits other team with using core banking data, making progress on revamp project.
- Achievements: Window Server 2016 upgrade project for SAS server upgrade. (Vendor coordination, powershell scripting for calling SAS job for end users)
- Achievements: Electronic Direct Mail(Radicasys) server migration, work closely with vendor, server support documentation, server backup plan,
- FATCA/CRS data extraction and analyst.
- Daily ETL batch support/job developments
Senior Analyst Programmer
Ambitions
Kowloon Bay, Hong Kong
09.2018 - 04.2019
- Achievements: building ETL(ODI) jobs for core banking revamp project(current, saving, loans, fix/term deposits)
- Support Oracle OFSAA system.
- Designed and developed ETL(ODI), and reporting(OBIEE)
- Designed and developed PL/SQL packages for OFSAA data integration.
- Shell script development for batch job support.
Analyst Programmer
ICO Limited
Wan Chai, Hong Kong
07.2015 - 08.2018
- Achievements: Making progress on core banking revamp projects(current, saving, loans, deposit), building more than 100 ETL(IBM datastage) jobs and reporting(Oracle Hyperion)
- Participate in Basel II project, building risk analyst ETL/reporting.
- Participate in post loan management reporting
- Revise business requirements and build the corresponding SQL report jobs(tunning IBM DB2 SQL).
- Design shell script for task scheduler control
Education
Bachelor of Engineering - Computer Science
Hong Kong University of Science And Technology
Clear Water Bay, Sai Kung, Hong Kong 09.2013 - 06.2015
Associate of Science - Statistic And Computing For Business
Hong Kong Community College
Hung Hum, Hong Kong 09.2011 - 06.2013
Skills
Technical Analysis
undefinedTimeline
System Analyst
Excel Technology
07.2021 - 08.2022
Assistant Manager - IT Department CRM
DahSing Bank
04.2019 - 07.2021
Senior Analyst Programmer
Ambitions
09.2018 - 04.2019
Analyst Programmer
ICO Limited
07.2015 - 08.2018
Bachelor of Engineering - Computer Science
Hong Kong University of Science And Technology
09.2013 - 06.2015
Associate of Science - Statistic And Computing For Business
Hong Kong Community College
09.2011 - 06.2013
Similar Profiles
AYESHA SIDDIQAAYESHA SIDDIQA
Administrative Office Assistant at EXCEL MEDICAL TECHNOLOGYAdministrative Office Assistant at EXCEL MEDICAL TECHNOLOGY
Mei Yee WongMei Yee Wong
Adminstration Executive at Excel Electronics Technology Sdn BhdAdminstration Executive at Excel Electronics Technology Sdn Bhd
Jalene Van ZylJalene Van Zyl
Native English Teacher at English Excel or Excel Top (Hong Kong) LimitedNative English Teacher at English Excel or Excel Top (Hong Kong) Limited