Gavin Mcilreavy

FAQ About Gavin Mcilreavy

• What is Gavin Mcilreavy's address?

  Gavin Mcilreavy is located at
  Kingston upon Thames, England, United Kingdom

• What is Gavin Mcilreavy's job title?

  Gavin Mcilreavy is a
  Currently delivering for Asda, but previously a highly experienced Database Analyst with expertise gained within the Financial services and across all Microsoft Office products. • In depth knowledge of project management and test frameworks. • Advanced user experience of: MS Excel including advanced formulas and macros, pivot tables, formatting and conditional formatting. • Access: including advanced queries, macros, multi table queries, parameter queries. • VBA Expert, skilled in programming Access to communicate accurately with Outlook, Excel and Word, using Visual Basic coding. • Experience in delivering best practice MI solutions (e.g. highlight reports, management dashboards). • Good problem solving and analytical skills. • Web writing via FrontPage • Visio flowcharts • Recently completed the MCSA – SQL Server 2016 Database Developer course with Firebrand. CAREER Mercer Database Administrator/Analyst 2001 -2017 Technical support for a small research team, providing up to date product information to sales consultants throughout the UK, within the pensions market. My main responsibilities are the design, development and distribution of an MS Access 2010 database and the development of supporting MS Excel spreadsheets. Example Deliveries • Automating processes – Used Excel to create processes which turned 15 minute jobs into 2 minute automated tasks • Access - By use of multiple hidden forms, lines and boxes I was able to create a form in Access that mimicked an Excel tabular workbook. • Created an Investment Fund search screen (using the workbook format) also created pie charts showing the distribution of sectors within the fund range search. • Created forms that allow users to browse through Powerpoint presentations and meeting notes, and allow users to open online documents from within the database. Addition roles: • Hardware installation and support (PC’s, laptops and printers) • Software installation and support (Microsoft Office suite) • PC builds (Ghosting) Mercer

• What industry does Gavin Mcilreavy currently work in?

  Gavin Mcilreavy currently works in the
  Mercer

• What is Gavin Mcilreavy's area of expertise?

  Gavin Mcilreavy specializes in
  Currently delivering for Asda, but previously a highly experienced Database Analyst with expertise gained within the Financial services and across all Microsoft Office products. • In depth knowledge of project management and test frameworks. • Advanced user experience of: MS Excel including advanced formulas and macros, pivot tables, formatting and conditional formatting. • Access: including advanced queries, macros, multi table queries, parameter queries. • VBA Expert, skilled in programming Access to communicate accurately with Outlook, Excel and Word, using Visual Basic coding. • Experience in delivering best practice MI solutions (e.g. highlight reports, management dashboards). • Good problem solving and analytical skills. • Web writing via FrontPage • Visio flowcharts • Recently completed the MCSA – SQL Server 2016 Database Developer course with Firebrand. CAREER Mercer Database Administrator/Analyst 2001 -2017 Technical support for a small research team, providing up to date product information to sales consultants throughout the UK, within the pensions market. My main responsibilities are the design, development and distribution of an MS Access 2010 database and the development of supporting MS Excel spreadsheets. Example Deliveries • Automating processes – Used Excel to create processes which turned 15 minute jobs into 2 minute automated tasks • Access - By use of multiple hidden forms, lines and boxes I was able to create a form in Access that mimicked an Excel tabular workbook. • Created an Investment Fund search screen (using the workbook format) also created pie charts showing the distribution of sectors within the fund range search. • Created forms that allow users to browse through Powerpoint presentations and meeting notes, and allow users to open online documents from within the database. Addition roles: • Hardware installation and support (PC’s, laptops and printers) • Software installation and support (Microsoft Office suite) • PC builds (Ghosting)

• Which languages does Gavin Mcilreavy speak? 

  Gavin Mcilreavy speaks the following languages:
  No languages available.

• Which industries has Gavin Mcilreavy previously worked in?   

  Gavin Mcilreavy has prior experience in the following industries:
  Mercer

• What is Gavin Mcilreavy’s work experience?  

  Gavin Mcilreavy has the following professional experience:
  Mercer , Mercator Trustees Ltd , Mercer .

• How can I find Gavin Mcilreavy on LinkedIn?  

  You can view Gavin Mcilreavy’s
  LinkedIn profile at LinkedIn URL.

• What are Gavin Mcilreavy’s work email addresses?  

  Gavin Mcilreavy’s work email addresses are
  [email protected] .

• What company does Gavin Mcilreavy work for?  

  Gavin Mcilreavy works at
  Mercer