SHARON WANGECI
Nairobi
Summary
Finance professional with strong analytical skills and results-driven mindset. Proficient in financial modeling, data analysis, and forecasting. Reliable team collaborator, adaptable to changing needs, and consistently focused on achieving organizational goals. Skilled in leveraging financial insights to drive strategic decision-making and enhance performance.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Finance and Data Analyst
MEZIT COMPANY
01.2024 - 12.2024
- Created interactive dashboards and comprehensive reports using Power BI and Excel, and used features like pivot tables and macros to streamline reporting processes, cutting preparation time by 50%.
- Conducted comprehensive market analysis and provided actionable insights, optimizing FMCG marketing and increasing product profitability by 12%
- Produced monthly reports using advanced Excel spreadsheet functions.
- Updated, reconciled and resolved issues with computerized accounting system.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
- Compiled data, reports and year-end audit information.
- Compiled and coordinated financial data for analysis and reconciliation.
- Strengthened internal communication between finance department and other business units, fostering collaboration towards shared objectives.
Finance Assistant
HOUSE OF PROCUREMENT
05.2023 - 12.2023
- Led the transition to a paperless practice by implementing an electronic booking system and a faster using QuickBooks, safer and more accurate business system; reduced cost of labor by 30% and office overhead by 10%
- Analyzed data and used outputs to guide marketing and product strategies, thus effective decision making and 30% in dropoff rate.
- Reconciliation of bank statements and MPESA statements for multiple accounts achieving 100% accuracy
- Financial reporting: employed Power BI to analyze a dataset of bicycle sales, identifying trends in service preferences 30% faster than manual methods.
- Developed financial models that improved forecasting accuracy by 15%, aiding in resource allocation decisions
- Supported the finance team by processing invoices and expense claims promptly and accurately.
- Helped reconcile bank statements and accounts and maintain accuracy and current records.
- Assisted with preparation of monthly financial statements and reports to inform management.
- Supported year-end closing activities, ensuring all transactions were properly recorded before the start of the new fiscal year.
- Minimized risk of errors by accurately processing invoices, payments and other financial transactions.
- Maintained confidentiality of sensitive financial information, safeguarding both company data and client privacy.
- Collaborated effectively with cross-functional teams to resolve any financial discrepancies or irregularities.
- Reduced discrepancies in accounts receivable by closely monitoring customer payments and following up on overdue balances.
Education
Diploma - Applied Statistics
TECHNICAL UNIVERSITY OF KENYA
01.2023
Skills
- Advanced in Python, and R programming,
- Microsoft Power BI,
- Proficient in MATLAB,
- Tableau software
- Data modeling
- Data mining
- Data visualization and presentations
- Data analysis
- Python programming
- Excel functions
- Analytical problem solving
Certification
- CPA level 1
- Online Data Science Course in Worldquant University
- Great Learning Power BI certificate
- Certificate in datacamp
Languages
Fluent in English and Kiswahili
Timeline
Finance and Data Analyst
MEZIT COMPANY
01.2024 - 12.2024
Finance Assistant
HOUSE OF PROCUREMENT
05.2023 - 12.2023
Diploma - Applied Statistics
TECHNICAL UNIVERSITY OF KENYA
Similar Profiles
Yvonne BaahYvonne Baah
NA at Dameba Company Limited, Display and Bargain Company Limited Quizno’s Restaurant Company Limited Soft Company Limited, Courtesy International HotelNA at Dameba Company Limited, Display and Bargain Company Limited Quizno’s Restaurant Company Limited Soft Company Limited, Courtesy International Hotel
ALPHA VANGAHUNALPHA VANGAHUN
Geologist at A-TO-Z OIL RIGS & FACILITIES Maintenance Company (Subsidiary company For Al-Masafi)Geologist at A-TO-Z OIL RIGS & FACILITIES Maintenance Company (Subsidiary company For Al-Masafi)
AHMED ALKHAIRANIAHMED ALKHAIRANI
Website & Operations Manager at Mersa Group Company&ON2 CompanyWebsite & Operations Manager at Mersa Group Company&ON2 Company
Kyle Temple-MurrayKyle Temple-Murray
Managing Director at NADSKA LtdManaging Director at NADSKA Ltd
MACKLYNE IMARYMACKLYNE IMARY
Customer Support Expert at TeleperformanceCustomer Support Expert at Teleperformance