Experienced spreadsheet and database designer with finance background
Last active: 8 days ago
Over the last 2 decades, I have developed a wide range of business spreadsheets and databases using Microsoft Excel, Access and Filemaker Pro, including major databases for organisations around the world. My core competency lies in complete end-end database and spreadsheet development utilising Visual Basic for Applications programming code, and I am seeking opportunities to build business solutions and databases from the ground up for you or your business.
I also have 22 years experience as an accountant and can develop automated financial reports that integrate with your accounting software.
If you'd like the full story, please read on.
My name is Lawrence.
I am an ex group finance director who has turned spreadsheet and database solutions developer. I hold a degree in psychology and sociology and my interests include the search for personal excellence, hypnosis and brainwave entrainment. My areas of expertise include accounting, systems implementation and financial reporting, spreadsheet and Microsoft Office development and database development.
Accounting, systems implementation and financial reporting
I have 24 years experience in the accounting field, having occupied positions such as accountant at an accounting firm, finance manager for a group of companies and group finance director for an international NGO. I provided support to finance managers in the NGO environment in several countries, both in person and remotely. I particularly focused on budget variance reporting and cash flow management for small NGOs. During my years as an accountant I provided clients with financial services such as financial statements, taxation advice and other financial reporting. I also conceptualised, designed and implemented numerous computerised accounting systems from scratch or from paper based systems. I have also implemented several project reporting systems and created data interfaces between popular accounting packages and Microsoft Excel from which sophisticated financial reports could be generated. I currently provide consulting services and financial advice to small businesses and NGOs as well as financial tools that improve accounting accuracy and financial reporting.
Spreadsheet and Microsoft Office development
As an accountant, I made extensive use of spreadsheet applications such as Lotus 1-2-3 and Microsoft Excel. I developed increasingly advanced spreadsheets to accommodate the needs of myself and my clients until I reached the point where I began using macros extensively. The next logical progression was to write my own code in Visual Basic for Applications (VBA), the programming language embedded in all Microsoft Office applications. This allowed me to create very sophisticated applications that could meet any SME or NGO requirement. An example of this is an invoicing system which I designed for an American organisation which allowed subcontractors to compile and submit their multipage invoices in a fraction of the time it took using another system. I currently consult and design customised spreadsheets for clients. I regularly do text and data manipulation in Excel using advanced formulas and, if required, VBA code.
I have completed three courses on Microsoft Access (Basic, Intermediate and Advanced) and use it to design database solutions for the Microsoft Windows platform. For one of my projects, I designed a database for a large American organisation which monitored several hundred schools and several thousand teachers for an education project which was run in several provinces in South Africa. For my latest project I designed a database to track the performance of students and teachers in 300 schools in Haiti. Data was collected in several field offices and combined at head office level. The database also interfaced with two other data systems to automate the import and export of summarised data.
In addition, I have accumulated extensive practical experience in IT support and application development and regularly provide technical advice on software implementation, design and computer automation. I strive to under promise and over deliver, something which I hope will be evident from any references you may see. A successful project to me means that I have exceeded your expectations as a client and that you would not hesitate to recommend my services or work with me again.
I would love to discuss your requirements with you if you have any projects for which you think my skills might prove useful.