Below is a strong ATS-friendly version based strictly on the information provided. # PROFESSIONAL RESUME ## David Okafor Lagos, Nigeria | Phone | Email | LinkedIn/Portfolio ### PROFESSIONAL SUMMARY Entry-level Data Analyst with a B.Sc. in Statistics and practical training in Excel, SQL, Power BI, and Python. Experienced in data cleaning and record organization through an internship, with additional hands-on practice creating sales and customer dashboards using sample datasets. Strong foundation in data analysis, visualization, problem-solving, and communicating insights clearly. Seeking to contribute analytical and technical skills as a Junior Data Analyst. ### CORE SKILLS * Data Analysis * Excel * SQL * Power BI * Python * Data Cleaning * Data Visualization * Dashboard Development * Statistical Analysis * Problem-Solving * Analytical Thinking * Communication * Data Organization ### PROFESSIONAL EXPERIENCE **Data/Records Intern — Company Name** Lagos, Nigeria | Dates * Helped organize and maintain company records to improve the accessibility and structure of business information. * Assisted with cleaning company records and identifying information requiring organization or correction. * Supported accurate record management through careful review and organization of company data. * Applied attention to detail and problem-solving skills when working with business records. ### EDUCATION **Bachelor of Science (B.Sc.) in Statistics** University of Lagos Lagos, Nigeria | Graduation Date ### TRAINING **Data Analytics Training — 6-Month Program** * Developed practical skills in Excel, SQL, Power BI, and Python. * Practiced data analysis and visualization using sample datasets. * Created sales dashboards to organize and present business data. * Created customer dashboards to support data interpretation and visualization. * Built foundational knowledge of data cleaning, analysis, and business-focused reporting. ### PROJECTS **Sales Dashboard Project** * Created a sales dashboard using a sample dataset to organize and visualize sales-related information. * Applied data analysis and visualization techniques to present information in an accessible format. **Customer Dashboard Project** * Created a customer dashboard using a sample dataset to analyze and visualize customer-related information. * Used dashboard visualization techniques to present data clearly and support interpretation. ### ADDITIONAL RELEVANT INFORMATION * Strong analytical and problem-solving abilities * Strong communication skills * Foundational knowledge of statistical concepts through academic study in Statistics * Practical exposure to data analysis tools through structured training and projects --- # ATS & APPLICATION REVIEW ### ATS Keywords **Junior Data Analyst, Data Analysis, Data Cleaning, Data Visualization, Excel, SQL, Power BI, Python, Statistical Analysis, Dashboard Development, Analytical Problem-Solving, Business Data, Data Organization, Data Reporting** ### Resume Strengths * **Strong academic foundation:** A B.Sc. in Statistics is highly relevant to analytical work. * **Relevant technical skills:** Excel, SQL, Power BI, and Python directly align with the target job description. * **Practical exposure:** The training and dashboard projects demonstrate hands-on application rather than only theoretical knowledge. * **Internship experience:** Record organization and data cleaning provide relevant entry-level experience. * **ATS-friendly structure:** The resume uses standard headings, straightforward formatting, and relevant keywords without keyword stuffing. ### Missing or Weak Areas The following information would make the resume substantially stronger: 1. **Internship details** * Company name * Exact job title * Start and end dates * Specific responsibilities * Any measurable results 2. **Technical proficiency** * Specific Excel skills, such as PivotTables, XLOOKUP, Power Query, or formulas * SQL capabilities, such as JOINs, GROUP BY, subqueries, or window functions * Power BI capabilities, such as DAX, Power Query, data modeling, or interactive dashboards * Python libraries used, such as pandas, NumPy, or Matplotlib 3. **Projects** * Dataset used * Specific questions analyzed * Tools used * Findings or insights discovered * Number of records or variables analyzed, if known * Links to dashboards, GitHub, or portfolio projects 4. **Education details** * Graduation year * Relevant coursework, if useful * Academic projects or achievements 5. **Contact and professional presence** * Phone number * Professional email * LinkedIn profile * GitHub or data analytics portfolio ### Improvement Suggestions * Add **2–3 more data analytics projects** using realistic business datasets. * Build a small **GitHub or portfolio collection** containing SQL analysis, Excel analysis, Power BI dashboards, and Python projects. * Quantify internship contributions wherever the actual numbers are known. For example, the candidate could state the number of records organized or cleaned rather than using an unsupported percentage. * Add specific technical capabilities under each tool instead of listing only the software names. * Include relevant certifications if actually completed. * For each project, describe the **problem, tools used, analysis performed, and key findings**. * Keep the final resume to approximately **one page** if the candidate remains at entry level. ### Truthfulness Check No employers, job titles, certifications, dates, achievements, performance metrics, or technical capabilities beyond those supplied were invented. Placeholder fields such as **Phone, Email, LinkedIn/Portfolio, Company Name, Dates, and Graduation Date** should be completed by the candidate before submitting the resume. If you provide David's **internship company/title/dates, graduation year, specific Excel/SQL/Power BI/Python skills, and any project findings**, this can be upgraded into a much stronger job-application version.