SUMMARY

• Over 6+ years of in - depth experience in Software Design, database design, development, administration and maintenance of SQL Server 2019/2016/2014 large scale databases.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stacks of BI solutions - SSRS, SSIS with MS SQL 2019/2016/2014 .
• Proficiency in creating diverse types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in writing regulator reports to improve the accuracy, reliability, and efficiency of existing regulatory reports by utilizing data validation techniques to ensure that all generated reports contain accurate.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities,
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Data conversion, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data).
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Worked closely with development and Technical Support team to resolve Visual Basic .Net issues.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.

TECHNICAL SKILLS

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2014/2017/2019

Programming Languages: C#, Visual Basic 6.0. VB.Net, ADO.NET, ASP.NET, T-SQL, PL/SQL, HTML, XML

Tools: DTS, SSIS, SSRS, SSAS, Erwin

DATABASE: MS Access, MS SQL Server 2019/2016/2014, Oracle8i/9i/10g, DB2

Software: MS Office Visio, MS-Project 2000,Dashboard using Crystal Reports Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, IL

SSIS/SSRS/ETL Developer

Responsibilities:

• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Make sure that standards and best practices in database development were followed and maintained.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2015.
• Scheduled and monitored all maintenance activities of SQL Server 2016 including database consistency checks and index defragmentation.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: SQL Server 2019/2016, SSIS, SSRS, Microsoft Office (Word, Excel, Visio), Windows 2010/2017 Server.

Confidential, Louisville, Kentucky

Jr.SQL/SSIS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting 2014
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2019, 2016 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package configure files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.

Environment: MS SQL Server 2019 SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential, West Chester, PA

MS SQL Server Developer / SSIS/SSRS Developer

Responsibilities:

• Developed logical and physical database (using ER-win, Normalization, Dimension Modelling and Enterprise Manager).
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.