Summary
Work History
Education
Skills
Timeline
Accomplishments
Work Availability
Certification
Work Preference
Overview
Quote
BusinessDevelopmentManager

Tesfay Gerezgiher

Senior Business Intelligent Developer & Fabric Administration
Alexandria,VA

Summary

Senior Power BI Developer with over 10+ years of expertise in Business Intelligence, specializing in Microsoft tools such as MS Fabric, Power BI, Azure, SQL Server, SSRS, and MS Excel. Highly skilled in data visualization, developing dynamic reports and dashboards, and creating semantic models for business analysis. Experienced in designing and implementing BI applications, troubleshooting, and providing system performance optimization and support. Proficient in Power BI issue resolution, ETL process management, and deployment optimization. Adept in Azure services, cloud computing, and agile methodologies, delivering high-quality results on time.

Work History

Sr. Business Intelligent Developer

Superior Health Services
Florida (Remote)
6 2022 - Current
  • Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
  • Collaborated with cross-functional teams to ensure seamless integration of new features.
  • Interacted with business users for understanding business requirements and existing system
  • Received service request from users and Created over 1200 security groups based on the request from users & given names for the security group (BSA, DEV & CSR)
  • Created and configured more than 1200 power BI workspaces , assigning workspace to pipeline.
  • Configured over 500 Data source’s to gateways and added service accounts.
  • Provided over 1000 troubleshooting support and root cause analysis for end-users.
  • Troubleshooted over all power BI performance issues using Dax studio, Tabular editor and performance analyzer to meet user's interest.
  • Adapted quickly to new technologies and programming languages, enhancing overall team productivity.
  • Contributed innovative ideas during brainstorming sessions, driving project success through creative problem solving & methods and documented resolutions for inclusion in knowledge base for support team use.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
  • Developed comprehensive documentation to facilitate seamless handoff to other team members.
  • Automated repetitive tasks through scripting, freeing up valuable time for higher-priority projects.
  • Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
  • Reduced development time by creating reusable code libraries for future projects.
  • Designed and implemented scalable applications for data extraction and analysis.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Coordinated deployments of new software, feature updates and fixes.

Power BI Consultant

Global Resources management
McLean, VA
12.2021 - 03.2023
  • Interacted with business users for understanding business requirements and existing systems.
  • Managed the full lifecycle of BI projects from requirement gathering to final implementation and post-launch support.
  • Conducted regular reviews of operations and identified areas for improvement.
  • Optimized data access and storage to improve performance of analytics systems.
  • Analyzed complex datasets using advanced statistical methods, uncovering valuable insights that drove informed decision making.
  • Leveraged visualization techniques, making it easier for stakeholders to understand complex patterns within their data.
  • Connected to multiple data sources like SQL Server, Oracle, Db2, Azure SQL DW and Flat Files and transformed data in Power Query using both graphical interface and M Formula Language
  • Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles & created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
  • Assisted clients in defining KPIs and performance metrics, enabling accurate tracking of progress towards strategic goals.
  • Provided consultation on best practices for utilizing BI tools effectively, boosting overall organizational productivity.
  • Provide troubleshooting support and root cause analysis for production maintenance, reporting errors, and researching data discrepancies using different troubleshooting tools.
  • Optimized customer experience by delivering superior services and effectively troubleshooting issues.
  • Developed automated reporting solutions to save time and reduce manual effort in generating reports.
  • Delivered high-quality presentations to stakeholders, effectively communicating project objectives and results.
  • Implemented security measures to protect sensitive business intelligence data from unauthorized access or misuse.
  • Collaborated with cross-functional teams to successfully deliver comprehensive solutions for clients.
  • Implemented best practices to optimize clients, organizational performance, leading to improved operational efficiency.
  • Ensured timely delivery of accurate reports by monitoring data processing workflows and resolving any issues quickly.
  • Passionate about learning and committed to continual improvement.

Support Engineer

Mindtree Limited Corporate Office
Seattle (Remote), WA
01.2021 - 12.2021
  • Provide troubleshooting support and root cause analysis for production maintenance, reporting errors, and researching data discrepancies using different troubleshooting tools for over 1500 end users.
  • Developed strong relationships with key clients, acting as their primary point of contact for all technical concerns.
  • Troubleshoot and solve customer technical issues like refresh issue, gateway installation issue, Power BI desktop installation issue, configuration issue, security issue, deployment pipelines issue etc.
  • Support Reporting servers and services by applying network configuration changes, security configurations, server patching, backup, and other resource customizations
  • Create and maintain incident management requests for product group or engineering group.
  • Drive technical collaboration and engagement outside of CSS (Product Engineering teams, Services, Support, Regions) Lead or participate in building communities with peer delivery roles
  • Help to managing Power BI workspaces, report access, report deployment, developing best practices in enterprise environment with customer.
  • Enhanced system performance for clients through proactive monitoring and troubleshooting of technical issues.
  • Implemented automation tools to streamline workflows, reducing manual tasks and increasing productivity within support team.
  • Reduced response times by prioritizing urgent requests and escalating issues when necessary.
  • Monitored systems in operation and quickly troubleshot errors.
  • Ensured compliance with industry best practices and company policies throughout all support activities undertaken by team.
  • Improved customer satisfaction by promptly addressing support tickets and providing accurate solutions.
  • Maintained high levels of customer satisfaction, even during peak times or high-volume ticket periods and documented technical issues and solutions to enable tracking history and maintain accurate logs.
  • Ensured compliance with industry best practices and company policies throughout all support activities undertaken by the team.
  • Collaborated with cross-functional teams to resolve complex problems, ensuring seamless system operations.
  • Implemented technical solutions to solve customer issues and increase satisfaction.
  • Documented technical issues and solutions to enable tracking history and maintain accurate logs.
  • Tools used: - fiddler, Jarvis, desktop log, event viewer, browser trace, Dax studio, Performance analyzer, proc-Mon, Proc-Dom, and others

MSBI/Power BI Developer

Tri West
Phoenix Arizona, AZ
09.2019 - 01.2021
  • Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
  • Collaborated with cross-functional teams to ensure seamless integration of new features.
  • Created Datasets, Relationships and Reports in Power BI Desktop and created Drill-down and Drill-through reports to provide interactive representation of data for Data Analysis, Forecasting and business decisions
  • Used Bar chart, Line chart, Matrix, KPI, Key Influencer, Funnel, Map, Gauge, Slicer, and custom visuals on Power BI Desktop
  • Developed calculated Measure, Calculated Column and Role level security using DAX & Published Reports to Power BI Service Workspace, Created Shared Workspace and APPs for Collaboration.
  • Embedded reports to SharePoint Online and Website or Portal, created Paginated Reports, Generated QR code to share reports, Subscribed users for reports and dashboards
  • Configured Power BI and Enterprise Gateway and performed Incremental Refresh on Datasets.
  • Modeled Data warehouse using Star and Snow flex schema, created Store procedure, Trigger, Functions, Views, Joins, CTE, Indexes and Constraints
  • Contributed innovative ideas during brainstorming sessions, driving project success through creative problem solving.
  • Documented technical workflows and knowledge to educate newly hired employees.
  • Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.

MSBI Developer

Apex Systems
Seattle, WA
01.2017 - 08.2019
  • Collaborated with cross-functional teams to gather requirements for new BI projects, translating them into technical specifications.
  • Improved data gathering, analysis, and visualization procedures with strategic optimizations.
  • Contributed to knowledge sharing within the team by leading training sessions and mentoring junior developers.
  • Created different visualizations (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements
  • Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according requirements
  • Used One Drive for storing different versions of Power BI report
  • Published Power BI Reports in required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Managing Citizen Development Center of Excellence on Enterprise level with MS tools Power Apps & Power Automate
  • Created views intake-database for MS Sales hierarchies to be use in store procedures in Staging database
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Optimized database performance through creation of efficient T-SQL queries, stored procedures, and triggers.
  • Streamlined data extraction from various sources, including relational databases, flat files, and APIs, using SSIS packages.
  • Troubleshot and resolved database issues to minimize downtime and maintain high availability for users.
  • Responsible for complete maintenance and delivery of scheduled releases.
  • Participated in code reviews to ensure that developed solutions adhered to established coding standards and best practices.
  • Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
  • Implemented best practices in database design to ensure optimal performance and maintainability of system.
  • Optimized database performance through the creation of efficient T-SQL queries, stored procedures, and triggers.
  • Maintained thorough documentation of all developed solutions for easy reference during future updates or modifications.
  • Assisted in migrating legacy systems to modern MSBI platforms, ensuring seamless transition and minimal disruption to business operations.

ETL/MSBI Developer

SWBC
Housto, TX
02.2015 - 01.2017
  • Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting).
  • Maintained thorough documentation of all developed solutions for easy reference during future updates or modifications.
  • Designing BI solutions with Microsoft SQL Server 2008 / 2008 R2 / 2012.
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
  • Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
  • Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Created Crystal Reports with ole object extracting image file from the database and URL links.
  • Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults, and complex SQL statements.
  • Write high performing SQL (DML, DDL), triggers, stored procedures, and packages.
  • Improved query execution times with proper indexing strategies and query optimization techniques.
  • Written complex SQL queries to retrieve data from Dynamic CRM and display in SSRS reports. Created SSIS job to verify accounts and leads from excel file.
  • Developed the SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSRS and SSIS.
  • Created Control Flow task such as Execute SQL task, CDC, Execute Package task, Bulk insert task, send mail task, Script task and performed different types of data transformation in Data Flow task such as Lookup, Data conversion, Merge join, Conditional split, Derived column and slowly changing dimensions.
  • Designed and implemented complex SSIS package to migrate data from multiple sources, used configuration and expressions to update package properties at runtime.
  • Used Error handler, Logging, Checkpoint and Break point for debugging and package optimization.
  • Scheduled, executed, and monitored package deployment using SQL Server Agent Jobs.
  • Developed and maintained SQL server database and Data Warehouse
  • Supported business decision-making by creating interactive dashboards for data visualization in Power BI.

Education

AAS - Cyber security

Northern Virginia Community College
Virgilina, VA
09.2018 - Current

Skills

Power BI Desktop

undefined

Timeline

Power BI Consultant

Global Resources management
12.2021 - 03.2023

Support Engineer

Mindtree Limited Corporate Office
01.2021 - 12.2021

MSBI/Power BI Developer

Tri West
09.2019 - 01.2021

AAS - Cyber security

Northern Virginia Community College
09.2018 - Current

MSBI Developer

Apex Systems
01.2017 - 08.2019

ETL/MSBI Developer

SWBC
02.2015 - 01.2017

Sr. Business Intelligent Developer

Superior Health Services
6 2022 - Current

Accomplishments

Optimized power BI semantic model refresh performance from 30 minutes to less than one by utilizing power BI best practice and tools (Tabular editor, Dax studio and Performance analyzer)

Work Availability

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

Certification

MTA - Microsoft Technology Associate

Work Preference

Work Type

Full TimePart TimeContract Work

Work Location

RemoteHybrid

Overview

10
10
years of professional experience
6
6
years of post-secondary education
3
3
Certificates
2
2
Languages

Quote

The supernatural is the natural not yet explained.
Elbert Hubbard

Similar Profiles

CREATE PROFILE
Tesfay GerezgiherSenior Business Intelligent Developer & Fabric Administration