Srikanth Vinjamoori

Talent

Raleigh, RaleighMember since March 30, 2022

Hire this person

Send a job offer directly to this candidate

About

12+ years of experience in Microsoft SQL Server/MS BI and Azure

Experience

PROJECT DETAILS:

Client : NC Department of State Treasurer, NC Mar 2019 - Till date

Project Title : ORBIT Employer Reporting

Role : Sr. MS BI/SSIS/SSRS/SQL Server Developer / Lead

Environment : Microsoft SQL Server 2016/2014,T-SQL, Microsoft BI,SQL Server Integration services, ETL, Windows 10,IIS,SQL Server Reporting services, Microsoft Power BI, Microsoft .Net Framework, Visual Studio 2015/2017/2019, SQL Server Data Tools

SQL Profiler, Visual Studio Team Foundation (TFS), C#, VB.Net, MS Office Suite, Microsoft Visio, PowerShell, Azure Data Factory, SQL Data warehouse, Azure Synapse

Role & Responsibilities:

Design and developed packages in SSIS
Redesigned Employer Reporting module and improved execution performance from 6hours to 3 hours
Fine tuned more then 30 stored procs and improved performance
Worked on creating, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors, and Indexes using T-SQL
Created reports using SQL Server Reporting Services (SSRS
analyzed data models, data relationships, and dependencies for greatest optimization.
Monitoring processes and resolve execution issues
Created and Modified SSIS packages using C# code to export and import data from CSV files, Text files and Excel spreadsheet.
Assisted with solving technical problems.
T-SQL coding for creating procedures and other database objects.

Education

Client : Premier Inc, PA Oct 2015 - Mar 2019

Project Title : LMS Reporting