Bio Data

Specialization: Software Development, Data Processing, Survey Analysis, Networking Management, DBMS, Management Information System (MIS), Executive Information System (EIS), Decisive Information System (DIS), Systems Analysis & Designing, Primitive Study of Projects for computerisation, report preparation, databases planning, Data Flow, Implementation Planning, Management Monitoring, planning & preparing a computerise approach for any application software etc.

Major Projects work completed

• A package of “Library Information System” in COBOL, dBase III Plus, Visual FoxPro, proceeding of this software was published in CSI communications Journal.

• A Package of “Assessment of Performance of Branches at their Controlling Offices in Banks” in dBase III Plus, Proceeding of this software was published in CSI Communications Journal.

• A Project on “Attitude of People towards Family Welfare Programmes” to measure general attitude of the people towards FWP (i.e. to estimate the proportion of the people having favourable attitude towards FWP) and impact of religious faith and practices, income and academic level. Since the survey was conducted within the AMU campus, the population for it consist of teaching, non-teaching and lower subordinate class of all faculties, colleges and schools of the AMU. The data had been compiled on computer by making programs in FORTRAN language and all the techniques of sampling was projected on computer including selection of data by Simple random sampling techniques. Mr. Abdul Aleem, Department of Statistics was the supervisor of this project as it was the part of M.Sc. study.

• Analyse the data of “Aligarh Environment Study Project” funded by the International Institute of Environment & Development, London, U.K. through Centre for Science & Environment, New Delhi and I was solely responsible for development of computer programs for interaction and correlation-ship in living conditions, environmental problems, environmental status, facilities and amenities, financial status and social conditions etc. of Aligarh City for 3024 households surveyed data of 40 wards collected through a questionnaire having more than 200 pieces of information. Prof. R. H. Siddiqi was the Principal Investigator of this project.

• I had developed software for computerisation for M.Sc. Engineering admissions at Z.H.College of Engineering & Technology, AMU. This software is in use for the last 16 years in the Civil Engineering Department. Prof. M. Jamil was the Co-ordinator of M.Sc. Engg. Admissions who encouraged performing M.Tech admissions though computer, later on Prof. R.D. Gupta continues till this session as Co-ordinator and software is being used every year.

• Analyse and handled massive statistical data in connection with a U.G.C. research scheme of which Prof. Mohammed Shafi, Pro-Chancellor, Aligarh Muslim University was the Principal Investigator.

• I have Established CAD Centre in Civil Engineering Department, Aligarh Muslim University from the primitive stage and developed programs of scientific and statistical applications for the use of Engineers in FORTRAN, BASIC & C Languages. This CAD Centre is now fully networked and Internet enabled on all computers through Campus Wide Network of Aligarh Muslim University.

Implemented VSAT Project to Faculty of Engineering & Technology (Very first Networking in AMU), planned network for faculty, prepared network charts and later the concept took in implementation through Wipro, New Delhi. Departments (viz. Applied Chemistry, Applied Physics, Applied Maths, Chemical Engg., Electrial Engg., Electronics Engg., Civil Engg.) of Faculty of Engineering & Technology were networked through UTP Cabling and connectivity for using Internet provided through VSAT (64 Kbps Shared, through ISP NICNET-IPAdvantage Server) and Switch/Routers/RAS installed in Civil Engineering Department. Prof. Aslam Qadeer was the Principal Investigator of the project funded by AICTE, UGC & AMU. After implementation of this project students & staff of Faculty of Engineering took advantage of using Internet freely for about 4 years 24 hrs on Internet ready computers. The facility has now withdrawn from NICSI by University Authority after successfully completed of 4 years when Campus Wide Networking of AMU had in effect with faster connectivity speed.

• Developed Software named “Production Planning and Control”, this was a Mini ERP Concept, this project was the part of my MCA Project but later extended as and when concept arises. This project was developed under the supervision of Dr. Salim Beg, Reader, Department of Electronics Engineering, AMU, Aligarh.

The highlights includes three types of billing (Domestic, Export, Excise), Financial Accounting (Ledgers, Account Balances, trial balance, balance sheet, profit & loss), expenses control, consumable control, manufacturing (Issue of Raw Material, Received items from Job work, movement of items in different process, polishing/finishing, convert to finished goods after assembly and then packing and sale), trading (Sale & Purchase), Machine Management (Purchase, repair, maintenance, Machine history etc.), orders management, Die/Pattern/Fixtures/Original Samples Control and Management etc. Quotations/Proforma Invoice Management, Price List, Catalogue with Items Photograph, The whole concept is integrated and tied up with financial vouchers, inventory/stock, accounts, management monitoring, market analysis, sales analysis, purchase analysis, orders analysis & pending orders, Excise registers (like RG 23 A Part I, RG 23 A Part II, PLA, Manufacturing Register, Register-4 etc.), Sales Tax reports, Sales Registers (UP Sale & Ex UP Sale, export sale), Purchase Registers (UP Purchase & Ex-UP Purchase), Transport & Freight Monitoring, Salary Management and Advance Control, Tax forms reports (like Form 3b, Form C, Form 31, Form H etc.), Raw Material Consumption Analysis, Consumables Analysis, Budget Control, Quotation, Pending C-form reminder letter, Account balance reminder letter, per unit cost of consumable & expenses accounts (individual monitoring), sales day register, sales year register, monthly sale register, average monthly sale, purchase day register, purchase year register, monthly purchase register, average monthly purchase, salary chart, leave register, attendance register, Over Time chart, monthly/yearly several reports/charts of employee for monitoring from different angles, average salary chart, bonus report, advance reports and ledgers, advance balances etc. This software includes EDP, MIS reports, EIS reports, and DIS reports and developed for management control & monitoring, these software includes more than 200 reports/lists in different angles for proper monitoring and management of business. In Export Management Part several documents like Proforma Invoice, Invoice, Packing List, Road Challan, Bill of Exchange, Bank covering letter, Forwarding Letter of Bank, Insurance declaration, Marine Insurance Declaration (Blank fills in the original sheet), Shipping Instruction, Shipping Summary, GSP Certificate (Blank fills in the original sheet), Certificate of Origin, Order Confirmation Letter, LCL Packing List, Bank Realization Certificate etc. were prepared and all possible analysis including sale register, CBM detail, order balances, order ledger, order summary, export expenses, Palate management, ECGC Management, Packing Credit Letter, Post Shipment letter with adjustment, FORM 144 management, DEPB Invoicing, 100s of reports for monitoring & management, Inner Box Steaker/Labels, Outer Box Steaker/Labels, Job Order, Manufacturing Order, Production Packing List, Production requirement, order requirement, are also ready. Initially these software were developed in Visual Basic & Microsoft Access and later it is converted to extended and has been completed in Visual FoxPro. The whole concept is the result of my original thinking and I have solely developed and completed these series of software. This software is somehow completed but there are always chances for improvement as ideas cannot grow in a day or software cannot be completely tested in a day. Work in this software extended keeping in mind that any type of manufacturer or any type of trader can control their whole business by using this concept. There are several new & innovative reports which I have prepared and incorporated in the software and thinking that a company where MIS department is establish, may feel better with the usage of these reports and formats in terms of Export Management, Salary Management, Excise Management, Tax Management, Marketing Management, Tax Forms Management, Human Resource Management/Employee Information & Management, Over Time Management, Sales Management, Purchase Management, Manufacturing Management, Expenses Control & Management, Consumables Control & Management, Advances Management, Raw Material Management, Process/Job work Management etc.

I have worked to develop Software Projects for various disciplines and have analysed the requirement, to meet the user needs. Software project developed by me is for management convenience besides its features of only EDP. I have completed the software to meet Management Information System (MIS), Executive Information System (EIS), and Decisive Information System (DIS). As a Solution provider I always think about solutions and wherever we see we tried to make the computerised management solutions for hectic work being done manually, and tried to make the management software solutions, and ultimately our knowledge is being helpful to students of Computer Science & others in their project Work.

 Restaurant Management Software
 Hotel Management Software
 Export Management Software
 OPD Management Software
 Pathology Reports Management Software
 Diabetes Patient Record & management Software
 Billing System and Management Software
 Excise Billing and Management Software
 Capital Gain Management Software
 Transport Management Software
 Production Planning & Control Software
 HR Management / Salary Management Software
 Cable operator management Software
 ISP Management Software
 Store Management Software
 Machine Management Software
 Trading Management Software
 VAT Management Software
 In-house Production and Management Software
 Financial Accounting Software
 Inventory Control Software
 PCO Management Software
 Courier Service Management Software
 Insurance Cover Note Management Software
 Label Printing Software
 Computerisation of Manufacturing Industry
 Computerisation of Petrol Pump
 Computerisation of GYM
 Computerisation of Tuition/Coaching Centre
 Document/File Manager
 Computerisation of a Petrol Pump
 Library Information System
 Admission Merit List & Reports

Teaching Experience :
• I have taught “Data Analysis” (using C, FORTRAN, BASIC Language, and Statistical Packages. Later the results either obtaining from our own programs or using statistical software transported to Excel/Grapher form Graphical presentation) to M.Tech. (Environmental Engineering) students in the Department of Civil Engineering, Aligarh Muslim University (AMU) for about 3 years. We have prepared students as independent program developer as emphasis given on Logic development (rather than teaching only Language syntax) and later applied logic/knowledge into their own programs.

• I have been teaching a course Computer & Programming (CO-101, CO-191) in B.Tech. since 2006.

Previous Employment:

• Worked in Computer Centre, AMU as Programmer Trainee from 1.6.87 to 30.11.87, was engaged for software development and maintenance, developed a package “Library Information System” during the period.

• Worked in Interface Consultants and Data Processors at Aligarh as Programmer Trainee from 1.12.87 to 19.6.88 was engaged for software development, customer support, developed many business and scientific packages and huge data analysis of Aligarh Municipal Corporation for making PF and Pension of the persons for last 10 years record and many statistical analysis of students doing PhD., M.Phil., M.D. etc.

• Worked in Resource centre, Computer Centre, AMU as Project Fellow on Computer Literacy and Studies in Schools (CLASS) project launched by MHRD, DOE and NCERT from 20.6.88 to 7.9.91, was engaged in the Assistance of Co-ordinator CLASS Project, Teacher’s Training Programme, Preparing and sending reports to NCERT, DOE, MHRD etc., Installation/Maintenance of Computer by CMC Ltd., New Delhi, Software development and maintenance, Provide technical assistance to the teachers of schools, Visit to Schools attached to Resource Centre in Northern U.P. for smooth functioning of computer Lab., Guidance to prepare infrastructure etc., meeting with School Management/Principal/concerned teacher/students before submitting progress report to MHRD, DOE, NCERT, Resource Centre etc.

Educational Qualifications
• Bachelor of Science (B.Sc.) in 1984.
• Diploma in Computer Programming (DCP) in 1985.
• Master of Science (M.Sc.) in Statistics in 1987.
• Post Graduate Diploma in Computer Applications (PGDCA) in 2001.
• Advanced Diploma in Computer Applications (ADCA) in 2004.
• Master in Computer Applications (MCA) in 2004.

Technical Skill Set:
OS : DOS, VAX/VMS, UNIX, Windows 98
Languages : COBOL, BASIC, FORTRAN, Pascal, C, C++
DBMS : dBase III Plus, FOXPRO, Visual FoxPro.
RDBMS : Oracle 9i, SQL, PL/SQL.
Spread Sheet : Lotus 1-2-3, Symphony, Quattro, Excel etc.
Word Processors : Word Star, Chi-writer, Soft word, MSWORD etc.
Statistical : Mstat, Microstat etc.
Web Appl. : HTML

Workshop/Training/Conference attended
• I have participated in corporate training from Digital Equipment (India) Ltd. for administration of DEC ALPHA 3000 Model 300 AXP workstation from 22.8.94 to 25.8.94.
• I have participated workshop on “Multimedia Technologies and Applications” from 5th to 7th Nov. 1997 organised at Bio- informatics Centre, Jawaharlal Nehru University, New Delhi.
• I have participated in National Convention on “Vocationalisation of Computer Education”, Department of Computer Science, AMU from 28th Sep. 1996 to 29th Sept. 1996, and presented a paper “Class Project: Reality Clashes with Expectations”.
• I have participated two weeks Training Course on “Multimedia Technology and Applications” held at the Department of Electronics Engineering, AMU from 19th Dec. 2002 to 31st Dec. 2002.
• I have attended training on ORACLE 9i: SQL from 3rd April 2006 to 7th April 2006 at Centre for Development of Advanced Computing (CDAC), NOIDA.
• I have attended training on ORACLE 9i: PL/SQL from 17th April 2006 to 21st April 2006 at Centre for Development of Advanced Computing (CDAC), NOIDA.
• I have attended training on ORACLE 9i: FORMS from 1st May 2006 to 5th May 2006 at Centre for Development of Advanced Computing (CDAC), NOIDA.

Publications
• Sudhir Bansal, “An Overview of Unix”, CSI Communications, Jan. 92, Vol.16,No. 7.
• Sudhir Bansal, Rajeev K. Mittal, “Role of Computers in Management under subtitle, Assessment of Performance of Branches at their Controlling Offices in Banks”, a package proceeding for computerisation of a part of Regional Office in Banks, CSI Communications, Aug., 1992, Vol. 16, No. 2.
• Sudhir Bansal, “XENIX for Systems Manager”, CSI Communications, Jul. 1995, Vol. 19, No. 1.
• Sudhir Bansal, “Alpha-AXP & OSF/1: A bird’s eye-view”, CSI Communications, Jul. 1995, Vol. 19, No. 1.
• Sudhir Bansal, “Library Information System”, CSI Communications, March 1996, Vol. 19, No. 9.
• Sudhir Bansal, “CLASS Project: Reality Clashes with expectations”, National Convention on Vocationalisation of Computer Education held at Aligarh Muslim University conducted by Department of Computer Science (Venue: Kennedy Hall, AMU).

Articles submitted for publications
• Sudhir Bansal, “Internet”, CSI Communications, Computer Society of India Journal. Accepted
• Sudhir Bansal, “E-mail”, ACECOMS. Accepted
• Sudhir Bansal, “E-commerce”, ACECOMS. Accepted
• Sudhir Bansal, “E-Commerce, Think fast, the electronic economy wait no one “, CSI Communications.
• Sudhir Bansal, “Connecting to Internet in Various ways”, CSI Communications
• Sudhir Bansal, Search Engines & Web Promotion, CSI Communications.

Book Published
“A First Course in Computers and Programming”, published by Alisha Publications, Aligarh. This book is syllabus based for B.Tech. students of all Universities and specially for AMU Students.