Data Analysis Entry

Victor Kash-Umoru

*****.**@*****.***

SUMMARY

Excel professional with over a decade of experience transforming data into valuable insights. Expertise in creating complex spreadsheets, automating tasks with VBA, and implementing data-driven initiatives to boost organizational effectiveness. Capable of producing high-quality work within a short timeframe.

CORE SKILLS

Excel Proficiency: VLOOKUP, HLOOKUP, INDEX & MATCH, PivotTables, SUMIFS, COUNTIFS, Conditional Formatting

Data Analysis: Data Sorting, Filtering, What-if Analysis, Basic Data Modeling

Automation: Macros, VBA Programming (Basic to Intermediate)

Data Visualization: Excel Charts, Dynamic Dashboards

Other Tools: Power Query, Power Pivot (basic knowledge)

Problem Solving: Strong analytical skills with the ability to debug and troubleshoot complex spreadsheets

Attention to Detail: Accurate data entry and validation, with a focus on maintaining data integrity

EDUCATION

Master of Science in Physics 2013-2015

University of Ilorin, Ilorin, Kwara State, Nigeria

Specialization in Atmospheric and Solar Radiation Physics

Thesis on "Time Series Models for Forecasting Global Solar Radiation".

Bachelor of Science in Physics 2007-2011

Ekiti State University, Ado-Ekiti, Ekiti State, Nigeria

Project on “Natural Radioactivity Measurement of Soil Samples”.

PROJECT & WORK EXPERIENCE

Global Solar Radiation Forecasting Models

MSc Physics Thesis

Developed time series Artificial Neural Network models for predicting global solar radiation for the city of Ilorin, Kwara State, Nigeria. Using meteorological data of rainfall, relative humidity, maximum temperature, and sunshine hours collected from the Nigeria Meteorological Agency (NIMET).

Designed a user-friendly interface with dynamic charts for easy interpretation of Root Mean Square Error (RMSE) values and the Global Solar Radiation forecasted output.

Data Collection, Cleansing and Integration Process

Air Quality Laboratory, Physics Department, University of Ilorin

Conducted collection, cleansing, and integration of air quality data from Air Sampler to prepare data set for analysis.

Applied Power Query to automate data transformation and ensure consistency across datasets.

Documented the data cleaning process and developed guidelines for future data management.

EURUSD Data Analysis and Dashboard Creation

Personal Project

Objective: Analyzed historical data of the EURUSD exchange rate to find trends, correlations, and possible trade signals.

Data Collection: Imported and cleaned a large dataset of historical EURUSD exchange rates from Yahoo Finance.

Data Analysis:

Utilized advanced Excel functions such as VLOOKUP, INDEX & MATCH, and SUMIFS to organize and analyze the data.

Utilized statistical methods such as correlation analysis, standard deviation, and moving averages to find trends and volatility.

Implemented What-if Analysis and Scenario Manager to simulate various market conditions and their impact on the EURUSD exchange rate.

Dashboard Creation:

Created a dynamic dashboard with PivotTables and Excel charts to show important metrics like changes in exchange rates on a daily, weekly, and monthly basis.

Added slicers and interactive charts, allowing users to filter data by specific time frames and visualize the EURUSD trend over different periods.

Integrated conditional formatting to highlight significant currency movements and potential trading opportunities.

Automation: Developed Macros to automate data updates and dashboard refreshes, reducing manual effort and ensuring real-time data analysis.

Outcome: The project provided clear insights into EURUSD exchange rate trends, aiding in the understanding of market dynamics and potential trading strategies.

Freelance Data Manager and Audit Administrator

Youth In View, Desoto, Texas, USA (2020-Present)

Consolidated data from multiple sources into an organized Excel database, ensuring consistency and accuracy.

Utilized VLOOKUP, INDEX & MATCH, and Power Query to link data across spreadsheets and databases.

Developed an audit trail system in Excel to monitor data changes and track user access. Help with data extraction and reports as needed

Automated audit report generation using Macros and VBA, reducing preparation time by 70%.

Created a dynamic dashboard with pivot tables and charts to visualize data quality and compliance status.

Implemented VBA scripts to automate data imports, error checking, and notifications.

Improved data accuracy by 50% and streamlined audit processes for faster, more thorough reviews.

Contact this candidate