Learn Data Skills
Beta
Samuel Adeolu Olusegun

Samuel Adeolu Olusegun

Data Scientist

Technologies

My Portfolio Highlights

My New Project

Investigating Netflix Movies

My New Course

Introduction to Python

My New Course

Intermediate Python

My New Project

Investigating Netflix Movies

Data archaeologist, unearthing buried insights from historical records.

My Work

Take a look at my latest work.

article

DataLab

PythonSpreadsheets
notebook

Comprehensive Data Analysis Project - Netflix Data

PythonGitSpreadsheets
article

DataLab

PythonSpreadsheets

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Coursera Google Data Analytics

Coursera Google Advanced Data Analytics

Udemy Machine Learning A-Z

Coursera Google Business Intelligence

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Understanding Artificial Intelligence

My Work Experience

Where I've interned and worked during my career.

Home Group | Jan 2024 - Present

Data Reporting Analyst

• Diligently entered and updated data in spreadsheets to ensure accuracy and efficiency, keeping all records current and reliable. • Leveraged advanced Excel functions such as lookup functions, PivotTables, PivotCharts, and complex nested formulas. Used Power Query for seamless data transformation, manipulation, and automation. • Applied conditional formatting to emphasize key data points, trends, and outliers. Created custom formatting rules for better data visualization and readability. • Compiled and delivered periodic reports summarizing key findings and metrics, ensuring they were accurate and timely for stakeholders. • Ensured data confidentiality and compliance with GDPR & DPA regulations. Implemented security measures to protect data integrity. • Analyzed datasets exceeding 10 million rows to uncover trends and patterns, resulting in a 15% improvement in operational efficiency using SQL. • Developed and maintained over 15 Power BI dashboards to monitor customer complaints, providing actionable insights that improved resolution time by 30%. Skills: Power BI, data visualization, problem-solving. • Executed SQL queries to retrieve, update, and manipulate data for efficient extraction, complex analysis, and database management, hence optimize query performance, reducing data retrieval time by 20% and supporting data- driven decision-making. • Developed Python scripts to automate data processing tasks and designed a timesheet application using Power Apps, streamlining time-tracking for over 50 employees and reducing manual effort by 35%. • Partnered with cross-functional teams to implement innovative technology solutions for resolving customer complaints, enhancing inter-departmental communication and workflow efficiency by 20%. • Utilized SharePoint and Teams to manage project documents, collaborate on tasks, and communicate effectively with team members, ensuring seamless coordination and information sharing.
Show More

RKY Consulting Services Ltd. | Sep 2022 - Present

Data Analyst

• Designed and implemented predictive dashboards with Power BI and Tableau, delivering real-time insights and forecasted trends. These tools empowered stakeholders to make well-informed, data-driven decisions. • Wrote efficient queries, indexed tables, and normalized data structures to enhance data retrieval performance. Achieved a 20% improvement in database efficiency. • Led initiatives to improve data governance practices, focusing on data quality and compliance. Implemented robust data validation and cleansing processes, increasing data quality by 25%. • Conducted comprehensive data analysis to identify and address operational inefficiencies. This strategic insight resulted in a 30% reduction in operational inefficiencies. • Reduced report generation time by 30% by optimizing reporting processes and implementing streamlined data workflows. • Worked closely with stakeholders to understand their reporting needs and deliver actionable solutions using SharePoint and Microsoft Teams. • Prepared comprehensive reports for management, highlighting trends, patterns, and predictions from analyzing datasets exceeding 10 million rows. These insights informed strategic decisions and led to a 15% increase in operational efficiency. • Extracted data from primary and secondary sources, analyzed and reorganized it into easily readable formats for both human and machine consumption. This resulted in a 30% increase in data processing efficiency. • Created SQL queries to retrieve data from multiple databases, joined tables, and merged datasets to enable comprehensive and accurate data collection, facilitating thorough analysis. • Identified, prioritized, and implemented enhancements to data assets, improving the accuracy and utility of information interpretation. This increased data quality by 25%. • Utilized Basecamp for project management, ensuring seamless coordination and timely completion of tasks.

New Horizons | Jan 2020 - Jan 2022

Data Analyst

Advanced Analytics • Leveraged Excel, SQL, and Python to perform advanced analytics, including data mining, statistical analysis, and predictive modeling. • Uncovered actionable insights for stakeholders, which informed key business decisions and strategies. Workflow Automation • Utilized Azure cloud solutions to automate workflows, achieving a 20% increase in process efficiency. • Demonstrated strong project management and organizational skills by managing and optimizing workflows. Data Visualization • Developed interactive and dynamic dashboards using Power BI and Tableau to improve data interpretation. • Provided real-time insights and visual representations of key metrics for decision-making. Automated Data Pipelines • Automated data pipelines using Python and SQL, reducing manual effort by 40%. • Implemented ETL processes that ensured seamless data extraction, transformation, and loading across multiple sources. In-depth Analysis • Conducted in-depth analyses using SQL and Python, delivering actionable insights to senior management. • Performed trend analysis and correlation analysis to uncover hidden patterns and inform strategic planning. • Utilized analytical thinking and communication skills to present complex findings in an understandable manner. Data Retrieval and Storage Optimization • Managed cloud databases, optimizing queries, and ensuring secure and scalable data storage through Azure Blob and Amazon S3 solutions. • Demonstrated proficiency in database management and data storage technologies. Data Protection Compliance • Implemented data anonymization, encryption, and access controls to ensure compliance with GDPR and Data Protection Act. • Maintained data security and integrity, adhering to regulatory standards. Collaboration and Communication • Collaborated to improve data processes and reporting efficiency using SharePoint and Zoom. • Demonstrated strong interpersonal skills, teamwork, and the ability to communicate effectively with stakeholders.

ELIZABETHA Brand | Jan 2017 - Jan 2019

Junior DBA & Web Designer

SQL Server Configuration: • Configured SQL Server solutions to ensure the high availability of critical databases, achieving a remarkable 99% uptime rate. • Demonstrated technical expertise in database configuration and optimization. Data Backup: • Designed and implemented comprehensive data backup and recovery protocols, successfully reducing potential data loss by 30%. • Showcased problem-solving skills and meticulous attention to detail in data management. Data Accuracy: • Improved reporting accuracy by 20% through the design of robust data architectures that aligned with stakeholder requirements. • Streamlined data analysis processes, showcasing strong analytical skills and a clear understanding of business needs. Data Availability: • Ensured a 99% availability rate for critical databases by configuring and maintaining SQL Server solutions for business continuity. • Highlighted reliability and technical proficiency in database administration. Data Loss Reduction: • Reduced potential data loss by 30% by developing and testing comprehensive database recovery and backup procedures. • Demonstrated a proactive approach to data security and integrity. Web Traffic: • Developed and implemented a content marketing strategy that significantly increased website traffic and engagement. • Utilized HTML, CSS, Wordpress, Joomla, and SEO skills to create and optimize web content. • Exhibited creativity and strategic thinking in digital marketing. Collaboration and Communication: • Collaborated effectively with team members using Microsoft Teams and Zoom to understand requirements and deliver solutions. • Demonstrated strong communication and teamwork skills, fostering a collaborative work environment.

KPMG US | Sep 2017 - Dec 2017

Data Analyst

Data Insights, Cleansing, Exploration, and Mining: • Utilize Excel, SQL, and Python to perform data cleansing, exploration, and mining, uncovering valuable insights that inform business decisions. • Apply critical thinking and analytical skills to identify and resolve data discrepancies. Quality Assurance: • Ensure the quality of imported data by collaborating with quality assurance analysts as necessary. • Demonstrate attention to detail and problem-solving skills to maintain data accuracy and reliability. Data Integrity and Normalization: • Support initiatives aimed at maintaining data integrity and normalization. • Utilize technical expertise to ensure data consistency and compliance with organizational standards. Data Compilation and Analysis: • Compile and analyze data related to business issues, providing actionable insights. • Use Power BI and Tableau to create dynamic dashboards that facilitate data interpretation and decision-making. Data Communication and Reporting: • Communicate data findings clearly and effectively through reports and presentations. • Utilize Google Meet and Zoom for virtual meetings, ensuring effective communication with stakeholders. Visualization Development: • Develop clear visualizations using Power BI and Tableau to convey complex data in a straightforward manner. • Leverage creativity and technical skills to design visually appealing and informative charts and graphs. Report and Analysis Development: • Assist in the development of reports and analysis, managing and designing the reporting environment, including data sources, security, and metadata. • Exhibit strong organizational and project management skills to ensure accurate and timely reporting.

Samuels-Pomca Solutions | Jan 2011 - Jan 2013

Website/Oracle 10G Assistant Instructor

Website Development: • Taught students the fundamentals of HTML, CSS, and JavaScript to create responsive and visually appealing websites. • Provided hands-on training on WordPress and Joomla for building and managing content-rich websites. Database Management with Oracle 10G: • Instructed students on configuring and managing Oracle 10G databases, covering essential aspects such as installation, setup, and maintenance. • Guided students through advanced SQL queries and database optimization techniques, showcasing problem-solving skills and attention to detail. • Emphasized data security and integrity by teaching best practices for backup, recovery, and user access management. Course Material Development: • Developed comprehensive and engaging course materials, including lecture notes, tutorials, and hands-on exercises. • Continuously update course content to reflect the latest industry trends and technologies, demonstrating a commitment to lifelong learning and professional development. Student Support: • Provided personalized support to students, addressing their questions and concerns with patience and empathy. • Foster a positive learning environment that encourages collaboration and active participation, utilizing Google Meet and Zoom for virtual classes and office hours. • Exhibited strong communication and interpersonal skills to build rapport with students and create a supportive educational experience. Assessment and Feedback: • Designed and administered quizzes, exams, and practical assignments to evaluate student progress and comprehension. • Offer constructive feedback and guidance to help students improve their skills and knowledge, highlighting strengths and areas for development. Collaboration: • Worked closely with other instructors and staff to develop and implement effective teaching strategies and curriculum improvements. • Exhibited strong teamwork and collaboration skills, contributing to a cohesive and dynamic instructional team.

My Education

Take a look at my formal education

Master's degree, Data Science in Data ScienceNorthumbria University | 2024
Data Accelerator, Data AnalyticsUtiva | 2021
Data Incubator, Data Analytics Utiva | 2021
Bachelor's degree, Computer Science in Computer/MathematicsLagos State University | 2011
Profession Diploma in Statistics in StatisticsUniversity of Ibadan | 2004

About Me

Samuel Adeolu Olusegun

I'm a data professional who transforms insights into impactful results, with proficiency in Advanced Excel, Power BI, Tableau, SQL, and Python. I am curious, and dynamic, transforming complex data into clear, actionable insight to drive decision.

Powered by

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