Lehigh Hanson uses IDEA® Server for global audit collaboration.

Fill out the following form to view the webinar

  • This field is for validation purposes and should be left unchanged.

My name is Nina del Castillo, I work for Lehigh Hanson who are the number one producer in aggregates and one of the leading cement producers. Lehigh Hanson is part of HeidelbergCement and our revenues in 2013 were 18.8 billion.


So as a data analyst I support our NAM team of auditors, and there’s 5 and our director, so our company has three different ERPs and a lot of other disparate systems. So in my role I work with IT, one to get familiar with all the systems and pull as much data as I can personally so that it’s more accurate.


Our company started with IDEA last year around April is when we were up and running with it on our Citrix server system and since then, now we have about 30 auditors on it across all the different continents, so in Asia, and Europe. And there’s three data analysts so we all support our different teams.


We were looking at the different automated auditing packages that were out there and one of the things about IDEA was that it was very user-friendly because our auditors have so many different systems to deal with and have their own duties that we wanted to make it as easy for them, as accessible, so they would actually use the system. Another reason we went with IDEA is because of the inventory of pre-prepared tasks that were in smart analyzers, so that helped us really get an idea to get started and as we became more familiar with scripting and applying it to our business then we developed more custom scripts, but it definitely helped us get started at the beginning. Also one of the reasons that we love IDEA is because of its important function, not just Excel and text, but particularly the report, read or import in the PDFs without wrapping lines and inconsistent columns and once you developed the impart definition, you can easily use it and allow other people to use it in the future. We work with three different systems and so they’re all in different formats and different header names, so with the impart definitions, we can basically build in a consistent field name so that the standard macros that we developed can run on the reports without creating a separate macro for each system.


So one of the advantages on working with IDEA server is we can easily collaborate across the pond with our Europe counterparts and Asia and share our scripts, share our projects and learn from each others past experiences.