Lillian Chengwa

Data Analytics Professional with over six years of experience collecting, cleaning, validating, and analyzing complex datasets in banking, donor-funded programs, and corporate environments. Specialized in data transformation, visualization, predictive modeling, and reporting to support evidence-based decision-making. Experienced in Excel, SQL, Python, Power BI, and machine learning tools, with proven ability to extract actionable insights from large-scale financial and operational data.

Skilled in designing automated workflows, standardizing reporting, and ensuring data integrity. Poised to apply this expertise to create robust data pipelines, optimize analytics processes, and deliver high-quality insights that drive strategic and operational decisions in fast-paced, data-driven environments.

Banking and Payment Services Data Analyst - Co-operative Bank of Kenya - Nairobi, Kenya

(2018-04 - 2024-02)

Appointed to collect, clean, validate, and analyze high-volume banking and donor-funded datasets to support financial and operational decision-making. Responsible for producing accurate, audit-ready reports, identifying anomalies and trends, and maintaining data integrity across multiple systems to enable reliable insights and process improvements.

• Collected and analyzed 500+ monthly vendor and staff payment records, implementing multi-level validation checks that identified discrepancies, reduced posting errors, and ensured dataset reliability for decision-making and reporting.
• Developed automated reconciliation workflows in Excel and ERP systems for 150+ mobile money transactions (M Pesa and Popote), reducing reconciliation time from multiple days to same-day completion while improving ledger accuracy.
• Built dynamic dashboards to track 40+ partner advance requests monthly, visualizing fund disbursement trends, highlighting anomalies, and enabling faster managerial decision-making and risk mitigation.
• Conducted trend analyses of withholding tax datasets for 90+ suppliers, identifying recurring inconsistencies, enabling corrective actions, and ensuring full compliance with KRA regulations.
• Managed a SharePoint-based repository of 2,000+ financial records, implementing structured indexing, metadata tagging, and retrieval protocols to improve audit readiness and operational efficiency.
• Generated predictive insights from historical transaction datasets to anticipate fund allocation needs, optimize liquidity management, and identify high-risk transactions requiring closer review.

Finance Data Operations Associate - Kenya Commercial Bank - Nairobi, Kenya

(2017-12 - 2018-04)

Appointed to oversee branch-level financial and operational datasets, including transaction verification, account reconciliations, and reporting. Responsible for maintaining high-quality, accurate data to support operational decisions, minimize errors, and ensure compliance with AML/KYC regulations.

• Verified and processed 300+ weekly financial transactions, performing detailed cross-checks of approvals, documentation, and ledger entries, significantly reducing posting errors and enhancing dataset reliability.
• Reconciled 500+ client accounts monthly, analyzing discrepancies between branch and central records, performing corrections, and documenting reconciliation workflows to ensure accurate reporting.
• Developed daily validation templates for deposits, withdrawals, and internal transfers, standardizing data capture, enabling quick error detection, and maintaining compliance with banking regulations.
• Maintained transaction logs and reconciliation schedules, tracking anomalies and corrective actions to strengthen internal controls and facilitate audit preparation.
• Conducted quality assurance checks on client datasets, identifying inconsistencies, correcting errors, and improving the reliability and completeness of branch-level financial data.

Data Entry and Analysis Clerk – Tax Department - Kenya Revenue Authority - Nairobi, Kenya

(2015-11 - 2016-01)

Appointed to manage tax data entry, validation, and digitization, ensuring fully accurate, audit-ready datasets for regulatory compliance. Responsible for maintaining data integrity, preparing reports, and supporting timely and accurate submission of tax records.

• Entered and validated 2,000+ monthly tax records, performing multi-level checks against payment confirmations and taxpayer documentation to ensure complete accuracy for compliance reporting.
• Prepared audit-ready documentation for 300+ taxpayer files, ensuring consistency, completeness, and standardization to improve audit efficiency and reduce queries.
• Implemented double-entry verification and error-checking processes, identifying and correcting inconsistencies prior to submission, ensuring high data integrity.
• Supported retrieval and analysis of digitized datasets for audits, compliance verification, and internal reporting, reducing response times and improving efficiency.
• Developed data cleaning procedures for incomplete or inconsistent records, improving dataset reliability and facilitating faster, more accurate reporting.

Data Research Assistant – Health Financing Project - Intra Health International - Nairobi, Kenya

(2015-03 - 2015-05)

Appointed to collect, validate, consolidate, and analyze financial and operational datasets from 40+ health facilities to support national health financing analysis. Responsible for ensuring dataset accuracy, standardizing reporting formats, detecting discrepancies, and generating actionable insights for project management and donor reporting.

• Collected and verified financial datasets from 40+ health facilities, reviewing expenditures, revenues, and fund utilization to ensure completeness, accuracy, and standardization across facilities.
• Digitized 500+ financial documents, creating a searchable, indexed repository for reporting, audits, and donor reviews, improving data accessibility and operational efficiency.
• Prepared weekly analytical reports, summarizing expenditure trends, fund allocations, and compliance metrics, providing actionable insights for project management and resource allocation decisions.
• Reviewed 200+ case reports for accuracy, performing recalculations, validating entries against source data, and identifying inconsistencies to ensure dataset reliability.
• Coordinated with field teams to track missing, delayed, or inconsistent data, ensuring timely submission and completeness for analysis and reporting to donors and project leads.

Bachelor of Business Management - Finance & Banking - Moi University (2014)

Proficiency Certificate in Computer Applications - Moi University (2009)