Summary:

• A skilled software professional with 8 years of industry experience in design, development and implementation of business requirements with Microsoft SQL Server 2012/2008/2005/2000 database system in client/server environment.
• Extensive experience in developing and Implementing Microsoft SQL Server Integration Services SSIS and Microsoft SQL Server Reporting Services SSRS .
• Expert knowledge of Data Extraction, Transformation and Loading ETL using SQL Server Integration Services SSIS in SQL 2005/2008/2012 and DTS in SQL 2000.
• Highly proficient in migrating organization orders, adjustments, objectives and data in various formats like text based files, excel spreadsheets to SQL Server databases using SSIS.
• Excellent in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery, Report security and created different types of complex reports like Parameterized, Cascading parameterized, Snapshot, Ad hoc, Linked, Cached, Drill-down and Sub reports.
• Experience in solving performance issues with the SSRS reports and troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Very strong T-SQL skills in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers, CTEs in SQL Server 2008.
• Involved in database activities like Maintenance, Performance Monitoring and Tuning using tools such as SQL Profiler, Database Engine Tuning Advisor DTA , Troubleshooting and Replication.
• Strong knowledge in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, running Database Consistency Checks using DBCC.
• Excellent hands on experience in scheduling SQL Server Agent Jobs for database Backups, Restoration and Disaster Recovery Procedures and implementing Backup strategies.
• Knowledge in designing cubes using star schema, deploying cubes in SSAS and creation of reports using analysis services cubes.
• Accomplished in working with users to understand and assess their needs and requirements prior to developing application systems and work effectively as a part of team or independently.

Skills Set:

MS-SQL Server 2000/2005/2008/2012, DTS Data Transformation Services , SSIS MS Integration Services , SSRS MS Reporting Services , SSAS MS Analysis services , Import/Export Wizard, SQL Profiler, Database Engine Tuning Advisor, SQL Agent, Erwin, Visio, SharePoint, TSF, C , T-SQL, Oracle, MS Office, C , .NET, Excel, XML.

PROFESSIONAL EXPERIENCE

Confidenital

MS SQL Server/BI Developer

Microsoft Corporation is an American multinational corporation that develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. The aim of the project was to maintain existing system and develop new features to pull the data from the upstream, apply business logic and ingest it to the third party vendor, who would pay royalties to the various companies as per the contracts signed.

Responsibilities:

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Developed various ETL packages to load the data from the upstream databases and flat files into the local relational databases.
• Configured SSIS Packages for run time Parameters and Configuration file, and created various event handlers to handle any errors.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the final destination.
• Successfully managed Extraction, Transformation and Loading ETL process by pulling large volume of data from various data sources using BCP.
• Worked extensively with lookup Transformation for comparing the data between the source and destination while loading to avoid duplicates.
• Worked with the Windows Services to load the aggregated data from OLTP servers to the Reporting servers for reporting.
• Created ETL metadata reports, reports including execution times for the SSIS packages, Failure reports with error description and developed an automated report subscription process using SSRS.
• Responsible for creating reports based on the requirements using SSRS 2008/2012 and scheduled monthly/weekly/daily reports to run automatically.
• Involved in creating complex reports using SSRS 2012/2008 from the OLAP cubes for end user analysis.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Created Views to restrict access to data in the tables and optimized the database by creating various clustered, non-clustered indexes.
• Responsible for Query optimization and performance tuning using tools like SQL Server Profiler, Database Engine Tuning Advisor and index creations.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , MS SQL Server Reporting Services SSRS , SQL Server Migration Assistant SSMA , BIDS, DTS, MS Visio, SQL Profiler, Database Engine Tuning Advisor, T-SQL, Oracle, MS Office.

Confidenital

MS SQL Server/BI Developer

Mitchell International, Inc. is one of the three largest auto collision repair information service provider company in the North America serving 30,000 collision repair facilities. The aim of the project was mainly concentrated to maintain the information of customers all over US by creating various SSIS packages to load data from heterogeneous sources.

Responsibilities:

• Worked with business users and solution managers to understand the business requirements and convert them into technical specs.
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Improved the data quality by filtering bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Fuzzy grouping transformation, Conditional split and other types of data manipulation.
• Applied conditional formatting in SSRS to highlight key areas in the report data and developed an automated report subscription process using SSRS.
• Created complex matrix, drill down reports and also dashboards using graphs and heat maps based upon the business requirements.
• Configured various data driven subscriptions for the same report based upon the different requirements from the business users.
• Worked with the Analysis team to create the reports based upon the cubes developed by the team.
• Developed various database objects and successfully implemented indexes on the tables for optimum performance by using index tuning wizard
• Worked with the DBA's to optimize the queries by getting insight from Execution Plan for better performance of the database.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , MS SQL Server Reporting Services SSRS , SQL Server Migration Assistant SSMA , BIDS, DTS, MS Visio, SQL Profiler, Database Engine Tuning Advisor, T-SQL, Oracle, MS Office.

Confidenital

MS SQL Server/BI Developer Comcast Corporation is the largest cable operator and home internet services provider in the nation. The aim of the project was to collect the data from heterogeneous sources and integrating it with the existing database design system using Integration Services and generating sales and target reports using SSRS.

Responsibilities:

• Extensively involved in the full lifecycle of ETL software development SDLC - analysis, design, build, documentation and testing for the project using SQL Server Integration Services.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and created several SSIS packages in Microsoft SQL Server.
• Automated the migration of data from Oracle DB to MS SQL Server DB using Microsoft SQL Server Migration Assistant SSMA .
• Developed and deployed data transfer packages to the appropriate destinations using SSIS.
• Created SSIS packages to load data from the OLTP system to a Data mart and involved in the design of transformation strategy from OLTP to OLAP Interfaces using SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.
• Developed design specification and SQL Server documentation using tools such as BI Documenter and dtsdoc.
• Created/modified a variety of parameterized, drill down, drill through, chart, matrix, sub reports using SSRS 2005 using data from a variety of sources.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Created complex stored procedures, efficient triggers, required functions, indexes, and indexed views for improving performance.
• Designed database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services, SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , SQL Server Migration Assistant SSMA , DTS, T-SQL, BI Documenter.

Confidenital

MS SQL Server/ETL Developer

Confidenital is the nation's leading financial institution providing banking, insurance, investments, mortgage and consumer finance through internet and other distribution channels. The project was to predict the future market in advance, in accordance to the stock and investment. Policy data was hedged daily to find out the negative/positive flow of money and reports were generated.

Responsibilities:

• Performed database management, design performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Extract Transform Load ETL development using SQL Server Integration Services SSIS and Performed backups and restore operations as per schedule.
• Development and production support for various databases and SSIS packages.
• Moved the static data from various heterogeneous sources like Oracle, MS Access, MS Excel and text files to SQL Server 2005 database using BCP and dynamic DTS/SSIS packages.
• Enhancing and deploying the SSIS Packages from development server to production server.
• 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 .
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used most of the Control and Data Flow tasks and created XML configuration files to enable portability of packages.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures and also reviewed many T-SQL issues using management studio for better performance.
• Scheduled Jobs and Alerts using SQL Server Agent and evaluated database performance, performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005, Excel pivot tables , SSIS, T-SQL, BCP, Visual basic, Visual Studio2005, MS Access, Oracle, Windows 2000/XP.

Confidenital

MS SQL Server Developer

Confidenital offers net banking services, personal banking, corporate banking and NRI banking in Confidenital The scope of the project was to build customer-centric database to analyze transactions across finance, marketing, risk, collections, and consumer relations was developed.

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• 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.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise and Involved in performing database Backup and Recovery.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Designed and implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Worked on Exception Handling with error and Try/Catch blocks.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Worked on Documentation using MS word.

Environment: SQL Server 2000/2005, T-SQL, DTS, Visual Basic 6.0/5.0, Crystal Reports 7/4.5