Summary
Overview
Work History
Education
Skills
Accomplishments
Work Availability
Timeline
Generic

Hiwot D Habtamu

Power Bi Developer
silverspring Md,MD

Summary

6+ years of experience in Microsoft stack of BI solutions – SSIS, SSAS, SSRS with MS SQL 2019/2017/2014 Hands-on experience in visualizing data using Microsoft BI stacks mainly SSRS and Power BI. Highly qualified Power Bi Developer .

Overview

5
5
years of professional experience

Work History

Power BI / SQL Developer

EastDil Secured
07.2020 - Current
  • Gather, analyze, and document business requirements and translate into technical specifications, prototypes
  • Develop and design data model and modify existing database model based on requirement
  • Analyzed translated data into informative reports and visuals based on business requirements
  • Connected to various data sources, importing data and transforming data for Business Intelligence
  • Design, test, and develop interactive and visually appealing reports, dashboards, KPIs, and visualizations using Microsoft Power BI
  • Write test case for back end and front end and conduct per review for accuracy prior to deployment
  • Implemented row level security and understand application security layer models in Power BI
  • Publish and share reports and dashboards to maximize user access, user adoption and business value
  • Proficient in making DAX queries in Power BI desktop
  • Integrate Power BI reports into other applications as needed
  • Connecting data sources, importing data, and transforming data for Business intelligence
  • Participated and created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on OLAP reporting needs
  • Designed ad-hoc reports and complex enterprise reports including drill down, drill through reports, cascading reports, sub reports, linked reports using SSR
  • Strong experience in Analysis, Design, development, and implementation of end-to-end Business intelligence
  • Developed, implemented and optimized stored procedures and functions using T-SQL.
  • Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing
  • Created optimal technical solutions to user needs through research and in-depth system analysis
  • Orchestrated optimized transformation processes for moving data sets between sources and target tables.

Power BI / SQL Developer

Rocket Mortgage
01.2019 - 06.2020
  • Gather, analyze, and document business requirements and translate into technical specifications, prototypes
  • Develop and design data model and modify existing database model on the requirement
  • Developed Logical and physical data model using SAP Power Designer and mapped the data into database objects
  • Provide accurate time and effort estimates as well as lead projects of various complexities in an Agile environment
  • Developed visually appalling reports, dashboards, Matrix and KPI scorecards using Power BI by pulling data from heterogeneous data sources and platforms such as SQL server database, data warehouse, websites, Analysis services, CSV, Azure SQL database, Azure data lake, excel
  • Publishing and scheduling Power BI reports as per the business requirements
  • Create and modifying Tables, view, Stored Procedures and Functions using T-SQL
  • Prepare and maintain database design and data Mapping documentation
  • Written complex procedures, functions and created database objects to manipulate data
  • Troubleshoot issues and optimize reports, processes, and SQL queries/Stored Procedures
  • Designed, developed and established KPIs report to monitor, analysis and provide strategic insights to drive performance for Loan risk department
  • Developed metrics that provide data for loan process management and indicators for future service improvement opportunities
  • Developed report on loan performance on a daily, weekly and monthly basis in Power BI and SSRS
  • Worked with senior management team and operation-level managers to gather requirements
  • Extract, Transfer and load the data from different data sources like flat files, SQL servers and excel using SSIS
  • Created overly complex SSIS packages using various Data transformations like conditional split, Fuzzy lookup, Multi Cast, Derived column, Lookup, Union All, merge, Copy etc
  • Designed stored procedures to insert new data and update existing data
  • Involved in designing and deploying Data warehouse using Snowflake designs for the operational data
  • Proficient in writing Power BI Data Analytics expressions (DAX)
  • Worked with business leaders and data analysts to develop business intelligence solutions and reports
  • Strong experience in Analysis, Design, development, and implementation of end-to-end Business intelligence.

SQL Developer

Eastern Alliance Insurance
01.2017 - 12.2018
  • Interpret requirements, perform analyses, and develop technical solutions to obtain desired results and prototyping
  • Create data mapping document and convert data mapping document into SSIS package
  • Design SSIS packages to extract data from various sources like SQL Server, Oracle, CSV, Excel, Teradata, Text, XML file
  • Perform data management tasks, such as conduct data profiling, assess data quality, and write SQL queries to fix data quality issue identified using data profiler task
  • Identify appropriate data sources, extract data, and develop integrated data
  • Create data verification plans to be used following trial runs at client site and ensure issues are identified, tracked, reported, and resolved in timely manner
  • Create complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on OLAP reporting needs
  • Participate in performance monitoring, analyzing and modify existing SQL queries, Reports and ETL packages to achieve maximum performance
  • Developed an interactive and visually appealing reports and dashboards using Microsoft Power BI
  • Designed ad hoc and complex enterprise reports with drill down, drill through reports, Parameterized reports, sub reports, linked reports using SSAR
  • Schedule daily, weekly, monthly reports for Executives, Business Analyst and Customer Reps for various categories and regions based on business needs using SSRS and Microsoft Power BI
  • Versed with all phases of Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering & analysis, detailed design, development, testing and post implementation support.
  • Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing
  • Created optimal technical solutions to user needs through research and in-depth system analysis
  • Supported multiple concurrent projects enabling delivery efficiencies and technical resolution
  • Orchestrated optimized transformation processes for moving data sets between sources and target tables

Education

Bachelor of Science - Information Technology

Hawassa University
Addis Ababa Ethiopia

Skills

  • TECHICAL SKILLLS:
  • ETL Tools: Microsoft SQL server integration services (SSIS)
  • Analysis and reporting services: SSAS, SSRS, Power BI, MS Excel
  • Database: SQL server 2019/2016/2014
  • Architecture: Relational DBMS, OLTP, OLAP
  • Programming language: T-SQL
  • Tools and Utilities: SQL Server Management Studio, SQL Server Profiler, Visual Studio
  • Data Modeling- Visio and SAP Power Designer
  • Methodology: Agile
  • Version control tools: Team Foundation Server (TFS), GitHub
  • Other: MS Office
  • Operating system: Windows Server

Accomplishments

  • 70-461 Querying Microsoft SQL Server 2012/2014
  • Certificate in analyzing and visualizing data using Power BI

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Power BI / SQL Developer

EastDil Secured
07.2020 - Current

Power BI / SQL Developer

Rocket Mortgage
01.2019 - 06.2020

SQL Developer

Eastern Alliance Insurance
01.2017 - 12.2018

Bachelor of Science - Information Technology

Hawassa University

Similar Profiles

CREATE PROFILE
Hiwot D HabtamuPower Bi Developer