Years of Data Warehouse Design Experience
Oscar Lee
Epping,Australia
Summary
A seasoned Data Architect / Senior Data Engineer adept at understanding mandates, developing plans and implementing enterprise-wide solutions. Completed the Master of Data Science course in Deakin University to enrich latest technologies knowledge. Ready to bring 15 years of company-wide level data modelling, data warehouse, ETL process design and development experience to take on a challenging new role with growth potential. Results-oriented and proactive with top-notch skills in project management and communication.
Overview
10
10
8
8
Years of BI Application Design Work
8
8
Years of Project Management Experience
12
12
Years of SQL Experience
6
6
Years of Python Programming
1
1
Master Degree of Data Science
3
3
3 Certifications in Data Analytics Software
3
3
Recognition of Expertise by Industry Experts
Work History
Data Architect
Pacific Basin Shipping Limited
Hong Kong
04.2018 - 06.2022
- Contributed in the company gaining 30% more revenue in 2021 by leading and delivering the big data analytic system project to the sales team.
- Assisted in reducing vessel port calling cost for 10% by developing Portlog API data integration to the operation team.
- Contributed in daily revenue dashboards for the top management by implementing complex business logic into SQL queries.
- Reduced data mart ETL processing time for 15% by optimizing data pipelines of integrating and transforming data from various sources.
- Developed logical and physical data models aligning with business objects and requirements.
Data Architect
VIU
Hong Kong
03.2016 - 01.2018
- Contributed in the company gaining million US dollars from venture capital funding by successfully mined key performance figures from the terabyte size big data platform.
- Achieved 5 millions daily app users performance monitoring by designing and implementing data lake, data warehouse and a big data platform in AWS.
- Delivered 5 data projects within 2 years by managing 3 junior developers and vendors.
- Contributed the weekly strategy meetings by collecting requirements from business analysts and developed analysis scripting in Python.
- Improved daily video view number processing time for 10% faster by conducting performance tuning on the Redshift database, EMR hive jobs and SQL queries in AWS.
Senior Business Intelligence Analyst
Quality HealthCare Medical Services Limited
Hong Kong
10.2014 - 01.2016
- Reduced monthly revenue reports generation time from 5 days to 1 day by digitizing manual processes using IBM Cognos.
- Increased data retrieval efficiency for business teams to real time access by deploying OLAP data cubes in Cognos.
- Provided long term business intelligence insight to the management by developing a series of performance dashboards in BI tools.
- Improved data warehouse ETL jobs performance for 30% faster by performing job turning in Informatica and Oracle database.
Assistant Consultant
Tata Consultancy Services Limited
Hong Kong
03.2014 - 10.2014
- Reduced Johnson Control monthly revenue reporting preparation process from 5 days to 2 days by designing data warehouse and BI reports to automate manual processes.
- Managed the project to deliver on-time by creating detailed project plan, timelines, resources allocation and performing weekly progress update with off-shore development team.
- Produced comprehensive system specification by collecting detailed requirements from business users at all levels.
- Contributed in establishing data governance policies and procedures in the client company.
Data Warehouse Specialist
Taylor Coulter Limited
Hong Kong
12.2012 - 12.2013
- Increased the utilization rate of the baggage system for 10% in Hong Kong International Airport by managing and rolling out the Baggage Analysis and Statistics Information System (BASIS) Project.
- Delivered the BASIS project on time, within budget by effectively coordinating internal teams, external vendors and closely monitoring project tasks according to the project plan.
- Achieved smooth project progress by advising and solving technical issues in data models, data warehouse and ETL logic design.
- Facilitated user acceptance test by preparing test plan and test case documents to the IBM Cognos dashboard implementation.
PS Staff Consultant
Teradata (Hong Kong) Limited
Macau
12.2011 - 12.2012
- Improved data analytic query performance of Macau SJM casino for 15% by implementing Teradata database with customized data models.
- Increased data analysis efficiency of China Mobile Hong Kong by migrating legacy data stores to Teradata database and deployed IBM Cognos OLAP cubes to client’s business department.
- Collaborated with clients to collect business objectives and data requirements for the data warehouse solution.
- Designed and developed data models for the data warehouse, including logical and physical models, data ingestion and ETL processes, to ensure fast retrieval and analysis of data.
Business System Analyst
G A Career Limited
Hong Kong
12.2010 - 11.2011
- Contributed in annual pass ticket price optimization in Disneyland Hong Kong by designing and developing the business data integration process using SAS.
- Improved data analysis efficiency of the finance team by enhancing data model, data warehouse and ETL jobs to cover extensive business data from multiple sources.
- Increased data warehouse performance by continually tuning query, database and enhancing data architecture.
Education
Master of Data Science -
Deakin University
Melbourne, VIC10-2023
Bachelor of Computing -
Monash University
Melbourne, VIC11-2005
Diploma of Computing -
Deakin College
Melbourne, VIC06-2003
Skills
- Enterprise Data Architecture
- Project Management
- Data Modelling
- Data Warehousing
- Data Quality Management
- Data Governance
- Big Data Technologies
- Python Programming
- Data Integration
- ETL Process Design
- Performance Tuning
- Business Intelligence
Technical Skills Experience
- Coding: Python | SQL | API | PL/SQL | R
- Cloud Platforms: AWS | Azure | GCP
- ETL Tools: SSIS | IBM Datastage | Informatica PowerCenter | SAS
- Databases: MS SQL Server | Oracle | AWS Redshift | Teradata | IBM DB2
- BI Tools: Power BI | IBM Cognos | Tibco BI | SAS
Accomplishments
- Recognition of expertise and achievement in big data systems - Suresh Moganti, IT Director in Pacific Basin Shipping Limited.
- Recognition of talent in big data and business analytic - Noble Binoy, Strategy and Analytics Lead in VIU.
- Recognition of expertise in data science and business intelligence - Allen Yu, Associate Director in Quality Healthcare Medical Services Limited.
Link: https://github.com/oscarlee711/oscar-ref-doc/tree/main/documents/
Certification
- Matomo Certified Professional - Digital Analytics (issued on March 2018)
- Python Programming online course (issued on March 2018)
- SAS Technical Training (issued on September 2011)
- Oracle Performance Analyzer Release 4.5 (issued on September 2009)
Languages
English
Full Professional
Chinese (Cantonese)
Native/ Bilingual
Personal Projects
- Machine Learning Grocery Item Recommender App
- Machine Learning Collaborative Filtering For Recommendations
- Deep Learning Real Life Item Classification
Link: https://github.com/oscarlee711/
Organisations
- Australian Computer Society (ACS) - Member - 2017 to present
- Data Management Association Australia - Member - 2021 to 2022
- Institute of Electrical and Electronics Engineers - Member - 2020 to 2022
- TDWI - Webinar Attendee - 2021 to present
- Hong Kong Surf & Standup Paddle Association - Member - 2020 to present
Similar Profiles
Jasper Jan CorderoJasper Jan Cordero
Able Bodied Seaman at Pacific Basin Shipping LimitedAble Bodied Seaman at Pacific Basin Shipping Limited
KARL BRYAN BACUGANKARL BRYAN BACUGAN
Cargo Officer at Pacific Basin ShippingCargo Officer at Pacific Basin Shipping
ELBA SORRERAELBA SORRERA
Front End Manager at Triple J Pacific Basin PaylessFront End Manager at Triple J Pacific Basin Payless