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



Crystal Reports ™ Programmer / Consultant / Trainer

Reporting is the process of accessing data, formatting it, and delivering it as information. Crystal Reports ™ (by Business Objects) is a powerful analytical tool and is the enterprise report writer of choice for many corporations. It is multiplatform, powerful, and versatile enough for any requirements.

Report Development: I am proficient with all the versions of Crystal Reports ™ and more importantly understand tables in relational databases and how to query them accurately. If I can't do the task with the basic Crystal Reports ™ features like grouping and subtotaling, as a skilled programmer, I can always get it done through code in its built-in C-like programming language called simply Crystal Syntax as well as the widely popular Visual Basic.

Training/Classes: I enjoy teaching Crystal Reports ™ and have developed a well-structured course outline for CR classes of 1 to 20 members. The classroom method is instructor led and group-paced with many hands-on activities. We can conduct 1 to 2 day seminars at your facility or, better yet, at our offices in Hampton, NH. Typically, after warming up with a few hours of the basics, the training extends to classroom development of specific reports you have in mind for your business. You will leave with the working report files and can call back later with your technical questions.

Crystal Reports ™ with its user defined functions, and event-driven model is capable of the most complex calculations and formatting. I find that there is so much interest in Crystal Reports ™ in the firms around Boston and NH that I work for that I often set aside my old prediliction for Microsoft Access' report writer and suggest the job be done in Crystal Reports ™.

Crystal Reports ™ Training / Training Crystal Reports ™ Salesforce.com
 

Projects - Crystal Reports ™

C & J Bus Lines; Portsmouth, NH (CR Ver 12)
Oct 2015
Crystal Reports ™ Programmer / Developer

C&J Bus is a well-established carrier running bus routes from Dover, NH to Boston and Logan Airport. They had another firm created and install new web-based accounting system and needed a Crystal Report created to do a summary type report of ticket sales. This was made difficult because I had no schema nor data dictionary for the new tables. Using SQL Management Studio, I studied the SQL Server data and after a few false attempts, got the Crystal report that Susan needed.

Contact: Susan Rockwell 603-570-2472

Steris (CR Ver 12)
Oct 2015
Crystal Reports ™ Programmer / Developer

Steris has several US branches that are set up with giant industrial units that sterilize packages for hospitals and health industries. They need to document at an extremely granular level eash sterilization cycle. needed an existing complex Crystal Report adapted to a brand new database.that resides on SQL Server. They This report was based on data being automatically generated minute by minute from various processes in their sterilizer units.
I made several visits to their Northborough, MA facility to work this out onsite as well as working from my office. Communication with several key staff was done via GoToMeeting.

Contact: Steve Walliser 630-730-4856 or Jason Parrish 915-208-2370

Exagrid (CR Ver 11)
Aug 2008 - Now
Crystal Reports ™ Programmer / Developer

Exagrid supports many companies in their sales pipeline analyses with data stored online in Salesforce.com. I currently provide complex sales reports, working directly upon the web based data. The interesting thing is that I replaced Chris's former resources in India. He reports that this is greatly improving his turnaround times as well as saving a lot of money (!).

Contact: Mark Halliday 508-898-2872

Kvichak Marine Industries (CR Ver 11)
Apr 2009
Crystal Reports ™ Trainer

Kvichak makes serious boats, especially for the Coast Guard. Terrance flew in for two days of intense on-on-one training at the Brightwork Solutions office. On my advice, he brought specifications for several reports that he needed to develop to support his operations. After preliminary Crystal Reports ™ orientation we used most of the class training time to do all of those reports, making his trip highly productive (his words).

Contact: Terrance Scott 603-601-6049

Phase II Medical (CR Ver 11)
July 2009
Crystal Reports ™ Training

Conducted full day of CR training for three staff members so they could develop their own reports.

Contact: Adam Prime 603-332-8900

TBS Shipping, Yonkers, NY (CR Ver 11)
Aug 2005 - Jan 2006
Crystal Reports ™ Programmer / Developer

I received the base data for this in the form of a SQL Server backup and imported it into my own SQL Server. I developed a series of CR reports and charts that track the voyages of container ships. Various trip factors such as ship speed, wind, wave height, fuel and oil usage,

Contact: Christopher Lynch 914-233-1197

Citizens Bank (CR Ver 11)
Oct - Dec 2005
Crystal Reports ™ Trainer / Programmer / Developer

390 reports created for Citizens Bank Lockbox program. Most were very similar, but there were many that had custom specifications that had to be met. Reports included payments, deposits, and credit card transactions for many well-known bank clients like the Celtics, the Boston Herald, and many state governments, municipalities, colleges and public utilities.

Developed a complete training curriculum in CR 11 and delivered it in a class format to 12 Citizen's Bank users and programmers. Although this exercise was specifically so that they could carry on with the many reports I had developed under my contract, it was also heavy with the basics.

Florida Power and Light (Seabrook NH Nuclear Plant) (CR Ver 7.0)
April - June 2004
Crystal Reports ™ Trainer / Programmer / Developer NH

30+ disparate reports created for the Learning Management System. This nuclear facility conducts massive amounts of training for all workers, including hundreds of seasonal nuclear workers who are signed on during planned outages. Many reports are necessary to track who needs training and retraining, who is overdue, upcoming courses, and so on. The data is on Oracle 8. Although required to use an older version, I used almost every facet of Crystal to get these reports completed.

I created many compound key joins on tables and views on an Oracle database, using custom formulas, subreports, and parameterized reporting. Incorporated library functions and created many custom functions.

Hampstead Fire and Rescue, Hampstead, NH (CR Ver 9.0)
Jan 2004
Crystal Reports ™ Programmer NH

Chip is also the IT Manager and had some difficulties upgrading existing reports from version 8 to 9. I did the debugging/troubleshooting to fix things up for an important series of reports.

Contact: Chief Chip Hastings

Genesys Software Corp., Methuen, MA (CR Ver 8.5, SQL Server 2000)
Jan 2003 to Feb 2003
Crystal Reports ™ Developer / Consultant / Training MA

Genesys 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 developing enterprise reporting solutions, I created reports using Crystal Reports ™ (Ver 8.5) against a very complex MS SQL Server 2000 database.

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.

The complexity of the system that I mentioned earlier arises out of their use of 38 byte computer-generated guids which served exclusively as the keys relating 250+ tables. In fact their entire family of data tables is generated automatically by a proprietary program (Vortex) that responds to a developer-designed graphical layout of just the data schema. This leads to some really long fieldnames and some really interesting (i.e. complex) queries relating many tables. Some of the tables were joined for the sole purpose of administering client security rather than contributing data. In spite of the fact that some queries involved 50 or more tables, response on the Internet was satisfactory.

In the interest of cross-skills enhancement on the development team, I conducted Crystal Reports ™ classes (Basic and Intermediate.) This was fun, but the team got so good, they didn't need a contractor anymore.

State of NH - Dept of Education, Concord, NH (CR Ver 9.0 / Oracle)
Programmer / Consultant
Aug, 2003 to Sep 2003

I used Crystal Reports ™ 9.0 against data on an Oracle 8 server to develop a complex report on activities and results of participants in New Hampshire's WIA Program. This report tracks what retraining goals the 1600 participants were assigned versus how they did in achieving them. For the sake of the users, it had to be easy to generate. For the sake of federal funding, it had to be accurate and it had to agree with other external analyses. Getting to the accurate part required Bonnie and I to cooperate and communicate frequently. Helped the team to learn Crystal Reports ™

Contact: Bonnie St. Jean: 603-271-3805
Cabot Corp., Billerica and Boston, MA (CR Ver 5 and 6, SQL Server 6.5)
Programmer / Consultant
Sep 1998 to Feb 1999

The client uses a commercial laboratory work throughput program named WinLims which connected to its database on SQL Server 6.5. Using Crystal Reports ™ Ver 5 (later upgraded to 6) I created and maintained many custom lab reports. I connected to the server using ODBC, set up ODBC DSN's (datasources) on PCs at 25 lab analyst workstations stations and deployed the reports. I also developed extensive user as well as technical documentation (like how to create new ODBC connections) and provided manager training in how to make their own changes to these reports, recompile and deploy them on their own. Since the lab personnel did not have their own DBA, I served in that capacity. Since my work in that area had a lot to do with getting familiar with the database in terms of Crystal Reports, I am including a description below.

SQL Server 6.5:
The lab's application. WinLIMS was custom written by an out of state vendor and recent performance degradations after a conversion from Gupta SQLBase to MS SQLServer led the lab manager to ask me to study it as a Crystal Reports ™ Programmer and see if I could make some recommendations. I attempted some reverse engineering using ERWin and plotted the database schema out on a 4 foot wide paper roll on an HP DesignJet 750C. Using the outside software provider as a guide and the MS SQL Analyzer as my main tool, the first thing I reported was that there were no keys of any sort on the tables primary or otherwise. It was not too hard from that point to convince the software provider that any queries against the database would resort to linear table scans to perform joins and this can't be tolerated. They agreed that it was a step that was missed somehow in the upgrade and they took care of it immediately. We reran our baseline queries and got immediate results instead of a lot of finger tapping. I later held classes for the lab personnel to helping them to learn Crystal Reports ™.

Contact: John Smithers: 978-663-3455

(back to top)