| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLESUMMARYExcel 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 SKILLSExcel Proficiency: VLOOKUP, HLOOKUP, INDEX & MATCH, PivotTables, SUMIFS, COUNTIFS, Conditional FormattingData Analysis: Data Sorting, Filtering, What-if Analysis, Basic Data ModelingAutomation: Macros, VBA Programming (Basic to Intermediate)Data Visualization: Excel Charts, Dynamic DashboardsOther Tools: Power Query, Power Pivot (basic knowledge)Problem Solving: Strong analytical skills with the ability to debug and troubleshoot complex spreadsheetsAttention to Detail: Accurate data entry and validation, with a focus on maintaining data integrityEDUCATIONMaster of Science in Physics 2013-2015University of Ilorin, Ilorin, Kwara State, NigeriaSpecialization in Atmospheric and Solar Radiation PhysicsThesis on "Time Series Models for Forecasting Global Solar Radiation".Bachelor of Science in Physics 2007-2011Ekiti State University, Ado-Ekiti, Ekiti State, NigeriaProject on Natural Radioactivity Measurement of Soil Samples.PROJECT & WORK EXPERIENCEGlobal Solar Radiation Forecasting ModelsMSc Physics ThesisDeveloped 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 ProcessAir Quality Laboratory, Physics Department, University of IlorinConducted 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 CreationPersonal ProjectObjective: 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 AdministratorYouth 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 neededAutomated 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. |
