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.
• 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.
• 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.
• Created successful SSIS packages to backup and remove multiple databases.