SUMMARY:

• Over 6+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008 R2/2008 using SSIS ETL 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, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• 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
• MS office 2007/2003
• Windows 2003/2008 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• Toad
• Sql and PL/Sql.

PROFESSIONAL EXPERIENCE:

Confidential, Monona, Wisconsin

SQL Server Developer

Responsibilities:

• Wrote complex queries using T-SQL to create joins, sub queries, functions and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database 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
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Created mapping tables to find out the missing attributes for the ETL process.
• Created SQL Jobs to schedule SSIS Packages
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Created VB.Net,C# 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 of the data after the insert, update or delete.
• 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.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
• Preparing reports using calculated fields, parameters, calculations, groups, sets and hierarchies in SSRS.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Migrated reports from SSRS to PowerBI.

Tools: and Technologies:MS SQL Server 2014/2016, SSRS, T-SQL, SSIS, Win 2008 Advanced Server, Erwin v8.0, ASP.Net, C#, MS Access 2010

SQL/SSIS/SSRS Developer

Responsibilities:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and 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 in Control 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 queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Developed Query for generating drill down and drill through reports in SSRS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.

Tools: and Technologies: Microsoft SQL Server 2012, T-SQL, SQL SSIS, SSAS, SSRS, SQL Profiler, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

SQL/SSIS/SSRS Developer

Responsibilities:

• Wrote queries using T-SQL to create joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database 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 using 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 of the data after the insert, update or delete.
• Involved in table and index partitioning 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 SSRS that were published the business stake holders for analysis and customization using filters and actions.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future projections.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools: and Technologies:MS SQL Server 2012, SSIS, SSAS,SSRS Oracle11g, Visual Studio 2008, VSS 2005, Erwin 7.3, Windows NT/2003, Microsoft .NET framework 3.5, C#, ASP.NET, XML.

SQL/SSIS Developer

Responsibilities:

• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of MS SQL Server 2008 R2.
• 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.
• Used T-SQL to create stored procedure and executed those procedures into SSIS packages.
• 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.
• Worked on VBA for programming in excel to create new columns.
• 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

Tools: and Technologies:Oracle 8i, Toad, MS SQL Server 2008R2, MS Access 2000, Excel, SQL Profiler, Windows XP, Erwin 7.1, VSS 2005

Confidential, Philadelphia, PA

SQL 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.
• 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.

Tools: and Technologies:MS SQL Server 2008/7.0, Windows Server, Windows NT, Erwin