EXPERIENCE SUMMARY

*+ years of progressive work experience in analysis, design, development and management of databases for applications backend databases using SQL Server 2008R2, 2012, 2014 and 2016.

Extensive knowledge and experience with ER Diagram and design of logical and physical data modeling using Erwin, Visio, Toad and draw.io.

Experienced in creating and using Stored Procedure, Views, Triggers, schemas, Complex queries, Common Table Expressions, Cursors, Functions, User-Defined Types and Dynamic SQL.

Expert on installing and configuring MS SQL Server 2008\2008-R2\2012\2016.

Hands on experience in configuring SQL Server Reporting Service, Report manager and Report Server.

Expert on Configuring MS SQL Integration Service Catalogs.

In depth experience in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs).

Sound knowledge of Data marts, Data warehousing, Operational Data Store (ODS), Dimensional Data Modeling, Star and Snow-Flake schema Modeling, Fact and Dimensions Tables using MS Analysis Services.

Hands on experience in configuring Data Flow source and destination connection strings.

Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.

Hands on Experience on SSIS package development, deployment and scheduling.

Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.

Used power BI/ Tableau to create different visualizations from different data sources.

Experienced in Database Optimization using SQL Profiler.

Experienced Creating and Managing Indexes.

Experienced working on Agile Projects with Multiple Sprints cycles.

Experienced using Agile Project management tools like JIRA.

Have hand full of experience in C# and Visual Basic (VB).

Implemented Role Based Security as part of security in Power Bi.

Experienced to translate reporting and analytical needs into technical solutions.

Strong interpersonal & communication skills, competitive analytical, logical, and problem-solving skills, Strong management, administrative and leadership skills to work in team.

Highly motivated, dedicated, well organized, goal oriented and flexible to learn advancements in the IT industry.

TECHNICAL SKILLS AND TECHNOLOGIES

Database and BI Tools: SQL Servers 2008/2008R2/2012/2014/2016 and associated tools such as SQL server Configuration manager, SQL Server Reporting Services Configuration Manager, SQL Server Data Profiler, SQL Server Tuning Advisor, MySQL, Oracle, Tableau, Power BI.

BI Design Tools SQL Server BI Stack (SSRS, SSIS, SSAS), MS Excel Report builder 3.0, Visual Studio 2010 to 2015, Windows Server 2008/2012/2014, MS-Access.

Programming Languages and Environment: C#

Desktop Tools: Microsoft office 365/2013/2010/2007 (Word, Excel, Power Pivot, Outlook, and PowerPoint) to communicate solutions among team and to clients of BI solutions.

PROFESSIONAL EXPERIENCE

SQL/BI Developer Jan 2019 -Present

PNC Financial Services, Pittsburgh, PA

Responsibilities:

Worked closely with SME’s end users/internal customers to understand project/requirement scope.

Strong experience working in an Agile development environment.

Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes.

Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.

Experience in implementing Normalization rules in database development and maintaining Referential Integrity by using Primary Keys and Foreign Keys.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables,user defined table types in codes developed).

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.

Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance, used SQL Profiler, and Query Analyzer to debug, troubleshoot, monitor, and measure SQL statements and stored procedures.

Extracted data from heterogeneous sources and transformed, processed the data using SSIS.

Involved in Designing the Data Warehouse and creating Fact and Dimension tables with Star Schema and Snowflake Schema.

Scheduled SSIS packages for running monthly/weekly/daily feeds from and to various vendors using SQL server Agent.

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations.

Integrated SSIS packages with the windows batch to trigger the SSIS package.

Develop several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS)/Power BI.

Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources.

Use Bulk Insert to load large data into staging table.

Proficient in Testing methodologies, Test Matrices and Trace matrix.

Develop various types of reports like Drill down, Drill through, tabular, matrix and parameterized reports using SQL Server Reporting Services (SSRS).

Used TFS/GitHub for source code management of developed codes/version control.

Migrated SSIS 2008, 2012,2014 version to SSIS 2017 and used custom created DLL for transfer of files using SFTP connection.

Created Alerts/log entries for successfully completed and failed jobs.

Collaborated with network operators, application developers, engineering and DBAs to address production issues and enhance end user experience.

Environment: SQL Server 2012, BIDS, Visual Studio 2010/2013, SSIS, SSRS, SSAS, Windows Server 2012/2014, Power BI.

SQL/MSBI Developer Nov 2016 – Dec 2018

Johns Hopkins Hospital, Baltimore, MD

Responsibilities:

Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.

Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.

Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BULK INSERT etc.

Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.

Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

Deployed analysis projects using SSAS based on data volume, as well as developed of KPI's which helped the Business users for easy understanding.

Documented and delivered Functional Specification Document to the project team by using SQL Server.

Involved in scheduling the reports and setting security for reports.

Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.

Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.

SQL/ETL Developer July 2013 – Oct 2016

Mantad Technology Solutions, Silver Spring, MD

Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly, and quarterly reports.

Checked the SQL Server is online and that still have connectivity with the frontend applications and functionality, making sure a 24/7 availability. Collaborated with multiple application owners addressing various issues.

Implemented and supported Quest spotlight application and the backend SQL database to monitor the overall I/O activity of the SQL server.

Monitored growth of database objects for capacity planning.

Supported multiple high availability technology SQL server 2008R2 clustering (active - active), Log shipping Mirroring between multiple locations on both development and Production environment size over 1TB.

Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012, which includes in-place, side-by-side and standalone migration.

Implemented SQL Server high availability solutions including clustering, replication, log shipping and Always ON

Designed and implemented disaster recovery plan under strict RPO and RTO guidelines.

Successfully implemented ALWAYSON for the new environment and created availability groups for databases.

Successfully migrated databases from SQL Server 2005 to 2008R2/2012, SSIS packages, SSRS reports, multiple database along all database objects like stored procedures, logins (orphaned users and after migration worked with application owner to redirect\point their application to the new migrated server).

Reorganized\rebuild Indexes to meet standards index fragmentation level to keep below 30% so as to improve Query Performance.

Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2012.

EDUCATION and CERTIFICATIONS

Bachelor’s Degree

MCSA SQL Server 2012/2014

CERTIFICATIONS and TRAINING

Querying Microsoft SQL Server 2012/2014

Administering Microsoft SQL Server 2012/2014

Advanced Training in SQL Development, MSBI, Data Visualization

Contact this candidate