System Analyst/Developer

• Dec 2017 - Present

Senior System Analyst

• May 2016 - Dec 2017

I am responsible for database application development at Marie Curie, a UK wide healthcare charity. Analysis, Data Modelling and Solution Design of SQL Server and database reporting projects. I collaborate extensively with internal stakeholders and third parties on database application integrations, development of new data feeds, ETL processes and automated data flows. I also have line management responsibilities.Using SQL Server 2008, SSMS 2008, SSRS 2008, Visual Studio/BIDS 2008, SSIS 2008.Also using CARE (IRIS/NFP Advanced), Faststats. Show less

Systems Analyst

• Jul 2014 - May 2016

1. To investigate and present recommendations to the relevant Project Teams with regards to technical solutions in support of new and/or changing business requirements 2. To develop appropriate technical solutions in support of new and/or changing business requirements3. To document the agreed technical solutions and to facilitate an effective handover to the appropriate delivery team(s)4. To work with internal teams and external suppliers as required to identify and ensure the most effective delivery of technical solutions5. To provide regular updates to all relevant audiences, including (but not limited to) Project Teams, Fundraising Operations, and Database Services colleagues6. To complete the appropriate testing of new technical solutions as required.7. To work closely with all relevant colleagues to ensure a seamless integration of technical and procedural solutions.8. To ensure that any technical solution or use of data is developed in line with both the charity’s strategic objectives and existing data policies9. To work to and promote the use of the Marie Curie Project Management Toolkit 10. To contribute to the ongoing development of the Database Services team11. To represent the Assistant Database Services Manager in his/her absence as and when required12. To line manage subordinates and other resources as required.13. Willingness to work occasional unsociable hours and travel throughout the UK with overnight stops Show less

Data Analyst

• Apr 2005 - Jul 2014

Analyse and enhance operational and accounts procedures in line with the Client and Team Relocations’ business requirements: - Use of Business Objects XI 3.0 for client reporting distributed via webzones and scheduled e-mails or in response to ad-hoc requests. Also used to produce figures and statistics for client quarterly review meetings, to track performance against KPI’s and to produce quarterly summaries for Team Relocations management team. - Creating and Updating SQL scripts using SQL Server Management Studio to create/populate bespoke tables or views in the database for enhanced reporting through Business Objects. - Creating Excel reports containing SQL Queries, for use by Team Relocations Accounts and Operations staff for monitoring purposes and to automate various previously manual functions (eg. tracking Leases due to expire so that renewal/termination procedures are carried out when required and logging temporary accommodation invoices processed to track commission due from suppliers) . - Amend Visual Basic code in existing excel invoice templates to meet client requirements. - Create scheduled Visual Basic scripts to perform automated tasks including running SQL code to import a daily file from the Team Relocations Netherlands office into the UK database to allow combined UK and Netherlands reporting for a jointly held client contract. • Additional tasks including: - Setting up workstations for new users. - Phone patching. - Liasing with London based IT Support team regarding system issues. - Helping users with any easily corrected IT issues. - Setting up laptop and projector for office meetings. - Fire Marshall Show less

Finance Assistant

• Oct 2004 - Apr 2005

Processing Invoice request details to Dream system and printing Invoices to be sent to Companies, Sponsors and Students. • Answer phone call or e-mail queries from staff, students or outside organisations. • Purchase Ledger of Supplier invoice including checking correct coding. • Assisting students in person by distributing grant and loan cheques and taking payment of tuition or accommodation fees. Processing Invoice request details to Dream system and printing Invoices to be sent to Companies, Sponsors and Students. • Answer phone call or e-mail queries from staff, students or outside organisations. • Purchase Ledger of Supplier invoice including checking correct coding. • Assisting students in person by distributing grant and loan cheques and taking payment of tuition or accommodation fees.

Patient Claims Officer

• Sep 2003 - Sep 2004

• Confirming data samples loaded into bespoke database (PECS) from dental and ophthalmic payment systems are complete and accurate to allow data matching with appropriate checking agencies. • Verifying and capturing data in order to complete data samples received from pharmacy payment system. • Answer phone call queries from patients and update cases based on patient correspondence. This on occasion involved dealing with distressed or angry callers. • Assist in the preparation of cases for referral to debt Management Company. • Maintaining spreadsheets to facilitate data analysis and extrapolation of fraud. Show less