Mary Kimani

MARY KIMANI Cell Phone: - Email:- Professional Summary Results-driven professional with over 3 years of experience in both data analytics and bookkeeping. Adept at transforming raw data into actionable insights, optimizing financial records, and streamlining business processes. Proficient in SQL, Python, R, Power BI, QuickBooks, Excel, and Google Sheets. Strong background in bookkeeping, financial reconciliation, and administrative support. Proven ability to enhance business efficiency, maintain accurate records, and provide data-driven recommendations. Work Experience IBM – Bookkeeper & Data Analyst (2023 – 2024)  Managed financial records, processed invoices, and ensured accurate bookkeeping using QuickBooks and Excel.  Performed billing reconciliation, cycle billing, and monitored meter changes for accurate financial tracking.  Conducted SQL-based fraud detection analysis, saving the company $500K annually.  Automated financial data pipelines, reducing manual reporting workload by 40%.  Developed interactive dashboards in Power BI to track financial metrics and improve decision-making.  Liaised with vendors and provided customer service support regarding financial inquiries. Coca-Cola – Data Analyst (2021 – 2022)  Designed and optimized Power BI dashboards, reducing reporting time by 30%.  Built predictive models to forecast sales trends, optimizing supply chain operations.  Analyzed customer data to enhance marketing strategies and improve engagement. Freelance Data Analyst – Safaricom & Other Clients (Ongoing)  Provided predictive modeling and customer segmentation services to e-commerce and finance clients.  Developed data-driven strategies using Python and R, leading to increased revenue and retention.  Created custom dashboards and automated reporting tools for business intelligence. Technical Skills      Bookkeeping & Accounting: QuickBooks, Excel, Google Sheets, Financial Reconciliation Data Analysis & Programming: SQL, Python, R Business Intelligence & Visualization: Power BI, Tableau Administrative & Clerical Tasks: Billing Reconciliation, Data Entry, Web Research Customer Service & Vendor Liaison Education Bachelor’s in Data Science/Statistics – The University of Nairobi, 2020 Certified Public Accountant - CPA Certifications    Google Advanced Data Analytics Professional Certificate – 2024 Google Data Analytics Professional Certificate – 2023 QuickBooks Online Certification (In Progress) Projects & Achievements    Built an automated fraud detection model that reduced financial losses by 20%. Developed an interactive sales dashboard for an e-commerce client, boosting conversions by 15%. Successfully maintained accurate bookkeeping records for a major real estate firm, ensuring compliance and financial accuracy. Soft Skills Problem-Solving | Business Acumen | Communication | Critical Thinking | Team Collaboration | Attention to Detail | Organizational Skills Availability: Available full-time, comfortable working in the organisation business hours. Internet & Equipment: Reliable internet (10Mbps+), scanner, printer, and a stable work environment.