Open To Work
Kester Ikechukwu
Work Preference
Summary
Results-driven Data Analyst with expertise in SQL, Python, and dashboarding. Focused on operational analytics, capacity modeling, and transforming semi-structured data into actionable insights for improved workflows and resource allocation. Skilled in analyzing operational workflows and supply-demand balance to enhance staffing and efficiency, while developing Tableau dashboards and SQL models that significantly reduced decision-making and query execution times.
Overview
5
5
years of professional experience
Work History
Data Analyst Consultant
10Alytics
10.2025 - Current
- Modeled advocate capacity and throughput using SQL and Python, producing staffing scenarios that improved resource forecasting accuracy by 30% and enabled operations to staff ahead of demand spikes.
- Curated and validated data models with engineering, authoring dbt-styled SQL transformations and data quality checks that reduced data inconsistencies by 25% and increased trust in analytics.
- Curated and validated data models with engineering, authored dbt-styled SQL transformations and implemented data quality checks, reducing data inconsistencies by 25% and enhancing trust in analytics.
- Processed semi-structured and nested JSON datasets to extract event-level signals for workflow analysis, improving match-quality measurement and decreasing investigation time by 40%.
- Synthesized complex analyses into concise operational recommendations and dashboards presented to senior operations leaders, resulting in the adoption of two process changes that reduced average case resolution time by 22%.
Data Analyst
10Alytics Inc
02.2025 - Current
- Optimized SQL queries and data pipelines, reducing query execution time by 35% while processing multi-million row datasets and improving ETL reliability.
- Automated ETL processes and implemented data validation checks, lowering data entry and reporting errors by 25% and accelerating monthly close processes.
- Established standardized reporting frameworks and SLA-driven dashboards to track advocate workflows and utilization, enhancing operational visibility and reducing over/under-staffing events by 18%.
- Automated ETL processes and implemented data validation checks to lower data entry and reporting errors by 25%, accelerating monthly close processes.
- Partnered with finance and operations to translate analytics into capacity plans and pricing insights, supporting a 10% uplift in resource allocation efficiency.
Data Analyst
10Alytics Inc
01.2023 - 01.2025
- Led A/B testing and causal analysis for product features, translating results into prioritized operational changes that increased engagement by 10%.
- Applied regression and time series methods to operational datasets to improve forecasting accuracy by 15%, supporting inventory and staffing planning.
- Led A/B testing and causal analysis for product features, translating results into prioritized operational changes that increased engagement by 10%.
- Built customer churn models and retention reports that contributed to a 15% reduction in churn via targeted operations interventions.
- Utilized SQL to transform and join semi-structured event and transactional datasets, enabling comprehensive operational analysis.
Business Intelligence Analyst (EMEA Region)
Company Name
01.2022 - 12.2022
- Delivered cross-functional BI dashboards and KPI reports supporting EMEA operations, contributing to a 10% revenue increase through data-driven strategic recommendations.
- Translated technical findings into concise presentations for senior leadership, facilitating two strategic initiatives that achieved a 12% reduction in operating expenses.
- Analyzed business data to deliver actionable insights supporting strategic decision-making and performance improvements.
- Developed interactive dashboards and reports using BI tools to track key operational and financial trends.
- Collaborated with stakeholders to define reporting requirements and translate business needs into scalable analytics solutions.
Education
BEng - Civil Engineering
University of Port Harcourt
Port Harcourt,Ng01-2015
Skills
Core Skills: Data Visualization
Data cleaning
Python programming
ETL development
Data validation
Data analysis
Business needs analysis
Data formatting
Workflow analysis
Technical Analysis
Timeline
Data Analyst Consultant
10Alytics
10.2025 - Current
Data Analyst
10Alytics Inc
02.2025 - Current
Data Analyst
10Alytics Inc
01.2023 - 01.2025
Business Intelligence Analyst (EMEA Region)
Company Name
01.2022 - 12.2022
BEng - Civil Engineering
University of Port Harcourt