Louange Lidvine
OPEN TO OPPORTUNITIES

Louange Lidvine
Bizimana

Data Analyst Business Analyst SQL Expert Python Frontend Developer

I turn complex data into clear business decisions — using SQL, Python, Power BI, and Excel. I also build fast, modern web interfaces with React and Next.js. Based in Kigali, Rwanda 🇷🇼

About Me

Who I Am

I'm a Data Analyst and Business Analyst with a background in software engineering, currently working at Centrika Ltd in Kigali, Rwanda. I specialize in designing SQL-based data analysis workflows, building interactive Power BI dashboards, and automating reporting pipelines with Python — turning raw operational data into insights that guide real decisions.

Before pivoting fully into data, I worked as a frontend developer and team lead at Rwanda TVET Board, where I led software development teams and built data-integrated systems for monitoring and reporting. That combination of engineering and analytics gives me a rare ability to understand both the technical data infrastructure and the business questions it needs to answer.

I'm driven by a passion for using data to improve public services, healthcare systems, and operational efficiency across Africa. I believe the right insight, delivered clearly, can change how an organization operates. Whether it's a KPI dashboard for an operations team or an automated monthly report, I build things that people actually use.

I'm fluent in English and Kinyarwanda, comfortable working with cross-functional teams, and always learning — currently deepening my Power BI skills and exploring machine learning applications for business forecasting.

2+
Years in Industry
4+
Data Projects
SQL
Advanced Level
2
Companies Led Teams
🇷🇼 Kigali, Rwanda
Open to Remote Opportunities
What I Do

My Core Services

From raw data to business insight, and from wireframe to deployed product — I cover the full spectrum.

📊

Data Analysis & Reporting

I design end-to-end analysis workflows using SQL and Python — from data extraction and cleaning to aggregation, trend analysis, and KPI reporting. I deliver insights that are clear, reproducible, and actionable.

📈

Business Intelligence & Dashboards

I build interactive dashboards in Power BI and Streamlit that give decision-makers a real-time view of performance. I design for clarity — so non-technical stakeholders can read and act on the data.

⚙️

Python Automation & Pipelines

I write Python scripts that automate repetitive reporting tasks — scheduled data extraction, cleaning, transformation, and delivery. I've automated workflows that previously took analysts hours every week.

🌐

Frontend Development

With 2+ years in React, Next.js, and TypeScript, I build performant and accessible web applications. I understand UX, data visualization on the web, and how to connect front-end products to data backends.

Tech Stack

Languages & Tools

The full toolkit I use across data analytics and frontend development — all arranged the way you'd expect.

Data & Analytics
Python Python
SQL SQL
Pandas Pandas
NumPy NumPy
Matplotlib Matplotlib
Seaborn Seaborn
Streamlit Streamlit
Power BI Power BI
Excel Excel
TensorFlow TensorFlow
Frontend & Web Development
React React
Next.js Next.js
TypeScript TypeScript
JavaScript JavaScript
Tailwind Tailwind
HTML5 HTML5
CSS3 CSS3
Node.js Node.js
MongoDB MongoDB
Redux Redux
Svelte Svelte
Flutter Flutter
Tools & Workflow
Git Git
GitHub GitHub
Figma Figma
Postman Postman
Vercel Vercel
Portfolio

Data Analytics Projects

End-to-end projects covering SQL analysis, Python EDA, Excel automation, and interactive BI dashboards — built to demonstrate real business analyst skills.

📊

Sales Business Intelligence — SQL Analysis

A full SQL-based business intelligence project analyzing 2,000+ sales transactions across regions, customer segments, and product categories. Designed to simulate the kind of analysis a DA does weekly at a retail or operations company.

  • 8 analytical queries covering revenue, profit, customer ranking, and growth
  • Window functions: RANK() OVER(PARTITION BY), running totals, cumulative sums
  • CTEs and self-joins for year-over-year revenue growth comparison
  • Discount impact analysis showing how discounting erodes profit margins
  • Results auto-exported to CSV for downstream reporting
SQLSQLite PythonPandas Window FunctionsCTEs
🔎

Retail Exploratory Data Analysis (EDA)

A comprehensive exploratory data analysis on a retail sales dataset. Covers the full analyst workflow — from raw data profiling and cleaning to statistical analysis and business storytelling through visualization.

  • Full data quality audit: missing values, duplicates, outlier detection
  • Descriptive statistics and distribution analysis across all numeric variables
  • Regional, segment, and category performance breakdown with business interpretation
  • Pareto analysis: top 20% of customers drive the majority of revenue
  • Correlation analysis: discount rate vs. profit margin (Pearson r)
  • 6 publication-quality charts saved automatically to the plots/ folder
PythonPandas SeabornMatplotlib EDAStatistics
📁

Automated Excel Report Generator

A Python automation script that replaces hours of manual Excel work — it reads sales data, performs analysis, and generates a fully formatted, publish-ready multi-sheet Excel workbook with one command.

  • 3-sheet workbook: Executive Summary, Monthly Trends, and Raw Data
  • KPI cards showing Revenue, Profit, Margin %, Orders, and Customers
  • Embedded line charts for revenue trend visualization
  • Color-scale conditional formatting on YoY growth (red → green)
  • Auto-filter, frozen headers, and column formatting for readability
  • Report auto-named with date stamp for version control
Pythonopenpyxl Excel AutomationReporting Conditional Formatting
📈

Interactive Business Intelligence Dashboard

A fully interactive BI dashboard built with Streamlit and Plotly — the kind of tool a business analyst would hand to operations managers. Filters drive every chart on the page in real time.

  • Sidebar filters: Year, Region, Category, Segment — all charts respond dynamically
  • 6 KPI metric cards with comparison against overall baseline
  • Dual-axis revenue & profit trend chart (area + bar)
  • Regional revenue bar chart, category donut, segment dual-axis
  • Discount vs. profit scatter with OLS regression trendline
  • Quarterly grouped bar and expandable raw data table
StreamlitPlotly PythonDashboard Interactive
Experience

Where I've Worked

Professional roles across data systems engineering, business analysis, and full-stack development in Rwanda.

2025 — PRESENT
Data Analyst / Data Systems Engineer
Centrika Ltd · Kigali, Rwanda
  • Design and maintain SQL queries to analyze operational and financial datasets across multiple internal systems, enabling data-driven performance reviews
  • Build and maintain Power BI dashboards actively used by operations and management teams to track service delivery KPIs and operational health metrics
  • Conduct regular platform usage analysis to surface trends, anomalies, and actionable opportunities for efficiency improvements
  • Develop Python automation scripts that streamline data extraction, cleaning, and report delivery — reducing manual reporting effort significantly
  • Work cross-functionally with engineering and operations to investigate data discrepancies, improve pipeline reliability, and ensure data quality standards
  • Design and implement the Centrika Reconciliation System — structured data organization and reporting logic for transactional monitoring datasets
2023 — 2024
Team Lead — Software Development & Data Systems
Rwanda TVET Board · Kigali, Rwanda
  • Led a software development team building systems integrated with SQL databases for operational data processing and national education management
  • Designed and deployed monitoring dashboards tracking key system performance indicators and digital service delivery metrics for national stakeholders
  • Conducted platform usage analysis to identify patterns and inform improvements in digital service delivery across Rwanda's TVET ecosystem
  • Architected backend services with real-time data visualization capabilities, enabling stakeholders to monitor system status without technical knowledge
  • Mentored junior developers, conducted code reviews, and established engineering standards across the team
EDUCATION
Diploma in Software Programming & Embedded Systems
Rwanda Coding Academy · Kigali, Rwanda
  • Specialized in software engineering, embedded systems, and full-stack web development
  • Built strong foundations in backend architecture, relational databases, and data processing
  • Developed problem-solving and systems-thinking skills applied throughout professional career
Impact

By The Numbers

A snapshot of what I've delivered across my professional work and personal projects.

2+

Years of professional experience across data analytics and software engineering roles

4+

End-to-end data analytics projects covering SQL, Python, Excel, and interactive dashboards

2

Organizations where data systems and dashboards I built are actively used in operations

10+

Technologies mastered spanning data science, frontend development, and data infrastructure

Contact

Let's Work Together

Open to Data Analyst & Business Analyst Roles

If you're looking for someone who can write complex SQL, build dashboards that stakeholders actually use, automate your reporting workflows, and communicate findings clearly to non-technical teams — I'd love to hear from you.

I'm open to full-time positions, contract roles, and remote opportunities. Don't hesitate to reach out — I respond within 24 hours.

Send Me a Message