Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Karen Fang

Sydney,NSW

Summary

Dynamic and results-driven Data & Insights Analyst with extensive experience in data analytics and interactive BI reporting. Proficient in Power BI and SQL, with a strong track record of delivering actionable insights that drive sustainable business growth.

My experience at global retailer market research company has honed my strong business acumen and customer-centric thinking, enabling me to leverage data to address complex business challenges and stakeholders’ needs.

Skilled in collaborating with cross-functional teams and engaging stakeholders to define requirements and deliver scalable reporting solutions.

With a background in practical analytics skillsets, experiences and a passion for storytelling through data, I excel at transforming raw data into meaningful strategies.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Data and Insights Analyst

CBAA
04.2024 - Current
  • Develop and maintain Power BI dashboards and interactive reports for strategic planning, KPI monitoring, advocacy, marketing, customer relationship, and product management purposes. Integrate dataflows from Salesforce and optimise pipelines using Power Query, Microsoft Azure, and Databricks for seamless analytics.
  • Manage research projects, conducting surveys and designing focus groups to gather and analyse data. Present findings to leadership, incorporating historical data to present trends into Power BI reports.
  • Collaborate with third-party data partner and consultant to ensure data quality and drive project success through effective stakeholder management.
  • Serve as a key point of contact for addressing client queries about data products, providing guidance to ensure optimal use of insights and tools.

Data Consultant

Happen Coffee
01.2024 - Current
  • Lead data analytics and business intelligence for eCommerce, integrating data from multiple sales channels for strategic decision-making and comprehensive visualisation.
  • Conduct detailed customer behaviour analysis, deriving actionable insights to enhance engagement and loyalty in a small-scale business environment.
  • Collaborate with the team on product strategy, employing sales data and customer feedback to guide pricing and product mix decisions, with a keen eye on seasonality and purchase context.
  • Initiate the integration of AI tools in marketing and operations, focusing on technology-driven optimisation and business growth.

CRM & Survey Manager

Carrefour
03.2021 - 02.2022

· Managed a team with 7 team members, responsible for external and internal data analysis, insights generation, and application.

· Monitored company performance with member sales data analysis, customer experience evaluation, and competition status.

  • Developed CRM campaigns including customer loyalty program and customer acquisition campaigns.
  • Effectively enhanced targeting strategies by implementing advanced segmentation and personalised content, leading to increased targeting accuracy, campaign effectiveness and customer engagement.
  • Organised and piloted customer experience digital transformation projects: initiated 3 innovative in-app functionalities, including e-receipts, e-coupons and digital collection campaigns.
  • Conducted category shopper analysis in collaboration with suppliers for new product launches, successfully driving trial purchases and enhancing engagement with the new brand and product line.

Quantitative Research Manager

The Nielsen Company
05.2013 - 02.2021
  • Served 30+ clients from FMCG, retailer, catering and healthcare industries and was responsible for producing high-quality market research reports meeting the client's research objectives.
  • Developed research plans and proposals to address clients' business questions or objectives.
  • Coordinated with 3 internal departments to ensure on-time delivery with the best quality.
  • Conducted quarterly internal training sessions to coach junior analysts on company product/solution knowledge.

Education

Master of Commerce - Computer Information Systems

The University of Queensland
Brisbane, QLD
12-2023

Master of Communication - Radio And Television

National Chengchi University
Taipei, Taiwan
07-2009

Skills

  • Market research and consultancy
  • Data analytics and business insights
  • Information systems management
  • Stakeholder engagement and communication
  • Data Visualization: Power BI
  • Data Transformation: Power Query
  • Data Analysis tools: SPSS, Google Analytics, Alchemer, RapidMiner
  • Programming Languages: SQL, Python
  • Process modeling: SAP Signavio

Certification

  • Coursera Generative AI with Large Language Models, 11/2023
  • Edx/Databricks Large Language Models: Application through Production, 08/2023
  • Google Analytics Certification (GA4), 05/2023
  • Google Ads Display Certification, 04/2023
  • Google Ads Search Certification, 04/2023

Timeline

Data and Insights Analyst

CBAA
04.2024 - Current

Data Consultant

Happen Coffee
01.2024 - Current

CRM & Survey Manager

Carrefour
03.2021 - 02.2022

Quantitative Research Manager

The Nielsen Company
05.2013 - 02.2021

Master of Commerce - Computer Information Systems

The University of Queensland

Master of Communication - Radio And Television

National Chengchi University
Karen Fang