SUMMARY

• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/2008 and 8 years of experience in MS SQL Server 2000/2005/2008
• Expert in designing and implementing relational database model as per business needs
• In - depth knowledge of Transact-SQL (DDL, DML), Indexes, Views, Stored Procedures and Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and SSRS
• 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
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTE’s Views and Cursors
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance
• T-SQL Programming using DDL, DML commands for various business applications
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008)
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Proficient in designing Data Mart and DataWarehouse using Star and Snowflake Schemas
• Hands on experience in creating the MDX cubes and dimensions
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008
• Worked with report manager for deploying the reports across all the environments
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008)& features
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and Performance Point 2010 and Microstrategy (Mstr) and Dashboards.

TECHNICAL SKILLS

RDBMS: SQL Server 2000/20 R2, MS Access

Languages: C, C++, T-SQL, PL/SQL, Visual Basic 6.0., Unix,Scripting

Operating Systems: Windows Server 2003, Windows 2000 Advanced Server/Server, Windows NT 4.0, Windows XP, Windows 7

ETL Tools: SSIS, DTS (Data Transformation Services)

Tools: SSAS, Erwin 4.0/3.5,Performance Point 2010

Reporting: SSRS (MS SQL Reporting Service), Crystal Reports, MS Access, Excel, Data Analyzer

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL Server Developer/SSRS

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the clients of VI.
• Involved in the Creating Databases for the project I was hired at VI.
• Prepared the complete data mapping and Report Definitions for the project which involved around 40 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Added Localization/Internationalization to all the reports that were created during this project, the localization consisted of 6 different languages.
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications

Confidential, San Antonio, TX

SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS
• Created KPI Objects in line with Requirement Docs
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Scheduled tasks to run every day to update changes in the base tables
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Confidential, Orlando, FL

SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Active Interaction with clients to understand business requirements.
• Actively Participated in logical design of database design to meet new product requirement using ERWIN.
• Successfully implemented physical database on MS SQL Server 2005. Supported complex relationship using triggers.
• Moved the static data from various heterogeneous sources like Oracle, MS Access, and MS Excel and text files to SQL Server 2000 database using BCP and dynamic DTS/SSIS packages.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Automated many operations by scheduling multiple SSIS packages using jobs.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: MS SQL Server 2005, XML, SSIS, MS Analysis Services.

Confidential, Addison, TX

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, ASP.Net, MS Excel, Window XP, Toad.

Confidential

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Designed logical and physical data models using Erwin.
• Backupandrestoredatabases.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary
• Worked on MS SQL Server tasks such as batch jobs, BCP, and indexes.
• Designed, developed and maintained the report updates.
• Involved with the Query performance.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: Microsoft SQL Server 2000, DTS, Windows 95

Confidential

SQL Server Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Usingjoins, database links and formatted the results into reports and kept logs.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• 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.
• Data migration (import & export - BCP) from Text to SQLServer.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.