Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Hermella Assefa

Aurora,CO

Summary

Dynamic and results-driven Data Analyst and BI Developer with over 4 years of experience in leveraging data to drive business insights and decision-making. Proficient in Advanced SQL, Power BI, SSIS, ADF, and Python. Seeking a challenging role to apply expertise in data analysis, visualization, and solution development to contribute to organizational success.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Validator

Colorado Department Of Personnel Administration
03.2024 - Current
  • Maintained exceptional attention to detail while reviewing large volumes of complex information for accuracy and consistency.
  • Trained and assisted staff in validation techniques, methods, and testing processes.
  • Conducted regular audits of validation processes to identify areas for improvement and increase efficiency.

Data Analyst | BI Developer

Global Automotive Imports Of Denver
09.2022 - Current
  • Designed and implemented data visualizations and dashboards using Power BI to communicate insights effectively.
  • Developed and optimized SQL queries, stored procedures, and views for data analysis, reporting, and performance monitoring.
  • Created complex data models and implemented data warehouse solutions to support business reporting and analytics requirements.
  • Performed data cleansing and transformation tasks using SSIS to streamline data integration processes.
  • Collaborated with cross-functional teams to identify opportunities for process improvement and optimization.
  • Provided technical expertise and support for data-related initiatives and projects.

Data Analyst

US Bank
06.2020 - 07.2022
  • Developed end-to-end BI solutions, including data modeling, ETL processes, and report/dashboard development using Power BI.
  • Conducted data analysis and interpreted results to provide actionable insights and recommendations.
  • Implemented data integration solutions using SSIS to extract, transform, and load data from multiple sources.
  • Utilized Python for data manipulation, analysis, and automation tasks.

Education

Bachelor of Science - Computer Science

Truman State University
Kirksville, MO
05.2026

Associate of Arts - Sales And Markating

Golden Sales Training Institute
Addis Ababa, Ethiopia
05.2021

Skills

  • Business Intelligence Tools: Power BI, SSIS, and Azure Data Factory (ADF)
  • Programming Languages: Python
  • Data Analysis: Data Visualization, Data Modeling, and ETL
  • Database Technologies: SQL Server, Azure SQL Database
  • Other Tools: Microsoft Excel

Certification

Nanolink data analyst training

Timeline

Data Validator

Colorado Department Of Personnel Administration
03.2024 - Current

Data Analyst | BI Developer

Global Automotive Imports Of Denver
09.2022 - Current

Data Analyst

US Bank
06.2020 - 07.2022

Bachelor of Science - Computer Science

Truman State University

Associate of Arts - Sales And Markating

Golden Sales Training Institute
Hermella Assefa