Monday , November 28 2022

Sunil Kumar

Logo

Technical Analyst

India

SUNIL KUMAR                                                                                      

 

 
Contact No. : 09891544018                                                                                    Correspondence Address
E-mail:    [email protected]                                                                   E-3499/10 Rajajipuram,

  [email protected]                                                                                                  Lucknow (Uttar Pradesh)

                 [email protected] (Skype id)                                                                                            Pin – 226017

 

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 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                               : School ERP, Insurance Domain, Travel Domain and ERP

   Remote Support Tool                        : GotoAssist, GoToMyPC, Team Viewer, VNC Viewer and 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 Seagull Publishers Private Limited, Lucknow Uttar Pradesh.

It is a part of Kriti group of companies.

From 10-May-2018 to 22-Feb-2019

 

Job Profile:

Designation                                           :  Technical Analyst                                             

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
 

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.

 

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 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.

 

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 send 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. 

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.

 

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.

 

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.

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 send some entries to a particular date range  officeid and Itinerary type after that picks 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.

 

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 send some entries  perform according to client requirement  after that picks 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.

 

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.                

 

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. .

 

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.

 

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.

 

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.

 

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.

 

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 send some entries after that picks 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.

 

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.

 

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 send some entries according to insurance providers such as AIG after that picks 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.

 

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.

 

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 maintain database of Employee such as category / department / Grade. It is maintain 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

 

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) Barakhamba 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 —-

  • Updated 3 years ago

To contact this candidate email [email protected]

Contact using webmail: Gmail / AOL / Yahoo / Outlook