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
09.2023 - Current
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
07.2021 - 09.2021
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.
03.2023 - Current
Central Bank of Kenya
06.2022 - 10.2022
Job overview
- Credit Risk Prediction using Machine Learning Algorithms
07.2022 - 01.2022
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
08.2020 - 03.2020
vocational teacher
06.2024 - 06.2024
Job overview
- Mostly with under-privileged and special needs children
- I tutored and examined students in different levels in Math and Science.
03.2023 - 08.2023
04.2023 - 10.2023
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
06.2024 - 06.2024
Data analyst
Kingdom Bank Limited
09.2023 - Current
04.2023 - 10.2023
03.2023 - Current
03.2023 - 08.2023
07.2022 - 01.2022
Central Bank of Kenya
06.2022 - 10.2022
Actuarial analyst intern, Operations and administration intern
Zamara Group Limited
07.2021 - 09.2021
Volunteer Teacher
Arap Moi Primary School
08.2020 - 03.2020
Strathmore University
Bachelor of Business Science from Actuarial Science
Moringa School
Similar Profiles
Fungai ChigundeniFungai Chigundeni
Office Administrator at Allhands Care Nursing Agency (Limited)- Luton United KingdomOffice Administrator at Allhands Care Nursing Agency (Limited)- Luton United Kingdom
Rahul DasRahul Das
Senior Vice President, International Sales at CyanConnode Limited, United KingdomSenior Vice President, International Sales at CyanConnode Limited, United Kingdom
Myra Kemunto MomanyiMyra Kemunto Momanyi
Life Business Lead, Bancassurance at Kingdom Bank Ltd.Life Business Lead, Bancassurance at Kingdom Bank Ltd.
Humphrey Maina MHumphrey Maina M
Network and Programs Coordinator – MEL & Programs at Arigatou International – GNRCNetwork and Programs Coordinator – MEL & Programs at Arigatou International – GNRC
Rosalia NjugunaRosalia Njuguna
Airport Service Agent at Kenya AirwaysAirport Service Agent at Kenya Airways