Paul Allen Email & Phone Number

Manchester, England, United Kingdom

I have delivery responsibility across three teams (30+ employees) regarding the provision of reporting primarily using SQL Server. The data estate & data volumes are vast (petabytes) and we distribute 100’s of reports on a daily basis. I am involved in the planning, progress updates and execution of multiple projects & requests that are often complex and have aggressive delivery dates. Within my role I contribute to how we can increase efficiency of operations from a development methodology and process approach in addition to employee performance, skill development & knowledge.

Manchester Area, United Kingdom

#Responsible for the coordination, organisation, reporting & delivery of projects / requests within my functional remit. This includes the authorisation of changes into the Live environments, ensuring that expectations & standards have been met.#Attend & participate in project meetings; providing updates, input & air concerns when required.#Manage the team (a mix of permanent & contract), providing instruction, guidance, mentoring, support, development & absence management. #Involved in shortlisting, interviewing and making offers for vacancies within the team. Onboard staff as required.

Manchester, United Kingdom

# Management of a single & multi-disciplined team responsible for the development of bespoke applications across multiple products throughout the business. This covers the full stack from data to presentation, including reporting and integrations and entails both Project and BAU / Reactive work.# Oversee, manage and allocate work stack throughout the team that is responsible for the scoping, requirements capture, design, development, testing & deployment.# Define, improve, refine and communicate development processes to provide greater visibility to the business to reduce development lifecycle & rework. # Performance management of the team, supported by technical leads, ensuring job descriptions are accurate, setting & tracking of objectives, which in turn influences bonus payments.# People strategy & welfare of the team including progression, retention and recruitment.# Hands on with SQL development & integrations, incident management, BAU / Reactive work.# Input into the wider department and operations function re: ideas, initiatives and improvements.

Manchester, United Kingdom

# Management of the Data & Analytics team responsible for ongoing development & stabilisation of the DWH and reporting databases. This involved both delivery & people management. # Implementation of new & changed data sources.# Oversee and coordinate project work and ad hoc data requests.# Database development and maintenance activity across SQL estate.

Bolton, United Kingdom

#Deputise in the absence of the BI Manager to coordinate activity of a 10-person team, prioritising and dealing with urgent work and escalations and ensuring that a 1st class service is being delivered to our customers. #Attend when required meetings with the Senior IT Leadership Team.#Shortlist candidates where new openings arise within the team, conduct interviews and make the recruitment decision.#Provide technical support and mentorship of the team in addition to driving standards.#Involved in core technical strategy and approach.#Active and hands on BI Developer, building data sets, delivering reporting solutions and providing ad-hoc data requests.Achievements and Highlights @ Keoghs LLP#Integration of acquired businesses MI Infrastructure involving the extraction, transformation, load, testing, validation and distribution of reporting output. #Building of a new data platform within SQL Server 2016 consisting of a centralised repository, reporting layer and data consumption via SSRS, PowerBI and extranet. #Delivered Data Quality Pilot throughout firm using PowerBI, presented to the COO for investment, produced training video and feedback site.

Bolton, United Kingdom

In addition to my Development responsibilities, approximately 40% of role focused on:# Responsibility for the welfare, performance management, personal development, absence management and the delivery of organisational updates of a diverse and multi discipline team of 8 via 121s and monthly meetings.# Onboarding and probation management of New Starters.# Monthly meetings with the Senior IT Leadership Team.

Bolton, United Kingdom

#Lead SQL Database Developer (SQL 2008 R2) within project responsible for all areas of system design, development and implementation. Produces robust and efficient code ensuring minimal defects enter the live environment. Delegates to and supports colleagues ensuring that sufficient and appropriate documentation is available.#Removal of technical debt via data fix scripts and new development. #Production of reports using SSRS and ETL packages using SSIS and SQL Server Job Agent. #Support of live systems dealing with issues promptly and professionally ensuring internal policies and practices are adhered to. Proactivity communicates to affected parties. #Fully active and embracing of the agile methodology contributing to all ceremonies and having excellent relationships with the team and stakeholders. Manages own workload effectively. Achievements and Highlights @ Keoghs LLP#Designed, developed and documented nightly one way data replication and on demand two way synchronisation between differing database schemas utilising SQL change tracking. Developed repeatable template for required objects and added in depth control and auditing measures.#Developed data extraction and zip file generation of deltas to a case management system (Visual Files) which is fully configurable by client and product. #Effectively continued the development of advanced data matching logic using SQL and XML following the departure of the SQL Contractor who developed the mechanisms. #Managed the software and database components regarding the upgrade and server move of a core application (IBM IBase) that had been in a state of “In Progress” for a number of years. Drove the implementation processes and communicated concerns and oversights to the project team.#Design, development and implementation of advanced address matching solution to uniquely identify an address without human intervention.

Warrington, United Kingdom

#Requirement gathering with senior stakeholders defining metrics and KPIs.#Data extraction, transformation and load activities via SQL and SSIS.#Creation and modification of SSRS Reports from end to end development including optimisation.#BAU data requests, report distribution and support.#Impact assessment of changes within the business effecting current MI Process or opportunities for new.Achievements and Highlights @ TalkTalk#Definition and creation of a series of new reports delivered via SSRS regarding a new contact channel delivered via Salesforce. Engaged with project team from start to finish, identifying issues within platform and provided support once the process went live. Data analysed against existing datasets to provide consolidated reporting view.#Process rewrite and data enhancement relating to the core telephony reporting. Streamlined activities resulting in considerable process time and disk savings whilst minimising server load. Data enhancements enabled new analysis and subsequent call reductions.

Manchester, United Kingdom

#Creation of database objects including tables, views, stored procedures, functions and triggers adhering to design specification and best practices. Wrote ad-hoc scripts to fix data issues with consideration to the environment.#Analysed poor performing SPs and implemented corrective measures. Modified existing replication publications and implemented new publications / subscriptions if required. #Creation and modification of SSIS Packages ensuring that configuration and logging features are utilised. #Responsible for testing and documenting all new or modified code and SSIS Packages. Involving functional and unit testing ensuring that all tests could be re-run. Approved testing of colleagues. #Acted as Lead Developer on medium sized projects, specifying tasks, offering guidance, contributing to design decisions and ensuring that deadlines are met. Responsible for checking that necessary permits had been completed to the required standards before being released for approval. #Offered 3rd line support for code and replication issues.Achievements and Highlights @ TalkTalk#Developed a number of ETL packages to extract data from multiple platforms ensuring sufficient logging was implemented including data quarantining and reprocessing. #Worked closely within a small team to implement a range of new databases to support the launch of a new product. This involved working on the provisioning and product management. Responsible for pre data population and replication flows. This was a cross server multiple database platform.#Wrote pre-build, synchronisation, business rules, migration and notification scripts of 150k customer records from legacy systems to new. This involved closely working with the project, design and testing departments in addition to providing detailed deployment documentation. These scripts were subsequently reused for further migrations.

Coventry, United Kingdom

#Data warehouse, cube creation and modification.#Report requirement gathering, creation and publication.#Maintained and administered a collection of SQL 2000 and 2005 servers, ensuring that disaster recovery strategies were implemented, access privileges set, service packs applied and that performance was monitored and systems tuned where appropriate. #Configuration and installation of default or named SQL Server Instances.#Adhered to and managed change release and control procedures. Achievements and Highlights @ RICS#Lead Developer within a Business Intelligence project to identify a single view of our customer. Personally I designed, built and implemented a number of elements using SSIS and SSAS and worked closely with our external consultants. In addition I liaised with stakeholders, verified data accuracy and had involvement presenting the solution.#Responsible for creating and implementing a reporting solution for a core department using SSRS. I enforced a design template and managed new requests and modifications.

Coventry, United Kingdom

#Maintained, administrated, developed and supported a number of SQL Database applications.#Implemented, customised and trained employees on new software installations and upgrades. #Provided telephone and email support, training and documentation to all users.Achievements and Highlights @ RICS#Project managed the upgrade of a Facilities helpdesk system and involved with the IT upgrade defining functional and reporting requirements. Involved data import, screen design, business rule creation and user training. Reports created using SRRS and Crystal v10.#Project managed, designed, developed and implemented an online overtime system using existing HR system and integrated with Payroll. This streamlined processes, provided cost savings and enabled data analysis.

Bsc, Business Information Technology

A practical and hands on sandwich course that developed and enhanced ICT and personal skills. Modules focused upon analysing, designing.

Education record