gavin broughton

About

I am a BI / Data Analyst specialising in MS SQL and reporting with SSRS & Power BI. * 10 years expertise of MS SQL Server versions 2000 to 2017 writing views, stored procedures and functions for data analysis, migration, ETL, data cleansing and Business Intelligence reporting. * 7 years experience of SSRS from installation to production of static, dynamic & dashboard reports. * 1 year (total) of SSIS, editing & developed ETL packages into production. * 15+ years Advanced user of Excel upto latest version. * 20+ years using Microsoft Windows, the Internet and a diverse range of other software.

Country

united kingdom

City

london

Industry

information technology and services

Skill

sql, ssrs, ssis, ssas, business process improvement, sql server, data analysis, relational databases, business process, business intelligence, report writing, reporting and analysis, data cleansing, data quality, etl, excel, digital photography, social media, internet entrepreneur, internet research, databases, microsoft excel, microsoft sql server, t sql, analysis services, online research, data warehousing, analysis, sql server reporting services

Experience

business intelligence developer

housing partners ltd

2017-9 - Present · 9 yrs 1 mo

business intelligence analyst

fusion lifestyle

2018-12 - 2020-3 · 1 yr 4 mos

founder and director 29 sep 1999 â 01 oct 2002

linxengine

1999-1 - 2001-1 · 2 yrs 1 mo

systems analyst and sql analyst developer

gab robins uk ltd.

2014-1 - 2015-10 · 1 yr 10 mos

* Collected and translated internal business requirements into technical requirements & solutions. * SQL Programming tasks designing, coding, testing and investigating faults. * Working with internal and external technical staff on business to business data solutions. * Acted as a point of escalation supporting 1st line helpdesk. * Providing succinct and regular updates to the senior management. * Created & re-designed existing processes to ensure that systems are fully operational & quick to run. * Designed an automated reporting solution to bill fees to clients where no software module existed. * Data cleansed incoming client data and escalated issues to the client. * Developed SSIS solutions to receive and process clients data from FTP into local data warehouse. * Improved and maintained monthly procedures to deliver reports.

business reporting analyst

wragge & co llp

2008-8 - 2014-1 · 5 yrs 6 mos

* Microsoft SQL Server 2005/2008R2 querying/scripting of CMS, PMS, Cognos and data warehouse databases. * Microsoft Reporting Services 2008R2 to advanced (highly dynamic) level. * Data quality / integrity analysis and complex data cleansing. * Data architecture & migration implementation of a Case Management System (1 year project). * Business Process Design. * Microsoft Business Intelligence / ETL with SSIS. * Practical knowledge of Business Objects Crystal Reporting.

barman, team leader, waiter and kitchen staff

various service industry roles

2001-9 - 2005-1 · 3 yrs 5 mos

* Sept 2001 * Aug 2004: Litten Tree Public House, part of SFI Group (which is now dissolved) in Redditch. Sept 2004 * late 2005: 2 other public houses & Pizza Hut (Kitchen) Bromsgrove.

records assistant and systems implementation

network rail

2005-1 - 2008-7 · 3 yrs 7 mos

Working out of the Mailbox in central Birmingham for Network Rail starting as a Records Assistant (part physical records, part database) and later took on a 'super user' role helping to implement new software & records keeping (database) system including training of other users and the disbandment of the old system/database. This is where I learnt that I wanted a career working with data. I left this role due to departmental relocation and as a result took redundancy.

lead business intelligence analyst

steeper

2016-2 - 2017-7 · 1 yr 6 mos

* Lead role for the setup and implementation of Business Intelligence within the company. * From first installation of MS Reporting Services, through to Data Modelling / Design of the Data Warehouse and OLAP cubes. * Kimball, Inmon or a hybrid of the two solutions currently being analysed.) * The key source ERP system is Sage X3. * Also often a key stakeholder for business process design, to ensure good data goes in, and good data comes out again.