Thringstone, England, United Kingdom
T-Shaped resource, familiar with a wide range of technical disciplines with a depth of knowledge in data and data integration. Specialties: Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analyst Services, T-SQL
Assisted in the migration of reports from a legacy SharePoint 2007 system to SharePoint 2010. Modernised reporting environment and enhanced KPI reporting ability.
Devised business intelligence strategy to enhance business information capabilities utilising the Pentaho data warehouse platform. Automated key customer centred performance reports. Designed extendible systems architecture and databases to support growing business information needs.
Architected and deployed Dynamics CRM on SQL Server 2008 R2 and supporting domain. Expanded IT systems to Saudi Arabia supporting international business expansion. Integrated with provider systems. Provided data extracts and management reporting utilising SSRS.
Maintained database infrastructure consisting of SQL Server versions 2000 through to 2008 R2. Created ETL processes for systems integration utilising SSIS. Led the implementation of a new data warehouse based business intelligence solution in SSAS. Automated management reporting information consolidating performance data from multiple source systems. Deployed Dynamics CRM and Dynamics AX databases onto SQL Server 2008 R2 cluster. Realised cost savings through database licensing efficiency. Mentored developers in SQL and SSRS use.
Developed web based applications in both ASP and ASP.NET. Produced management information reporting utilising SSRS. Led proof of concept data warehousing project.