SUMMARY

• MS SQL Server Developer with around 9 years of strong experience in Auditing, Finance and Retail domain.
• Diversified development experience on Database Design, Architect and Development in SQL server 2016/2012/2008 R 2/2008/2005/2000
• Involved in SQL Server Upgrade migration from 2012 to 2016
• Migrated SSIS VS2010 packages to VS2015 versions
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server databases.
• Expert in Creating, Configuring and Fine - tuning MS SQL Server Integration Services (SSIS).
• Experience working with Azure Devops
• Experience working in Azure using CI/CD pipelines.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Created master and child packages, package configurations, auditing, logging and custom error handling in SSIS.
• Expertise in performance tuning of Data Flow Task in SSIS Packages
• Experience in working with various data source like SQL Server, MySQL, XML, Excel, Flat Files and CSV files.
• Worked on change data capture, historical and incremental data.
• Expert in creating indexes- clustered, non-clustered, filtered index, Query Optimization, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team in agile.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experience in creating different type of reports like ad-hoc reports, parameterized reports, drill through report, and drilldown reports by using MS reporting services (SSRS).
• Highly experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2016/2014/2012/2008 R 2/2008/2005.
• Self-learning ability and leadership quality.

TECHNICAL SKILLS

ETL Tools: VS 2017, SQL Server 2016/ 2014/2012/2008 R2/2008/2005- SSIS,SSRS

Database: MS SQL Server2016, 2012, 2008R2, 2008, 7.0, MS-Access 97/2003/2007.

Operating System: Windows 95/98/NT//WIN7, UNIX, DOS, Windows Server 2003

Tools: /Utilities: Enterprise Manager, SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), SSIS, SSRS, Database Tuning Advisor (DTA), MS SQL Profiler, ER win, MS Visio 2005-2013, Microsoft Office, Microsoft Access, Microsoft project.

Architecture: Relational DBMS, OLAP, OLTP, Client-Server Architecture

Web Servers: IIS

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer (SSIS/SQL Server)

Responsibilities:

• Leading Level 3 Support and Development Teams responsible for gathering requirements, design, development, deployment & Support of business applications using scrum methodology, SDLC, CI/CD & ITIL techniques.
• Managing day-to-day operations, ensuring team adhering to support model and SLA commitments are met.
• Implemented 100+ successful deployments using Dev-Ops Model.
• Strong exposure of handing escalations and P1 issues with right stakeholders to fix the issues.
• Actively creating databases/tables and optimising large datasets using SQL Profiler, Tuning Advisor, Indexing, Stored Procedure, joins, CTE’s for data processing during development tasks in OLTP Databases using SQL and SSIS.
• Performing ETL process from different data sources to different destinations on Azure
• Handling day-to-day operations, ensuring the team is adhering to the DevOps model and SLA commitments are met
• Delivering modules as per defined ROM, Sprints, Incident Management, Change Management to complete development & deployment tasks.
• Motivating, mentoring teams, performance management and providing feedback on the development
• Driving continuous improvement into development and support processes
• Conducting Root Cause Analysis (RCA) of escalations
• Accountable for providing technical support to the client & users in case of functionality failure
• Participating in technical discussions to minimize the gap between business requirements & expected delivery

Tools: & Technologies: SQL Server 2016, SQL Server Data Tools, SQL Server Business Intelligence Studio, Visual studio 2017, MS PowerPoint, MS Project, MS Office 2010, Azure Devops

Confidential, NC

Database Engineer (SSIS/SQL Server)

Responsibilities:

• Participated in daily agile scrum meetings to understand business logic for user stories from sprint backlog.
• Developed views, complex stored procedures, CTE's, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experienced working with Azure Devops.
• Monitoring execution plans to enhance the performance of the queries.
• Created complexSQLcodes using Views, temporary tables and stored Procedures.
• Performed tuning of T-SQLprocedures, triggers and other database objects.
• Developed and deployedSSIS packages for ETL fromvarious sourcesto staging and from staging to production usingData Conversion, Derive Column, Script Task, Condition Split, for each loop container, and error handling.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Implemented Slowly Changing DimensionType 1andType2for required Dimensions and participated in performance tuning SSIS package
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Performed ETL mappings using SSIS and MS SQL Server
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables to check metadata entries in test and prod databases.
• Created views for generating reports for tableau reporting.

Tools: & Technologies: SQL Server 2016, SQL Server Data Tools, SQL Server Business Intelligence Studio, Visual studio 2017, MS PowerPoint, MS Project, MS Office 2010, Jira

Confidential, Piscataway, NJ

SQL Developer (SSIS/ SSRS)

Responsibilities:

• Participated in daily agile scrum meetings to understand business logic for user stories from sprint backlog.
• Involved in SQL Server Upgrade migration from 2012 to 2016
• Migrated, tested and deployed SSIS VS2010 packages to VS2015 versions
• Developed indexed views, complex stored procedures, CTE's, triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Monitoring execution plans to enhance the performance of the queries.
• Created complexSQLcodes using Views, temporary tables, triggers and stored Procedures.
• Performed tuning of T-SQLprocedures, triggers and other database objects.
• Developed and deployedSSIS packages for ETL fromvarious sourcesto staging and from staging to production usingData Conversion, Derive Column, Script Task, Condition Split, for each loop container, and error handling.
• Generated Custom ETL scripts using SSIS and develops unit test SSIS load processes for performance check.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Provided Dynamic Configuration, Custom Package Logging, Error handling, and Notification to SSIS template package.
• Createddeployment utilityto deploy SSIS Packages.
• Implemented Slowly Changing DimensionType 1andType2for required Dimensions and participated in performance tuning SSIS package
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Performed ETL mappings using SSIS and MS SQL Server
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables to check metadata entries in test and prod databases.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Generated SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Create Scripts for Data Validation in Production after the process has been deployed.

Tools: & Technologies: SQL Server 2016, SQL Server 2014, SQL Server Data Tools, SQL Server Business Intelligence Studio (SSIS 2014, SSRS 2014), Visual studio 2012/2015, MS PowerPoint, MS Project, MS Office 2010, HP ALM

Confidential, Montvale, NJ

MS SQL Server / SSIS/ SSRS Developer

Responsibilities:

• Participated in daily agile scrum meetings to understand business logic for user stories from sprint backlog.
• Writing Joins and sub-queries for complex queries involving multiple tables from different database.
• Wrote different Validation Scripts to check the accuracy of data.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables,SQLjoins and other T-SQLcode to implement business rules for SSRS reports. Implemented different types of constraints on tables for consistency.
• Wrote complex TSQL queries to get data from different sources and test results with expected results.
• Designing and creating SSIS packages to ETL data from databases.
• To achieve business requirement generated SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• UsedLook up, Pivot, Merge Join, Union all, Derived Columntransformations to manipulate data inSSISpackage data flow.
• Provided Dynamic Configuration, Custom Package Logging, Error handling, and Notification to SSIS template package.
• Createddeployment utilityto deploy SSIS Packages.
• Implemented Slowly Changing DimensionType 1andType2for required Dimensions and participated in performance tuning SSIS package.
• Creating reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly and yearly basis via emails and sending to shared folders.
• Involved in designing and deploying Tabular, Matrix, List and Chart reports with Drill Down, Interactive sort, Dropdown menu option, Parameterized and Sub reports.
• Responsible for designing, developing and deploying Drill through, conditional and dynamic reports.
• Designing, deploying, scheduling and maintaining various SSRS Reports in SQL Server in test, staging and production environments.
• Documenting the project work and process.

Tools: & Technologies: SQL Server 2012, SQL Server Data Tools, SQL Server Business Intelligence Studio (SSIS 2012, SSRS 2012), Visual studio 2012, MS PowerPoint, MS Project, MS Office 2010, HP ALM

Confidential, Harrisburg

SQL Developer

Responsibilities:

• Worked with the Data Warehouse Architect and Technical Architect in design sessions to develop high level solutions architecture for SQL Server Reporting Services (SSRS) solution.
• Create database objects in SQL Server 2008R2 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes
• Responsible in creatingT-SQLscripts consisting of many joins, views, functions and filters into Stored procedures to run concepts
• Used Execution Plan,SQLProfiler and Database Engine Tuning Advisor to optimize queries, fix bugs, and tuning the performance during assurance tests and fix defects raised during testing.
• Generated SSIS Packages to pull data from Oracle and Flat files
• Created SSIS packages with different data sources (SQLServer, CSV, SAP, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts
• Participated in data warehouse design and architecture sessions with the program management team
• Participated in developing the design, development and implementation strategy by working on deliverables such as Database Aggregation Design, Database Logical and Physical Architecture and Process Architecture
• Responsible for delivery of design deliverables including the solutions conceptual design and business process presentations
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS
• Involved in complete SDLC process, which includes requirement gathering, analysis, design, development, Implementation
• Used DBCC utilities to fix data corruption in application databases
• Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.

Tools: & Technologies: SQL Server 2012, SSRS 2012, SSIS 2012, MS Office 2010, Windows Enterprise Server 2000, Windows 7 and Windows Server 2008, Visio 2010, IIS 7.0, Share point