
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.
- Google Data Analytics
- Associate Data Analyst in SQL
- Data Analyst in Python
- Associate Data Scientist in Python
- Hands-on practice through personal & Kaggle projects
- Watched tutorials on data analysis, SQL, and Python
- Learned practical skills through project-based videos
- Followed industry experts for insights and best practices
- 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
English
Chinese
Korean
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.