Hi, I’m
Cynthia Sophie Wangui Mwangi
Data Analyst
Nairobi,30
Summary
ABOUT ME
I am a result-oriented finance data analyst specializing in financial modeling and data analysis. Proficient in advanced
Excel, DAX language, Power BI, and MS-SQL. I am known for my automation process cutting down manual reporting
in my organization by over 80%, enabling better placement of resources. I have a passion for learning and I am an
effortless team player. My strong attention to detail allows me to quickly assess, and pinpoint, both the threats and
the chances that lie ahead.
Overview
4
years of professional experience
1
Language
Work History
Kingdom Bank Limited
Data analyst
2023.09 - Current (3 education.years_Label & 1 education.month_Label)
Job overview
- City: Nairobi | Country: Kenya | Website: https://www.kingdombankltd.co.ke/
- Model, generate, and analyze Branch P&L statements to provide actionable insights for financial performance
- Conduct feasibility studies for new branch openings, developing financial models to assess profitability, break- even timelines, and key economic/product focus areas for optimal branch performance
- Serve as a report automation specialist and project administrator in the CBK EDW project, coordinating with vendor developers for successful implementation
- Automate stakeholder reporting using advanced DAX in Microsoft Report Builder, Power BI, and Excel VBA, creating interactive dashboards and scheduling reports to minimize manual effort
- Develop quarterly strategy reports to track and align bank performance with annual objectives
- Perform ad-hoc financial analyses, addressing system data inconsistencies and providing critical insights to resolve issues.
Zamara Group Limited
Actuarial analyst intern, Operations and administration intern
2021.07 - 2021.09 (2 education.months_Label)
Job overview
- City: Nairobi | Website: https://zamaragroup.com/
- Reviewed the annual financial statements of the schemes and calculated the year's declared interest
- Reconciled annual contribution, withdrawals and transfers related to each scheme
- Forecasted future performance of pension schemes
- Conducted financial assessments of the schemes.
2023.03 - Current (3 education.years_Label & 7 education.months_Label)
Central Bank of Kenya
2022.06 - 2022.10 (4 education.months_Label)
Job overview
- Credit Risk Prediction using Machine Learning Algorithms
2022.07 - 2022.01 (-1 education.years_Label & -6 education.months_Label)
Job overview
- Terry Traffic Stops Project
- Link: https://github.com/SophieMwangi29/Terry-Traffic-Stops-Project/tree/main
- HOBBIES AND INTERESTS
- Swimming and Chess
- Active member of the Kingdom Bank Swimming and Chess Teams, taking part in the 2023 and 2024 Inter-banks swimming competitions.
Arap Moi Primary School
Volunteer Teacher
2020.08 - 2020.03 (-1 education.years_Label & -5 education.months_Label)
vocational teacher
2024.06 - 2024.06
Job overview
- Mostly with under-privileged and special needs children
- I tutored and examined students in different levels in Math and Science.
2023.03 - 2023.08 (5 education.months_Label)
2023.04 - 2023.10 (6 education.months_Label)
Education
Strathmore University
Bachelor of Business Science from Actuarial Science
07.10/2022
University Overview
strathmore.edu/
Data Science Certification
Moringa School
30.09/2022
University Overview
https://moringaschool.com
Skills
- DIGITAL SKILLS
- Financial Modeling
- Financial Analysis
- MS PowerBI
- Data PreProcessing
- Predictive modeling
- MSSQL Advanced Level
- Microsoft Office ( Word , Excel and Power Point )
- DAX in power BI
Timeline
vocational teacher
2024.06 - 2024.06
Data analyst
Kingdom Bank Limited
2023.09 - Current (3 education.years_Label & 1 education.month_Label)
2023.04 - 2023.10 (6 education.months_Label)
2023.03 - Current (3 education.years_Label & 7 education.months_Label)
2023.03 - 2023.08 (5 education.months_Label)
2022.07 - 2022.01 (-1 education.years_Label & -6 education.months_Label)
Central Bank of Kenya
2022.06 - 2022.10 (4 education.months_Label)
Actuarial analyst intern, Operations and administration intern
Zamara Group Limited
2021.07 - 2021.09 (2 education.months_Label)
Volunteer Teacher
Arap Moi Primary School
2020.08 - 2020.03 (-1 education.years_Label & -5 education.months_Label)
Strathmore University
Bachelor of Business Science from Actuarial Science