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
Timeline
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