LUCY NKECHINYERE MBAMALU
PROFESSIONAL SUMMARY
Analytical and detail-oriented Data & Business Analyst with 4+ years designing automated, nocode solutions that streamline operations and empower small businesses. Expert in translating
complex data into actionable insights using Excel, SQL, R, Power BI, and Airtable. Proven track
record delivering dashboards, financial models, and reporting solutions that boost operational
efficiency by up to 40%. Skilled in stakeholder engagement, process optimization, and turning
business challenges into scalable, data-driven solutions.
WORK EXPERIENCE
Business Analyst & Project Coordinator
Beta Marketplace, PH, Nigeria | Jan 2024 – Present
•
•
•
•
•
Facilitated JAD sessions and gathered requirements for digital product rollouts, aligning
teams and accelerating project delivery.
Developed functional specifications, user stories, and process maps in Visio and
Lucidchart, streamlining workflows and improving cross-department efficiency.
Coordinated expansion initiatives across 36 states, increasing market penetration by 20%
and improving operational reach.
Supported CRM system implementation, training 30+ staff and enhancing efficiency by
25%.
Conducted market analysis and contributed to project documentation for strategic growth
planning, informing data-driven decisions.
Property Data Manager
Hipster Investments (Remote) | Mar 2024 – Sep 2024
•
•
•
•
Automated property inventory workflows, reducing errors by 30% and saving staff time.
Improved listing data quality and visibility, boosting engagement by 30%.
Maintained data consistency through Excel-based audits and validation routines, ensuring
reliable reporting.
Designed standardized reporting templates, improving team communication and decisionmaking speed.
Freelance Data & Business Analyst
Upwork | Jun 2021 – Present
•
•
•
Designed and deployed 20+ analytical dashboards (Power BI, Excel, Looker Studio),
reducing client reporting time by up to 40%.
Conducted data cleaning, transformation, and validation using Excel, SQL, and R,
ensuring accurate insights for business decisions.
Built and deployed custom no-code tools (inventory, sales, forecasting, payroll, and
performance trackers), enhancing operational efficiency for small businesses.
•
•
Collaborated with global clients to define requirements, create workflow documentation,
and optimize business processes, improving project delivery speed and clarity.
Leveraged R (dplyr, ggplot2, lubridate) and SQL to perform marketing and performance
analytics, identifying trends and actionable insights that informed client strategies.
SKILLS
Data Analysis & Reporting: Excel (Power Query, Macros, PivotTables, LOOKUPs), SQL,
Power BI, Tableau, Looker Studio
Business Analysis: JAD Sessions, Requirements Gathering, User Stories, Functional
Documentation, Stakeholder Engagement
Process Improvement: Process Mapping (Visio, Lucidchart, Axure), Workflow Automation
(Power Automate, Macros)
Project Management Tools: Jira, Trello, Asana, Freedcamp, Microsoft Project, Project Libre
Programming: R (lubridate, dplyr, ggplot2), Python (Pandas, NumPy)
Data Quality & Governance: Data Validation, ETL, Quality Assurance, Data Cleansing
EDUCATION
Master of Science (MSc), Computer Science – Rivers State University, Nigeria
Bachelor of Science (BSc), Computer Science – Lagos State University, Nigeria
PROFESSIONAL DEVELOPMENT & TRAINING
•
•
•
•
•
•
•
Data Analyst in Python, Jun 2025 (Verify Here)
Project Management & Business Analysis Bootcamp (Digitech Business School, London),
Apr 2025
Business Analysis Masterclass, Mar 2025 (Verify Here)
PMP Certification Prep, Feb 2025 (Verify Here)
Google Data Analytics Certificate, Oct 2022 (Verify Here)
SQL for Joining Data, Aug 2022 (Verify Here)
Intermediate SQL Queries, Jul 2022 (Verify Here)
TECHNICAL PROJECTS
1. SQL Data Cleaning & Exploration (View Project 1 | View Project 2)
Description: Executed full SQL-based data cleaning, transformation, and exploratory
analysis to prepare datasets for actionable insights.
Tools Used: SQL, Microsoft SQL Server, CTEs, Aggregate Functions, JOINS, String
Functions, CASE Statements, GROUP BY, ORDER BY
Value: Delivered analytics-ready datasets and insights that improved reporting accuracy and
supported data-driven business decisions.
2. R Marketing Analysis Report (View Project)
Description: Conducted end-to-end analysis of Cyclistic’s bike-share dataset using R,
including data cleaning, visualization, and trend identification.
Tools Used: R (dplyr, ggplot2, lubridate, tidyverse), R Markdown, Data Visualization,
Statistical Analysis
Value: Provided actionable insights that informed marketing strategies and improved
customer retention.
3. Sales & Inventory Tracker (View Project)
Description: Built automated Excel sales and inventory trackers using formulas, dropdowns,
and conditional logic.
Tools Used: Excel, Formulas (IFs, VLOOKUPs, SUMIFS), PivotTables, Data Validation,
Conditional Formatting
Value: Helped small business clients manage stock levels, reduce manual errors, and
improve financial visibility.
4. Airtable Inventory Management System (View Project)
Description: Designed multi-store inventory system in Airtable with SKU automation, realtime stock updates, and low-stock alerts.
Tools Used: Airtable, Formulas, Automations, Linked Records, Rollups, No-Code Design
Value: Improved inventory accuracy and operational visibility, reducing manual updates and
discrepancies by over 25%.
5. Income Statement Template (View Project)
Description: Developed Excel-based income statement with automated revenue, COGS, and
expense calculations and dynamic reporting.
Tools Used: Excel, Power Query, SUMIFS, Data Validation, Conditional Formatting
Value: Simplified financial tracking, saving users time and ensuring accurate profit reporting.
6. Sales Forecast Dashboard (View Project)
Description: Built Excel forecasting dashboard using historical data and trend formulas to
project future sales and revenue growth.
Tools Used: Excel, Forecast Functions, Charts, Slicers, PivotTables, Power Query
Value: Enabled business owners to anticipate demand, plan budgets effectively, and make
data-driven decisions.
