Profile:

• 7+ Years of IT Experience.
• 7+Years of SQL Server Experience.
• 4+Years of (SSIS/SSAS/SSRS) Experience

Summary:

• Over 7+years of experience in design, development & analysis of SQL Server 2005/2008 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
• 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, Views and Cursors.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• T-SQL Programming using DDL, DML, DCL commands for various business applications
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Integration Services (DTS/SSIS):

• Proficient 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).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• ETL implementation using SQL Server Integration Services (SSIS).
• 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).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• 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

Reporting Services (SSRS):

• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based onclient requirement.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Worked with report manager for deploying the reports across all the environments.

Analysis Services (SSAS):

• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Experience inDevelopingandExtending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Modelsand Deploying and Processing SSAS objects.
• Good Knowledge on creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

Education:

• Bachelor’s in Information Technology

Technical Skills

SQL Server 2008/2005/2000, Oracle 10g/9i/8.0, MS Access, DB2,MS Excel, DB2, Teradata, Sybase.

Tools and Packages

SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, Lite speed, MDX, Visual Studio .Net, ProClarity, DB Pro, Visual Source Team Foundation

Languages

T-SQL, PL/SQL, V.B6.0, MDX, C, C#, ASP.Net, VB.Net.

Operating Systems

Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies

HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages

MS Office, MS Outlook (Microsoft Office Suite)

BI Tools

SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

Confidential, Richmond, VA Jan’11 – Till Date 
SQL / BI Developer

Responsibilities:

• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Database objects – Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script componentand etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Designed and developed Datamart using SSAS.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, C#.net.

Confidential, Sun Prairie, Wisconsin Nov’09 –Dec’10
SQL / BI Developer

Responsibilities:

• Migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created Databases, Tables, Views, Indexes.
• Wrote complex stored procedures, queries, triggers.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for transferring the data using SSIS packages.
• Gathered user requirements.
• Developed Analysis Services Project.
• Responsible for Dimensional modeling.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for Understanding the world scope data feed, help design the 
  target schema and develop an ingestion feed process using SSIS.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes
• Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Designed dimensional modeling with star and schema flakes Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Documented all database objects and packages for future references.
• Educated team on load process and data movement changes.
• Analyzed and designed of software and database solutions.

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, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C# Oracle, T-SQL, Query Analyzer.

Confidential, KY Jun’08- Oct’09
SQL/BI Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Developed, monitored and deployed SSIS packages.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Deployed the generated reports on to the server.
• Assisted in migrating denormalized report DB into a Star Schema design.
• Actively supported business users for change requests.
• Administeredand enhanced SQL Server Integration Services (SSIS) data loads.

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, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C# Oracle , T-SQL, Query Analyzer. 

Confidential Jan’07 –May’08
SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Designed and implemented the Logical and Physical model of the database.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQL Server 2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Confidential Mar’05 – Dec’06
Database Developer

Responsibilities:

• Active participation in the business requirement meetings with the client
• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Written Complex and Extended T-SQL Stored Procedures for application developers and some User Defined Functions.
• Created DTS Packages for transferring data from various sources like Oracle, MS Access, and Excel.
• Created DTS Packages to pull data from Oracle and Flat files.
• Handling database objects with Enterprise Manager and Query Analyzer.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created Clustered and Non Clustered Indexes on tables, views, and columns
• Developed stored procedures, triggers and functions and added/changed tables for data extraction ,transformation and loading
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Performed data conversions from flat files into a normalized database structure.
• Generated reports by using Crystal Reports and Excel spreadsheets
• Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.
• Analyzing the Database Growth and Space Requirements. Handling Users, Logins or User Rights.

Environment: SQL Server 2000, DTS, Access, Excel, SQL Profiler, Import & Export Data, Windows 2000 Server.