PROFESSIONAL SUMMARY:

• Over 8 years of extensive experience in database design, development and administration with MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS in Finance, Banking, Retail and Healthcare industries.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
• Experienced in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user defined functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2005/2008.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Extensively worked with third party tools like SQL LiteSpeed, Spotlight, SQL Watch, Red-Gate, Erwin, Toad, and DBArtisan.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

MS SQL Server 2008/2005/2000/7.0 , MS SQL Server 2005/2008 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS),, Business Intelligence Development Studio (BIDS), BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2 , Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C#, VB.Net, HTML, XML, XSL, SharePoint 2007, Oracle 9i/10g, Crystal Reports 8.5/9/10/11, Visual source safe 2005, MS office 2003/2007, Windows 2000/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

MS SQL Server Developer/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using MS Visio.
• Installed SQL Server 2008 R2 and Management tools using SQL Server Setup Program.
• Developed and maintained many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output and deploying it on SharePoint 2007.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc to extract, transfer and load (ETL) data from OLTP to OLAP databases.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Developed all the required Stored Procedures, user defined functions, triggers, views using T-SQL as per business logic.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats (PDF, Excel) and resolved formatting issues.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2008 R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in preparing training document for application development and QA/UAT teams.

Environment: MS SQL Server 2008 R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005, VSS 2005, MS Visio 11.0, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential, Marlborough, MA

SQL Server Developer/DBA

Responsibilities:

• Involved in Data modeling to develop the database design using ER-win 4.0.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Developed Database Triggers to enforce Data integrity and to additional Referential Integrity.
• Created SQL reports, data extraction and data load scripts for different databases and schemas.
• 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.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• Wrote Transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Mentoring the team members by reviewing their codes and giving them right direction to accomplish the task efficiently and on time.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.

Environment: SQL Server 2005, T-SQL, CSV, ER-Win 4.0, Windows NT/2000/XP

Confidential, Columbus, OH

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Performed Extraction, Transformation and Loading (ETL) using SSIS.
• Designed Fact tables, Dimension tables and scheduled data transfer from real time database to data warehouse and databases
• Designed SSIS packages to migrate the data from Development Database to Application Database (OLAP).
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
• Developed the reports using business intelligence development studio (BIDS) and SQL Server reporting services (SSRS) based on the business logic by implementing efficient stored procedures.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various format from (PDF, Excel) and resolved formatting issues.
• Used Report manager to deploy reports, schedule reports, and created groups and users. Used role based Security to control access to folders, reports and resources
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, Normalized Tables, established Joins and created Indexes whenever necessary
• Extensively worked on Query Optimization and Performance Tuning of databases
• Deployed SQL Code and Reports (SQL 2005 Reporting Services) to QA\Dev\Prod.
• Participated in Database Design and Code Reviews to ensure optimum Performance
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access, created and managed new security accounts.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2005, SQL Server 2000, SSRS, SSIS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP.

Confidential, Hopkins, MN

MS SQL Server Developer

Responsibilities:

• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, Normalized Tables, established Joins and created Indexes whenever necessary
• Created drill down and sub reports from SSAS cubes that can be browsed on web
• Created SQL Server Reports using SSRS 2005 for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Created SSIS packages to migrate data from Oracle 8i, MS SQL 2005 to MS SQL Server 2008.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
• Documented the data such as entity relationships and attributes, file descriptions and definitions.
• Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created Queries for generating drill down reports in SSRS 2005.

Environment: MS SQL Server 2005, SQL Server 2000, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP.

Confidential, St. Louis, MO

SQL Server Developer

Responsibilities:

• Involved in logical and physical database design using Erwin 3.5.2 and MS Visio 2003
• Maintaining the database consistency with DBCC at regular intervals
• Designed and implemented comprehensive Backup plan and disaster recovery strategies to ensure high availability of data.
• Responsible for database backups, database replication, encryption and database security
• Maintaining high security to patient records by creating and managing new security accounts and restricting user activity on it.
• Involved in trouble shooting and tuning of databases for its performance and concurrency using Database Tuning Advisor.
• Export/ Import data from other data sources like flat files using Import/Export of Data Transformation Services (DTS)
• Analyzing performance elated queries and tune the same using SQL Query Analyzer to optimize application and system performance.
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per the business need.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating with the development team
• Assisted the development team in writing complex SQL scripts and SQL Joins
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Involved in index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Assisted in handling escalating billing issues and propagating bug fixes in production environment.

Environment: SQL Server 2000/7.0, Enterprise Manager, Windows Server 2003, SQL Profiler, DTS, T-SQL, BCP, MS Excel

Confidential, Lansing, MI

SQL Server Developer

Responsibilities:

• Worked with database planning and implementation of physical and logical data modeling using Erwin and MS Visio.
• Worked as a Junior DBA/Developer and assisted in upgrading SQL Server 7.0 to SQL Server 2000.
• Involved in installation, configuration and maintenance of SQL Server 2000
• Modified database structures as per the business need for test/develop environments and assisted the development team with coding, design and performance tuning.
• Configured and implemented database mirroring on production environment to ensure high availability of data.
• Used Bulk Copy Program (BCP) utility to publish table output to text files and to export data from text files to SQL Server 2000.
• Developed DTS Packages to transfer the data between SQL Server databases and files.
• Creating and managing of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the Server performance, debug T-SQL and slow running queries to optimize performance.
• Managing of database objects like Tables, views, indexes, stored procedures, triggers and implementing and monitoring Backups and restoring when necessary.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables to optimize query execution plans.
• Writing stored procedures as business needed and supporting .Net application development team.
• Managing of user profiles including creating/altering, granting of system/db roles and privileges on various database objects to restrict data accessibility.
• Provided 24/7 dedicated production support for assigned application database servers.

Environment: SQL Server 2000/7.0, Enterprise Manager, Windows Server 2003, SQL Profiler, DTS, T-SQL, BCP, MS Excel