Learn Data Skills
Beta
Oluwakemi Akigbogun

Oluwakemi Akigbogun

Data Analyst

Georgia State University

Technologies

My Portfolio Highlights

My New Course

Introduction to Natural Language Processing in R

Analytical storyteller, weaving captivating narratives with the threads of data.

My Work

Take a look at my latest work.

course

Introduction to Natural Language Processing in R

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Amazon.com Services LLC | Jun 2023 - Sep 2023

Business Analyst Intern

• Created and presented dashboards tracking weekly accuracy of predictive supply chain pricing models using and compare historical pricing data to KPI's for 156 weeks of freight transport contracts. • Created complex SQL queries using JOINs and temporary tables to extract and aggregate thousands of pricing model predictions and over 3 million records of historical contract pricing data from the data warehouse. • Optimized Redshift SQL queries by reducing query runtimes from over 7 minutes to less than 2 minutes for ETL jobs in order to automate pricing model reporting using temporary tables and join clauses.
Show More

Amazon.com Services LLC | Jun 2022 - Sep 2022

Business Analyst Intern

• Created complex SQL queries using JOINs and temporary tables to extract and aggregate thousands of pricing model predictions and over 3 million records of historical contract pricing data from the data warehouse. • Optimized Redshift SQL queries by reducing query runtimes from over 7 minutes to less than 2 minutes for ETL jobs in order to automate pricing model reporting using temporary tables and join clauses. • Used Redshift SQL, Excel, and Tableau to transform large datasets into easily understandable reports and explain technical data to non-technical stakeholders weekly for 12 weeks.

Genesys Telecommunications Laboratories, Inc. | Jun 2021 - Aug 2021

Professional Services Intern

• Created and maintained project documentation and visuals in SharePoint and Microsoft Teams, coordinated communication within project team, acted as stand in scrum master as needed for End-of-Life project. • Used Excel formulas and macros to sort large datasets and match over 1000 lines of customer data for End-of-Life project. • Summarized employee certification data and created reports in Excel using pivot tables to display high level department certification statistics for management.

Wellstar Health System | Mar 2020 - May 2021

Information Technology Student Intern

• Collaborated and helped organize the switch and launch from Skype for Business to Microsoft Teams for the organization by hosting 20 remote training events. • Worked extensively in telecommunications with scheduling, logistics, and production of over 70 Microsoft Teams Live events. • Reconciled support tickets, scheduled meeting requests, and created over 200 articles for Wellstar knowledge database using ServiceNow.

My Education

Take a look at my formal education

BBA in Computer Information SystemsGeorgia State University | 2023
AS in Business AdministrationGeorgia State University | 2020

About Me

Oluwakemi Akigbogun

Oluwakemi hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free