SUMMARY

• Over 7+ Years of experience as SQL Developer in MS SQL Server 2005/2008.
• Experience in Installing and Configuring SQL Server 2005/2008.
• Experience in Upgradation of SQL Server 2005 databases to SQL Server 2008.
• Excellent experience in design and development of Business Intelligence tools like SQL Server 2005 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Expertise in creating SSIS packages for Extraction, Transformation and Loading (ETL) operations.
• Experience in Import & Export of various data formats using DTS (Data Transformation Services), BCP, Bulk Insert and SQL 2005 Integration Services.
• Experience in migration from DTS Packages to SSIS Packages.
• Extensive experience in creating and managing different report layouts using MS SQL Server 2005 Reporting Services.
• Experience in generating Ad - hoc, Drill down Reports using Global Variables and Expressions.
• Experience in administrating the reports to assign permission to the valid users for executing the reports.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Experience in Analysis Services (SSAS) for designing OLAP Cubes.
• Experience in Designing and Building the Dimensions, Fact Tables with star schema using SQL Server Analysis Services (SSAS).
• Experience in Normalization, De-normalization.
• Experience in Data Modeling using ERWIN and Microsoft Visio.
• Experience in Forward Engineering and Reverse Engineering using Erwin CASE tool.
• Extensive experience in using T-SQL (DML, DDL) in SQL Server 2000/20005/2008 platforms.
• Created Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Experience in configuring and managing Linked Servers for data transfer between SQL Server and other heterogeneous relational databases such as Oracle, DB2 and Sybase.
• Experience in taking Backups, managing Alerts, Operators and Jobs through SQL Server Agent.
• Extensively worked in all phases of Software Development Life Cycle (SDLC).
• Experience in usage of DB tools like Robocopy, Lite speed, Red Gate and BMC Patrol.
• Possess good knowledge on Microsoft Office Share Point Server, Microsoft Office Suite.
• Worked synergistically with team members in meeting challenging project goals and deadline.
• Good team player and self-starter with excellent communication skills to work independently or as a part of team in Financial, Insurance & Healthcare industries.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008, MS Access 2000, Oracle 9i/10g/11i

Database Utilities: Enterprise Manager, Query Analyzer, SQL Server Configuration Manager, TOAD, Business Intelligence Development Studio (BIDS), SQL Server Surface Area Configuration, Database Engine Tuning Advisor, SQL Profiler, Red gate, Robocopy, BMC Patrol

ETL Tools: Export & Import (DTS), SSIS (Integration Services)

BI Tools: SQL Server Analysis Services 2005, SQL Server Reporting Services 2005/2008

Data Modeling: Erwin, Microsoft Visio

Languages: C/C++, JAVA, J2EE, C#, T-SQL, ASP.Net, Visual Basic, PL/SQLWeb TechnologiesHTML, XML, XSL, CSS, JavaScript, AJAX

Web Servers: Microsoft IIS, Apache, Apache Tomcat

Operating System: Windows Server 2000/2003, Windows NT/98/XP/Vista, UNIX

PROFESSIONAL EXPERIENCE

Confidential, SC

Sr SQL Server Developer

Responsibilities:

• Involved in all phases of system development life cycle.
• Created logical and physical design using Microsoft Visio.
• Up graded the databases from SQL Server 2005 to SQL Server 2008 on development server.
• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Convertion, Term Extraction, Conditional Split, Derived Column etc.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Deployed different SSIS packages on development and test environments.
• Developed reports in SSRS 2005 using Table Control, Matrix Control for Cross Tab reports.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.
• Designed Report Templates, Bar Graphs and Pie Charts based on data.
• Worked on querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email.
• Created Reports and integrated reports into ASP.Net Application.
• Scheduled reports to run daily, weekly and monthly based on the requirement using SQL Server Agent from the Report Manager.
• Defined Report Layouts for formatting the report design as per the need.
• Generated test data and tested new database consistency with existing databases.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Implemented best practices in structuring SQL queries, Debugging Unexpected SQL Results etc.
• Developed and created the new database objects including Tables, Views, Index, Stored procedures, Functions and Advanced Queries.
• Documented and helped in developing code using c#.net.

Environment: Windows XP, SQL Server 2005/2008 Enterprise Manager, Visual Studio 2005/2008/2010, T-SQL, MS Access, MS Excel, SSIS, SSRS,BIDS,C#.Net

Confidential, Washington DC

Sr SQL Server Developer

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Design/develop database using SQL SERVER 2000/2005.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.
• Developed SSIS Packages using xml, ADO.NET, OLEDB, file system, Active X script, Look up tasks.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Deployed SSRS Reports in SharePoint Environment.
• Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Scheduled Complex Stored Procedures using SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning.
• Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS), SharePoint Moss 2007, Windows XP

Confidential, IL

Sr SQL Server BI Developer

Responsibilities:

• Involved in requirement gathering and database design using Erwin.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Convertion etc.
• Worked with different Control Flow elements like For Loop Container, For each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Created Linked Servers to retrieve data from other databases.
• Monitored and modified Performance using execution plans and Index Tuning.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, SharePoint MOSS, Oracle9i, XML, ASP.Net, Windows 2003/2000

Confidential, OH

Sr SQL Server Developer

Responsibilities:

• Actively involved as a part of a team for gathering and analyzing the User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships
• Upgraded SQL Server 2000 databases to SQL Server 2005.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
• Created jobs using SQL Server Agent and generated SSRS (SQL Server Reporting Services) reports as a part of each job.
• Upgraded DTS Packages to SSIS Packages.
• Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
• Created OLAP Cubes and Dimensions and tables using SSAS.
• Managed the legacy data in the data warehouse from various data sources.
• Created Indexed View to optimize query performance by facilitating easy user interface implementation.
• Created Linked Server to retrieve data from other databases.
• Worked on SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server.
• Documented different Stages of Data Transformation, procedures and scripts.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
• Performed Backups and Restore of the databases.
• Worked with Database tools like Red Gate, BMC patrol, Robocopy.

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, T-SQL, DTS, BIDS, SSIS, SSRS, SSAS.

Confidential, OH

SQL Server Developer

Responsibilities:

• Involved in Physical and Logical design of the databases.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Created and maintained Data Transformation Service (DTS) packages for migrating data.
• Scheduled Jobs for DTS packages.
• Used BCP/Bulk Insert to publish table output to text files.
• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
• Used all Declarative Constraints for maintaining Data Integrity.
• Created Views to restrict access to data in a table for security.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Auditing using triggers.
• Created schema objects, rules and granted roles to the users.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Monitored the Database Performance using execution plans and Index tuning.
• Optimized the query performance with modifications in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.
• Involved in scheduling backups of databases and logs and restoring them when necessary.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 server, Windows NT 4.0.

Confidential

Application and SQL Server Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Documented the data flow and the relationships between various entities.
• Actively participated in gathering of User Requirement and System Specification.
• Created new Database logical and Physical Design to fit the new business requirement and implemented the same using SQL Server.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Created Tables, Views and Indexes on the Database, Roles and maintained Database Users.
• Followed and maintained standards and best practices in database development.
• Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Developed new Stored Procedures, Functions, and Triggers.
• Implemented Backup and Recovery of the databases.
• Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: Windows 2000 adv. server, Windows 2000/XP, MS SQL Server 2000, IIS, MS Visual Studio.