Beta

Nsikan Udoma

Certified

Data Analytics Trainee

Masterschool | Ontario, Canada

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Certification

Data Analyst Associate

My New Certification

Data Engineer Associate

My New Course

Introduction to Python

Unleashing the magic of data, one algorithm at a time.

My Work

Take a look at my latest work.

course

Introduction to Python

certification

Data Analyst Associate

certification

Data Engineer Associate

course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

Data Engineer Associate

Other Certificates

DataCamp Certified Associate Data Analyst

DataCamp Certified Associate Data Engineer

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python

Intermediate SQL

Intermediate Python

Joining Data in SQL

Courses

Introduction to Python

Intermediate SQL

Intermediate Python

Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

TELUS International AI Data Solutions | Nov 2022 - Present

Online Data Analyst

N/A

Masterschool | Jun 2022 - Present

Data Analyst Trainee

Skills: Tableau · Microsoft Excel · Python (Programming Language) · SQL · Databases · Google BigQuery · Google Cloud Platform (GCP) · Extract, Transform, Load (ETL) · A/B Testing · Data Visualization · Data Management · Pivot Tables · Exploratory Data Analysis · Data Quality · Agile Methodologies · Process Automation · API Management · Statistical Data Analysis · Web Scraping · Git · Feature Engineering Responsibilities ▪ Translated complex business problems into business questions and then converted those questions into advanced SQL queries, using PostgreSQL/ MySQL/SQLite dialects to extract, manipulate and analyze large datasets from multiple relational databases and data warehouses. ▪ Completed complex EDA projects using advanced SQL queries & Python scripts to give valuable business insights & recommendations. ▪ Automated data wrangling & cleaning tasks using python scripts. URL, CSV, JSON, web scraping & APIs for cloud-based data gathering. ▪ Developed interactive Tableau dashboards to identify trends in customer churns for a bank’s credit card service; most profitable & poor-performing locations/product categories for an e-commerce startup; and trends/causes of flight delays/cancellations for U.S airlines in 2015. ▪ Communicated process improvement strategies with program managers, contributed to data analysis efforts during live meetings, and assisted students in my Data Analytics cohort by sharing project observations, tips, and responding to questions in slack channels.

Freelance | Jan 2019 - Dec 2022

SQL, MS Excel & Website Management Freelancer

Skills: Microsoft Excel · MySQL · Google Sheets · Databases · Data Analysis · Data Management · Pivot Tables · Data Quality · Web Scraping · Canva · Squarespace · Content Management Responsibilities • Resolved over 30 spreadsheets problems (Excel & Google Sheets) for paying clients and on pro-bono cases. I used SQL to extract, clean and transform datasets for clients, and often create visualizations with the clean dataset in Excel or Google Sheets. • Cleaned a variety of dirty and untidy datasets, where I used Excel/GS logical, conditional functions and cell formulas to extract, split, sort, filter and manipulate data into clean datasets prior to exploratory data analysis (EDA). • EDA using Pivot Tables to aggregate & summarize data. Developed charts to visualize trends & patterns in datasets • Built & managed 5 websites via Squarespace platform without writing code. Setup Google Analytics for web traffic monitoring, ads campaign performance tracking, and automating reports.

Labatt Breweries of Canada | Jan 2019 - Jan 2022

Packaging Operations Associate

Skills: PI Dashboards · SAP ERP · MS Excel Responsibilities • Monitored KPIs continuously throughout shift, using production software programs and PI dashboards to identify and report causes of downtime and poor line performance, while escalating issues to shift & line managers during scrum meetings. • Completed brand changeovers and size conversions according to production schedule. Developed 5WHYs to identify root causes of process bottlenecks or quality concerns and escalated them accordingly. • Continuous improvement efforts aimed at optimizing Line Efficiency (LEF) and Gross Line Yield (GLY) by reorganizing material storage, optimizing inventory strategies, and maintaining appropriate safety stock levels, while escalating any discrepancies across the supply chain to my group managers.

Platinum Plus TV - The100NairaShop | Jun 2017 - Dec 2017

Marketing Data Analyst

Skills: Tableau · Microsoft Excel · Google Sheets · Amazon Web Services (AWS) · Google Analytics · A/B Testing · Data Analysis · Data Visualization · Data Management · Pivot Tables · Data Quality · Agile Methodologies · Jira · Canva · Project Management · Social Media Marketing Responsibilities • 69% user subscription growth in 4 months after launch, through targeted ad campaigns. Defined the null and alternative hypotheses and worked with the engineering team to bootstrap and perform A/B testing of 100NairaShop website CTAs, which led to shorter steps in the lead-to-activation cycle, reducing signup-activation time by approx. 57%. • Developed internal Tableau dashboards for monthly marketing analytics reports, SKU performance tracking, and user subscription/activity reports. • Collaborated with the procurement team to identify over 5000 SKUs in high demand for the 100NairaShop & developed KPIs to track SKU performance. • Supported the business team with requirements gathering and technical documentation prior to the launch of the 100NairaShop website. • Supported the IT & Development team during the seamless migration of data from AWS to Google Cloud Platform (GCP) during a scheduled downtime period. • Designed company profiles, visualizations & presentations, project costings and marketing budgets for all PPTV products including the 100NairaShop. • Developed PR & content management strategies to achieve marketing objectives of all PPTV products.

Ventures Platform Fund | May 2016 - Apr 2017

Marketing Operations Associate

Skills: Google Sheets · Google Analytics · Agile Methodologies · Business Analytics · Canva · Strategic Planning · Project Management · Microsoft Word · Advertising Campaigns · Microsoft Office · Squarespace · Social Media Marketing Responsibilities • Led the marketing team that grew social media following from 0 followers to over 5k followers across all platforms (FB, IG, Twitter, LinkedIn) for Ventures Platform, and over 7k followers across all platforms (FB, IG, Twitter, LinkedIn) for Ventures Park, through sponsored ads and growth hacking techniques. • Wore multiple hats to enable startups in the accelerator program succeed, including helping to develop pitch decks, marketing budgets for ad campaigns, media buying, and organizing demo day events to showcase startups to potential investors. • Monitored and reported KPI performance using visualization tools including PowerPoint. Prepared marketing budgets and analyzed ads campaign performance using spreadsheets (Excel & Google Sheets) and Google Analytics • Collaborated to organize over 50 events including exhibitions, developers meetups, and networking hangouts for startup founders and tech folks. Used such events to market VP offerings including coworking spaces, and funding for tech startups. • Managed all forms of media and communication platforms to build, maintain and manage the reputation of Ventures Platform, Ventures Park and Emerging Platforms Ltd.

My Education

Take a look at my formal education

Data Analytics in Data Science and AnalyticsMasterschool | 2023

OCGC, Operations ManagementFanshawe College | 2021

Master's degree, Materials EngineeringSwansea University | 2014

Bachelor of Science (B.Sc), Industrial ChemistryCovenant University | 2012

About Me

Data & Business Intelligence Analyst | Marketing Data & Operations Analyst | Data Analyst Trainee @ Masterschool | Tools/Skills: SQL, Python, Tableau, Excel & Google Sheets, A/B Testing, ETL/ELT, Database Mgt

Create Your Data Portfolio for Free