SUMMARY

• Experienced IT resource with over 8 years of intensive hands - on experience in SQL server both as a developer and a DBA, as well as front end application development using .NET. Possess good knowledge of healthcare, finance, banking, and electrical domains.
• Extensive experience in designing solutions for ETL using SSIS and reports using SSRS. Various high impact contributions in the areas of performance tuning and innovation. Experience in leading a development team spread across multiple locations.
• Over eight years of experience in SQL Server 2012, 2008 R2, 2008, 2005, 2000 as developer & DBA in finance, banking, healthcare and electrical domains.
• Experience in business requirement analysis, system design, development, unit testing, implementation, maintenance, estimation of Web/Windows based applications and ETL applications.
• Expertise in creating complex stored procedures, functions, triggers, tables, views, triggers and other database objects.
• Expertise in T-SQL queries, dynamic queries, sub queries, nested queries, correlated queries, common table expressions (CTE), SQL joins union, aggregate functions.
• Expert in data extraction, transformation and loading (ETL) using various versions of SQLserverintegration services (SSIS) like 2005, 2008, 2012.
• Used SSIS components like execute package, execute process, web service task, XML task, send mail task, FTP task, file system task, execute SQL task, data flow task, bulk insert task, various DBA tasks and containers like for loop, for each loop and sequence container.
• Expert in creating reports with the use of different report properties like chart controls, filters, interactive sorting,single and multi-valued parameters, cascading parameters, sub report, drill down and drill through reports, etc using SQL server reporting services (SSRS) versions 2005, 2008, 2012.
• Used various SSRS components like charts, matrix, table, rectangle, etc. Implemented features like filters, interactive sorting, single and multi-valued parameters, cascading parameters, sub-reports, drill down reports, drill through reports etc. in the reports.
• Used shared and embedded data sources and datasets in SSRS.
• Expertise creating reports using Tableau.
• Development and maintenance of OLAP cubes using SSAS.
• Creating, modifying, deploying and browsing Cubes with multiplefact measuresandmultiple dimension hierarchies in SSAS.
• Deployment of SSIS packages to file system and SQL server using different deployment techniques.
• Worked on database design, database schemas & methodologies, building complex queries and task automation by scheduling jobs on SQL server as well as on autosys.
• Expertise in performance improvement of SSIS packages and SSRS reports.
• Expertise in performance tuning of SQL stored procedures and various other database objects.
• Using SQL server execution plan, data tuning advisor and profiler for performance improvement and process improvement.
• Table partitioning, indexing (clustered, non-clustered and column stored indexes), indexed views, files and file groups.
• Extensively worked in database development, maintenance and DBA activities.
• Experience in implementing different types of Replication Models like snapshot, merge and transactional on basis of business specification and Database Mirroring
• Worked on production environments of different applications, scheduled backups, creating linked servers, restoring backup.
• Setting up environments for development and testing of applications.
• Experience in writing distributed queries between SQL servers and DB2 databases by creating link servers.
• Worked on Microsoft Project Server 2010 to manage the project team and work status for team estimations.
• Worked on estimation of space requirements for development and production databases.
• Monitoring of production databases and quickly fixing the blocking & performance related issues.
• Good in analyzing table data and rebuilding or reorganizing the indexes to improve the performance.
• Experience in creating high level technical design documents and created functional flow documentation for new and existing applications.

TECHNICAL SKILLS

Databases: SQL Server 2000, 2005, 2008, 2008 R2, 2012, DB2

Operating Systems: Windows Family

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

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, 2008, 2012, Enterprise Manager, Query Analyzer, Power shell, Profiler, Performance Monitor, DTS, Log Shipping, Database Tuning Wizard, Index Tuning Wizard, BCP, SSIS(SQL Server Integration Services), SSRS(SQL Server Reporting Services), SSAS (SQL Server Analysis Services)

Web Technologies: .Net, HTML, Java Script

Source Control: Visual Source Safe, Team Foundation Server.

ETL Tools: SQL server integration services

Reporting Tools: SQL server reporting services

Scheduling tool: Autosys

Other Technologies: MS Office(Excel, Word, PowerPoint, Visio), VBA

PROFESSIONAL EXPERIENCE

Consultant

Confidential, Detroit, MI

Responsibilities:

• Requirement gathering, design, analysis, documentation.
• Meetings with client for requirements and status updates.
• Entire software lifecycle including requirement gathering, analysis, design, documentation, development, testing and production deployment.
• Design and create SQL server database objects maintaining the bigger data mart structure and standards.
• Design and create SSIS packages to get data from different sources like flat files and Oracle.
• Creation of ETL's for validation of data.
• Creating reports using Tableau for mobile friendly reports and SSRS for web reports.
• Creating dimension and fact tables.
• Creating tables, functions, and stored procedures as part of project.
• Partitioning of tables to improve the performance and to handle large sets of data.
• Indexing on partitioned tables.
• Moving objects from development to test to production environments.

BI Developer

Confidential, Phoenix, AZ

Responsibilities:

• Requirement gathering, analysis, documentation.
• Daily meetings with client for requirements and status updates.
• Writing complex SQL scripts for adhoc reporting.
• Worked on the fixing the bad data in legacy tables in batches, created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in excel report and notify by emails and using expressions in SSIS packages.
• Design and create SSIS packages to get data from different sources like excel, flat files, Oracle, Access databases.
• Migration project to migrate the database from Access database to SQL Server.
• Creation of ETL's for validation of data.
• Create ETL and SSRS reports to automate the adhoc reporting.
• Performance tuning for long running T-SQL scripts and stored procedures.
• Performance tuning of SSIS packages to load large data files.
• Creating tables, functions, and stored procedures as part of automation.
• Moving objects from development to test to production environments.
• Deployment of SSRS reports to report manager.
• Deployment of SSIS packages to SQL server.
• Creating jobs to automate SSIS packages.

Sr. SQL Developer

Confidential

Responsibilities:

• Responsible for migration of ETL logic from .net to SSIS.
• Designing and reviewing the migration strategy, database and database objects.
• Migration of ETL from SSIS 2008 to SSIS 2012.
• Creating database objects like tables, stored procedures, functions and views.
• Performance tuning of SQL stored procedures by using various optimizing techniques, analyzing the SQL script using execution plan, and profiler, making proper usage of Indexes.
• Creating SSRS reports using SSRS 2012.
• Deployment of SSRS reports to report manager and Share Point.
• Deployment of SSIS packages.
• Migration of SSRS reports from SSRS .
• Creation of report subscriptions for automating reports.
• Scheduling ETL using SQL Jobs in SQL server agent and sometimes on Autosys as per business need.
• Implementation of change data capture (CDC) in SQL server.
• Requirement gathering, analyzing the requirements and providing appropriate solutions.
• Writing adhoc queries according to the business requirements and providing data to user in excel.
• Extensive used export/import utilities for selective backup, transferred tables between different instances.
• Created standard subscription, data-driven subscription for SSRS reports in report manager and share point.
• Agile methodology for development.

Team Lead

Confidential

Responsibilities:

• Estimations for team and effort involving planning, Analysis and complete SDLC.
• Worked with tools like Microsoft Server Project for cost estimations and project management.
• Work with a team of 7 developers to assign and manager the work.
• Worked on complete SDLC right from requirement gathering, analyzing, documentation, design, development, unit testing and deployment.
• Creating and maintaining various databases for development and testing environments using SQL server 2005, 2008, 2008 R2 and 2012
• Creating tables, views, stored procedures, functions and other database objects as per requirements
• Worked on performance tuning of SQL stored procedures, SSIS packages and SSRS reports.
• Creating and maintenance of SSIS packages on SQL server 2005 and 2008 to extract data from various sources like SQL server, DB2, excel, flat files etc and destinations like SQL server, excel, DB2, flat files.
• Creating reports using SSRS 2005 and 2008.
• Automating the ETL by scheduling them on SQL server Agent and Autosys.
• Deployment of SSIS packages to file system and SQL server.
• Deployment of SSRS reports to report manager and share point.
• Report subscriptions on report manager and share point. Both data driven and standard.
• Migration of reports, packages and databases from SQL server R2.
• Design and creation of data mart.
• Worked on DB2 by creating tables, creating ETL to load tables and used DB2 as source and destinations.
• Created standard subscription, data-driven subscription for SSRS reports in report manager and share point.
• L1 and L2 support of production servers to ensure smooth functioning of system.
• Support and maintenance and enhancements of OLAP cubes using SSAS.
• Creating scripts using .net code to automate the process of creating SSIS packages.
• Prepare prototypes using Oracle Business Intelligence(OBIEE).
• Creation of various re-usable scripts in order to automate tedious manual processes.
• Created project flow diagrams using Visio.
• Handling a team of 5 members from different locations assigning work, reviewing and make sure meet the project deadlines.

Sr. SQL Developer

Confidential

Responsibilities:

• Create and maintain packages using Microsoft SQL server integration service (SSIS) to interact with various teams.
• Create and maintain reports using Microsoft SQL Server Reporting Service (SSRS) as per business requirements.
• Writing complex stored procedures as per business need.
• Involved in database migration tasks and modifications to the database, deployment of these changes to various environments and monitoring of servers.
• Support multiple applications like excel integration by writing macro VBA code in excel.
• Took many initiatives to automate manual tasks which would otherwise take a lot of manual effort.
• Implementation of change data capture (CDC) in SQL server.
• Performance improvement of SQL database objects and stored procedures.
• Performance improvement of SSIS packages and SSRS reports.

Sr. Developer

Confidential

Responsibilities:

• Requirement gathering, analysis and documentation.
• Design the application and prepare design documents.
• Prepare server specification for database and application servers.
• Database design, implementation of database. Creating tables, views, stored procedures, functions.
• Design ETL mechanism to get data from various sources like excel, Access DB to SQL server.
• Data profiling the data from various sources which was manually maintained.
• ASP.net coding to prepare front-end screens for the web application.
• Create complex stored procedures to in corporate the business logic.
• Indexing on tables and views, table partitioning for performance improvement.
• Creating reports using SSRS for business users to take critical decisions.
• Preparing unit test case documents and completing the unit test.
• Automation of ETL by scheduling the SSIS packages on SQL server agent jobs.
• Automating critical reports by creating report subscriptions.
• Production support for smooth functioning of system.

Developer & DBA

Confidential

Responsibilities:

• Involved in database administration and maintenance.
• Creating script for taking regular backup.
• Creating jobs.
• Creating and maintenance of complex stored procedure and Triggers, functions, tables, views.
• Creating reports using C#.net, ASP.net and ADO.net, HTML, XML, Java Script.
• Creating SSIS packages for extracting-transforming-loading data between various sources like SQL server, Oracle server, DB2, Excel to destinations like SQL server, excel, flat files.
• Creating SSIS packages for database administration activities like backup and restores, indexing, monitoring of database. shrinking database, blocking monitoring, and to get automated mails.
• Migration of database from SQL server .
• Migration of DTS packages to SSIS packages.
• Creating reports using SSRS 2005.
• Worked on DTS packages (imports and exports).
• Managing security by creating logins, users and roles.
• Involved in performance monitoring and performance tuning of the stored procedures in T-SQL.
• Ensuring data consistency in the database through DBCC commands.
• Creating and scheduling jobs in SQL server by automating the daily tasks.
• Used SQL server profiler to monitor and record database activities of particular users and applications.
• Configured transactional replication and log shipping with SQL server management studio
• Monitoring SQL server replication, database mirroring and log shipping.
• 24X7 support to production servers.
• Deployment of applications and databases to various other client locations.
• Involved in configuring and maintenance of database mirroring and have knowledge of database clustering

Confidential

Responsibilities:

• Creating database, tables, views, stored procedures, functions using T-SQL.
• Export data from Sybase to SQL Server using Windows service and SSIS packages.
• Created stored procedures to access data from different servers by creating linked server.
• Generated operational reports using the web application.
• Played key role in requirement gathering and finalizing the requirements.
• Played a crucial role in development, testing, and UAT of applications in client locations.
• Testing of applications for performance, data integrity and validation issues.
• Extensively worked in writing the ad-hoc queries as per the user requirement for data analysis and automated the frequently asked queries using SSRS.