Jamie Bonsell

Reports dashboards and data warehouse management using MS SQL and SQL tools.
Gathering of business requirements to provide KPI and management reporting along with bespoke ongoing requests from a variety of business usuers to meet their daily data requirements.

<p>Leading a team of 2 BI Developers to provide the business with Financial, Marketing and Operational performance reporting.<br>
Manage KPIs reporting with Power BI.<br>
Manage Azure data warehouse populated through Data Factory with data from source databases including PostgreSQL, Google BigQuery and some Excel data sources.</p>

<p>Leading a team of 3 to manage reporting and data extracts from various SQL sources primarily for Compliance, AML and Responsible Gaming teams.<br>
Created complex SQL queries to extract data from data warehouse, CRM and finance databases.<br>
Managed SSRS reporting suites for multiple brands.<br>
Performed ongoing business analysis to gather ad-hoc requirements.<br>
Migrated dashboard capability into Power BI for future reporting platform.</p>

<p>Managed datasets and reports delivered from SQL Server using SSRS on private client data relating to pensions and investments.<br>
Maintained and optimized reporting database extracted from Xplan client management database using SSIS and T-SQL scripts managed through jobs in SQL Server.</p>

<p>Worked closely with a major UK client to assist with and maintain reporting process across multiple divisions within the company.<br>
Analyzed reporting and data requirements for reports, dashboards and future migration to One CRM.<br>
Analyzed data and developed dashboard capability in Power BI for future reporting platform.<br>
Assisted with development of data hub using PostgreSQL on Azure database.</p>

<p>Supported various fundraising teams in selecting data for marketing campaigns across multiple channels including mail and email.<br>
Created MS SQL scripts and stored procedures to extract relevant data from existing data warehouse.<br>
Analyzed and planned development of new data model to create new data warehouse.<br>
Created SQL scripts to create data items used in selections, reporting and analysis.</p>

<p>Developed SSRS reports for tracking and monitoring of SLAs for concierge services on corporate accounts provided across various clients.<br>
Developed reporting suite in SQL Server 2016 development environment and tested across multiple users.<br>
Deployed production reports and created schedules to provide the business with accurate reporting data as and when required.<br>
Developed SQL Stored Procedures to create reporting metrics for a variety of stats to monitor SLAs for various reports for multiple clients.<br>
Developed procedures to extract stats from raw telephony data and to build statistical data for SSRS reporting.</p>

<p>Created reporting suite from Case Management software MatterSphere using SSRS and SQL Server for both major external Insurance and Aviation clients and internal client admin.<br>
Developed ETL processes using SQL stored procedures and SSIS packages to create data marts from three case management servers and one finance database to create data sets for SQL reporting tools from one single source.<br>
Created ad hoc reporting requirements to specifications as defined and agreed with internal client admin teams.</p>

<p>Created Business Objects documents for Sales Directors, Managers and representatives using version XI 3.1.<br>
Distributed documents using InfoView.<br>
Managed reports and distribution to management and field staff on daily, weekly, and cyclic changes to Oracle database using SAP BOXI Enterprise CMC 3.1 and Toad for Oracle.</p>

<p>Supported ongoing modification of the 'Marketing Data Mart' data model using ETL processes to achieve effective business use of high volumes of data and manage ETL projects through the whole project lifecycle.<br>
Developed a wide range of Business Intelligence solutions to manage output of large data volumes for marketing managers.<br>
Developed and deployed SSIS packages using Team Foundation Server and SSRS to provide ongoing reporting solutions.<br>
Implemented agile BI development methods across project work and BAU including collaboration with product owners creating user stories and developing projects to create reporting functionality and solutions.</p>

<p>Managed and configured The Raiser’s Edge database for fundraisers and other users across various directorates within the organisation.<br>
Carried out segmentation of data for Direct Marketing teams.<br>
Provided complex reports for analysis and providing data and results to mailing houses.</p>