Ph: (952)
953-6349, email: ravi@ravirai.com
Objective:
Seeking part time work or telecommute
assignments.
Technical Skills:
ˇ
Experience
in providing remote or local customer support.
ˇ
Specialization
in developing customized relational databases.
ˇ
Database
application system implementation and administration.
ˇ
Over ten years of technical work experience with
several responsibilities.
ˇ
Excellent in
System Design and Development of Application Software.
ˇ
Comfortable
in learning and efficiently using new tools.
Experience:
Consultant, First Note Inc. Minneapolis, MN |
Apr. 02 Aug '02 [ 5 mths.] |
|
Working as a freelance developer designed, developed a web based business support system that handles scheduling music lessons for teachers and students. The system also keeps track of complex billing and accounting on a daily basis. The user interface screens were developed in Java Server Pages. The requests were handled by Java Servlets using Tomcat4 Web Server. MySql was used as database support.
|
||
Consultant, Ajilon, 3800 West 80th. St, |
Oct. 96 Present [7yrs. 2 mths.] |
|
Currently working as a
programmer/analyst for Minnesota Department of Revenue. Responsibilities include
development of Income Tax Reengineering,
maintaining online and batch programs for the sales
tax and compliance division. Writing and reengineering programs that update
information stored in Sybase tables on a regular basis. Instrumental in implementing
middleware applications between various systems. |
||
Consultant, Ajilon, 3800 West 80th. St, |
Dec. 95 Aug. 96 [9 mths.] |
|
Worked as Oracle Database Administrator
at Opin Systems for Pathways, a decision
support system for health organizations. Responsibilities included maintenance of the
database server on Windows NT and Clients for Delphi developers. Created the database and
wrote loaders to download data from HP 9000 machines. Provided customer support to the
clients during systems installation. |
||
Consultant, Ajilon, 3800 West 80th. St, |
Sep. 95 Nov. 95 [3 mths.] |
|
Worked as a programmer for Northern
Lakes Data Corporation and developed batch scheduler and purge module for SR91, automated
toll collection unit, countrys first fully automated toll-way. The modules schedule
jobs to be run at different times of the year and purge extremely old and unused data from
the INFORMIX database. |
||
Senior Research Assistant, Operations Research
Group, Dept. of Computer Science and
Operations Research, NDSU, Fargo. |
Mar. 93 Aug. 95 [2 yr. 6 mths] |
|
Worked with varied responsibilities on
DAKOTA, for United States Air Forces in Europe (USAFE. DAKOTA is a Client/Server system in a
distributed computing environment. The system performs optimized scheduling and routing
tasks for USAFE mission travels while maintain databases. |
||
Programmer Assistant, Dept. of Computer Science &
Operations Research, NDSU, Fargo. |
May 94 Dec 94 [8 mths.] |
|
Worked as a programmer on
SCHOOLMAPS, for North Dakota Department of Public Instruction (NDDPI). SCHOOLMAPS is a geographical Information and
Decision Support System. The system is designed to evaluate the performance of school bus
routing systems for various school districts in the state of
|
||
Teaching
Assistant, Student Support Services, NDSU,
|
Sep.93 May 95 [1 yr. 9 mths.] |
|
Tutored students in Computer Science
fundamentals, Programming in C/C++ & Basic, Data Structures, Linear Programming,
Calculus (intermediate level), Algebra (all levels) and Trigonometry (all levels). Worked
with students diagnosed with learning disabilities. Consistently attained excellent
ratings in student evaluations. |
||
|
Software
Consultant, Cascade Electronics, |
Sep. 91 Oct. 92 [1 yr. 2 mths.] |
Designed and instructed employees on
courses in Data Structures, C & 8085 AL programming. Developed a BASIC Language
Interpreter in C which parses and interprets statements written in BASIC at run time,
eliminating the compilation step. |
|
Cooperative Traineeship, Tata Consulting Engineers, |
May 89 Apr. 91 [2 yr.] |
Worked as a trainee and application
developer on CAD-PIPE. CAD-PIPE
is a DOS and PC based software for designing Pipeline Layouts in Civil and Construction
Engineering. Designed and implemented the Graphical User Interface and programmed Device
Drivers for NEC, Fujitsu printers and Schlumberger and HP Plotters. |
|
Technical Skills:
Languages |
C/C++, Java, SQL, FORTRAN, Pascal, Bourne/Ksh Shell, Sed, Awk, Perl. |
Hardware |
Sun SPARCstation, DECstation, IBM RS/6000, IBM-PC. |
OS |
AIX, SOLARIS, WIN 95/98/NT/2000, SUN OS, UNIX SYSTEM 5 |
GUIs & TOOLS |
VISUAL C++, TomCat, JCreator, Visual Café, |
DBMS |
Informix (4.1), Oracle (7.1), Sybase 11, Access 7.0, AS/400, MySql. DB2 |
Computer Equipment:
Dell 8100, P4-1.7GHz, 256 MB RAM, 60 GB
Hard drive.
Gateway 2000 P5-133MHz, 128 MB RAM, 8
GB Hard drive.
High Speed Cable Internet (Charter
Communication).
Education:
M.S.,
Computer Science,
MS Paper: An Embedded SQL Interface for the DESc Database System.
B.E., Computer Science and Engineering,
Software project: Device Drivers for Printers and Plotters.
Hardware Project: Microprocessor based Rainfall Measuring
Unit.
PROJECTS:
ˇ
Project (Software Developer)
This project replaces the existing Dos
based System with a state of the art Web based system. The system consists of user
interfaces designed in Java Server Pages that are serviced by Java Servlets invoked by
Tomcat 4 servlet engine. The data is stored in MySQL database. The application handles
variety of music lessons provided by teachers at Students home. It implements the complex
accounting and billing systems for the business on a daily basis. It also handles
absentees, predicts earnings, tracks possible misuse of facilities. It also keeps tracks
of potential students and sets reminders based on date and availability of teachers for a
particular instruments.
OS & TOOLS: WindowsXP/ 2000, , MySQL, Java, Tomcat4.1, JCreator, Ant
ˇ
Music School Web Site (Web Site
Developer)
Developed
web site for Melodee Inc, (now FirstNote.Inc) to bring
the business of music to the web. Developed all the web pages (secure and unsecured)
to receive vistor's information. Special directories were created to facilitate secured
http (https) connections. Wrote Perl script to process the web form entries. The Form data
is saved in secured directories and a brief description of the contents is emailed to the
director of the school. Several Scripts were developed to process and provide statistics
on information received. I was responsible for maintaining the site and information on a
daily basis.
OS & TOOLS: FrontPage, Perl, JCreator, HTML-kit
ˇ
Income Tax Reengineering Project
(Senior Programmer/Analyst)
This project replaces the existing
Mainframe based Income Tax System with a state of the art Web based system. The system is
designed to use CORBA servers for process management and load distribution. Weblogic
Enterprise acts as the backbone of the new Software System that manages the communication
with Web Logic Servers on the Front End and DB2, the underlying database. The data
communication from Income Tax to legacy systems is managed though MQSeries based Bridges
and Sybase Open Server bridges allows data access for Sybase based applications to access
data from Income Tax.
Responsibilities: ˇ
Implemented
a CORBA Service to retrieve data from DB2 Database and send taxpayer details to the
Mainframe based TPR system using MQ Series queues. This XA compliant service is
responsible to control the updates to different servers. ˇ
Developed a
new Sybase Open Server/ CORBA Client that allows existing Sybase based systems to fetch
Income Tax data using Remote Procedure Calls. ˇ
Developed a
java code generator to prepare stub and skeleton files files for C++ CORBA Servers (DBServ
- C++ embedded & Java) ˇ
Implemented
the Fraud rule checking as part of Rules Engine. ˇ
Currently
developing the Enterprise beans to implement the business logic for Tax Order Processing
System.
OS & TOOLS: UNIX/AIX, WINDOWS NT,
Sybase, C, Visual C++, AIX, Weblogic Enterprise, MQSeries, DB2, JAVA, Visual Café,
WebLogic Server, EJB, JCreator.
ˇ
Web Live Hosting Project (Senior
Programmer/Analyst)
This project assists the web site
maintained by the vendor by providing data over the internet as needed by the Web pages.
The system is designed on WebLogic Server and uses EJB architecture to fulfill the
requests. The batch processing includes retrieving encrypted files at vendor's ftp site
and uploading them into the local systems.
Responsibilities: ˇ
Actively
participated in design and development of the entire system. ˇ
Developed
Sybase Stored procedures and queries to access business information from the Sybase and
DB2 Databases. ˇ
Configured
and implemented Gnu Privacy guard to facilitate encryption and decryption of Data when
interacting with remote sites. ˇ
Developed
FTP Client program to download files from a given remote FTP site, decrypt and upload them
to DB2 database or JMS queues.
OS & TOOLS: UNIX/AIX, WINDOWS NT,
Sybase, C/C++, AIX, Weblogic Server, DB2, JAVA, JCreator.
ˇ
Print Engine Server Reengineering
Project (Project Lead)
I worked as a project leader in the
reengineering of Windows Print Engine Software System. Migrated the Win3.1 based software
system to Windows 98. Designed to operate as a stand-alone application, this software
manages the printing of various types of printing requests. It creates a device context
for the appropriate task and the printer before connecting to a printer device over the
network. This system is also capable of Word Printing using DDE. The software makes
appropriate use of Windows SDK and Microsoft Foundation Classes and incorporates 40,000
lines of code.
OS & TOOLS: WINDOWS 98/NT,
Sybase, C, Visual C++, AIX.
ˇ
Middleware Maintenance
ˇ
Systems:
Sales Tax, Payment Processing, Taxpayer Registration, touch-tone, MnCare, Fiduciary,
Partnership, Estate, Small Business & Corp. taxes, Mats, Compliance, Income Tax, Live
Hosting, Electronic Pre-Processing System. ˇ
ˇ
Responsible
for maintaining Server Daemons that bridge message from Sybase to Mainframe using RPC. ˇ
ˇ
Responsible
for maintaining the Sybase Open Servers that allow users make remote procedure calls to
perform complex database queries or run Unix based processes. ˇ
ˇ
Migrated dos
based application program Interfaces in C to Windows for allowing non- Sql compliant
systems (FoxPro-Dos) to interact with Sybase. ˇ
ˇ
Assisting
Computer Operations during Systems Problem resolution ˇ
ˇ
Client/Server
Programming using sockets to provide Interface to TouchTone system. Later Migrated this
application to Windows NT based Interactive Voice Response System. ˇ
ˇ
Developed
batch programs to manage & extract data for auxiliary systems such as IRS, State
Legislative audit, Taxpayer Assistance and Refunds.
OS & TOOLS: UNIX/AIX, WINDOWS NT,
Sybase, C, Visual C++, AIX, Weblogic Enterprise, MQSeries, DB2, JAVA, Visual Café.
ˇ
Analytic Pathways
A client server system that enables
managed care organizations to improve network quality and understand and manage health
care costs, while building credibility and acceptance with providers. The system features
clear, concise profiles for PCPs, specialists and facilities with compelling graphics and
easily understood summary data for health care organizations. Methods developed by
physician informaticists and managed care experts guide the user from high level summary
to detail data. User friendly ad hoc analysis can be performed with point and click ease.
OS & TOOLS: ORACLE 7.1, Windows
NT 3.51, DOS, C,
ˇ
SR91
An Automated toll collection facility
that allows vehicles to use the toll road without stopping to pay toll charges. Suitable
hardware mechanism identifies the vehicle and transmits the information back to the
service center where its toll charges are entered into the centralized database. Developed
a batch scheduler,
which executes jobs in batches during off peak hours. It checks for inter-dependency
between jobs before executing them. Also developed a purge
module that deletes extremely old and unused
records from the database on a quarterly basis.
OS & TOOLS: Informix, Unix, C.
ˇ
ESQL/C Interface to DESc
A preprocessor
parses SQL statements and produces C compatible code for DESc (Database Engine
for Scheduling). Developed a grammar and
implemented the Syntax Checker and Code generator. Written in C on a SPARCstation, the
preprocessor is portable to other Operating Systems. The ESQL Interface now serves as
another layer in DAKOTA whereby database access functions to DESc can now be written in
ESQL/C. Tested with over 22 KLOC.
OS & TOOLS: UNIX, C, LEX, YACC
(BISON), xxgdb.
ˇ
DAKOTA
A client/server based system that
facilitates mission routing, resource allocation and scheduling tasks for United States
Air Force in
ˇ
Designed and
developed the system database and associated set of queries under INFORMIX.
ˇ
Enhanced the
functionality of DESc and investigated its reliability and portability.
ˇ
Converted
INFORMIX ESQL/C code to DESc library routines (15KLOC).
ˇ
Designed
SchedGen algorithm, a Decision
Support module that provides optimal solution for the schedules. Considered different
types of ordering. Likes the scheduler to the lp
solver and evaluated its performance.
ˇ
Developed
Hyper Help, on-line help utility for the system.
ˇ
Performed
elementary system administrative tasks, WWW home page, documented features and prepared
User Manual.
ˇ
Also
involved in re-engineering DAKOTA under MS-Windows using Power Builder, WATCOM-SQL.
ˇ
Designed the
framework for interactive SQL support.
OS & TOOLS: UNIX, Motif, lp_solve, LOQO, C, INFORMIX, DESc, dbx,
HTML.
ˇ
SCHOOLMAPS
A Geographical Decision Support
Software (GDSS) for the North Dakota Department of Public Instruction (NDDPI). For this
computerized school district mapping application, implemented an algorithm that computes
the relative efficiency of each school district. Investigated the possibility of
re-engineering the system under MS-Windows and developed a top level menu using BORLAND
C++.
OS & TOOLS: MS-DOS, C, lp_solve, BORLAND C++, MS-Windows, TEGL-C.
ˇ
Device Drivers
Designed the software for NEC P5 Pinwriter and Fujitsu DL 3300/3400 series 24-pin dot matrix
printers and Schlumberger series 18 pen plotters
and Hewlwtt-Packard graphics plotters. Implemented device control for primitives used for
printer-head and plotter-carousel movement and control while operating them in graphics mode. This software was developed for
Tata Consulting Engineers, Bangalore, India.
OS & TOOLS: MS-DOS, C.
ˇ
Microprocessor Based Rain Gauge
Intel 8085 based Rain Gauge with
RS-232C based Communication facility for continuous data sampling. An electrically
operated device, with a battery backup, it is capable of working uninterrupted and
unsupervised for 50 days. This project was developed for Karnataka State Council for
Science and Technology, Bangalore, India.
OS & TOOLS: INTEL 8085.
ˇ
Micro-Database in C
A mini project that implements basic database functions using C. Implemented hashed index scheme for data retrieval. This project was done in partial fulfillment of a certificate course in UNIX & C. at National Institute of Information Technology, Bangalore, India.
OS & TOOLS: UNIX, C.
Awards and Scholarships
ˇ Graduate Research Assistantship at Dept. of Computer Science and Operations Research, NDSU Fargo.
ˇ
Student Research grant to
develop Rainfall Measuring Unit by
ˇ Awarded first place in Inter University Technical Contest at Coimbatore chapter of IEEE, India. Presented paper Microprocessor based rainfall measurement unit.
ˇ Certificate of excellence on attaining the first place in UNIX & C course at National Institute of Information Technology, Bangalore, India.