$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Application Developer
Jamie McCulloch
,
LONDON, United Kingdom
Experience
Other titles
Skills
I'm offering
My passion for technology comes from the creative process and the challenge to build dynamic applications, that enhance productivity. Usually on my own and in close alliance with end users, I'd design every aspect of the solution from business analysis, user interface, front & backend coding, to database design and build.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - 2019
temp
Sage SQL Expert
Rimex Metals (UK) Ltd.
Contract: 7 Months
At Rimex my role was to create Crystal Reports based on a 600 table Sage X3 SQL Server database, a common Enterprise Resource Planning application. The database had virtually no documentation other than a cryptic data dictionary. To rapidly come up to speed on the database structure, I applied software tools to analyse and index not just the SQL Database but also some existing Crystal Reports. Some Business Analysis was involved to document user reporting requirements. After 7 months I completed a suite of reports including a webpage to instruct users on how to run them with examples of their appearance. Besides Crystal Reports, I also created many SQL Views and Functions to format and manipulate the data.
At Rimex my role was to create Crystal Reports based on a 600 table Sage X3 SQL Server database, a common Enterprise Resource Planning application. The database had virtually no documentation other than a cryptic data dictionary. To rapidly come up to speed on the database structure, I applied software tools to analyse and index not just the SQL Database but also some existing Crystal Reports. Some Business Analysis was involved to document user reporting requirements. After 7 months I completed a suite of reports including a webpage to instruct users on how to run them with examples of their appearance. Besides Crystal Reports, I also created many SQL Views and Functions to format and manipulate the data.
Sql, SQL Server, Business Analysis, SoMe, Database, Software, Server, Enterprise, UP
2016 - 2017
job
Data Solutions Architect
Augustus Martin.
Permanent: 1 Year 3 Months
At Augustus Martin my Rapid Application Development experience came to the fore. My first project was to build a MS Access working prototype application to enable Tesco and other large retailers to order their printed advertising materials from Augustus Martin. Previously this was done using an Excel spreadsheet. However, with over 2,000 stores and 250 printed items of advertising, per store, it created half a million cells to enumerate the order. The Access database and front end reduced the task to manageable proportions using searching and cloning features. Excel spreadsheets could then be created or input with a single click, using advanced MS VBA functions to enable Excel - Access communications. This saved an enormous amount of time. Later the application was re-skinned for Starbucks use.
For another project, I built a Service like application that sat on the company server collecting delivery updates from TNT. As the consignment tracking data provided by TNT was cryptic and segmented, I created a script to automatically download FTP files, parse them into a SQL Server database and then present the data for Head Office staff. It used HTML5 and CSS3 technology in a responsive design with a SQL Server Database. In yet another project I built a Web page prototype for use by quality assurance personnel to ensure the Point of Sale advertising was deployed.
To improve tracking of the printing process I added QR codes to the packing lists. The collated package for delivery including the QR code was photographed on the production floor. The camera was tethered to a laptop that automatically scanned the QR code indexing and saving the image without any human interaction. That image then formed part of a website that could be interrogated by the customer to confirm the delivery contents. The same QR code could be used by the customer to direct them to the webpage. A diagram of the process can be seen here
http://www.baydatatech.com/Process_Diagram_Small.jpg
At Augustus Martin my Rapid Application Development experience came to the fore. My first project was to build a MS Access working prototype application to enable Tesco and other large retailers to order their printed advertising materials from Augustus Martin. Previously this was done using an Excel spreadsheet. However, with over 2,000 stores and 250 printed items of advertising, per store, it created half a million cells to enumerate the order. The Access database and front end reduced the task to manageable proportions using searching and cloning features. Excel spreadsheets could then be created or input with a single click, using advanced MS VBA functions to enable Excel - Access communications. This saved an enormous amount of time. Later the application was re-skinned for Starbucks use.
For another project, I built a Service like application that sat on the company server collecting delivery updates from TNT. As the consignment tracking data provided by TNT was cryptic and segmented, I created a script to automatically download FTP files, parse them into a SQL Server database and then present the data for Head Office staff. It used HTML5 and CSS3 technology in a responsive design with a SQL Server Database. In yet another project I built a Web page prototype for use by quality assurance personnel to ensure the Point of Sale advertising was deployed.
To improve tracking of the printing process I added QR codes to the packing lists. The collated package for delivery including the QR code was photographed on the production floor. The camera was tethered to a laptop that automatically scanned the QR code indexing and saving the image without any human interaction. That image then formed part of a website that could be interrogated by the customer to confirm the delivery contents. The same QR code could be used by the customer to direct them to the webpage. A diagram of the process can be seen here
http://www.baydatatech.com/Process_Diagram_Small.jpg
Technology, QR codes, Production, Responsive, Http, Web, Server, Office, Development, Quality Assurance, Access, It, Html5, Service, Website, VBA, Responsive design, Database, Advertising, SQL Server, Css3, Excel, Sql, Design
2010 - 2014
job
Intranet Developer
Superdrug.
Permanent: 4 years 1 month
At Superdrug, I built a seven page Intranet application to coordinate delivery and collection of the new "Click and Collect" Internet ordering option. A Service like app. sitting on the IIS Server scheduled the sending of up to five emails to customers as per individual Store control. Additional modules built in VB, monitored utilities that would daily check incoming data from the Distribution Centre for anomalies. When one was detected a list of support staff were emailed. With one other colleague, I also built, in two months an Intranet based HTML, JavaScript, VBscript, CSS, MS SQL database application to record staff working hours, as entered by 1200 Store Managers. Another application I built using the Intranet again, enabled Store Managers to document, detail and log their business plans for review by Area and Regional Managers. It worked well, recording a word count of over 6 "War and Peace" novels. https://www.superdrug.com/
At Superdrug, I built a seven page Intranet application to coordinate delivery and collection of the new "Click and Collect" Internet ordering option. A Service like app. sitting on the IIS Server scheduled the sending of up to five emails to customers as per individual Store control. Additional modules built in VB, monitored utilities that would daily check incoming data from the Distribution Centre for anomalies. When one was detected a list of support staff were emailed. With one other colleague, I also built, in two months an Intranet based HTML, JavaScript, VBscript, CSS, MS SQL database application to record staff working hours, as entered by 1200 Store Managers. Another application I built using the Intranet again, enabled Store Managers to document, detail and log their business plans for review by Area and Regional Managers. It worked well, recording a word count of over 6 "War and Peace" novels. https://www.superdrug.com/
Support, UP, Vb, Utilities, Internet, App, Server, Detail, Vbscript, IIS, Javascript, Developer, It, Service, Word, Database, HTML/CSS/Javascript, Sql, Html, Css
2006 - 2010
temp
Senior Contract Developer
IMG.
Contract: 3 years 6 months
Initially I solved bugs in the IMG Content Management System as well as production sites such as Manchester United, Manchester City and European Tour. I progressed to performance improvements by writing code to cache, frequently accessed, almost static data. SQL statements ran quicker when the in-line code was replaced by compiled stored procedures. Reducing the dataset size and the NOLOCK hint also increased performance. Attention was also focused on HTML headers which directed the third party caching service Akamai. This greatly increased the performance of the origin servers when handling 500 hits a second. Working with QA on the implementation of these updates, I wrote Visual Basic 6.0 utilities to compare file versions on ten servers, transfer code between servers and monitor live web page performance. These high profile sites demanded the best practice and minimal downtime. We followed an extended change management procedure, incorporating an extra testing phase, for superior service levels. My work at IMG involved extensive work with MS SQL Server, ASP classic, JavaScript, VbScript, Visual Basic, DHTML and HTML. This was an interesting role as I gained an understanding of the infrastructure and software of the high performance websites behind the world's elite sports stars like Tiger Woods.
http://www.img.com/
Initially I solved bugs in the IMG Content Management System as well as production sites such as Manchester United, Manchester City and European Tour. I progressed to performance improvements by writing code to cache, frequently accessed, almost static data. SQL statements ran quicker when the in-line code was replaced by compiled stored procedures. Reducing the dataset size and the NOLOCK hint also increased performance. Attention was also focused on HTML headers which directed the third party caching service Akamai. This greatly increased the performance of the origin servers when handling 500 hits a second. Working with QA on the implementation of these updates, I wrote Visual Basic 6.0 utilities to compare file versions on ten servers, transfer code between servers and monitor live web page performance. These high profile sites demanded the best practice and minimal downtime. We followed an extended change management procedure, incorporating an extra testing phase, for superior service levels. My work at IMG involved extensive work with MS SQL Server, ASP classic, JavaScript, VbScript, Visual Basic, DHTML and HTML. This was an interesting role as I gained an understanding of the infrastructure and software of the high performance websites behind the world's elite sports stars like Tiger Woods.
http://www.img.com/
Developer, Akamai, Basic, Utilities, Production, Http, Web, Server, Software, Vbscript, Testing, Infrastructure, Implementation, Stored procedures, Javascript, QA, Service, ASP, Content, Management, Content Management, Websites, Writing, HTML/CSS/Javascript, SQL Server, Change management, Sql, Html
2005 - 2006
temp
Senior Developer
ACE Parking.
Contract: 1 Year 5 months
Here I created a desktop application, to meet the bespoke needs of a small company handling airport car parking. It was an MS Access application with background VBA code for taking parking bookings and producing management reports.
ACE parking personnel would meet and greet travellers at Gatwick airport and then drive their car to a cheap third party car park ten minutes away.
ACE personnel would then collect the car from the car park and meet the returning traveller at Gatwick airport.
The Desktop application coordinated meetings for ACE staff and produced a variety of reports to help the owner run the business.
Latter on I additionally built a web site take booking across the Internet and integrated it to the desktop app. It contained a date based client-side parking fee calculator, with data validation in JavaScript and VBscript.
Although I started working for IMG the following year I continued to work for ACE part time up till Feb 2011.
An image of the website I created can still be found here
http://web.archive.org/web/ 1/http://aceparkinggatwick.com/
Here I created a desktop application, to meet the bespoke needs of a small company handling airport car parking. It was an MS Access application with background VBA code for taking parking bookings and producing management reports.
ACE parking personnel would meet and greet travellers at Gatwick airport and then drive their car to a cheap third party car park ten minutes away.
ACE personnel would then collect the car from the car park and meet the returning traveller at Gatwick airport.
The Desktop application coordinated meetings for ACE staff and produced a variety of reports to help the owner run the business.
Latter on I additionally built a web site take booking across the Internet and integrated it to the desktop app. It contained a date based client-side parking fee calculator, with data validation in JavaScript and VBscript.
Although I started working for IMG the following year I continued to work for ACE part time up till Feb 2011.
An image of the website I created can still be found here
http://web.archive.org/web/ 1/http://aceparkinggatwick.com/
Javascript, VBA, Management, Website, It, Access, Developer, Vbscript, Senior Developer, App, Web, Internet, Http, Booking, UP
2004 - 2004
temp
Senior Contract VB Programmer Contract
AIR NEW ZEALAND.
7 months
This role covered a variety of systems and provided interesting work. As well as day-to-day production issues I also worked on green-field tasks such as the business analysis on a document management system recording regulations for aircraft maintenance. Another system I worked with was to be used to coordinate the support of relatives in case of a plane crash. It tapped into the CARINA passenger list database. I did most work on the Crystal Reports systems and Crystal Enterprise for scheduling reports. This also involved working with several SQL Server databases which provided the data for the reports. Most of the systems I worked on were coded in Visual Basic 6.0 and several versions of MS Access.
This role covered a variety of systems and provided interesting work. As well as day-to-day production issues I also worked on green-field tasks such as the business analysis on a document management system recording regulations for aircraft maintenance. Another system I worked with was to be used to coordinate the support of relatives in case of a plane crash. It tapped into the CARINA passenger list database. I did most work on the Crystal Reports systems and Crystal Enterprise for scheduling reports. This also involved working with several SQL Server databases which provided the data for the reports. Most of the systems I worked on were coded in Visual Basic 6.0 and several versions of MS Access.
Sql, SQL Server, Business Analysis, Database, Management, It, Access, Support, Server, Enterprise, Production, Vb, Basic
2003 - 2004
temp
Senior Contract VB Programmer
IBM.
Contract: 1 year 3 months
At IBM the task was to work with an existing VBA application to extract data for feeding into a Workforce Management application. The coding involved using an Active-X control for creating a Socket connection. As well as completing the specified additions on schedule, I also had time to improve the performance of the existing application. By adding profiling code I identified bottlenecks in the application. I optimised these by replacing inefficient links to a DB2 database with 'pass-through' queries. The application then ran in one fifth of the time it took previously by ceasing unnecessary query compilation in Access and extracting only the information it needed from the DB2 database, rather than transferring whole tables.
At IBM the task was to work with an existing VBA application to extract data for feeding into a Workforce Management application. The coding involved using an Active-X control for creating a Socket connection. As well as completing the specified additions on schedule, I also had time to improve the performance of the existing application. By adding profiling code I identified bottlenecks in the application. I optimised these by replacing inefficient links to a DB2 database with 'pass-through' queries. The application then ran in one fifth of the time it took previously by ceasing unnecessary query compilation in Access and extracting only the information it needed from the DB2 database, rather than transferring whole tables.
Database, VBA, DB2, Management, It, Vb
2001 - 2003
temp
Contract ASP Developer
Clifford Chance LLP.
Contract: 1 Year 2 months
Clifford Chance LLP is a large law firm in the City of London. Their lawyers had prepared a guide for companies purchasing assets overseas. As part of a team of three we encoded this guide onto the company's web site. The content covered approximately 30 situations across eleven jurisdictions. Using ASP pages, VBscript and HTML we created a site that enabled collation and summaries across jurisdictions or situations. I focused on the matrix display of the information that hyper-linked to further detail. Considerable attention was given to the fine detail of the screens, creating a professional and authoritative look to the site. This application was completed in 2 months and received praise for the company hierarchy. Prior to this I supported 4 MS Access applications, speeding up operation and adding new features.
Clifford Chance LLP is a large law firm in the City of London. Their lawyers had prepared a guide for companies purchasing assets overseas. As part of a team of three we encoded this guide onto the company's web site. The content covered approximately 30 situations across eleven jurisdictions. Using ASP pages, VBscript and HTML we created a site that enabled collation and summaries across jurisdictions or situations. I focused on the matrix display of the information that hyper-linked to further detail. Considerable attention was given to the fine detail of the screens, creating a professional and authoritative look to the site. This application was completed in 2 months and received praise for the company hierarchy. Prior to this I supported 4 MS Access applications, speeding up operation and adding new features.
Html, HTML/CSS/Javascript, Content, ASP, Access, Developer, Vbscript, Detail, Web, Guide, UP
2001 - 2001
temp
Contract ASP Developer
BP.
Contract: 4 months
The requirement at BP was to build an application that would collate and disseminate information on BP chemicals global projects and their cost.
The application was used by a large number of internationally based project managers, who without any training, entered salient data and the financial status of their projects.
Considerable effort was given to user-friendly features and an intuitive operation.
The application was browser based with an MS Access database on the server.
By using Dynamic HTML I created a constantly displayed help page that interacted with the data capture screens providing advice and lists of options.
Most of the coding for the data collection, data selection and reporting pages was done with VBscript in ASP pages. Hyper-linked figures on the financial reports provided drill-down links to project details.
Written in three months, the application was installed on the BP Intranet on time and to some acclaim. The commissioning manager was so pleased with the result he entered the application into the internal BP Hellios awards.
The requirement at BP was to build an application that would collate and disseminate information on BP chemicals global projects and their cost.
The application was used by a large number of internationally based project managers, who without any training, entered salient data and the financial status of their projects.
Considerable effort was given to user-friendly features and an intuitive operation.
The application was browser based with an MS Access database on the server.
By using Dynamic HTML I created a constantly displayed help page that interacted with the data capture screens providing advice and lists of options.
Most of the coding for the data collection, data selection and reporting pages was done with VBscript in ASP pages. Hyper-linked figures on the financial reports provided drill-down links to project details.
Written in three months, the application was installed on the BP Intranet on time and to some acclaim. The commissioning manager was so pleased with the result he entered the application into the internal BP Hellios awards.
Html, HTML/CSS/Javascript, Training, SoMe, Database, ASP, Access, Developer, Vbscript, Server, Data collection, Manager
1999 - 2001
temp
Contract Application Developer
AXA.
Contract: 23 months
At AXA I was involved in two projects as the first was so successful. The first project was as support to an infrastructure upgrade of 350 PC's in head office. That included new hardware, new OS and retention of existing installed applications. Keeping track of over 5,000 applications required a MS Access database which I developed and expanded. Coupled to webpages it kept staff informed of the rollout which was a "soft-launch" done PC by PC. The second project was to create from scratch graphical reporting module to a "green screen" application running under Oracle. Using MS graphing module I tapped into the DB2 database using ODBC. Later advancements including a recorded scripted batch process to provide each manager with a personalised weekly set of reports. A animated Gif of the application can be seen here. http://www.jamiemcculloch.co.uk/graphs.gif (NB: best browsed with I.E.)
At AXA I was involved in two projects as the first was so successful. The first project was as support to an infrastructure upgrade of 350 PC's in head office. That included new hardware, new OS and retention of existing installed applications. Keeping track of over 5,000 applications required a MS Access database which I developed and expanded. Coupled to webpages it kept staff informed of the rollout which was a "soft-launch" done PC by PC. The second project was to create from scratch graphical reporting module to a "green screen" application running under Oracle. Using MS graphing module I tapped into the DB2 database using ODBC. Later advancements including a recorded scripted batch process to provide each manager with a personalised weekly set of reports. A animated Gif of the application can be seen here. http://www.jamiemcculloch.co.uk/graphs.gif (NB: best browsed with I.E.)
Oracle, Database, DB2, It, Access, Developer, Support, Hardware, Infrastructure, Office, Retention, PC, Http, Manager
1997 - 1998
temp
Application Developer
TeleTELL Consultants.
Contract: 4 months
Here I worked hand-in-hand with the business owner who wanted to build his own Customer Relationship Management application. Although there were "off the shelf" CRM applications he wanted to build his own as relating to his customers was the single most important talent of his business. I built the front end in MS Access 95 and another employee built the back-end DB in SQL. One lesson came out of the project, was that it was possible to over-normalise the DB resulting in too many tables. This was only a slight flaw and over all the application exceeded expectations. However more tables mean more front-end work and slower operation.
Here I worked hand-in-hand with the business owner who wanted to build his own Customer Relationship Management application. Although there were "off the shelf" CRM applications he wanted to build his own as relating to his customers was the single most important talent of his business. I built the front end in MS Access 95 and another employee built the back-end DB in SQL. One lesson came out of the project, was that it was possible to over-normalise the DB resulting in too many tables. This was only a slight flaw and over all the application exceeded expectations. However more tables mean more front-end work and slower operation.
Sql, CRM, Management, It, Access, Developer
1997 - 1998
temp
Application Developer
National Mutual Ltd.
Contract: 9 months
At this New Zealand finance company I enhanced an existing MS Access application. The system tracked cashflows of Swap trades designed to hedge exposure from a domestic mortgage fund. They we're borrowing wholesale at floating rates to fund bundles of mortgages at fixed rates. Profitability of the project was quite dynamic and the Access application kept track of that as the completed mortgage bundles were sold off and new ones started. The engine of the Access application was reverse engineered from an Excel spreadsheet.
At this New Zealand finance company I enhanced an existing MS Access application. The system tracked cashflows of Swap trades designed to hedge exposure from a domestic mortgage fund. They we're borrowing wholesale at floating rates to fund bundles of mortgages at fixed rates. Profitability of the project was quite dynamic and the Access application kept track of that as the completed mortgage bundles were sold off and new ones started. The engine of the Access application was reverse engineered from an Excel spreadsheet.
Excel, Finance, Access, Developer, Wholesale
1997 - 1997
temp
Application Developer
MAS Technology Ltd.
Contract: 2 months
Reviewing this assignment, it's amazing that I created two fully functional applications in such a short period. Technology involved was Visual Basic 4.0, Crystal Reports, Excel and MS Access. The first project was a classic Excel to Access upscale using DDE communications. Transferring the data from Excel to Access had to be done automatically as the records numbered 25,000. The process was made more challenging as the spreadsheets were in 4 different formats The second was a standalone VB application for the Sales Reps. That embodied a database to search the company stock and create pro-form invoices and quotes.
An animated Gif of the second application can be seen here. http://www.jamiemcculloch.co.uk/images/mas.gif
Reviewing this assignment, it's amazing that I created two fully functional applications in such a short period. Technology involved was Visual Basic 4.0, Crystal Reports, Excel and MS Access. The first project was a classic Excel to Access upscale using DDE communications. Transferring the data from Excel to Access had to be done automatically as the records numbered 25,000. The process was made more challenging as the spreadsheets were in 4 different formats The second was a standalone VB application for the Sales Reps. That embodied a database to search the company stock and create pro-form invoices and quotes.
An animated Gif of the second application can be seen here. http://www.jamiemcculloch.co.uk/images/mas.gif
Excel, Database, Sales, Technology, It, Access, Developer, Search, Http, Vb, Basic
My education
2001
Microsoft
Microsoft Certified Professional, MS Access
Microsoft Certified Professional, MS Access
Victoria University
BSc, Mathematics
BSc, Mathematics
Jamie's reviews
Jamie has not received any reviews on Worksome.
Contact Jamie McCulloch
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Jamie directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark