DHEERAJ KUMAR MEDARI

Motivated and detail-oriented Application Support professional with 2+ years of experience in troubleshooting and supporting enterprise applications. Skilled in MS SQL, MS Office tools, Linux, and Unix environments. Known for efficiently handling L1 and L2 support roles, ensuring seamless user experiences and consistently maintaining high service standards.

Project 1 : CPS (Cargill Plantation System)

Databases

: SQL   Server 2012/2014

Tools Used

: Microsoft   visual studio 2012, SSMS

Project Description:

CPS is a main system to take care of palm plantation and palm oils mill. The Cargill Plantation System is an application of Cargill Company, which is having different modules for different business purposes. CPS application is used more than 500 business users. Overall Business Solution for Plantation Business with End-to-End Operation’s Needs. CPS is used in Indonesia. And this application is having three location servers.

Ø Hindoli

Ø Harpan

Ø Poliplant.

Based on the server region they will be connecting to the appropriate server to access the CPS application

Responsibilities:

• Involved in development of complex database objects like Stored procedures,Functions and Triggers.
• Managing the team and monthly reports generating for the client
• Distributing the tickets to the team
• Providing the regular updates \ status higher management
• Involved in attending the calls with business.
• Involved in attending the CAB meeting.
• Performed deployment in stage environments.
• Production and QA Support

Project 2 :

Project Name : NGC

Role : Programming, Production, and QA support

Environment : SQL SERVER 2005/2008R2, SSIS 2005,2008

Project Description

NGC: NGC is the Next Generation Clubcard system used in Tesco. It consists of 3 modules, Support Console module used at the Store tills used for Coupon, Voucher Issuance and Redemption, Marketing module to run the mailings, generate reports and Business Admin module to create groups with admin actions customized for each group.

Roles & Responsibilities

• Creating new SSIS packages and editing existing SSIS packages
• Involved in coding, Implementing the business logic in SSIS packages, T-SQL,SQL Server programming
• Involved in analysis and solving tickets.
• Complete Production & QA support