Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kedamawit Biru

Aurora,CO

Summary

Dynamic Database Engineer devoted to maintaining reliable computer systems for uninterrupted workflows. Delivers up-to-date methods to increase database stability and lower likelihood of security breaches and data corruption. Offers detailed training and reference materials to teach best practices for system navigation and minor troubleshooting.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Engineer

National Storage Affiliates
Greenwood Village, CO
05.2019 - Current
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
  • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
  • Developed, implemented, supported and maintained data analytics protocols, standards and documentation.
  • Authored specifications for data processing tools and technologies.
  • Experience in MS SQL Server database design, development & administration in enterprise production environment
  • Experience in Data Architecture, Database design and data cleanups
  • Design and manage enterprise Data Warehouse, transform data using ETL tools
  • Design KPI reports, financial reports and development activity reports
  • Created On-demand and scheduled Reports using Excel, SSRS and Tableau
  • Enhanced SQL source queries by efficient tuning of queries for data load and performance

Data Analyst

Mental Health Partners
Lafayette, CO
07.2016 - 04.2019
  • Designed and implemented stored procedures, Views and other application database code objects
  • Maintained SQL scripts, indexes and complex queries for analysis and extraction
  • Performed quality testing and validating for SQL Servers
  • Worked with developers, project managers and production teams across needs and solution options
  • Ensured best practice application to maintain security and integrity of data
  • Parameterized Reports and Linked Reports using SSRS and created reports subscription schedule for senior management
  • Generate schedule reports on information for various categories and regions based on business needs using Reporting services (SSRS) for Monthly, Quarterly, and Annually reports
  • Strong experience in Extracting, Transforming and Loading data from various data sources like excel, flat file and CSV to SQL Server databases using SSIS SQL Server Integration services
  • Extensive experience using Joins and sub-queries for complex reports involving multiple tables from different databases
  • Responsible for creating and managing dynamic forms using Functions, Stored Procedures, Joins, and to fully support SmartCare Application

Report Developer

SMNE
12.2015 - 06.2016
  • Created On-demand Reports using Report Builder in SSRS and Power BI Desktop
  • Worked cross functionally with project managers and users to understand reporting requirements
  • Used complex expressions to group data, filter and parameterize reports
  • Created Stored Procedures to transform the data and worked extensively in T-SQL for loading the data
  • Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS and created reports subscription schedule for senior management
  • Recognized data issues and worked with business analyst and Senior DBA to resolve data-related problems

IT Help Desk

Ethiopian Telecommunication
07.2012 - 11.2015
  • Greeted clients and responded to guest inquiries, requests, and issues in a timely, personable, and efficient manner to resolve guest concerns
  • Transfer open issues to an IT specialist
  • Help and guide clients on login and activation process
  • Provide professional support to the customer base with the expectation of single call resolution, and
  • Manage Open issues that hasn’t been solved.

Education

BA - Business Administration and Information Systems

Addis Ababa University College of Commerce
06.2012

Skills

  • Data analysis
  • Technology leadership work streams
  • Excellent Communication
  • Teambuilding
  • Planning and Coordination
  • Multitasking Abilities
  • Dependable and Responsible

Certification

DA-100 Analyzing Data with Power BI

Power BI Tools: DAX Introduction

Basic Life Support - BLS

Microsoft Azure Fundamental AZ900 Amazon Web Server (AWS) Certified Microsoft MTA certified Ethiopian Women Leadership Program (EWLP) from

Timeline

Data Engineer

National Storage Affiliates
05.2019 - Current

Data Analyst

Mental Health Partners
07.2016 - 04.2019

Report Developer

SMNE
12.2015 - 06.2016

IT Help Desk

Ethiopian Telecommunication
07.2012 - 11.2015

BA - Business Administration and Information Systems

Addis Ababa University College of Commerce
Kedamawit Biru