Meron Birhanu Email & Phone Number

United States

As a seasoned database professional, I specialize in optimizing SQL queries, procedures, and functions to enhance data retrieval efficiency and minimize processing time. Using advanced SQL skills, I validate dataset integrity through scripts, meticulously checking for duplicates, null values, and truncated data. My expertise extends to performing quality analysis in complex data migration projects.Utilizing Power BI, I craft analytical dashboards featuring key KPIs like territory leads and billing hours, incorporating user-friendly slicers for seamless filtering. I excel in developing precise data models and DAX calculations, ensuring accuracy and performance in reports. My proficiency extends to creating diverse reports—Dashboards, Tabular & Matrix reports, Charts & Graphs—meeting customer requirements using Power BI & SSRS.I have successfully implemented Row-Level Security (RLS) to create secure, user-specific reports and dashboards. Efficient scheduling of refreshes via Power BI gateway ensures timely updates with appropriate dependencies. Importing datasets from various sources into Power BI, I establish relationships among datasets during model construction. My skills also encompass the engineering of efficient ETL processes with SSIS and designing dimensional models with SSAS packages. Collaborating closely with managers, I adopt the Agile Methodology to ensure swift and efficient project delivery.

Texas, United States

In this role, I demonstrated proficiency in Business Intelligence (BI) by developing comprehensive solutions using Microsoft Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), and Tableau. I created Structured Query Language Server Reporting Services (SSRS) reports, SQL Server Integration Services (SSIS) integration packages, and SQL Server Analysis Services (SSAS) analysis cubes. Additionally, I utilized Dashboard Designer to construct SharePoint dashboards, enhancing data visualization capabilities. My responsibilities extended to dimensional modeling and OLAP cube creation with SSAS, translating project requirements into functional and non-functional specifications for BI reports and applications.Data extraction from customer rational databases was achieved through SSIS, facilitating data loading into a data warehouse. I played a crucial role in converting existing reporting tools to a standardized infrastructure using SQL and Microsoft products. This involved designing and implementing interfaces for the data warehouse, ensuring compatibility with various BI tools and other business applications. As part of the team, I contributed to and supported the organization's Business Intelligence strategy, actively participating in refining and maintaining current standards while establishing new ones. My role also encompassed the development and implementation of tactical and strategic data warehousing solutions, including a corporate Data Warehouse, aligning with the organization's overall goals. Throughout, I adhered to established programming, testing, and release standards, ensuring the reliability and effectiveness of BI solutions.

Master'S Degree, Agricultural Economics, A

Bachelor'S Degree, Economics, A