Sql Server System

E XPERIENCE

Onionsalad.com Inc.

Las Vegas, NV

Owner, Web Spider/Crawler 1/06- present

Foxpro, MS SQL Server, AJAX Interface, the Google API, C#

The worlds largest, fully searchable, recipe website.

The website is currently down for maintenance. I am rewriting the whole system to utilize

a .NET, C#, SQL Server platform. A snapshot of it can be seen at

http://instawares.webs.com/onionsalad.htm

I wrote an Internet spider that has collected 500,000 food recipes, completely indexed for

search. It is the worlds largest.

It was once thought to be computationally impossible to do because of the difficulty of

consistently finding the title of any random recipe on the web.

A Spanish, French Italian and German version will be available soon.

From sending keywords to Google to the AJAX HTML writes directly to the browser, this

demonstration project uses multiple technologies and disciplines.

Ratings.net

Sacramento, CA

Lead consultant, Web Spider/Crawler 1/08- present

Foxpro 9, HTML, the Google API, Internet Explorer Object

A ratings search engine.

Collected 500,000 individual ratings for this website. Then the system was reversed

engineered (technically documented) so the system could be re-written in C# or Visual

Basic in the .NET platform.

Washington, DC Superior Court

Washington, DC

Lead consultant, Financial accounting system 10/01 – 12/08

MS SQL Server, Various point of sale hardware, FoxPro 7 for Windows

The Court Finance and Remittance System (CFARS) version 1.0

Interface with numerous point of sale electronic equipment. Rewrote and updated the

Superior Court Finance and Remittance System. It was then reversed engineered in an

effort to port it over to a new platform. This system collected all fees and fines for the

court. The system was cross departmental, including probate, criminal, family, traffic,

bankruptcy, probation, child support, restitution and small claims. It was the only single

system that ran across almost all departments of the court. The system was used by all

judges, both in their chambers and all courtrooms.

This was a multiuser application, with hundreds of users at a time. The system also

wrote data to multiple external hardware devices including exotic receipt printers and

cash drawers, making the front end essentially a complete point of sale system.

CarlynDavisCasting.com

Falls Church, Virginia

Lead Consultant, Web master with a back end database 9/99 – ongoing

Foxpro, Foxweb, Various multimedia tools.

Authored a major multimedia based web site.

I Created a web site for a major talent casting company. The site contains thousands of

head shots, audio and video samples. The back end was implemented with a scanner,

audio and video capturing utilities. These were implemented using LEAD Technologies,

the world-leading supplier of imaging development SDKs.

Foxweb runs this Web site.

Government of the District of Columbia

Washington, DC

Principle consultant, Systems integration 11/99 – 9/01

SQL Server, MySQL, Oracle, FoxPro, HTML

Street inventory System

Ported an extensive Clipper based application into SQL Server and converted much of

the system. The system tracked all of the trees, benches, plant boxes, sewer openings,

sidewalks, bus stops and parking meters. These things need to be tracked for

maintenance and replacement purposes.

The system was also technically documented in a very detailed way so the application

could be utilized by other cities and municipalities.

Federal Deposit Insurance Corporation (FDIC)

Washington, DC

Lead consultant, Transaction tracking system 8/99 - 10/99

SQL Server, MS Access, Visual Basic

Ported a massive Visual Basic database back end into Microsoft SQL Server.

This was done because of new security requirements of the federal government.

3M Corporation

Washington, DC

Consultant, Heath data systems 6/96 -6/98

SQL Server, MS Access, FoxPro

Analysis of worldwide government health care data

Analysis of health care data for countries of Yugoslavia, Portugal and Hungary and

others.

Analysis was done in order for these governments to better project health care budgets.

The health care budgets where projected for a period of up to 20 years. The main

problem was that these countries did not have the capacities to collect very detailed

health information on their patience’s. Where as the medical data collected in the US did.

So the foreign data was juxtaposed against the American data collected in Maryland and

Florida.

The State Court System of Montana

Helena, Montana

Lead consultant, Systems integration 7/95 - 6/96

FoxPro 2.6 DOS/Windows, FoxPro 3

CFARS version 1.0

Installation of the Court Finance and Remittance System across the state of Montana.

This system was originally written for the Washington, DC Superior Court. It was then

adopted by the state of Montana, with the DC courts blessing.

Washington, DC Superior Court

Washington, DC

Consultant, Programmer 9/94 – 7/95

FoxPro 2.6 DOS/Windows, FoxPro 3

CFARS version 1.0

Designed and implemented the Superior Court Finance and Remittance System. This

system handles all aspects of the courts funds management activities. I worked for the

court multiple times over a period of 10 years.

See listing above.

NASDAQ

Bethesda, Maryland

Consultant, Programmer 6/94 – 9/94

MS Access, Foxpro

Incentive compensation System

Designed a system to implement nation wide compensation policies.

Martin Marietta Inc.

Rockville, Maryland

Consultant, Database administrator 3/94 – 6/94

FoxPro 3

GSA Mailing list system

Designed a system to handle GSA automated correspondence. Designed procedures to

maintain the GSA’s very large databases.

Washington, DC Superior Court

Washington, DC

Consultant, Programmer 11/91 - 3/94

FoxPro 3

Court Finance and Remittance System (CFARS)

See above

The World Bank

Washington, DC

Consultant, Systems integration 10/90 - 11/91

FoxPro 2.0, FoxPro 2.6

International Finance Division

Designed and developed an international finance data collection and analysis system for

member clients world wide. This was before the Internet. So the systems were installed

on laptops which were flown all over the world to collect member countries financial data.

Office of Secretary of Defense, The Pentagon

Arlington, Virginia

Consultant, Systems integration 10/90 – 11/91

Clipper 7 FoxPro 2.6, Sun Spark Stations

RTS (FoxPro 2.0) Report Tracking System. The report tracking system was developed

because of all the various reports requested by members of congress and the current

administration (The White House).

STS (FoxPro 2.0) Security Tracking System for the Security Division. The security

tracking system tracks all security clearance requests, decisions and expirations. It was

also used to create certificates and badges.

MTS (FoxPro 2.0) Mail Room Tracking System for the Mail Distribution Division. The mail

room tracking system is used to track not only Pentagon based mail but also all mail of

the armed forces worldwide.

I still can’t believe they had me write a system to track all of the security clearances,

even though I didn't, at the time, possess a security clearance.

Jeff Roehl

Los Angeles, CA and Washington, DC

419-***-**** • *******@*****.***

25 Years Technical Experience

I achieved a perfect score on my SAT’s.

Bachelor’s degree, University of Toledo, Ohio.

I have been published recently in the Chicago Tribune, The Wall Street Journal and the

Washington Business Journal.

Willing to travel.

Willing to re-locate anywhere.

Current technologies: Visio, ASP.NET, C#, AJAX interfaces, .NET, WCF, Silver-Light, XML,

HTML, COM Objects, Multimedia creation and tools, Microsoft Visual Studio, MySQL, Oracle,

SQL Server, Sybase, Microsoft Office, Reverse engineering and technical analysis of legacy

FoxPro systems, Cryptology and security expert, Object Oriented Programming OOP, FoxPro

Contact this candidate