Charity Ileigo Okpanachi

Data Analyst

LinkedIn

About

Highly analytical and detail-oriented Data Analyst with practical experience in end-to-end data lifecycle management, from collection and cleaning to advanced visualization. Proficient in Python, SQL, Power BI, and Tableau, adept at transforming complex datasets into actionable insights that drive strategic decision-making and enhance business performance. Proven ability to identify trends, patterns, and anomalies, committed to optimizing processes and delivering measurable outcomes through data-driven solutions.

Work Experience

Remote Data Analyst Intern

Intern Career

Jul 2024 - Aug 2024

Remote, IN

Led data analysis and visualization initiatives, extracting actionable insights to support policy decision-making and enhance data accessibility.

  • Analyzed a dataset of 1,000 YouTube streamers, identifying trends in audience engagement and growth.
  • Conducted comprehensive data exploration and trend analysis, computing key performance metrics and visualizing patterns to inform stakeholder reporting.
  • Designed and developed an interactive Power BI dashboard to visualize global terrorism trends, including attack locations and casualties, enhancing data accessibility.
  • Prepared and cleaned the Global Terrorism Database, addressing missing data and outliers to ensure 100% data accuracy and consistency for analysis.
  • Delivered comprehensive analytical reports on regional impacts, providing data-driven insights that directly supported policy decision-making.

Private Tutor

Private Tutor

Jan 2023 - Apr 2024

Lagos, Lagos, NG

Provided personalized academic support to over 10 students, improving academic performance by 30% and achieving a 90% exam success rate.

  • Developed personalized learning plans for over 10 students, improving their academic performance by 30%.
  • Implemented strategic exam preparation techniques, achieving a 90% success rate for students in external examinations.
  • Conducted regular progress assessments and provided tailored feedback, enhancing student learning outcomes by 25%.
  • Utilized diverse instructional materials, including textbooks and multimedia resources, to deliver engaging and effective lessons.
  • Collaborated effectively with parents to establish achievable academic goals and track student progress, strengthening communication and trust.

Remote Extern

Beats by Dre

Sep 2023 - Oct 2023

Remote, US

Conducted sentiment and exploratory data analysis on consumer reviews, providing actionable insights that optimized marketing and brand strategies.

  • Conducted Python-based sentiment analysis on consumer reviews, delivering actionable insights that improved understanding of customer satisfaction and brand perception.
  • Applied Exploratory Data Analysis (EDA) techniques to uncover key consumer trends, directly influencing and optimizing marketing strategies.
  • Created insightful data visualizations using Python libraries, translating complex data into actionable insights that contributed to strategic brand-building initiatives.
  • Leveraged Natural Language Processing (NLP) tools, including Gemini AI, to extract and deliver critical insights from customer feedback, enhancing comprehension.

Tech Virtual Intern

GAOTek Inc

Aug 2023 - Oct 2023

New York, New York, US

Optimized product sourcing and information management, reducing procurement time and enhancing clarity for client presentations.

  • Conducted comprehensive product sourcing and identified high-quality suppliers, reducing procurement time by 20%.
  • Promoted company products across social media platforms, significantly increasing audience engagement.
  • Organized and managed product information using advanced MS Office tools, ensuring 100% data consistency for streamlined access.
  • Assisted in developing clear and concise product specifications and overviews, enhancing clarity for client presentations.
  • Contributed innovative ideas during daily virtual team meetings, optimizing sourcing strategies and communication workflows.

Class Teacher/Admin Support

Rose Park Private School

Jan 2018 - Aug 2022

Lagos, Lagos, NG

Managed administrative and teaching responsibilities for 300+ students, optimizing school operations and enhancing staff efficiency by 20%.

  • Managed school event budgets, optimizing fund utilization by 15% to maximize resource allocation.
  • Streamlined record-keeping processes, reducing document retrieval time by 40% and improving administrative efficiency.
  • Coordinated annual school-wide examinations for over 300 students, ensuring 100% compliance with regulatory standards.
  • Facilitated teacher training sessions, enhancing teaching quality and boosting staff efficiency by 20%.
  • Resolved parent and student queries effectively, improving overall satisfaction rates and fostering positive relationships.

Teacher (NYSC Associate)

Sycro Model College

Jun 2015 - May 2016

Ekiti, Ekiti, NG

Delivered structured lessons and analyzed student performance data, boosting overall class performance by 20%.

  • Delivered structured lessons and supervised examinations, fostering a disciplined and effective learning environment.
  • Analyzed student performance data to identify key improvement areas, boosting overall class performance by 20%.
  • Organized and maintained a detailed grading system, ensuring 100% accuracy in student records and progress tracking.
  • Provided actionable insights on student behaviors and performance, enhancing student engagement strategies.

Office Clerk (SIWES)

Tin-can Island Container Terminal

May 2013 - Dec 2013

Lagos, Lagos, NG

Streamlined administrative processes and managed client inquiries, reducing document handling time by 25% and improving retrieval efficiency by 30%.

  • Streamlined package management processes, reducing handling time by 25% and improving operational efficiency.
  • Organized and digitized company files, improving document retrieval efficiency by 30%.
  • Addressed client inquiries effectively, maintaining a client satisfaction rate of 95%.
  • Supported daily logistical operations, ensuring timely and accurate package deliveries.

Education

Pure and Applied Mathematics

Federal University of Technology, Minna

Sep 2010 - Dec 2014

Minna, Niger, NG

Certificates

Data Analytics/Science

Utiva

Nov 2023

Soft Skills and Behavioural Assessment

Utidia

Jun 2023

Cybersecurity Essentials

UNITES Cisco Networking Academy

May 2021

Soft Skills Training

Jobberman

Jul 2020

Proficiency in Management (Chartered)

Nigerian Institute of Management

Aug 2016

Languages

English

Skills

Excel

  • Advanced Statistical Analysis

SQL

  • Database Querying

Python

  • Data Analysis
  • Data Visualization
  • Pandas
  • NumPy
  • Matplotlib

Data Visualization Tools

  • Power BI
  • Tableau
  • Dashboard Design
  • Data Storytelling

Data Preprocessing

  • Data Cleaning
  • Data Preparation
  • Missing Data Handling
  • Outlier Detection

Data Governance

  • Data Privacy
  • GDPR Compliance
  • Data Protection Regulations

Cybersecurity Fundamentals

  • Cybersecurity Principles
  • Information Security

Communication

  • Effective Communication
  • Data Storytelling

Collaboration

  • Cross-functional Collaboration
  • Teamwork

Critical Thinking

  • Problem Solving

Time Management

  • Organization

Customer Focus

  • Customer Service
  • Client Relations

Natural Language Processing (NLP)

  • Gemini AI
  • Sentiment Analysis

Exploratory Data Analysis (EDA)

  • Trend Analysis

Project Management

  • Coordination
  • Budget Management