EFFIONG LESLEY AKPAN

Designed and implemented an integrated data management system, combining MS Forms, Power Automate, and Power BI to reduce reporting delays and manual data consolidation by 60%.

Developed KPI-aligned dashboards for Monitoring, Evaluation, and Learning (MEL) reporting across gender justice, education, and livelihoods programs, enabling real-time decision-making.

Strengthened data collection templates and implemented validation rules, reducing reporting errors by 40% and improving indicator consistency across departments.

Trained 30+ staff on data quality, analysis, and dashboard interpretation, increasing internal MEL capacity by 75%.

Processed and analyzed health facility, operational, and performance datasets from 10+ internal and client-facing systems, enhancing reporting accuracy by 30%.

Cleaned and standardized datasets, reducing data errors and inconsistencies by 40% across monthly reports for improved dashboard reliability.

Built and maintained 12+ dynamic dashboards within 2 months of engagement, facilitating leadership reviews and cross-team decision-making.

Developed reporting mockups and templates for quarterly and external partner presentations, ensuring consistent and professional data dissemination.

Introduced new KPIs and refined existing metrics, significantly improving insight quality and monitoring efficiency for program and operations teams.

Integrated SQL Server and external data sources into a unified BI environment, enhancing system security and data integrity for client reporting.

Supported robust ETL pipelines and ensured strict adherence to data governance standards for multi-country datasets.

Delivered advanced training on Power BI, reporting workflows, and analytical best practices for over 50 analysts, improving team capabilities.

Re-engineered existing data workflows, identifying 8+ critical process gaps and improving data accessibility and system efficiency by 30%.

Automated multi-source Excel and SQL workflows, achieving 100% reporting accuracy and cutting processing time by 50%.

Facilitated training for 100+ professionals on segmentation, RFM analytics, and KPI reporting using large-scale datasets.

Delivered Power BI and data literacy training to 50+ staff at the Nigerian Civil Aviation Agency (NCAA), improving visualization competencies by 60%.

Designed and built high-availability, quality database systems using PostgreSQL to support critical business operations.

Provided proactive data management support and comprehensive training to team members on database best practices.

Developed, enforced, and documented robust database policies, procedures, and standards to ensure data integrity and security.

Analyzed data to identify and report potential risks from inadequate procedures, systems, and data handling, informing strategic improvements.

Maintained a central database of employee information and business records, ensuring accuracy and compliance.

Conducted large-scale data audits and successfully recovered over ₦500M in revenue leakage through SQL-based anomaly detection across 100,000+ billing accounts.

Developed SQL dashboards and automated reporting workflows, reducing reporting time from 3 days to under 4 hours.

Ensured data quality and NERC regulatory compliance through monthly QA checks and comprehensive reporting.

Built predictive analytics models for customer payment behavior, increasing forecasting accuracy by 25%.