Emmanuel Ojo

● A detail-oriented data analyst passionate about helping businesses

leverage business data and identify opportunities for improvement and achieve valuable insights within the organization.

● With 3+ years of experience working for startups in data analytics, customer service, product management and sales.

● Proficient in writing programming scripts using SQL and Python. Excellent proficiency in Power BI, Microsoft Excel and functions such as SUM, Count, Count A, LEN, TRIM, RIGHT, LEFT and MID, VLOOKUP, IF Statements, CONCATENATE, and Pivot Tables.

RELEVANT EXPERIENCE

Baseline 360 Limited, Glasgow, Scotland - Data Analyst Trainee

(Business Consulting and services)

JUNE 2022 - PRESENT

● Made analysis and visualization presentations to communicate results to trainers and fellow trainees using Pivot tables, Power BI, and SAS.

● performed data cleaning on small data and big or complex data sets as well as joining tables using ETL Frameworks and tools like MS SQL Server, Power BI, SAS and Vlookup.

● debug data wrangling and ETL errors and provided appropriate solutions to code, i.e. PROC SQL, Transact-SQL, SAS, Excel. Tremendoc Limited, London, England — Customer Service Supervisor(A telemedicine company)[Remote work]

MARCH 2022 - MAY 2022

● Created a reporting tool in collaboration with the customer service team which improved the reporting generated from our various operational systems.

● Ensured quality and accuracy are well represented in daily and weekly reports generated as regards departmental operations.

● Learnt and Conducted ad-hoc exploratory data analysis on calls and consultations reports using Google excel sheets and pivot tables.

● Communicated analysis and used insights to make recommendations to the COO and other stakeholders for changes and improvements in business operations.

Tremendoc Limited, London, England — Customer Experience Intern[Hybrid work]

MAY 2020 - MARCH 2022

● Performed data entry tasks as regards calls and customer complaints and made sure they were accurately inputted.

● Generated daily and weekly reports for team lead and other stakeholders.

● Collaborated in the planning and development of a communications roadmap and calendar for customer marketing and retention initiatives.

+234 810-***-****

emmanuelojo.dev@

gmail.com

www.linkedin.com/in/emm

anuel-ojo-47703419b

GitHub: emmanuelojo38

SKILLS(TOOLS)

STACK

Microsoft Excel

(Advanced)

SQL[MySQL, SQL Server

Management Studio,

PostgreSQL]

(Intermediate)

Microsoft Power BI

(Advanced)

Canva (Advanced)

Python(Intermediate)

SAS Enterprise Guide

(Intermediate)

Mixpanel(Intermediate)

SPSS (Beginner)

Jupyter Notebook

Statistical Analysis

CERTIFICATES(copies

available on request)

Product Analytics

Micro-certification -

Product School - 2022

Professional Data

Analyst - Data Camp

- 2022 - 2024

Project Management

Essentials Certified

(PMEC) - Management &

Strategy Institute - 2022

Product Masterclass:

How to build digital

products - Product

School (2022)

Scrum Fundamentals

Certified(SFC) -

SCRUMstudy- 2022

PROJECTS

UK Property Price Comparison App(Ongoing)

Analysis on UK property sales for 2019 till 2021 collected from the Land Registry Price Paid open source data.

Analysis on International Debt Statistics (August 2022) Analysis on International debt data collected by the World Bank. The dataset contained information about the amount of debt(in USD) owed by developing countries across several categories.

https://app.datacamp.com/workspace/w/09002fba-d9c5-4db0-9efb-5e9bc6704e5a Tools Used: SQL, Jupyter Notebook

CASE STUDY PROJECT - Boat Sales(July - August 2022) Case study on an advertisement website called Nearly New Nautical regarding exploratory analysis on the number of views on various boat types for a 7 day span. Methods: Importation and Cleaning of Data, Data Manipulation and Visualisation.

https://docs.google.com/presentation/d/1nwpl9vezyUsE7ONSTrgcgJYHV9bkxo9D9nDkTG7G gB0/edit?usp=sharing

Tools Used : Excel, Power BI, Power Point

A Visual History of Nobel Prize Winners (June 2022) Importation and Cleaning of Data, Data Manipulation and Visualisation. https://app.datacamp.com/workspace/w/4528e32b-b553-464f-8f4c-e6546bd5afea Tools Used : Numpy, Pandas and Seaborn in Python, Jupyter Notebook The Github History of The Scala Language(June 2022) —Data Manipulation, Data Visualisation, Importing and Cleaning. https://app.datacamp.com/workspace/w/cf4f0286-9ba9-49c5-bd66-130d6f08754a Tools Used : Pandas Python, Jupyter Notebook

Investigating Netflix Movies and Guest Stars(May 2022) —Data Manipulation; Data Visualisation; Programming; Case Studies. https://app.datacamp.com/workspace/w/fd192a33-6674-44fd-86b1-3a270fae5610 Tools Used : Pandas Python, Jupyter Notebook

The Android App Market on Google Play(May 2022) —Data Manipulation; Data Visualization; Probability and Statistics; Importing and Data Cleaning of historical data.

https://app.datacamp.com/workspace/w/d1849173-d3ad-442a-be84-94fa2242d806 Tools Used : Pandas Python, Matplotlib, Jupyter Notebook Assessment of the distribution of petroleum products via pipeline in Nigeria (March 2019 - November2019)

My Final year project spanned across the distribution of petroleum products through the modes of distribution were examined and special focus was on the distribution of petroleum products by pipeline. Nigerian pipeline network, depots and pump stations demerits. The activities of the Independent marketers, seven major oil marketing companies were analysed. https://docs.google.com/document/d/1E1OZqrFShIbmLsCGb9aLN-z-3qsIxDtV/edit?usp=shar ing&ouid=117598944207279720401&rtpof=true&sd=true

Tools Used : MS Excel, MS Word, Power Point

Agile Essentials- Alison -

2022

Six Sigma Yellow Belt -

6sigmastudy - 2022

Lean Six Sigma White

Belt Certification -

Management & Strategy

Institute - 2022

Young African

Leadership

Initiative(YALI) - 2022

- Servant Leadership:

The Deciding Difference.

- Responsible Leadership

on Transparency and

Good Governance.

Jobberman Certificate

of Achievement(soft

skills training)-

Jobberman Youth

Engagement & Learning -

2021

LANGUAGES

English, Yoruba,

French(Basic)

EDUCATION

DataCamp

● Data Engineering Upskill course - Ongoing

● Data Analyst Professional Certificate course - COMPLETED APRIL 2022 - SEPTEMBER 2022

Product School

● Product Analyst Professional Micro-Certification course - COMPLETED DECEMBER 2022

● Product Masterclass: How to Build Digital Products course - COMPLETED Federal University of Technology Akure, Ondo State, Nigeria. Transport Management and Technology[B.Tech.] - Awaiting Final Result JANUARY 2015 - NOVEMBER 2022

REFERENCES AVAILABLE ON REQUEST

Contact this candidate