Skill set
Industry fields of expertise
Hyesoo in a few words
A data analyst with a background in retail and digital marketing. Skilled in data manipulation, visualisation and regression analysis. Proficient in SQL, Python, R, and Power BI. Enjoys synthesis of her business acumen gained during her two master’s degrees and coding skills to help create unique and successful business solutions.
• Data manipulation with MS SQL server
• Visualisation & reporting with Power BI
• Statistical analysis and Machine Learning with R, Python
• Microsoft Office Tools
• Fluent French, Native Korean
- Projects
- Digital marketing: Reporting of leads generation / Ad-hoc analysis
- Retail: Competitor Analysis / Food Analysis / Forecasting / Segmentation Analysis / Sales dashboard
- Master's degree: Research Report using Random Forest Analysis with R studio / Dissertation using logistic regression analysis with R studio
Experience
- FreelancerData Analyst (Freelance)September 2024 - Today (7 months)London, UK• Freelancing for eProspects• Cleaning and transforming raw data using SQL and loading it into Power BI• Analysing campaign performance and media buying strategies, tracking Key Performance Indicators (KPIs)• Developing and maintaining interactive dashboards in Power BI, eabling data-driven decision-making
- E-prospectsMedia Campaign ScientistAugust 2019 - March 2020 (7 months)London, UK• Optimised SQL queries to extract and manipulate data from multiple sources• Analysed media campaigns' effectiveness, media buying strategies and tracked KPIs• Created interactive and visually impactful quality Power BI reports to track KPIs, monitoring the quality of reports• Provided recommendations for decision-making with regards to campaign optimisation and business strategy• Presented analysis results to internal stakeholders, ensuring clarity and alignment with objectives
- Quant MarketingData AnalystMay 2018 - August 2019 (1 year and 3 months)London, UK• Designed and implemented the data Extract, Transform, Load (ETL) workflow, automating data processing using MS SQL Server Integration Services (SSIS)• Analysed IKEA's marketing campaign effectiveness, tracked sales KPIs• Developed comprehensive dashboards in Dundas BI, using SQL to pull large datasets (up to 2 million entries) from the company's data warehouse• Monitored and improved the dashboards' quality• Conducted segmentation and predictive analysis, providing insights into customer behaviour and contributing to improved engagement• Built a predictive model using logistic regression to assess competitor impact on customer purchasing patterns• Delivered strategic recommendations, leading to measurable improvements in campaign performance
Recommendations
Education
- Master of ScienceUCL2017MSc
- Global MBAYonsei University2015Global MBA
- Bachelor of ArtsU of Minnesota - Twin Cities2012BA Economics •