SUMMARY

• Over Seven years of extensive experience in the IT industry as a MS SQL Developer/BI Developer (SSRS, SSIS,) in MS SQL Server 2005/2008R2.
• Extensively worked in various domains verticals such as Healthcare, Insurance, Finance, Banking etc.
• Experienced in RBMS Concepts, Database Management Systems, and Database Physical and Logical design & Data Modeling.
• Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Expertise creating various complex reports in SSRS 2005/2008 including tabular reports, drill down reports, drill through, matrix reports, chart reports, sub reports and parameterized queries for generating cascading reports.
• Highly proficient in the use of SQL Server and T - SQL in constructing triggers, tables, user functions, Stored Procedures, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in tuning the performance of database and queries by creating indexes, views.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Experienced in deploying and enhancing the SSIS Packages from development server to production server.
• I have Expertise in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Proficient in writing complex T-SQL (DDL, DML), using new features like CTE, ranking functions, top(n), pivot and building referential integrity constraints.
• Extensively worked on how to design and develop cubes using SQL Server 2005 Analysis Services and leverage the advanced BI functionality of SQL Server 2005.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Excellent interpersonal skills, analytical, problem solving and presentation skills.
• Strong experience of SSAS and dimensional modeling. Expert in creating and modifying SSAS cubes (dimensions, facts, members, calculations) and in-depth knowledge of MDX query language.

TECHNICAL SKILLS

• MS SQL Server 2005/2008
• MS SQL Integration Services 2005/2008
• MS SQL Reporting Services 2005/2008
• MS SQL Server Analysis Services 2005/2008
• C
• C++
• Visual Basic 6.0
• Visual C++
• ASP
• C#
• Erwin Designer 2000
• Crystal Reports
• Windows 2003 Server
• Windows XP/2000/Vista/W7

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Scheduled JAD Sessions and involved in gathering the report specifications by interacting with the business users.
• Migrated data from various sources into SQL Server 2008 using SQL Server Integration Services 2008.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Developed packages in SSIS for aggregating data files and database sales information and consolidating for reporting & cubes.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used multiple transformations in SSIS such as Conditional Split, Bulk Insert, Merge and Data Conversion.
• Created reports using Reporting Services 2008 to retrieve data using database code objects such as stored procedures, views and multiple T-SQL queries.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Auto dispatched of simple and complex reports with parameters to different business users using Data driven subscriptions all across the organization based on defined schedules.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Enhanced stored procedure performance for fast generation of reports.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.

Tools: and Technology: SQL Server 2008, Visual Studio 2008, ETL, SSRS 2008, DB2, MS Access 2008, WindowsEnvironment: Agile Methodology, Microsoft .Net Framework 3.0, C#.NET, Windows Forms, Visual Studio 2010

Confidential, Boston, MA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Involved in development and implementation of SSIS application solutions for various business units across the organization.
• Modified and transferred the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Designed and developed SSIS (ETL).
• Involved in performing migration of DTS packages to SSIS packages
• Generated Tabular reports, Matrix reports, List & 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.
• Analyzed reports and fixed bugs in stored procedures for the ongoing database operations, to resolve business problems.
• Generated reports using SQL Server Reporting Services (SSRS).
• Created report models for Report Builder and managed reports using Report Manager.

Tools: and Technology: MS SQL Server 2005 (SSIS, SQL Profiler), MS SQL Reporting Services 2005, ASP.NET, MS Excel, Windows XP.

Confidential, Lynchburg, VA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Designed Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Managed extract, transform, and load data into the repository and Created Complex Stored procedure, Functions, Views, and Indexes for the Logic package.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Tools: and Technology: SQL Server 2000/2005, MS Office Suite 2003 (Word, Excel, Access, PowerPoint and Outlook), Visio, Erwin, DTS, SSIS 2005, SSRS 2000.

Confidential, Raritan, NJ

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Worked with data analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of reporting, decision support and analysis using SSRS and SSAS.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed, Managed, Monitored and Administered database and system perform-acne which included optimization and tuning of query or package changes.
• Created SQL server Reports using SSRS 2005 for the manager and the brokers involved and formatted the report layout for the requirement of the end users.
• Monitored and explained plan assessment, SQL scripts, stored procedures in both 2000 and 2005 for databases.
• Created parameterized reports for the clients.
• Generated reports for end user requirements using SSRS.
• Deployed developed reports on to the server for the end users.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Tools: and Technology: MS SQL Server 2005, MS SQL Server Reporting Service 2005, MS SQL Server Analysis Service 2005 T-SQL, Windows XP, Windows Vista.

Confidential, Chicago, IL

MS SQL Server/SSIS Developer

Responsibilities:

• Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from CDW to Sales Force.
• Preformed QA Testing for all the Store Procedures to validate the sales results.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Used sub reports functionality for complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like Pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.

Tools: and Technology: Windows XP/2003 Enterprise edition, MS SQL Server 2005, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential

MS SQL Developer

Responsibilities:

• Involved in creating tables and databases, defining entity, attributes relationships using constraints
• Achieved proper database design using Normalization.
• Implemented constraints in database design.
• Performed in maintaining of Stored Procedures, Functions and DTS Packages, enforced database triggers for auditing.
• Developed Data files, Log files and File groups.
• Created relationships between entities of database using Entity Relationship diagram.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Tools: and Technology: SQL Server7.0/ 2000, Enterprise Manager, Windows 2K, SQL Profiler, Active Directory, MS Access, and MS Excel.