Fanny Yang

VP, Data Architect @ KGI 凱基

About

I've working over 10 years for data related projects, including data warehouse, data migration, data analysis and data visualization. I had the multiple industry experience, such as telecom, banking and insurance, dealing with requirement gathering, data manipulating, ETL support

Country

City

Hong Kong SAR

Industry

Banking

Skill

Data Engineering, Data Analysis, Data Warehousing, Extract, Transform, Load (ETL), Analytical Skills, Business Analysis, Project Management, Business Intelligence (BI), Business Analytics, Data Visualization, Software Development Life Cycle (SDLC), Software Project Management, Databases, Microsoft Power BI, Microsoft SQL Server, Tableau, Microsoft Azure, Performance Dashboards, Data Analytics, Cloud Administration

Experience

VP, Data Architect

KGI 凱基

2023-7 - Present · 3 yrs 3 mos

香港特別行政區

Manager

livi bank

2021-6 - 2023-7 · 2 yrs 2 mos

香港特別行政區

Analyzing digital data in Google Analytics & Branch.io using Google Big Query, CRM data monitoring and processes optimizing Drive and support data integration projects of Cloud data and On-premise data; Design, develop and maintain data models, consistent reporting, data automation, dashboards and performance metrics support (Tableau) Work closely with product, sales, and marketing teams to support and implement high-quality, data-driven business decisions

Data Engineer

KEYTEO

2020-5 - 2021-6 · 1 yr 2 mos

Hong Kong SAR

As an consultant served for client Natixis CIB in Global Market Business Management Department, liaised with Paris team and local BI team to extract and integrate system data, and consolidate into database, to develop a Power BI application for improving KYC and vetting processes; Served in Midland Realty Ltd IT Data Team, developed ETL process in MS SQL DB, built multiple business areas of TV dashboards and reports in Power BI for senior managers and functional teams, including system analysis dashboard, IT operation customer service report, incoming & outgoing call usage report, P&L report, HR report, etc.

Senior Business & Data Analyst

Zurich Insurance

2020-1 - 2020-5 · 5 mos

Hong Kong

Support to design and build the datawarehouse/datamart models, a centralized repository of integrated data from various data sources and required components, such as ETL processes, reports and dashboards Prepare test plan, test cases/scripts, perform testing and user training Assemble performance statistics, analyze them and make recommendations for improvements

Data Analyst

FWD Insurance

2018-11 - 2019-12 · 1 yr 2 mos

Hong Kong

Build data model and database for MIS reports enhancement and develop visualization reports to optimize Digital Channel performance tracking operation Data tracking for online sales journey, analyzing insurance statistics provided by manufacture, performing market research on online insurance, taking up ad hoc projects as stipulated by manager To perform digital product competitiveness analysis, analyze digital product insurance sales journey for continuous customer journey enhancement and process enhancement

IT Solution Developer

PCCW Solutions

2015-9 - 2018-6 · 2 yrs 10 mos

Hong Kong

Provide IT support for data projects including data warehouse, development of analytics, data extraction, validation and automation of data collection/submission process; Follow existing industry guidelines and help develop best practice for technical documentation, unit testing, performance tuning, data integration testing, and source code version Work closely with cross-functional teams to perform analysis and report Develop data visualization for business reporting, to explore, test and build BI/DS/ML projects and solutions