PROFESSIONAL SUMMARY

With over *+ years of comprehensive experience, I possess a deep understanding of database design, development, administration, and maintenance, particularly with SQL Server 2022/2019/2016/2014/2012 in large-scale environments. I have expert-level skills in creating objects such as tables, views, user-defined data types, functions, and triggers, ensuring data integrity and efficient data manipulation.

My expertise lies in crafting optimized T-SQL queries, implementing indexes, and utilizing DTS for data cleansing and migration.

Excellent Report creation Skills of various types of reports using SSRS, including drill-down, drill-through, summary, and parameterized reports, while ensuring proper formatting.

I am well-versed in enhancing and deploying SSIS packages and maintaining and tuning RDBMS like T-SQL and MS SQL Server. Furthermore, I have hands-on experience in extracting and migrating data from heterogeneous sources such as Excel, MS Access, Oracle, and DB2 to MS SQL Server and Unified Data Warehouse (UDW) or Enterprise Data warehouse, utilizing tools like Import Export Wizard, DTS, SSIS, BCP, and Bulk Insert utilities.

My expertise extends to transforming unstructured data from multiple sources using SSIS transformations, implementing change data capture (CDC) for efficient incremental data loading, and designing dimensions and cubes using SQL Server Analysis Services (SSAS).

In terms of performance optimization, I am proficient in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor. I have a solid understanding of capacity planning, disaster recovery, troubleshooting, and backup and restore procedures.

Throughout my career, I have leveraged third-party tools such as Net Backup, Lite Speed Pervasive ETL, SQL Assistant, ERWIN, Red-Gate, and Spotlight to streamline operations and enhance efficiency.

As an excellent team player and technically proficient individual, I have collaborated effectively with business users, project managers, team leads, and architects, fostering a productive and positive project environment.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin, Visio

ETL Tools: SQL 2022/2019/2016/2014/2012 Integration Services (SSIS)

Database and related tools: MS SQL Server 2022/2019/2016/2014/2012, Oracle 11g, My SQL

BI & Reporting Tools: SQL Server Management Studio, Business Intelligence Development Studio, Tableau, Qlik

Programming: Basic knowledge of Java, Visual Basic

Operating Systems: Windows 2013/2011/2013, XP

Cloud Computing: Microsoft Azure

EDUCATION:

Bachelors’ Degree

PROFESSIONAL EXPERIENCE:

MSBI/SQL Developer

Bright view Senior Living June 2022– Present

Baltimore, MD

Responsibilities:

Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL.

Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

Involved in enhancing and deploying the SSIS Packages from development server to production server.

Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Advisor

Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Designed and developed ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinations

Created Various types of Reports (Table, Chart, List and Matrix report) Designed and Developed Drill down and Drill through reports with KPI (Key Performance Indicator), EPI, drop down menu option using SSRS.

Scheduled Reports for Daily, Weekly, Monthly on various information for various categories and Regions based on business needs using SQL Server Reporting Service (SSRS).

Created and maintained technical documentation using defined technical documentation templates.

Contributed to the creation of solid coding techniques and recommended and reviewed coding standards. Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.

Wrote documentation, data warehouse artifacts and data lineage for ETL tools.

Business Skills/Technical Skills: MS SQL Server 2022/2019/2016/2014/2012 Visual studio (SSAS/SSIS/SSRS), Microsoft Access, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, C#. Net, VB.Net. / Share point, Crystal Reports 8/ 9/10, ADO.NET, ASP.Net, Framework 2.0, MDM, Oracle, DB2, Dashboard by Crystal report, Erwin, MS Access, Qlik.

ETL/SQL /BI Developer

Citibank January 2019 – May 2022

Jacksonville, FL

Roles and Responsibilities:

Performed database backups and restore from Production server to test server as refresh backup as part of testing whether backup is restorable or not.

Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems.

Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging.

Used the SSIS to migrate databases such as Excel files, flat files, and SQL Server database to centralized IT destination.

Created many complex databases code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.

Experience with logical and physical data modelling, data warehousing, data querying languages and data strategy

Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.

Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Coordinated and attended everyday standup/scrum/Agile meetings and weekly Sprint meetings to evaluate completed work.

Designed and developed ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinations

Created and maintained technical documentation using defined technical documentation templates.

Contributed to the creation of solid coding techniques and recommended and reviewed coding standards. Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration, and Disaster Recovery for the data.

Environment: MS SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server2005 Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, MDX, ETL, XML, ASP.Net, and Windows.

SQL Server Developer/SSRS/ DBA

Data Group USA September 2016 – December 2018

Alexandria, VA

Roles and Responsibilities:

Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.

Managed the Bulk Supply of Data from operational system and involved in packaging and presenting to end users to meet the specific management needs.

Performing query plans and making sure every query is using appropriate useful Indexes.

Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.

Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Crosstab, Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).

Developed Ad hoc queries, SQL queries to fill business analyst, Operations Analysts, Financial analyst data requests in Teradata.

Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.

Environment: MS SQL Server 2017/2014, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office

Contact this candidate