8071 Slater Avenue, Suite 230 Huntington Beach, CA 92647 714-375-5290 (o) 714-375-5293
Jagjit Singh Sikka
Objective
My goal is to obtain
employment as Project manager/Software Engineer
Web developer that will enable me to best utilize my educational
Background and expertise.
Summary:
26 years of experience in IT
industry involving analysis, design, implementation and support of application
software. Experienced in developing Client Server and Web applications using
ASP, Visual Basic, VBScript, HTML, XML, JAVA, JSP, SQL and Oracle.
Education: Ph.D (Engineering)
B Tech(Engineering)
SKILLS:
Languages :
Java,SQL, FORTRAN, PASCAL, COBOL,
BASIC
Operating
systems :
MS-Windows, Windows/NT,DOS
RDBMS :
Oracle, Microsoft Access,
Dbase, FoxPro
Database Connectivity
:
ODBC, JDBC, and ADO
Internet
:
JSP, ASP, HTML, XML,VB Script, JavaScript
Web / Application Servers
:
Java Web Server
GUIs
:
Visual Basic
EXPERIENCE:
Nov
’99 to Dec
2000
Systech Solutions Inc.
Project: Netfins
This Project is developed for Netfins.com which is an portal for retirement planning. This project involved all the aspects of plan design and record keeping along with information building. It is a B2B as well as a B2C site In this project ODBC is used to communicate with Oracle 8.05 database. Vbscript and ASP is used for coding and backend. The portal uses invest link and stock point as other objects to keep the track of transactions..
Environment:
Windows NT, ASP, VBscript, HTML,
XML, and Oracle 8
Responsibilities:
·
Coding ASP and HTML pages as a presentation Layer.
·
Involved in writing front-end validations using VB script.
·
Designed the whole bank end database system and logic for all
retirement plans.
·
Involved in writing stored procedures.
·
Led a team of 5 members for all backend operations
Project: Inventory Management
This Project is developed for Systech Solutions Inc internally for maintaining a complete record of inventory hardware and software of the company. This project is done using java and JSP with database as SQL server. JDBC is used for interaction with database. This project involved all the aspects of plan design and record keeping along with information building.
Environment:
Windows NT, JASP, Java, Servlets, HTML, and SQL
Responsibilities:
·
Coding JASP, JAVA and HTML pages as a presentation Layer.
·
Involved in writing front-end and back end validations using JASP
·
Designed the whole backend database system and logic for all
activities.
·
Involved in writing stored procedures.
Sep’85
to Oct’99
Jaico Computers India
Project:
Octroi tax Management system
Octroi Tax is collected by every city on the item being entered into the city for consumption purposes. The system was developed in Visual FoxPro in networked environment to collect tax on line. It is collected from the truck drivers and varies item wise. The system study was done and coded and fully implemented. The various MIS reports and the collection behavior was done. It was a small data mining and forecast model based study. The various modules of the system predicted the loss of revenue and its behavior with respect to the society. The System worked for 4000 trucks per day movement
Responsibilities:
Environment:
Visual FoxPro and Windows NT
Project:
Telecom Billing and Accounting System
This project was to develop a billing, accounting and Management information system for the telephone department for the state of Punjab. I led the team, which built the complete system design along with coding and running. The state is divided into districts and districts into exchanges. The transactions include the calls generating from a particular exchange. A typical district has about 100 exchanges and a100 thousand subscribers. The daily calls are about 8000 and the billing cycle is 2 months. The system
Included
data collection, capturing, analysis, reconciliation, and then billing. There
were about 200 different reports to be generated for different levels of
management. The payment of bills after distribution was captured and the
accounts ledgers were maintained and audited The total system was designed in
four modules namely Data capturing, billing, information system and accounting.
The Capturing was done in FoxPro, billing in COBOL, information system in PASCAL
and again accounting in FoxPro. This project was run for 6 districts of Punjab
for 6 years before it was successfully implemented into the in house system
which is still running.
Environment:
FoxPro, COBOL,PASCAL ,Windows NT and DOS
Project: Election Commission Identity Card
In this project about 20 million identity cards for voters
were issued. The personal dat was collected and database was made in English and
the local language. Tools using transliteration were used and used with digital
photographs to produce identity cards, The data base used was SQL server and the
languages used were English hindi and Punjabi.
Responsibilities.
·
Writing
Transliteration package
·
Data capturing,
validation and printing
·
Issue of complete
identity card with photo
Environment:
FoxPro, PASCAL and DOS
Project: Group Insurance Scheme
This project involved computation and enrollment of
subscribers. GIS is applicable to the group of personals working together or
having something in common. The project involved system study, coding and final
calculation of premium as a group. This was coded in COBOL using random data
file concept.
Responsibilities.
·
System study and
design
·
Coding and
testing of programs
·
Running and
execution
Environment:
COBOL and DOS
Apart from the above I have headed more than 150 small
projects for Industry, city council, government organizations during my tenure
as president of Jaico Computers before I relocated my self to USA. I had also
been engaged in training in general on computer concepts and specialized
corporate training. I used to design courses for the various public and private
sector undertakings.
Jul
’92 to Oct’99
Jaico Exports India
As the President
of this company I was engaged in managing all the objects of the business. This
unit is involved in manufacturing of automobile filters, and exporting the same
and other engineering goods to Middle East and Europe.
The responsibilities included managing a team for manufacturing, sales,
procurement documentation and international trade. I was involved in selecting
and installation of machinery, building the information system and planning and
implementation of sales plans
Sep'81-
Sep 85
Assistant Professor, College of Engg.
Punjab Agricultural University, India
Project:
I was involved in teaching and applying FORTRAN for research in the areas of Ground water Engineering, Irrigation Engineering, Drainage engineering Ground water movement, Aquifer Pollution, Soil Science, Plant Breeding, Plant Genetics, Plant Pathology, Human behavior, Food technology, Food nutrition and many other areas of statistical, mathematical, forecasting, and optimization modeling. Most of the time it included system study and modeling it into computers and coding in FORTRAN. The system used were HP 1000 with Operating system as CPM/MPM
Responsibilities:
·
Designing various research models
·
Coding and running with data in FORTRAN
·
Teaching Masters and Doctorate Students in FORTRAN programming
·
Data flow diagrams and Planning.
Environment:
FORTRAN, SSP, CPM/MPM system
Feb
1976-Sep 81
Doctorate Fellow
I did research on computer modeling of ground water movement lying between the rivers of Sutlej and Beas. The technique used was of finite element method to solve a partial differential equation with stochastic and probabilistic boundary conditions. Also the parameters of input and output were probabilistic. The language used was FORTRAN, coded and analyzed.
Training: I am trained in
Data warehousing using Microstrategy tools. I also have
Training of 8 weeks in CRM using SIEBEL tools. However I have never
Worked on projects using these two tools.