Data Analyst Power Bi

GLAS S DOOR JOB M ARKET EDA – Personal Project – Kogi, Nigeria January, 2024

Whatlap Group Sales Report – Client’s Project – Kogi, Nigeria February, 2024 Global Superstore Sales – Personal Project – Kogi, Nigeria March, 2024 M E RCHANT STORE AN AL Y S IS – Personal Project – Kogi, Nigeria April, 2024 BI KE RS’ NATION ANALYSI S – Client’s Project – Lagos, Nigeria September, 2024 Data Analyst On-chain Analyst

Olura Seun Paul

SOFT SKILLS

• Excellent organization and managerial skills

• Good Research methodology and presentation skills

• Excellent verbal and written communication skills.

• Strong analytical and problem-solvingskills.

Phone Number: +234**********

Email: ***************@*****.***

Portfolio: linktr.ee/seunpaul1

• Conflict management and resolution skills.

• Good interpersonal relationship skills;

• Goggling; ability to search the internet creatively.

• Excellent time management skill

CORE SKILLS

• Excel (VLookup, Pivot Tables, Power Pivot, Functions, Power Query, DAX, etc.)

• SQL (PostgreSQL)

• Python (Functions, Numpy, Pandas, Matplotlib, Seaborn, Loops, etc)

• Tableau

• Microsoft Power BI

• On-chain Analytics

• R

Onchain Analytics Projects (Dune Analytics)

• Swap Trends and User Behaviour on Uniswap v3 & v4 – Dune link: https://dune.com/paulax/swap-trends-and-user-behavior- analysis-on-uniswap

• Analysis of Raydium Blockchain: Analyzing Key Blockchain Metrics – Dune link: https://dune.com/paulax/raydium-analytics-dashboard

• Near Protocol Analysis – Dune link: https://dune.com/paulax/near-protocol-analysis#https://dune.com/paulax/near-protocol- analysis#network-activity-analysis

Excel PostgreSQL Python R Tableau Power BI Projects

● Utilized Excel to analyze over 10000 customer data and gain insights on the key sales metrics, as well as staff/product performance

● Implemented excel techniques to comb through the company data and identified the key factors that could improve sales.

● Aggregated and visualized the data by using pivot tables, charts, and dashboard in order to compile a professional report.

● Utilized Excel to analyze over 8000 data jobs and gain insights on key metrics on the most valued companies on Glassdoor as well as the most rewarding career in data field.

● Implemented Excel techniques to comb through the job description and present key employment insights, aiding in market analysis and job trend identification.

● Aggregated and visualized the data by using pivot tables, charts, and dashboard in order to compile a professional report.

● Created a dashboard with Power BI to provide actionable insights into the company sales performance, helping to identify key revenue drivers and optimize sales strategies.

● Transformed and processed client’s data by using DAX and Excel to ensure data completeness and validity

● Provided technical insights on how the client can fully utilize their data by introducing different technologies

● Consulted with client to determine the best metrics to be displayed on final product

● Conducted in-depth data cleaning and analysis using Excel and DAX functions in Power BI, Power Query, resulting in a detailed dashboard showcasing market segment profitability, sales trends, total profit, top countries by sales, etc.

● Power BI was used for the data visualization which provided key insights into sales performance, therefor, assisting in strategic decision-making to enhance profitability and market reach.

● Transformed and processed client’s data by using DAX and Excel to ensure data completeness and validity

● Utilized SQL to extract data from 4 different related tables from customer sales databases using JOIN and VIEW.

● Transformed and filtered data by using aggregating and filtering function to improve reporting process

● Analyzed sales data to identify key trends and insights for a chain of retail stores, by identifying seasonal sales peaks during holiday, highlighted best performers and analyzing customer demographics for targeted marketing.

● aded and visualize data with Tableau, actionable insights was derived, and recommendations were made in order to optimize inventory, enhance marketing strategies, and improving the overall sales performance. Work Experience. ECWA HOSPITAL EGBE, EGBE, KOGI STATE OCT., 2019 – May, 2024 KEYSTONE KIDDIES COLLEGE, ISOLO, LAGOS STATE 2016 – 2019 ECWA School of Nursing & Midwifery, Egbe, Kogi State 2009-2014

● Utilized Python to import customers’ bike’s data from two different but related tables using pandas join and merging.

● Employed the numpy and pandas library to conduct an in-depth and thorough data cleaning by searching for missing values, and treating any other inconsistencies that can inflate the end result of the analysis.

● Conducted exploratory data analysis to uncover insights from the business data

● Utilized seaborn, and matplotlib library to show graphical representation of the analysis and adequately present the insights derived from the data.

● The report of the analysis was presented using Jupyter notebook and recommendations was given based on the insights derived from the data. Work Experience

Designation: Administrative Assistant to the Medical Director

• Managing scheduling for the executive for the Medical Director

• Draft, review and send communications on behalf of the Medical Director

• Organize and prepare for meetings, including gathering documents and attending to logistics ofmeetings.

• Answer and respond to phone calls, communicate messages and information to the Medical Director

• Prioritize emails and respond when necessary

• Coordinate travel arrangements

• Maintain various records and documents for the Medical Director Designation: Computer Tutor/Manager/Teacher Librarian

• Changed and replaced backup tapes regularly and performed detailed server backups.

• Generated reports covering details about data, system operation and error monitoring.

• Trained end user of software and software on use, functionality and application to business problems.

• Organized library catalogues, supplies, equipment and records.

• Drove expansion of library collections and programs in response to student and faculty needs and special requests.

• Incorporated engaging teaching methods and resources that set a strong foundation for learning, encouraging student participation and self- motivation to seek more information.

Designation: Librarian

• Collection Management: Organize, catalog, and develop the library's collection, focusing on nursing and healthcare materials. Manage acquisitions and conduct regular inventory checks.

• User Support: Assist students, faculty, and staff with research, provide reference services, and deliver information literacy workshops.

• Technology and Resources: Manage the library’s digital resources, including online journals and databases, and ensure the effective use of the library management system.

• Library Administration: Oversee circulation, library policies, and space management. Supervise library staff and maintain accurate records.

• Research Assistance: Support academic research, guide students with literature reviews, and assist faculty with resource needs for teaching and research.

• Outreach and Collaboration: Promote library services, collaborate with faculty to align resources with the curriculum, and engage in community outreach to enhance library usage.

EDUCATION QUALIFICATION WITH DATES

AHMADU BELLO UNIVERSITY, ZARIA - Masters in Information Management (Second Class Upper) - 2023

UNIVERSITY OF ILORIN, KWARA STATE - B.Sc., Lib. & Info. Science (Second Class Upper) – 2014

FEDERAL POLYTECHNIC, OFFA, KWARA STATE - OND, Lib. & Info. Science (Distinction) – 2010 CERTIFICATIONS AND TRAINING OBTAINED WITH DATES

• Vephla University Diploma in Data Analytics 2024

• IBM Professional Certificate for Data Science 2020

• Project Management Foundations: Schedules (Linkedin Learning) 2020

• Microsoft Project 2019 and Project Online Desktop Essential Training 2020

• National Registry of CPE Sponsors (Quality Assurance Services) 2020

• Project Management Foundations: Budgets (Linkedin Learning) 2020

• Project Management Foundations: Communication (Linkedin Learning) 2020

• Project Management Foundations: Teams (Linkedin Learning) 2020

• Data Visualization with Python 2020

• Tableau Essential Training (2020.1) 2020

• Machine Learning for Data Science 2020

• Applied Data Science Capstone 2020

• Introduction to Power BI (Datacamp) Statement of Accomplishment 2020

• Jobberman Soft-Skills Training 2020

References available on request

Contact this candidate