SUMMARY

• Over 8 years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008 R2/2008 using SSIS, SSAS, SSRS in Healthcare, Retail, Banking, finance and industries.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
• Hands on Experience in using tools like SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Designing and development of various dashboards, reports utilizingvarious TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed, monitored and deployed SSIS packages.
• Experience in developing Drill through and Drill down reports using MS SQL Server Reporting Services (SSRS)
• Experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.
• Experience in Deploying SSIS packages using the Legacy deployment model as well as deploying SSIS packages using the new Deployment model (Project deployment Model) from SQL server 2012 using SSISDB catalog, configuring project parameters and environments.
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong team player with great verbal, written communication and interpersonal skills.

TECHNICAL SKILLS

• MS SQL Server 2016/2014/2012/2008 R2/2008 MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Server 2008 Analysis Services (SSAS)
• Microsoft Access 2010
• Erwin 8.0/7.3/4.2/4.1/4.0
• Microsoft Visio 11.0/10.0
• T-SQL
• PL/SQL
• ASP.NET 3.5
• C# 4
• VB.Net
• XML 1
• Oracle 10g/9i
• Tableau 7.x/8.x/9.x
• Crystal Reports 11/10/9/8.5
• Visual source safe 2005
• MS office 2007/2003
• Windows 2003/2008 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• Oracle D2K
• Toad
• Sql and PL/Sql.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS..
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing ForEach Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimensionand more.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Create complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries
• Developed Query for generating drill down and drill through reports in SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Wrote SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds usingSSIS.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
• Involved in table and indexpartitioning for performance and manageability.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future projections.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of MS SQL Server 2008.
• Upgraded the server from MS SQL Server 2005 to MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• 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.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using Erwin Data Modeler.
• Worked Extensively with MS SQL Server Integration Services (SSIS)to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQL Server Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.