Adeola Oke
Lawrenceville,Georgia
Summary
Lead Data Analyst with 5 years of experience on leveraging SQL, Power BI, and Excel to deliver actionable insights and enhance data-driven decision-making. Proficient in creating interactive data visualizations and optimizing. data processes, contributing to improved operational efficiency and revenue growth. Committed to fostering a data-driven culture and aligning data strategies with business objectives, while continuously advancing skills in data warehousing and communication.
Overview
6
6
years of professional experience
Work History
Data Analyst
Syfan Logistics
Gainesville, GA
04.2024 - Current
- Identify and remove corrupted data
- Developed complex SQL queries to extract, aggregate, and analyze large datasets from relational databases (e.g. SQL Server, MYSQL)
- Use statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for prediction of events
- Prepare reports using Power BI when possible with SQL Databases, DAX query, Analysis Server
- Partner with cross-functional teams to align data strategies with business objectives
- Foster data-driven culture, empowering colleagues with actionable insights
- Ensure data accuracy and integrity through meticulous quality control processes
- Develop comprehensive documentation for data management protocols
Lead Data Analyst
Samsung
11.2022 - 02.2024
- Analyzed large amounts of data in Excel to identify trends, patterns, signals and hidden stories within data
- Created pivot tables and VLOOKUPS in Excel to join 2 data sets together and pull key components
- Automated data cleansing processes using Excel VBA, reducing data cleaning time by 30%
- Integrated SQL-based data quality checks, improving reporting accuracy by 25%
- Wrote SQL scripts for business-critical reports and analyses, improving data accessibility and enabling faster decision-making
- Built forecasting models using Power BI’s time intelligence functions, improving demand prediction accuracy by 20%
- Mentored junior analysts, enhancing team skills in data visualization and analytical tools.
Data Analyst
Consult R
Atlanta, GA
04.2021 - 09.2022
- Navigate master data, including creation, updates and deletion
- Used TOAD for Oracle to generate reports and datasets for product sales and marketing improvements
- Optimized SQL queries, reducing query execution time by 30% and improving report generation efficiency
- Analyzed existing SQL queries to identify opportunities for improvements
- Developed and maintained 50 Power BI and Tableau dashboards, supporting decision-making across multiple departments.
- Designed a sales analytics dashboard that reduced manual reporting time by 85% and provided real-time insights.
- Identifying key areas for improvements, such as audience, acquisition, behavior, and conversions, product sales by 11%
Data Analyst
Verizon
Marietta, GA
09.2020 - 02.2021
- Analyzed data from 10000 monthly active users and used outputs to guide marketing and product strategies; increased average app engagement time by 2x, 12% decrease in dropout rate, and 2x shares on social media.
- Built Power BI dashboard to visualize core business KPIs (e.g., Monthly Recurring Revenue), saving 10 hours per week of manual reporting work.
- Collaborated with 4 interns to conduct attitude study, which led current buyers to purchase products 10% more frequently.
Education
Bachelor of Science - Computer Information Science
Georgia Gwinnett College
Lawrenceville, Georgia12-2022
Skills
- Microsoft Power BI
- Tableau
- Pivot Table
- SQL
- Power BI
- Excel
- Data analysis
- DAX Query
- Excel VBA
- Databases
- AWS
- Python
- Data Validation
- Data Migration
- Data Entry
- Data Visualization
- Data Cleaning
KEY ACHIEVEMENTS
- Efficiency Improvement: Decreased manual reporting work by 10 hours monthly through Power BI utilization.
- Data Process Automation: Automated data cleansing, reducing total cleaning time by 30% with Excel VBA.
- Enhanced User Engagement: Analyzed user data leading to 2x increase in app engagement time and social shares.
- Query Performance Boost: Optimized SQL queries, reducing execution time by 30% for improved report generation.
COURSES
Master Power BI Desktop for Business Intelligence by Maven Analytics
Timeline
Data Analyst
Syfan Logistics
04.2024 - Current
Lead Data Analyst
Samsung
11.2022 - 02.2024
Data Analyst
Consult R
04.2021 - 09.2022
Data Analyst
Verizon
09.2020 - 02.2021
Bachelor of Science - Computer Information Science
Georgia Gwinnett College