Open to opportunities

Joy Lorna

@joylorna

Message

Junior Data Analyst skilled in SQL, Tableau, Power BI and Excel, turning data into actionable business insights.

Kenya

Message

What I'm looking for

I seek a collaborative team role where I can apply SQL, Tableau and Power BI to solve business problems, build dashboards, and drive measurable operational improvements.

I am a results-driven junior data analyst with a Google Data Analytics Professional Certificate and over three years of customer-facing finance and operations experience across hospitality, finance, and consulting.

I specialize in data cleaning, modeling, KPI development, and interactive dashboards using SQL, Excel (pivot tables, Power Query), Tableau and Power BI, and I have delivered insights that improved operational efficiency and governance.

I am passionate about predictive analytics, business intelligence and data visualization, and I bring strong stakeholder communication, problem-solving, and a focus on measurable impact to forward-thinking teams.

Experience

Work history, roles, and key accomplishments

Junior Data Analyst

Ridge Cabin Resort

Aug 2025 - Dec 2025 (4 months)

Developed Excel dashboards and reporting to anticipate customer needs and align operations with service KPIs, improving guest satisfaction and operational efficiency. Streamlined issue resolution and prepared accurate reports to support data-driven decisions.

Excel Pivot Tables Dashboards Data Cleaning Reporting KPIs Data Visualization Power Query

Finance Officer

Flero Traders Limited

Mar 2024 - Jul 2025 (1 year 4 months)

Built real-time Excel dashboards and automated POS data workflows to track sales and supply chain KPIs, enhancing operational efficiency by 25% and improving data governance. Provided actionable sales insights to leadership for strategic planning.

Excel Dashboard KPI Tracking Data Governance Sales Reporting SQL

Accountant

Truestone Mines Limited

Aug 2023 - Jul 2025 (1 year 11 months)

Produced monthly financial and operational reports using Excel models to support compliance-focused planning and strengthen stakeholder trust. Managed confidential communications with auditors and suppliers and improved document governance for timely decision-making.

Financial Reporting Excel Modeling Compliance Reporting Data Governance Stakeholder Management

Financial & Research Analyst Intern

Agusto & Co.

Mar 2025 - Apr 2025 (1 month)

Prepared data-driven reports and presentations to strengthen client engagement and accelerate internal reviews, improving responsiveness and client satisfaction. Produced preliminary findings and maintained cross-functional communication to align project priorities.

Data Analysis Reporting Statistical Analysis SQL Presentation Stakeholder Management Excel

Finance Assistant

Mgeni Online Limited

Feb 2023 - Jul 2023 (5 months)

Translated financial data into simplified reports using Excel pivot tables, improving internal stakeholder understanding and accelerating decision-making. Responded to team queries and supported operational clarity through clear data communication.

Excel Pivot Tables Financial Reporting Internal Communications

Tax & Financial Advisory Intern

Viva Africa Consulting LLP

Feb 2022 - Jun 2022 (4 months)

Coordinated client engagement and prepared executive summaries supported by financial data analysis to accelerate advisory delivery. Ensured timely client communication and contributed to efficient tax advisory processes.

client support Financial Analysis Executive Summary Data Presentation Excel

Finance & Compliance Volunteer

Kangemi Resource Center

Jan 2020 - Mar 2020 (2 months)

Coordinated stakeholder communication and supported schedule management while leveraging structured data reporting to improve service response times and documentation consistency.

Data Reporting Stakeholder Management Documentation Scheduling Community Engagement

Education

Degrees, certifications, and relevant coursework

Google via Coursera

Professional Certificate, Data Analytics

Activities and societies: Capstone projects involving data cleaning, visualization, statistical analysis, and business intelligence reporting.

Completed the Google Data Analytics Professional Certificate covering end-to-end data analytics workflows, Excel, SQL, Tableau, Power BI, and a capstone project.