Joy Njeru

JOY WAWIRA NJERU Data Analyst | Reporting Automation | Power BI | SQL | Excel Expert Email:- PROFESSIONAL SUMMARY Data Analyst specializing in SQL, Excel, and Power BI to deliver high-impact dashboards and automate business reporting. Designed systems that reduced reporting time by 30% and streamlined CRM workflows. Proficient in transforming multi-source datasets into actionable insights for operational and marketing teams. Adept at cleaning, joining, and analyzing large datasets using SQL and Excel, and building dynamic dashboards in Power BI to support strategic decision-making. Passionate about leveraging data to optimize operations and drive measurable business outcomes. EXPERIENCE Data Analyst Intern SUNKING SOLAR COMPANY – EMBU, Kenya Jan 2024 – Present • • • • • • Built Power BI dashboards tracking daily SKU sell-through and customer conversion rates → used weekly by the marketing team to optimize inventory clearance. Automated sales and inventory reporting using Excel + Power BI → saved 6 hrs/week in manual reporting and improved executive decision-making. Wrote advanced SQL queries to clean, join, and aggregate CRM + inventory data for realtime dashboard integration. Developed Excel-based templates with dynamic formulas and pivot tables to streamline monthly reporting. Conducted data audits and reconciliations in SQL to ensure data accuracy and completeness. Contributed to team sprints, offering Excel and Power BI optimization tips for more efficient processes. EDUCATION DataCamp (Online) Track: Data Analysis | Ongoing – Expected Completion: July 2024 TOOL STACK IN PRACTICE • • • • • • • SQL (PostgreSQL) — used to clean, join, and aggregate CRM and inventory datasets for business reporting Power BI — built automated dashboards for tracking sales, inventory, and marketing KPIs Excel (Advanced) — designed templates with formulas, pivot tables, and charts for ad hoc and recurring reports Make.com — used for syncing external data sources into reporting tools Python — applied in basic EDA projects for churn and trend analysis (in progress) Power Automate — set up basic workflows for scheduling and alerting PowerPoint — presented data insights from Power BI and Excel visualizations to teams CERTIFICATIONS • • • • Data Analytics with Excel & Power BI | Coursera (2024) AI Automation with Make.com | Self-Learning Project (2024) Introduction to Python | DataCamp (2024) Customer Service | Alison Online School PROJECTS Sales Reporting Automation (2024) • • Automated weekly sales reporting using SQL and Power BI; reduced reporting time by 30% and increased stakeholder access to real-time data Designed Excel dashboards for sales and marketing teams to analyze regional performance and customer trends Inventory Dashboard Development (2024) • • Used SQL and Power BI to build a live dashboard tracking product-level inventory changes and reorder triggers Helped operations team reduce stockouts by 25% through proactive inventory planning SOFT SKILLS • Strong analytical thinking, attention to detail, and process optimization • • Excellent communication and teamwork in fast-paced environments Proactive problem-solver with a focus on results and continuous learning LANGUAGES • • English: Proficient Swahili: Native