SUMMARY

• Over 6 years of strong experience in the IT industry as a SQL Server Developer (SSIS, SSRS) with sound business analysis skills.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Installation and configuration of SQL Server 2008 R2.
• Extensive experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
• Performed Key Role in Logical and Physical Database design and development and Data modeling using SQL Server Enterprise manager.
• Good Knowledge of normalization/de - normalization of database tables, developing (DDL) and (DML) and building referential integrity for the (RDMS).
• Highly proficient in the use of T-SQL for developing stored procedures, triggers, tables, user defined functions, relational database models, data integrity and SQL joins.
• Highly experienced in sub queries, joins involving multiple tables.
• Experienced in Performance tuning, and optimization of procedures and queries.
• Used DBCC commands for Database maintenance (Rebuilding Indexes).
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Expert in designing and scheduling complex SSIS Packages for transferring data from multiple data sources like SQL Server 2000, Excel, Flat file using SSIS to SQL server 2005/2008.
• Developed packages in SSIS with error handling.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression and Derived Column.
• Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way. Versatile in working as an individual and also as part of a team. Proficient with various computer operating systems.
• Proactive team player with demonstrated problem solving and analytical reasoning abilities.

TECHNICAL SKILLS

Languages: C#, .Net, SQL, T-SQL,PL/SQL

SQL Server Tools&Packages: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, ETL

Databases: SQL Server 2000/2005/2008 , MS Access 97/2003/2005/2008 , Oracle

Operating Systems: Windows Server 2000/2003/2008 , Windows 7/Vista/XP/2003/2000 UNIX, Linux, DOS

BI Tools: SSRS, SSIS

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front page

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL Server /SSRS Developer

Responsibilities:

• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Strored Procedures for the DataSet to build the reports for the client requirements.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Performance tuning, and optimization of procedures and queries.
• Used DBCC commands for Database maintenance (Rebuilding Indexes).
• Installation and configuration of SQL Server 2008 R2
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2008 and Flat files.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Involved in creating report models and applying row level security filters for report model.
• Experienced in participating meetings with business users to gather the requirements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2008/2008R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),T-SQL,,Microsoft Office 2010, OLAP, Oracle 10g,ASP.Net,VB.net,MS Visio.

Confidential

MSSQL Server/Report Developer

Responsibilities:

• Based on business requirement, developed the Complex T-SQL, Stored procedure, Views, Triggers for implementing the business rules and transformations.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in Performance Tuning of SQL Server to improve the performance.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Actively participated and worked jointly with other members of the department for the quick and easy retrieval of required data.

Environment: MS SQL Server 2008R2/2005, Windows Server 2000/2003,Microsoft Visual Studio 2005/2008,SSRS,SSIS,MS Office 2007,Oracle 10Gg.s

Confidential, Boston

SQL Server SSRS/SSIS Developer

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.
• Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.
• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Experience in deploying and scheduling the reports based on quarter, month, and year reports.
• Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).
• Developed, monitored and deployed SSIS packages.
• Worked on Excels to upload the data from excels to database.
• Responsible for implementation of data viewers, error configurations for error handling of the packages.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).
• Implemented Event Handlers in SSIS packages
• Implemented Checkpoints to rerun the failed package from the point of failure.
• Responsible for creating user groups and assigning permissions.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, NY

MS SQL Developer

Responsibilities:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Identify the causes of slow running of T-SQL queries.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Wrote user requirement documents based on functional specification.
• Used multiple join statements to retrieve data from multiple several tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Responsible for creating complex reports like Drill down and Sub Reports..
• Participated Databases Architecture and Data Modeling design.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Wrote stored procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Participated in business analysis and development of report requirements specifications and business rules.
• Provide24 X 7 supportsto all production, development and staging.

Environment: MS SQL Server 2000, SQL Server Management Studio, DTS, TSQL, SQL Profiler, MS SQL Server Configuration Manager, MS Access.

Confidential

SQL Server Developer

Responsibilities:

• Created Stored Procedures, Database Triggers, Views, User defined Functions and other SQL Joins and Statements by Applications using T-SQL.
• Implemented installing and configuring of the SQL Server 2000.
• Involved in Functional design, System analysis, gathering of user requirements and maintaining good documentation.
• Fined-Tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Bulk data migration using SSIS from flat files.
• Implemented user login and security.
• Involved in the development, design and testing of the system.
• Involved in administrative tasks of managing users, logs and profiles.
• Documented all the processes involved in maintaining MS SQL database.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Involved in gathering of the requirements and converting into database related components.

Environment: MS SQL Server 2000, MS Excel, MS Office Windows Server 2003, T-SQL.