samatar Abdirahman Ali

I am an ICT graduate and emerging Data Analyst focused on transforming complex raw datasets into actionable business insights. I possess a strong technical foundation in SQL, Python, Power BI, and Excel, with specific proficiency in managing end-to-end ETL processes and developing dynamic KPI visualization dashboards. By integrating robust data cleaning techniques with core machine learning concepts, I bridge the gap between technical metrics and strategic decision-making. I am now seeking to apply my analytical rigor and data modeling skills to help global organizations solve high-impact challenges through evidence-based analysis.

1. AB

   Data Analyst Intern

   Amal Bank

   • Analyzed operational datasets using SQL queries and Microsoft Excel functions to surface actionable business trends.
   • Collected, cleaned, and organized financial data records to maintain strict reporting standards across departments.
   • Prepared summarized reporting decks and data visualizations to inform banking management and leadership decisions.
   • Monitored and maintained database entries to ensure data integrity and eliminate redundant records.
   • Assisted senior analysts with recurring audit schedules and cross-departmental data reconciliation tasks.
   • Collaborated with operational units to refine data reporting formats and enhance workflow visibility.
2. BP

   Field Data Enumerator

   BAHDA Project

   • Collected and recorded primary field survey data efficiently utilizing mobile digital forms on KoboToolbox.
   • Validated incoming survey records on-site to verify completeness, consistency, and structural accuracy.
   • Enforced rigorous data verification protocols to minimize collection bias and eliminate reporting errors.
   • Structured and organized raw field records into standardized datasets ready for senior analyst evaluation.
   • Liaised with community respondents and team supervisors to ensure timely completion of target coverage areas.
3. PP

   Data Administrator & Data Analyst

   Personal Project

   • Architected relational database schemas and implemented database constraints within Microsoft SQL Server.
   • Programmed optimized SQL queries and stored procedures to handle high-volume data retrieval tasks.
   • Authored Python scripts using Pandas and NumPy to clean, normalize, and transform unstructured source datasets.
   • Built dynamic Power BI dashboards featuring custom DAX measures for core business metric tracking.
   • Produced comprehensive business analytics documentation to outline database architecture and analytical conclusions.
4. PP

   Construction Project Data Analyst

   Personal Project

   • Extracted and integrated construction operational records using SQL Server to establish centralized reporting tables.
   • Evaluated capital budgets, expense patterns, and contractor disbursements to isolate cost variances.
   • Constructed interactive Power BI dashboards to track milestone delivery, expenditures, and financial health.
   • Formulated tailored DAX measures to calculate budget variances and project cost-performance indices.
   • Delivered summarized analytical evaluations highlighting key operational expenditure bottlenecks and savings opportunities.