$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
strong analytical and organisational analyst specialising in Microsoft Office automation
Mike Platten
,
Stoke Gifford, United Kingdom
Experience
Other titles
Skills
I'm offering
An approachable individual with strong analytical and organisational skills allied with a practical stance and enthusiasm to make things happen
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2006 - ?
job
Partner
Classic Connections.
• Everyday management of the business as well as strategic decision making.
• Designed and implemented a database using Access for the business in which I am a partner.
• Production and analysis of reports showing the effectiveness of advertising campaigns for my business.
• Trend analysis for various aspects of my business.
• Produce Profit & Loss accounts and complete the partnership tax return for the business in which I am a partner.
• Designed and implemented a database using Access for the business in which I am a partner.
• Production and analysis of reports showing the effectiveness of advertising campaigns for my business.
• Trend analysis for various aspects of my business.
• Produce Profit & Loss accounts and complete the partnership tax return for the business in which I am a partner.
Advertising, Database, Management, Production
2020 - 2020
temp
Stock Take Analysis Team Leader
IVC Evidensia.
• Lead a team of 7 stock take analysts collating and analysing stoke take data from the companies 450 mainland Europe branches.
• Automate the collation of branch data into individual Excel workbooks by country
• Organise the daily workflow of the team
• Take part in team and management meetings.
• Automate the collation of branch data into individual Excel workbooks by country
• Organise the daily workflow of the team
• Take part in team and management meetings.
Excel, Management, Workflow
2019 - 2020
temp
HR Reward Data Analyst/VBA Developer
Dyson.
• Automate the production of salary review spreadsheets for distribution to Managers and the aggregation of those spreadsheets into a single master spreadsheet once individual workbooks reviewed.
• Create various reports and analysis of Bonus and pay data for senior management.
• Create various reports and analysis of Bonus and pay data for senior management.
VBA, Management, Developer, Analyst, Production, Bonus
2019 - 2019
temp
Business Data Analyst
Bank of America.
• Automate the gathering and presentation of data to European Central Bank (ECB) re Bank of America's new Irish entity for review of asset quality within Wholesale Credit using Excel and Word.
• Clean and organise the data from various bank systems to achieve the above.
• Manage SharePoint lists and forms to gather data to track the progress of the project
TSB MI Analyst/Business Analyst (Contract) December 2018 to End of March 2019
• Analyse and redesign the current MI reportage process within the customer rectifications area of TSB.
• Design and create an Access database and associated Excel spreadsheets to aggregate the data required to produce accurate MI.
• Automate the above process to reduce time spent by the management who currently produce the MI on a monthly basis using manual methods.
• Create new dashboard incorporating rectification data from the whole of TSB
• Clean and organise the data from various bank systems to achieve the above.
• Manage SharePoint lists and forms to gather data to track the progress of the project
TSB MI Analyst/Business Analyst (Contract) December 2018 to End of March 2019
• Analyse and redesign the current MI reportage process within the customer rectifications area of TSB.
• Design and create an Access database and associated Excel spreadsheets to aggregate the data required to produce accurate MI.
• Automate the above process to reduce time spent by the management who currently produce the MI on a monthly basis using manual methods.
• Create new dashboard incorporating rectification data from the whole of TSB
Design, Excel, SharePoint, Database, Word, Management, Reportage, Analyst, Redesign, Wholesale
2018 - 2018
temp
Data Analyst
University of Bristol Business.
• Performing User Acceptance Testing on a new Workflow Administration System for the University Vet school.
• Gap analysis of system for senior stakeholders.
• Producing user documentation.
• Creating automated system to gather and import timetabling data into the new system using Excel and VBA.
• Gap analysis of system for senior stakeholders.
• Producing user documentation.
• Creating automated system to gather and import timetabling data into the new system using Excel and VBA.
Excel, Administration, VBA, Workflow, Analyst, Testing, Performing
2017 - 2018
temp
EUC Specialist/Developer
Hiscox Insurance.
Initial 3 month contract role renewed several times)
• Organising and executing the transformation of EUCs into a standard format as part of the wider Finance Transformation programme
• Enhancing or recommending enhancements to the EUCs converted to the new format by automating various processes using VBA.
• Gathering requirements for the enhancement of EUCs
• Organising with the various business units when they will release the EUCs to allow for transformation and organising UAT.
• Tracking progress of project.
• Organising and executing the transformation of EUCs into a standard format as part of the wider Finance Transformation programme
• Enhancing or recommending enhancements to the EUCs converted to the new format by automating various processes using VBA.
• Gathering requirements for the enhancement of EUCs
• Organising with the various business units when they will release the EUCs to allow for transformation and organising UAT.
• Tracking progress of project.
VBA, Finance, Developer, Transformation, Processes
2016 - 2016
job
Business Analyst
Lloyds Banking Group.
(Contract to cover end of project as previous incumbent left due to health reasons)
• Risk assessment of existing EUC database with recommendations on how to mitigate risks once contractor resource no longer available.
• Define and manage user acceptance testing (UAT) of new database
• Enhancing and testing existing Access database front ends.
• Training permanent members of staff in VBA, SQL and Access to enable them to troubleshoot or amend current Access databases once contractor resource is no longer available to provide support.
• Develop new MI reporting for existing HR Benchmarking database.
• Building scripts to extract specific data from within large datasets, anonymising that data where appropriate for use with executive pay and reward analysis.
• Risk assessment of existing EUC database with recommendations on how to mitigate risks once contractor resource no longer available.
• Define and manage user acceptance testing (UAT) of new database
• Enhancing and testing existing Access database front ends.
• Training permanent members of staff in VBA, SQL and Access to enable them to troubleshoot or amend current Access databases once contractor resource is no longer available to provide support.
• Develop new MI reporting for existing HR Benchmarking database.
• Building scripts to extract specific data from within large datasets, anonymising that data where appropriate for use with executive pay and reward analysis.
Sql, Training, VBA, Database, Support, Analyst, Assessment, Testing, Health
2014 - 2016
job
Data Analyst/Database Developer
HSBC.
(Initial 3 month contract role renewed several times)
• Capture requirements for database enhancements and upgrades.
• Convert existing Access databases to SQL server 2008 whilst retaining the Access front end, amending VBA to accommodate the change in the back end tables to SQL Server.
• Analyse and combine data from various systems to produce letters to send to customers regarding reviews of potential product mis-sales.
• Create Access databases using VBA, SQL and Access to record the results of business reviews after eliciting requirements from the business.
• Maintain existing Access databases used in the recording of various business reviews updating and enhancing using VBA and SQL as required.
• Produce ad hoc management information using various Access databases, VBA and SQL.
• Capture requirements for database enhancements and upgrades.
• Convert existing Access databases to SQL server 2008 whilst retaining the Access front end, amending VBA to accommodate the change in the back end tables to SQL Server.
• Analyse and combine data from various systems to produce letters to send to customers regarding reviews of potential product mis-sales.
• Create Access databases using VBA, SQL and Access to record the results of business reviews after eliciting requirements from the business.
• Maintain existing Access databases used in the recording of various business reviews updating and enhancing using VBA and SQL as required.
• Produce ad hoc management information using various Access databases, VBA and SQL.
Sql, SQL Server, VBA, Database, Management, Sales, Developer, Analyst, Server, Sql server 2008
2012 - 2014
job
Business Analyst
Friends Life.
• Organise and manage the compliance testing of all Friends Life finance EUC (End User Computing) applications
• Requirements gathering for system enhancements for both small scale changes and major updates.
• Create both functional and non functional documentation for database systems.
• Develop and enhance an existing database used by Friends Life to monitor all finance reconciliations throughout the business, merging two existing Access databases and converting the back end to SQL server.
• Writing scripts within the GroupIT application to bulk reconcile multiple Friends Life bank accounts so that the reconciliation function could be transferred from the current application (Accurate).
• Requirements gathering for system enhancements for both small scale changes and major updates.
• Create both functional and non functional documentation for database systems.
• Develop and enhance an existing database used by Friends Life to monitor all finance reconciliations throughout the business, merging two existing Access databases and converting the back end to SQL server.
• Writing scripts within the GroupIT application to bulk reconcile multiple Friends Life bank accounts so that the reconciliation function could be transferred from the current application (Accurate).
Sql, Writing, SQL Server, Database, Finance, Compliance, Analyst, Testing, Server
2011 - 2012
job
Business Analyst
AXA plc.
* Organise and manage the compliance testing of all AXA plc finance EUC (End User Computing) applications.
* Creating an automated tracking system for AXA to control testing of EUC (End User Computing) applications using Excel and VBA.
* Creating an automated tracking system for AXA to control testing of EUC (End User Computing) applications using Excel and VBA.
Excel, VBA, Finance, Compliance, PLC, Analyst, Testing
My education
2001
-
2004
Open University
Unspecified, Computing
Unspecified, Computing
Chartered Institute of Bankers Stage 2
Associate, Accountancy
Associate, Accountancy
Chartered Institute of Bankers Stage
Associate, Exams
Associate, Exams
n/a
Secondary, Computer Science
Secondary, Computer Science
Mike's reviews
Mike has not received any reviews on Worksome.
Contact Mike Platten
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Mike directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark