SUMMARY

• Around 7 years of IT experience in Database Administration, Design, Development & Support of MS SQL Severs 2012, 2008 R2, 2008, 2005, 2000 and BI, Design (DTS, SSIS, SSRS, SSAS) with various business domains like Sales, Banking, Insurance, Manufacturing and Health care.
• Working experience in Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP & OLAP and experience with MS SQL Server in writing T - SQL.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Extensive experience with SQL Server and T-SQL in constructing tables, views, triggers (DDL/DML), indexes, joins, constraints(keys) with their integrity, functions, stored procedures, user profiles, relational database models, and data dictionary.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experienced in implementing the indexes such as Clustered and Non-ClusteredIndexes appropriately on data structure to achieve faster data retrieval.
• Proficient in writing T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008), DTS, Bulk Insert and Bulk Copy Program utility.
• Experience in creating jobs, Email Alerts, SQL Mail Agent, and Schedule SSIS/DTS Packages.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Created many complexSSISpackages with complicated transformationslikeLookup, Derived Column, ConditionSplit, Multicast, Sort, Union All, Cache Transform, and ConditionalSplitetc.
• Thorough Knowledge of various SSIS Objects such as Dataflow Components, Control Flow Elements, Connection Managers, Runtime Events and Log Providers.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through and Multi-valued parameters etc.

TECHNICAL SKILLS

Modeling & Design Tools: Erwin 4.0, Vision 2002

Operating Systems: Windows XP / NT / / Vista.

Languages: C, C++, C#, SQL, T-SQL PL/SQL VB.NET.

RDBMS: Microsoft SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0, MS-Access

Web Designing: HTML, Photoshop, MS Front Page

MS-Suite: MS-Office, MS Outlook, MS Power-point, MS-Visio, MS- Project

Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Profiler, Query Analyzer

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Crystal Reporting.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

SQL (SSIS and SSRS) Developer

Responsibilities:

• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation
• Highly used T-SQL for developing complex Stored Procedures, Triggers and User Defined Functions, Views, Indexes.
• Used SQL Profiler, System Monitor, Query Analyzer for Troubleshooting, Monitoring, Optimization and Tuning of SQL Server.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) packages and also modified the packages accordingly using the new featuresof SQL Server Integration Services.
• Extensively involved in designing theSSISpackages to export data ofheterogeneous data(like XML, Excel, CSV, PGP, Flat file) source to staging tables in SQL Server Database.
• Created SSIS packages using various Transformations for export data from different data sources and Transformed data and load it to SQL Server 2005.
• Used SSISpackageConfiguration, changing the variables dynamically and SSIS logging.
• Responsible for Deploying, Scheduling jobs, Alerting and Maintaining SSIS packages.
• Created and Configured OLAP Cubes (Star Schema and Snowflake Schema) Using SQL Server Analysis Services.
• Responsible forFull Report cycle including Authoring, Managing, Security and Generation of reports.
• Developed Query for generating drill down, drill through, parameterized, cascaded reports in SSRS 2005.
• Backing up, Restoring system& other databases as per requirements, and also scheduled thosebackups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS Access, Windows XP, VB,C#, Oracle, T-SQL, Query Analyzer.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

• Responsible to create scoping documents, business requirements documents including use cases, detailed requirements for data modelling, ETL and reporting requirements.
• Perform source system’s data analysis for data quality and BI data modelling requirements.
• Primary contact for the management and BI internal IT managers & architects.
• Develop functional requirements for data modelling, ETL and front end reporting.
• Detailed reporting requirements include required filters, metrics and ad hoc reporting functional requirement analysis.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Involved in writing classes for business logic layer using C#.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, triggers, cursors, UDF’s.
• Iteration planning for new features and user stories in Agile Development methodology.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.

Environment: SQL Server 2005/2008, SSIS, SSRS, C#,.Net 3.5, MDX, OLAP, ODBC, XML, MS PowerPoint, MS Access 2007/2003 & UNIX, Agile Programming, Shell Scripting, Crystal Reports.

Confidential, Louisville, KY

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote DDL, DML statements for processing of daily activities.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Responsible for upgrading and migrating of various applications in Access to SQL Server 7.0.
• SQL Server Administration involving planning and implementing Backup and Recovery Strategies
• Configuring the standby servers and setting guidelines to automate recovery scenarios
• Implementation of data transfer through DTS
• Monitoring and fine tuning of SQL Server performance and ensuring integrity
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved performance tuning using indexing (Cluster Index, Non Cluster) tables.

Environment: T-SQL, SQL Server 2000, OLAP Services, Windows 2000 Server, Business Intelligence Suite, SSIS, SSRS, SSAS, Query Analyzer, DTS,MS Access 2000, VB.net 2003, Erwin Data Modeler.

Confidential

MS SQL Server Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2000.
• Upgraded the database from MS SQL Server 7.0 to MS SQL Server 2000.
• Transferred logins and users information using the DTS object transfer task.
• Successfully Transferred logins and passwords information using the DTS Package transfer logins task.
• Gathered all the data from legacy systems and loaded them into a flat file using ETL.
• Created various DTS packages to load data from the flat file into MS SQL Server 2000.
• Involved in BCP commands to transfer data in text files from MS SQL Server 7.0 to MS SQL Server 2000.
• Developed complex SQL queries using various Joins and Sub-queries, Views, Functions and Triggers.
• Created customized stored procedures and triggers for automating tasks.
• Optimized various SQL Server statements with the help of MS SQL Server Profiler.

Environment: MS SQL Server 7.0, MS SQL Server 2005, DTS, Windows NT/ 2000, Erwin v4.0, MS SQL Server Profiler, Crystal Reports 8.5.

Confidential

SQL Server Developer

Responsibilities:

• Installation, configuration the MS SQL Server 2000 and maintenance of servers in various environments.
• Performance and tuning of SQL servers and application issues related to migration.
• Created Stored Procedures, Tables, writing T-SQL codes and SQL joins.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Complete automating on NT so that the tasks are run without user monitoring.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, T-SQL, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.