Data Analyst Power Bi

Yemi Ogunleye

Detroit, MI

Summary:

Data Analyst with expertise in transforming complex workflows into actionable insights.

Proficient in Python, SQL, Power BI, Tableau, and AWS/Azure for data modelling and visualization.

Has generated real-time reports and dashboards in ServiceNow to provide actionable insights for leadership and support data-driven decision-making.

Has developed comprehensive dashboards and reports in Power BI to visualize pricing trends, performance metrics, and the outcomes of pricing strategies.

Has deployed SQL-driven queries to identify infrastructure vulnerabilities, improving system reliability.

Used Excel Sheets, flat files to generate Tableau ad-hoc reports.

Excellent communication and problem-solving skills.

Areas of Expertise:

Data Analysis & Visualization (Tableau, Power BI, ERP System Table)

SPSS Tools

MS PowerPoint

Predictive Modelling & Statistical Analysis

Process Automation (Python, ServiceNow)

Outstanding mathematical and analytical skills.

Cross-Functional Collaboration & Stakeholder Reporting

Ad hoc reporting using SQL Coding

Datawarehouse and Data Pipeline

Python (Pandas, NumPy)

SQL

Azure Synapse

Excel/Sheets

Education/Certification:

Bachelor of Science, Computer Information Systems & Cybersecurity -University of Detroit, Detroit, MI.

Associate of Arts - Wayne County Community College, Detroit, MI.

Google IT Support – Technical Support Fundamentals Certificate.

Professional Experience:

ExcelMindCyber 01/2024 to 01/2025

Data Analyst

Analyzed compliance trends using SQL and Python, identifying 95% of potential violations and reducing query resolution time by 30%.

Perform data analysis to identify trends, patterns, and correlations by %80.

SQL Query Optimization & Database Management Built Python scripts to automate log analysis, ensuring 100% adherence to evolving GDPR and HIPAA standards.

Developed comprehensive dashboards and reports in Power BI to visualize pricing trends, performance metrics, and the outcomes of pricing strategies.

Presented this data to the business stakeholders to identify trends and opportunities for the improvement using ServiceNow Reporting.

Used Excel Sheets, flat files to generate tableau ad-hoc reports.

Designed Tableau dashboards to track compliance KPIs, enabling real-time stakeholder decision-making.

Creating Dashboards and Enhancements to existing dashboards on Power BI.

Work closely with data entry teams and other analysts and stakeholders to ensure data integrity 80%.

Generated real-time reports and dashboards in ServiceNow to provide actionable insights for leadership and support data-driven decision-making.

Woodward & Midland M/MRT 10/2022 to 11/2023

Data Analyst

Spearheaded enterprise data assessments using Python to model threat probabilities, reducing data irregularities.

Deployed SQL-driven queries to identify 50+ infrastructure vulnerabilities, improving system reliability by 40%.

Analyzed phishing simulation data (Tableau), correlating training participation with a drop in employee susceptibility.

Gather, clean, and organize large datasets from various sources %35 using Analytical skill.

Administered and customized ServiceNow modules (e.g., Incident, Problem, Change Management) to align with organizational processes and compliance standards.

Designed and developed interactive Power BI dashboards and reports, enabling stakeholders to visualize key metrics and make data-driven decisions in real time.

Contact this candidate