Iain Brown
Tel : 0784 32 444 18
Email : iain.brown@ib-its.com
Profile
An enthusiastic, self motivated individual who always strives to achieve a very high standard in whatever is undertaken. Able to work on own initiative or as part of a team, a conscientious and hardworking person by nature. Experience and understanding of the importance of good customer service. An effective communicator at all levels, honest, trustworthy with a good sense of humour. Currently looking for short or long term contract work in England and am available for immediate start.
Career Summary
2012 – Present Managing Director – iBits – Iain Brown IT Solutions Ltd
Freelance database developer with over 20 years of experience. Specialising in Access 97-2016 database development with strong SQL and VBA skills. SQL Server 2000-2014 database development. I am currently looking for contract work in England and I am available for immediate start.
Contracts:
Systems Development & Support Analyst – Legal & General – Jan 2022 – Dec 2023
Responsible as part of a team for the migration of MS Access end user application data to an MS SQL Server Azure solution, including the re-programming of VBA DAO code to ADO. Redeveloping the HMRC annual data returns with regards to ISA, Other Interest and FATCA.
July 2018 – Mar 2019 System Developer – Computershare
Responsible for programming TSQL statements into a MS Access system linked to SQL Server back end to evaluate responses to customer questions to give acceptance or denial of mortgage applications.
May 2018 – Jun 2018 MS Access VBA Developer – Greensill Capital
Design and development of an interim Access application used for maturity reconciliations for a supply chain finance company based in the north-west of England.
Dec 2017 – Jan 2018 MS Access VBA Developer – Unilever (New York)
Development of a globally used Access Database with import/export, reporting and filtering features. Original brief was to automate an existing spread sheet concept, but the data was unsuited for that application, my recommendation of an Access database was then agreed.
June 2015 to Oct 2016 MS Access VBA Developer – Greensill Capital
Working as part of the IT team for a fast-growing name in the financial services sector based at their North West offices. Understanding, developing, documenting and supporting a live MS Access Financial Asset Tracking and Reporting database developed in-house. This work was taking place during the development of its replacement PostgreSQL system. Development and support of stand-alone MS Excel VBA applications and PostgreSQL processes.
Nov 2012 to Dec 2014 MS Access VBA Developer – Clamonta Engineering
Sole developer for an aerospace company in the midlands, supporting, developing and maintaining their in-house MRP system and working in all areas of their business. System consisted of around 40+ front end MS Access 97 databases all linked to a central back end database.
2008 – 2011 Systems Development Manager – South Leicestershire College
Managing 1 member of staff and the college database systems, responsible for the design, development, implementation, maintenance and support of the colleges 50+ in house integrated database systems running on SQL Server 2005/2008 R2 and MS Access 2003 platforms. Responsible for the administration, security and backups of the SQL Server. Data imports using integration services and notifications using database mail. Migration from MS Access to SQL Server platforms. Table, view/query and stored procedure programming. Report writing using MS Access & SQL Reporting Services. Preparation and production of data returns to government agencies. Knowledge of FE funding methodology.
2007 – 2008 Data Project Manager – Leicester City Council, Children & Young People’s Services
Involved working on 3 mini projects namely to design and implement management information systems to produce the teachers’ annual pension return, DfES form 618g (the teachers census) and the setup of a national minimum data set for all of the children’s workforce. I had a Project Assistant who I line managed and he assisted me in this role. Along with this I was also setting up various other ad-hoc management information systems.
2000 – 2007 Senior Applications Developer – Leicester City Council, Children & Young People’s Services
Design, development, implementation, maintenance and support of MS Access 97/2000/2003 databases for the LCC Education department developments include – Teachers Personnel System, CRB Check, Nursery Grant Administration, Admissions Oversubscription, Recruitment, Stress Management, Special Needs Caseload, Complaints, Continuing Professional Development, Health & Safety Training, Residential Visits, Absence Monitoring, Special Educational Needs Training. Duties also included Canon DIP System administration and general IT consultation, advice & support to users in the department.
Education & Training
Microsoft Certified Professional 2012 – Technology Specialist/IT Professional in:
070-432 SQL Server 2008 – Implementation and Maintenance
070-433 SQL Server 2008 – Database Development
070-448 SQL Server 2008 – Business Intelligence Development and Maintenance
070-450 Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
070-452 Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Microsoft Certified Systems Engineer NT 4.0 Certification Track 1998 – 1999
070-058 Networking Essentials
070-073 Implementing and Supporting Microsoft Windows NT Workstation 4
070-067 Implementing and Supporting Microsoft Windows NT Server 4.0
070-068 Implementing and Supporting Microsoft Windows NT Server 4.0 in the Enterprise
070-059 Internetworking with Microsoft TCP/IP on Microsoft Windows NT 4.0
070-087 Implementing and Supporting Microsoft Internet Information Server 4.0
Midlands Co-operative Society Ltd. 1996
NEBS Introductory Management Award
Training Courses Attended
March 2007 ISEB System Development Essentials
November 2006 Dreamweaver MX Studio
October 2006 MS Access 2003 VBA
April 2006 Visual Studio 2005
March 2006 SQL Server 2005
February 2006 Adobe Photoshop CS Introduction
February 2006 Adobe InDesign CS Introduction
February 2006 Adobe Illustrator CS Introduction
May 2005 Achieve Forms Design
March 2005 SQL Server for Web Development
March 2005 Macromedia Dreamweaver MX 2004 : Dynamic Application Development
March 2005 Microsoft Project 2002 Introduction
October 2004 Groupwise Advanced
September 2004 Groupwise Basic E-mail
March 2004 Intro to Adobe Acrobat Pro
February 2003 SQL DB Design & Information Retrieval
February 2003 Crystal Reports
Personal Details
Date of Birth : 14th June 1971 Car owner with a full clean driving licence
Interests
Keen interest in speedway as a supporter, also armchair football, cricket and formula one fan. I also like to try and keep fit.
References – On Request