Business Intelligence Analyst

MICHEL BRIAN NGUEGANG

*************@*****.*** 773-***-**** Chicago, IL

LinkedIn: www.linkedin.com/in/michel-brian-nguegang-363130182 GitHub: https://github.com/Michel-Nguegang

SUMMARY

Business Intelligence Analyst with 3+ years of experience turning complex data into actionable insights that improve performance and decision-making. Strong background in SQL, Python, Excel, and BI tools, with a focus on automation, scalable dashboards, and data quality. Experienced partnering cross-functionally across marketing, operations, and revenue teams to drive measurable business impact.

WORK EXPERIENCE

Credico Chicago, IL

Business Intelligence Analyst April 2023 – Present

• Optimized Data Ingestion: Developed Python scripts to transform raw daily sales files into 90-day rolling datasets, reducing SQL database load times by 75% (from 1 hour 30 minutes to 22 minutes) across 15+ retail, insurance, and telecommunication campaigns.

• Enhanced Reporting Efficiency: Built automated Qlik NPrint and Excel reports, including global campaign dashboards for KPIs, heatmaps, and trend analysis, saving Account Managers 20+ hours per week on manual reporting tasks.

• Implemented Critical Alert System: Created a Python-based notification system to monitor Enterprise Data Warehouse failures and discrepancies, sending real-time alerts via Teams and email, improving response times by 100%. This project received commendation from leadership for its impact.

• Streamlined Data Governance: Designed Teams Group Alert system using Python, Teams Webhooks, and SQL queries to identify missing client files, PII violations, and data discrepancies. Developed backend scripts for data wrangling, profiling, and password encryption, enhancing data integrity and security across campaigns. SKILLS

• Data & Analytics: SQL (MySQL, PostgreSQL, BigQuery), Python (Pandas, NumPy, automation), Excel (Power Query, DAX), Qlik Sense / Qlik Cloud, Tableau, Power BI

• Analytics & BI: Dashboard Development, KPI Tracking, Ad-hoc Analysis, Data Validation, Trend & Performance Analysis, Data Storytelling, Marketing & Revenue Analytics

• Data Engineering & Cloud: ETL / Data Pipelines, Data Modeling, Data Quality & Governance, AWS, Relational Databases, APIs & Data Integrations

• Collaboration & Development: Stakeholder Communication, Requirements Gathering, Cross-Functional Collaboration, Git & GitHub

• Languages: English (Native), French (Native), Spanish (Beginner) EDUCATION

The Ohio State University, Max M. Fisher College of Business Columbus, OH Bachelor of Science in Business Administration May 2022

• Specialization: Operations Management GPA: 3.39 Dean’s List, Spring 2021

• Relevant courses: Business Statistics, Business Analytics, Six Sigma, Strategic Management and Operations Planning Professional Certificates

• Google Data Analytics Professional Certificate (Coursera) August 2022

• The Complete SQL Bootcamp: Go from Zero to Hero (Udemy) February 2023

• Python for Finance: Investment Fundamentals & Data Analytics (Udemy)

• Python for Data Science and Machine Learning Bootcamp (Udemy)

• Microsoft Excel: Business Intelligence w/ Power Query & DAX (Udemy) December 2024

• The Business Intelligence Analyst Course 2024 (Udemy)

• AWS Certified Solutions Architect – Associate (Amazon Web Services – AWS) March 2025 PERSONAL PROJECTS

• Google Data Analytics Capstone: Analyzed Divvy bikes data (08/2021–07/2022) using Excel and R to recommend marketing and operational improvements.

• Bank Customer Churn Prediction: Built a Python logistic regression model with oversampling techniques, achieving an 86% recall for predicting customer churn.

• Superstore Sales Analysis: Conducted SQL and Tableau-based analysis to uncover sales and profit trends, optimizing resource allocation and efficiency.

• Additional GitHub Projects: Created stock charts, linear regression models, and deep learning projects.

Contact this candidate