Daniel Berhanu

Analytical and results-oriented Data Analyst experienced in transforming complex, raw datasets into clear, actionable business insights. Experienced with utilizing Excel, SQL, Python, Power BI, Power Query, and DAX to execute end-to-end data cleansing, ETL processes, trend analysis, and interactive dashboard development. Proven ability to bridge the gap between technical data engineering and business strategy to support leadership with reliable, data-driven decision-making.

Freelance Data Analyst - ioToad East Africa

(2019-06 - 2020-09)

• Interactive Visual Storytelling: Developed interactive, insight-driven dashboards in Power BI to transform complex, multi-source datasets into clean visual narratives that enhanced data accessibility for cross-functional partners.
• KPI & Performance Reporting: Formulated custom business metrics, KPIs, dynamic maps, and drill-through reports using DAX, Power Query, and Excel to track historical performance and support data-driven decision-making.

Data Analyst - Quintal & Co, Financial Services

(2022-09 - 2023-11)

• Financial Analytics & Insights: Translated raw portfolio performance and financial transaction data into actionable operational insights using Excel and SQL to support executive portfolio reviews.
• Automated Dashboard Reporting: Developed and deployed interactive Power BI dashboards focused on automated KPI reporting, replacing manual processes and reducing weekly reporting prep time by 25%.
• Large-Scale Data Auditing: Cleaned and structured transactional databases exceeding 50,000+ records with SQL (utilizing Joins, CTEs, Window Functions, Aggregations, and Subqueries) and Power Query, identifying and resolving schema conflicts and data anomalies to establish a high-integrity source of truth.

Freelance / Part-time Data Analyst (Remote) - Upwork - Remote

(2023-07 - 2025-10)

• Interactive Dashboard Development: Built an interactive Data Jobs Dashboard using Power BI, Power Query, and DAX to track global salaries and hiring demand across 5,000+ tech roles, establishing actionable KPI tracking for job-market trends.
• Data Quality & Cleansing: Cleaned and modeled over 10,000+ records of complex, unstructured materials data using Power Query and Excel, standardizing schema anomalies to improve data consistency and reliability for forecasting.
• Exploratory Data Analysis (Python): Performed statistical trend and cyclical pattern analysis on client datasets utilizing Python (Pandas, NumPy, and Matplotlib) to clean data, identify anomalies, and build exploratory visualizations, supporting operational planning.
• Robust ETL Processes: Developed automated data transformation workflows using Power Query to seamlessly ingest, clean, and merge diverse flat-file data sources, eliminating manual Excel data prep.

Bachelor - Software Engineering - Microlink Information Technology College