Learn Data Skills
Yoan Stoyanov

Yoan Stoyanov

-

-

Technologies

My Portfolio Highlights

My New Course

Intermediate SQL

My New Course

Data Analysis in Excel

My New Course

Intermediate Python

My New Course

Intermediate SQL

Mindful analyst, decoding patterns to unravel the big picture.

My Work

Take a look at my latest work.

track

Excel Fundamentals

course

Data Manipulation in SQL

course

PostgreSQL Summary Stats and Window Functions

course

Functions for Manipulating Data in PostgreSQL

course

Introduction to SQL

course

Intermediate SQL

course

Joining Data in SQL

course

Introduction to Excel

course

Data Preparation in Excel

course

Data Visualization in Excel

course

Data Analysis in Excel

course

Case Study: Analyzing Customer Churn in Excel

course

Introduction to Python

course

Intermediate Python

track

Excel Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

SolarBotanic Trees | Feb 2025 - Present

Head of Operations

• Led operational processes across marketing, CRM, website management, content strategy, and investor relations, reporting directly to the CEO and CPO • Built and managed content strategy across 8 platforms (LinkedIn, Bluesky, Threads, TikTok, YouTube, Instagram, Facebook, X/Twitter), expanding SolarBotanic Trees’ digital footprint • Grew LinkedIn following by 20%+ in 4 months • Directed LinkedIn ad campaigns across multiple creatives, achieving a combined 37500+ impressions with a 1.02% CTR, generating qualified inbound leads • Designed investor pitch decks, product brochures, email templates, and sales approaches, supporting investor engagement and business development • Maintained the WordPress website, improved UX and optimised for SEO, driving +120% impressions and +40% clicks via Google Analytics, Search Console, and Ahrefs • Conducted data analysis using marketing metrics, produced investor reports and shareholder updates, and organised client and partnership meetings to support growth and strategy execution • Introduced a new content calendar for social media and implemented HubSpot CRM, Jira, and Notion to streamline operations, marketing, and reporting
Show More

Bloomcoding | Jul 2022 - Sep 2023

Country Manager

• Hired and trained all the teams, growing the Bulgarian Branch to over 20 people • Created and standardised the data tracking systems across different branches, to create actionable insights for senior management • Created and maintained Branch P/L, as well as quarterly revenue and performance forecasts • Managed all teams, ensuring a high sales conversion rate, low client churn rate and high employee retention • Hosted weekly department meetings with Sales, Customer Success and HR departments to address and eliminate bottlenecks • Weekly reporting to C-level team

AIESEC in Denmark | Jul 2022 - Jan 2023

Member of The Board of Advisors - AIESEC in Aalborg

Advising the Executive Board of AIESEC in Aalborg on strategy and organisational development.

AIESEC in Denmark | Jan 2021 - Jan 2023

Member of the Board of Advisors - AIESEC in Copenhagen

Advising the Executive Board of AIESEC in Copenhagen on strategy and organisational development.

AIESEC in Denmark | Apr 2021 - Jun 2022

Business Process & Operations Analyst

• Analysed operational processes for all departments and local branches to optimise processes at every level in the organisation • Created analytical tools to benchmark performance and establish trends, identify bottlenecks and suggest areas in need of improvement • Provided data-driven insights in decision-making to the Board of Directors to support with change management and implementation of national strategy • Optimising processes at every level of the organisation • Drove increase in domestic rollout of global policies and standards from 56% to 98% • Co-organised and facilitated 4 national conferences for 100+ delegates

AIESEC | May 2021 - Jul 2021

Global Steering Team - Membership Experience Product

Part of a small unit working directly under AIESEC International to help steer the direction and innovation of the Membership Experience Product for AIESEC globally, and downscaling product details and processes to the global membership.

AIESEC in Moldova | Nov 2020 - Jul 2021

National Director - Talent Management & Organisational Development

• Managed National Recruitment / Onboarding / Retention campaign for over 70 members • Implemented HubSpot CRM, LinkedIn pages, a new data management system and knowledge hub for a smoother onboarding • Facilitated culture design for both Local Committees • Implemented and facilitated a national conference cycle leading to increased organisational health, improved internal synergies, education, and engagement • 2 Global Compliance awards from AIESEC Internal Control Board for 'Board Development' and for 'Customer Support'

AIESEC in Denmark | Jan 2020 - Jan 2021

Governance & Compliance Officer

• Co-ordinated over 25 National Legislative Meetings • Revamped all the National By-Laws and supporting documents of the association to maintain compliance with Global standards • Created the Local Compendia of By-Laws for 3 Local Committees. • Increased efficiency by implementing new templates and time-saving methods for legislation

AIESEC in Denmark | Oct 2019 - Jan 2021

Branch Manager

• Initiated and executed a merger of the Copenhagen branches, managing the legalities and logistics, as well as ensuring a smooth transition for all stakeholders • Developed and grew the organisation during a Global Pandemic from 9 to over 40 members • Led an Executive Board of 6, managing their personal and professional development • Hosted weekly strategic meetings, monthly and quarterly progress reviews with the Sales and Customer Service teams • Organised and facilitated 2 Local Induction Conferences for 40+ people

IVY | Sep 2019 - Jan 2020

Founder

In collaboration with SEA and the AAU Incubator. Worked in the Startup in Practice (SiP) programme as part of my internship for my Master's degree - a short term and hands-on project to create a company. Project IVY - An alternative energy solution.

AIESEC in Denmark | Feb 2019 - Oct 2019

Head of Sales

• Grew sales by 280% on the previous year • Contributed to a new record and a national award • Implemented new strategies, tools and materials • Laid the foundations for a new project, to open new markets and further increase growth of the department by 300% over the following 2 years

AIESEC in Denmark | Sep 2018 - Jan 2019

Account Manager

Focused on exploring alternative market segments and new ways to grow the Incoming Global Volunteer team. Supported the Outgoing Exchange team as main responsible for an outreach event for the Danish market - raising awareness of our exchange product as well as general brand awareness.

Fine Tutors | Sep 2017 - Jun 2018

GCSE Maths and Science Tutor

N/A

Waterstones | Mar 2016 - Jun 2016

Bookseller

N/A

My Education

Take a look at my formal education

Master of Science (MSc) in Technology in Entrepreneurial Engineering and Business InnovationAalborg Universitet | 2020
Bachelor of Science (BSc) (Hons) in Physics with Theoretical PhysicsKing's College London | 2017
International Summer School 2017 in Information TechnologyBeihang University | 2017
Associateship of King's College (AKC)  in TheologyKing's College London | 2016
International Summer School 2016  in Chinese Language and CultureRenmin University of China | 2016
Summer School in PhysicsUniversity of Leicester | 2012

About Me

Yoan Stoyanov

Experienced Analyst with a background in Theoretical Physics and Business Innovation.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free