SUMMARY:

• Over 6+ yearsof experience inData Modeling, DatabaseDesign, Programming, Development and Implementationof Client - Server Applications & Database systems using MSSQL 2008/2005.
• Worked in various industries including Financial, Health Insurance and General insurance
• Active participation inSoftware Development Life Cycle (SDLC)specifically waterfall and Agile Scrum methodology.
• Expertise with T-SQL in writing complex queries, triggers, user functions, views, indexes, Cursorsand maintaining data integrity
• Created several complex stored procedures
• Strong experience inSQL Development,ETL developmentusing Microsoft SQL Server Integration Services(SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services(SSAS)and reporting solutions using Microsoft SQL Server Reporting Services(SSRS).
• Experience in developing complexSSIS packages to import/export data from different data sources.
• Experience in developing and designing reports through SSRS, Crystal Reports, and SharePoint
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Worked with .NET framework including C#, ASP.NET and Web Service.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience inup gradationandMigrationofSQL Server 2005 to SQL Server 2008
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduledSSIS Packages.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2008/2005/2000 , Oracle 8i/9i, MS Access.

Database Tools: SSIS, SSAS, SSRS,Enterprise Manager, Query Analyzer, SQL Profiler, Management Studio, SharePoint 2007, Crystal Reports 9.0/10

Programming Languages: SQL, TSQL, VB.NET, XML, C++, Java, VB 6.0

Scripts: JavaScript, VBScript, HTML, DHTML and XML

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express

Applications: Microsoft Office, Visio, and Visual SourceSafe

Operating Systems: Windows 2000/2003/XP, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Roseland, NJ

SQL Server Developer

Responsibilities:

• Involved in completeSoftware Development Life Cycle (SDLC)process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Developed several database structures, complex T-SQL queries, views, triggers and user-defined functions.
• Created complex stored proceduresto update tables on daily schedule andto pull data for various reports.
• Create several Joins to pull employee related data from various tables of Data Layer.
• Designed and developed SSIS Packagestoimport and export datafrom MS Excel, SQL Server 2005andFlat files.
• Used variousTransformationsinSSIS Dataflow, Control Flowusingfor loop Containersand Fuzzy Lookupsetc.
• Modifying existing database by adding tables and relationships
• Createdcheck constraintsto maintain data integrity.
• Createdviewsto facilitate easy user interface implementation, andtriggerson them to facilitate consistent data entry into the database.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc.
• Involved inNormalizationandDe-Normalizationof existing tables for faster query retrieval.
• Created indexes for better performance.
• Extensively worked on SQL Profiler and Database tuning wizard as part of the performance tuning.
• Troubleshoot system issues, monitoring scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
• Involve in testing, bug fixing and documentation for the project

Environment: SQL Server 2008/R2 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting SERVICES, SQL Server Analysis Services, Crystal REPORTS, SHAREPOINT 2007, T-SQL, ODBC, Excel, Access, Windows 2000//2003/XP, Unix, IIS 5.0

Confidential, Baltimore, MD

SSRS/SQL Server Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the data integrity.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Assisted in the design of star schema and snowflake schema.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Used SQL Server Agent for scheduling jobs and alerts.
• Active part in creating cubes from which data can be retrieved rapidly.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP

Confidential, New York City, NY

SQL Server Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and FMO System Specification.
• Modified existing database by adding tables and relationships
• Specified Hierarchy Structure for FMO (Financial Management Organization) Database to describe the relationships and dependencies within the Cost centers ofCiti Group
• Created several stored procedures to Archive the old data in the database
• Wrote custom T-SQL Stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Crystal Reports.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Involved in testing, bug fixing and documentation for the project
• Scheduled jobs for backup, and created alerts for error reporting.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, ODBC, Excel, Access, Sybase Power Designer, Windows 2003, Unix, IIS 5.0,Oracle 9i, Crystal Reports

Confidential, Minneapolis, Minnesota

SQL Developer

Responsibilities:

• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Defined constraints, rules and defaults.
• Created views as required by front-end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Optimized the performance of queries with modification in index system for online system.
• Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.
• Data migration (import & export - BCP) from Text to SQL Server.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Monitored the growth of the database objects for capacity planning.
• Scheduled jobs for backup, and created alerts for error reporting.
• Participated in different testing and debugging for the system.
• Documented all processes involved in maintaining the database for future .

Environment: SQL Server 2005 Enterprise Edition, ASP.Net, ODBC, VBScript, JavaScript, CSS, DHTML, Macromedia Dreamweaver, Windows 2003, IIS 5.0.