Summary
Overview
Work History
Education
Skills
Timeline
Generic

Habi Demi

Burtonsville,Maryland

Summary

Result-oriented BI/SQL Developer with expertise in data management, ETL processes, and reporting using Microsoft SQL Server, SSIS, SSRS, Power BI, and Tableau. Skilled in developing complex T-SQL queries, stored procedures, functions, and optimizing database performance. Experienced in AGILE methodologies, cloud technologies like AWS and Azure, and leveraging cloud services for scalable and efficient data solutions. Possesses a MSc. in Data Science (Bioinformatics), a BSc. in Applied Science, and an adaptable, detail-oriented, and collaborative approach to problem-solving.

Overview

8
8
years of professional experience

Work History

Programmer Analyst (SQL Developer)

Daybreak IT Solutions
10.2021 - Current
  • Analyze and refine data for specific projects
  • Develop Azure SQL Server, Power BI, SQL, T-SQL, SSRS solutions
  • Responsible for database design and development in SQL Server 2012 and report creation using SSRS
  • Build T-SQL queries, stored procedures, views, triggers, functions, and optimize with JOINs
  • Utilize cloud services like AWS RDS and S3 for scalable data solutions
  • Technologies: SQL Server Management Studio 2019, Visual Studio 2017, SQL Server Integration Service, SQL Server Reporting Service, Azure DevOps, Microsoft Teams, MS Office (Word, Excel, Power Point), MS
  • Windows, AWS RDS, AWS S3

BI/SQL Developer, ETL Expert

Anomeg Consulting LLC
05.2018 - 09.2021
  • Work with Microsoft BI reporting tools like SSRS, Power BI, and Tableau
  • Develop, implement, and support ETL processes
  • Create complex T-SQL stored procedures, functions, and optimize queries
  • Use SSIS to transfer data from various sources (SQL Server, MS Access) for SSRS reporting
  • Migrate PostgreSQL codes to Snowflake and then to Tableau for reporting purposes
  • Transition database and report packages to Production
  • Design reports, develop databases, and create technical documentation
  • Develop visualizations with Power BI and deploy them to Power BI Services
  • Work with AGILE methodologies and AWS for SQL Server Database migration
  • Technologies: SQL Server Management Studio 2019, Visual Studio 2017, SQL Server Integration Service, SQL Server Reporting Service, Azure DevOps, Microsoft Teams, MS Office (Word, Excel, Power Point), MS Windows, AWS RDS, AWS S3, Snowflake

BI/SQL Developer

TargetedTech Consultancy Group
10.2015 - 05.2018
  • Develop complex T-SQL queries, stored procedures, functions, and optimize database performance
  • Use SSIS for data transfer and ETL processes from various sources (SQL Server, MS Access) for SSRS reporting
  • Migrate databases and report packages to Production Environments
  • Design and develop databases from scratch, including Polybase tables
  • Create reports and visualizations using SSRS, Power BI, and Tableau
  • Analyze cancer patient's data using Python applications (data from qPCR).

Education

MSc - Data Science (Bioinformatics

University of Hannover
2010

BSc. - Applied Science

Haramaya (formerly Alemaya) University
2005

Skills

Databases: MS SQL Server 2019/2016/2014/2012, MySQL, PostgreSQL, Snowflake

Programming Languages: T-SQL, NET, XML, JSON

BI Tools: SSIS, SSAS, SSRS, Power BI, Tableau

OLAP Tools: SSAS, SSRS, MS Excel, MS Power BI, Tableau

ETL Tools: SSIS, DTS, Import/Export Wizard

Cloud Platforms: AWS (Amazon Web Services), Microsoft Azure Cloud Services, AWS RDS, AWS S3, AWS EC2, Azure SQL Database, Azure Blob Storage, Snowflake, Postgres SQL

MS Offices: MS Office 365 (Word, Excel, Power Pivot, Outlook, and PowerPoint), MS-Visio, SharePoint, TFS

Database Diagram Tools: SQL Server Database Diagram Tool in Management Studio, Visio, Lucid Chart Environment: Azure DevOps, Azure SQL Server, Tableau, GitHub, Notion, Okta

Statistical Software: SAS, R-program

Technologies: SQL Server Management Studio 2019, Visual Studio 2017, SQL Server Integration Service, SQL Server Reporting Service, Azure DevOps, Microsoft Teams, MS Office (Word, Excel, Power Point), MS Windows, Azure SQL Database, Azure Blob Storage, Python

Other Skills: Bioinformatics

Timeline

Programmer Analyst (SQL Developer)

Daybreak IT Solutions
10.2021 - Current

BI/SQL Developer, ETL Expert

Anomeg Consulting LLC
05.2018 - 09.2021

BI/SQL Developer

TargetedTech Consultancy Group
10.2015 - 05.2018

MSc - Data Science (Bioinformatics

University of Hannover

BSc. - Applied Science

Haramaya (formerly Alemaya) University

Similar Profiles

CREATE PROFILE
Habi Demi