Vaibhav Singh

PROJECTS

WIPRO

Client - GlaxoSmithKline(GSK) November 2021 – Current

IPM Process Modernization (June 2023 – Current)

IPM is workflow management or scheduling tool currently on on-prem servers developed

within GSK to enable business transformation of data and sending it to different Vendors via

SFTP solution. As part of Journey To Cloud, 2 in house processed were migrated to cloud using

Azure data Factory and Azure Logic app technologies. The cycles are tracked and monitored in

azure sql database which stores meta data about the cycles, their runs and exceptions.

Responsibilities

→Feature developer in AGILE development project

→Bug Fixing

→Individual Contributor

→coordinating with US dev Team and Product owners

Technologies

T-SQL programming, Oracle, Unix shell scripting, Git, Azure SQL database, Azure Logic App,

Azure storage account, Azure data factory, Azure Key Vault

Tools

GitHub desktop, SQL Server Management Studio, Azure data explorer, oracle PL/SQL, JIRA,

POSTMAN.

Features Handled

➔ INMAR daily process migration

➔ XPD weekly process migration

Reltio Queries (November 2021 – Current)

The Reltio Master Data management tool feeds its output into different azure sql database

objects and business required different validation queries to support business decisions.

Responsibilities

→Feature developer in AGILE development project

→Bug Fixing

→Individual Contributor

→coordinating with US dev Team and Product owners

→Scrum master (from past 3 months)

Technologies

T-SQL programming, Node Js, git

Tools

GitHub desktop, SQL Server Management Studio, Azure data explorer, oracle PL/SQL, JIRA,

POSTMAN.

Features Handled

➔ Develop custom queries

➔ Developed Delta report for business to do data validation each quarter involving 200+

columns

➔ Developed custom Node JS program using Reltio Provided APIs to retrieve Reltio Users

and Roles for audit purpose by business team.

Customer Management Tool (November 2021 – Current)

Customer management Tool is a .NET based web application used by data stewards for

viewing Customer Master data and supports workflow process. It is the single source of truth

of Cleansed Customer master data for several downstream systems.

Responsibilities

→Feature developer in AGILE development project

→Bug Fixing

→Individual Contributor

→coordinating with US dev Team and Product owners

→Scrum master (from past 3 months)

Technologies

C#.NET, Azure SQL database, Oracle, JavaScript, HTML, CSS, XML, ASP.NET MVC 2.0, .NET

Framework 4.6, git, ASP.NET WCF, ASP.NET Web service, Jquery

Tools

Microsoft Visual studio 2019, GitHub desktop, SQL Server Management Studio, Azure data

explorer, oracle PL/SQL, JIRA, Team Foundation Server.

Features Handled

➔ Migration of application to IWH azure PAAS

Incentive Compensation (November 2021 - Current)

Incentive Compensation is Microsoft .NET based web application used to determine the compensation of sales representatives where aggregates are developed by tagging different Master data (dimensions) of Product received by upstream systems and published aggregates are used by compensation managers.

Responsibilities

→Feature developer in AGILE development project

→Bug Fixing

Individual Contributor

→coordinating with US dev Team and Product owners

→Scrum master (from past 3 months)

Technologies

VB.NET, Azure SQL database, Oracle, JavaScript, HTML, CSS, XML, Infragistics controls,

ASP.NET web forms, git, Sql bulk Copy

Tools

Microsoft Visual studio 2019, GitHub desktop, SQL Server Management Studio, Azure data explorer, oracle PL/SQL, JIRA, Team Foundation Server.

Features Handled

→Migration of application to IWH azure PAAS environment from On-prem with necessary remediation

→Removed dependency of application on on-prem CDF da