SUNIL KUMAR

Contact No. : 09891544018 Correspondence Address

E-mail: sunilkg_mca@rediffmail.com M -37 Ground Floor, Front Side,
contact.sunilk007@gmail.com J.J Colony, Sri Niwaspuri
sunil007@hotmail.com (Skype id) New Delhi-110065

PROFESSIONAL SUMMARY
 Overall 12 Years of experience in software industry. (5 Yrs. Exp. In .Net Technology).
 Sound knowledge in database design, development and implementation using SQL.
 Enriched with strong analytical, technical, and proactive leadership skills on the strength of complex real-time experiences.
 To be a part of quality environment and to grow professionally by continuous learning while contributing my best level to the
organization.
 Motivated and hardworking individual with the ability and enthusiasm to learn and excel.
 Hard Worker, Quick Learner, Excellent problem-solving abilities.

CAREER OBJECTIVE
 Passionate to take the challenges of greater responsibilities and attain optimum Level of Utilization of my skills through hard
work and dedication.

PROFESSIONAL QUALIFICATION
Master of Computer Application (MCA) From Institute of Management Studies (I.M.S.) Ghaziabad
(U.P. Technical University Lucknow) Year of Passing 2003, with 61%

SOFTWARE SKILLS
Languages/GUI : VB.Net, Visual Basic 6.0, C#, ASP.Net, MVC.
RDBMS/DBMS : MS-SQL Server 2014/2012/2008/2005/2000, MS-Access
Internet Application : HTML, Java Script, CSS, XML, JSON, Bootstrap, JQuery, Entity Framework and LINQ
Operating Systems : Windows XP/2003/2000/98, NT, MS-DOS.
Reporting Tool : Crystal Report (10.0/9.0/8.0), Stimulsoft Reports
Middleware Technologies : ActiveX, COM & DCOM
Configuration Mgt. Tool : Visual Source Safe 6D, TFS
Functional Areas : Supply chain management, School ERP, Insurance Domain, Travel Domain and ERP
Remote Support Tool : GotoAssist, GoToMyPC, Team Viewer, VNC Viewer, Ammyy Admin and AnyDesk
MIS Reporting Tools : MS Excel and MS Word (2010/2007/2003/2000), PDF, and OpenOffice3.4,
King Soft Office, Libre office
Central Reservation System (CRS) : Amadeus Vista (Amadeus Selling Platform) and Amadeus Pro Tempo.

WORK EXPERIENCE
 Currently working with Supplyvalid Pvt. Ltd, Noida Uttar Pradesh.
From 11-Dec-2019 to 02-Jun-2020
Job Profile:
Designation : Software Developer
Role and Responsibility : Analysis, Design and Coding of the Modules, Client Support & Database

 Worked as Technical Analyst with Seagull Publishers Private Limited, Lucknow, Uttar Pradesh.
From 10-May-2018 to 22-Feb-2019
Role and Responsibility : Analysis, Design and Coding of the Modules, Client Support

 Worked as Technical Analyst with NIIT Technologies Ltd, Noida Uttar Pradesh 201301
From 06-Nov-2017 to 28-Mar-2018
Role and Responsibility : Analysis, Design and Coding of the Modules, Client Support

 Worked as Sr. Software Developer with ResBird Technologies Pvt. Ltd, Gurgaon -122002
 From 01-Sep-2013 to 03-Nov-2017
Role and Responsibility : Analysis, Design and Coding of the Modules, Client Support

 Worked as Sr. Software Developer with Amadeus India Pvt. Ltd. New Delhi -110070
From 14-Dec -2006 to 31-Aug -2013
Role and Responsibility : Analysis, Design and Coding of the Modules, Client Support

 Worked as Software Developer with Hot-Biz Systems Pvt. Ltd. New Delhi -110065
From 01-Jul - 2004 to 09-Jun -2006
Role and Responsibility : Analysis, Design and Coding of the Modules, Client Support

PROJECTS DESCRIPTIONS

1. Project Name : GPS Track

Client : In house and others
Environment : Windows 10, MVC, SQL Server 2012, JQuery, Json, Linq and Entity framework.
Role : Design, Coding, Database and Unit Testing
Group Size : 2
Project Details : To automate the Tracking process of running vehicles. This is a solution that will search
the vehicles which are running and register on the portal, to maintain that records (company, branch, Employee, Customer,
route, Device, Vehicle, Route stop, Department, Designation, Position, Customer Branch, Customer Branch Employee and
Customer Branch Supervisor) track all activity regarding Vehicle and Device.

2. Project Name : EdusCol

Client : Green field Public School and others
Environment : Windows 10, ASP.net with C#, SQL Server 2012, JQuery, and Json.
Reporting Tool : Stimulsoft Reporting Tool
Role : Design, Coding, Database and Unit Testing and Maintenance
Group Size : 4
Project Details : This project based on the various Activities that is carried out the school Such as
Student details, Class and section, bus route information and students fees bill generation and bill amount posting in finance
module and maintain all employee’s salary of a school. This project is flexible and generic school automation software based
on client server technology. The current software scope includes Student’s Admission, Fees Collection, Exam, Transport, HR-
Payroll, Accounts modules. The main strength of this Project lies in its reports generation part which are very useful for the
upper management.

3. Project Name : PNR Synchronization and MIS

Client : Amadeus India
Environment : Windows XP, VB.Net, Sql Server 2008
Role : Analysis, Design, Coding, Database and Unit Testing
Group Size : 1
Project Details : This software has two parts.
PNR Process Part – Application has been picked pnr’s from related Queue, the script will be checked the mandatory remarks
in correct format at the PNR. If any problem in the mandatory remarks so pnr has been send to in related rejection queue with
reason for error and reason for save in database, otherwise pnr are process successfully then it’s sent to success queue. This
script runs on 24*7.
MIS Part – User want to see the pnr is not process what reason, again pnr has been checked and again send the pnr in
related queue for the again process.
4. Project Name : Amadeus Profile Extractor
Client : Uni Globe, BCD Travels
Environment : Windows XP, VB.Net, MS-Excel
Role : Analysis, Design, Coding and Unit Testing
Group Size : 1
Project Details : Amadeus Profile Extractor product will be Graphical User Interface based product
designed to export data With Amadeus Profile Exporter, customers can extract full and partial data Company & Corporate
Profile both in an Excel File.
This product extracts all Profiles (Company as well as Traveller) from Amadeus Central System and export the data in the
Excel formats. Travels Counsellor will go to GUI based Script and define the criteria for which he wants to extract the report.

5. Project Name : Ticketed PNR Tracking

Client : Thomas Cook, Carlson, Uniglobe and FCM
Environment : Windows XP, VB.Net, Sql Server 2008
Role : Design, Coding, Database and Unit Testing
Group Size : 1
 Project Details : To automate the search process of ticketed PNRs. This is a solution that will search the
PNRs which are ticketed and Queue them into the queue of the designated Office ID after checking a pre-defined data base.
For some unique indentified corporate (as per the database) the script will perform some entries in CRS and place the PNRs
in the respective queue (Success or failure) as per the database. The application has to be manually triggered.

6. Project Name : DialETKTV2

Client : Amadeus India
Environment : Windows XP, VB.Net, Sql Server 2008
Role : Design, Coding, Database and Unit Testing
Group Size : 1
Project Details : This software has two parts.
Server Application - This application gets request for Electronic Ticket from clients via SMS and generates a Request. Client
get a notification via SMS that request id is generated for E-Ticket.
Client Application - Client gets all pending requests and generates Electronic Ticket for each pending request. Amadeus
issue the PNR’s if registered in Amadeus. All the added requests are processed on CRS. It then sends acknowledge mails
and queue the messages on the CRS to inform the travel agencies about the successful processing of the PNR.
7. Project Name : Amadeus PNR Search
Client : Thomas Cook, Uni Globe
Environment : Windows XP, VB.Net
Reporting Tool : Crystal Reports 9.0
Role : Coding, Design and Unit Testing
Group Size : 1
Project Details : This software sends some entries to a particular date range officeid and Itinerary type
after that pick’s details of ticket from Amadeus Pro Tempo or Amadeus Selling Platform then all details capture after that
generated a crystal report according to user select options.

8. Project Name : Smart ATSR

Client : Uni Globe, Thomas Cook
Environment : Windows XP, VB.Net, MS-Excel
Role : Coding, Design and Unit Testing
Group Size : 1
Project Details : This software sends some entries perform according to client requirement after that
pick’s details of ticket from Amadeus Pro Tempo or Amadeus Selling Platform then all details capture of a particular date
range and officeid after that generated an excel report according to user select options.

9. Project Title : Ticket Expert

Functional Area(s) : Analysis, Design, Development
Environment : Visual basic 6.0, SQL Server 2000, Windows 2000,
VBA (MS Word & MS Excel) (3 Tier Technology)
Team Size : 3 Members
Role : Design, Development & Unit Testing
Client : Sapient
Project Details : This software Check the open PNR in CRS. Then it passes through a Quality check
pertaining to Fare Detail, Validating Carrier etc. After checking all details, it Issues Tickets for Passengers in PNR. MIS is
generated separately for Domestic & International Travelers through Formatted Excel sheets from Front End.

10. Project Title : Amadeus Professional

Client : All Travel Agents in INDIA Uses Amadeus CRS
Functional Area(s) : Analysis, Design and Development
Environment : Visual Basic 6.0, Windows XP, MS-Word & PDF
Group Size : 2
Role : Design, development & Unit Testing
Project Details : This software Check the open PNR in CRS. PNR details are exported to formatted PDF
documents, along with all Logos (Amadeus/Agent/Validating Carrier/IATA). Path auto Configure for Acrobat Reader exe path
and its path update in ini file and generated pdf file save as then send a email to agent through Outlook or MS-Outlook. .

11. Project Title : PQC (PNR Quality Check)

Client : Carlson and UniGlobe
Functional Area(s) : Analysis, Design and Development
Environment : Visual Basic 6.0, SQL-Server2000, Crystal Report
Group Size : 2
Role : Design, development & Unit Testing
 Project Details : This software checks for the accuracy of PNR created by Travel agents on Tempo or
Vista and inform them about all the entries which are missing elements in the selected PNR, and it check the open PNR in
CRS and check open tempo or not, after that check user sign or not sign in tempo.

12. Project Title : Tpro Carlson

Client : Carlson
Functional Area(s) : Analysis, Design and Development
Environment : Visual Basic 6.0, SQL-Server2000
Group Size : 3
Role : Design, development & Unit Testing
Project Details : This software allows to create, maintain, delete client and travel profiles/PNR (Passenger
Name Record) on Tempo and Vista. This Utility picks up the details of existing Traveler and Client Profiles from Amadeus Pro
Tempo (A leading CRS in Indian Subcontinent) and Update the Old profile into new client profile. After that some information
client or traveler move in to current PNR.

13. Project Title : TQC (Ticket Quality Check)

Client : Uni Globe, Thomas Cook
Functional Area(s) : Analysis, Design and Development
Environment : Visual Basic 6.0, SQL-Express 2005 & SQL-Server2008
Group Size : 1
Role : Design, development & Unit Testing
Project Details : The product is being designed to issue an e-ticket after verifying the QC remark in the
PNR. This is basically to maintain a quality service to the customers. The script will identify the mandatory remark in the PNR
before Travel Consultants precede further to issue the tickets. The script will identify “QC passed” remark in the PNR by the
sign-in 1010AP. If the remark is available in the PNR, the script will process the ticketing but if the remark is not present in the
PNR, it will not process the ticketing.

14. Project Name : BSP Admin

Client : Amadeus India
Environment : Windows XP, Visual Basic 6.0, SQL Server 2000
Reporting Tool : Crystal Reports 8.0
Role : Coding, Design and Unit Testing
Group Size : 5
Project Details : This software gets request from clients via SMS, Email and a Web site regarding the
Ticket Quota details for a fortnight, all the received requests are processed on CRS. It then sends acknowledge mails and
queue the messages on the CRS to inform the travel agencies about the successful update of ticket quotas.

15. Project Name : My Ticket Planner

Client : India Market (Uni Globe, Shree Travel, Pearl Travel, TC Travel and Riya Travel),
Lanka Market (Classic Travel and Mackinnons Travels)
Environment : Windows XP, VB.Net, MS-Excel, Open Office, King soft Office
Role : Coding, Design and Unit Testing
Group Size : 1
Project Details : This software sends some entries after that pick’s details of traveler itinerary from
Amadeus Pro Tempo or Amadeus Vista then all details capture after that generated a formatted excel report According to user
added PNR’s or other option user fill the excel sheet in column PNR No. and then attached excel sheet.

16. Project Name : Real Time Quota

Client : Amadeus India
Environment : Windows XP, Visual Basic 6.0, SQL Server 2008
Role : Coding, Design and Unit Testing
Group Size : 1
Project Details : This software gets request from clients and a Web site regarding the Ticket Quota details
for a fortnight, all the received requests are processed on CRS. It then sends acknowledge mails and queue the messages on
the CRS to inform the travel agencies about the successful update of ticket quotas and change quota details according to
user.

17. Project Name : Travel Assistance

Client : All Airline Agent
Environment : Windows XP, Visual Basic 6.0
Reporting Tool : Crystal Reports 8.0, Acrobat Reader
Role : Coding, Design and Unit Testing
Group Size : 1
Project Details : This software sends some entries according to insurance providers such as AIG after
that pick’s insurance details of customers from Amadeus Pro Tempo or Amadeus Vista then displayed a insurance certificates
as well as generated PDF file then its file send to email through Outlook or MS-Outlook or Agent we want print it.
18. Project Name : BCD Profile Creator & MIS
Client : BCD Travels
Environment : Windows XP, VB.Net, MS-Excel
Database : MS-Access
Role : Coding, Design and Unit Testing
Group Size : 1
Project Details : BCD Travels wants an automated process to be designed to create all customer profiles
in Amadeus central system. BCD Travels corporate clients update their information in an excel sheet and the same sheet will
be processed by the automated process in the Amadeus Central system for creating profiles after that we will be check the
MIS in according to search a particular condition.
Amadeus India is a product-based company, so we are simultaneously working on other various products, which is
based on Air Ticket, Hotel, Insurance & car booking. And are of desktop or web-based type.

19. Project Title : ERP (Enterprise Resource Planning)

Software Tools Used : Visual Basic 6.0, SQL Server 2000 and Crystal Reports 8.0
Team Size : 8 Members
Role : Coding, Repoting and Database
Description : This Project has full solution for any industry. It includes modules like Procurement,
Material, Manufacturing, Sales, Finance and Personnel. It fits in all types of industry requirements & minimizes all manual
operations. The complete ERP is divided in different modules such as Merchandising, Material, Purchase, Sales and Finance
etc.
Module wise Implementation is done on client according to its requirements. Customization of the Module is done accordingly
and various MIS reports and User Reports are Developed Accordingly.The Project is based on client server technology. The
main strength of this Project lies in its reports generation part which are very useful for the upper management.

Technical Points of Project: This is a client server-based application using COM (Component Object Model) and DLL
(Dynamic link library) concepts. Visual Basic does not provide any inbuilt Error handler; our company has developed a
function to manage the errors. Active X Controls are also the part of this project like menu buttons. Security aspects consist
form wise security as well as user wise security. To access any form or Report user need authorization from the
administration.
Clients: Graffica Flextronics (Mumbai), Eltek SGS India (Gurgaon), Indeutsch Industries (Noida), Spring well Mattresses
(Delhi, Mumbai, Kolkata), Cat Vision Electronic Pvt. Ltd. (Noida).

20. Project Title : Payroll Management System

Language/GUI : Visual Basic 6.0
Backend : MS-SQL Server 2000
Reporting Tool : Crystal Reports 8.0
Role : Coding and Database
Team size : 5 Members
Duration : Three Months
Description : This Project has full solution far any company or Organization. It is maintaining
database of Employee such as category / department / Grade. It is maintaining salary category and Department wise. And
Define the Salary Structure with flexibility through which every company can define their Allowances and deductions. The
Project is based on client server technology.
The project manages the necessary requirement for payroll processing that includes shifts of employees, holiday in the
company, weakly off in the company, various heads of pay (Earning, Deductions), formula of various heads of pay,
perquisites, manages loan and advance taken by employees in the company, claim given by employee and manages tax
calculation on the salary .After this the monthly salary processing is carried out.
The main strength of this Project lies in its reports generation part which are very useful for the upper management.
Clients : SMEC India Pvt.Ltd, IDP, Kwality Ice cream

21. Project Title : School Management system

Language/GUI : Visual Basic 6.0
Backend : MS-SQL Server 2000
Reporting Tool : Crystal Reports 8.0
Role : Coding, Reporting and Database
Team size : 5 Members
Duration : Three Months
Description : This project based on the various Activities that is carried out the school Such as
Student details, Class and section , bus route information and students fees bill generation and bill amount posting in finance
module and maintain all employees salary of a school. This project is flexible and generic school automation software based
on client server technology. The current software scope includes Student’s Admission, Fees Collection, Exam, Transport, HR-
 Payroll, Accounts modules. The main strength of this Project lies in its reports generation part which are very useful for the
upper management.
Clients : Modern School in (Three branch) Barakhambha Road, Vasant Vihar and Sangam Vihar

OVERALL RESPONSIBILITIES INCURRED

 To analyze and anticipate the whole business requirements through a direct negotiation with the operational-staff who was
manually involved in the business activities followed by closed observations of entire process at the client-side.
 To elicit the software requirements from the real-time business scene and prepare a database design model.
 To develop and implement the operational-database.
 To prepare the functional model and various algorithms to embody the entire business scenario.
 To modularize the development work and assign it among the team members, guiding them on various stages and monitoring
the output.
 To participate in programming part as a member of development team.
 To debug, test and integrate different modules individually and as a whole on the development site.
 Client-Side implementation using a 2-Tier Client/Server based architecture.

ACADEMIC QUALIFICATION
 B. Sc (Math’s, Physics) from D.S.N College, Unnao. (C.S.J.M. University Kanpur)
 Intermediate from Govt. Inter College, Unnao. (U.P. Board)
 High School from Govt. Inter College, Unnao. (U.P. Board)

PERSONNEL DETAILS
Father’s Name : Late Shri Mangal Prasad
Date of Birth : 01 August 1976
Marital Status : Married
Nationality : Indian
Language Known : English, Hindi
Permanent Address : H.No. 234 Hiran Nagar Unnao (U.P.) - 209801
Passport No. : N1887254

STRENGTH
 Hard Working
 Self-confidence
 Work effectively independently or as part of a team.
 Capability to understand and adapt to new environment and technology.
 Optimistic and confident outlook to wards life.

HOBBIES
 Drawing and Interacting with people.

EXPECTED SALARY : Negotiable

Date : (Signature)
Place : ---- Sunil Kumar ----