Molla Adugna
Strategic Data Analyst | 18+ Years Clinical Expertise
New to Contra
Molla is ready for their next project!
Legacy Data Conversion (PDF to Excel)
Overview: Engineered a solution to extract and structure previously "trapped" data from unstructured PDF reports.
The Problem: Vital historical data was inaccessible for analysis due to being stored in non-editable PDF formats.
The Solution: Developed a Power Query extraction process to convert unstructured reports into clean, tabular Excel datasets.
Outcome: Successfully integrated legacy data into the modern BI ecosystem for comprehensive trend analysis.
0
7
Executive KPI Dashboard Creation
Overview: Designed a professional, interactive business intelligence dashboard for C-suite decision-makers.
The Problem: Leadership lacked visibility into core performance metrics and trend analysis.
The Solution: Built a unified dashboard featuring high-level KPIs, trend charts, and drill-down capabilities.
Outcome: Provided a "single source of truth" that drove faster, more informed strategic decisions.
Tools: Excel, Power Query, Visualization Principles.
0
12
Dynamic Data Restructuring &
Analytics
Overview: Advanced data modeling project focused on unpivoting complex tables and building interactive exploration tools.
The Problem: Static, poorly structured data prevented stakeholders from uncovering granular insights.
The Solution: Restructured datasets into relational formats and designed interactive pivot charts with integrated slicers.
Outcome: Enabled stakeholders to perform self-service discovery and explore trends dynamically.
Tools: Power Query, Excel Pivot Tables, Slicers.
0
30
ETL Automation with Power Query
Overview: Developed an end-to-end automated ETL (Extract, Transform, Load) workflow to handle messy raw datasets.
The Problem: Manual data cleaning was causing significant delays and reporting inaccuracies.
The Solution: Leveraged Power Query to automate data ingestion and normalization, transforming raw data into analysis-ready formats.
Outcome: Eliminated manual effort and ensured 100% data accuracy for downstream reporting.
Tools: Excel, Power Query (M-Code).
0
35