Data Analyst Power Bi

Amara joy

Nigeria 081******** ***************@*****.*** LinkedIn.com/in/amara-joy-ekpunobi-5b880482 EDUCATION

Enugu state University Enugu state

2nd Class lower Graduation Date: Aug 2024

WORK EXPERIENCE

Goglow Hub Owerri Imo state

Data Analyst Jan 2024 - Feb 2025

Collect, clean and organize data from various sources to ensure data accuracy and completeness Collect, clean, and analyze large datasets to support business goals Create dashboards and reports using tools like Tableau, Power BI, or Looker Write and optimize SQL queries to extract data from relational databases Perform data validation and ensure data accuracy

Present findings and recommendations clearly to non-technical teams Work with stakeholders to define KPIs and measure performance Identify trends, patterns, and opportunities for improvement Assist with A/B testing and statistical analysis when needed DBASEDOTNET owerri, Imo state

Website development Jan 2023 - Jan 2024

Design, code, and deploy websites using HTML, CSS, JavaScript, and modern frameworks Collaborate with UI/UX designers to implement responsive and interactive web interfaces Maintain and improve existing websites and web apps Optimize sites for speed, SEO, and accessibility

Troubleshoot and debug cross-browser or platform issues Integrate APIs and third-party services as needed

Participate in code reviews and contribute to best practices POLARIS BANK Owerri, Imo state

customer service Mar 2018 - Jan 2023

Respond to customer inquiries via phone, email, live chat, or social media Resolve product or service issues quickly and professionally Maintain accurate records of customer interactions in the CRM system Follow up on customer concerns to ensure complete resolution and satisfaction Work closely with other departments (sales, shipping, tech support, etc.) to solve problems Identify recurring issues and suggest process improvements Meet or exceed customer satisfaction and response time targets PROJECT EXPERIENCE

Goglow Hub Owerri, Imo state

DATTA ANALYST PROJECT Jan 2024 - Feb 2024

Collect, clean, and organize data from diverse sources to ensure accuracy and completeness. Perform data analysis using statistical methods and software (e.g., Python, R, Excel) to uncover trends, patterns, and actionable insights.

Create visual reports and interactive dashboards (using tools like Tableau, Power BI) to communicate findings effectively to stakeholders.

Assist in developing data models and predictive analytics to support strategic decision-making and forecasting. Collaborate with cross-functional teams (e.g., marketing, sales, operations) to understand their data needs and provide relevant insights.

Monitor data quality continuously, identifying and recommending improvements in data collection, organization, and analysis processes.

Ensure data confidentiality and compliance with data protection regulations to safeguard sensitive company information.

1. Customer Churn Analysis

Goal: Identify patterns in customer behavior to predict who’s likely to stop using a service (churn). Skills:

SQL (querying customer & transaction data)

Python (Pandas, Matplotlib, Seaborn)

Logistic regression or decision tree (basic ML)

Business insight writing

Bonus: Build a dashboard in Tableau to show at-risk segments. 2. Sales Performance Dashboard

Goal: Visualize regional, monthly, and product-wise sales to find top performers and lagging areas. Skills:

Excel / Google Sheets or SQL for data prep

Tableau or Power BI for interactive dashboards

KPI analysis (e.g., revenue, profit margin, growth rate) Bonus: Add filters and drill-downs for interactivity. 3. A/B Testing Analysis (Marketing or App Feature) Goal: Analyze results of an A/B test to determine if a change (like a new email or feature) improved conversion. Skills:

Statistics (hypothesis testing, p-values)

Python (Scipy/Statsmodels) or Excel

Data storytelling: Explain findings to non-technical audience Bonus: Simulate your own test using public data or mock data. 4. Exploratory Data Analysis (EDA) on a Public Dataset Goal: Find trends, correlations, and outliers in open data. Ideas:

Kaggle Datasets: e.g., Airbnb, Netflix, COVID, Olympics Government Data: e.g., U.S. Census, World Bank

Skills:

Python (Pandas, Matplotlib, Seaborn)

Data cleaning & wrangling

Visual storytelling (charts, heatmaps, correlation matrices) 5. SQL Project with a Sample Database

Goal: Answer business questions using SQL.

Example Questions:

Which customers made the most purchases last month? What’s the average order value by region?

What products are frequently bought together?

Tools:

SQL (PostgreSQL, MySQL, or SQLite)

Chinook, Sakila, or Northwind databases (available free online) Jupyter Notebook or DB Fiddle to present

LEADERSHIP EXPERIENCE

DOMINION CITY INSTITUTE OWERRI, IMO STATE

DOMINION LEADERSHIP INSTITUTE Jun 2020 - Aug 2020

1. Leading Data-Driven Projects

Led a cross-functional team to deliver actionable insights from sales data that resulted in a 15% increase in quarterly revenue.

Coordinated data collection across marketing, sales, and product teams to ensure alignment and consistency. Directed the development of interactive dashboards to track key performance indicators (KPIs) and presented findings to senior leadership.

Oversaw the integration of external data sources for a comprehensive analysis, improving decision-making processes.

2. Mentoring Junior Data Analysts

Provided mentorship to junior analysts, helping them improve data-cleaning techniques and statistical analysis skills. Guided them through the use of advanced analytical tools like Python and SQL for efficient data manipulation and extraction.

Conducted training sessions on data visualization best practices to ensure consistency across reports. Fostered a collaborative environment by offering feedback on their analyses and encouraging knowledge-sharing. 3. Implementing Process Improvements

Led an initiative to improve the data quality assurance process, reducing errors in reports by 30%. Analyzed existing data pipelines and identified bottlenecks that led to data inaccuracies. Developed a new system for automated data validation, saving the team 10+ hours per week. Trained team members on the new process, ensuring consistent application across all datasets. 4. Driving Data Strategy and Insights

Initiated and executed an ongoing project to analyze customer behavior, providing strategic insights that influenced marketing campaigns.

Partnered with marketing and product teams to understand business goals and tailored analysis to support these objectives.

Championed the creation of weekly performance reports, providing leadership with actionable insights to adjust marketing strategies in real-time.

Collaborated with senior management to set KPIs, ensuring all data analyses were aligned with business goals. 5. Advocating for Data-Driven Culture

Advocated for and led the transition to a more data-driven approach within the company, increasing the adoption of analytics tools across departments.

Led workshops and presentations to educate non-technical departments on the value of data and the tools available to them.

Promoted the use of self-service analytics platforms (e.g., Tableau) to empower teams to explore data independently.

Created documentation and best practices to ensure long-term adoption of new tools and processes. SKILLS & INTERESTS

Skills : Technical Skills

Excel – basic to advanced functions, pivot tables, VLOOKUP/XLOOKUP SQL – for querying databases

Python or R – for data cleaning, analysis, and visualization (Python is more common) Data Visualization Tools – Tableau, Power BI, or even matplotlib/seaborn in Python Statistics/Analytics – understand basic stats, A/B testing, regression, etc.

Soft Skills

Communication: Explaining data insights clearly

Critical Thinking: Spotting trends, asking the right questions Business Acumen: Understanding company goals and how your analysis supports them Microsoft Office (Excel, Word, PowerPoint)

Contact this candidate