Eman Surur

Sql Etl Developer @Bank of America

Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and developed Cubes and reports for analysis.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.Troubleshooting and correcting production ETL issues.Optimizing stored procedures, T-SQL, views, and functions for the best performance.Refining and automating regular SQL processes, track issues, and document changes.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.Developed complex database objects like complex stored procedures and complex UDF.Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.Developed script for data manipulation and ensuring data integrity.Designed, developed and maintained a data warehouse.Creating Tabular reports with SQL Server Reporting Services (SSRS).Generating parameterized reports, drill down drill through reportsDeployed reports, created report schedules and subscriptions.Managing and securing reports using SSRS.