Nationwide Building Society is a British mutual financial institution and the largest building society in the world
· Strewed a team of 8 members
· Created the build plan to commit timelines.
· Extracted data from various sources like SQL Server, CSV, and Excel & Text file from Client servers and through FTP.
· Handled Performance Tuning and Optimization on SSIS, with strong analytical & troubleshooting skills for quick issue resolution.
· Involved in creation/review of functional requirement specifications & supporting documents for business systems
· Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers
· Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
· Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
· Planned SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
· The packages created included a variety of transformations for example Slowly Changing Dimensions, Look Up, Aggregate, Derived Column, Conditional Split, Multicast, Data Conversion etc
· Reviewed & tested packages, Fixing bugs using SQL 2008 Business Intelligence Development Studio