Working within the BI team on dataflows covering all 999 core Trust systems, 111 and Patient Transport Systems as well as other corporate datafeeds, such as Patient Experience, Safeguarding and Risk, including maintaining dataflows into the data warehouse, and providing cubes for analysis.Core Duties:- Controlling the dataflow from multiple data sources, including core Trust systems, information repositories (Sharepoint) and external partners into the Data Warehouse via ETL’s (SQL, SSIS).- Managing live datafeeds ensuring fast, efficient ETLs to give organisation visibility of extensive live information.- Development and maintenance of Cubes (SSAS).- Co-development of the Trusts Reporting Portal (SSRS).- Development of T-SQL, stored procedures, views, functions as required.- Technical support for Analysts developing in SSRS and Visual Studio using SQL.- Migration of ETL’s & Cubes from SQL Server 2008 to 2014.- Created the new Sharepoint Portal and migrated lists from 2007 to 2014, handling permissions as required to enforce patient confidentiality.- Use of Tableau for data visualisations/testing.- Use of Idera to monitor database locks and identify problem queries.- Periodically employed the Paired Programming development technique.- Contribute to Trusts BI Strategy and researching available and evolving technologies.- Working within Trusts change management processes for new deployments and datafeeds.Specific developments:- Integrated ErlangC as a SQL CLR for 111 Call Centre Forecasting.- Developed an Outlook addon to automatically import incoming data attachments into SQL.- Implemented an OData application as an option for data imports from Sharepoint.- Designed critical path failure reports for support desk monitoring.- Built webpage scraper to obtain live information from 3rd party system.- Created alerts system to indicate instances of missing data.

A dual role to both manage and maintain the operational side of the business plus implement technical solutions in a rapidly changing direct marketing environment.- Responsible for delivering the operational side of the business via the revision of existing operational procedures, enabling teams to begin to deliver within SLA’s, through prioritisation, automation and team development.- Developed significant conflict resolution skills in a high pressure environment.- Lead on the strategy for designing new data models and flows, ensuring the capability to add new streams with minimal impact to existing processing.- Design and implement new solutions (SQL, SSIS, SSRS) to support changing business and market requirements. - Implemented an SSRS portal for automation of standard reports, including a KPI dashboard linked to the CRM system to provide visibility on performance.- Training and mentoring staff to enhance SQL knowledge and capability, from stored procedures to ETL’s, creating more efficient data flows.- Responsible for liaising with third party suppliers, from contract to deployment/continued maintenance.

In order to meet the demands of a constantly evolving business model, the primary focus of this role has been to recommend, design and implement technical solutions to meet business process requirements, using a number of technologies, including .NET/ADO/T-SQL (.NET Framework 3.5).- Responsible for the design and implementation of interoperability between applications.- Created and embedded dynamic link libraries to enhance existing systems.- Primary applications developer/version installer for the organisations Customer Relationship Management (CRM) system, Captavia. - Responsible for supplying new data architecture(s), stored procedures, triggers, T-SQL.- Replaced existing CRM Word templates with .NET generated Word files, attached to client records.- Implemented SQL Assemblies for web service calls to dnDirector, a Data Management tool by Datanomics and Sharepoint.- Created bespoke web services for exposure of database(s) to web applications.- Implemented data access ribbons for MS Excel using Visual Studio Tools for Office (VSTO) 2007.- Developed new reports and custom controls in SQL Server Reporting Services (SSRS) 2005.- Applied Agile/Scrum/Paired Programming and Waterfall software development techniques.- Wrote basic test applications using the DevExpress toolkit in both VB/C#.NET.

Within this role, development work was primarily focussed on the organisations CRM system, Captavia, and MS Reporting Services.- Solely designed and implemented a new CRM system, contributing towards winning the regional bid for business support in the West Midlands.- Responsible for all CRM related design, training and Application Lifecycle Management.- Technical lead for the installation of SSRS 2000. Designed a suite of DTS packages to support a data migration project for the entire database from Oracle 9i to SQL Server 2000. - Converted all MS Access/VBa applications into a full suite of reports with a data dashboard.

Initially, the requirement of this role was to provide adhoc reports in Excel. However, to support the demand for Business Intelligence, a suite of MS Access/VBa databases were created for real-time reporting/analysis.- Migrated all data layers/querying from MS Access applications to Oracle 8i.- Dually responsible for data integration between the CRM system, Agresso and Sage.- Responsible for the design and production of contractual reports for the Small Business Service and Advantage West Midlands, the Regional Development Agency.- Became a supervisory role for the team, acting as Manager to cover maternity leave.