gregory mcgrath

senior data and mi analyst

About

Key skills: - Advanced skills in Excel/Excel VBA (i.e. macros, complex formulae, pivot tables and other main features of Excel) and Access/Access VBA - Very high standard of skills in the rest of MS Office (Word, Visio, Powerpoint, Outlook including significant knowledge of VBA relating to these programs) - Ability to manipulate huge datasets, provide meaningful reports and analyse the results - Creation of flexible systems through which customised MI Report production is automated - Proficient in the use of the business analytics tool, Tableau - Good working knowledge and understanding of SQL - Excellent analytical skills with a high level of attention to detail - Degrees in IT (with Distinction), Law (with Distinction) and Accountancy

Country

united kingdom

City

city of edinburgh

Industry

banking

Skill

vba, microsoft excel, access, data analysis, stakeholder management, business analysis, analysis, sql, banking, visio, outlook, microsoft word, powerpoint, process improvement, business process improvement, visual basic for applications, excel dashboards, analytical skills

Experience

solicitor

watermans

2011-12 - 2013-6 · 1 yr 7 mos

* Responsibilities and key achievements included: * Personal Injury Court and case work relating to road traffic accident, industrial accident, occupiers' liability, public liability and product liability claims * Developed case management system using Excel/Excel VBA * Created customised MI reports from above case management system * Automated the creation of style letters and e-mail templates using Word, Excel and VBA

solictor

digby brown solicitors

2009-9 - 2011-11 · 2 yrs 3 mos

Responsibilities and key achievements included: - Personal Injury Court and case work relating to road traffic accident, industrial accident, occupiers' liability, public liability and product liability claims.

build analyst

royal bank of scotland

2005-12 - 2006-8 · 9 mos

* Responsibilities and key achievements included: * Installing, configuring and testing servers and workstations for test environments * Planning, setting up and modifying system environments for software testers * Verifying software packages to ensure they functioned correctly * Manipulating and analysing data relating to the above in spreadsheets

mi technical specialist and analyst

royal bank of scotland

2004-7 - 2005-11 · 1 yr 5 mos

* Responsibilities and key achievements included: * Designing automated systems which produced MI reports through Excel VBA * Design and creation of a RAG (Red, Amber, Green) report for the entire department in Excel through VBA, automating the extraction of data from approximately 25 files into an up-to-date daily summary of daily, weekly, monthly, quarterly and annual performance * Creation of the automated calculation and print-out of daily call statistics in Excel, reducing the manual completion time from around 20 minutes to less than 10 seconds * Automation of the creation of headcount/FTE reports and staffing rotas in Excel * Various ad hoc projects in Excel which were similar to the projects detailed above * Analysis of the department's performance data and recommendations thereupon

customer service officer

royal bank of scotland

2002-10 - 2004-6 · 1 yr 9 mos

* Responsibilities included: * Creating and maintaining performance spreadsheets with Excel VBA * Improving existing processes * Taking customer enquiries via phone

senior data and mi analyst

tesco bank

2013-7 - Present · 13 yrs 3 mos

Tesco Bank are part of Tesco PLC, the largest retailer in the UK and the third biggest retailer worldwide. So we know our customers.We are also the UK's most successful supermarket bank, and still growing. We bring simplicity to a sometimes overly complicated market and an approach that puts the customer firmly at the heart of everything we do. We aim to give our banking customers the same excellent value they have come to associate with Tesco stores - it's a fresh approach to banking and offers a fresh start both for our customers and for our staff.