srikanth vinjamoori

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

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.

Client              : Premier Inc, PA                                                         Oct 2015 - Mar 2019

Project Title   : LMS Reporting

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

Environment   : Microsoft SQL Server 2016, T-SQL, DB2, Microsoft BI,SQL Server Integration services, ETL, Windows 10,IIS, Microsoft .Net Framework, Visual Studio 2015/2017, SQL Server Data Tools, SQL Profiler, Visual Studio Team Foundation (TFS), C#,VB.Net, MS Office Suite, Microsoft Visio, PowerShell, GIT Hub, JIRA, Microstrategy Analytical Tool, SQL on Azure

Role & Responsibilities: 

• Converted the legacy sequential SQL job to parallel processing using SSIS and reduced the execution time to 50%
• Migrated on-premises SQL server to Azure cloud
• Converted existing legacy reports to Power BI Reports
• Tuning the SQL Agent job and SSIS packages
• Performance Tuning
• Created various database objects in SQL Server
• Production Support
• Bug fixing raised by QA and Clients
• Troubleshooting and fixed the bugs using c#, VB.Net, ASP.Net etc.