Senior Solutions Developer
Working collaboratively in a small team, we developed a site reporting system for Rio Tinto mines in the Hunter Valley. Its key modules include Production, Delay Accounting, Dashboards and Data Warehouse (OLAP) reporting. Utilising modern technologies including Silverlight, .NET 3.5, SQL Server (SSDB and SSAS) and OPC we delivered an easy to use and intuitive solution giving our client real time access to their plant metrics with a sleek and modern appearance.
I had significant involvement in the architecture, design and implementation of the entire project and envisioned a unique data warehouse OLAP reporting tool, utilising dynamic cube generation to virtually eliminate the need for fixed reports. This system allows users to focus on data analysis rather than fixed reports, utilizing drill down, filtering and grouping techniques to give users the information they need when they need it. The Cube reporting module was extremely well received by our clients and set our product apart from others on the market.
Technologies I worked with at Solutek include:
- Microsoft .NET Framework (C#, windows and web)
- SQL Server 2008 Database Services
- SQL Server 2008 Analysis Services
- SQL Server 2008 Reporting Services
- Data Historians (PI Historian and Uniformance)