Danait Beyene

San Antonio, Texas

Dana.beyene@gmail.com (Preferred Contact)

Professional Summary
Results-oriented Power BI and SQL BI developer with over 5 years of experience in Database Design,
ETL Implementation, and Data Warehouse support using Microsoft SQL Server 2016. Proven ability to
drive data quality improvements, develop interactive dashboards, and perform detailed data analysis.
Strong communicator and team player with a track record of collaborating effectively with users to
identify and solve business challenges.

 Demonstrate professionalism, attention to detail, collaborative nature, and a quick learner. Strong
communicator exhibited by working closely with users to identify and resolve problems in
addition to working well individually, as well as an effective team player
 Working knowledge with Power BI (Power Pivot, Power View, Power BI Online, Power BI
Desktop, Power BI Publisher) and DAX scripting language a plus
 Design and Implement reporting solutions using Reporting Services, Power BI, or other data
visualization tools
 Working with new updated Technologies such as SQL Azure (Microsoft’s Cloud Services)
 Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence
Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS)
 Experience with advanced Power BI topics such as complex calculations, table calculations,
parameters, geographic mapping, and performance optimization
 Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures,
Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate
efficient data manipulation and consistency
 Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration,
Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts
 Database development experience with Microsoft SQL Server in OLTP/OLAP environments
using integration services (SSIS) for ETL (Extraction, Transformation and Loading), Database
Administrative skills including, backups, recovery, database maintenance
 Strong experience in client interaction and understanding business applications, Data Modeling,
Data Mapping, Table Normalization, Optimization and Tuning
 Provides guidance, training, and problem-solving assistance to other team members, and be open
to receiving similar guidance, training, and assistance from others
Education and Training
 AAS-Cyber Security & Information Assurance Alamo Colleges, San Antonio, TX

 Bachelor Of Science Computer Science Texas A&M university, San Antonio

 Certificate in Full Stack Development, Evangadi Teach (DC)

 Certificate in Data Analytic (TX, United States)

 Microsoft Certified: Power BI Data Analyst ( ID :995450578)

Technical Competencies
Operating Systems Windows Server 2008/2003/XP/Vista, Windows 7/8/10

Database Tools SQL Server Management Studio (SSMS), SQL Profiler, Query
Analyzer, DTS Designer

GUI Tools Power BI Desktop, Power BI Publisher, SQL Server Business

Languages SQL, Python

OLAP Tools Power BI

Development Methodology Agile Methodology

ETL Tools SSIS, DTS, Import/Export Wizard

Office Tools MS Word, PowerPoint, MS Excel

Professional Experience
Colaberry Inc Aug 2022 – Present

Role: Power BI Developer

Industry: Software SKU and Building Blocks

Key Responsibilities
  Drive and document data quality metrics, incident findings, remediation plans, and requirements
 Assist in maintaining a comprehensive inventory of data and reporting assets
 Assist in developing and enforcing governance for standards in reporting, data transfer, and data
storage
 Responsible for assisting in measurably improving CHIE data quality issues, and develop
automated solutions that eliminate unnecessary manual work
 Create dashboards and visual interactive reports using Power BI
 To analyze data and present them through reports that can help in decision making
 Design, develop and deploy Power BI scripts and perform efficient and detailed analysis
 Perform Dax queries and functions in Power BI
 Use of filters and graphs for better understanding of data
 Data exploration and Analysis (EDA) using different libraries in Python with Pandas, matplotlib
and NumPy
Environment: Power BI, SQL Server, Azure Synapse Analytics, Azure DevOps, MS Excel

Multi Render, Inc. Middletown, Delaware Jan 2018– Jan 2021

Role: Power BI Developer

Industry: Software vendor in Healthcare

Key Responsibilities

 Designed, Build, and deployed using Microsoft Power BI for the creation of dashboards, standard
reports, and ad-hoc reports
 Worked with users to design and develop valuable BI solutions
 Used SSRS, Microsoft Power BI and Microsoft Excel: Pivot Table, Power Query, Power Pivot,
and Data Models to gather information from multiple sources and deliver information to the end
user
 Worked with Excel, Power Pivots, or VBA to provide various automation and analytic solutions
 Worked on all activities related to the development, implementation, administration, and support
of ETL processes
 Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling,
Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions,
Views, Rules, Defaults, and complex SQL statement.
 Created and Deployed reports to Report Manager and Troubleshooting for any error occur in
execution
 Scheduled the reports to run on daily and weekly basis in report manager and email them to
managers and analysts to review in excel spread sheet
.
Environment: Power BI Desktop, Power BI Publisher, Windows Server 2003, SSIS, SSRS, SQL Server
2012, Excel, Notepad++, XML

Mr. Cooper Jun 2015 – Feb 2017

Role: Power BI Developer / SQL Developer

Industry: Mortgage
Key Responsibilities

 Gathered business requirements, definition and design of data source and data flows
 Created complex SSIS packages using various transformations and tasks like Sequence
Containers, Script, For Loop and Foreach Loop Container, Execute SQL/Package, Send Mail,
File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge
 Join, Union All, flat file source and destination, OLE DB source and destination, excel source and
destination
 Designed SQL database with control and audit schema tables to maintain historical data and error
handling
 Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views
using T-SQL in Development and Production
 Improved Performance of the database by creating Clustered and non-clustered Indexes and by
optimizing the T-SQL statements using SQL profiler
 Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and parameterized
Reports in SSRS
 Responsible for defining, designing, and leading implementation of Power BI reports and
dashboards for our client
 Troubleshoot and created complex calculation using DAX
 Developed Proof of Concepts (POC) for various projects using SSRS and Power BI
 Implemented tasks (both personal and On- Premises) to schedule Power BI Gateway and
Dashboard refreshes at regular intervals and appropriate dependencies

Environment: Power BI, SQL Server 2012, Reporting services SSRS, SSIS, MS Excel