Kirubel Tsehai Email & Phone Number

• Support modernization efforts within the Energy Information Administration (EIA). Work involves resolving issues that are a result of transforming legacy reports into a modernized enterprise solution as part of a scrum team that operates in 2 week sprints. • Responsible for setting up data governance policies to ensure organization wide integrity, transparency, accountability, and compliance.• Developed standardized report templates that reduced report generation time by 60%.• Create new reports using requirements gathered during story gathering sessions to develop server based dashboards inside the enterprise BI tools Jaspersoft Studio and PowerBI. • Provide demo to business users on functionality of developed dashboards and reports using Jaspersoft Server tool – includes providing training on development process for energy analysts wanting to create ad-hoc reports using server application.• Maintained reports on server using code versioning on Gitlab.

Arlington, Va

• Created simple to complex Business Intelligence deliverables, including reports, dashboards, scorecards (KPIs) using Tableau Desktop and Tableau Server.• Extracted data from database warehouse environment, Snowflake, using customized SQL queries to format and cleanse data before connecting to BI tool for data exploration and presentation.• Interacted directly with client stakeholders who are in business and/or technical roles to implement data-driven strategies that have significantly improved the accuracy and timeliness of our reports.• Supported functional, integration or system testing, UAT, and implementation of solution into production.• Created and maintained design and production system documentation.

• Act as lead analyst for 1ntelligent One, a reporting system utilizing Tableau to increase review speeds (30% - 40%) and eliminate 95% of data prior to review.• Streamlined Tableau dashboards for repetitive reporting using various connection types, extracts, filters, custom fields, and parameters, which involved troubleshooting various issues throughout the creation process.• Ran custom Transact-SQL scripts in SSMS\SSIS\Tableau to extract specific records from large datasets.• Reduced time it took to defragment highly fragmented database indexes by 98% by creating optimized stored procedures.• Designed a customized Tableau report to track live SQL Server performance metrics to find areas of resource bottlenecks. Utilized Tableau Server to monitor live performance data and created recommended changes based on live results. • Created successful SSIS packages to backup and remove multiple databases.• Involved in hiring process and development of BI team.