Power Bi Business Intelligence

Location:

Silver Spring, MD

Posted:

March 21, 2025

Contact this candidate

Resume:

Assefa Tsegaye

**********@*****.***

240-***-****

linkedin.com/in/assefa-tsegaye-76a5931- Dat

-Summary POWER BI, SQL, SSIS and SSRS DEVELOPER

Experience Summary:

A Microsoft POWER BI Developer,SQL,SSIS,SSRS and with 8 years IT experience: As a professional Database and power BI developer, I have implemented supported both OLTP and OLAP applications, created different database and database objects using SQL Server, created application integration and data transformation using SSIS packages and developed reports using SSRS, TABLEAU and POWER BI. Hands-on experience in Power BI platforms: Power bi desktop, Power Bi Service, power Bi report builder and power bi mobile app. Specializing in Data Warehouse, Power BI Reporting Service, SQL Server, Azure Cloud Computing, ADF (Azure Data Factory), Database and BI developer with SQL Server, Developing Complex SQL query SSMS and Data Modeling, Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization. Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers .Experience supporting Data Flow transformations:

I am a dedicated and results-driven professional with extensive experience in Power BI development, SQL development, and business intelligence with a proven track record of delivering data-driven insights and solutions. I excel in transforming data into actionable insights, optimizing database performance, and automating workflows. Adept at collaborating with cross-functional teams, designing data models, and creating interactive reports, Strong expertise in SQL, data transformation, and visualization tools. My journey in the field of data analytics has allowed me to work on impactful projects, enabling organizations to make informed decisions and drive business growth.

Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All. Expertise in enhancing and deploying SSIS packages from development server to production server, Keen understanding of dimensional Star Schema and Snowflakes Schema. Designed and implemented normalized relational database schemas, defining primary/foreign keys, constraints, and indexing strategies to ensure data integrity and optimized query performance. Created scalable, well-structured tables to support transactional and analytical workloads.

I specialize in Microsoft Power BI to create a report using datasets and Power Bi desktop tools to understand the data in depth Experienced in Microsoft Power BI Premium, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Power bi report builder, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.

Design and develop Power Bi report and dataset gathering, manipulating, and loading data. Building and Designing power bi reports and dashboards, developing data models creating custom visuals and calculations, connecting and integrated data, Designing and creating paginated reports, configuring data sources, building and designing reports layouts creating parameters and complex calculations.

Develop and deploy power bi solutions to support business processes and decision making, stay up-to-date with the latest power bi features and best practices and incorporate them

into development processes. Adhere to compliance procedure and internal/operational risk controls in accordance with all applicable regulatory standards and policies Experience

. Created, prioritized, and managed Jira tickets for bug fixes, enhancements, and new feature development. Utilized Jira to implement Agile methodologies, including sprint planning, backlog grooming, and daily stand-ups. Designed and configured Jira dashboards to monitor team progress, identify bottlenecks, and report KPIs to stakeholders. Implemented custom workflows and automation rules in Jira to streamline repetitive tasks and improve team efficiency. Generated detailed reports and charts in Jira to analyze team performance and support data-driven decision-making.

Developed and maintained interactive Power BI reports for the organization, leveraging Sales force data to provide key insights into business performance.· Designed custom dashboards integrating Sales force data to track sales metrics, customer behavior, and financial outcomes, enabling real-time decision-making.

Developed and maintained SAP BusinessObjects (BOBJ) reports for data visualization and decision-making. Designed and optimized Universes (IDT/UDT) to support business reporting needs. Created complex Web Intelligence (WebI) reports with filters, prompts, and drill-down functionalities. Integrated BOBJ with SQL databases to extract, transform, and visualize critical business data.

Participated data migration initiatives, successfully transferring large datasets from legacy systems to modern platforms, ensuring minimal downtime and data integrity throughout the process. Analyzed existing databases, developed migration strategies, and created efficient ETL processes for seamless data transformation and load operations. Utilized SQL, SSIS, and other ETL tools to automate migration workflows, improving data extraction, cleansing, and loading efficiencies. Conducted thorough testing and validation of migrated data to verify accuracy, troubleshoot issues, and optimize performance.

Leveraged a deep understanding of Dataverse to create and maintain data structures, enabling reliable backend support for Power Apps applications.

Utilized the Power Platform Center of Excellence (CoE) Admin Center to oversee application governance, monitor performance, and maintain system best practices.

Developed Canvas and Model-driven Power Apps using Microsoft Dataverse and SharePoint for backend data storage, ensuring efficient and scalable app solutions tailored to end-user needs.

Developed and optimized Power BI dashboards and reports for payor analytics, claims processing, and financial reporting.Designed data models and implemented DAX calculations to analyze claims, reimbursements, denials, and payment trends.Integrated data from healthcare payor systems, including eligibility, authorization, and adjudication data sources.Conducted in-depth claims analysis to identify payment discrepancies, revenue leakage, and cost containment opportunities.

Regulatory Reporting Experience (Banking/Finance) Developed and automated regulatory reports using Power BI, SQL, and SSRS to ensure compliance with Basel III, CCAR, Dodd-Frank, and IFRS 9.Extracted, transformed, and loaded (ETL) large financial datasets from Adenza/AxiomSL, SQL databases, and cloud sources for accurate regulatory reporting .Designed data models to improve the efficiency of regulatory reporting processes, reducing reporting time by 30%.

Created visual dashboards for risk exposure, liquidity, and capital adequacy, ensuring senior management had real-time insights for compliance decisions.Worked with finance, risk, and compliance teams to validate data accuracy and integrity for FR Y-9C, FR 2052a, FFIEC 031/041, and CECL reporting.Improved data quality by implementing SQL-based validation checks for missing or incorrect regulatory data. Collaborated with internal audit and compliance teams to ensure regulatory submissions met Federal Reserve (FED), SEC, and OCC requirements.

Automated reporting workflows using Power BI, SSIS, and SQL stored procedures, reducing manual effort by 40%, Optimized SQL queries for AxiomSL/Adenza reports, improving data processing performance for large-scale banking datasets.

Power Platform Power Apps (Canvas and Model-driven), Power Automate (Flows, Desktop Flows, business process Flows), Power BI, Data verse. SaaS / PaaS Environments: Experience in developing and deploying applications within cloud-based environments. Agile Methodologies: Sprint planning, Agile development, team collaboration and Database Management: Data verse, SharePoint, Microsoft SQL Server

Gecom Software LLC and Voyatek VA October, 31/2022 –present ( 2 years)

Role: Power BI Developer, Power Apps and SharePoint developer /Administrator

. Data Integration & Modeling: Experience: Connecting Power BI to multiple data sources, such as SQL Server, CSV files, or APIs related to police data (e.g., arrest records, incident reports).Example: You might create a data model by pulling data on criminal records from multiple police databases, relating it through common fields (like case number or officer ID) for use in reports.

. DAX (Data Analysis Expressions):Experience: Writing DAX functions to perform calculations and create measures or calculated columns.Example: Using DAX to calculate the average response time of officers for different types of incidents and displaying this in a report.

. Advanced Query Writing (Power Query):Experience: Querying large datasets using Power Query for transformation and cleaning, as well as writing advanced SQL queries to retrieve data from relational databases. Example: Writing an SQL query to filter arrest records based on date, crime severity, or officer department, then transforming the data in Power Query to clean inconsistencies before reporting.

Report & Dashboard Development: Experience: Designing interactive reports and dashboards for visualizing crime data, police performance metrics, or other KPIs (Key Performance Indicators).Example: Building a crime heat map to show the distribution of offenses in different regions, along with drill-down capabilities for specific crime types.

Troubleshooting: Experience: Identifying and resolving issues related to data accuracy, performance (slow reports), and misconfigured data models. Example: Troubleshooting slow report performance by analyzing inefficient .DAX expressions or optimizing SQL queries to reduce load times when generating reports.

Performance Optimization: Experience: Optimizing Power BI performance by query folding, reducing visuals on the page, and avoiding expensive DAX functions. Example: If a report displaying monthly arrest trends runs slow, you might optimize the underlying query or reduce the complexity of the visuals by using simpler DAX functions.. Collaboration with Team members :

Developed Canvas and Model-driven Power Apps using Microsoft Dataverse and SharePoint for backend data storage, ensuring efficient and scalable app solutions tailored to end-user needs.

Designed and deployed comprehensive Power BI reports, enabling data-driven insights that support key decision-making processes.

Built and optimized Power Automate workflows, including Flows, Desktop Flows, and business process Flows, automating complex business processes and enhancing productivity.

Conducted Agile development and sprint planning sessions to align project timelines with deliverables, ensuring timely and efficient development cycles.

Power Platform Power Apps (Canvas and Model-driven), Power Automate (Flows, Desktop Flows, business process Flows), Power BI, Dataverse

SaaS/PaaS Environments: Experience in developing and deploying applications within cloud-based environments

Light house mortgage HAUPPAUGE, NY, 2021 February-October/28/2022

Role: Power bi developer and sql developer, Regulatory Reporting Developer Power Apps and SharePoint

Worked closely with Business Analyst and all team within the organization to understand business processes.

Developed complex SQL queries, stored procedures and views to be used in Power BI reports as well as for ETL workflows and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor. Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraint

Regularly monitored SQL Server performance, analyzing logs to ensure optimal database functionality.

Troubleshot and resolved SQL Server issues, including concurrency problems such as blocking, locking, and deadlocks, using tools like Activity Monitor.

Diagnosed and addressed SQL Agent job execution failures to ensure seamless job scheduling and processing. Used the tabular model cubes as the source in Power BI to visualize the data.

Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard. Created interactive reports customized for the business using Power BI Desktop.

Developed and automated regulatory reports using Power BI, SQL, and SSRS to ensure compliance with Basel III, CCAR, Dodd-Frank, and IFRS 9.

Extracted, transformed, and loaded (ETL) large financial datasets from Adenza/AxiomSL, SQL databases, and cloud sources for accurate regulatory reporting.

Designed data models to improve the efficiency of regulatory reporting processes, reducing reporting time by 30%.

Created visual dashboards for risk exposure, liquidity, and capital adequacy, ensuring senior management had real-time insights for compliance decisions.

Worked with finance, risk, and compliance teams to validate data accuracy and integrity for FR Y-9C, FR 2052a, FFIEC 031/041, and CECL reporting.

Installed and configured and maintained Power BI Report Service, Worked on a project in the migration of Tableau reports to Power Bi report server.

Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog, imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

Cleaning up datasets using Marge queries, append queries, and sort data column to properly fit our reports. Created Dax Queries to generated computed columns in Power BI, also applied DAX calculated measures and columns.

Design and develop Power Bi report and dataset gathering, manipulating, and loading data.

Building and Designing power bi reports and dashboards, developing data models creating custom visuals and calculations, connecting and integrated data.

Designing and creating paginated reports, configuring data sources, building and designing reports layouts creating parameters and complex calculations.

Generated computed tables in Power BI by using Dax

Experience with AWS services, including data storage, computing, and integration for cloud-based analytics and business intelligence solutions like power bi.

Involved in creating new stored procedures and optimizing existing queries and stored procedures. Created Azure Blob Storage for Import/Export data to/from .CSV File also access and analyze dataset and KPI’s to create reports.

Used Power BI to created visualization tools intended for diverse users.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Used Power BI Gateways to keep the dashboards and reports up to date.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Published reports and dashboards using Power BI.

Leveraged a deep understanding of Dataverse to create and maintain data structures, enabling reliable backend support for Power Apps applications.

Utilized the Power Platform Center of Excellence (CoE) Admin Center to oversee application governance, monitor performance, and maintain system best practices

Collaborated with cross-functional teams to ensure cohesive project execution, coordinating with both technical and non-technical stakeholders to achieve project goals.

Independently led technical projects while also providing mentorship to junior team members, fostering a collaborative and innovative team environment.

Highmark Health Pittsburgh, PA Jul 2018 - Jan 2021

Role: SQL/ETL/Power BI Developer

Worked closely with SME’s end users/internal customers to understand project/requirement scope

Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes

Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements, and prepared documentation for same.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (Used CTE, temporary tables, user defined table types in codes developed)

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014/2017.

Experience in Power BI and with different BI component like (Oracle, SQL, SSIS, SSRS, SSAS).

Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog.

Experience working with Snowflake for data warehousing, including querying, data modeling, and integration with business intelligence tools like Power BI.

Experience in automating tasks and work flows between applications and services using Microsoft Power Automate tool.

Imported data from Oracle DB, SQL Server DB and Azure SQL DB to Power BI to generate reports. Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.

Participated data migration initiatives, successfully transferring large datasets from legacy systems to modern platforms, ensuring minimal downtime and data integrity throughout the process.

Analyzed existing databases, developed migration strategies, and created efficient ETL processes for seamless data transformation and load operations. Utilized SQL, SSIS, and other ETL tools to automate migration workflows, improving data extraction, cleansing, and loading efficiencies.

Collaborated with cross-functional teams, including database administrators, developers, and business analysts, to align migration strategies with business needs and mitigate potential risks.

Conducted thorough testing and validation of migrated data to verify accuracy, troubleshoot issues, and optimize performance.

Created Azure Blob Storage for Import/Export data to/from .CSV File, also access and analyze dataset and KPI’s to create reports.

Used Power BI to create visualization tools intended for diverse users.

Experience with AWS services, including data storage, computing, and integration for cloud-based analytics and business intelligence solutions like power bi.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Agile Methodologies: Sprint planning, Agile development, team collaboration

Database Management: Data verse, SharePoint, Microsoft SQL Server.

Used Jira to plan, track, and manage project workflows, ensuring timely completion of deliverables. Created, prioritized, and managed Jira tickets for bug fixes, enhancements, and new feature development.

Utilized Jira to implement Agile methodologies, including sprint planning, backlog grooming, and daily stand-ups. Designed and configured Jira dashboards to monitor team progress, identify bottlenecks, and report KPIs to stakeholders. Implemented custom workflows and automation rules in Jira to streamline repetitive tasks and improve team efficiency. Integrated Jira with tools like Confluence,

GitHub, and Slack to enhance collaboration and visibility across teams. Generated detailed reports and charts in Jira to analyze team performance and support data-driven decision-making.

Created KPI dashboards for claims approval rates, denial reasons, and reimbursement cycles to enhance financial decision-makingand Collaborated with business users, data engineers, and stakeholders to ensure accurate reporting on provider-payor relationships.Developed ETL processes using SQL and SSIS to extract, transform, and load payor-related data from multiple healthcare systems.Ensured compliance with HIPAA regulations while handling Protected Health Information (PHI).Provided insights to improve contract negotiations with payors and optimize reimbursement rates.

EAGLE BANK Bethesda, MD Jul 2015 - NOVEMBER 2017

Role: Regulatory Reporting Developer,Business Intelligence Developer (SQL/SSIS/SSRS/SSAS)

Worked closely with internal and external users to understanding and gathering business requirements. Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.

Designed and implemented normalized relational database schemas, defining primary/foreign keys, constraints, and indexing strategies to ensure data integrity and optimized query performance. Created scalable, well-structured tables to support transactional and analytical workloads.

Developed and maintained OLAP cubes using SSAS, optimizing aggregations and partitions for high-performance analytics. Designed efficient schemas for reporting, integrating SSRS with cube-based MDX queries for dynamic dashboard insights.

Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraint

Regularly monitored SQL server, analyzing the logs, troubleshooting SQL Server problems such as Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.

Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.

Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.

Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher periodically.

Log shipping database for reporting server within the firms’ latency objective.

Mirrored one of our critical databases with zero latency/synchronized- with witness/for critical Database on SQL 2008.

Part of the team which configured Always On with availability group for one of our critical servers on SQL 2012 that was installed via nodes on WSFC (Window Server Failover cluster).

Improved data quality by implementing SQL-based validation checks for missing or incorrect regulatory data.Assisted in the migration and integration of regulatory reporting data from legacy systems to modern cloud-based platforms.

Collaborated with internal audit and compliance teams to ensure regulatory submissions met Federal Reserve (FED), SEC, and OCC requirements.Automated reporting workflows using Power BI, SSIS, and SQL stored procedures, reducing manual effort by 40%.Optimized SQL queries for AxiomSL/Adenza reports, improving data processing performance for large-scale banking datasets.

Performed full, differential and transaction log backups.

Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.

Participated data migration initiatives, successfully transferring large datasets from legacy systems to modern platforms, ensuring minimal downtime and data integrity throughout the process.

Implemented report scheduling and distribution using BusinessObjects Enterprise.Worked on performance tuning and troubleshooting for BOBJ reports and Universes.Collaborated with business stakeholders to gather reporting requirements and ensure data accuracy Provided user training and support for BOBJ reporting tools to enhance business adoption.

Analyzed existing databases, developed migration strategies, and created efficient ETL processes for seamless data transformation and load operations.

Utilized SQL, SSIS, and other ETL tools to automate migration workflows, improving data extraction, cleansing, and loading efficiencies.

Conducted thorough testing and validation of migrated data to verify accuracy, troubleshoot issues, and optimize performance.

Used the SQL Server profiler to capture and store the execution plan.

Provided weekly, monthly, yearly quality control reports for work orders, service requests.

Represent reports in different forms using graphs, charts, tabular, area and pie charts as required. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS). Worked with XML configuration files and variables for deploying SSIS packages into various environments.

- S Education:

Bachelor's Degree in Information Technology (IT)

Skills:

- Power BI Development

- SQL Development

- Data Analysis

- Data Modeling

- ETL Processes

- Business Intelligence

- Database Optimization

- Data Visualization

- DAX Queries

- Report Generation

- Database Administration

- Security Policies

- Data Integration

-business analysis

-charts

-customer relations

-data transfer

-Data migration

-Etc.

QL Development