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