EDWIN ANAJEMBA

Data Analyst & Analytics-Focused Operations Professional

About

Highly analytical Data Analyst and Operations Professional with 6+ years of experience transforming complex datasets into actionable insights across diverse industries. Expert in leveraging Excel, SQL, Power BI, and Python for end-to-end data solutions, including advanced AI-assisted analytics workflows. Proven ability to optimize operational efficiency, enhance reporting accuracy, and drive data-backed decision-making for management.

Work

Datadoktor Labs
|

Data Analyst

Remote

Summary

Designed and maintained operational reports and KPI dashboards, supporting internal analytics and client engagements through data preparation and visualization.

Highlights

Applied AI-assisted analytics workflows, including LLMs for data summarization and exploratory analysis, to accelerate insight generation and reduce reporting turnaround times.

Prepared, cleaned, and structured diverse datasets using Excel, Power Query, and Python (pandas), ensuring reliable downstream reporting and analysis for key stakeholders.

Built robust Power BI dashboards with basic data models and DAX measures, visualizing performance trends, delivery metrics, and operational KPIs.

Implemented data quality checks, reconciliation processes, and basic anomaly detection routines, significantly improving reporting accuracy and trust.

Buz and Socials Ventures
|

Business Analyst

Remote

Summary

Led business and operational analysis, supporting program planning, monitoring, and performance reviews through comprehensive data insights.

Highlights

Designed standardized reporting templates, KPI frameworks, and management reporting packs to monitor program outcomes and operational health.

Built Power BI dashboards to visualize performance trends, operational bottlenecks, and key program KPIs, enabling data-driven leadership decision-making.

Automated recurring reports using Python scripts and spreadsheet automation, reducing manual reporting overhead by 30% and improving data consistency.

Defined data collection standards, documentation, and reporting workflows, enhancing data quality and reporting reliability across initiatives.

Prince Ebeano & Co.
|

Inventory Analyst

Nigeria, Nigeria

Summary

Analyzed inventory movement and consumption patterns, optimizing procurement planning, stock optimization, and cost control.

Highlights

Analyzed inventory movement, stock levels, and consumption patterns using Excel models, SQL extracts, and Power BI dashboards to inform strategic decisions.

Built recurring inventory performance reports and BI dashboards, supporting procurement planning, stock optimization, and reducing costs.

Used Power Query and Excel-based reconciliation workflows to align POS exports with inventory records, improving data accuracy by 15%.

Delivered ad-hoc analyses on stock turnover, shrinkage, and reorder cycles, directly supporting operational efficiency and procurement decisions.

Henvok Computer Institute
|

Head of Operations (Part-time)

Nigeria, Nigeria

Summary

Managed operational trackers, attendance datasets, and performance reports to provide management visibility into program delivery metrics.

Highlights

Designed and maintained operational trackers, attendance datasets, and performance reports using Excel and Google Sheets, improving data accessibility.

Built basic Power BI dashboards and visual reports, providing management visibility into enrollment trends, attendance rates, and program delivery metrics.

Standardized operational reporting templates and documentation workflows, enhancing consistency and traceability of program data.

Coordinated short-term training program delivery by tracking milestones, tasks, and resources, ensuring efficient execution using productivity tools.

Professor Iyke Akunakan Community Resource Center
|

Administrative Assistant

Nigeria, Nigeria

Summary

Maintained structured datasets and generated reports to summarize program reach, participation trends, and operational metrics.

Highlights

Maintained structured datasets for participants, attendance, and activities using Excel and shared spreadsheets, ensuring data integrity.

Built recurring activity reports and simple BI visuals to summarize program reach, participation trends, and operational metrics for stakeholders.

Introduced basic data collection templates and documentation standards, improving reporting consistency across programs.

Performed data entry, reconciliation, and validation, ensuring 99% accuracy of records used for management reporting.

AIICO Insurance PLC
|

Industrial Trainee

Nigeria, Nigeria

Summary

Supported data entry, record management, and operational reporting, gaining exposure to corporate reporting workflows.

Highlights

Supported data entry, record management, and operational reporting using Excel-based templates, contributing to efficient data processing.

Assisted in compiling operational summaries, basic performance reports, and documentation for internal teams.

Applied structured data validation and reconciliation processes, improving accuracy of records used in reporting by 10%.

Gained hands-on exposure to corporate reporting workflows, documentation standards, and basic operational analytics processes.

Education

World Quant University
USA, United States of America

M.Sc.

Financial Engineering

Federal University Oye-Ekiti
Oye-Ekiti, Nigeria, Nigeria

B.Sc.

Mathematics

Certificates

Google Data Analytics Professional Certificate

Issued By

Coursera

Data Analysis with SQL & Python

Issued By

Coursera

Power BI Data Analyst Track

Issued By

DataCamp

Advanced Excel for Data Analysis

Issued By

DataCamp

Skills

Data Analysis, BI & Analytics

Microsoft Excel (advanced formulas, pivot tables, Power Query, structured tables), Google Sheets, SQL (PostgreSQL, MySQL, SELECTs, joins, aggregations), Power BI (data modeling, Power Query, basic DAX, dashboard development), Python (pandas for data cleaning and analysis), KPI definition and tracking, Inventory analytics, Operational analytics, Ad-hoc analysis, Trend analysis, Reporting template design, Data Visualization, Business Analysis.

AI, Automation & Modern Analytics

AI-assisted analytics (LLMs for data summarization, insight generation, exploratory analysis), Prompt engineering for analytics workflows, Automated reporting with Python scripts and scheduled jobs, Basic anomaly detection, Data validation and reconciliation automation, Workflow automation for data collection and reporting.

Project Management & Operations

Project coordination, Delivery planning, Milestone and task tracking, Requirements documentation, Process mapping, Stakeholder communication, Execution tracking, Reporting to management.

Productivity, Collaboration & Documentation

Microsoft Office Suite, Google Workspace, Notion/Trello-style task boards, Documentation systems, Shared drives, Versioned reporting assets.