Lalit Kumar Khanna
[login to view URL]
Personal Details
Present Address: Permanent Address:
A-138, First Floor, Wing No 7,Bk no 13/5
Sector-19, Prem Nagar
Noida (U.P.) - 201301. Dehradun. (U.T.) - 248001
India. India.
Mobile No. 9511-33166747 Ph. [login to view URL]
Date of Birth : 18th Oct 1974
Sex : Male
Marital Status : Single
Summary
Application developer with over 6.5 years of experience in Information Technology and background in working with Visual Basic,ASP, SQL Server, Oracle, Access, Crystal Report , Active Reports plus experience in LAN Administration.
© Exhaustive experience in functional areas of Application development.
© Actively participated in all phases of Applications, projects viz. need / requirement analysis, design, implementation.
© Functional expertise in areas of System Management.
© Possess thorough knowledge of LAN.
© Complete all the given tasks as a programmer or a Project leader.
Educational & Professional Qualification
B.s.c From D.A.V Dehradun
PGDCA From M.C.R.P Bhopal
M.C.A From M.K.U DPS New Delhi
Oracle 8i Certificate Cource From STG Chandigarh
Technical Skills
Operating System Win -2000,NT, 98,95,Dos 6.22,Sco Unix 3.2, Novell 3.X, 4.X
Graphical User Interface Visual Basic, Dev2000
Relational Database Management Oracle ,SQL Server, MS Access
Database Management FoxPro
Reporting Crystal Reports, Crystal Analysis, Crystal Enterprise
Language Turbo-C, Pascal, Basic, C++
Internet ASP, VBscript, JavaScript, FrontPage, HTML, DHTML
Office Tools Microsoft Office, Photoshop, PageMaker
Messaging System Mdeamon[E-Mail Server]
Other Tools Wingate, Win proxy, Remote Admin, Pc anywhere
Software/Projects Developed: -
Employer:ASAP SOLUTION PVT LTD SECTOR-19,NOIDA(IT COMPANY)
(Period 3-Nov-2000 TO Till Date)
Client:Eicher Group(GK-2,NEW DELHI)
Work Assignment:- Create Top Management Reports using Visual Basic ,Sql Server Analysis ,Crystal Reports.
Front End: -Vb6, Back End: -SQL Server, Data Object: - ADO
Reporting: -Crystal Reports 8.5,
Team Members: -1
Role: -System Analyst, Programmer
Responsibilities :-Project Analysis, Design & Implementation
Employer: - VRINDAVAN OVERSEAS SECTOR 2,NOIDA(ISO CERTIFIED EXPORT HOUSE)
(Period 1-MAY-2000 TO 31-OCT-2003)
Client: Vrindavan Overseas
Work Assignment:- Integrated & develop ERP Software.
Project Name :- Export Software/ERP Software
Developed For Vrindavan Overseas(Sector -2, Noida)
Front End: -Vb6, Back End: -SQL Server/Access, Data Object: - ADO
Reporting: -Crystal Reports 8.5,Active Reports
Team Members: -1
Role: -System Analyst, Programmer
Responsibilities :-Project Analysis, Design & Implementation
Project Details
Modules Covered: - 1.) Sampling 2.) Store Dept.3.) Cutting Dept 4.) Production 5.) Unit to Unit Transaction 6.) Dispatch 7. Export documentation
Including Planning
Reporting (Cover all Depts.) 7.Accounting System 8.Billing System 9.Salary system
Employer: - GAC INFOSYS PVT LTD ,MATHURA ROAD, NEW DELHI
(Period 1-DEC-1999 TO 30-APR-2000) AS System Analyst ,Programmer
Company Profile :-A IT company dealing in Software/hardware since 1992. They
have AMC 200 companies.
Project Name :- Trade Software
Developed For Garg Metal (Vishvas Nagar, Delhi)
Front End: -Vb6, Back End: -Ms Access 97,Data, Reporting: -Crystal Reports 8.0
Object: - ADO (Multi-User Env.),
Team Members: -1
Role: -System Analyst, Programmer
Responsibilities: -Project Analysis, Design & Implementation
Project Details
Modules Covered: -1. ) Inventory System
2. ) Sale. & Purchase System
3.) Active Reports
4.) Interest System
Project Name: - Franchisee Management system
Developed For Webcom (Sector 18,Noida)
Front End: -Vb6, Back End: -SQL Server, Data Object: - ADO (Multi-User Env.)
Reporting: -Crystal Reports 7.0
Team Members: -1
Role: -System Analyst, Programmer
Responsibilities: -Project Analysis, Design & Implementation
Project Details
Modules Covered: -1. ) Franchisee Open/close
2. ) Fee System
3.) Franchisee material
4.) Sub-franchisee Reports
Project Name :- Financial System Like Tally
Developed For Bhilwara Group (Sector 1,Noida)
Front End: -Vb6, Back End: -Ms Access 97,Data Object: - ADO
Reporting: -Crystal Reports 7.0
Team Members: -2
Role: -Programmer
Responsibilities :- Design & Implementation
Project Details
Modules Covered: - 1. ) Company-Wise, Group-Wise Information
2.) Balance Sheet, Trial Balance
3.) Voucher-Wise/Party-wise Reports
Project Name :- Payroll System
Developed For Bhilwara Group (Sector 1,Noida)
Front End: -Vb6, Back End: -Ms Access 97,Data Object: - ADO
Reporting: -Crystal Reports 7.0
Team Members: -2
Role: -Programmer
Responsibilities :-Design & Implementation
Project Details
Modules Covered: -1. ) Information System
2.) Payroll Repots
3.) Best GUI
Project Name :- Fee Collection System, Payroll System, Mark sheet System
Developed For K.P.S (Sector 36,Noida)
Front End: -Vb6, Back End: -Ms Access 97,Data Object: - ADO
Reporting: -Crystal Reports 7.0
Team Members: -4
Role: -Programmer
Responsibilities :-Design & Implementation
Project Details
Modules Covered: -1. ) Fee system
2.) Student Information
3.) Result-Marksheet System
Project Name:- MUTI-LEVEL MARKETING
Developed For Mission-India (Rohani,New Delhi)
Front End: -Vb6, Back End: -Ms Access 97,Data Object: - ADO
Reporting: -Crystal Reports 7.0
Role: -System Analyst, Programmer
Responsibilities :-Project Analysis, Design & Implementation
Modules Covered: -1. ) Set Multi-level System[tree System]
2.) Generate Reports from any levels
3.) Best GUI system
Employer: - D.A.A.S ,DEHRADUN
(Period 1-Jun-1997 TO 18-NOV-1999) AS Senior Faculty /Programmer
Company Profile :-A education/Software institute which have BCA,PGDCA,DCA,MCA,MBA courses.
Project Name :- Canteen System
Developed For I.M.A (Dehradun)
Front End: -Vb6, Back End:-ORACLE, Data Object: - ADO
Reporting: -Crystal Reports 7.0
Team Members: -2
Role: -Programmer
Responsibilities :-Design & Implementation
Project Details
Modules Covered: -1. ) Product Information
2.) Product©s Stock
3.)Daily Transactions
Project Name:- Pathology Lab System
Developed For Dr V.P Chopra Pathology Lab (Dehradun)
Front End: -Vb5, Back End: -Ms Access 97,Data Object: - DAO
Reporting: -Crystal Reports 7.0
Team Members: -2 Role: -Programmer
Responsibilities :-Design & Implementation
Project Details
Modules Covered: -1. )Patient Information
2.) Daily Patient Report
3.) Pathology Reports
In FoxPro: -
Project Name:- Color Store
Developed For S.P.L 48(Faridabad)
Project Name:- Trade System:
Developed For K. & Kumar(Chandni Chowk N.Delhi)
Project Name:-Indent System
Developed For Sadhu Gear(Sector 25, Faridabad)
Others Projects
1.Created Dos Commands in 'C'. 2.Banking System in 'FoxPro' & 'C++'. 3.Notepad in Visual Basic.
4.Messaging System in LAN (VB)
Projects Supervised: Acted as a Project Leader/Supervised for the successful Projects such as Computerized Ticketing, Banking System, Inventory System, Payroll etc. To name a few in Various Languages such as VB, Oracle, FoxPro, C, C++ Of the Following Classes at D.A.A.S (Dayanand Academy of Advanced Studies).
1.) P.G.D.C.A
2.) B.C.A
3.) D.C.A
Current Engagements: -
1.Development & Implemented ERP System Of Vrindavan Overseas
2. Pursing .Net Technologies