Sofia Han

Data Analyst with proven expertise in SQL, Python and Power BI, combining analytical skills with business needs to transform data into actionable insights. Experienced in applying statistical methods and machine learning techniques to solve business problems across finance, marketing, and supply chain domains.

SKILLS 

Data Analytics: Excel, SQL, Python, Power BI and Tableau for data analysis, visualization, and reporting. Statistical Analysis: Statistical inference, sampling techniques, hypothesis testing, experiment design, exploratory data analysis, A/B testing. 

Business Intelligence: Dashboard development, KPI tracking, performance metrics, data visualization best practices. 

Machine Learning: Classification, regression, clustering, feature selection, dimensionality reduction, natural language processing, time-series analysis. 

Database Management: relational databases, data warehouse design, ETL, SQL Server, NoSQL, MongoDB, data quality, functions, triggers, store procedures, normalization, query performance, transactional data and error handling. 

Domains Expertise: Marketing analytics, supply chain analytics, financial analytics, healthcare analytics (portfolio available on GitHub). 

Soft Skills: Project leadership, communication, problem-solving, bilingual (English and Portuguese). 

PROFESSIONAL EXPERIENCE 

Data Scientist, British Airways January 2025 – April 2025 British Airways Job Simulation Program 

● Conducted sentiment analysis on customer feedback using Python to identify key satisfaction drivers. 

● Applied web scraping techniques to collect customer reviews from Skytrax for analysis. 

● Utilized natural language processing with word vectorization techniques including bag-of-words, TF-IDF, and ngrams. 

● Created a logistic regression model to classify sentiment with clear identification of terms related to positive and negative experiences. 

● Delivered insights on customer satisfaction factors that could inform service improvement strategies. 

Data Scientist, BCG X January 2025 – March 2025 BCG X Job Simulation Program 

● Analyzed customer churn for an energy company using Python and implemented a random forest classification model. 

● Achieved 80% precision in identifying customers likely to remain but faced challenges with 5% recall for potential churners. 

● Identified opportunities for improved feature engineering to enhance model’s ability to capture churn patterns. 

● Presented findings with emphasis on business impact and recommended strategies for customer retention. 

Data Analyst, Reckitt Benckiser Group June 2020 – May 2023 Sao Paulo | Brazil 

● Managed and analyzed approximately 500,000 monthly price transactions using JDE ERP system from Oracle.

● Created financial reports and budgets for performance analysis with focus on data accuracy and completeness. 

● Identified a $200,000 P&L risk due to system failure and implemented a data validation solution. 

● Developed metrics to assess business impact and risk through data-driven approaches.

EDUCATION 

Post-Degree in Data Analytics for Business September 2023 – April 2025 St. Clair College | Windsor, Canada 

● 3 Academic Distinction badges, 1 Honor badge for exceptional performance 

● Received 2 Scholarships for Academic Excellence 

Bachelor’s in Chemical Engineering March 2017 – December 2022 Federal University of Sao Carlos | Sao Paulo, Brazil 

• Ranked top 5 best engineering schools in Brazil. 

CERTIFICATION 

Data Analyst in Power BI (Microsoft) 2025 

Database Management (DataCamp) 2025 

Data Scientist (BCGX) 2025 

Data Scientist (British Airways) 2024 

Cloud Practitioner (AWS) 2024 

Agile Fundamentals (LinkedIn) 2023