Power Bi Data Management

FRANK KEMAJOU

**************@*****.*** // Baltimore, MD 21239 // Frank Kemajou LinkedIn

EDUCATION

Morgan State University (Cum Laude) Sept 2020 - Dec 2024 Bachelor of science, GPA: 3.4/4.0 Baltimore, MD

Coursework: Data Mining, Data Modeling, Data Visualization, Statistical Analysis, ETL Processes SKILLS

● Data Analysis & Visualization Tool: Power BI & Excel

● Data Management System: SQL, PostgreSQL

● Core Competencies: Problem Solving, Critical Thinking, Adaptability

● Languages: Fluent in French and English

PROJECTS

Patient Healthcare Analytics Power BI Fall 2024

● Analyzed 10,000 patient records in Power BI to visualize demographic trends, improving hospital resource allocation by 20% across age and gender groups.

● Built a doctor and hospital performance dashboard tracking 55,000 physicians and hospitals, reducing patient hold time by 15%.

● Created billing and insurance dashboards that revealed 30% cost variation across providers, guiding financial strategy and contract negotiations.

Hospital Readmission risk Power BI Spring 2025

● Analyzed 25,000 healthcare records in Power BI to identify cost drivers of patient readmissions, translating clinical data into financial insights.

● Built a risk-adjusted performance dashboard that quantified a 35% higher likelihood of return visits, similar to credit or insurance risk modeling.

● Designed a financial impact report estimating the monetary burden of readmissions, providing data for budget forecasting and cost control.

Insurance Fraud Detection PostgreSQL Spring 2025

● Built fraud risk reports using joins, aggregates and window functions to flag anomalies across accident areas and vehicle makes

● Designed advanced SQL queries to detect suspicious claims by comparing accidents vs claim dates

● Developed a fraud scoring system with SQL case statements, helping to prioritize fraudulent claims for investigation.

PROFESSIONAL CERTIFICATION

IBM Data Analyst Spring 2025

● Mastered up-to-date practical skills and tools used daily by data analysts.

● Queried census, crime, and school demographic data with SQL to uncover population patterns.

● Completed a capstone project integrating Power BI, SQL, and Excel to showcase end-to-end data analytics skills.

● Gained technical experience through hands-on labs and projects, building a professional portfolio. Microsoft Power BI Bootcamp Fall 2023

● Designed professional dashboards in Power BI aligned with corporate branding and reporting standards.

● Applied dashboard design best practices to deliver clear and executive-ready visuals.

● Conducted real-world business analysis projects such as sales performance tracking.

● Optimized data models for speed, accuracy, and scalability in large datasets. INTEREST

Data Visualization & storytelling, Python (in progress), Data science, Generative AI.

Contact this candidate