Tesfay Gerezgiher

• Administered enterprise-wide Power BI and Microsoft Fabric environment, managing 1,200+ workspaces, 500+ gateways and data sources, deployment pipelines, and security groups to ensure compliant, high-availability access.
• Diagnosed and resolved 1,000+ production incidents through root-cause analysis and advanced tooling (DAX Studio, Tabular Editor, Performance Analyzer), maintaining near-100% report availability.
• Optimized complex semantic models and large datasets, reducing refresh times from 2 hours to under 10 minutes, delivering hundreds of annual processing hours saved and enabling near-real-time analytics.
• Conducted weekly training sessions on data modeling best practices, significantly improving team modeling standards and overall solution performance.

2025 Key Accomplishments

• Strengthened Power BI reliability by systematically resolving critical refresh failures and gateway disruptions.
• Improved data accuracy through robust validation frameworks, quality monitoring, and best-practice implementation (>40% reduction in discrepancies).
• Standardized troubleshooting processes and reusable workflows, decreasing mean time to resolution by 50%.
• Monitored Microsoft Fabric capacity utilization (Metrics App and telemetry); advised optimal modeling strategies to eliminate throttling and control costs.
• Automated repetitive tasks using Power Automate flows and scripting; incorporated emerging Power BI features, increasing developer productivity by 25–35%.
• Continuously updated skills through training courses, workshops, and self-study staying current on industry trends and emerging technologies.

• Gather business requirements and translate them into BI solutions.
• Collected data from wide-ranging sources.
• Connect and transform data from multiple sources (SQL, Azure, Oracle, Excel, etc.) using Power Query.
• Build semantic models, complex DAX calculations, Row-Level Security (RLS), and time intelligence.
• Create interactive reports, dashboards, KPIs, drill-through visuals, and paginated reports.
• Designed custom dashboards and reports to address specific business needs and requirements.
• Optimize performance (DAX tuning, incremental refresh, gateways) and troubleshooting issues.
• Leveraged visualization techniques, making it easier for stakeholders to understand complex patterns within their data.
• Deploy and manage Power BI Service (workspaces, pipelines, apps, embedding).
• Provide training, best-practice guidance, documentation, and client advisory.
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Provided consultation on best practices for utilizing BI tools effectively, boosting overall organizational productivity.
• Managed the full lifecycle of BI projects from requirement gathering to final implementation and post-launch support.

• 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

• 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.

• 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.

• 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.