Data Analyst - SQL, Python, Power BI

DANIEL BERHANU

DATA ANALYST

Addis Ababa, Ethiopia ********************@*****.*** www.linkedin.com/in/daniel-berhanu PROFESSIONAL SUMMARY

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.

PROFESSIONAL EXPERIENCE

ioToad East Africa Freelance Data Analyst

June 2019 – September 2020 (1 yr 3 mos)

• 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. Quintal & Co, Financial Services Data Analyst

September 2022 – November 2023 (1 yr 2 mos)

• 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. Upwork Freelance / Part-time Data Analyst (Remote) July 2023 – October 2025

• 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.

EDUCATION & CERTIFICATIONS

Bachelor of Software Engineering

Microlink Information Technology College

• Verified Certificate: SQL for Data Science edX

• Verified Certificate: Data Engineering Basics for Everyone edX SOFT SKILLS

• Adaptability

• Resilience under pressure

• Strong communication skills

• Problem-solving mindset

• Self-discipline and time management

• Analytical thinking

TECHNICAL SKILLS

BI & Data Visualization

Power BI, Microsoft Excel (Pivot Tables, Power Pivot, VLOOKUPs, Charts), Dashboard Development, KPI

Reporting

Data Integration & ETL

Power Query, Extract, Transform, Load (ETL) Processes, Data Cleansing, Schema Alignment, Data Modeling

Databases & Programming

SQL (Joins, CTEs, Window Functions, Aggregations,

Subqueries, Relational Modeling), Python (Pandas,

NumPy, Matplotlib), Git, GitHub

LANGUAGES

• English (Full professional proficiency)

• Amharic (Native/bilingual proficiency)

• Tigrinya (Native/bilingual proficiency)

INTERESTS

Hiking & Chess: Develops methodical preparation, route planning, strategic foresight, and logical analytical reasoning.

Contact this candidate