Nick Appleby

Nick Appleby Email and Phone Number

I do stuff with data @ Ardonagh Specialty
london, greater london, united kingdom
Nick Appleby's Location
Greater Norwich Area, United Kingdom, United Kingdom
Nick Appleby's Contact Details

Nick Appleby personal email

n/a
About Nick Appleby

Experienced IT professional across several disciplines including Business Intelligence, Data Visualisation,database design, performance and optimisation. Experienced in both supplier and customer engagement.Recognised as Subject Matter Expert (SME) for Power Bi. Strong Extract, Transform, and Load (ETL) skills with a good knowledge of data warehousing concepts including Kimball methodology.Positive communicator with the ability to translate non-technical customer requirement into technical design and to explain the technical in non-technical language. Continuous seek to develop my technical skills using MS Learn & ESA and other online resources. Goals: Make it right, make it simple, make it work, make it save time and or money.

Nick Appleby's Current Company Details
Ardonagh Specialty

Ardonagh Specialty

View
I do stuff with data
london, greater london, united kingdom
Employees:
15
Nick Appleby Work Experience Details
  • Ardonagh Specialty
    Lead Data Engineer And Architect
    Ardonagh Specialty Dec 2023 - Present
  • Ed Broking Llp
    Business Intelligence Architect
    Ed Broking Llp Sep 2021 - Dec 2023
  • Willis Towers Watson
    Bi Architect
    Willis Towers Watson Jun 2019 - Sep 2021
    Ipswich, United Kingdom
    BI Architect responsible for E2E BI architecture within CRB client platform technologies and analytics function. Additionally CRB segment wide Power BI architecture. Creating BI design patterns following cloud first paradigm, including scaling and cost management. Creation of Pbi auditing functionality using appropriate management APIs. Rapidly increasing hands on knowledge of ELT using Azure Data Factory including interaction with ADLS and Salesforce. All following Agile methodology within MS Azure Dev Ops.
  • Willis Towers Watson
    Bi Delivery Lead
    Willis Towers Watson Apr 2017 - Jun 2019
    Ipswich, United Kingdom
    Lead BI delivery team across multiple geographies for both projects and BAU. Service transition and support. Continuation of hands on development for strategic solutions. Solution and technical architecture. Database design and infrastructure scoping\capacity planning. Engineering and automation of legacy manual business processes.
  • Willis Towers Watson
    Analytics Model Development Specialist
    Willis Towers Watson Dec 2015 - Apr 2017
    Ipswich, United Kingdom
    Database optimisation, physical structure & storage. Oversight of 3rd party supplier's solutions. Recommendations for improvements. Data movement for tactical initiatives.
  • Willis
    Senior Mi Developer
    Willis Aug 2014 - Nov 2015
    Ipswich, United Kingdom
    • End to end oversight and training for design and development of new enterprise wide data warehouse including financial, transactional and operational streams. • Documentation, coaching and mentoring team on best practice. • Member of Business Intelligence working group. • Recommendations on changes to MI Strategy from initial data source to presentation layer.• Development and upgrading of existing relational data warehouse design & related ETL process.• Error identification and rectification within poor performing processes, identification of redundant code within reports and recommendations for improvement.• Definition and action of both Unit and System testing on all reporting deliverables • Facilitate the implementation of the final solution into the production environment. • Document new reporting capabilities to facilitate the handover to the maintenance function where applicable.• Work with analysts to ensure an appropriate design which meets the client’s needs, in line with MI strategy. • Design and development of auditing for SSRS and SharePoint outputs.
  • Aviva Plc
    Innovation Consultant \ Business Intelligence Developer.
    Aviva Plc May 2012 - Jun 2014
    Norwich, England
    Main UK point of contact\ technical reference to team of 10+ offshore MS SQL developers including 10 days in India mentoring and coaching the team which has enabled sign off of their self sufficiency for BAU activity. Platform SME for Aviva UK & Ireland MS Reporting Services (2005) instance with approximately 1500 executions per day. Duties include performance monitoring of SSRS platform and identification of bottle necks followed by optimization. Performance tuning and optimization of ETLs. Recommendations for server\db upgrades including E2E PM for new MI database setup for Shared Service function to remove legacy reporting dependency on application DB. This included data modelling, DB capacity estimation for year 1-2 growth, Introduction of new staging DB. Trouble shooting for C# web applications and associated application DB layer. Additionally I have been developing MS SQL server 2012 solutions (SSAS, SSRS and SSIS) in sandboxed environment.
  • Aviva Plc
    System Designer
    Aviva Plc Oct 2011 - May 2012
    Norwich, United Kingdom
    Data Warehousing Systems Design. Design of ETL processes using Informatica for a large scale finance date warehouse within Aviva life.
  • Aviva
    Data Asset Development Consultant (Ms Bi Developer)
    Aviva Nov 2007 - Dec 2011
    • Analysis and development of SSRS reporting for All Aviva UK telephony reporting, both historic and intraday. • Telecoms ETL package with associated outputs to partners. Extraction from third party data server with load to Aviva in excess of 1 million rows per day. This includes agent and call data for all IPCC based UK contacts. Approximate run time of 20 mins. • Produced ETL Development Standards documentation for dynamic connections to secure data assets. Both within Aviva and 3rd party assets.• Development of Contact centre service level reporting package including sms functionality (reducing 30 to 40 minute manual process to <1 minute automated process.•Promotion and exploitation of internal telephony reporting database to provide and support a single version of the truth across Aviva UK.• Rebuild of historic DTS/SSIS packages to vastly increase their efficency and decrease run time. Where run time has been increased this has been due to the removal of large quantities of legacy post ETL MS access processing. • Creation of Web tool to enable database lookup tables to be updated via a user friendly GUI.• Migration and merger of legacy SQL 2005 32bit databases into 64bit clustered environment.
  • Aviva
    Telephony Management Consultant
    Aviva Feb 2003 - Nov 2007
    Config of Cicso IPCC call routing systems for Aviva , 5000+ Agents approx 150k+ phone contacts per day. Intergration of Cicso IPCC/ICM with Verint I360 Workforce managerment software

Nick Appleby Skills

Databases Etl Data Warehousing Cisco Icm Business Analysis Microsoft Power Bi Business Intelligence Sql Server Management Studio Microsoft Sql Server Ssrs T Sql Ssis Analysis Telecommunications Systems Data Modeling Data Migration Sql Requirements Gathering Access Software Documentation Database Design Requirements Analysis Performance Tuning Sql Tuning Dts Sql 2014 Column Stores Table Partitioning Indexing Ssisdb Sequal Eclipse Sql Server Integration Services

Nick Appleby Education Details

  • West Herts Collage
    West Herts Collage
    Business And Finance

Frequently Asked Questions about Nick Appleby

What company does Nick Appleby work for?

Nick Appleby works for Ardonagh Specialty

What is Nick Appleby's role at the current company?

Nick Appleby's current role is I do stuff with data.

What is Nick Appleby's email address?

Nick Appleby's email address is ni****@****son.com

What schools did Nick Appleby attend?

Nick Appleby attended West Herts Collage.

What skills is Nick Appleby known for?

Nick Appleby has skills like Databases, Etl, Data Warehousing, Cisco Icm, Business Analysis, Microsoft Power Bi, Business Intelligence, Sql Server Management Studio, Microsoft Sql Server, Ssrs, T Sql, Ssis.

Not the Nick Appleby you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.