Emma Woldesilasie Email & Phone Number

Silver Spring, Md, Us

Illinois, United States

• Designing and implementing advanced reports and KPI dashboards to enhance decision-making.• Utilizing bookmarks feature for easy navigation to report tabs with one click.• Optimizing complex SQL queries, including CTEs, Views, joins, and unions, for efficient data analysis and reporting.• Demonstrate expertise in data modeling, aligning data structures with business needs.• Staying updated with the latest Power BI developments to enhance our reporting and analytical skills

Ohio, United States

• Created database objects in MS SQL Server for both relational and dimensional models.• Developed complex queries for reporting, including subqueries, CTEs, views, triggers, and joins.• Proficient in DAX for complex calculations, enhancing Power BI's analytics.• Proficient in T-SQL for advanced data analysis using unions, joins, partitions, and ranking functions.• Continuously updated skills in Power BI for advanced business intelligence solutions.

Maryland, United States

• Installed and configured SQL Server (2008-2017) for optimal performance.• Proficient in developing database schemas with effective normalization and indexing to enhance performance.• Imported data from multiple sources like SQL Server, SSAS, and Excel for report generation.• Proficient in creating dynamic, user-friendly SSRS reports and dashboards for effective data visualization.• Proficient in automating database tasks using SQL Server Agent and optimizing table design for efficient access.