Resume

Sign in

SQL Developer

Location:
Kolkata, West Bengal, India
Posted:
September 25, 2019

Contact this candidate

Resume:

Ishit Nandy

SQL Developer

Passionate and self-motivated

adafvb@r.postjobfree.com +919*********

Kolkata, India 03 March, 1993

linkedin.com/in/ishit-nandy93 facebook.com/ishit.nandy.5 WORK EXPERIENCE

05/2016 – Present

Programmer Analyst

Cognizant Technology Solutions

Kolkata, India

Understanding Scope of the work

Requirement Gathering

Analysis and Coding

EDUCATION

07/2011 – 05/2015

Bachelor of Technology

Biju Pattnaik University of Technology

Bhubaneswar, Odisha

Electronics and

Communication

Engineering

05/2009 – 03/2011

Intermediate

Sri Chaitanya College

Visakhapatnam, Andhra Pradesh

MPC (Maths, Physics and

Chemistry)

05/2008 – 03/2009

Matriculate

S.E.Rly English Medium Mixed Higher

Secondary School

Chakradharpur, Jharkhand

SKILLS

SQL T-SQL Microsoft SQL Server DBMS

Data Analysis Data WareHousing ETL SSIS

Advance Excel COBOL CICS DB2

Mainframe

PROJECTS

GEB (Group Employee Benefits) (08/2017 – Present)

It is an insurance project where we deal with the enrolment of members of different clients in groups and thereafter we manage the proper processing of the claims raised by the members, only after validating the eligibility criterion of the respective member based on the policy with which the enrolment was processed. We mostly work with relational database - MS SQL Server. SKILLS USED - Joins, Temporary Tables, Type Casting, Aggregate Functions, User Defined Scalar Functions, Cursors, Triggers, Stored Procedures, Error Handling, Transactions

UNUM (CI Implementation) (09/2016 – 08/2017)

An insurance project of an US Insurance company which provides benefits for different product lines to its customers. Worked as a team member to enhance the mainframe based application to add a new product line - Critical Illness (CI) SKILLS USED - COBOL, CICS, DB2

HOBBY PROJECTS

Created a business model in MS SQL Server to track the order and sales details of the products

Created tables, established relationships between tables and created stored procedures for different functionalities of the business model Created a timesheet tracker in Excel to track the

average time spent in office for an employee

Used the functions of excel and time properties to efficiently track and report for a week

LANGUAGES

English

Full Professional Proficiency

Hindi

Full Professional Proficiency

Achievements/Tasks

Courses

Courses



Contact this candidate