A lone silhouette stands beneath a crescent moon and starry sky, evoking a sense of solitude and wonder.

Get to know my background in education, diverse work experience, continuous data learning, certifications, skill development, and the problem-solving mindset that shapes my work.

Welcome to Roy's Data World

🎓 Bachelor’s Degree in Accounting – China, 2011

🎓 Master’s Degree in Marketing – Massey University, New Zealand, 2019

Education Background

💼 Marketing Specialist & Lighting Designer – LEDFocus (2019 – 2024)

  • Analysed customer, product, and sales data to uncover trends and improve marketing strategies.
  • Researched competitor products to inform pricing, features, and positioning strategies.
  • Created Excel-based reports and dashboards to present business insights to leadership.
  • Managed website content, UX, and design to maintain a strong online presence.
  • Designed and managed company website(ledfocus.co.nz).
  • Executed segmented email campaigns to boost customer engagement and retention.
  • Developed custom 3D lighting designs and VR visualisations for client presentations.
  • Delivered end-to-end product training for customers and staff, combining theory with hands-on installation guidance to ensure successful product adoption.

💼 Project Assistant – Yanji Urban Construction Bureau (2013 – 2017)

  • Supported project research, evaluation, and the development of construction plans.
  • Coordinated with government departments to ensure project approvals and regulatory compliance.
  • Managed project documentation and budgets, maintaining strict control over costs and timelines.
  • Mediated communication between government entities and the public to resolve disputes.
  • Drafted, reviewed, and filed contracts and legal documents for real estate projects.
  • Oversaw development and certification for two residential complexes.
  • Organised regulatory documents and processes to ensure full legal compliance.

💼 Internal Trainer & HR Planner – KIA Motors Co., Ltd. (Yueda KIA), Jiangsu, China (2011 – 2013)

  • Developed and delivered employee training programmes aligned with internal goals and skill gaps.
  • Conducted training needs analysis and introduced new channels for onboarding and development.
  • Coordinated job fairs and supported recruitment across departments based on annual workforce planning.
  • Reviewed and refined training content, lecture evaluations, and internal communication processes.
  • Published monthly internal newsletters to share updates and improve team alignment.
  • Recognised as “Excellent Employee of 2012” for performance during overseas training initiatives.
  • Pioneered partnerships with foreign training institutions to improve programme effectiveness.

Previous Work

Data Learning & Certifications

Youtube Channels​

These are some of the top YouTube channels I use for learning Data Analytics, Python, SQL, Power BI, and other useful theories and tools. They provide hands-on tutorials, real-world projects, and industry insights to enhance my skills.

techTFQ

SQL, SQL Project, Case Study

Alex The Analyst

SQL, Python, Excel

DATAtab

Statistics

Data with Decision

Power BI, DAX

Absent Data

SQL & Power BI Project

Python

Coursera
  • Google Data Analytics
DataCamp
  • Associate Data Analyst in SQL
  • Data Analyst in Python
  • Associate Data Scientist in Python
Projects
  • Hands-on practice through personal & Kaggle projects
YouTube
  • Watched tutorials on data analysis, SQL, and Python
  • Learned practical skills through project-based videos
  • Followed industry experts for insights and best practices
ChatGPTChatGPT
  • Used for quick explanations, coding help, and concept clarification
  • Helps generate ideas, debug code, and summarize complex topics
  • Acts as an interactive tutor for learning new skills


📊
Key Takeaways

☑️ Gained strong foundational knowledge from structured courses
☑️ Improved practical skills through hands-on projects
☑️ Used YouTube for real-world applications and expert insights
☑️ Leveraged ChatGPT for instant explanations and debugging

I have a strong curiosity for technology and a passion for exploring a wide range of software and applications. Through my previous work in digital marketing, training, and design, I gained hands-on experience with various tools. Many of these skills were developed through self-learning and seamlessly applied to my daily work, allowing me to adapt quickly and solve problems with creativity and efficiency.

My Skills

SQL Server

Python

Excel

Power BI

Azure

Kaggle

Data & Analytics

VS Code

GitHub

Development Tools

Photoshop

Illustrator

After Effects

CapCut

Creative Design

SketchUp

3ds Max

AutoCAD

3D & Architecture

Canva

Notion

PowerPoint

Productivity & Workflow

WordPress

Shopify

Web Design & Management

MailChimp

Google Analytics

Semrush

Marketing

Web Designer 75%
Web Designer 70%
Web Designer 75%
Web Designer 80%
Web Designer 50%
Web Designer 90%
Web Designer 70%
Web Designer 50%
Web Designer 90%
Web Designer 60%
Web Designer 70%
Web Designer 90%
Web Designer 80%
Web Designer 50%
Web Designer 70%
Web Designer 90%
Web Designer 70%
Web Designer 90%
Web Designer 80%
Web Designer 50%
Web Designer 80%
Web Designer 50%
Web Designer 50%
Language Skills

English

0%
Fluent Proficiency

Chinese

0%
Fluent Proficiency

Korean

0%
Fluent Proficiency
Problem-Solver

Finds creative and efficient solutions to challenges.

Independent & Self-Motivated

Thrives in self-learning and executing ideas.

Efficiency-Driven

Always looking for ways to automate and improve processes.

Persistent & Resilient

Doesn't give up on challenges; always finds a solution.

Results-Focused

Measures success based on impact, not just effort.

Innovative & Curious

Constantly exploring new ideas, tools, and techniques.

Fast Learner

Quickly adapts to new tools, concepts, and challenges.

Adaptable & Flexible

Adjusts quickly to new situations and technologies.

Personality Traits

Email

roylee7493@gmail.com

Call Me

02108087493

Let’s Connect!