Lucy Mbamalu

LUCY NKECHINYERE MBAMALU Email | LinkedIn Professional Profile Results-driven Data and Business Analyst with proven experience in data extraction, transformation, and visualization; operational and KPI reporting; process documentation; and stakeholder engagement. I excel in SQL, Power BI, Excel (Power Query, Macros, PivotTables), and SharePoint. I specialize in building templates, automating workflows, and delivering actionable insights that enhance efficiency, decision-making, and reporting accuracy. Core Competencies SQL Queries • Power BI • Data Analysis • Excel (Power Query, Macros, PivotTables) • Data Visualization • KPI Reporting • Process Documentation • Template Development • Power Automate • SharePoint Management • Workflow Automation • Stakeholder Management • Jira • Confluence • Requirements Gathering • Data Cleaning • Ad-hoc Analysis Professional Experience Business Analyst – Beta Marketplace, Nigeria | Jun 2024 – Present • • • • • Built and maintained Power BI dashboards and Excel KPI reports, enhancing data visibility across 5+ departments. Facilitated requirement-gathering sessions with stakeholders, translating business needs into clear technical specifications. Designed standardized Excel templates, reducing manual formatting work by 25%. Automated approval and reporting workflows using Power Automate, cutting turnaround time from 3 days to 1 day. Managed SharePoint datasets and permissions, ensuring compliance and version accuracy. Project Support Analyst – Beta Marketplace, Remote | Jan 2024 – Jun 2024 • • • • • Delivered recurring operational and performance reports using Excel and Power BI. Documented workflows and reporting processes, reducing reporting errors by 15%. Managed Jira boards to track project deliverables, dependencies, and blockers. Created Confluence knowledge base to support onboarding and process adherence. Collaborated cross-functionally to gather, validate, and analyze data for leadership reporting. Administrative & Data Support Officer – Hipster Investments, Remote | Mar 2024 – Sep 2024 • • • Produced operational reports using Excel PivotTables and advanced formulas. Designed and maintained reporting and correspondence templates for consistent output. Coordinated departmental data requests to ensure on-time reporting. Freelance Data & Business Analyst – Remote | Jun 2021 – Present • • • • Designed and deployed custom Power BI dashboards and automated Excel templates, cutting client reporting time by up to 40%. Developed SQL queries to extract, clean, and prepare datasets for market analysis and KPI tracking. Standardized client reporting workflows with template libraries and Confluence documentation. Implemented SharePoint data repositories with structured permissions to ensure data security and accuracy. Education Master of Science (MSc), Computer Science – Rivers State University, Nigeria (2022) Post Graduate Diploma (PGD), Computer Science – University of Port Harcourt, Nigeria (2018) Bachelor of Science (BSc), Computer Science – Lagos State University, Nigeria (2010) Training & Certifications Data Analysis & Visualization • • • • • SQL for Database Administrators – Aug 2025 (Verify Here) Data Analyst in Python – Jun 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) Business Analysis & Project Management • • • Project Management & Business Analysis Bootcamp – Apr 2025 Business Analysis Masterclass – Mar 2025 (Verify Here) PMP Certification Prep – Feb 2025 (Verify Here)