SUMMARY

Around 6 years of extensive experience as a MS SQL Server SQL Server 2008 Developer with major focus on T-SQL, SSIS, SSAS and SSRS .6 years of sound experience as a database developer in banking, IT and financial sectors. Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.

• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Exceptional hands on working knowledge and recent experience working with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Thorough experience with SQL Server 2005 instance installation, up gradation and migrating from SQL Server 2000 to 2005.
• Experience in writing Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Experience in creating reports using SSRS and worked on OLAP environment
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in planning and implementing MS SQL server Security and database permissions. Creation and maintenance of databases, creating roles and managing user permissions.
• Solid knowledge and recent experience with all aspects of SQL Server Management Studio (SSMS) including Query Editor, Server objects, SQL Server Agent, Replication, Management and Notification Services .
• Proficiency in using different Transformation tools like DTS packages, BCP and Bulk Insert as well as SQL Server Integration Services (SSIS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Experience on performance point server and dashboards, scorecards, building reports and created management reports.
• Monitor the production server using tools like SQL Profiler, Windows Perform, Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.
• Worked on pro-clarity to create cost-effective reporting and analytical solutions.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Knowledge and exposure to performing whole database backup and recovery using Log Shipping and Database Mirroring techniques.
• Strong experience withcreating Linked Servers for connecting servers at remote site locations and then querying the group of servers using T-SQL statements. Strong working knowledge on Query Optimization. And outstanding knowledge of database and server performance tuning strategies.
• Successfully implemented Transactional and Snapshot Replication methods for Backup and Restore of Database. Good understanding of high availability SQL Server solutions using active-active andactive-passive Clustering modes.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates. Expert in performing database consistency checks using DBCC Utilities.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Designing, developing and capacity planning for database. Expert in creating SSIS packages and sending alerts using SQL Mail.
• Experience in Data Modelingusing Erwin, Rational Rose (UML) and MS-Visio to create logical and physical data models; use case diagrams and data flow diagrams respectively.

TECHNICAL SKILLS:

Operating Systems: Windows 2000 Server, Windows 2000 Advanced server, Windows 2003 Server, SP3, Windows NT 4.0, Windows XP, Windows Vista.
components/environment: MS SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration SQL SERVER Services, Analysis Services.
Languages: C,C++, PL/SQL,T-SQL
RDBMS: SQL Server 2008,2005/ 2000 /7.0,8.0,9.0,10.0,MySQL,MS Access
Application: MS-Visio, Rational Rose (UML), Erwin, Visual Studio
Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL
Database Software: TOAD
Server Scripting: ASP,PHP
Software Methodologies: SDLC,RUP
Systems familiarity: OLTP,DSS,OLAP

CLIENT: Confidential, May Field Village, NY MAY 10 – TILL DATE
JOB TITLE: SQL Server Developer 
Client Description: 
Confidential has always lived up to its name by being one step ahead of the insurance industry, and finding new and affordable insurance solutions. We began in 1965 with the first drive-in claims office, became the first to introduce reduced rates for low-risk drivers, and then changed the insurance shopping experience by offering comparison rates on the Web.

Responsibilities:

• Installed and Configured SQL Server 2005 along with SQL Server Business Intelligence Development Studio in new server.
• Gathered business requirements for creating the new mission-critical databases from business analyst, project manager, other internal employees as well as customer feedbacks.
• Collaborate on the global data architecture design and planning for the physical structure and implementation of data warehouses and data marts.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Migration of all the databases from old servers to new server. Loaded stored procedures and user defined functions into the databases.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Involved in Data Staging includes importing data, parsing, scrubbing by using SSIS tools.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools (pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate)
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Support and enhance a financial and enterprise Data Warehouse with OLAP reporting functionality.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.

Environment: Windows 2003, MS SQLServer 2005, ETL, SSIS, T-SQL, Microsoft Visual Studio.Net 2005 and VB.Net

CLIENT: Confidential, Chicago IL APR 09 – APR 10
JOB TITLE: SQL Developer 
Client Description: 
The project involved migrating old legacy data to SQL Server 2000 using DTS, calculate different investment management business logics and generate reports for the Investors and managers.
Responsibilities:

• Designed Logical data model using Erwin.
• Developed tabular reports using SSRS.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Installation and configuration of SQL Server 2005/2000 on Windows 2000/NT/XP OS.
• Managing of database objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table content to text files.
• Developed SSIS Packages to transfer the data between SQL Server database and files.
• Created and managed database maintenance plans for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/db roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Assisted admin team with Log Shipping to ensure full database backup and disaster recovery.

CLIENT: Confidential, NJ OCT 08 - MAR 09
Job Title: SQL Developer 
Client Description: 
A world leader in distributing pharmaceutical resources, which consists of more than 200 companies, specialized in each surgical device. Involved in data transfer between servers and work on the BI side as an support to provide necessary information to the end user
Responsibilities:

• Upgraded SQL Server 7.0 to SQL Server 2000. Also Performed SQL Server 2000 Installation
• Worked on Client/Server tools like SQL Server Query Analyzer to administer SQL Server
• Created Database Maintenance Planner for improving the performance of SQL Server which covers Database Integrity Checks, Updated Database Statistics and Re-indexing
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
• Designed DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database
• Data migration (import & export - BCP) from Text to SQL Server
• Clustered Server and Load Balancing to maintain the Redundancy of Servers
• Configured IIS Server for the XML programming which was a new level of SQL 2000
• Configured Exchange Server for sending automatic mails to the respective people when a jobfailed or succeed
• Configured Commerce Server for capturing the Web Log details of the User
• Moved the entire phase from the Staging to the Production
• Created Triggers to enforce data and referential integrity
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers
• Designed Different kinds of Transactions for the application
• Maintained SQL Script for creation of Database Objects
• Documented business rules, functional and technical designers, test cases and user guides.
• Conducting training for users.

Environment: Microsoft SQL Server 2000/7.0, Microsoft Windows 2000 Server, Microsoft Visual Basic and Microsoft Access 97/2000.

CLIENT: Confidential AUG 06 –SEPT 08
JOB TITLE: SQL Server Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Developed stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects.
• Environment:
• MS SQL Server 2000, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB, Crystal Report.