SUMMARY

• Over 8 plus years of extensive experience in system analysis, design, development and testing in various projects executed in SQL Server 2000/ 2005/2008/2012
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning
• Working Experience in Designing, Implementing, Maintaining Complex Database Applications and Data Warehouse
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS )
• Expertise in writing Database Objects such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
• Experience in designing Database Models using Microsoft Visio and Erwin
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T - SQL Scripts and Batches
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005/2008 using SSIS tools like Import and Export Wizard, Package Installation and BIDS
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• Proficient in creating SQL server Reports using SSRS 2008
• Expert in defining Query for generating drill down reports in SSRS 2008
• Experience in using global variables, expressions and functions for the reports
• Proficient in handling parameterized reports in SSRS 2008
• Experience in optimization tools such as Index tuning wizard, SQL Profiler to resolve Dead Locks/Long running queries, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience in partitioning of tables using partition functions to manage and increase the performance of large or high volume tables
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Hands on Experience in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008
• Experience in High Availability SQL Server solutions, including SQL Server Clustering, Database Mirroring and Log Shipping
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems and Administered Databases greater than 1 TB+ in size
• Experience in creating and implementing (OOP) VB.Net front end application
• Experience in creating and implementing C#.Net and ASP.Net based front end application
• Experience in software development life cycle (SDLC) and RDBMS concepts and constructs
• Experience in providing good 24x7 - Production support

TECHNICAL SKILLS

SQL Server and Databases: Management Studio, Business Intelligence Development Studio, Visual Studio 2005/2008/2012 , Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, SQL, T-SQL, DDL, DML, Stored Procedures, UDF, Triggers, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS,SSAS, SSRS, Microsoft Clustering Services (MSCS). My SQL, Oracle, MS-Access

Data Migration & ETL: MS DTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, DMExpress 5.2

Reporting Tools: SQL Server Reporting Service(SSRS), Crystal Report

Languages: SQL,PL/SQL,XML, PHP, HTML/XHTML, JavaScript, UML, C/C++, VB.Net, VBScript

Version Control: Tortoise CVS version 1.10.9, Visual Source Safe 6.0, Team Foundation Server(TFS)

Networks: HTTP, TCP/IP, FTP, SFTP

Software: Erwin, Visio, Rational Rose, LiteSpeed 5.0, Visual Studio.NET

Others: Relational Database Design, Image processing (MATLAB), Object Oriented Design and Development

Operating Systems: Windows Vista/95/98/2000/XP, Macintosh, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Farmington, CT

Sr SQL Server Developer (SSAS, SSIS and SSRS)

Responsibilities:

• Gather requirements, perform Business Analysis, System and Database Design
• Responsible for overall database design and architecture ensuring optimum level of normalization and standardization of tables for new product development from scratch
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Constructed cubes based on data volumes mostly adhering to Star Schema
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS
• Wrote complex T-SQL statements and created indexed generic views to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity and consistency
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Involved in software development life cycle (SDLC) and RDBMS concepts and constructs
• Wrote complex stored procedures to balance the processing load between front end and back end
• User Defined stored procedures for module integrity and application
• Involved in Designing, Implementing, Maintaining Complex Database Applications and Data Warehouse
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Nateeza and Excel Spreadsheet and CSV format to SQL Server 2008
• Created SSIS Packages by using advance tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting)
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA
• Responsible for defining Query for generating drill down reports in SQL Server Reporting Services (SSRS)
• Responsible for designing stylish report layout
• Involved in using global variables, expressions and functions for the reports
• Responsible for handling parameterized reports in SQL Server Reporting Services (SSRS)
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Managing and maintaining database release schedules and implemented source control using Team Foundation Server (TFS), version management for database releases.

Environment: SQL Server 2008, SQL Server 2012, VB.Net, Visual Studio, SSIS, SSRS, OLAP, TFS, Windows 20008/NT, Windows XP Pro

Confidential, Chicago, IL

SQL Server Developer (SQL Server 2005/2008)

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment
• Wrote complex T-SQL statements and created indexed generic views to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity and consistency
• Wrote complex stored procedures to balance the processing load between front end and back end
• User Defined stored procedures for module integrity and application
• Involved in Designing, Implementing, Maintaining Complex Database Applications and Data Warehouse
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Nateeza and Excel Spreadsheet and CSV format to SQL Server 2008
• Created SSIS Packages by using advance tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting)
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA
• Responsible for defining Query for generating drill down reports in SQL Server Reporting Services (SSRS)
• Responsible for designing stylish report layout
• Involved in using global variables, expressions and functions for the reports
• Responsible for handling parameterized reports in SQL Server Reporting Services (SSRS)
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks

Environment: SQL Server 2005, SQL Server 2008, VB.Net, Management Studio, SSIS, SSRS, OLAP, Windows 2008/NT, Windows XP Pro

Confidential, Richmond, CA

SQL Server Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment
• Wrote complex T-SQL statements and created indexed generic views to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity and consistency
• Wrote complex stored procedures to balance the processing load between front end and back end
• User Defined stored procedures for module integrity and application
• Involved in Designing, Implementing, Maintaining Complex Database Applications and Data Warehouse
• Extensively used Visual Source Safe for controlling the versions of User Defined Store Procedures and UAT documents
• Involved in making Data Dictionary for The Sys-Biobank Data Warehouse target tables
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), DB2 and Excel Spreadsheet to SQL Server 2005
• Created SSIS Packages by using advance tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting)
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups
• Created generic SSIS package which Process the Measures, Dimensions and Cubes created using SSAS based on the requirements. And this package depends on the ETL jobs completion
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks

Environment: SQL Server 2000, SQL Server 2005, SQL Server 2008, VB.Net, Management Studio, SSIS, SSRS, OLAP, VSS, Windows 2003/NT

Confidential, Columbia, MD

SQL Server Developer (Data Warehouse /ETL-SSIS)

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Wrote complex T-SQL statements and created indexed generic views to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity and consistency.
• Wrote complex stored procedures to balance the processing load between front end and back end.
• User Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database
• Involved in Designing, Implementing, Maintaining Complex Database Applications and Data Warehouse
• Extensively used Tortoise CVS for controlling the versions of User Defined Store Procedures and UAT documents
• Involved in technical writing and UAT for The Limited Data Warehouse
• Involved in creating OLAP cubes by using SQL Server Analysis Services (SSAS)
• Involved in making Data Dictionary for The Limited Data Warehouse summary tables
• Expertise in writing Database Objects such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Involved in designing Database Models using Microsoft Visio and Erwin
• Worked on TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches
• Worked on Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.

Environment: SQL Server 2008/2005/2000 , Visual Studio 2005/2008, SQL Server Integration Services (SSIS) as ETL, SQL Server Reporting Services (SSRS), Tortoise CVS version 1.10.9

SQL Server Developer

Responsibilities:

• Designed and developed for data download from external systems to verify revenues and commissions.
• Creation of database, tables and procedures to update and clean the old data.
• Merging data into a single server environment to have better control, consistency and security of data.
• Backing up entire users’ database and scheduling backup process.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.
• Created views for the users according to their roles.
• Participating in the Installation SQL Server. Installed SQL Server Management tools using SQL Server Setup Program.
• Troubleshooting DB performance issues and implementing necessary DB changes
• Responsible for creating signed stored procedures to grant specific privileges to limited access accounts and application roles
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data
• Wrote standard & complex SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Involved in running DBCC consistency checks, fixing data corruption in user database
• Developed, tested and implemented robust Disaster Recovery Plan
• Planning and scheduling Backup Strategy to ensure reliable backup
• Troubleshooting DB performance issues and implementing necessary DB changes
• Involved in implementing CDC Utility of SQL Server 2005 to record DML activity in designated Data Warehouse tables

Environment: SQL Server 2005/2000, Visual Studio 2005

Confidential

SQL Server Developer/ VB Programmer

Responsibilities:

• Created tables, indexes and constraints.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Configured and monitored database application.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Preparation of test plans for assembly testing & System Integration testing.

Environment: SQL server 2000, Visual Basic 6.0, Win NT, Crystal Reports