Description
PROFESSIONAL SUMMARY * Experienced in SSIS Practices to improve performances when configuring packages * Created SSIS packages to perform ETL tasks to extract data from different sources, excel, text, csv, etc. * Implemented Tableau to connect to data sources to create worksheets, dashboards, story points for analyzing * Developed stored procedures, views, and optimized queries by using the execution plan * Used T-SQL commands to improve performance over the existing standard SQL REVELANT EXPERIENCE HDSupply - SR SQL Server Database Developer IT Dept (9 month contract) 06/2016 - 2/2017 * Migrated Access 2013 queries to SQL Server in an AGILE environment * Developed complex stored procedures, views, and ad-hoc queries for extracting data into sql server * T-SQL using ISNULL, COALESCE, case, constraints, unions, indexing, cluster vs. noncluster, etc. * Created SSIS packages to perform ETL tasks to extract data from txt, excel and csv into SQL Server * Tested both the Access and SQL environments concerently to confirm accuracy of data * Deployed reports using SAP software Business Objects with different formats such as pdf, excel, etc.