Dilip kumar

1. Project: Disa Modernization

Client : DISA

Description:

DISA Global Solutions (DISA) is a leading global provider of workforce screening, compliance, and risk

management services, helping employers with hiring and maintaining a safe, compliant workforce through

drug/alcohol testing, background checks, occupational health, and regulatory support (like DOT) across various

industries like transportation, hospitality, and franchises.

Responsibilities:

• Optimize sql legacy code
• Migrate data from legacy to modernization system using (SSIS, ADF)
• Participate in daily client call to take requirement and provide solution

Environment:

Migration:- SSIS, Azure data factory(ADF)

Database : Ms-sql

Operating System : windows

Project: Fid1

Client : Morgan Stanley

Description:

Fid1 is a project in morgan Stanley which take raw data from various client (bloomberg, Refnitive,

embs, DTCC, FINR) and provide centralized structured model for product maintenance and user.

Responsibilities:

• Responsible for debug the jira ,fix it and deploye the changes on production through TCM
• We use Azile scrum dashboards to deploye the changes on production
• Responsible for creating/updating Autosys job
• Responsible for optimization of store procedure in Sybase.
• Responsible for L3 support to resolve client issue

Environment:

Scripting Language : Perl , Python, shell scrpting

Database : Sybase , Ms-sql

Operating System : Linux

Project: Crmnext

Client : Urban bank

Crmnext is product in acidaes solution, using this product we have generated the tabular and matrix report for urban bank and for employee of the company to keep record of DOJ and DOE according to hr. This product is also used by bank to open new account of credit and debit card.

Responsibilities:

• Taking raw data of bank from client server table and load into crmnext table .
• We need to create a proc of data which we get in crmnext table.
• Then we have to pass this proc in xml to generate the report.
• We use xml in crmnext to show the report on client side.
• Before doploying the proc and xml in production we have to take approval from Db review team.
• After deploye the code in production first we verify it then ask client to check at his end.
• In similar way we generated report for acidaes solution employee.

Environment:

Database : Ms-sql , T-sql

Operating System : Windows 7, windows 10,unix

Other tools : SSRS , CRMNEXT (Reporting tool)

Ms-excel : Dax formula

Project: SCM

Client : Indiabulls

Indiabulls is a stock Market based company. In this company customer wanted a financial report of stock trading so first we migrate all data from oracle to Ms-sql through SSIS packages (ETL) because client data was in oracle and we have to generate the report in Ms-sql. After that we created an API using store procedure which return price and all financial year transacation of selling and purchase the stock. Using Json tool we generate report.

Responsibilities:

• Migrate all data from oracle to Ms-sql
• Create Job in ms-sql for Data migration.
• Create store procedure for API which generate report using json.
• Create View and function according to proc requirement
• Use postman to generate json format for report.

Environment:

Tools : Postman,json

Database : Ms-sql or T-sql,Oracle

Operating System : Windows 7, windows 10

Other tool : Postman, SSRS

Ms-excel : Dax formula

Project: Prepaidcard ,Creditcard

Client : Greensky, wirecard

Description:

In this project there are two product Prepaidcard and Creditcard for website uses. We customize the product

according to requirement of client. With the help of this product we can create new card with name print and

keep record of all transaction perform on that accounts

Responsibilities:

• Responsible for creation of API using DBBIDE
• Responsible for creation ofstore procedure using API
• To debug the issue setup an environment for testing on QA
• Recreate issue on QA
• Fixed issue on QA and then deploye on production using SVN

Environment:

Programing Language :- DBBIDE

Database : Ms-sql , T-sql 2012,2016

Operating System : Windows 7, windows 10