Vibhor Sood

Project working in | India
July 2024-Present

KIK Corp – One of North America’s largest independent manufacturers of consumer products. With major positions in the multi-billion-dollar household and pool categories. KIK partner with a wide range of retailers to bring our large portfolio of brands and products to consumers every day.

Roles and Responsibilities-

• Here we need to perform the Auto carve out process in which only the Auto product should be there, and rest of the products should be discarded from the process.
• Changes multiple DTSX packages in which we applied various filters and remove that tasks which are not required. ·
• Do changes in Store procedure, views and tables in which necessary filters need to be applied for conserver Auto data and discard other ones ·
• Intense Unit testing need to done to make sure no other data other then Auto should be there.

Project working in TCS | India

• The Public Financial Management System (PFMS) is a web-based online software application developed and implemented by the Controller General of Accounts (CGA)
• Department of Expenditure, Ministry of Finance, Government of India
• PFMS started during 2009 with the objective of tracking funds released under all Plan schemes of Government of India, and real time reporting of expenditure at all levels of Program implementation

Roles and Responsibilities -

• Responsible for Analysis, design, development, testing and implementation of various ETL tools and design the reports in SSRS and Power BI
• Created Various DTS Packages to Extract/Transform/Load source data into SQL Server in a highly efficient way, created several valuable reports (DPR, BOOKLET, FM DASHBOARD)
• Developed an automated report subscription process using SSRS and Power BI
• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report)
• Created several interactive dashboards and reports in PowerBI applications
• Responsible for effective communication between the project team and the customer
• We faced the performance challenge in SSIS package because our database is in DMZ domain, so for every request crossing the Firewall
• Given the number of KT's and documenting them as well and was very well recognized by manager and Team Lead
• The Public Financial Management System (PFMS) is a web-based online software application developed and implemented by the Controller General of Accounts (CGA)
• Department of Expenditure, Ministry of Finance, Government of India
• PFMS started during 2009 with the objective of tracking funds released under all Plan schemes of Government of India, and real time reporting of expenditure at all levels of Program implementation

Project working on UHG

UMR – which is the third largest TPA of HealthCare domain

• Created Various DTS Packages to Extract/Transform/Load source data into SQL Server in a highly efficient way, wrote numerous stored procedures to perform data cleaning/loading task, once data is loaded into staging area
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary
• Created several valuable reports (i.e., Portal Utilization, Auditing Reports, Data Load reports by using Tabular data and Charts etc.) for Business users using SQL Reporting Services
• Developed an automated report subscription process using SSRS and Power BI
• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report)
• Created several interactive dashboards and reports in PowerBI applications
• Responsible for effective communication between the project team and the customer
• Received many appreciations from onshore UMR Portal team and got the Star Award at Offshore
• Direct interaction with Onshore Folks in terms of Requirement Gathering, Analysis, Development, Testing and Deployment
• Given the number of KT's and documenting them as well and was very well recognized by manager and Team Lead
• UMR – which is the third largest TPA of HealthCare domain