Data integrationUsing SAS DI Studio to extract, transform and load (ETL) data from the hospital's clinical systems in to the CDW. Creating data marts according to user specifications in order to facilitate clinical research, and also to create datasets for upload to the SAS Visual Analytics LASR server for further analysis and dashboards. Participating in the maintenance of scheduled ETL jobs.Analysis and reportingHandling requests for CDW data using SAS Enterprise Guide and base SAS. Understanding research/analysis requirements and gathering specifications. Submitting data, creating reports and setting up stored processes (accessed via SAS Add-In for MS Office). Transforming data to conform to standards, eg SNOMED.Creating data visualizations using Power BI and SAS Visual Analytics (VA).Stakeholder SupportAssisting expert users in self-service access to CDW. Providing training in using SAS for extracting and analysing data. Participating in development of strategy for further development of CDW.

Ad hoc requestsLiaising with members of NHS Patient Safety team to decide upon required data/analysisUsing SAS (9.2) to extract data from NRLS database of patient safety incidents (over 16M records on main table), combining with data from other sources or SAS reference tables (Data step merge, Proc SQL join, hash object)Searching free-text fields using Perl regular expressions. Tokenising for further analysisWriting/editing code in SAS Macro Language to improve efficiency of repetitive tasksSummarising and visualising outputs: Proc Tabulate, Proc SQL (crosstab queries, etc), Proc Report, Proc Freq, ODS (html, pdf, excel.xp), SGPlot, SGPanel, Tableau, MS ExcelResponding to data and analysis requests from external sources, including: academic research; media inquiries; Freedom of Information requests; parliamentary questionsScheduled reportsProducing biannual published reports (recognised by ONS as official statistics); National Quarterly Data and Organisation Patient Safety Incident Reports. Building VBA macro to create monthly feedback report from SAS output dataMaintaining automated SAS batch reportingPerforming quality assurance of outputs. Documenting, validating, reviewing and improving production processesNRLS internal analysisDeveloping report for exploration into quality of data submitted to NRLSInvestigation and analysis of reporting trends using SAS Enterprise Guide and TableauWorkload analysis. Maintenance of legacy MS Access workload logGuiding and mentoring junior colleagues

Lead Reporting Analyst, Collinson Insurance Group September 2013-September 2015Report Production• Taking lead role in generation, validation and circulation of all existing reporting, using Excel and Business Objects• Using Excel/VBA to automate reporting, drawing data from data marts, Business Objects universes and proprietary data-system tools • Communicating regularly with all business units to understand their current reporting requirements and processes, and to optimise resulting output• Handling feedback and following up queries regarding delivered output Development• Gathering and understanding new reporting requirements from stakeholders and external clients. Designing KPI reports and dashboards and liaising with end users to agree proposed output• Assembling data sources for compliance reports submitted to the Financial Conduct Authority • Creating a suite of standard MI reports for external business tender proposals• Appraising processes to find more efficient or accurate methods of production• Managing ad hoc data requests and dealing with requests for new reportingAnalysis• Understanding cost and revenue drivers that have an impact on business performance, and providing commercial insight• Supporting the validation of forecasts, projections and pricing models designed by Commercial Analytics• Using advanced Excel to provide assistance and technical expertise to facilitate implementation of analytical models

Management Information• Using SQL, SQL*Plus and UNIX to create stored procedures for scheduled and ad hoc reporting• Creating and maintaining suite of management reports in Business Objects and Crystal Reports, published to the intranet for access by end users• Building and supporting Excel and MS Access management information tools for users across the department• Assisting expert users to produce, troubleshoot and update their reportsData Manipulation• Handling data requests by extracting data sets from many different systems (ORACLE PL/SQL, MS SQL Server, UNIX, external data files) and combining, collating and analysing the data to provide meaningful information• Importing, exporting, cleansing and processing data from a wide variety of sources and systems• Creating and maintaining XML interface between Council's Revenues & Benefits system and third-party voice recognition system to provide automated refund line and Direct Debit hotline• Building and supporting VBA applications for automating reformatting and transmission of data files between internal and external systemsSupport• Heading Finance Department participation in corporate-wide project to migrate all intranet content to MS SharePoint, ensuring searchability with consistent formatting and metadata• Developing and maintaining Council intranet, creating pages, subsites and web apps with XHTML, DHTML, CSS, XML, XSLT, ASP, PHP, MySQL, JavaScript and VBScript• Software and user support for a wide range of systems and applications• Instructing end users in using Excel, MS Access and other tools to produce desired output

Delivering training of core IT skills, planning coursework and developing course materials

Delivering English courses, student level assessment and exams