SUMMARY

• Over 8 years of IT experience as MS - SQL Server/BI Developer, involved in Design, Development and Support of MS SQL Server 2016//2012/2008 R2
• Expertise in MS SQL Server wif Business Intelligence using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good knowledge on SQL Server Analysis Services (SSAS).
• Extensive SQL Development experience in Banking and Healthcare environments wif a strong understanding of data and analytics.
• Proficient Knowledge in dealing wif Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Strong experience in creating T-SQL objects, working wif DDL/DML, Performs most of teh SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Expertise in Extraction, Transforming and Loading (ETL) data using BI/SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities (Data Warehouse, Data mart).
• Experience in providing Logging, Error handling using Event Handler, and Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet.
• Strong T-SQL Query optimization and tuning skills, and experience wif SSIS, SSRS and SSAS.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS)
• Experience in designing teh logical data model and physical data model.
• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Deployment of SSIS Packages and Database components using GIT’s (Pipeline), SVN, TeamCity and Octopus.
• 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.
• Creating teh SQL Agents and running teh jobs directly and through Tidal.
• Ability to handlemultiple tasks,InitiativeandAdaptable.Self-motivated, organized team player wif strong problem solving and analytical skills and total commitment to teh organization goals.
• Effective in working independently and collaboratively in teams also responsible for coordination between Onsite and Offshore Teams in various industries.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2019/2017/2016 , Business Intelligence Development Studio (BIDS), Import & Export (DTS), Query Analyzer, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Databases: MS SQL Server 2016/2012/2008 R2/2008, MS Access

Languages: T-SQL, C# and .NET

Operating Systems: Windows 2000/2003/XP/NT/Vista/2007, Windows 8.0 and Windows 10.0

Application Packages: MS Office 2015/2013/2007 (Word, Excel, Power Point, Access)

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

MS SQL Server/Senior ETL Developer

Responsibilities:

• Worked as a senior ETL developer to send all teh input data to feed teh CareAnalyzer and Score+, which used in teh HEDIS (Healthcare Effectiveness Data and Information Set).
• Worked as an ETL developer and taken care of daily, weekly, and semimonthly Pharmacy data load process from teh vendors.
• Designed, Developed, and tested ETL (Extract, Transformation and Load) strategy to populate teh data from various source systems feeds using SSIS.
• Created DDL, DML scripts, stored procedures, CTE according to teh requirement and designed ad-hoc queries on teh database tables.
• Associated wif entire Software Development Life Cycle (SDLC), analyzing business requirements and understanding teh functional work flow of information from source systems to destination systems.
• Monitored Performance and Optimized SQL Queries for maximum efficiency.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Design and develop SQL procedures, views, functions, and triggers to facilitate easy user interface implementation and to fetch data from different tables by usingjoins.
• Transformation and Load (ETL) packages, loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data into teh tables from text files, excel files and csv files.
• Create recursive jobs in SQL Server Agent to run multiple SSIS packages, SQL procedures and scripts.
• Used SSIS variables, parameters, and expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Monitored and maintained existing production ETL packages to fix issues, bugs to troubleshoot and resolve complex issues and Error Handling in SSIS.
• Monitored teh production jobs (Daily, weekly and Semi-Monthly files into teh destination tables) and fix teh issues/errors.

Environment: MS SQL Server 2016/2012, Visual Studio 2012/2015/2016 , SQL Server Integration Services (SSIS), Visual Basic 6.0/VB script, SQL Profiler, OLAP, OLTP, Performance Point Sever, MS Office 2015, SVN, Tidal, TeamCity, Octopus, GIT’s (Pipeline), TFS.

Confidential, Quincy, MA

MS SQL Server/BI Developer

Responsibilities:

• Monitored Performance and Optimized SQL Queries for maximum efficiency.
• Developed and OptimizedStored Procedures, Views, and User-Defined Functionsfor teh Application.
• Developed Physical data models and createdDMLscripts to create database schema and database objects.
• EmployedServer Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Performed Debugging on theStored proceduresfor teh requirement to handle teh errors
• Different types of SSRS reports were created which including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports as per business requirements.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Performed DBCC checks to ensure teh physical consistency of teh database and objects.
• Implemented transactional replication among different servers to has high availability of teh data.
• Created DDL, DML scripts, stored procedures, CTE according to teh requirement and designed ad-hoc queries on teh database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• ETL development for data warehouse data marts daily refresh and real time reporting, utilizing both SSIS and DTS packages using SQL Server.
• Identified teh Cardinality and teh Relationship between teh Entities and Attributes in teh Data modeling or Designing are accurate to build a Physical data model for an OLTP.
• Created teh packages based on mapping document using SQL Server Integration Services (SSIS).
• Using SSIS, building high performance data integration solutions including Extraction,
• Transformation and Load (ETL) packages, loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Create jobs, Alert and schedule DTS/SSIS Packages and SSRS to generate reports.
• Working wif reporting team in Designing, Developing and Deploying Reports in SSRS.
• Designed and architected Report Layout including both simple and complex report using SSRS.

Environment: MS SQL Server-2014/2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Basic 6.0/VB script, SQL Profiler, Performance Point Sever, MS Office 2015.

Confidential, Lexington, KY

MS SQL Server/ETL Developer

Responsibilities:

• Experience in working wif Business Analyst in order to gather requirements for design and implementation of database.
• Optimized teh performance of queries wif modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP systems to teh Data warehouse.
• Integrated ETL (batch processing) as well as real time processes using web services dat were both subscribed and fed as information into teh database.
• Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into data warehouse using Aggregate, Sort, Multicasting, Lookup, Fuzzy Lookup, Derived Column, Conditional Split to perform Data Scrubbing, including data validation checks during Staging, before loading teh data into teh Data warehouse.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau desktop.
• Experienced in creating jobs, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports wifin SSRS 2012.
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up teh SQL Server Performance.
• Created complex SSAS cubes wif multiple fact measure groups and multiple dimension hierarchies based on teh OLAP Reporting needs.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS.
• Reviewed and developed data models and database designs wif development teams.
• Interacted wif teh Business Admin and gather teh requirements and analyzed them.

Environment: SQL Server 2008/2012, MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, SQL Server Integration Services (SSIS), TFS, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Tableau Desktop, TFS, Visual Studio.

Confidential, Lexington, KY

MS SQL/BI Developer

Responsibilities:

• Gathered functional requirements, Business requirements and wrote teh technical specifications for building teh Global Enterprise Data warehouse.
• Experienced on writing complex queries, performance tuning and optimized SQL queries using T-SQL, SQL Profiler in SQL Server.
• Excellent experience in maintaining Batch Logging, Error Logging wif Event Handlers and Configuring Connection Managers using SSIS 2012.
• Data migration (import & export/BCP) from Text to SQL Server.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and tan from Staging to load data in Database Tables.
• Involved in Query optimization and tuning stored procedures for better performance.
• Executed database backup task, check database integrity, rebuild indexes, update statistics task for maintenance.
• Generated Reports using Global Variables, Expressions and Functions based on teh requirements in SSRS 2012.
• Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for teh Business Users.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Identified and worked wif parameters for parameterized reports in SSRS in SQL Server 2012.
• Experience in Designing and Building teh Dimensions and Facts wif star schema and snowflake schema using SQL Server Analysis Services (SSAS), and developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS 2012.

Environment: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel,MS Access,MSvisual Studio, BIDS,MSPower Point 2012.