Nick Appleby Email & Phone Number

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.

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.

Ipswich, United Kingdom

Database optimisation, physical structure & storage. Oversight of 3rd party supplier's solutions. Recommendations for improvements. Data movement for tactical initiatives.

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.

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.

Norwich, United Kingdom

Data Warehousing Systems Design. Design of ETL processes using Informatica for a large scale finance date warehouse within Aviva life.

• 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.
• 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.

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