Summary
Overview
Work History
Education
Skills
Certification
technical skills
additional education
Timeline
Generic

Yibeltal Yismaw

Dallas,TX

Summary


Dynamic Power BI Developer with over 4 years of experience in Data Warehousing and Business Intelligence Technologies. Proficient in SQL Server Development, MSBI stack (TSQL, SSIS, SSRS, SSAS), and Power BI, adept at creating Dashboards and reports using SSRS and Power BI.
Skilled in T-SQL for robust database design and management, encompassing Tables, Views, Stored Procedures, Functions, and Triggers. Possesses extensive experience with MS Power BI tools for comprehensive data visualization and analysis.
Demonstrated ability in analyzing User and Business Requirements, adeptly translating them into technical specifications, and delivering high-quality solutions. Familiarity with Reporting Services and supporting services like MDX Technology of the analysis services.
Solid understanding of data warehousing methodologies, including Star Schema and Snowflake concepts. Proficient in dimensional modeling, ETL processes, and data transformation.
Experienced troubleshooter, capable of providing support for reports in Power BI workspace and collaborating effectively with cross-functional teams. Detail-oriented Data Analyst with a passion for Big Data and a dedication to exceeding expectations through excellent communication and meticulous task prioritization skills.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst/Power BI Developer

Webster Bank
05.2023 - Current
  • Developed reports to visually explore data and create an interactive report Excel and Power BI quarterly.
  • Using a query editor in Power BI performed certain operations like fetching data from different file
  • Created groups, content packs quarterly.
  • Conducted unit tests and developed Database queries to analyze the effects and troubleshoot issues
  • Performed and documented data analysis, Data validation, and Data Mapping/Design
  • Created the KPI to show the difference between actual and forecast data
  • Working with import and direct query, creating custom table in the Power BI
  • Merge queries and append queries, remove columns and split columns, choosing required columns in the data
  • By using Power BI desktop connected to various data sources, working with different visualizations
  • Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging Created several user roles and groups to the end - user and provided row level security to them
  • Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service
  • Worked on importing custom visualizations
  • Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters
  • Used various data visualizations with Power BI
  • Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements
  • Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS
  • Involved in designing partitions in cubes to improve performance using SSAS
  • Created Tabular model reports to slice and dice huge volumes of data
  • Using Tabular model provided more security to data at Row level
  • MDX programming, DAX expressions, analysis and business forecasts
  • Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets
  • Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop
  • Creating reports from importing, direct query and live data from several data sources.
  • Streamlined data processing for faster results by implementing advanced analytics tools.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.

Data Analyst/Power BI Developer

Humana
03.2020 - 04.2023
  • Designing, building, and maintaining complex ETL package Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP systems Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task and Script Task in SSIS Designer Automated Power Query refresh using power by using parameter
  • Used various sources to pull data into Power BI such as SQL Server Installed and configured Enterprise gateway and Personal gateway in Power bi service Created Workspace and content packs for business users to view the developed reports
  • Scheduled Automatic refresh and scheduling refresh in power bi service
  • Wrote calculated columns, Measures queries in power bi desktop to show good data analysis
  • Techniques Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily Worked on all types of transformations that are available in Power bi query editor
  • Created stored procedures and SQL queries to pull data into power pivot model
  • Involved in the process of upgrading SQL Server systems to SQL Server 2008 R2 to 2012 Extensively worked on tuning stored procedures and queries for optimum performance Designed and Created databases, tables, views, stored procedures, Cursors and DDL & DML triggers
  • Used DBCC commands to check physical and logical consistency of the databases and rebuilt indexes
  • Provided all levels of support, including on-call support through rotational basis
  • Provided full support of SQL Server SSIS and SSRS services
  • Designed, implemented, maintained, and provided full support of SQL Server clustering and mirroring
  • Controlled, monitored, and generated an access report process for user access to the database
  • Deployed database objects from development/testing environment to production environment Worked with production team on data warehousing in handling large databases
  • Created logins and users as and when required with specific roles on production server
  • Created SQL alerts, Mail, and linked servers for accessing data from remote servers using jobs.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.
  • Streamlined data processing for faster results by implementing advanced analytics tools.

Data Analyst/Power BI Developer

Discover Financial Services
09.2017 - 02.2020
  • Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
  • Developed, Maintained, and Managed advanced reporting, Data cleaning, Report Design, analytics, dashboards, and other BI solutions such as Tableau
  • Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data
  • Build GSHS Reports in Power BI from scratch
  • Performed and worked with dimensions, measures and MDX queries
  • Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI
  • Utilized ( Power BI, Pivot/View ) to design multiple scorecards and dashboards to display information required by different departments and upper level management
  • Created data marts and multi-dimensional models like Star schema and Snowflake schema
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
  • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis
  • Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI
  • Used various sources to pull data into Power BI such as SQL Server, oracle
  • Involved in installation of Power BI Report Server
  • Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries
  • Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements
  • Generated reports using global variables, expressions and functions
  • Configured reporting services in SQL Server 2008
  • Created different power pivot reports as per the client requirement
  • Gathered data and visual requirements from business users to deliver effective reports, dashboards and analytics.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.
  • Streamlined data processing for faster results by implementing advanced analytics tools.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.

Education

Bachelor of Science - Computer Science

Bahir Dar University
Bahir Dar Ethiopia
11.2015

Master of Science in Business Analytics - Business Analytics

Texas A&M University
Commerce, TX
12.2022

Skills

  • Data Warehousing
  • Technical Writing
  • Simulation Modeling
  • Collaboration
    Communication
    Project Management Data Validation
    Data Analysis
    Statistical Analysis
    Data Visualization
    SQL Proficiency
    Programming Languages (Python, R)
    Data Cleaning and Preprocessing
    ETL Processes
    Business Intelligence Tools (Power BI, Tableau)
    Data Warehousing Concepts
    Problem-Solving

Certification

Microsoft Certified SQL Server Administrator

technical skills

SQL Server Management Studio 2017, T-SQL, SQL Server, SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), Transact-SQL, Azure SQL DB, Cosmos DB, Power BI, Tableau, Data Extraction, Data Analytics, Data Visualization, Data Modeling, Business Intelligence, PowerShell, M Language for Power Query, DAX, Python, R, Java, MS Office 360, MS Excel, MS Access, MS Office Suite, SharePoint, Jira, Azure

additional education

Bachelor’s in computer science

Timeline

Data Analyst/Power BI Developer

Webster Bank
05.2023 - Current

Data Analyst/Power BI Developer

Humana
03.2020 - 04.2023

Data Analyst/Power BI Developer

Discover Financial Services
09.2017 - 02.2020

Bachelor of Science - Computer Science

Bahir Dar University

Master of Science in Business Analytics - Business Analytics

Texas A&M University

Similar Profiles

CREATE PROFILE
Yibeltal Yismaw