SUMMARY

• Around 7 years of experience in Microsoft SQL Server and extensive experience in Microsoft Business Intelligence Tools - SSIS, SSRS, etc.
• Experience in MS SQL Server 2008R 2/2008/2005/2000 , SSIS/SSRS/SSAS, Database Migration, Physical/Logical Data Modeling, Performance-Tuning, Troubleshooting, Data-Warehousing and Normalization/ Demoralization techniques.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Experience with T SQL (DDL and DML) in constructing tables, user defined functions, views, complex stored procedures, relational database models, data dictionaries, data integrity and appropriate triggers to facilitate efficient data manipulation and consistent data storage.
• Efficient in writing complex T-SQL queries using Joins.
• Experience in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Expert in scheduling jobs for SSIS Packages and sending Alerts using SQL Mail.
• Adept in designing Stylish Report layout and have extensive experience in generating Drill down and Drill through as well as Slice and Dice reports with Drop down menu option, sorting the data, Sub reports defining subtotals in SSRS 2005/2008/2008 R2.

TECHNICAL SKILLS

Databases: MS SQL server 2000/ 2005/2008/2008 R2, MS Access

Languages: Transact- SQL, SQL, ASP.NET, C, C++

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Reporting Tools: SQL Server Reporting Service (SSRS)

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, SQL server profiler.

Data Modeling Tools: Microsoft Visio 2000/2003

Operating Systems: Windows NT/98/2000/XP/Vista/2003, MS-DOS

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Austin, Texas

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Developed and created new database objects including tables, views, triggers, stored procedures, user defined functions, complex SQL Queries, clustered and non-clustered indexes to implement the business logic.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and also created SQL scripts for tuning and scheduling.
• Wrote queries using Dynamic SQL to reduce complexity of the queries and improve performance
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reports, dynamic sortingusing various features like Charts, graphs, pie, filters etc.
• Identify business requirements and provide solution options.
• Coordinate between project management and development teams.
• Identify the data issues and provided solution options for resolution.
• Provide disaster recovery plans to the data services.
• Monitor entire application development, execution, and maintenance.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TFS, Microsoft visual studio 2012, MS Visual Source Safe.

Confidential, NYC, New York

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions, also updated statistics using Query analyzer and Enterprise Manager on the existing servers.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Created the automated process for the activities such as database backup processes and SSIS packages run sequentially using SQL Server Agent job
• Created report models for ad-hoc reports using SSRS.
• Designed and developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reports, dynamic sortingusing various features like Charts, graphs, pie, filters etc.
• Created Drill-through, Drill-down, Parameterized, Cross Tab and Sub-Reports using Report Designer and Report Builder based on the requirements.
• Formatted the reports using Global variables, Expressions and Functions using SSRS.
• Designed and developed Dashboards and Scorecards according to business requirement using SSRS.
• Created complex reports like weather reports, map reports etc.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Generated periodic reports based on the statistical analysis of the data using SSRS.

Environment: SQL Server 2008/2005 Enterprise Edition, SSRS, SSIS, Windows 2000/2003 Enterprise Server, XML, MS Excel, MS Access, MS Visio 2003, and Visual source safe (VSS), Crystal Reports 8.0.

Confidential, Minneapolis, Minnesota

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, advanced queries, views, indexes, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to back- up the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.

Environment: SQL Server 2000, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, Microsoft Visio 2000.

Confidential

SQL Developer

Responsibilities:

• Modified existing database by adding tables and relationships
• Created views as per the requirement of front-end developer.
• Optimized the performance of queries with modification in T - SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Wrote complex queries and stored procedures.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Monitored and scheduled existing/new jobs on production environment.
• Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Deploying database objects from development/testing environment to production environment.
• Coordinated and performed quality assurance testing for movement of database and objects from development environment to testing and production environments.

Environment: SQL Server 2000/2005, SSIS, SSRS, ASP, VBScript, Windows 2000/XP.