Ravi Rai

15960 Fennel Ct., Apple Valley, MN - 55122.

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, Suite#1130,

Bloomington, MN 55431.

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, Suite #1130, Bloomington, MN 55431.

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 system’s installation.

 

Consultant,

Ajilon, 3800 West 80th. St, Suite #1130, Bloomington, MN 55431.

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, country’s 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 North Dakota.

 

Teaching Assistant,

Student Support Services, NDSU, Fargo.

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, Bangalore, India.

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, Bangalore, India.

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, North Dakota State University, Fargo, North Dakota, May 1996

MS Paper: An Embedded SQL Interface for the DESc Database System.”

 

B.E., Computer Science and Engineering, Bangalore University, Bangalore, India, January 1992.

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

 

ˇ        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 Europe. DAKTA has several state of the art scheduling optimization and routing optimization algorithms for a very complex and dynamic transportation & distributing network. Participated in various aspects of project management, design, analysis and implementation of Decision Support module, database integration and testing of the User Interface. Worked as a team member and achieved the following:

ˇ        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 Karanataka State Council for Science and Technology, Bangalore, India.

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