JOHN EMMANUEL OKON

Data-Analyst

**, ****** ****** *****, ********. Lagos-State. Nigeria.

+234********** ad33ic@r.postjobfree.com

http://www.linkedin.com/in/john-emmanuel-646bb4166

https://www.novypro.com/profile_projects/jizzytycoon

PROFESSIONAL PROFILE

An highly organized, communicative, effective and efficient data analyst with up to date knowledge and understanding of data analysis with a 9-months valuable training that grew my knowledge of SQL, Excel and power bi. Seeking an opportunity as a data analyst, which will enable me to make positive contributions to improve data conversions and process improvements in your organization.

EXPERIENCE

Working at MeriSKILL (Virtual Data Analyst Intern)

Started December 2023 --- Present

Utilized power bi and MySQL statistical software to track and analyze data

Optimized data collection procedures and generated reports on a weekly, monthly and quarterly basis

Used advanced Microsoft Excel and the VLOOKUP function to efficiently create pivot tables and pivot reporting

SUMMARY

At my present role at Meriskill, I successfully analyzed complex datasets, utilizing statistical methods and programming language such as MYSQL. I am adept at data cleaning, transforming and conducting through exploratory data analysis to identify trends and patterns using tools like Power bi, facilitating clear communication of insight both technical and non-technical

EDUCATION

Nov 2019 – July 2022

YABA COLLEGE OF TECHNOLOGY,

OND BANKING AND FINANCE

EXCEL

pivot Table (To Analyze, Summarize Market Value)

Power Query (Cleaning of Data)

Vlookup (It Is Particularly Useful for Task Such as Matching Data from Different Source)

Concatenate (Combine Two Or More Row Together)

Substitute (standardizing text, correcting errors, or making bulk replacements within a dataset) etc….

MYSQL

Structured Query Language

MySQL is used for data analysis and reporting, enabling users to query and analyze large datasets to extract valuable insights and generate reports. It supports complex queries and aggregations, making it suitable for data analytics tasks.

POWER BI

Data Visualization: Power BI enables users to create interactive and visually appealing dashboards and reports to represent data in various formats such as charts, graphs, and maps. This makes it easier for stakeholders to understand complex data and identify trends and patterns.

SKILLS

Programming (MYSQL)

Ms. Excel, Microsoft Power-Bi.

SUMMARY OF SKILLS:

Generate SQL Queries, create spreadsheets, and monitored tracking tools

Data modelling

Data visualization: Excel, Power Bi

Cleansing and preparing data

Attention to details

Problem-solving

CERTIFICATE

March 2023- December 2023

DATA SCIENCE PROFESSIONAL [ MYSQL, ADVANCE EXCEL, POWER BI]

GIIT AFRICA

Contact this candidate