GREENHAM IT SERVICES
Professional IT Solutions
![Fotolia_16908299_XS.jpg](https://static.wixstatic.com/media/07af45_3c0df5fcf67645d3852cf84d115566c8~mv2.jpg/v1/fill/w_484,h_271,al_c,lg_1,q_80,enc_avif,quality_auto/Fotolia_16908299_XS.jpg)
![Fotolia_30414645_XS.jpg](https://static.wixstatic.com/media/07af45_513fe517cebd4b9d8e700dd085541c1e~mv2.jpg/v1/fill/w_390,h_520,al_c,lg_1,q_80,enc_avif,quality_auto/Fotolia_30414645_XS.jpg)
BIO
These days, everything is about connectivity and efficiency. Since 2001, I've been working with various organisations to allow them to work better, faster and with less manual intervention. I look at the best and most cost-effective way of delivering what my clients need and undertake to do this within agreed timescales and cost.
![Image by Toa Heftiba](https://static.wixstatic.com/media/nsplsh_666243784c5f77456f354d~mv2_d_5789_3859_s_4_2.jpg/v1/fill/w_780,h_520,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/nsplsh_666243784c5f77456f354d~mv2_d_5789_3859_s_4_2.jpg)
SERVICES
Save time and money with integration and automated processes
A lot of what I do is concerned with efficiency and streamlining. This can be providing better management information to allow fact-based business decisions, or allowing disconnected systems to connect together and allow automated flow of information between them.
I work with in-house and cloud-based systems to take away time-consuming tasks and provide better means for data to be captured and move to the appropriate systems.
BUSINESS INTELLIGENCE AND REPORTING
![Fotolia_13724189_XS.jpg](https://static.wixstatic.com/media/07af45_174a7f95342840b6954864c7310e0400~mv2.jpg/v1/fill/w_301,h_201,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/Fotolia_13724189_XS.jpg)
MAKING INFORMATION FLOW BETWEEN SYSTEMS
![Fotolia_6866169_XS.jpg](https://static.wixstatic.com/media/07af45_64fac5321bd14e3a932332290d284405~mv2.jpg/v1/fill/w_301,h_194,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/Fotolia_6866169_XS.jpg)
BESPOKE DEVELOPMENT OF APPLICATIONS AND SERVICES
![Man Hands On Keyboard](https://static.wixstatic.com/media/49cf43b85ab5497ea5c3a2e6d0737885.jpg/v1/fill/w_301,h_201,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/Man%20Hands%20On%20Keyboard.jpg)
![fotolia_1625743.jpg](https://static.wixstatic.com/media/07af45_5ffa273818ba4193bd051d7d7f5fedd0~mv2.jpg/v1/fill/w_702,h_470,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/fotolia_1625743.jpg)
CANDIDATE REGISTRATION
July 2021
Using Microsoft Dynamics 365 Customer Voice (previously called Forms Pro), Power Automate and a new Windows service, candidates are emailed with a link to securely collect registration information that then automatically feeds back into the candidate's Dynamics 365 CRM record. This replaced a 3rd party system, saving around £30K p.a.
![Fotolia_1951352_XS.jpg](https://static.wixstatic.com/media/07af45_3cbb7325f35b4b269796816381fc17e2~mv2.jpg/v1/fill/w_560,h_420,al_c,lg_1,q_80,enc_avif,quality_auto/Fotolia_1951352_XS.jpg)
DYNAMICS CRM DATA EXPORT
March 2021
My client needed to be able to export various information from a Mercury xRM system to be imported into an Access Pay & Bill system in order that temporary workers are paid and clients are invoiced accordingly. I provided an application to move personnel, placement and timesheet data from the cloud-based CRM system to data formatted for import into the pay and bill system on demand.
![iStock_000000492908Large.jpg](https://static.wixstatic.com/media/07af45_790e1129bf84424593ca4b1a24698ad4~mv2.jpg/v1/fill/w_692,h_460,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/iStock_000000492908Large.jpg)
CRM MIGRATION
January 2021 - June 2021
This project covered:
Specification
Data mapping
Data migration
Customisation and new process creation
Testing
Deployment
Moving from an Access RDB (Pronet) CRM to a Microsoft Dynamics 365 Mercury xRM system, this project was done in compressed timescales and went successfully live in May 2021.​
![Fotolia_13941173_XS.jpg](https://static.wixstatic.com/media/07af45_35558299cc674e3da6890a6c91312ce7~mv2.jpg/v1/fill/w_460,h_460,al_c,lg_1,q_80,enc_avif,quality_auto/Fotolia_13941173_XS.jpg)
WEBSITE TO MICROSOFT DYNAMICS 365 CRM INTEGRATION
April 2021
This recruitment client needed to ensure that their new website supplied candidate information to its Microsoft Dynamics CRM, keeping them both in sync, including for GDPR purposes. The middleware I produced provided the website provider an API to send data to and this then updated the Mercury xRM system and emailed CVs through to be processed by DaXtra.
![Business Meeting](https://static.wixstatic.com/media/11062b_12568f280e304a668e2920040f718284~mv2.jpg/v1/crop/x_0,y_0,w_5472,h_2736/fill/w_940,h_470,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/Business%20Meeting.jpg)
HR SYSTEM INTEGRATION
January 2021
My client employs a significant number of internal hires each month and required a connection between their hiring system and their HR system for employee information, which had previously required manual entry. With this project, this data transfer now happens on an automated basis.
![iStock_000017831176XSmall.jpg](https://static.wixstatic.com/media/07af45_f402c79b13c2492aac77bfc356d082f8~mv2.jpg/v1/fill/w_560,h_420,al_c,lg_1,q_80,enc_avif,quality_auto/iStock_000017831176XSmall.jpg)
RECRUITMENT COMPLIANCE PROCESS
December 2019
This client has more than 30 nurseries that it recruits for. The compliance process is critical, and this project augmented its CRM system with an integrated process and clear interfaces for the people involved to use.
![iStock_000016143375XSmall.jpg](https://static.wixstatic.com/media/07af45_eb6fc62c561b4ec9962b6179527cb52a~mv2.jpg/v1/fill/w_595,h_395,al_c,lg_1,q_80,enc_avif,quality_auto/iStock_000016143375XSmall.jpg)
PHONE STATS REPORTING VIA API
August 2019
This required a very quick turnaround; a new IP phone system, with cloud based reporting, was being installed. As phone stats were very important to this client, I built a service that queried the API of the phone system, and constantly updated the reporting information in-house.
Update August 2021: keeping the phone API logic, this now updates the new cloud based Microsoft Dynamics 365 CRM system with the same stats.
![Fotolia_18317884_XS.jpg](https://static.wixstatic.com/media/07af45_51611d3f793a44bb9f75e5dcfd604664~mv2.jpg/v1/fill/w_560,h_420,al_c,lg_1,q_80,enc_avif,quality_auto/Fotolia_18317884_XS.jpg)
AUTOMATED KPI REPORTING
April 2019
I helped my client remove the need for manual collation of activity data, pulling data from different sources and sending it out weekly in a formatted spreadsheet, with a Power BI report for executives.
![iStock_000004941834XSmall.jpg](https://static.wixstatic.com/media/07af45_e7ea3666211b40dc945b67a0b8dc3921~mv2.jpg/v1/fill/w_560,h_420,al_c,lg_1,q_80,enc_avif,quality_auto/iStock_000004941834XSmall.jpg)
GDPR SOLUTION
May 2018
The requirement here was to ensure that my recruitment client would be GDPR compliant with respect to the hundreds of thousands of candidates on its CRM system. I produced a system that automatically emailed candidates, giving them an easy way of setting their preferences via a simple web site, removing them from the CRM system, should they so wish.
![fotolia_2003271.jpg](https://static.wixstatic.com/media/07af45_8eb96b833ef84de58381bf1c7782f067~mv2.jpg/v1/fill/w_714,h_475,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/fotolia_2003271.jpg)
AUTO INSERT OF SCANNED DOCUMENT TO CRM
September 2019
Working with a printer supplier, I produced part of the solution to allow users to scan identification documents directly into that person's CRM record, saving time and improving GDPR compliance.
![iStock_000003498728Small.jpg](https://static.wixstatic.com/media/07af45_eb803c9e5243487f86e55b1dbc6bae62~mv2.jpg/v1/fill/w_709,h_470,al_c,q_80,usm_0.66_1.00_0.01,enc_avif,quality_auto/iStock_000003498728Small.jpg)
REPORT PRODUCTION
2012 onwards
I often produce straightforward reporting on a quick turnaround. Sometimes the 'out of the box' reports don't give quite the right information and a new report that delivers just what is required can save huge amounts of time. Reports can be automated, or, using a technology such as Power BI, be made to allow drilling down into the data, analysis and modelling.
CONTACT ME
Have a particular challenge you’re trying to deal with? Contact me today and see what I can do for you.
07747 584703