Karl Davis Email and Phone Number

I am responsible for the production of data though Development, Test and Production for all data held within the UK, Channel Islands, Ireland, Spain and Australia with equates to 44 main databases and 6 other Adhoc databases. I dynamically pull all this data together using SSIS and building load and executables tables held within SQL Server 2017. I introduced plug in events from Zappy Sys to deal with supporting data for migration to AWS S3 due to constraints with inhouse data and UTF8 formatted files which can be zipped under .gz format and read by S3 buckets and convert to parquet file format to optimize upload performance speeds as well as lower costs within the cloud. Using SSIS I also plug into live API’s such as currency conversions which runs every few hours in order to dynamically give the most accurate conversion rates at point of sale. I have created an on-premise data lake which is help is its rawest form and pushed data though staging and reporting databases to product true facts and dimensions that plug into Power BI for easier modelling and data manipulation.Although I am not fully working within the cloud, yet I have had full training from AWS directly and giving me knowledge of how to create S3 landing zones. Creating crawlers and glue jobs to push data between buckets for landing and production as well as data brew and pushing to final Redshift tables to be plugged into Power BI. I am currently working with 3rd parties AND Digital and Inawisdom around full cloud migration and creating dimensional models between on premise and the cloud.

I am currently responsible for the automation of data and the development of senior management dashboards through the use of T-SQL, SQL Server Reporting Services (SSRS) ,Qlik View amd Power BI. I am also responsible for warehousing and data modelling in order to make newly provided data available to the business. I design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. I am also responsible for the data pipeline and jobs to ensure there are no errors and all data is populated prior to 8am. I am currently learning the DBA role to enhance my own leaning in the structures and management of a SQL Server

● Delivering root cause analysis on request from Service Managers ● Ability to influence higher management for best practice. ● Advanced skills within Excel, including VBA, Word and Power Point. Intermediate Microsoft Access knowledge and an understanding of relationship databases within SQL. ● Liaising with other parts of the business to feedback relevant information in a timely manner, enabling me to change the customer’s expectations. ● Building of the KPI Trackers linked into the KPI reports which were rolled out to the business.

I was responsible for taking calls in the Customer Enquiries department, ensuring customers were given appropriate information and that this information complied with company agreed standards whilst hitting my own personal KPI targets.

Within this role, I was responsible for the building and production of Management Information reports for approximately 2000 employees on a daily, weekly and monthly basis, providing detailed analysis on Key Performance Indicators. I coached the Management Support Teams on practical use of Management Information and how to self-serve from other reporting suites. I was able to drive the efficiency of reporting and reduce complexity in day to day tasks, to allow for ad-hoc reporting and proactive analysis. I managed my allocated ad-hoc requests from senior management to meet strict Service Level Agreements. I travelled between the North East sites to proactively support the operation and give a hands-on approach to all levels of staff.

Main duties – Support the Prepayment Department to enhance performance, whilst working towards key performance indicators. I was able to motivate and build morale with new employees within the academy by floor walking. I dealt with complex issues and escalated them when required, providing support across the business from knowledge on product to polices. Achievements Include: ● Excellent communication skills, providing world class customer service to all audiences in coaching and team meetings. Comfortable using a variety of mediums including telephone, email and face to face ● Working on courses in the Learning Resource Centre on Microsoft Access databases. ● Time management ensuring deadline objectives are delivered, whilst aiming for key performance indicators. ● As a proactive, self-motivated individual, I was able to work on my own initiative and also as part of a team, to build performance and maintain good working relationships.

I was responsible for a team of 10 Customer Service Advisors, providing developmental feedback and coaching each individual to achieve maximum performance. I ensured personal development plans were kept up to date and monitored attendance and capability issues. I confidently took escalated calls relating to customers queries and complaints. I maintained high health and safety standards.

Main duties – Support the Prepayment Department to enhance performance, whilst working towards key performance indicators. I was able to motivate and build morale with new employees within the academy by floor walking. I dealt with complex issues and escalated them when required, providing support across the business from knowledge on product to polices. Achievements Include: ● Excellent communication skills, providing world class customer service to all audiences in coaching and team meetings. Comfortable using a variety of mediums including telephone, email and face to face ● Working on courses in the Learning Resource Centre on Microsoft Access databases. ● Time management ensuring deadline objectives are delivered, whilst aiming for key performance indicators. ● As a proactive, self-motivated individual, I was able to work on my own initiative and also as part of a team, to build performance and maintain good working relationships.