Bruk Wolde

Senior Sql Server Bi Etl Developer @Emory University Hospital

Developed complex SQL queries and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor. • Support relational and dimensional database models. • Developed and optimized stored procedures, T-SQL, views, and functions for the best performance. • Refining and automates regular SQL processes, track issues, and document changes. • Designed, developed, and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access, to SQL Server. • Creating Tabular reports with SQL Server Reporting Services (SSRS) in addition to generating parameterized reports, drill down drill through reports • Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS. • Planned and designed data collection and survey tools and performed data analysis. • Created and tuned database objects such as tables, stored procedures, triggers, views, indexes and joins in MS SQL server to support relational and dimensional database models. • Developed SSIS packages to Extract, Transform and Load (ETL) data from different sources into database; and to transfer data from various sources including MS Excel, MS Access, Flat Files, XML files, and SQL sources to SQL database. • Scheduled SQL Server jobs to load data periodically using SQL Server Agent. • Created ad-hoc reports and complex enterprise reports such as drilldown, drill through, parameterized and cascading reports using SQL Server Reporting Services. • Designed and created report templates, plots, bar graphs and pie charts; and scheduled periodical reports to run automatically. • Documented All MS-SQL database structures and functionalities. Worked with Auditors and Provided Database related documents.