SQL Server Development and HR Reporting for Lime Pictures.
Lime Pictures is an award winning production company that produce shows such as 'The Only Way Is Essex', 'Hollyoaks', 'Geordie Shore' and many more.
We provided SQL server development on their existing SQL farm to deliver a batch of new reporting requirements for their HR system.
The end solution included modifying ther SQL Server database, establishing links to the data source, custom extraction of certain key data that had to be transformed as its natural stored form was an alternate format for other line of business applications and Microsoft Excel was used as the reporting interface offering filtering, pivot tables, unique and related data.
Technologies used were: Microsoft Windows, Microsoft SQL server, Microsoft Office 365 - Excel, VPN & remote access tools.