SUMMARY

• 8 years of strong experience in MS SQL Server with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and T - SQL.
• Expertise in installing, configuring and maintaining SQL Server … database systems.
• Excellent T-SQL Developer skills working with Stored Procedures, Views, User Functions, Triggers, SQL Agent jobs.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard for monitoring and tuning MS SQL Server performance.
• Experience in migrating application code and objects from development/test environments to production.
• Well-versed in usage of SSIS Control Flow items(Execute package/SQL tasks, Script task, For each loop, Sequence containers etc) and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Merge Join, Pivot etc).
• Experience in creating Master and Child packages, Package configurations, Event handling, SSIS event logging.
• Expert in Extracting and transforming data (ETL) from various heterogeneous sources and creating packages using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports using SQL Server Reporting Services(SSRS).
• Extensively used Report Wizard, Report Builder and Report Manager for developing and deploying reports in SSRS.
• Good verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS:

• Integration (9 years), INTEGRATOR (9 years), Microsoft SQL Server Integration Services (9 years), MS SQL Server (9 years), SQL (9 years)
• RDBMS MS SQL Server …
• SQL Server Tools SQL Server Management Studio, SQL Server Business Intelligence Development Studio 2010 and 2012
• BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Operating Systems Windows 7, Windows XP, Windows 2008
• Languages T-SQL, CSS, XML

PROFESSIONAL EXPERIENCE:

MSBI Developer (SSIS, SSRS)

Confidential - New York, NY

Responsibilities:

• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Reverse engineered backend database to change the T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically.
• Experienced working in the Agile methodology.
• Performed improvement of application by replacing the old cursor logic in various triggers by writing complex T-SQL queries.
• Performed Data Modelling to know about the relationships between entities in a database.
• Worked with SQL server BIDS 2012.Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to data warehouse (PDW).
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Involved in creating VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).
• Created various types of performance reports from the TFS server database using SSRS.
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

Environment: SQL Server 2012, SQL Server Integration/Reporting Services, Visual Studio 2010, SQL Server Business Intelligence Development Studio 2012, Windows 2008 Server.

MS SQL Server SSRS/SSIS Developer/ SQL DBA

Confidential - Westlake, TX

Responsibilities:

• SQL Server installation and administration on SQL 2008 for development and test server, 2008 R2 for UAT and production server and 2012 for report server.
• Create various database objects (tables, indexes, views, stored procedures and triggers) and implement referential integrity constraints for enforcing data integrity and business rules.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Developed SSIS packages for migrating data from staging area of SQL Server 2008R2 to SQL Server 2012.
• Installed and administered Microsoft SQL Server Integration Services and SQL Server Reporting Services.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS various features like multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
• Built reports in SSRS for errors generated by SSIS Packages.
• Generated Reports using Data Source Views in Report Builder.
• Created Drill Down, Drill through, linked and sub reports using SSRS.

Environment: Windows 2008, MS SQL Server, MS Office, Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio 2010, SSIS, SSRS.

MS SQL Server/SSIS/SSAS Developer

Confidential - Austin, TX 

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements
• Participated actively in designing the system database structure
• Performed performance tuning of stored procedures using SQL Server Profiler
• Involved in the development of custom stored procedures, functions.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Generated Reports using Data Source Views in Report Builder.
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.

Environment: SQL Server, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS, SSMS 2010.

SQL Server/SSIS Developer

Confidential

Responsibilities:

• Written Stored procedures, views and also optimized them to boost the performance.
• Performance monitoring using SQL profiler and Spotlight.
• Extract, Transform and Load (ETL) data from Excel, Flat file, OLE DB sources to MS SQL Server using SSIS services.
• Manage and automate control flow, data flow, events and logging programmatically for SSIS packages.
• Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Deploy SSIS Package into Production and use Package configuration to export various package properties and make package environment independent.

Environment: Oracle, SQL Server 2008, SQL Server Integration Services, Visual Studio 2008, Windows 2003 Server.