Bray Leino Ltd
Systems Developer (SQL Server/ETL/MS Access)
Design and development of the core Continuing Healthcare and Individual Funding Requests systems using MS Access and SQL Server 2008R2.
- MS Access
- MSSQL 2008r2
- Stored Procedures
- Scalar Functions
- SQL Server Agent
- SQL Server Integration Services
- SQL Server Reporting Services
I have recently completed two projects which enabled data transmission between an internal MS Access GUI and an external facing .NET website.
These allow data input, triage and file transfer from the web into the NHS N3 network via a secure triage form.
One of my proudest achievements to date within Bray Leino was developing an additional database product for one of our largest clients, enabling them to automate mass data cleansing and migration of over a million records which would otherwise have been a manual undertaking, The product has been added to the company products portfolio and sold as an additional tool.
My responsibilities also include gathering system requirements from our clients. This is usually done either over the phone, or via a remote connection to the clients own work station. I document all requirements in notepad, and send a word document copy to our client for confirmation and sign off. Occasionally this may include pre-visualised objects (forms/reports) to determine that we are going in the right direction.
As well as developing enhancements for and supporting our core products, I have also developed several data migration tools for transferring / updating bulk records simultaneously for several of our clients for data housekeeping purposes.
I have been tasked with developing several client and employer BI Stack (SSIS) applications for bulk data management and file output. Some of these projects are automated and are required to be run daily using the SQL Job Agent.
I also provide technical 1st and 2nd line support for all company core products, and from time to time I remotely connect to a client’s PC to provide the support required.