
Saving you a day-and-a-half with a click of a mouse, Microsoft Access and Excel specialist
Leeds, United Kingdom

Saving you a day-and-a-half with a click of a mouse, Microsoft Access and Excel specialist
Leeds, United Kingdom
I have worked in the IT Industry since 1983, starting as a junior programmer, moving into support and training, and now spending most of my time programming again.
I write time-saving business programs for Access and Excel - I can save you a day and a half with a click of a mouse!
I stop your computers frustrating your staff, and instead make them delight your staff in the time it saves them and in how easy they are to use.
I make your staff more efficient by running training courses on Microsoft Office products up to Excel and Access VBA programming levels.
Training courses include:
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft PowerPoint
Microsoft Outlook
Microsoft Project
View case studies here: http://www.astradyne.com/cs4.htm
Microsoft Access and Excel development.
Computer Training.
Cost Saving.
Frustration removal.
SMS alerts.
Information at the click of a mouse.
(Privately Held; Computer Software industry)
October 1992 — Present (17 years 6 months)
In the last few years Astradyne Limited has saved over £1m for companies and Government departments in the North of England and Nationwide.
We write tailored solutions for businesses using Microsoft Access and Excel. This includes programs for invoicing, quoting, reporting, case tracking, SMS messaging, PDF reporting, internet databases and standard letters.
Can you find out your turnover per customer, how this compares to expected and their rank against all other customers over any time period in a few seconds? Our customers can.
(Computer Software industry)
September 2008 — December 2009 (1 year 4 months)
For a medical company in Leeds, I’ve created a system to analyse questionnaires. This has cut down on the input time of a questionnaire by half.
Also, using a combination of Excel and Access, I’ve written a method where the staff can simply design their own reports which can be integrated within the system. These reports can then be repeated with the latest data, or any range of dates, in a few seconds.
(Government Administration industry)
March 2007 — December 2009 (2 years 10 months)
For a Government Department, I’ve designed a database to handle sensitive cases. It’s now much easier and quicker for staff to handle and track cases, and I’ve designed a way where they can produce ad hoc reports in seconds rather than hours.
Many staff were complaining that the old system put out too many reports for their section, but my system allows the user to choose the reports they require, which are presented in separate sheets of an Excel spreadsheet.
An additional report, consisting of over 10 KPIs, each featuring graphs, now is created for any range of dates in seconds, rather than the two days it took previously. This system has recently gone nationwide, analysing national statistics never previously available.
(Transportation/Trucking/Railroad industry)
February 2006 — December 2009 (3 years 11 months)
One batch of Monthly Reports were taking three weeks to produce.
By writing a suite of VBA Macros in Excel, this was reduced to just two hours of computer time, and just three clicks by the user!
The system also featured a function where by the user could define new reports, and also define the format, enabling immediate changes to be made.
(Privately Held; Transportation/Trucking/Railroad industry)
May 1994 — December 2009 (15 years 8 months)
I have created and developed an Access database enabling many different tasks to be undertaken concurrently. Functions include:
* Internet booking and tracking of jobs
* Postcode entry of addresses cuts down on errors
* Invoices produced directly to PDFs for emailing to customers
* Production of CO2 statistics so customers can offset their use
* Logging of all jobs as they come in.
* Invoicing for the month now takes one hour rather than two days.
* Up to the minute statistics.
* Link to the internet to show map of parcel collection and delivery.
* Tracking screen shows collection and delivery status.
* Job costing.
* Mailmerge of all customers that had not placed an order for three months resulted in many becoming regular customers again.
(Mechanical or Industrial Engineering industry)
April 2007 — September 2008 (1 year 6 months)
This company upgraded their systems from Lotus Smartsuite to Microsoft Office. To aid the switchover, I converted the functionality of over three hundred Lotus Approach databases to Microsoft Access, with advanced reporting in Microsoft Excel.
This involved some complex VBA to mimic Lotus functions in Microsoft Office.
(Design industry)
August 2007 — December 2007 (5 months)
For a Design company, I’ve created a database to handle their quotes and invoices. Previously, a quote took over fifteen minutes to prepare. Each time a document was required, the Customer name and address had to be input. If the quote became an order, another thirty minutes was spent producing an invoice. To check unpaid invoices (and uninvoiced work) was a manual and laborious task.
Features of the new system include:
• No repetition. To do a quote for an existing customer, pick them from a list.
• Similarly for items on the quote, simply pick the item and the description and price are automatically entered.
• To ‘convert’ a quote into an invoice now takes one click
• Built in reports for work not yet invoiced and invoices not paid
(Computer Software industry)
June 2003 — September 2007 (4 years 4 months)
For an employment agency, an existing database was modified to improve its efficiency. Functions added include:
* Ability to send SMS messages for quick contact of staff. Simply fill in a screen requesting a skill, type the SMS message (or choose from a set of predefined messages), and click send. All candidates with the matching skill set immediately receive the message. This saves time and money involved in contacting by phone, and allows the vacancy or vacancies to be more quickly filled.
* A Status screen was added to constantly show the staff numbers required and satisfied for the day in question.
* Letter printing was automated - the system can create one-off or mailmerge letters at the touch of a button.
* Shortcuts were added so information was always to hand, eliminating the need to constantly close and open forms.
* Data checks and e-mail alerts were added.
* New reports added to more quickly identify calls to be made/activities to be completed.
(Transportation/Trucking/Railroad industry)
August 2003 — October 2004 (1 year 3 months)
A delivery company in Yorkshire needed a more efficient way of planning and handling deliveries. Also, a stock control system was implemented.
Features of the installed system include:
* Route planning. The organisation used a program to plan the delivery route efficiently. However, the input to, and output from this program was manually entered. An export/import facility was written, enabling a fast link between the database and the route planner, saving 10 hours per week, along with a vast decrease in transcription errors.
* Autodialler. Click a button to dial the contact.
* Notes with the order. Any member of staff could glance at the order screen and look at the order history.
* Internet Map access. A button was provided to show the location of the delivery by searching on the Postcode.
(Utilities industry)
March 2003 — April 2004 (1 year 2 months)
For a Utility Company, I was involved in the designing of training courses for their GIS system.
There were two courses; a five-day version for the draughtspeople, and a two-day course for other staff.
I also designed and created the CBT intranet website for the web-based part of the project.
Along with two business representatives, we toured the region giving training and PowerPoint presentations of the system.
(Computer Software industry)
December 1996 — January 2001 (4 years 2 months)
I was responsible for the day-to-day operation of the technical side of the company, building networks, presenting and designing training courses, and providing technical support to customers and staff of the company.
(Computer Software industry)
August 1988 — October 1992 (4 years 3 months)
I was the Technical Manager of a team of three. We were responsible for installation, training and support of both single and multi-user systems, including DOS, OS/2, Novell and Unix.
(Computer Software industry)
August 1987 — August 1988 (1 year 1 month)
I was originally employed in the training department, but was soon promoted to Systems Engineer. This involved the installation and support of customer's machines.
(Information Technology and Services industry)
September 1985 — August 1987 (2 years )
Together with a colleague we set up the customer support function that eventually evolved into a staff of four, which I went on to manage. I was also responsible for the training arm of the company.
(Computer Software industry)
October 1983 — September 1985 (2 years )
I was employed as a computer programmer, writing packages to simulate and program machine tools such as lathes, punch presses and millers. I also trained customers on these packages.