Guo Hao (Derek) Lee Email & Phone Number

Auckland, Nz

New Zealand

New Zealand

Auckland, New Zealand

New Zealand

Linux, Networking, Bash Scripting, ServerlessCircleCI CI/CDDockerTerraform, Ansible , AWX , MoleculeAWS InfrastructureSupport in helping organisation to achieve ISO27001 by improvising security and technologies

Auckland, New Zealand

Auckland, New Zealand

- Develop and Maintain ELT/ETL pipeline built using Python and SQL Stored Procedures- Data preparation & Data Warehousing for visual analytics in Tableau and Carto- Geospatial Data Analytics- Develop website’s backend framework using DJANGO & REST FRAMEWORK- Develop scripts for various APIs data extraction and loading Technology Stack:PythonPostgres SQLAWS RDS PostgresAWS EC2 LinuxTableau CartoGeoSpatial Data ( PostGis)QGisDJANGOREST API

Auckland, New Zealand

Task And Responsibilities: • Develop Python and SQL scripts for ETL processing from various sources such as CSV and APIs• Data Analytics & Data Warehousing ETL• Geospatial Data Analytics with PostGis • Develop websites using Django, Django REST Framework and React languages• Deploy websites and backend into PAAS services like Heroku • Involves in setting up and supporting the company’s infrastructure either physically or on cloud providers like AWS• Setting up automation task and mail reporting system for daily tasks in Linux system. • Task includes software development, testing, documentation and other tasks as required• Exposed to scrum and agile methodologies

Auckland, New Zealand

• Summer of Tech 2018 internship role• Develop Python and SQL scripts for ETL processing.• Involves in setting up and supporting the company’s infrastructure (on-premise and cloud) • Tasks include software development, testing, documentation, and other tasks as required• Exposed to scrum and agile methodologies

Shah Alam, Malaysia

Involvement in 80% infrastructure and 20% application• As tier 2 support engineer to provide proactive and reactive support to telecommunication monitoring system.• Involve in troubleshooting hardware like network splitters and taps, production servers, copper and fiber cablings, and SFPs.• Involve in monitoring solution projects to major telecommunication companies like Maxis, U-Mobile, and Celcom in Malaysia.o Provide solution to tap live traffic and capture datao Captured raw data is processed in probe via 3rdparty vendor like Empirix, Anritsu and Zhilabs.o Data is processed and displayed for troubleshooting and data analysis.• Involve in project preparation documents like rack design, tapping links, IP tables , Low Level Design Documentation• Involve in installing of rack and hardware, tapping links and switchover activity.• Liaise with principles like HP, Empirix, Anritsu, Zhilabs, IXIA and Gigamon during project implementation.• Prepare Monthly Support Report for Maxis Performance Network• Create automated health check scripts for daily server’s health monitoring.

Selangor, Malaysia

The company provides services in Maintenance, Service and Testing of electrical installation as well as contract staffs to carry out the works.Responsibilities:• Work as part time electrician • Involved in Maintenance, Services and Testing concerning electrical installation up to 33kv. • Equipment handling including capacitors, switchboards, circuit breakers, protection relays, troubleshooting, calibration and installation. • Planning and design protection relays discrimination functioning, power system for new installation for industries, commercial and residential• Preparation of engineering designs, scheduling, liaise with customer, factory acceptance testing, mobilization, pre-commissioning and commissioning projects and workforce management• To be involve in maintenance job in cleaning switch board and circuit breaker.

Responsibilities:• To co-ordinate in major hardware and software application• Involvement in implementation projects, including working with vendors and users.• To provide support to users in hardware by way of training, troubleshooting and coordinate in maintenance and repair services in HQ and outlets.• Involve in supporting company’s ERP system (PRONTO)• Liaise with CCTV vendors to install CCTV at shop outlets and setting remote connection to HQ office• Involvement in replacing IBM POS system to all shop outlets.

Master Of Cyber Security And Digital Forensics, Computer And Information Systems Security/Information Assurance

Postgraduate Diploma In Computing, Data Processing

Activities and Societies: Gained experience in JAVA and socket programming Gained experience in Data Warehousing Gained experience.

Bachelor Of Computer Science Major In Software Engineering And Network Security, Computer Science, Average Of 70

Attended Codefest & Codefest 2.0 Attended Data Centre Training year

Master Of Business Administration - Mba, Business Administration And Management, General

Diploma In Information And Communication Technology, Computing

Activities and Societies: Awarded Best Project for Diploma’s Final Year Project (Ecommerce website) in IT@INtigenieur Challenge 3.6 2013