DATA ANALYSIS
UKONU UGO EKE-| - | www.linkedin.com/in/ukonu-ugoeke
PROFESSIONAL SUMMARY
Detail-oriented and analytical aspiring Data Analyst Intern with hands-on experience in Excel and SQL for data management, analysis, and visualization. Strong problem-solving abilities with a keen eye for data trends and insights. Passionate about leveraging data-driven decision-making to drive business improvements. Background in Library and Information Science with experience in data entry, business consulting and services, and customer service. Proven ability to work in a remote team-oriented environment and deliver high-quality results with accuracy and attention to detail.
SKILLS
Data Analysis & Reporting: Excel (Pivot Tables, VLOOKUP, Charts, Conditional Formatting), SQL (Queries, Joins)
Quality Control & Data Validation: Creating standard QC reports, identifying and correcting data issues
Key Performance Indicators (KPI) Reporting: Generating daily, weekly, monthly, and yearly performance metrics
Database Management: SQL (MySQL)
Remote Work Tools: Google Suite, Microsoft Office, Communication Platforms
Soft Skills: Organized, Strategic, Inquisitive, Analytical, Proactive Communicator, Team Player
EDUCATION
Michael Okpara University of Agriculture, Umudike, Abia State
Bachelor of Library and Information Science (B.LIS) | Graduated: 2021
PROJECT EXPERIENCE
Sales Data Analysis Using Excel & SQL
Cleaned and organized raw sales data to improve accuracy and completeness.
Utilized SQL queries to extract key insights and detect trends in sales performance.
Created Excel dashboards with PivotTables and Charts to visualize revenue trends and customer behaviours.
Customer Retention Analysis
Analysed customer churn rate using Excel formulas and SQL queries.
Identified key factors contributing to churn and provided actionable insights.
Recommended data-driven strategies to improve customer retention.
C:\Users\pc\Desktop\SQL CATSTONE\BLINKIT ONLINE GROCERY MALL ANALYSIS.docx
C:\Users\pc\Desktop\SQL CATSTONE\Copy of Blinkit combine.xlsxC:\Users\pc\Desktop\CAPSTONE QUERY.docx
WORK EXPERIENCE
Customer Relationship Manager
Constel Investment Limited, Aba | Sept. 2020 - Oct. 2021
Managed customer inquiries, resolving issues swiftly and effectively to ensure satisfaction and loyalty.
Played a pivotal role in driving product improvements, leading to a significant 25% reduction in customer complaints.
Analysed customer feedback to provide actionable insights for product enhancement.
Data Entry Intern
Michael Okpara University Library, Umudike, Abia State | May 2018 - Nov. 2018
Assisted in organizing and maintaining information resources systematically.
Provided technical and logistical support for library users.
Monitored and compiled reports on resource usage and user feedback for continuous improvement.
CERTIFICATIONS & TRAINING
SQL for Data Analysis – [TDI]
Excel Advanced Training – [YouTube]
ALX Virtual Assistant Certificate
ADDITIONAL INFORMATION
Strong verbal and written communication skills.
Comfortable using headset and webcam for virtual communication.
Open to working in Mountain Standard Time (MST) or other remote schedules.
Reliable internet connection and computer specifications that meet remote work requirements.
Passionate about growth, long-term job security, and the opportunity to contribute to a global team.