Chandan Roy

Contact: 9231975389
Email: [email protected] / [email protected]

PROFESSIONAL PROFILE

 GNIIT and MCP with over 14 years of experience in Database designing, Database programming,
Data migration, Database maintenance, Software Programming, Application Design & Development.
 Having experience of Handling small team and play the role of Technical Project Manager
 Skilled in developing and managing Databases using SQL Server 2014 and above. Successfully
executed Data Transfer/Migration and Software Development Projects.
 Gained efficiency in the analysis, design, development & implementation of Web Applications, Client
Server Applications.
 Proficiency at grasping new technical concepts quickly and utilising the same in a productive manner.
 Team player and Team Leader with strong analytical, organisational and planning skills.

IT SKILL SETS

Database MS SQL Server 2017

ETL Tool SSIS, Pentaho
Cloud Azure (Limited Exposure)
Programming Asp.Net, MVC, C#
Language
Reports Crystal Reports 9, RDLC.
Scripting JavaScript, AJAX, JQuery

PROFESSIONAL QUALIFICATION

Certification: Microsoft Certified Professional in SQL Server 2000.

Diploma Course: GNIIT (3 years programming), Basic Hardware from NIIT.

WORK EXPERIENCE

Company Name Duration Designation

Kaba Express Pvt Feb 2020 to till date Technical Project
Ltd Manager
Bahwan Cybertek July 2019 to Jan 2020 Senior Software
Engineer
Inland World Aug 2008 to July 2019 Senior Database
Logistics Pvt. Ltd. Developer
Decision Aids India Nov 2006 to Aug 2008 Software Developer
(P) Ltd

WORK EXPERIENCE - PROJECTS (1)

Title : KEMS (Kaba Enterprise Management System)

Client's : Kaba Express Pvt. Ltd.
Role : Technical Project Manager, Requirement gathering, Database Planning, Design,
Programming, Data Migration, Data Partition, Azure VM creation etc.
1
Technologies : Sql Sever 2017, AZURE, .NET CORE MVC, RDLC

Description : This is an online ERP Project of Kaba Express Pvt. Ltd. All business
transactions starting from Operational to Accounts Finalization done on this system. The Operational
part consists of Booking, Manifest, THC/Challan preparation, THC/Challan movement, Arrival, Gate Pass
etc. The financial part consist of Money Receipt, Bill Generation, Due Collection, Bill Collection,
THC/Challan Hire payment and accounting entries like Journal, Receipt, Payment, Contra etc.

The output of this system is also enormous. All types of Operational output in form of report, outputs in
DOS and Windows based printing etc. Financial output like Cash and Bank Book, Journal Book, Trail
Balance etc.

This Web based online application is a complete solution for any Transport/Logistic Company from its
scratch operation to its Accounts Finalization.

WORK EXPERIENCE - PROJECTS (2)

Title : EWS (Early Warning System)

Client's : UCO Bank (Bahwan Cybertek)
Role : Database programming, ETL development, Implementation, Client Handling

Technologies: SQL Server 2017, Pentaho

Description : EWS (Early Warning System) is Fintech Credit Monitoring project under Risk
Management. It gives early warning to Bank for its corporate customers loan to prevent it from NPA. It
tracks customer transaction from Finacle and based on RBI guidelines generates alert. Being part of the
team I was deployed in Bank for Database programming, ETL creation/modification, DEV and UAT
Testing, Implementation, part of Client meeting.

WORK EXPERIENCE - PROJECTS (3)

Title : Courier Management System

Client's : Inland Courier Pvt. Ltd.
Role : Planning, Design, Programming of Database.

Technologies
Front-End : ASP.net
Back-End : SQL Server 2008.

Description : CMS designed to manage courier business which consist document booking to
its delivery. Its different modules include Docket booking (Cash/Credit), manifest generation, Air Way
Bill generation, Arrival, Delivery Challan etc. Maintaining of its accounts like Cash receiving, Bill
generation, Credit collection from party, Bill payment to Airways, maintaining outstanding of both
debtors and creditors etc.

WORK EXPERIENCE - PROJECTS (4)

Title : inCore
Client's : Inland World Logistics Pvt. Ltd.
Role : Database Planning, Design, Programming, Data Migration, Data Partition.

Technologies
Front-End : ASP.net
Back-End : SQL Server 2005.

2
Description : This is an online ERP Project of Inland World Logistics Pvt. Ltd. All business
transactions starting from Operational to Accounts Finalization done on this system. The Operational
part consists of Booking, Manifest, THC/Challan preparation, THC/Challan movement, Arrival, Gate Pass
etc. The financial part consist of Money Receipt, Bill Generation, Due Collection, Bill Collection,
THC/Challan Hire payment and accounting entries like Journal, Receipt, Payment, Contra etc.

The output of this system is also enormous. All types of Operational output in form of report, outputs in
DOS and Windows based printing etc. Financial output like Cash and Bank Book, Journal Book, Trail
Balance etc.

This Web based online application is a complete solution for any Transport/Logistic Company from its
scratch operation to its Accounts Finalization.

WORK EXPERIENCE - PROJECTS (5)

Title : Fleet Management System

Client's : Inland World Logistics Pvt. Ltd.
Role : Planning, Design, Programming of Database.

Technologies
Front-End : ASP.net
Back-End : SQL Server 2008.

Description : Fleet Management is designed to maintain the fleets of the company. It

includes fleet purchase, its financing, fleet running tracking, maintenance. It maintain the Trip i.e.
movement of vehicle from one location to another, its costs of running, its profitability, its servicing,
tyre management etc.

WORK EXPERIENCE - PROJECTS (6)

Title : Inventory Management System

Client's : Inland World Logistics Pvt. Ltd.
Role : Planning, Design, Programming of Database.

Technologies
Front-End : ASP.net
Back-End : SQL Server 2005.

Description : Inventory management system is all about managing inventories like

generating purchase order, goods receiving than maintain the stock with distribution of stock to
branches etc. In the same time it also manages the bill credit payment to parties.

WORK EXPERIENCE - PROJECTS (7)

Title : BKB PF
Client's : B K BIRLA (Decision aids India Private Ltd.)
Role : Programming, Database Design and Implementation.

Technologies
Front-End : VB.NET, ASP.NET
Back-End : SQL Server 2000.

Description : It’s of B K BIRLA’s Project. This is to maintain the Provident Fund, Loans, and
Investments of all the members of the different Units of BIRLA Group.
3
WORK EXPERIENCE - PROJECTS (8)

Title : KPurchase
Client's : Kesoram Industries Ltd. (Decision aids India Private Ltd.)
Role : Programming, Database Design, Data Migration and Implementation.

Technologies
Front-End : VB.NET
Back-End : SQL Server 2000.
Description : This project is of Kesoram Industries Limited. It maintains and prepares all
types of Indent, Enquiry, Quotation, Purchase Order and Goods Receipt etc.
The package starts from making Indent to Purchase Order of the Factory.

WORK EXPERIENCE - PROJECTS (9)

Title : KIL FA
Client's : Kesoram Industries Ltd (Decision aids India Private Ltd.)
Role : Planning, Programming, Database Design and Implementation

Technologies

Front-End : VB.NET
Back-End : SQL Server 2000.
Description : This project is of Kesoram Industries Limited for maintaining the Fixed Assets
of the Kesoram Rayon Factory (Kuntighat). This package maintains the
Purchase, Depreciation and Disposal of different types of Assets of the Factory.

WORK EXPERIENCE - PROJECTS (10)

Title : TGMS
Client's : Vishnu Tea, Lotus Tea, Mokalbari Kanoi Tea.
Role : Planning, Programming, Database Design and Implementation.

Technologies
Front-End : VB.NET
Back-End : SQL Server 2000.

Description : The package is all about the Tea Garden Management System, it consist of all
type of Tea Garden related activities. The Package has two parts: a)HO Management and b)GARDEN
Management.

a) HO Management: This package maintain about the monetary transactions like Cash
Voucher, Bank Voucher, Cash Book, Trial Balance etc. It also contain different type of sales like
from preparing Garden involve to Agent Sales and this maintain all things related to Auction
Sale, Agent Sale etc.

b) GARDEN Management: This package is separate from HO Management it consists of four

parts

1. Kamjari: - Kamjari is all about recording daily work of different type of Labour
of the Garden, it also calculate the Fortnightly wages, PF, Ration, Loan etc. And
the final output is Pay book and Salary Slip of the Workers.

4
 2. Finance: - It maintains garden related expenses like Vouchers, Cash Book, trial
balance etc.

WORK EXPERIENCE - PROJECTS (11)

Title : CCo
Client's : Carry Transport Co. (Decision aids India Private Ltd.)
Role : Planning, Programming, Database Design.

Technologies
Front-End : VB.NET
Back-End : SQL Server 2000.

Description : The package is for a Transport Company name Carry Co. which deals with
carrying goods from one location to another. The package maintains the
different types of Lorry Challan issue from the Parent Branch to other branches.
The main thing to maintain is that how much advance a customer is paying and
the due amount. It also deals with the total amount of money reimbursed from
Parent Branch to other Child Branch.

EDUCATINAL QUALIFICATION

COURSE BOARD/UNIVERSITY PASSING Percentage (%)

YEAR
Master of Computer Manipal University 2012 63
Application
Bachelor of University of Calcutta 2006 52
Commerce
Higher Secondary West Bengal Council of Higher 2003 52
Secondary Education
Secondary West Bengal Board of Secondary 2001 66
Examination Education
PERSONAL DETAILS

Date of Birth : 8th Sept 1983.

Father’s Name : Sukumar Roy.

Address : 270 (Old No 204) Bidhanpally, Ground Floor. Garia. Kolkata-700084.

Marital Status : Married.

Language Known : Bengali, Hindi and English.

Nationality : Indian.

Religion : Hindu.

Dated: Chandan Roy