Simon Letten work email
- Valid
- Valid
- Valid
Simon Letten personal email
I am an Excel/Access/VBA RAD developer with over 20 years’ experience developing and supporting solutions for the financial and fashion retail sectors. Recent projects include Excel workbooks as a front-end for an Azure SQL Server database with Power BI reporting. PowerShell scripts provided continuous integration and delivery by deploying copies of the live database to other environments overnight.I enjoy working in an environment where projects can be delivered quickly and have an immediate impact. I understand the importance of high quality code - naming procedures and variables, re-usable functions and procedures and user-friendly exception handling.
-
Vba DeveloperS Cubed Services Ltd Sep 2023 - PresentLondon, England, United KingdomAdding automation to existing processes. Reviewing workbooks and suggesting improvements. -
Senior Software EngineerAsos.Com Jul 2021 - Jun 2023London, England, United KingdomASOS bought the Miss Selfridge, Topman and Topshop brands from the Arcadia Group in Feb-2021. This included their wholesale business and the wholesale trade management system called WTSO. I joined a small team (one other developer, a tester, and a business analyst) supporting and developing the WTSO system. This is a set of Excel workbooks with an Azure SQL Server database as the back end with a few Power BI reports. Projects included new data columns in the workbooks and database, new features in the data-entry process, new stored procedures, and new developer tools for making changes to workbooks in production. One project was coordinating with other teams on the specification for a scheduled export of data from WTSO for consumption by other systems. In addition, I did code review of the other developer’s work, reviewed the test cases and UAT scripts and ran knowledge-transfer sessions. -
Senior Vba EngineerArcadia Group Ltd Oct 2018 - May 2021LondonPart of eight-person team that updated the existing Excel workbooks used for managing sales to wholesale partners for all brands. We transformed the system from standalone workbooks to an Azure SQL Server database with Excel workbooks as the front-end and Power BI reporting. This project employed Agile methodology including sprints and daily stand-ups.Developed ad hoc Excel workbooks for the Project Management team pulling data from SharePoint and for warehouse staff to run stored procedures on an Oracle database. Other mini-projects included data querying and transformation and an Excel workbook that uses the Trader Support Service (TSS) API for making declarations under the NI Protocol.Made redundant at the end of May 2021 following Arcadia Group going into Administration in Nov 2020. -
Software Engineer (Vba)Arcadia Group Ltd Aug 2017 - Oct 2018London, United KingdomI support and develop a suite of Excel workbooks that are integral to the Buying and Merchandising teams for Topshop and Topman. I was hired to take ownership of the workbooks from the contractors who had developed them and to work with the business SME to further develop them to meet the changing business needs. The workbooks include pivot tables, user forms, popup menus, sql queries and some ribbon customisation. User requirements can evolve rapidly and prototyping of ideas helps drive this. The workbooks have been documented, aligned with code standards and checking the code modules into Git Hub is now part of the development process.
-
Excel/Access/Vba Developer (Contractor)Pantheon Ventures Sep 2015 - Aug 2017London, United KingdomDeveloped new Excel workbooks and Access databases to support changing business practices. Some integration with SQL Server and development of Business Objects reports.I was hired to improve the mostly-manual transaction entry procedures by creating new Excel workbooks and developing existing ones. This involved the creation and scheduling of Business Objects reports as part of the move away from legacy reporting software. Additionally, I developed Access databases as part of Pantheon’s Strategic Projects programme. Technologies used include Excel/Access VBA, ADO for connection to Excel workbooks and SQL Server, DAO in the Access databases, ad hoc SQL queries and PowerShell.The projects included transaction entry forms and data validation, task assignment and tracking with Outlook reminders, bulk entry of fx rates into legacy software, cash flow projections, fee calculations and fee reporting. -
Excel/Vba Developer (Contractor)Abd Investment Management Oct 2013 - Feb 2015London, United KingdomI developed Excel workbooks to support the launch of their UCITS fund and, subsequently, a managed account. The main project was a trade booking system which read confirms from emails and from text files, generated the input for the portfolio management system and sent an email to the execution broker detailing where the trade should be given-up. End-of-day trade reports were automated using Excel/VBA and delivered using email, FTP and SFTP. In addition, I developed workbooks and documented processes for monitoring and reporting UCITS and AIFMD exposures and VaRs. I wrote Python scripts for housekeeping tasks such as archiving files and checking that report files had been created.
-
Research ProgrammerGlc Ltd. Dec 2000 - Apr 2013London, United KingdomI developed and supported applications for all areas of the office but my focus was on the trading and research teams. Development was primarily in Excel/VBA with some VB, MySQL and VbScript. GLC traded European, US and Asian equities, exchange-traded derivatives (futures and options on equity indices, bonds, interest rates and commodities) and fx (including emerging-market fx).My primary role was the implementation, support and monitoring of trading books and models for all the asset classes traded by GLC. The trading books included the display of model outputs for the traders, p&l, trade-entry and some risk measurements, as well as reporting values to the back-office. I introduced price validation in the trade-entry process, programmatic rolling of futures contracts and scheduled apps that checked the integrity of the Excel workbooks. The Bloomberg API was used to get static and historical data. I also developed automated test scripts for use when making changes to the design of the workbooks. Early projects included trade and position reconciliation, automating offsite backups and implementing stored procedures and triggers in the Sybase database. -
Analyst ProgrammerPublic Trust Office (Now Office Of The Public Guardian) In The Uk Jan 1995 - Dec 2000London, United KingdomDeveloped mainly in MS Access and Excel. Supported legacy applications and MS Office.
-
Energy Management OfficerLeicester City Council Jan 1993 - Jan 1995
Simon Letten Skills
Simon Letten Education Details
-
Pass With Distinction -
Jurisprudence
Frequently Asked Questions about Simon Letten
What company does Simon Letten work for?
Simon Letten works for S Cubed Services Ltd
What is Simon Letten's role at the current company?
Simon Letten's current role is Excel/Access/VBA Developer.
What is Simon Letten's email address?
Simon Letten's email address is si****@****sos.com
What schools did Simon Letten attend?
Simon Letten attended Middlesex University, University Of Oxford.
What skills is Simon Letten known for?
Simon Letten has skills like Programming, Financial Markets, Microsoft Excel, Visual Basic, Financial Analysis, Research, Vba, Requirements Analysis, Teamwork, Analysis, Sql, Database Design.
Not the Simon Letten you were looking for?
-
1icomgroup.net -
-
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial