•Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Access
•Developed SSIS packages to produce details and summarized reports on a daily basis.
•Created SSIS packages using Conditional Split, Data Conversion, Fuzzy Logic and C#.
•Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS) and Crystal Reports.
•Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).
•Built ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
•Developed Stored Procedures, Functions, Views & Triggers to enforce the business rules.
•Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.
•Created Triggers to implement business control.
•Fine tuned SQL queries to improve query performance and to reduce runtime.
•Reorganized database structures as needed, automate procedures at regular intervals.
•Created and maintained all types of Backups and recovery strategies and set up jobs.
•Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
•Optimized long running Stored Procedures & queries for effective data retrieval.
Environment: SQL Server 2008 (Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard, SQL Suite (SSIS, SSRS), SQL Server Business Intelligence Studio, ETL, C#, Windows Vista, MS Excel, MS Access, Ms Word.)