Abrha Gebrehiwet
Data Analyst Intern at Prompt BI
Computer Science at Mekelle University
Ethiopia
Hi, I'm Abrha Gebrehiwet!
Data Analyst Intern at Prompt BI
Results-driven Data Analyst with expertise in SQL, Python, Excel, and Power BI, specialized in solving climate and sustainability challenges through data-driven insights. Proficient in end-to-end analytics—including data wrangling, exploration, visualization, and machine learning—with focused applications in carbon accounting, ESG metrics, and climate risk analysis. Committed to leveraging data science to help organizations achieve net-zero targets and strengthen climate resilience amid evolving regulations.
Experience
Prompt BI
Data Analyst Intern
October 2025 - Present
Processed and standardized a dataset of over 100,000 rows from multiple regions to support weekly analytics—enabled business teams to track KPIs across geography and time.
Designed smart Excel templates embedded with lookup functions and pivot logic, saving 40% reporting time across 4 departments.
Developed and maintained Power BI dashboards to visualize revenue trends, customer mix, and monthly performance—regularly used by managers and analysts across business units.
Collaborated with 4 analysts and 2 senior managers to define and validate 6 KPIs, improving report reliability and strategic alignment.
Education
Certificates & Badges
No certificates or badges added
Projects
Backend Developer(Python)
A multi‑vendor ecommerce platform where multiple vendors can register, list and sell their products, while customers browse, cart, and checkout. Admins manage vendors, catalog, orders, refunds, and monitor performance with built‑in analytics.
Frontend: Vue 2/3 SPA (in src/), charting via vue-chartjs.
Backend: Flask + SQLAlchemy (in backend/).
Payments: Chapa checkout with webhook/callback verification.
Dashboards: Admin analytics (orders summary, sales over time, top categories), vendor management, refunds.
✨ Features
Multi-vendor cart → single or per‑vendor order creation
Chapa payment initialization, callback verification, and optional return URL suppression
Orders lifecycle: pending → paid/failed → completed/cancelled
Admin dashboard: counters, charts, recent orders
Vendor applications review and product management
Refund requests and processing
data analyst
Customer Behavior Analysis — Python, SQL, Power BI Nov 2025 – Dec 2025
– Analyzed behavior of 7,043 telecom customers to identify churn patterns based on tenure, contract type, and
monthly charges.
– Engineered new features including contract type buckets and tenure bands to improve segmentation and insights.
– Generated 11 visualizations (histograms, box plots, heatmaps) to highlight churn-prone segments.
– Revealed that 38% of churned users were on monthly contracts with less than 3-month tenure—suggested early
engagement strategies
Languages
Arabic
Professional
English
Professional
Amharic
Native
Skills
Data Analytics
Machine Learning
Python
Microsoft Power BI
Microsoft SQL