HND, Electrical & Electronic Engineering @
I am a Business Intelligence and Data Warehouse consultant and developer with 10 years’ experience working with numerous highly prestigious organizations, including 18 months spent with a leading consultancy. I have expertise utilizing the full Microsoft database / BI suite of tools, combined with best-practice knowledge in designing and optimising the systems these are used to implement.
I am a Business Intelligence and Data Warehouse consultant and developer with 10 years’ experience working with numerous highly prestigious organizations, including 18 months spent with a leading consultancy. I have expertise utilizing the full Microsoft database / BI suite of tools, combined with best-practice knowledge in designing and optimising the systems these are used to implement. I have a proven track record of successfully delivering complex end-to-end OLAP based solutions across a variety of sectors, including Financial Services, Asset Management, Media, Government, and Property. I have been recognised on a number of occasions by various employers for outstanding achievement and commitment, including ‘Employee of the Quarter’ whilst working as Technical Lead on a multi-million pound project at HM Treasury. I have previously spent time as a ‘guest’ Microsoft employee, working as a technical liaison between MS and a top Microsoft Gold partner. A key strength I bring to any employer is I have substantial experience not only developing solutions, but also using them in an analytical capacity to drive decision-making and ultimately increase profitability. I can therefore bridge the sometimes difficult communication gap between I.T and the wider business.
I am an active member of the Microsoft SQL Server and BI communities, regularly attending usergroup meetings and conferences. I keep up to date with the latest developments in the industry via respected internet blogs and news sites. I also enjoy studying for further certifications to broaden my subject knowledge. I recently completed a short course in ‘Object Oriented Programming Using C#’, and am currently embarking on an online ‘Data Science’ course. This combines standard database principles with statistical modelling and so-called ‘Big Data’ technologies.
Business Intelligence & Analysis Consultant @ From March 2015 to Present (10 months) London, United KingdomDirector @ I work as a freelance Microsoft BI / DW consultant and developer, predominantly in and around the London area. From August 2011 to Present (4 years 5 months) London, United KingdomBusiness Intelligence / Data Warehouse Consultant @ BI team lead on a multi-million pound Europe-wide reporting and planning project, utilising the entire SQL Server 2012 stack. Architected, designed and led the development of a Kimball style data warehouse, now the sole source of reporting for both the wholesale and retail channels of the European business. Data volumes for the ‘planning’ component of the data were very large (hundreds of millions of rows), which necessitated a well thought out and highly tuned ETL subsystem. This was further enforced by the requirement for rapid intra-day refreshes of the data. Reporting output was achieved via two multidimensional OLAP cubes sitting off the DW. These were used to deliver all the business logic, including over 200 metrics. Output was achieved via Excel pivot tables, Excel dashboards, and SSRS. Query performance of these outputs was paramount to the users, and due to the volume of the data and the complexity of the business logic, tuning the structure and the MDX was a difficult and involved exercise. From June 2013 to March 2015 (1 year 10 months) London, United KingdomBusiness Intelligence / Data Warehouse Consultant @ I worked on an SQL Server 2012 DW/ETL design and build project to hold UK and international advertising sales data (online and offline) from the client's transactional booking system. I also integrated budget data sourced from an implementation of Hyperion Financial Planning (Oracle back-end). Front end delivery was initially achieved via Qlikview (external consultancy), but then extended to SSAS by myself with the aim of increasing penetration. The SSAS solution was extremely well received by the business, with hundreds of active users within the various Finance and Sales teams. I also devised and implemented a Data Governance framework using Master Data Services, whereby Data Stewards could maintain some dimension attributes via Excel. I was additionally tasked with building a prototype to extract traffic data from Google Analytics for the various websites throughout the business. From June 2012 to May 2013 (1 year) London, United KingdomBusiness Intelligence / Data Warehouse Consultant @ I led an internal team of four developers, with responsibility for delivering a first class Business Intelligence capability to the entire business. This involved maintaining the existing BI estate, whilst developing a new EDW (SQL Server 2008R2) to replace it. I successfully delivered stage one of this project, bringing in all financial information from an implementation of ‘JDE Enterprise One’ ERP software. This gave users a much improved capability to manage profitability, and was regarded as invaluable by users. Front end delivery was achieved via a suite of dashboards and reports accessed through Sharepoint. These were built using a variety of technologies, (SSRS / Performance Point Services / Excel Services), which sourced data both from the EDW and SSAS cubes. I additionally initiated a number of POCs to demonstrate BI features such as map-based reports, and PowerPivot based dashboards served through Sharepoint. These were well received by users, and were to be incorporated into the next stage of the project. From August 2011 to May 2012 (10 months) London, United KingdomSenior Business Intelligence Consultant @ I was Technical Lead on a number of complex BI initiatives (see B&D assignments below). I was Awarded ‘Employee of the Quarter’ for work done at HM Treasury, and was a key member of teams which won the ‘Quarterly Team Award’ on two occasions. I was selected to be a ‘guest’ Microsoft employee, acting as a liaison on behalf of the business. This involved giving demonstrations of the full BI stack (including Sharepoint) to prospective clients, being seen as a technical expert who could answer any queries around specific requirements and functionality. One such demo directly led to B&D being awarded a large contract at Aviva Investors. From March 2010 to August 2011 (1 year 6 months) London, United KingdomTechnical Architect / Lead Developer @ Consulting Assignment for Business & Decision
I architected and built an end-to end SQL Server 2008 solution to enable analysis/reporting on the contents of Activity Based Costing models built using the SAP Financial Planning tool. The datasets contained over 2 billion records, requiring all my expertise to deliver highly performing ETL and OLAP cubes given the hardware available. Reporting requirements also necessitated complex MDX to generate the output required by the users. The final solution was delivered on time and on budget, and exceeded all of the client's expectations. It was successfully scaled out to all Account Managers business-wide, and also utilised internally within the Finance department. From February 2011 to July 2011 (6 months) London, United KingdomLead BI Developer @ Consulting assignment for Business & Decision
I assisted Aviva Investors with the design and development of a solution to integrate data from a number of disparate data sources across the business into a central repository (effectively an Inmon Data Warehouse). This was then used as a source to populate a Strategic MI dimensional data mart, which was delivered to users across the business via Excel and bespoke SSRS reports, feeding from a number of SSAS cubes. From October 2010 to February 2011 (5 months) London, United KingdomTechnical Lead @ Consulting Assignment for Business & Decision
I was the Technical Lead of a six person B&D development team, subcontracted by PWC and working alongside a wider project team of around twenty people comprising various Project Managers, Technical / Solutions Architects, Business Analysts and Testers. The project remit was to design and build a solution to allow reporting and analysis on the approximately £230bn of risky RBS assets that were effectively being insured by the UK government.
I was initially responsible for liaising with key stakeholders to understand system requirements, managing expectations in line with the tools available. I devised the eventual schema design, and led the ETL team in building the solution within a challenging timeframe. I carried out all SSAS design and development, working closely with members of the Investment Management and Risk teams to understand their complex requirements. I additionally coordinated between the development and testing teams, taking ownership of issues in order to get them swiftly resolved. I was ultimately seen as the technical expert, offering advice on all aspects of database / BI development. From March 2010 to September 2010 (7 months) London, United KingdomAnalysis & Business Intelligence Manager @ I managed a combined team of developers and analysts, delivering both tactical and strategic BI solutions that resulted in a step change in how data was used within the company. I also heavily utilised these OLAP systems to analyse business performance and present findings to decision-makers right up to director level. I conceived, designed and led the development of an EDW, bringing together terabytes of data covering the Finance, Marketing and Credit Risk functions. I also trained personnel across the company on all aspects of database / BI development and utilisation. I was recognised on two occasions for my outstanding contribution to the business. From February 2006 to March 2010 (4 years 2 months) Bradford, United KingdomLeading Weapons Engineer @ An initial three-year apprenticeship, resulting in selection for a much sought-after position of section leader. I had full responsibility for upkeep, reliability and availability of a range of electrical / electronic and computer equipment. From September 1996 to June 2002 (5 years 10 months)
2:1, Electrical & Electronic Engineering @ Sheffield Hallam University From 2002 to 2005 HND, Electrical & Electronic Engineering @ Royal Navy From 1996 to 1999 HNC, Engineering @ Royal Navy From 1996 to 1999 David Lindley is skilled in: Business Intelligence, Data Warehousing, Microsoft SQL Server, ETL, Analysis Services, MDX, Databases, Dimensional Modeling, SSRS, SSIS, Tableau, Data Modeling, T-SQL, OLAP, BIML
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension