DOREEN JOHN-OPARA
DATA ANALYST
(- / Email Address / LinkedIn / Github
PROFESSIONAL SUMMARY
A highly motivated and detail-oriented Data Analyst with 3+ years of experience in utilizing data
analytics tools and techniques to derive insights.
SKILLS
Python, SQL, Pandas, NumPy, MySQL, PostgreSQL, Tableau, Power BI, Looker, Matplotlib, Seaborn,
Git, Advanced proficiency in data analysis using Microsoft Excel and Google sheet, formulae, pivot
tables, and chart creation
WORK EXPERIENCE
SendMe Food Technology (YC W22)
Data Analyst
(Hybrid)
Ibadan, Nigeria
Feb. 2022 - Sept. 2023
● Developed an inventory management system, utilizing google sheet and python resulting in a
70% reduction in delivery time and a 10% decrease in Shrinkage/Loss.
● Created dashboards using Google Looker and Power BI needed for effective communication of
findings to stakeholders to monitor KPIs, facilitating informed decision-making for the
management team.
● Conducted data analysis using postgreSQL and python to identify areas for process enhancement
achieving a 20% increase in operational efficiency and overall service quality.
● Developed and maintained SQL queries using PostgreSQL for data extraction and transformation
using ETL pipelines, ensuring comprehensive data collection and accuracy for informed
decision-making and visualization through Google Looker.
● Collaborated with senior analysts to create predictive models for demand planning and
forecasting, guiding production and contributing to a 10% increase in sales.
Leveraged knowledge in Python, Google sheet, PostgreSQL, Google Looker, Power BI, Strong
analytical, problem-solving, and communication skills.
Customer Success Analyst
May, 2021 - Jan. 2022
● Implemented personalized resolution strategies for customer complaints, achieving a 30%
increase in customer satisfaction scores.
● Utilized data tools, including Excel, Tableau and Google Looker for cohort analysis, improving
customer retention, reducing churn and implementing effective “buy-back” strategies to reduce
churn rate by 35% and boost revenue by 40%.
● Established robust data management and performance tracking procedures, enhancing data
management for improved customer retention, contributing to a 15% increase in customer
retention within a six-month period.
● Collaborated with the engineering team to design and implement a versatile payment system and
successfully launched a convenient payment system for both Business and Individual customers
(B2B and B2C).
● Analyzed Customer data and provided actionable insights to the marketing team, enhancing
marketing strategies for increased customer engagement, achieving a 15% increase in customer
engagement through targeted campaigns.
Leveraged Knowledge in Google sheet, Google analytics, Google Looker, CRM software
(Zoho), Project management, Problem-solving, and Communication skills.
PERSONAL PROJECTS
● Bank Loan Financial Analysis
Conducted an in-depth analysis of a dataset containing information on over 5000 customers
using python. The project aimed to understand the factors influencing loan applications and
customer characteristics. The Source Code on Github is here.
● Interactive Dashboard on CO2 Emission by Country
Created an impressive interactive dashboard that visualizes CO2 emissions by country using
Python libraries such as pandas, numpy, panel, hvplot.pandas, and holoviews. The Source Code
on Github is here.
● Sales Dashboard for a Fictitious Company
Designed and implemented a dynamic sales tracker for LIPA, a fictitious company using Google
sheet which enables real-time monitoring of product sales across multiple branches. The tracker
provides comprehensive daily and monthly sales records, automatically updating as new order
details are inputted. Click here to experience the live sales tracker in action.
EDUCATION
University of Ibadan (UI)
Programme: Bachelor of Science, Food Technology
Dec. 2021
