Jumoke Yekeen
North York,Ontairo
Summary
Meticulous and enthusiastic data analytics student actively seeking a Data Analytics Intern/Co-op opportunity at the esteemed company for the 2024 fall co-op term (September 2024). Armed with strong analytical skills, dedicated to enhancing processes and proficient in utilizing tools such as SQL, Python, and Power BI. With a demonstrated history of evaluating dashboards and creating KPI reports. Additionally, developing expertise in artificial intelligence and product life cycle analytics. Committed to nurturing collaborative partnerships and promoting interdisciplinary communication to achieve meaningful results.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Project :
Power BI E-commerce Behavior Analysis Dashboard
06.2023 - 04.2024
- Check for missing values, wrangle, transform columns and load data in Power BI.
- ·Performed data quality assurance from data domain and metadata consistency.
- Identify data challenges and evaluated multiple solutions to ensure structured approach Increase in sales was 84.67k, with San Francisco making highest purchase.
- Creating and redefining sales forecast in Power BI desktop
- ·Male purchasers are mostly in south with San Francisco being 49.02% and average at 31 years.
- Female purchasers mostly in north with New York at 67% and average age at 36 years.
- Male gold and silver membership are least satisfied compared to female purchasers.
- ·Female mostly belong to bronze and gold membership are more satisfied with their purchase.
- Communicate and report all my findings to stakeholders
Project:
Online Fraud Detection
06.2023 - 02.2024
- Basic Exploratory Data Analysis (EDA) and data wrangling which will help to identify patterns, trends, and outliers were performed on data
- Data preprocessing such as data cleaning, identifying null values and imputing into null values or deleting it.
- Performing Visualizations on data using matplotlib.
- Correlation between features were created using heatmap.
- Data are prepared for modelling where target variable and independent variables are identified.
- SMOTE (synthetic minority oversampling Technique) for oversampling minority class.
- Different Machine Models such as Logistics Regression model, K-Nearest Neighbors (KNN) classification model, Decision tree and Random Forest Classifier.
- Based on different ML models used for this project, deduction was made that Random Forest classifier had better accuracy 99.67%, performed better in terms of Harmonic mean, determine better instances for Fraud than other models (logistics, Tress classification, KNN).
Project Experience:
Sentiment Analysis On An IMDB Movie Critics
06.2023 - 12.2023
- Demonstrated flexibility to meet changing deadlines and institution requirements.
- Applied understanding to data and follow technical processes.
- Actively participate in debriefings and meetings with professor and teammates.
- Review conversations and ensure adherence to machine learning annotations.
- Assign additional annotations to main high standard and accuracy on dataset.
- Preprocess dataset remove stop words, special characters, URL links, create contraction expansions.
- Used word cloud to visualize most frequent used words in both positive and negative reviews.
- Accurate show word length average of positive and negative reviews. Negative reviews are longer.
- Accurately performed N-grams (4 and 5 grams) on text dataset for both positive and negative datasets.
- Successfully show that best and worse words were used predominantly by reviewers on both cases.
- Successfully lemmatized dataset for further analysis.
- Successfully convert texts into vectorizer and further performed machine line techniques.
- Different models such as Random Forest, Decision Tree, ADA Boost & Tensor flow and make comparison based on their accuracy, F1 score, AUC
- Accurately deploy TensorFlow machine learning in 5 epochs for training and Test accuracy was 87%.
- Generated metrics and reports based on thorough machine learning results.
- Sourced, vetted and managed vendors needed to accomplish project goals
- Developed and implemented project plans and budgets to ensure successful execution.
Project: Structured Data Processing and Analysis
Using SQOOP, MySQL And Hadoop
06.2023 - 11.2023
- Successfully import csv dataset into Microsoft SQL server.
- Successfully connect python IDE with SQL database.
- Perform CRUD operations in database.
- ·Query database with SQL queries to draw insight from dataset.
- Use rollup and cube to perform numerical summations.
- Successfully two tables and then use where clause to provide necessary information to client query.
- ·Perform several aggregate functions like sum, count, average etc. on dataset to make sense of dataset.
- Perform other tasks as required in SQL environment.
Senior Program Analyst;
09.2014 - 05.2023
- Large amounts of data to identify trends and find patterns within data.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality thereby reducing time lapse in grade collation, computation, processing, and presentation.
- Daily utilizing MSSQL, Data warehousing programs, Tableau, and other dashboards/visualization tools for data intelligence and analysis.
- Building reports using SQL and excel to provide real-time insights into students' academic performance annually. These insights are used in college's annual convocation lectures and summarization.
- Building reports using SQL and excel to provide real-time insights into roles and identity management of about 3000 staff providing quick access to relevant information used in personal budget preparation.
Education
Post Graduate Diploma - Big Data Analytics
Lambton College of Applied Arts And Technology
Mississauga, ON12.2024
B.Tech - Computer Engineering
Ladoke Akintola University of Technology
Ogbomoso, Nigeria.12.2009
Skills
- Good Power BI , Tableau, Matplotlib and Seaborn in Python
- Good SQL, R and Python
- Good in different database management systems such as MySQL, SQL Server, and SQLite
- Intermediate Big data tools such as Hadoop, Spark, Hive
- Strong Microsoft Excel skills include proficiency in functions such as XLOOKUP and VLOOKUP
- Good communication skills
- Time Management
- Analytical Thinking
- Strong interpersonal skills
- Attention to Detail
- Effective collaboration
- Decision-making capabilities
Certification
- Certified [Databases and SQL for Data Science with Python from ], [Coursera] - [2022]
- Certified [Introduction to Databases], [Coursera] - [2023]
- Certified [Python for Data Science, AI & Development], [Coursera] - [2023].
- Certified [Python Project for Data Science], [Coursera] - [2023]
- Certified [Tools for Data Science], [Coursera] - [2023]
Timeline
Project :
Power BI E-commerce Behavior Analysis Dashboard
06.2023 - 04.2024
Project:
Online Fraud Detection
06.2023 - 02.2024
Project Experience:
Sentiment Analysis On An IMDB Movie Critics
06.2023 - 12.2023
Project: Structured Data Processing and Analysis
Using SQOOP, MySQL And Hadoop
06.2023 - 11.2023
Senior Program Analyst;
09.2014 - 05.2023
Post Graduate Diploma - Big Data Analytics
Lambton College of Applied Arts And Technology
B.Tech - Computer Engineering
Ladoke Akintola University of Technology
Similar Profiles
Kaitlyn MartinezKaitlyn Martinez
Registered Behavior Technician at Behavior Analysis IncRegistered Behavior Technician at Behavior Analysis Inc
Aldara Mariño FerreiraAldara Mariño Ferreira
Research Assistant at Criminal Behavior Analysis UnitResearch Assistant at Criminal Behavior Analysis Unit
Emily TewEmily Tew
Lead Registered Behavior Technician at Full Spectrum Behavior AnalysisLead Registered Behavior Technician at Full Spectrum Behavior Analysis