SERVANT JOHNN
Oakland,CA
Summary
Results-driven Data Analyst with 5+ years of experience leveraging SQL, Python, Power BI, and machine learning techniques to extract insights, optimize business decisions, and automate workflows. Expertise in data modeling, predictive analytics, dashboard development, and ETL pipelines with a proven track record in insurance risk analytics (Aon) and healthcare data management (Kaiser Permanente).
Overview
6
6
years of professional experience
Work History
Data Analyst
Aon
San Francisco, CA
01.2023 - Current
- Designed and optimized SQL queries to extract risk analytics data, improving query performance by 40%
- Built interactive dashboards in Power BI for risk assessment, reducing data reporting time by 60%
- Developed predictive models using Python to forecast insurance claim trends, enhancing decision-making
- Automated ETL workflows using Apache Airflow, reducing manual data processing efforts by 50%
- Implemented data warehousing solutions (Snowflake, AWS Redshift) to centralize insurance claims data, increasing data accessibility
- Created data pipelines in SQL & Python for real-time processing of financial and risk data
- Developed interactive dashboards in Tableau and Power BI to visualize key performance metrics, enabling stakeholders to make data-driven decisions
- Conducted data cleansing and preprocessing using Pandas & NumPy, improving data accuracy by 30%
- Led A/B testing initiatives, analyzing the effectiveness of risk models and optimizing actuarial models
- Built an anomaly detection system using machine learning (isolation forests, k-means clustering) to detect fraudulent claims
- Integrated Google Analytics API to track website traffic and customer engagement trends
- Managed big data processing with Spark & Databricks, analyzing large-scale customer data
- Created self-service dashboards with DAX functions in Power BI, allowing non-technical users to explore insights independently
- Conducted data security and compliance checks (GDPR, HIPAA, CCPA) to ensure adherence to regulatory policies
- Partnered with actuarial teams to optimize Monte Carlo simulations for risk forecasting
- Presented data-driven recommendations to C-level executives, leading to a 15% improvement in risk mitigation strategies
- Collaborated with cross-functional teams to define data requirements and ensure data accuracy and consistency
Data Analyst / Tableau Developer (Junior)
Kaiser Permanente
Oakland, CA
06.2019 - 12.2022
- Designed and maintained SQL databases for patient records, optimizing query execution time by 45%
- Built Tableau dashboards for real-time hospital performance monitoring, reducing reporting errors by 30%
- Developed machine learning models for patient readmission predictions, increasing prediction accuracy to 85%
- Automated data extraction from electronic health records (EHR) using Python APIs (FHIR, HL7 standards)
- Created ETL pipelines (Apache Airflow, Alteryx) to automate data flow from multiple sources
- Conducted trend analysis on patient satisfaction surveys using NLP techniques, improving response categorization accuracy
- Implemented data governance frameworks to ensure compliance with HIPAA, GDPR and CCPA regulations
- Developed predictive models to assess disease risk factors, improving early intervention strategies
- Performed statistical analysis to identify correlations and trends in customer behavior
- Supported the implementation of a new data governance framework, improving data quality by 25%
- Designed a real-time alerting system for abnormal patient vitals using Python & IoT integration
- Conducted cohort analysis on patient populations using SQL window functions & Python
- Created data visualizations for executive leadership, driving a 20% increase in operational efficiency
- Developed custom Power BI reports with DAX measures, providing physicians with real-time patient insights
- Built automated scheduling algorithms for patient appointments, reducing scheduling conflicts by 35%
- Used Google Big-Query & AWS S3 for large-scale healthcare data storage and analysis
- Provided ad hoc SQL queries to support clinical research teams, accelerating data retrieval processes
Education
Bachelor’s Degree - Education, Mathematics
University of Education Winneba
01.2011
Skills
- SQL
- MySQL
- MySQL Server
- Python
- Pandas
- NumPy
- Matplotlib
- Power BI
- Tableau
- Google Data Studio
- Excel
- ETL Pipelines
- Data Warehousing
- Snowflake
- Redshift
- BigQuery
- Alteryx
- Apache Airflow
- Power Query
- Predictive Analytics
- Regression
- Spark
- Hadoop
- Databricks
- AWS
- S3
- Lambda
- Google Cloud
- Business Intelligence
- SQL-based dashboards
- KPI Metrics
- Financial Reporting
- HIPAA
- GDPR
- CCPA
- SOC 2
- Data quality
- Data storytelling
Education Certifications
- Bachelor’s Degree in Education, Mathematics, University of Education Winneba, 2011
- Tableau Desktop Specialist, 2021
- AWS Certified Practitioner, 2022
- AWS Certified Solution Architect- Associate, 2023
- CompTIA Security +, 2024
- Microsoft Certified Security Fundamental, 2024
- Professional Cloud Security Engineer, 2024
Technical Skills
SQL (MySQL, MySQL Server), Python (Pandas, NumPy, Matplotlib), Power BI, Tableau, Google Data Studio, Excel, ETL Pipelines, Data Warehousing (Snowflake, Redshift, BigQuery), Alteryx, Apache Airflow, Power Query, Predictive Analytics, Regression, Spark, Hadoop, Databricks, AWS (S3, Redshift, Lambda), Google Cloud (BigQuery), SQL-based dashboards, KPI Metrics, Financial Reporting, HIPAA, GDPR, CCPA, SOC 2
Timeline
Data Analyst
Aon
01.2023 - Current
Data Analyst / Tableau Developer (Junior)
Kaiser Permanente
06.2019 - 12.2022
Bachelor’s Degree - Education, Mathematics
University of Education Winneba