1. Data Analysis Skills
- SQL:
- Expert in writing complex queries for large datasets, optimising database performance, and creating custom reports.
- Used extensively in roles like Freelance Data Analyst, Media Campaign Scientist, Data Analyst to manipulate and extract meaningful insights.
- Python:
- Advanced proficiency in data manipulation and analysis using libraries like Pandas, NumPy, and Matplotlib. Used for data cleaning, statistical analysis, and predictive modeling.
- R:
- Experience with data analysis and visualisation, especially in statistical methods like regression and clustering. Applied in research projects such as linear regression analysis during my time at Project Oracle, UCL.
2. Power BI Skills
- Data Modeling:
- Built comprehensive data models to analyse key performance metrics and derive business insights.
- Strong ability to manage complex datasets and create effective models.
- DAX & Power Query:
- Extensive use of DAX for calculations and Power Query for data transformation, ensuring accurate and optimised reports for stakeholders.
- Data Visualisation:
- Expert in creating interactive and visually compelling dashboards to communicate data-driven insights. Developed impactful reports in roles at eProspects.
3. Data Management & ETL Processes
- ETL Workflows:
- Designed and implemented automated ETL processes using MS SQL Server and SSIS to efficiently manage data pipelines for reporting purposes at Quant Marketing.
- Data Warehousing:
- Experienced with large-scale data sets (up to 2 million entries) and managing them in platforms like SQL Server, ensuring data integrity and efficiency.
4. Statistical & Predictive Analysis
- Regression Analysis:
- Applied statistical methods like linear regression and logistic regression to build predictive models and provide actionable insights, such as assessing competitor impact on customer behaviour.
- Segmentation & Clustering:
- Conducted customer segmentation analysis to improve marketing strategies and optimise engagement, improving sales performance and customer targeting.
5. Certifications
- Google Analytics for Power Users:
- Advanced understanding of web analytics and how to use them effectively in business decision-making.
- Associate Data Scientist with Python certified by Datacamp:
- Recognised certification highlighting proficiency in data science tools and methodologies.
6. Language Proficiency
- English:
- Fluent – both written and spoken, allowing effective communication with stakeholders and international teams.
- French:
- Intermediate – capable of handling professional communication.
- Korean:
- Native – full fluency in reading, writing, and speaking.