David Connolly Email & Phone Number

Nottingham, England, United Kingdom

London, England, United Kingdom

Nottingham, United Kingdom

• Objective - Create a forecasting model to drive customer conversions to SMART meter.
• Reason - Supply the business an estimated £2+million saving per year on campaign and conversion costs, improved customer experience and meet OFGEM obligations.
• Data Modelling - SQL – Creation and definition of tables and data types, data sourcing and cleansing, migration of and manipulation of legacy data and creation of dimensions to allow for customisation of process.
• Data Modelling - SQL – Adding additional requirements into model process, with viability and impact assessments, build duration estimates, build and UAT of additional processes.
• Data Modelling – SQL – Disaster recovery process to rebuild dataset from generated reports in case of catastrophic data warehouse failure.
• Data Modelling – SQL – Creation of 26 week historical data set of 4.5 million customer base with weekly movements for use with excel business forecasting model.

Nottingham, United Kingdom

• Objective – Creation of SQL data sets to track customer journeys / contacts with business.
• Reason – OFGEM obligation to ensure all methods of contact are achieved with all customers with logical reasoning for methods used and when.
• Creation of customisable customer journeys in SQL, with justification of contact type, duration between contacts and impact this would have on changes to SMART meter installs.
• Interpretation of requested business logic on what “right looks like”, case study creation with presentation to stakeholders.
• Impact assessment of new Data Model on historical business processes and reports, including root cause analysis on number shifts that would occur throughout business and deep data to justification of impact.

Nottingham, United Kingdom

• Objective – Creation of new SQL data sets to hold SMART relevant information.
• Reason – OFGEM requirement to be able to accurately report on SMART meter progress.
• Scope, design, document, UAT and production of new data sets to meet OFGEM data requirements for business reporting utilising Oracle data servers.
• Optimisation and standardisation of existing reporting suite.
• Development of internal data sets to create efficient, standardised data sources for implementation across multiple business reports.
• Fact finding and data mining of existing data sets, with recommendations on improvements to methodology for implementations across business to improve data accuracy.

Sheffield, United Kingdom

• Creation of interactive MI Dashboard for visibility of new group project, through iterative, collaborative steps with data analysis and recommendations to determine correct MI model to employ.
• Ad-hoc report production from SQL server
• Quotation tool production, providing staff the ability to produceaccurate, update to date quotes incorporating margins, bespoke sales history and terms in use to provide a tailored competitive quote.
• Production of Daily, Weekly, Monthly reporting tool for auto production and distribution to stakeholders ranging from sales advisors through to MDs to allow accurate analysis to be undertaken to guide new business.
• Production of in house reporting tool to analyse Daily, Weekly, Monthly progress of ongoing project to assist in drive future project iterations and develop further business opportunities.
• Analysis of SQL holding data and integrity for Ecommerce project.

Derby

• Redesign of current MI Process, from basic business concept to full application.
• Liaising with worldwide divisional heads establishing reporting needs.
• Production of fully automated MI application within Excel, incorporating adaptability to incorporate complex and changeable data sets, with GUI setup for data management for report production. Including production of.
• Support for Legacy reporting system to improve current process.

Notitngham

Derby, United Kingdom

• VBA process for reconciliation of multiple large data sets to allow production of reports to monitor company migration to new Juniper solution.
• Bespoke VBA software solutions to perform an array of tasks such as Auto HTML Emailer program, data mining and collation for individual tailored reports of access transfer requirements, Survey setup and data.
• Production of Excel VBA GUI for replacement of Outlook forms to meet compliancy requirements with Office 365 migration.
• Setup of MI reporting system and dashboard to monitor migration and user requirements for Office 365 project within Excel
• Streamlining updating process of Office 365 migration database.
• Production of new leaver’s process to ensure databases are current, access removal requirements achieved and cross company billing is current to meet business compliancy.

Nottingham, United Kingdom

Derby, UK

• Production of end to end solution for transition to Microsoft Lync utilising Excel VBA. Full process requirements:o Setup of GUI for account setup / alternation / deletion, current state of install and ability to view.
• Estimate time saving of 30 minutes per user (23,000 hours) – total saving ~£250,000
• Set up of outlook forms with VBA coding for data capture and validation, allowing accurate standardised case requests with automated integration of company processes.
• Supporting 46000+ users across 120+ domains
• Clients including NHS, O2, DSA, Deutsche Bank, G4S, BAE, TV Licensing.
• RSA Administration – Setup of Active Token (PC/Blackberry/iPhone/Physical), Manual locking/Unlocking, Re-synchronising, PIN resetting and network resource access rights..

Nottingham, UK

• Independent design of Outlook VB form to reduce human error, increase work load efficiency and standardise information passed to third parties.
• Auto generation of standardised email to end-user and engineers.
• Task was undertaken due to my own desire to remove inefficiency in processes.
• Integration of Outlook VB form with access database, utilising SQL queries to allow integration of sharepoint data for case allocation to correct party with automation of notification to case allocation via email in.
• VBA to automate emails filing with essential information with agent accountability.
• Estimate of 300 email cases per day – Time saving 10 minutes per case ~ 50 hours per day. Saving ~ £120,000 per year.

Christchurch, New Zealand

o Selection and dispensing of spectacles including single vision, bifocal and varifocal lenses.o Independent assessment of store procedures leading to store reorganisation and improved store efficiency.o Excellent communication and customer service skills.o Complaint resolution and promoting ownership within the store.o Planning and implementation of new.

Nottingham, UK

• Set up of cross store VBA Excel database to track stock movements, orders and purchases.
• Training staff in the use of databases and website to progress business.
• Build PC’s to store requirements; component procurement, installation and maintenance.
• General store administration - stock checks and ordering, daily banking, sales reports, rota production, invoicing and sales trend analysis, glazing, repairs.

Nottingham, UK

• Setup of VBA Process for use within HR department for monitoring applications from internal and external candidates.
• Production of Excel team report sheets for performance guidelines and determination of training needs.
• Use of Excel to allow trend analysis and monitoring of statistical data
• Work within a high pressure environment with tight deadlines, assessing dynamic business requirements and pre-empting the rapid changing business needs to ensure processes and options are available to meet KPI’s and.
• Motivate employees to understand and meet the required business needs..
• Ability to multi-task complex problems and prioritise workloads.

Nottingham, UK

o Efficient logical diagnosis and repair of hardware faults.o Providing software support and troubleshooting for a variety products.o Use of MS office and Citrix software.o Excellent communication and customer service skills.o Provide second level support for other people within the team and business environment to resolve technical difficulties. o.