SANDEEP Email:ktk3av@r.postjobfree.com

MS SQL SERVER DEVELOPER Phone: 908-***-****

• Over 7 years of experience in IT, Financial and Healthcare environments with primary skill on SQL Server database development and administration with SQL Server 7.0 /2000/2005/2008 and.Net Technologies.

• Experience with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes,Stored Procedures, relational database models, data dictionaries, and data integrity ,BIDS.

• Expertise in SSIS(Integration services),SSAS(Analysis services) ,SSRS.

• Expert in optimizing database choosing appropriate indexes using Index tuning Wizard, SQL Profiler.

• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services(DTS) , SSIS, BCP,Bulk Insert, ActiveX).

• Had a major role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.

• Extensive experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.

• Expertise in providing Business Intelligence solutions in Data Warehousing using Cognos 8.0 Framework Manager, Report Studio and Query Studio.

• Expertise in performing administrative tasks such as database files management, backup/restore, security management, data integration and synchronization.

• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility.

• Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.

• Good Knowledge in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.

• Extensively worked on SSIS packages to transfer data from heterogeneous databases & different files format (Text File, Spread Sheet, and XML) to SQL Server 2005.

• Building reports using Crystal Reports and Cognos.

• Developing custom ETL using DTS.

• Experience in developing applications with ASP.NET, C#, VB.NET, XML and Web Services.

• Thorough knowledge and extensive experience in using .NET Framework Common Language Runtime (CLR) assemblies to create SQL Server objects, such as Stored procedures and triggers.

• Designed and mapped using various SSIS Transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.

• Good knowledge on Oracle 9i and Sql Server 2000/2005,MS Sharepoint Server

• Experience in providing high quality application support on data integration and data management projects.

• Worked on complex data loading from FTP sites (implemented the batch data cleansing and data loading).

• Worked as Senior Developer in large-scale production environments.

• Good ETL skills ,Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance.

• Experience in the areas of design and development of client/server database applications and Database Data modeling using Erwin 3.5.2 ,MS Visio.

• Experience in Data Profilers

• Well-versed in OOAD - UML, RUP & SDLC methodologies.

EDUCATION: Bachelor of Science, Major in Computer Science.

Oracle Certified PL/SQL Developer.

Technical Skills:

Operating system Windows 2000/03 Servers, Windows NT/XP,UNIX

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

DataWarehousing & BI SQLServer,BusinessIntelligence DevStudio,SSIS,SSAS,DTS Informatica(5.1,6X,7),Cognos(Impromptu,PowerPlay,DBVisualizer,

AccessManager,)SQL Server 2000 Analysis Services and SQL Reporting services.

Programming languages C,C++,C#.NET,VB.NET,ASP.NET,SQL,PL/SQL, ASP VC++6.0, XML, XSLT, CSS,Java.

Web Designing Tools HTML, XSLT, XPATH, XSL-FO.

ETL Tools DTS, SSIS (SQL Server Integration services), SSAS

Development Tools SQL Server Business Intelligence Development studio.

Visual Studio, WCF

Version control Visual SourceSafe, Team Foundation Server.

Reporting Tools Cognos Reportnet, ReportStudio and QueryStudio,Aspose

Data Modeling Star Schema Modeling, FACT, Dimensions Tables,

Physical and Logical Data Modeling.

Scripting UNIX Shell (Korn, Bourne, C), Java Script, VB Script.

DB Design Tools ERWIN,MS VISIO

Client: Results Technologies, Kennesaw,GA. Aug’07 to Present

Position: SqlServer 2005 Developer/SSRS/ SSIS

Project: USRobotics, XmRadio

Results Technologies is call center IT Management and Reporting Company. Results generates 4000 reports daily around the globe for outbound and inbound clients. Generally in either Microsoft Excel ,flat file formats,web reports containing statistics on industry callmetrics.Worked with team of developers developing applications deployed in 2000+ user call centers and Worked on Deliverable Manager Application which was deployed corporate-wide including 4000 branch locations throughout US and also worked with Web reporting system RNET.

Responsibilities:

• Developed/Supported Intranet-based applications for call centers and corporate-wide use (Extensively used T-SQL(DDL, DML), C#,ASP.NET for webservices.

• Done lot of Query Optimization and Performance Tuning of Stored Procedures.

• Developed more than 500 Stored Procedures with complex business logics.

• Migrated the DTS packages into SSIS(Integration Services).

• Used the Checksum Transformation logic for incremental updates ( incremental rows and modified rows ).

• Extracted the data from XML and CSV files to SQL Server 2008.

• Created the Staging tables, successfully migrated old data from legacy system into SQL Server 2008 using SSIS Packages.

• Extracted the data from AS400&Altitude to SQL Server 2008 using SSIS as ETL tool.

• Transferred data by adding Derived column Transformation, count of records, merging of data has been done while pulling data from Source to the Target.

• Created various Stored Procedures to validate the data from source and update the records and insert them into a newly created table.

• Developed several Complex Reports (daily, weekly, monthly, quarterly and yearly) using SSRS (SQL Server Reporting Services).

• Actively involved as part of team to modify or generate Store Procedure as per LOB’S user requirements

• Wrote some C# procedures and deployed them to the database server.

• Involved in the conversion of old VBasic to C#.NET,Used ADO.NET for Database manipulations.

• Worked with an offshore team of 30 junior developers.

• Achieved great strides on automating various manual processes through DTS Packages and Jobs, Writing code and creating jobs to automate repetitive tasks.

• Developed some windows based applications in C#.Net for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports, Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.

• Enhanced the old Excel Reports to new SQL Server Reports fit new business requirement, and implemented into SQL Server 2005.

• Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005, Used Pivot tables to provide structured Reports like monthly, weekly.

• Temp Tables are used for reduce the number of rows for joins, to aggregate data from different sources for different reports.

• Indexes are created on tables for new database for faster retrieval for the reports.

• Created DTS packages and scheduled data migration from old system to new system and verified making different reports on new system.

• Created Views and Indexed Views to reduce database complexities for the reports.

• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Environment: Microsoft SQLServer 2005/2008 Enterprise Edition, SQL Server Reporting Services(SSRS), Management studio, SQL Server IntegrationServices(SSIS),Windows 2000, Erwin, Ms excel 2003,Microsoft Visual Studio.NET 3.5 ,Team Foundation Server ,WCF.BIDS.

Client :Progressive Insurance, Mayfield, OH . Nov’06- July’07

Position: SQL Server Developer/ SSIS/SSAS.

The Progressive Group of Insurance Companies ranks third in the nation for auto insurance, with More than 12 million customers. It Provides Auto, Home & Business insurance.

Project: SolidG Client Web

Client Web is a web-based system which is used by customers of Progressive and its partners. The primary purpose of the Client Web System is to provide the users with a more comprehensive recovery and reporting functionality, to increase the standards of customer service and improve ease-of-use.

Responsibilities:

• Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships, data transformation through mapping development, validation and testing of mappings.

• Developed the Logical and Physical Design models as per business requirements using Sybase Power Designer.

• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.

• Migrated the Data from SQL Server 2000 to SQL Server 2005 Using SSIS.

• Used various Migration Wizards like Import and Export Wizard and Migration Wizard.

• Developed logic for incremental updates ( incremental rows and modified rows )

• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.

• Extract the data from SQL Server 2000 to SQL Server 2005 using SSIS as ETL tool.

• Implemented the Package configuration using XML files.

• Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.

• Defined report layouts

• Identified and defined the Datasets for report generation

• Wrote queries for drill down reports.

• Developed a Tabular Reports using SSRS Report Designer.

• Debugging reports and deploying reports on server

• Created an ad-hoc reports using SSRS Report Builder.

• Used complex expressions to calculate groups, filters, parameterize, and format the contents of the reports

• Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2000 to the SQL Server 2005.

• Used various transformations like MultiCast, Conditionalsplit, OLEDB Command, Script Component and Lookup while loading the data into Destination.

• Created various Stored Procedures to validate the data from source and update the records and insert them into a newly created table.

• Created the Indexed Views for better performance.

• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

• Developed the T-SQL Statements for loading the data into Target Database.

• Involved various levels of testing (Unit, Functional and Integration), with Data Profilers.

• Build cubes with SSAS and written MDX scripts for generating reports on top of cubes.

Environment: SSIS,SSAS, Informix,Sybase Power Designer, SQL Server 2005, VSS 3.5, SSRS,Team Foundation Server,BIDS

Client: Merrill Lynch, NJ. Dec’05 - Oct ‘06

Role: SSIS/SSRS Developer.

Post trade services are managing and maintaining all the data related to the trades after they are initiated in the market. Whether a trade was settled, cancelled, postponed or never finished, all the information is collected through Legacy systems and then reconciled in the night before the next trading day starts. Based upon this data, various reports are generated. We developed the Production support website to monitor the nightly recon and production issues. The development, maintenance and enhancement of this website are done by the onsite team. I was one of the team member for Merrill Lynch Development team.The GMI GEF&S, Merrill Lynch Project consisting of development, maintenance and enhancement of the Existing Project

Responsibilities:

• Actively Involved in a Database Design, Coding and Testing.

• Actively involved in creation of required database, modified tables, triggers, and procedures to clean and validate the data to meet the specifications.

• Created views and indexed views as required by front end developer for easier implementation on web pages.

• Created stored procedures and functions to support efficient data storage and manipulation.

• Involved in metadata modeling, creating a project, creating and publishing the package.

• Converted the DTS Packages into SSIS using Migration Wizards.

• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.

• Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings.

• Actively Involved in Testing and Debugging the Stored Procedures and T-SQL.

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

• Extracted the data from SQL Server 2000 to the SQL Server 2005 using SSIS as ETL tool.

• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

• Developed a Tabular Reports using SSRS Report Designer.

• Implemented the Package configuration using XML files.

• Designed models in Framework Manager and worked with parameter maps.

• Involved in metadata modeling, creating a project, creating and publishing the package.

• Used custom queries in certain reports.

• Used Script Component to generating the Surrogate key values in Dimensional Tables.

• Involved in query tuning for increasing the query performance.

• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

• Designed and implemented critical system recovery plan through different stages of backup and replication.

• Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2000 to the SQL Server 2005.

• Used various transformations like Multicast, Slowly Changing Dimensions and Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.

• Created various Stored Procedures to validate the data from Source and update the records and insert them into a newly created table.

• Build test scenarios and test cases (negative / positive) to validate expected outcome

• Migrated tables to the Data Warehouse using DTS for reporting purpose.

• Created OLAP Cubes using Star Schema and Snowflake Schema.

• Created OLAP Databases and generated reports Using COGNOS and MS Excel.

• Created various report types like simple report, cross tab, sub report and drill through that cover the entire range of enterprise reporting requirements and distributed to users.

• Created and Modified Catalogs for different applications by using Impromptu Administrator.

Environment: SSIS,SSAS Business Intelligence Development studio (BIDS),SSRS DTS, HL7,BIDS

Visio, Windows XP,IIS,SQL Server 2000/2005 and Cognos7 series.

Client:Medical Services Company, Jacksonville, FL. Oct ’04 – Nov ‘05

Role: SQL developer/SSAS

MSC - Medical Services Company is a Nationwide Leader in the delivery of medical products and pharmacy services to the workers' compensation industry. MSC serves both the workers' compensation insurance carrier as well as the injured worker.Leaded the web based reporting team. Responsible for development, test, and Production database environments for the company’s web-based applications and Managed user security, roles, profiles and assignment of privileges. Perform data modeling, design, code review, debugging. More than 200 reports for various insurance carriers like Liberty Mutual, Safeco, and Cambridge etc.

Responsibilities:

• Responsible for re-designing database models for various MSC applications and tools.

• Responsible for developing and implementing database objects like Stored Procedure, Triggers, Indexes, functions etc for all the MSC applications and tools.

• Responsible for conversion of data from Data Ease (heterogeneous source) to MSC database, from Fastrack database to MSC database using DTS scripts / Stored Procedures .

• Developing Web Forms using ASP.NET and Code behind using VB.NET.

• Developed Business logic components using interfaces in C#.

• Prepared and updated the Functional Specification Document.

• Developed User Controls to enhance the UI functionality.

• Managed and maintained the Safeco Letters Project with full control.

• Responsible for the design and development of the MSC Rx Database structure to implement the Hierarchical structure of the customers. The structure is modeled to provide a universal structure to accommodate customers with complex hierarchical business models.

• Responsible for planning, developing and implementing security model for MSC’s web reporting system.

• Responsible for creation & maintenance of database, table spaces, users, tables, indexes, store procedures, roles, profiles, partitions and other schema objects.

• Maintaining and creating replication (Merge, Transaction, and Snapshot) and cluster (Active/Passive) environment with fast problem solving capacity.

• Responsible for the production database performance, index tuning, query optimization.

• Monitor Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Capturing long running SQL/runaway queries using SQL Server.

• Tuning Queries and Database performance using tools like SQL PROFILER, SET IO, QUERY EXECUTION PLAN .

• Responsible for scheduling and managing jobs on MS SQL Server.

• Responsible for designing and writing DSS queries and reports.

• Worked throughout the projects to support the areas of 1) data quality and standardization, 2) data definition, 3) data modeling, 4) metadata repository management functions, and 5) data replication.

• Researched and defined the use of SQL Server 2000 Analysis Services and SQL Reporting services.

• Designed Logical and Physical data models of the data warehouse, report repository and report access security database.

• Designed cubes for the OLAP database.

• Load, transform and extract data from different sources such as production database, flat files, excel files into staging database for cleanup using DTS.

• Nightly jobs to load data from staging database to the OLAP database.

• Defined measures and various dimensions to analyze the measures of the cube.

• Used Data Profilers for testing.

Environment: SqlServer 2000/2005,DTS, ASP.NET, VB.NET, C#, XML, Visual Source Safe, Active Reports 2.0, Windows Server 2003,Oracle 9i.

ICICI BANK, India . Aug’03 to Sept’04

MS SQL Server Developer/DTS

Customer Loan processing System

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages and import/export data feeds to/from data warehouse and loan systems.

• Created new database objects like Sequences, Procedures, Functions, PackageTriggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.

• Worked with Client/Business Analysts to define data requirements for reporting Warehouse and loan systems to import data feeds.

• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.

• Configured product meta-data tables to support client data reporting needs.

• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the bank’s financial data.

• Written complex SQL statements using joins, sub queries and correlated sub queries.

• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.

• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

• Created SQL reports, data extraction and data loading scripts for different databases and schemas.

• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.

Environment: MS SQL Server Analysis Service 2000, Visual Studio 2003 VB 6, Transact-SQL,VBScript, Erwin,Crystal Reports, Microsoft Visio 2000, .Net, ASP, MSExcel ,Windows2000/NT,Oracle .

Client: Apollo Hospitals, India. June’02 to July’03

Role: .NET/SQL Server Developer

Project: Medical Inventory Management System (MIMS) is a web-based application developed for Doctors and Small Hospitals to maintain the Inventory of the drugs.

• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2000.Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.

• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.

• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP.

• Assisted in designing and creating website utilizing ASP and .Net technologies for the system using ADO.Net, HTML, XML in designing form, validating inputs and connecting to backend database

• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard

• Performed rigorous Performance Tuning of queries written in middle layer and backend to gain huge performance gain of webpage loading.

• Involved in testing and debugging business logic in Store Procedures with Application Development Team.

• Prepared scripts to upgrade the software from one version to another and make sure the client’s production data has been correctly populated after the up gradation.

• Data migration (import & export – BCP) from Text to SQL Server.

• Used Crystal Reports to generate ad-hoc reports Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency. Wrote complex stored procedures to process driver’s record and balanced the processing load between front end and back end.Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.

• Developed windows based applications in C#.Net for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.

Environment: MS SQL server 2000, DTS,Oracle,ASP, C#.Net, Windows2000/NT,Crystal Reports,

Contact this candidate