John Raleigh
139 Woodland Road
Hampton, NH 03842
603-926-6611
jraleigh@jraleigh.net

Access database programmer Access database programmer certified

Consultant Available...Call or EMail now...



.NET, ASP.NET C#, VB.NET

Silverlight 4 Microsoft Silverlight

Microsoft Silverlight is a powerful development platform for creating engaging, interactive user experiences for Web, desktop, and mobile applications when online or offline. It is a free plug-in powered by the .NET framework that is compatible across multiple browsers, devices and operating systems to bring a new level of interactivity wherever the Web works. With support for advanced data integration, multithreading, HD video using IIS Smooth Streaming, and built in content protection, Silverlight enables online and offline applications for a broad range of business and consumer scenarios.

Silverlight enables Web-based applications to deliver the business functionality users demand with a modern, efficient UI while securely interacting with desktop files, devices, data and applications such as Microsoft Office.

C#

A brand new fully object-oriented language, C# is the predominant choice among Microsoft .NET programmers. It is very easy for a VB6 programmer to pick up the few syntactic differences and reach a high state of productivity using C#. Call me a nerd, but I sometimes do a small job, say a well-defined class in VB.net and time permitting, translate it into C# just for fun. All the power of the .NET Framework class library is available and the calls are identical between the two languages. It is very significant that Microsoft considers C# to be its internal developmental language, replacing C++ in all their new products including Windows 7 and Office 2010.

Visual Basic.Net

Except for IT historians and nostalgic trivia geeks, probably no one cares much anymore, but BASIC is an acronym that stands for Beginners' All-purpose Symbolic Instruction Code.

This programming language actually got its start on the campus of Dartmouth College in my home state of New Hampshire in 1964. Professor John Kemeny, along fellow Dartmouth mathematician Tom Kurtz created the first version known as Dartmouth Basic. In the late 70's Microsoft picked up on it and it was included in all editions of DOS. I still have an early issue of BYTE magazine with a Micro-soft ad for Basic, promising that it "...comes with 8 commands!"

It was easy to get simple things going. Many programmers got their start by making some trivial "Hello World" programs with a freebie that came with all editions of DOS called Basica. Then, with the same version, went on to create more complex and practical business programs. Some of these programmers stuck with the language through True Basic, CBasic, Apple Basic, Quick Basic, VB 1 through 6 and now Visual Basic.NET.

As an advanced Visual Basic programmer, I easily migrated to VB.NET and I have found that what was started on the Dartmouth campus has evolved into a powerful object oriented platorm to work from. I use it especially in client/server projects against serious databases such as SQL Server and Oracle. It also works fine as a front end to an Access database for smaller departmental jobs. The current .NET 2.0 framework is exceptionally productive where Rapid Application Development (RAD) is the norm.

I stay heavily involved in the DotNet environment, either as a programmer, attendee at technical events or as a presenter.

Specific tasks where I used Visual Basic are...

  • Link business systems in different formats (Excel, Oracle, ascii, .dbf, etc.)
  • Increase shared access to enterprise data
  • Incorporate a wide range of data sources
  • Improve data availability across a network
  • Analyze information in many powerful new ways

As a C#, VB.NET, VB 6, Access and SQL Server database programmer, I am a regular member and occasional presenter at the C#, Visual Basic.NET, and Boston DotNet dotnet Programmer nh Developer's groups that meet in Manchester, NH and at Microsoft's Waltham offices. I read (analytically) several current journals, visit technical websites, attend many Microsoft sponsored technical events, and take advantage of the wide variety of developer support for Microsoft Access .
Abstracts of my major projects follow.

Critical Care Systems,
ASP.NET 2.0, C#, SQL Server 2005, XSLT, CLR Integration
Contact: Scott Koskela 603-888-1500
Dec 2006 - Now

Critical Care Systems, headquartered in Nashua, NH operates 50 US branches that provide specialty infusion therapies in alternate-site settings such as the patient's home or in an ambulatory infusion suite. As a team member, The firm created an initiative in .NET 2.0 technologies to provide support field personnel such as nurses gather formalized data on patient encounters and events. The system is 100MB in 5000+ files. I added new modules to the program, using ASP.NET, ADO.NET C#, XML, XSLT, AJAX, Javascript, and CLR Integration.
We used many of the server controls that come with .NET 2.0 such as FormView, MultiView, TreeView, and many Object DataSource controls. We used an in-house utility fondly known as the Class Generator. This takes some minimal information from the developer then looks at the data store on SQL Server and generates all the Data Access layer code (ISUD) for a unique class for the particular module. Big time saver. We also enhanced the project with third party controls from the Telerik ASP.NET UI Suite. Another of my contributions was using SQL Server Reporting Services to produce detailed reports based on sometimes complex SQL queries. An add-in that helped with the SQL coding was RedGate's SQL Refactor. As an aside, I made a presentation of this utility to the DotNet Developer's Group at Microsoft's Boston Headquarters in January, 2006.

INETA, (International)
C# Module
Contact: Pat Tormey 603-498-9822
Sep 2006

The International .NET Association (INETA) provides structured, peer-based organizational, educational, and promotional support to the growing worldwide community of Microsoft® .NET user groups. INETA gets a lot of support from third party vendors as well as book publishers who sponsor meetings and supply programmer swag (T shirts, pizzas, and Coke. One large publisher wanted to reward attendees with free copies of technical books but needed a way to track who deserved the gift. For example one for the speaker plus an additional book to a door prize winner. The usual database storage was out of the question, so I created a C# class that did the job of capturing several fields of information, serializing that data to a small diskfile, returning a token that allowed retrieval and decompression (deserialization) of the readable info later when it came time to ship the book.

ProTracker Software, Hampton, NH
C#, Visual Basic.NET ASP.NET Programmer and Analyst
Contact: Warren Mackensen 603-926-8085
Jul 2004 - Current

This firm develops specialized software named ProTracker that it markets nationwide to Certified Financial Planning (CFP) firms. The owner, Warren has an excellent reputation, being a recognized "guru" and a frequent speaker on the CFP symposium circuit. I collaborated with a team in the Midwest on the extensive (60-80) page eCommerce site that markets the software. This was done in the .NET Framework using C#, Visual Basic .NET and ASP.NET. This included downloading data from a web service, working with common dotnet server controls, linking to the data on a remote SQL Server, and plenty of ASP.NET and HTML coding. I also worked for Warren on a large Access program that manages his internal database issues.

PAX World Funds, Portsmouth, NH
Visual Basic/Access Database Programmer
Contact: Molly Mahoney 800-767-1729 Ext 19
Jun 2006 - Aug 2006 and
Jul 2003 - Dec 2003

This major mutual fund company hired me to finish the work started by a previous Access database programmer. The program tracks commissions owed to brokers all across the country on all kinds of mutual fund transactions. A quarterly import of data is required and I automated this to make life easy for the administrator (Michelle). I later took on Access projects in several other departments including a critical one, Social Screening that is the core of the firm's specialty. PAX continues to use me for general database support.

UNITIL Corp, Hampton, NH
Visual Basic/Access Database Programmer and Analyst
Contact: Cindy Carroll 603-773-6532
May 2004 - Jun 2006

Unitil Corporation is a public utility holding company supplying gas and electric services. I took up where a previous programmer left off in a complex Access program This is designed to track the monetary benefits of users who voluntarily upgrade their residential or commercial energy equipment. This program handles frequent vendor data imports in a wide variety of formats, from ascii (.txt), Access (.mdb), Excel (.xls), and dbase IV (.dbf). The vendors as well as the users of the equipment are tracked and energy savings are calculated in this program.

Fisher Scientific World Headquarters, Hampton, NH
VB/Access Programmer and Analyst
Contact: Dierdre Sommerkamp 603-929-2517
Dec 2003 - Jun 2004

Fisher had a bunch of databases containing the results of multiple Quarterly Customer Satisfaction Surveys. They needed a programmer to unify this data so it could be properly queried and reported on and so information across quarters and across divisions would make sense. I have merged all data into one set of normalized tables and am proceeding to rewrite all queries and reports to address the new schema. We are doing this in such a way that an eventual merge of this "seed" data will easily transform into a full CRM system by means of migration into a Siebel ODS (Operational Data Store).

Strafford County Dover, NH
Visual Basic with XML
Contact: Roger Smith 603-742-1348; Diane Legere 603-659-6415
Oct 2003 - Feb 2004

A new mandate in the State of New Hampshire requires all agencies (>300) to begin reporting all pension payroll deductions and related information for all state employees via a file in XML format. Strafford County has 310 employees to report on and the resulting XML rendition is over 4000 lines long. Roger located me from a web search (oracle programmer nh) and I did the job using Visual Basic.
It turns out that we were the only ones to get our file validated within the deadline. All other agencies used the fallback approach of fixed width ascii or CSV or they begged for more time.

Tyco International Exeter, NH
Access Database Programmer (Access 2002)
Contact: Jeff Kovach 603-778-9090
May 2003 - Jun 2003

A local programming house named Compass Systems and Programming created an Employee Performance program in Access that is deployed at 100 worldwide regions. There were two very different versions, one for upper management and one for everyone else. I merged the two code bodies and reproduced all the pre-existing functionality.

Just for fun, I changed some employee's names and ids and published a subset of the data to our password protected .NET website in an editable datagrid. I did this to demonstrate our skills with DotNet and to show the value of centralized, up-to-date, and secure data. Currently, like so many others, Tyco exchanges data between regions via EMail attachment of Excel spreadsheets.

Acme Brick Company, Houston, TX
Visual Basic.NET, ADO.NET
Contact: Randy Oliver 979-885-4124
Feb 2004 - May 2004

A large brick plant near Houston, TX located us by searching for our skillset on the Web. We created a quality control program for their production engineer using DotNet technologies that monitored a high resolution video camera. This camera was continually focused on a production line of precured and precut bricks called a "slug". Periodically, the line operator clicks a button to take a picture of the line going by at 1 foot per second. Our Visual Basic DotNet solution grabs a frame from the continuous video stream and displays it on a color monitor side by side with a picture of a known high quality standard for that particular style of brick. Depending on the visual comparison, the operator can take appropriate action such as calling for a change in mixture or other operating parameters. If quality is good, he simply does nothing. We log the picture taking events in order to track the operator taking pictures on a prescribed frequency. Hidden from the operator, there is a secured maintenance module so the engineer can periodically check the log, add new standards, tune the camera settings, and perform other data management features.

Genesys Software Corp, Methuen, MA
Visual Basic, Crystal Reports, SQL Server 2000
Contact: Steve Munini, Chief Systems Architect:978-685-5400 Ext 3002
Jan 2003 to Feb 2003

Program: People Come First -- a Web-based Human Resources program.
As part of developing enterprise reporting solutions, I developed reports using Crystal Reports Developer (Ver 8.5) against a complex MS SQL Server 2000 database.

GSC clients are Fortune 500 companies as well as other sites such as state and county governments who have a need for extensive reporting on a wide range of employee activities. The client installations I worked on were in the area of employee education. We built a central report repository, maintained tight user security, used report scheduling, and sought accurate and speedy report processing.

As part of a tight and highly skilled development team of 5, I helped provide a scalable web-based solution for managing the access and delivery of hundreds of Crystal reports across the enterprise. These client reports had to be carefully constructed and often rested on SQL joins of up to 20 tables. A very important aspect was speed optimization. The query (view) underlying a particular report was written to take advantage of server-side processing. For example, directing that grouping take place on the server and that execution of the reports be based on data saved with the report, rather than suffering multi-user hits to the server for live data every time. This data was refreshed to the report during off-peak hours.

Another optimization was the use of stored procedures as data sources. Although these take time to set up properly, they can be incredibly powerful, especially when running reports off large databases.

In the interest of cross-skills enhancement on the development team, I conducted Crystal Reports classes (Basic and Intermediate.)

State of NH - Dept of Education, Concord, NH
Consultant / Coder Visual Basic / Access Programmer and VB6
Contact: Bonnie St. Jean: 603-271-3805
Jan, 2000 to Jul 2001

The DOE needed a database programmer in NH to develop a brand new program to deal with a complex new tracking system mandated by the Federal Dept. of Labor. This legislation that created this national system was the Work Incentive Act (WIA) so that is what we named the State of NH response to it. My program tracks out of work participants and a myriad of details about them while they are involved in Job Training and other educational programs to improve their employability. Many business rules and extensive exporting and reporting at the state and federal level. Periodically transmitted the NH data in formatted records of over 3000 bytes to Dept. of Labor main database which collects data for all the states.

...and many many other projects going back into the mid 1990s.
back to top