Learn Data Skills
Beta

Adejoke Fajemilo

Quality assurance analyst

UKHSA

Technologies

My Portfolio Highlights

My New Project

Introduction to Notebook Projects

My New Project

Introduction to Notebook Projects

Quantitative magician, conjuring valuable knowledge from data spells.

My Work

Take a look at my latest work.

project

Analyze International Debt Statistics

course

Joining Data in SQL

DataLab

Project: Analyze International Debt Statistics

project

Analyze International Debt Statistics

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Azure Fundamentals- AZ 900

Microsoft Azure Data Fundamentals- DP 900

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Introduction to Power BI
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

United Kingdom Health and Security Agency | Nov 2021 - Present

Data & Compliance Analyst

As a Data & Compliance professional at UKHSA, I build an interactive dashboard to deliver real-time insights, ensure adherence to GDPR and NHS data standards, analyze health records to identify trends, and implement predictive models to enhance efficiency, compliance, and public health outcomes. • Built end-to-end data pipelines and interactive dashboards using Power BI and SQL, providing real-time insights into customer service metrics like CSAT, NPS and response time across multiple service lines and response time, reducing SLA breaches by 25%. • Designed and implemented a data compliance monitoring framework to align with GDPR and NHS data standards, reducing compliance breaches by assessing the adherence of customer service representatives to established standards, resulting in a 20% improvement in compliance scores. • Developed and optimized SQL scripts to query and analyze over 10 million health records, uncovering key trends in disease outbreaks. This analysis led to a 20% increase in proactive interventions, improving response times and public health outcomes. • Presented actionable insights and visualizations to senior stakeholders, driving a 10-point increase in team engagement. Collaborated with IT and customer service to integrate tools like Zendesk and Tableau, enhancing reporting and reducing manual time by 40%. • Applied machine learning models to predict recurring customer issues, allowing for proactive resolutions that reduced complaint volumes by 20% and streamlined the support process, leading to faster issue resolution and a more efficient workflow.
Show More

Orleeman Finance LTD | Sep 2019 - Nov 2021

Business Intelligence Analyst

As part of the Data & Reporting team, I design and deliver secure, scalable Power BI solutions, integrate complex data models, and generate actionable insights to drive cross-departmental collaboration, improve decision-making, and optimize organizational performance. • Use the Built comprehensive reports using Power BI Desktop by connecting to various data sources such as Excel, SQL Server, Oracle Database, Salesforce, and online sources, generating over 100+ actionable insights monthly that informed key management decisions and optimised performance across departments. • Designed and implemented Row-Level Security (RLS) to ensure secure, tailored data access for over 300+ users, improving data governance and reducing unauthorized access by 40%. • Led the development and publication of 50+ Power BI reports to centralized workspaces, facilitating cross-departmental collaboration. This initiative reduced report sharing time by 50%, leading to more timely and informed decisions. • Collaborated with cross-functional teams to design and implement Star and Snowflake Schemas, linking over 100+ tables in the data warehouse to improve data modelling and reporting. This led to a 35% reduction in data processing time and improved scalability as data volume increased. • Created and delivered KPI dashboards that monitored key business drivers, providing actionable insights that improved decision-making and contributed to a 10% increase in revenue through better resource allocation.

SIU Medicine Center for Rural Health and Social Service Development | Sep 2017 - Aug 2018

Research Assistant

- Developed educational materials and programs for community agencies, utilizing data analysis to tailor content to specific needs. - Maintained databases and managed information to support the effective operation of health education programs. - Prepared and submitted materials for research funding to agencies and foundations. - Created a substance use pocket guide template for Southern Illinois region counties, and assisted with meeting preparation, leveraging data insights. - Collected and analyzed information on community health needs in the Southern Illinois region. - Researched data sources and updated data sets for the Southern Illinois Healthcare Community Health Needs Assessment. - Developed and administered community surveys, applying data analysis techniques to interpret results. - Assisted with Southern Illinois University Medical Reserve Corps community outreach events, using data to optimize event planning and outcomes. - Evaluated the effectiveness of counseling and educational programs for the Egyptian Area Agency on Aging, using data-driven methods. - Performed administrative duties, including report completion, with a focus on data accuracy and presentation.

My Education

Take a look at my formal education

Masters in Public Health in Public Health and Health EducationSouthern Illinois University | 2018

About Me

I’m a passionate data analyst skilled in SQL, Python, and BI tools, I specialize in identifying trends and creating visualizations that support data-driven decision-making. Let’s connect and explore how I can contribute to your data analytics needs!

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free