Merveille YANDA

As a Business Intelligence Developer at a leading Portuguese data consultancy, I design and deliver end-to-end analytics and reporting solutions that help organizations improve visibility, performance monitoring, and data-driven decision-making. KEY RESPONSIBILITIES & PROJECTS ◙ End-to-End BI Pipeline Development - Design and deploy star/snowflake schemas in Power BI and SQL Server to support complex reporting needs. - Develop and automate ETL workflows using Power Query, DAX, and SQL to ensure reliable data ingestion and transformation. - Optimize data models for performance, reducing report loading times by up to 40% for key client dashboards. - Interactive Dashboard & Reporting Suite - Build real-time dashboards in Power BI for clients in retail, logistics, and services sectors. - Implement dynamic filtering, drill-through pages, and KPIs visualization tailored to business user needs. - Create PDF and Excel automated exports to streamline monthly and quarterly reporting cycles. ◙ Data Quality & Governance - Establish data validation rules and consistency checks across multi-source environments. - Collaborate with IT teams to integrate APIs, cloud databases, and on-premise systems into a unified data warehouse. - Document data lineage and transformation logic to ensure maintainability and compliance. ◙ Client Collaboration & Requirements Analysis - Conduct workshops with stakeholders to translate business needs into technical specifications. - Provide training and support to end-users, empowering them to use self-service BI tools effectively. - Deliver ad-hoc analysis and insights in response to evolving business questions.

As a Business Intelligence Analyst supporting executive leadership, I partnered directly with the CEO and department heads to consolidate business performance across Sales, Marketing, Finance, Logistics, and HR. My role focused on executive reporting, performance management, KPI governance, and decision support through data-driven insights, dashboard development, and reporting automation. KEY ACHIEVEMENTS & BUSINESS IMPACT ◙ Executive Reporting & Performance Management - Designed and maintained the executive performance dashboard consolidating company-wide KPIs across Sales, Marketing, Finance, Logistics, and HR. - Delivered strategic performance reports directly to the CEO and department leaders to support business reviews and decision-making. - Identified performance gaps, growth opportunities, and operational risks through cross-functional analysis. Impact: Improved visibility into business performance and accelerated executive decision-making. ◙ Reporting Automation & KPI Governance - Designed and deployed 25+ interactive dashboards using Power BI and advanced Excel. - Automated monthly reporting processes, reducing report preparation time from 4 days to 2 hours. Impact: Increased reporting efficiency and improved consistency of business performance monitoring. ◙ Commercial Performance & Revenue Protection - Developed sales monitoring and early-warning systems integrating inventory, forecasts, and performance metrics by SKU and region. - Identified sales gaps, stock risks, and revenue leakage indicators. Impact: Helped prevent up to 15% potential revenue losses and improved service level performance. ◙ Geospatial Analysis & Market Expansion - Developed an interactive Excel map visualizing sales and distribution performance across Kinshasa. - Identified underperforming territories and market expansion opportunities. - Impact: Enabled targeted commercial actions that increased market coverage by 18%.

I served as the lead data analyst for a growing e-commerce venture, focusing on CRM optimization, customer behavior analysis, and digital marketing performance. My role centered on transforming raw data into actionable insights to drive customer retention, improve conversion funnels, and maximize ROI across online sales channels. KEY ACHIEVEMENTS & MEASURABLE IMPACT ◙ CRM Optimization & Customer Lifecycle Analysis - Developed and automated customer segmentation models based on purchase history, engagement, and lifetime value (LTV). - Implemented targeted email workflows, increasing customer reactivation rates by 22% and improving repeat purchase frequency. ◙ E-Commerce Performance & Conversion Funnel Analysis - Built interactive dashboards to track key e-commerce metrics: conversion rate, cart abandonment, average order value (AOV), and traffic source performance. - Identified drop-off points in the purchase journey and proposed UX improvements, leading to a 15% reduction in cart abandonment. ◙ Marketing Campaign ROI & Attribution Modeling - Analyzed multi-channel marketing performance (social media, Google Ads, email) to assess ROI and optimize budget allocation. - Introduced attribution modeling to better assign credit to touchpoints, increasing marketing efficiency by 18%. ◙ Product & Sales Insights - Conducted product performance analysis to identify top-selling items, seasonal trends, and inventory recommendations. - Provided insights that supported pricing strategy adjustments, contributing to a 12% increase in margin on targeted product lines.

As the analytical backbone of BNB GROUP DRC’s sales division, I designed and deployed the BI tools and insights that shaped commercial strategy. From territory optimization to incentive alignment, my analyses directly influenced decisions that boosted revenue, improved sales efficiency, and strengthened customer penetration across the region. KEY ACHIEVEMENTS & IMPACT ◙ Sales Performance Intelligence - Developed 15+ interactive Power BI dashboards tracking KPIs across products, regions, reps & channels. - Automated sales reporting, cutting manual work by 70% and ensuring real-time visibility for leadership. ◙ Territory & Channel Optimization - Mapped sales performance geographically to identify high-potential and underperforming zones. - Optimized sales force allocation and channel strategy, boosting regional sales efficiency by 18%. ◙ Incentive & Commission Strategy - Analyzed rep performance to design data-driven incentive plans that increased team productivity by 15%. - Modeled commission schemes aligned with business goals, improving motivation and retention. ◙ Product & Pricing Insights - Conducted margin and volume analysis by SKU, leading to portfolio rationalization and 10% margin improvement. - Supported dynamic pricing strategies based on competitive and demand analysis. ◙ Forecasting & Inventory Alignment - Built sales forecasting models improving accuracy by 25% and reducing stockouts by 30%. - Collaborated with supply chain to align inventory with demand, lowering excess stock by 22%.

Served as a key technical and operational agent for the Independent National Electoral Commission (CENI) during the 2018 electoral cycle. My role was to ensure the integrity, security, and smooth execution of voting operations by setting up, managing, and troubleshooting polling station equipment and materials. KEY RESPONSIBILITIES & CONTRIBUTIONS ◙ Polling Station Setup & Technical Readiness - Installed, configured, and tested voting equipment and materials to ensure full operational readiness before election day. - Organized and verified voter registers, ballots, and electoral kits in compliance with strict CENI protocols. ◙ Operational Integrity & Process Compliance - Applied and enforced electoral procedures and security measures to prevent fraud and ensure a transparent voting process. - Managed the secure handling and sealing of ballot boxes and sensitive electoral documents. ◙ On-Site Technical Support & Problem-Solving - Provided real-time troubleshooting for logistical and technical issues at the polling station. - Assisted voters and election staff with the use of voting materials and verification devices. ◙ Documentation & Reporting - Completed and submitted detailed post-election reports, including voter turnout records and incident logs. - Participated in the reconciliation and archival of electoral materials after the closing of polls. ◙ Context & Impact - Operated in a high-stakes, fast-paced environment requiring precision, neutrality, and adaptability. - Contributed directly to the credibility and transparency of the electoral process in the DRC.