$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Experienced access vba systems builder.
Robert.Walmsley
,
Stoke on Trent, United Kingdom
Experience
Other titles
Skills
I'm offering
Outgoing personality, hard working either alone or in a team. Strong inter personal skills, I like cricket and football and marrying off my daughters! Good timekeeper, and hard working.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2018 - 2018
job
VBA Developer
unknown.
3 Ireland
I was brought in to assist with a server migration affecting the finance department, where all Excel workbooks and links needed to be checked and updated to new links. Successfully wrote the script to achieve this and produce statistical analysis of data.
I was brought in to assist with a server migration affecting the finance department, where all Excel workbooks and links needed to be checked and updated to new links. Successfully wrote the script to achieve this and produce statistical analysis of data.
Excel, VBA, Finance, Developer, Server
2013 - 2018
job
Access Business Systems Developer
RPS Clear Environmental Ltd.
Working for Clear seconded to Severn Trent Water initially to develop a tool (DIAMOND) to allow management of large data for consultants to update and or gather information. System nominated for Best Data Project at The Water Industry Awards. Now includes developing a system for pre tender by consultancies. Also other database requirements have landed with me. Initially written in Access 2007 VBA, now Access 2013 with various outputs to Excel. Also extensive Word, PDF, Tab, and Xls file interrogation and extraction of data.
Excel, Database, VBA, Word, Management, Developer, PDF, ME
2013 - 2013
job
Access Systems Developer
Formart Ltd.
Update to existing Predict system written for BOC/Linde. The system is a bespoke Work Study Time Management tool that allows instant and accurate measurement and prediction of time for tasks. This was an upgrade from Access 2000 to Access 2010. It also included adding outputs to Excel using VBA.
Excel, VBA, Management, It, Developer
2012 - 2013
job
Business Systems Developer Analyst
unknown.
RAC
Job specification includes creating management information for Accounts Receivable. This involves extracting data from two legacy accounting systems and merging data to produce debtor reporting for board and senior managers. Analysing ad hoc data from various data streams. Investigating revenue shortfalls between systems. I have developed new and upgraded existing systems to enable various departments within the business to streamline their work and make them more efficient. I am also the go to for any accounts receivable information and analysis. Involves extensive reporting in Excel using VBA.
Job specification includes creating management information for Accounts Receivable. This involves extracting data from two legacy accounting systems and merging data to produce debtor reporting for board and senior managers. Analysing ad hoc data from various data streams. Investigating revenue shortfalls between systems. I have developed new and upgraded existing systems to enable various departments within the business to streamline their work and make them more efficient. I am also the go to for any accounts receivable information and analysis. Involves extensive reporting in Excel using VBA.
Excel, VBA, Management, Developer, Analyst, Go
2010 - 2011
job
Business & Systems Expert
unknown.
npower
Brought in to take over maintenance of business critical access system. Normalised back end database and improved performance of user's front end. Commenced specification of new system for controlling heating installations, from writing functional spec to developing full integrated system. Also enhancing and babysitting smaller access databases. Currently working on developing three new systems for controlling costs and scheduling work. Took charge of development for npower new Solar PV installations, designing and creating a system that both acts as a quoting tool by remote sales people, and an in house front and where installations are managed. Fully responsible for the database design and the user interface. Also implemented upgrade from Access db to SQL Server db.
Brought in to take over maintenance of business critical access system. Normalised back end database and improved performance of user's front end. Commenced specification of new system for controlling heating installations, from writing functional spec to developing full integrated system. Also enhancing and babysitting smaller access databases. Currently working on developing three new systems for controlling costs and scheduling work. Took charge of development for npower new Solar PV installations, designing and creating a system that both acts as a quoting tool by remote sales people, and an in house front and where installations are managed. Fully responsible for the database design and the user interface. Also implemented upgrade from Access db to SQL Server db.
Design, Sql, Writing, SQL Server, Database, Database design, Controlling, Sales, Development, Server
2010 - 2010
freelance
Consultant Developer (short term)
unknown.
Abigem Turkey
Short term role developing a skills matcher system to locate relevant consultants and experts from cv's stored in a folder on the server. Written in Access 2003 and converted to Access 2007.
Short term role developing a skills matcher system to locate relevant consultants and experts from cv's stored in a folder on the server. Written in Access 2003 and converted to Access 2007.
Developer, Server
2009 - 2009
job
Senior Information Analyst
North Staffs PCT.
Working on PBC Data Packs producing Inpatient, Outpatient, and A & E data and graphs for publication to Clusters and Practices. Using data migrated from SUS data to summarise Elective and Non Elective data and First and Follow Up Outpatient data with statistical analysis. Data summaries from Access and Packs produced using Excel. Producing ad hoc charts and trends analysis on demand from Commissioning and GP's. Developed Drill Down Tool to allow Cluster's,Practice's, GP's, and Commissioning to view all data in detail, using Access.
Excel, Analyst, Detail, UP
2008 - 2009
job
Information Analyst
Gloucester Health Trust.
Analyst
2007 - 2008
job
Access developer/Data Analyst
Learning + Skills Council.
Contract to assist in migration of payroll from an old legacy system to Oracle. Involves writing queries and functions in an Access database, converting, and validating data to create tab delimited text files for exporting Payroll data to Oracle. Involves complex sql statements and some advanced Excel work. A lot of data analysis is required to get the correct data from the legacy system into Oracle. Writing exception reports to highlight data differences and anomalies. Creating reconciliation queries and functions to compare both old and new systems.
Sql, Excel, Data Analysis, Writing, Oracle, Database, SoMe, Developer, Analyst
2008 - 2008
freelance
Consultant Developer
Baobab IT Ltd.
Upgrade production (barcoded) system from Access 2003 to 2007 for uniform manufacturer based in Trinidad. System written previously in Access XP and 2003.
Main role is to create graphical displays of varying data and analyse and report on various trends, linear, average etc. Also a major task is to develop an Access front end to display graphical data and details on various types of data including Referrals, Outpatients, and Elective Non Elective spells, Waiting Lists for senior management and directors. Some ad hoc analysis production with a report explaining the data and trends.
Main role is to create graphical displays of varying data and analyse and report on various trends, linear, average etc. Also a major task is to develop an Access front end to display graphical data and details on various types of data including Referrals, Outpatients, and Elective Non Elective spells, Waiting Lists for senior management and directors. Some ad hoc analysis production with a report explaining the data and trends.
SoMe, Management, Developer, Production, XP
2007 - 2007
job
Access SQL Developer
MOD.
Join development team to create call centre software to monitor calls and allocate resources. Normalise database and rewrite forms. Top secret so cannot reveal details. Access 2003, including migrating Access backend to SQL. Involved taking raw data from text files and importing into Access database backend using functions created by myself.
October Migrate Access 2003 to SQL 2000 Capita Derby
Migrate Access 2003 back end to SQL 2000 to stabilise back end database with onset of thousands more records.
October Migrate Access 2003 to SQL 2000 Capita Derby
Migrate Access 2003 back end to SQL 2000 to stabilise back end database with onset of thousands more records.
Sql, Backend, Database, Developer, Development, Software, Backend, Derby
2007 - 2007
job
Access Developer - Financial
HSBC Rail Finance.
Upsizing numerous access databases from Access 97 to Access 2003. Collate all databases into one secure front end and allocate applications to users based on logon name. Implement enhanced functionality in order processing and financial management. Implement systems for reporting from Business Objects and CODA general ledger.
Management, Developer, Processing
2005 - 2005
job
Developer
NHS.
Derwent Shared Services Fleet and Logistics
Migrate existing Fleet Management system from Access 97 to Access 2002 with new reports in Access 2002 to specific customer requirements. Also involved migrating Excel from 97 to XP. Implement new Access functions to calculate Salary Deductions and update specific data where changes have occurred. Analyse data for any discrepancies with standards to enable internal audit. Mainly used Access reports, Queries, and VBA in Modules. Modify SQL tables to suit new functionality.
Migrate existing Fleet Management system from Access 97 to Access 2002 with new reports in Access 2002 to specific customer requirements. Also involved migrating Excel from 97 to XP. Implement new Access functions to calculate Salary Deductions and update specific data where changes have occurred. Analyse data for any discrepancies with standards to enable internal audit. Mainly used Access reports, Queries, and VBA in Modules. Modify SQL tables to suit new functionality.
Sql, Excel, Audit, VBA, Management, Developer, Audit, XP
2004 - 2005
job
Developer
Outsourcing Company.
Migrate system written Access 97 to Access 2002/2003, which is a timesheet entry and analysis system using extensive Calendar control and date based reporting. Updated to obtain data from a SAP system yet still utilise existing Access 2002 reports. Investigated opportunity to upgrade to a SQL backend in order to improve performance across the network.
Sql, Backend, SAP, Network, Developer, Backend
2003 - 2004
freelance
IT Consultant and Access developer
Chinal Management Ltd.
Developing a system for work study measurement for BOC PLC, using Access 2000 with an Access back end data base. Migrated Access 2000 to Access 2003, Involves a lot of complex calculations and user friendly interfaces. Calendar controls were used to allow easy selection of from and to dates. System will be used worldwide on completion. Installed at BOC in Guildford.
PLC, It, IT Consultant, Developer, Calculations
2004 - 2004
job
Access Developer
unknown.
Home Office
Developing existing Access 97 systems at the Home Office in Liverpool and developing from scratch a comprehensive Flexi Time system automated at system login, with comprehensive reports and email facilities. I was security cleared for this position.
Developing existing Access 97 systems at the Home Office in Liverpool and developing from scratch a comprehensive Flexi Time system automated at system login, with comprehensive reports and email facilities. I was security cleared for this position.
Security, Developer, Office
2003 - 2003
freelance
Access Developer and IT Consultant
Department of Health.
Contract work involving upgrading Access 97 and VB 5 systems to XP and VB 6 with an Oracle back end database. Included registry settings and recoding existing systems to look at registry and validate user information. Code rewrites to upgrade to XP using VBA and VB6. Based in London.
Started February 1999, Ongoing, to 2007 IT Developer. Derwent Shared Services (NHS)
Developed a complete system controlling and analysing fleet management for the NHS. Written in VBA Access 97 and recently migrated to a SQL 7 database. The data was migrated to SQL 7 database from the Access 97 backend database. 20-user system. Comprehensive reporting to NHS standards, including over 150 letters and reports in Access, enabling quicker and more impressive response to customers.
Started February 1999, Ongoing, to 2007 IT Developer. Derwent Shared Services (NHS)
Developed a complete system controlling and analysing fleet management for the NHS. Written in VBA Access 97 and recently migrated to a SQL 7 database. The data was migrated to SQL 7 database from the Access 97 backend database. 20-user system. Comprehensive reporting to NHS standards, including over 150 letters and reports in Access, enabling quicker and more impressive response to customers.
Sql, Backend, Oracle, Database, VBA, Controlling, Management, It, IT Consultant, Developer, Vb, Backend, XP
My education
St Andrews High School
HighSchoolOrEquivalent, Maths, English Language, Physics
HighSchoolOrEquivalent, Maths, English Language, Physics
Economics University of Southern Rhodesia
Bachelors, N/a
Bachelors, N/a
Robert.Walmsley's reviews
Robert.Walmsley has not received any reviews on Worksome.
Contact Robert.Walmsley
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Robert.Walmsley 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