Hi, I'm Samatar

Database Administrator | Data Analyst

I manage databases and data, administer SQL Server databases, perform data analysis, and create interactive Power BI dashboards that turn data into actionable insights.

SQL · Excel · Python · Power BI · ETL · SQL Server
View CV View Projects
Samatar Abdirahman Profile

About Me

IT Graduate with experience in Data Administration and Data Analysis. Skilled in SQL Server database management, ETL processes, data cleaning and validation, and building interactive dashboards with Power BI. Passionate about maintaining data quality, optimizing data processes, and transforming raw data into actionable insights.

0

Records Processed

0

Projects Completed

0

ETL Pipelines

0

Dashboards Built

Education

Amoud University
Bachelor of Information Technology (2022 – 2026)

Focused on Data Administration, Database Management, and Data Analytics.

Skills

Database Administration

Database management & design
Backup and Restore
security management
performance optimization
data integrity
Data Migration
maintenance and monitoring

Data Analysis & BI

SQL
Power BI & DAX
Excel Data Analysis
Python Pandas
Data Cleaning & Validation
Data Visualization
KPI & Business Analysis

Tools & Technologies

Microsoft SQL Server
Power BI
Microsoft Excel
Python / Jupyter Notebook
ETL
Git & GitHub

Services

Data Administration

Database design & management

ETL Development

Scalable data pipelines

Data Analysis

Actionable business insights

Dashboard Development

Power BI dashboards

Data Cleaning

Preprocessing & quality assurance

Featured Projects

SQL Server Database Management System

Designed and implemented a relational database using SQL Server for managing and organizing business data. Developed tables, relationships, stored procedures, and validation logic to maintain data integrity and support efficient data management and reporting.

Focus: Database Design, SQL Server & Data Management

SQL Server T-SQL Database Design Stored Procedures Data Integrity

Sales Performance Analysis

Developed an interactive Power BI dashboard to analyze sales performance, revenue, products, customers, and business trends. Created DAX measures and interactive visualizations to provide meaningful insights and support data-driven decision making.

Focus: Data Analysis, Sales KPIs & Business Intelligence

Power BI DAX SQL Data Modeling Data Visualization

Customer Database Management System

Designed and implemented a relational database using SQL Server for managing customer and business information. Created relationships, stored procedures, and validation logic to maintain data integrity and support efficient database operations and reporting.

Focus: Database Management, Data Integrity & SQL Server

SQL Server T-SQL Database Design Stored Procedures Data Validation

Experience

Data Administrator & Data Analyst

Personal Project

  • Designed and managed relational databases using Microsoft SQL Server.
  • Developed SQL queries, stored procedures, and database solutions for data management and reporting.
  • Cleaned, validated, and transformed datasets using SQL and Python.
  • Developed interactive Power BI dashboards and DAX measures to analyze business performance and KPIs.
  • Prepared data and reports to support data-driven business decisions.

Construction Project Data Analysis

Personal Project

  • Analyzed construction project data using SQL Server and Power BI.
  • Analyzed project budgets, expenses, payments, and financial performance.
  • Developed Power BI dashboards to monitor project KPIs, budget performance, and expenses.
  • Created DAX measures for financial analysis and project performance reporting.

Data Collection – BAHDA

Borama, Somaliland

  • Participated in data collection for the BAHDA project conducted in Borama.
  • Collected and recorded field data using KoboToolbox.
  • Ensured accurate and complete data entry during the data collection process.
  • Reviewed collected data for consistency, completeness, and quality.
  • Supported the organization and preparation of collected data for further analysis.

Data Analyst Intern

Amal Bank

  • Supported data analysis and reporting activities during the internship.
  • Collected, cleaned, and organized data for analysis and reporting.
  • Used SQL and Excel to analyze datasets and generate useful insights.
  • Prepared reports and summaries to support business and operational decision-making.
  • Assisted in maintaining data accuracy and consistency across datasets.

Let's Work Together

Open for Data Administration & Data Analysis opportunities

Hire Me

Contact

samataryare088@gmail.com
+252 636558966
Borama, Somaliland
github.com/samatar-yare