While James was already engaged with us on another project, we brought in a business improvement consultant who required detailed sales and production information from our systems. This was data we had previously struggled to extract in a meaningful and timely way from our SysPro environment.
We asked James whether it would be possible to retrieve and structure this information, despite him not having prior exposure to the SysPro database. He quickly demonstrated an impressive ability to understand the underlying data structure, identify where key information was stored, and determine how the various data tables and relationships connected.
Within a short period of time, he was able to deliver the required datasets in a clear and usable format, meeting the consultant’s requirements and enabling the project to progress without delay.
Our preferred method of working was through Excel-based reporting, and it became immediately apparent that James had exceptional Excel and data manipulation skills. He introduced us to parameter-driven data extraction techniques directly from the database into Excel, a capability we had not previously utilized, and which significantly improved our ability to interrogate and analyze business data.
Following the success of this work, James also developed a number of interactive Excel-based tools that allowed users to access and analyse information far more efficiently. These solutions saved the business countless hours of manual reporting and significantly improved access to timely, accurate information.
Overall, his ability to quickly understand complex systems, extract meaningful data, and deliver practical, user-friendly solutions had an immediate and lasting impact on our reporting capabilities.
