David Essien

Data Analyst and Information & Analytics professional with a Computer Science background and hands-on experience turning operational and sales data into dashboards, performance insights, and decision-ready reporting. Skilled in data management, data cleaning, validation, KPI tracking, Power BI, Microsoft Excel, Power Query, SQL, Google Sheets, and data storytelling.

Data Analyst / Sales Data & Business Intelligence at AG Global Resources Service LTD (2025-01 – Present)

Sales Operations focused on tracking and monitoring daily sales performance and automating sales reporting.

• Track and monitor daily sales performance of sales representatives, capturing daily actual sales against assigned targets and commitments.
• Automate Daily, Week-to-Date (WTD), and Month-to-Date (MTD) sales reporting using Excel, formulas, Power Query, PivotTables, and Power BI, reducing manual reporting and improving reporting speed.
• Develop automated sales tracking templates where daily sales entries automatically update WTD and MTD performance for individual sales representatives, products, regions, and other business categories.
• Monitor daily sales achievement against targets, identifying sales representatives and territories that are above or below expected performance.
• Analyse WTD and MTD sales trends to identify performance gaps, growth opportunities, declining sales, and areas requiring management attention.
• Consolidate sales representatives' daily submissions and maintain structured sales records for historical performance tracking and comparison.
• Track key sales performance indicators including sales value, quantity sold, SKU movement, target achievement, sales commitments, and individual sales representative performance.
• Prepare daily and periodic sales performance reports highlighting actual sales, target achievement, WTD/MTD performance, performance gaps, and key business insights.
• Work with sales teams to improve daily sales data submission, accuracy, consistency, and reporting discipline.

Analytics Projects / Portfolio at Independent & Training Projects (2025-01 – 2026-12)

Developed analytical solutions and dashboards using Power BI and Excel with focus on data transformation, modelling, and KPI tracking.

• Developed sales-performance dashboards using Power BI and Excel, including regional, product, retailer, channel, revenue, and trend analysis.
• Performed data transformation and modelling using Power Query, calendar tables, DAX measures, relationships, calculated columns, and KPI logic.
• Built analytical solutions around customer visits, wait times, satisfaction, service costs, payment methods, branch performance, and operational KPIs.
• Worked with large structured datasets to identify duplicates, missing values, inconsistencies, and data-quality issues before visualization.
• Applied SQL concepts including joins, aggregations, views, filtering, conditional logic, and business-oriented analytical queries.

Bachelor's Degree in Computer Science – Akwa Ibom State University (2022)