Sql Server Software Development

Ravinder Saini

Fort Mill, SC - *****

Phone: 803-***-****

Email: *********@*****.***

LinkedIn: https://www.linkedin.com/in/ravi-saini-02a506b/

Objective:

Seeking a challenging position as a SQL/BI Developer in an environment where my initiatives and creative thinking can be nurtured, valued, and rewarded.

Skills:

•More than 20 years of experience working within an IT sector providing software development, data analysis, data management, project work and requirement gathering.

•Excellent communication, problem solving, and decision-making skills.

•Ability to make constructive recommendations to management and peers.

•Excellent understanding of project methodologies and software development cycle

•Always eager to learn and easily adapt to changes in work environment due to emerging technologies.

Software: MS Visual Studio.Net2000 - 2017, SSIS, SSRS, SSAS, Power BI

RDBMS: MS SQL Server 2005 - 2021, Oracle

Languages: C#.net, Knowledge of Azure Data Factory

Education:

B.Sc. of Computer Science, University of Central Florida, Orlando, FL May 99

Work Experience:

VayaHealth, Charlotte, NC

Aug 2023 – May 2024

Senior Business Intelligence Developer

•Create SSIS packages to read data from various data sources.

•Utilized SQL Server 2019/T-SQL programming in creation and optimization of tables, views, stored procedures, triggers, and user defined functions.

•Support development, maintenance and delivery of SSRS reports using Visual Studio 2019, SQL Server 2021.

•Created GitHub commits, pull requests, and issues to work items by connecting Azure Boards with GitHub repositories.

•Work with Business Partners during the development process.

Equiscript, Charleston, SC Nov 2022 – Feb 2023

Senior SSIS Developer

•The company had used ETL tool called Convergence in the past for all their ETL needs.

•Created SSIS packages for all the ETL packages that were created using Convergence tool.

•Also used KingswaySoft’s SSIS Productivity Pack to connect to some data sources.

•Created Tables and Stored Procedures on SQL Server 2019 to support the SSIS packages.

Curo Health Services, Charlotte, NC Aug 2021 – Sept 2022

Senior SQL Developer

•Support development and maintenance of SSRS reports and deliver the reports using SSIS packages to line of business using Visual Studio 2017, SQL Server 2018

•Create SSIS packages to read data from various data sources.

•Work with Business Partners to create Technical Design Documents from Business Requirements

Truist, Charlotte, NC May 2019 – Aug 2021

Software Engineer II

•Migrated SSIS packages from SQL Server 2008 to Visual Studio 2015 and SQL Server 2018. Modified the queries written in SQL Server2008 to improve Performance when the same query runs in SQL Server2017 as execution plan is different between SQL Server08 and SQL Server18.

•Optimized the query performance so queries run below the stipulated time and made an effort to make the rendering time for the reports to be below 20 seconds.

•Responsible for nightly refresh of the Data Warehouse. The Warehouse sourced data from various Oracle based Insurance Management systems.

•Converted Exsight Insurance Management System to AMS360 Insurance Management System.

Curo Health Services, Charlotte, NC Dec 2018 – May 2019

Senior DW/BI Developer

•Support development and maintenance of SSRS reports and deliver the reports using SSIS packages to line of business using Visual Studio 2015, SQL Server 2016

•Create SSIS packages to read data from various data sources including REST APIs.

•Working on re-designing the existing Data Warehouse

•Work with Business Partners to create Technical Design Documents from Business Requirements

Wells Fargo, Charlotte, NC April 2018 – Dec 2018

Senior SQL Developer

•Support development and maintenance of SSIS packages for client’s DCOE business unit using Visual Studio 2015, SQL Server 2016(T-SQL) including but not limited to DDL, DML, and Stored Procedures. A lot of Stored Procedures included use of Temp Tables, CTE, Recursive CTE, and Table Functions.

•Modifying/Automating existing Dashboard written in VBA to meet’s users’ requirements.

•Creating application using C#.net MVC to upload Metadata from SQL Server DB to user friendly drill through forms.

AvidXchange, Charlotte, NC April 2017 - April 2018

Senior Data Warehouse Developer

•Creating new SSIS packages using Visual Studio 2015 and SQL Server 2016 to Extract, Transform, and Load the Dimension and Fact tables that make up the Warehouse.

•Converted existing Data Warehouse from Postgres SQL to SQL Server

•The process involved re-writing the Postgres SQL to T-SQL including but not limited to DDL, DML, and Stored Procedures. Stored Procedures included use of Temp Tables, CTE, and Table Functions.

•Tuned Performance of slow running queries utilizing Queries by improving the Execution Plan

•Created SQL CLR Stored Procedures using C#.Net where complex logic was involved.

Cardinal Innovations Healthcare, NC Sept 2015 - March 2017

Senior DW / BI Developer

•Worked on migrating about 550 SSIS packages and 3 Cubes from SQL Server 2008 to Visual Studio 2015 and SQL Server 2016. SQL Server 2016 creates a different Execution Plan for queries compared to SQL Server 2008. As a result, had to modify the queries written in SQL Server2008 to improve Performance when the same query runs in SQL Server2016.

•The SSIS packages are being converted into Project Deployment model.

Piedmont Natural Gas Nov 2008 – Aug 2015

Senior BI Developer

•Delivery of architecture / solutions and taking ownership of business requirements, issues, integration to various source applications, development of full life cycle data models using Kimball methodology and innovative business intelligence delivery (SSAS, SSIS, SSRS) to users using Visual Studio 2008 / 2013, SQL Server 2008 / 2014 and Oracle DB server

•Provide training / guidance to current and new associates.

•Designed and developed the CUBE with flexibility to add more Power Plant modules in future.

•Build MDX calculations to compare Actuals, Budgets, Forecast, and other calculations.

•Used tools like dB Forge Studio for Oracle, Golden6 for refining SQL Queries, troubleshooting, and creating DDL for DBAs

•Converted Legacy VB6 Web Application to C# / ASP.Net using Visual Studio2008 and Telerik Rad controls for ASP.NET AJAX Q3 09.

•Attended “Dimensional Modeling in Depth” training at Kimball University in San Francisco, CA in March 2012. Ralph Kimball is the instructor for the course.

Bank of America July 2002 – Oct 2008

Consultant - Apps Programming

•Extensive experience using MS SQL Server2000,2005 including but not limited to DDL, DML, DCL, TCL, Stored Procedures, Jobs, Triggers, DTS / SSIS Packages, Dynamic Queries, Link Servers

•Extensive development experience using MS Visual Studio2005 developing Windows & Web Applications using C#.Net using built-in and third-party controls including AJAX.

•Attended weeklong training on Cognos Report Net 1.1 - Authoring and Modelling

•Built strong working relationships with all component workgroup participants.

•Completed the Peer review report, which documents the recommended changes during the Peer review.

•Supported the deliverables for design throughout the Measure and Analyze stages of the SSP lifecycle to support Six Sigma methodology.

•Primarily responsible for creation of Software Requirement Specification, High Level Design, & Low-Level Design documents

DST Innovis, El Dorado Hills, CA Dec 2000 - July 2002

S/W Engineer

•Converted legacy product functionality from Tandem/Guardian to communicate with Client Applications running on a variety of platforms using XML.

•Managed product code and bug fixes for a team of engineers

•Created extensive documentation of processes and instructions.

•Participated in the entire software development life cycle – requirements, design, development, unit test and change control.

•Conducted code walk through and design meetings.

Unify Corp., Sacramento, CA May 1999 - Nov 2000

Software Porting Engineer

•Built and tested Accell/SQL, Data Server, and eWave on Unix platforms

•Installed and configured Oracle, Sybase, and Informix databases

•Trained new employees in processes and responsibilities.

•Executed manual/auto tests to verify product quality.

•Documented processes and instructions as well as created web site to post them.

Contact this candidate