Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic
Frezer Yirdaw

Frezer Yirdaw

SQL BI/Power BI Developer
Denver,CO

Summary

Over 6 years of IT Experience in Database and Business Intelligence Technologies with expertise in ETL process and Reporting using SQL Server 2019/2017/2016/2014/2012, SSIS, and SSRS. Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications. Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing the latest versions and features. Utilized Python Scripting to automate repetitive tasks, enhancing productivity and reducing manual effort. Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer. Hands on experience in SQL/Snow SQL of Oracle/SQL Server/Snowflake. Proficient in the Microsoft Business Intelligence (MSBI) stack, including SQL Server 2012/2014/2016,2017/2019 SSIS, SSAS, and SSRS. Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all. Used R & Python, SAS, Tableau, Power BI and SQL for data cleaning, data visualization, risk analysis and predictive analytics. Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing. Strong command of T-SQL for querying and manipulating data within SQL Server databases. Hands-on Experience in Data Migration from MS SQL Server to Oracle ERP Systems. Very good T-SQL Programming skills. Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor, and DBCC Commands. Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis. Had good experience in publishing Power BI Desktop reports to the Power BI service. Deployed Power BI Pro for Business users to view reports on the service and local report server. Had good Experience in publishing and sharing BI objects in Power BI Workspace, designed and maintained Power BI dashboard in Power BI App. Reports to Tableau dashboards connecting to SQL server. Worked on Insurance projects in Health Care industry, Medical Claims Experience. Utilized DAX (Data Analysis Expressions) for creating complex calculations and measures within Power BI and SSAS models. Experience in developing SSIS packages to bring data from Insurance Claims Databases to Data Warehouse tables. Good understanding of Normalization/Denormalization, Normal Form, and database design methodology. Knowledge of full Software Development Life Cycle, including code reviews, source control management and working knowledge of Agile. Strong knowledge of Data Marts, Data warehouse, ODS, OLAP, OLTP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables. Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server. Experience in Tableau Desktop, Power BI for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart. Experience with full development cycle of a Data Warehouse, including requirements gathering, design, UAT, and Deployment. Experience in developing Power BI Reports with KPI Metrics for senior leadership to view the Metrics values and developed BI data mapping and BI objects (dashboards, reports, analysis, visualizations, metrics, security) design documents using Power BI. Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert, and BCP utilities. Expertise in resolving SQL Reporting Services (SSRS) and T-SQL-related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP, and Sub reports in Business Intelligence Development Studio.

Overview

6
6
years of professional experience

Work History

SQL Server BI Developer

AT&T
Atlanta, GA
07.2022 - Current
  • Actively participated in gathering business requirements to implement functional and technical specifications
  • Migrating databases\instances from SQL Server 2017 to SQL Server 2019 version
  • Installed, managed and administrated SQL Server 2019/2017/2016/2014/2012 Databases
  • Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bulk Insert task, Script task in SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Data Flow
  • Designing, developing, and testing the ETL (Extract, Transformation, and Load) strategy to populate the data from various source systems feeds using SSIS
  • Worked with both the version in Azure Data Factory such as V1 & V2
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages
  • Wrote a python-based SQL generator that helped speed up a weekly reporting from several days
  • Developing interactive reports and dashboards using tools like Power BI, Tableau, or QlikView to enable data visualization and insights
  • Created packages using the various control flow tasks such as data flow task, execute SQL task
  • Proficient in designing and maintaining relational databases using platforms like Microsoft SQL Server, Oracle, or MySQL
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc queries
  • Generated monthly reports and budget analysis to drive forecast production plans with SQL Server Reporting Services (SSRS)
  • Integrated data from varied sources using SSIS - SQL Server, Azure Data Lake, Spreadsheets and Flat Files
  • Created parameterized reports and Linked reports with thorough knowledge of report serving architecture
  • (Table, chart, and matrix report)
  • Experience in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
  • Working with various business groups while developing their applications, assisting in Database Design, Creating E-R Diagrams using Visio, and designing Local and Physical Data Models with Erwin r4
  • Used various transformation tasks to create ETL packages for data conversion
  • Created and deployed cubes in star and snowflake schema
  • Performed and worked with dimensions, measures, MDX queries
  • Based on business requirements, developed complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Triggers to implement the business rules and transformations
  • Created ETL packages with different data sources (SQL Server, Oracle, Teradata, Access, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • ETL Performed Query Folding using Power Query to filter data in the data source server
  • Involved in extracting the data using SSIS from OLTP and OLAP
  • Extracted data from various sources like DB2, Oracle, Flat Files, and XML Files and loaded them into Fact and Dimension tables of the Datawarehouse.

SQL/Power BI Developer

Fannie Mae
Austin, TX
11.2020 - 05.2022
  • Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
  • Took part in creating Star Schema, Snowflake dimensional schema in MS analysis services (SSAS)
  • Imported Data from SQL Server DB Azure SQL DB to Power BI for generating Reports
  • Wrote data queries in DAX and SQL and Expertise in writing Complex Dax functions in Power BI and Power Pivot
  • Configurated and Deployed of all reports across various SDLC environments and deployed the packages to production using XML package configuration
  • Used Power BI, Power Pivot to developed data analysis phototype, and used Power View and Power Map to visual
  • Experience in getting data from different data sources like SharePoint, Excel, CSV, APIs etc., and transforming raw data as per requirement
  • Added new users and applied roles in the QNXT UI in the Development and UAT Environments
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
  • Gathered user requirements, analyzed and designed software solution based on the requirements
  • Developed SSRS reports which include dynamic grouping fields, drilldown and dashboard report and Export reports into various formats such as PDF, HTML, EXCEL, and WORD
  • Utilized Power Query in Power BI to Pivot and UN Pivot the data model for cleaning and massing
  • Responsible for the design and development of key indicators (KPI) and the appropriate tracking reports to assist in the management campaigns
  • Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the Junk characters from the file before loading them into the base tables
  • Experienced in integration of various data sources like DB2, Green Plum, SQL Server, MySQL, and Flat Files
  • Designed and developed reports such as Drill down, Drill through using Microsoft Reporting Services (SSRS)
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
  • Designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
  • Developed application in PowerApps using Common Data Service CDS, Flow, Excel, Forms and SharePoint online
  • Generate ad-hoc reports in excel Power Pivot and shared them using Power BI to the decision makers for strategy planning
  • Extensively involved in doing user acceptance testing (UAT)
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
  • Mentored business power users to create reports/dashboards using tableau desktop
  • Created and modified several Unix Shell Scripts according to the changing needs of project and client requirements
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the Junk characters from the file before loading them into the base tables
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

BI Analyst

CareSource
Dayton, OH
09.2018 - 10.2020
  • Interacted with the client for requirement gathering/ implementation
  • Maintained BSO cubes and participated in data loading to BSO cubes from flat files
  • Working with Business, SMEs (which includes mockups, assumptions, current reality and use cases), scheduling meetings, preparing minutes (MOM), action items, maintaining log files and follow-up
  • Design project plan, road map and project status evaluation
  • Designing and customizing reports and embedding with dashboard
  • Troubleshooting and being accountable to application end users
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data into data warehouse databases
  • Experience in refreshing datasets using Power BI gateway
  • Work with IT team to create users, groups and assigning roles according to the requirements
  • Report design, drill through reports using OLAP cube features, Power Pivot
  • Created dashboards using SQL Server Reporting Services (SSRS)
  • Extensively worked on agile scrum environment for several claims processing modules
  • Acted as Data analyst and interacted with business community and gathered requirements based on changing needs
  • Aiding the support and supervision of BI software programs
  • Security implementation, administration, troubleshooting, and RPD migration
  • Excellent analytical, problem solving and Tableau and SQL debugging skills
  • Supported in creating KPI, Calculation Members and Measure groups and MDX queries
  • Designing and deploying RPD using OBIEE environment
  • BI data modelling as per business rules and business matrices to support reporting
  • Wherever required, the ETL process was created, the reports will be stored, refreshed, and utilized in the report on a daily basis.

Education

Bachelors of Computer Science -

University of Colorado
01.2018

Skills

  • Windows 7/ Vista /XP professional Windows Server 2012/2008/2003, UNIX
  • T-SQL, ASPnet, VBnet, C, C, Python, HTML
  • Power BI desktop/service, BI Stack (Power pivot, Power query, Power map), Snowflake, MS SQL Server 2019/2017/2016/2014/2012, MS Access, Oracle 11g/10g/ 9i
  • [Skill] abilities Operating Systems: Windows 7/ Vista /XP professional Windows Server 2012/2008/2003, UNIX
     Databases: Power BI desktop/service, BI Stack (Power pivot, Power Query, Power map), Snowflake, MS SQL Server
    2019/2017/2016/2014/2012, MS Access, Oracle 11g/10g/ 9i
     Language: T-SQL, ASPnet, VBnet, C, C, Python, HTML
     Power BI Tools: Power BI Desktop, Power BI Embedded, Power BI Gateway, Power Query, DAX, Power BI App,
    SSIS, SSRS, SSAS
     Application Packages: MS Office 2013/2007/2003/2000(Word, Excel, Power Point, Access)
     Data Modelling Tools: MS Office Suite, Microsoft Visio, IBM Rationale Rose, ER Modelling, Erwin, Power Pivot

Personal Information

Title: SQL BI/Power BI Developer

Timeline

SQL Server BI Developer

AT&T
07.2022 - Current

SQL/Power BI Developer

Fannie Mae
11.2020 - 05.2022

BI Analyst

CareSource
09.2018 - 10.2020

Bachelors of Computer Science -

University of Colorado

Similar Profiles

CREATE PROFILE
Frezer YirdawSQL BI/Power BI Developer