Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ehizojie Martins Obodeh

NEWARK

Summary

Results-driven professional with 6+ years of experience in Data Reporting and Analysis. Proficient in Microsoft applications, including Word, PowerPoint, and advanced Excel (Pivot Tables, VLOOKUP, Macros, Access). Skilled in data cleaning, visualization, statistical analysis, and SQL for data extraction and manipulation. Adept at analyzing results and communicating insights to stakeholders. Experienced in handling complex datasets, collaborating with internal and external clients, and supporting Business Analysts in gathering development requirements. Quick learner with expertise in Power BI/Tableau dashboard creation.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Analyst

Alpha Wire
05.2024 - Current
  • Expertly support and manage day-to-day purchasing operations
  • Create and update Purchase Orders, generate and manage Invoices, and conduct data analysis
  • Strategically managing new vendors and existing vendor relationships for all indirect materials, services, and equipment
  • Gather and consolidate data from various sources, inventory databases, and supply chain management tools
  • Maintain and update databases to ensure data accuracy, consistency, and reliability
  • Develop and produce Reports/DASHBOARDS in excel and Power BI, making visualizations and analysis using VLOOKUP, Pivot Tables, Power Query and other formulas to communicate findings and insights to stakeholders
  • Work with supply chain, logistics, finance, and production teams to understand data needs and provide analytical support
  • Collaborate with IT and data management teams to ensure data integrity and system integration

Data Analyst

Allied World Insurance
02.2021 - 12.2023
  • Developed visualizations and dashboards from extracted reports using Power BI Desktop
  • Gather raw data to generate different essential reports using MS Access, MS Excel, and Power BI
  • Document weekly meetings with internal and external Stakeholders
  • Interacted with Business Analyst, SMEs, and other Data Architects to understand Business needs and functionality for various project solutions
  • Create Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas
  • Assist Business Analysts in gathering requirements for Development purposes
  • Created Graphs for Spread Sheets and MS Access Reports
  • Created Power BI Dashboards to present critical company data in a single report
  • Imported data from pre-existing text files and Excel spreadsheets

Senior Media Reporting Analyst

SBI Media
04.2018 - 01.2021
  • Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas for business needs
  • Facilitated meetings among providers and internal teams to ensure proper understanding and clarification of special projects
  • Implemented planning modules to streamline the team’s media planning process, resulting in faster delivery time for requested media plans
  • Staff training on media star applications including station rankings, reach, GRPs, frequency and data translation
  • Provide technical guidance to programs in monitoring methodologies, good practice, and reporting responsibilities
  • Developed reports in Excel and Access from datasets as per business needs
  • Delivering end-to-end account management from brief to closure – strategy, plan, implementation follow-up, compliance and reconciliation, invoicing, payment from client and closure reports
  • Data migration and Data validation/Testing through MS Access and MS Excel
  • Maintained the MS Access database for the purpose of extracting reports
  • Developed interactive Microsoft Excel dashboards for presentations purpose

Strategy Analyst/ Consumer Planner

Intercontinental Distiller Limited
02.2016 - 03.2018
  • Data Collection and business insights generated that feed business planning, budgeting, and forecasting so that customers will more effectively manage and optimize their financial goals and strategies
  • Reporting to the Marketing Intelligence Manager on various reports
  • Assisted in execution of market research by supervising commissioned Agency(s) for Ad-hoc projects
  • Continuously generate database for competitive intelligence across available Wines and Spirits
  • Created Excel based report and Analysis Bi-weekly, Monthly, Quarterly and Annually to establish measures for Branch Marketers, Business Managers KPIs
  • Created Intuitive Dashboards and Power-point presentations, using Excel and Microsoft Access
  • Generated the necessary power BI reports and Interacted with Business Analyst, SMEs, and other Data Architects to understand Business needs and functionality for various project solutions
  • Monitor and analyze market share trends, sales volumes, and competition
  • Generate reports on brand performance, sales, and all marketing projects
  • Maintained the MS Access database for the purpose of extracting reports
  • Assist in Digital Marketing execution, Market analysis, Data Analysis (pivot) MS Excel, Market Segmentation, and Product Marketing

Education

Bachelor of Science - Industrial Chemistry

Bowen University

Skills

  • Power BI
  • Power Query
  • SQL Server
  • Data Analysis
  • Dashboard Creation
  • Database Management
  • Data visualization and presentations
  • Excel functions (Pivot Table, VLOOKUP etc)
  • Analytical problem solving
  • Statistical analysis
  • Attention to detail

Certification

  • Power BI Business Analyst Certified
  • Statistical Analysis Certified
  • Certified MS Excel Professional
  • Dynamic NAV

Timeline

Data Analyst

Alpha Wire
05.2024 - Current

Data Analyst

Allied World Insurance
02.2021 - 12.2023

Senior Media Reporting Analyst

SBI Media
04.2018 - 01.2021

Strategy Analyst/ Consumer Planner

Intercontinental Distiller Limited
02.2016 - 03.2018

Bachelor of Science - Industrial Chemistry

Bowen University

Similar Profiles

CREATE PROFILE
Ehizojie Martins Obodeh