Business Intelligence Solutions

SAMPSON EDIDIONG

Address: Lagos State, Nigeria. Email:************@*****.***

Project Portfolio LinkedIn Profile Phone: +234********** PROFESSIONAL SUMMARY

As an IBM certified data analyst, I have expertise in business intelligence, skilled in collecting, analyzing, and interpreting data to drive informed decision-making. Proficient in MS Office 365, SQL, Power BI, and Python, with a strong background in research and analytics. Demonstrated success in leading teams and generating data-driven insights that contribute to business growth and efficiency. TECHNICAL SKILLS & PROFICIENCY

• Structured Query Language (SQL)

• Power Business Intelligence (BI)

• Power Query Mastery

• Proficiency in MS Office 365 (Power automate, Power BI, DAX, Excel, Macros)

• Research and Analytical skill

• Excellent Written and Verbal communication skill

• Enterprise Resource Planning (ERP) Systems

PROFESSIONAL EXPERIENCE I

Ikeja Distributionc Company – Lagos, Nigeria 04/2024 (Current) Business Intelligence Analyst

• Collect, analyze, and interpret large datasets related to energy delivered, billed and consumed across all Business Units for efficient energy accounting.

• Analyze sales data to Identify trends, patterns, and correlations to inform business decisions and drive strategic planning, resulting in 5 % decrease in ATC&C loss.

• Manage data repository, regularly update data and create a platform that improves data accessibility and ad-hoc reporting which has reduced reporting time by 30 %

• Develop and maintain strategic reports, dashboards, and metrics to measure key performance indicators (KPIs) in tracking SLA around fault clearing activities and repairs, thereby improving operational efficiency by 20%.

• Communicate complex data insights to non-technical stakeholders through dynamic Business Intelligence dashboards such Power BI, Excel and Power point.

• Improved data integrity by implementing data governance principles, reducing data errors by 40%.

Ikeja Distribution Company – Lagos, Nigeria 05/2021 – 04/2024 Energy Sales Analyst

• Lead business analysis on revenue collection, consumer side, and derive insight from data used to inform company decision making deploying Excel and Power BI.

• Reporting and tracking of sales pipeline, trends and performance for over 74 Distribution Transformers (DTs) using macros.

• Supervise non-vending data reports for pre-paid customer across 100 distribution transformers.

• Drive collation of an average of 3,000 first-party data using vital tools such as power query, pivot table, Xlook-up, etc, as well as lead customer segmentation with sort and filter functions.

• Monitor meter behaviour using human machine interfaces (HMI) for data warehousing.

• Improved company revenue collection by 10% by conducting advance metering activities

(energy data aggregation, energy utility analysis, bill determinants and dynamic tariffs).

• Proactively led a team of three, providing scalable solutions and effective strategies that was informed by the insight derived from data which resulted in the recovery of over 5403KWH loss energy and a 12% YoY reduction of energy theft.

Xgo Finance Limited (Xcreditnigeria) – Lagos, Nigeria 02/2021 - 05/2021 SM Data Analyst. - Team Lead

• Drove business decisions by analyzing high performing marketing channels for A/B Testing.

• Analyzed and visualized data for high performing organic campaigns with over 2500 impressions.

• Created weekly dashboards for reporting campaign traffic and overall performance

• Achieved 85% increase in app downloads from insight generated from analytics and customer signup data.

• Drove traffic for inbound marketing using insights from data. Aniera Homes Partners Ltd – Lekki, Lagos, Nigeria

07/2020 - 01/2021

Digital marketing Analyst

• Developed, edited and published engaging content for various social networks, including Facebook, Instagram, and Twitter resulted to follower increase of 51%.

• Prompt response to DM has helped with customer satisfaction.

• Optimized social media posts based on the target audience’s reaction. Access Bank- Oshodi Branch, Lagos. 07/2019 - 01/2020 Transaction Officer

• Executed error-free cash transactions timely to ensure customer satisfaction

• Carried out regular loading of ATM to ensure 24 hours service

• Communicated diplomatically with customers to ensure customer retention

• Performed an average of 200 transactions per day which impacted the bank’s revenue. EDUCATION AND TRAININGS

• IBM Professional Data Science Certificate November, 2022

• SQL for Data Analysis – Udacity December, 2021

• Machine Learning Foundation – Udacity October, 2022

• Design Thinking – UNICEF June, 2020

• Project Management Essentials – MSI April, 2020

Federal University of Uyo, Akwa Ibom State. May 2016 B.Sc. Physics (Second Class Upper Division)

Contact this candidate