Michael Kenyon Email & Phone Number

Thornton, Gb

Supporting the development and communication of the enterprise vision for Information Architecture. Using a range of design tools for Information Modelling & Design across the BAES Enterprise (Conceptual/Logical/Application Data Modelling). Responsible for creation and maintenance of Logical Information Models across the business using metamodels, taxonomies, ontologies. Systems Integration PrototypingWorking with diverse audiences to illustrate and simplify complex and technical issues.Adoption of Data Modelling standards, guidelines, approved modelling techniques and approachesCreation and Application of Information Management strategiesProviding Functional Information Architecture support to the Air business.

1. Deployed as a Technical Lead on projects to supervise and oversee all technical related aspects ofSolution Delivery2. Working as part of the Business Intelligence & Analytics Competency Centre to perform dataintegration aspects for the organisation.3. Working with classified and extremely confidential defence data.4. Data Virtualisation (DV) Building a virtual data infrastructure for Military Air & Information using CiscoInformation Server for various aspects of the business.5. Developing end to end solutions using different technologies in line with design architecture ( usingSSIS, Powershell, DV)6. Involvement in the data architecture and design and build for multiple star-schema type DataWarehouses for Enterprise Resource Planning Tools.7. Experience of Master Data Management using Searcher and delivering ETL for the business to useas governed and canonical views.8. Supporting individuals of all levels throughout the business - technical and non-technical, to deliverBAU.9. Providing cover for Data Integration Team Lead where necessary10. Database Administration (DBA) to maintain uptime and high performance on over 20 servers(virtual/non-virtual). Indexing, mirroring/failover DB, QEP's, Problem identification, backups, server spacemanagement.11. JIRA/AGILE/SCRUM approach to managing workload.12. Managing security for all reporting systems connecting to the Data Virtualisation layer.

Investigative data analytics to identify areas of target for improved patient care and cost savings/effectivity.Developing T-SQL to manage SQL Server databases to provide business intelligence solutions forhealthcare related businessesMentoring and overseeing other Information Analysts within the team to develop different and new skillsto find more proficient ways to analyse data and find ways to further their career developmentUsing advanced & complex SQL to proficiently extract Hospital Episode Statistics (HES) and Prescribingdata to create Inpatient, Outpatient, A&E and pack level prescribing BI reports.Dynamic SQL Development to implement "standardised" reporting and also develop other areas whichcan be automated to create minimal manual work.Importing monthly raw data via SSIS packages for queryable state.T-SQL/MySQL Problem Solving/Performance TuningAnalysing both activity and costing data for patient pathway and scenario modelling in dashboardsManaging, maintaining and developing systems and re-building partitioned datamarts to improvesolutions within the AXON SQL warehouseInterviewing potential candidates of all levels to become part of the team at HW.Liasing with external/internal clients to provide specialist healthcare intelligence to benefit ongoingprojects towards various disease and treatment areasThe experience of being in the role has given me to opportunity to query, analyse, manipulate andinterpret every single Inpatient episode, Outpatient appointment, A&E attendance in England from 2006for each Provider, CCG, CSU, Practice etc. which has allowed me to specialise my knowledge within theNHS. I have also managed to specialise within Community Prescription dataAGILE working plan

Using different analytical methods to extract and query information from the Trust-s IT systems toproduce reports on a monthly basis and also ad-hocUse of Microsoft SQL (T-SQL, querying, tables and stored procedures)SQL Server Reporting Services (SSRS) - building, designing and manipulating data extracted from ITsystems and produce business intelligence solutions for the clientSQL Server Integration Services (SSIS) - creating packages, transferring information between serversBasic Data Architecture/ModellingImplementation of a monthly KPI dataset with the Trust-s targets - extracting and querying KPIInformation and presenting it month by month with a forecast out-turnLiasing with end user/client and meeting to ensure that reporting is kept to the highest standard andthe client-s needs are fully metProviding business intelligence solutions across the organisation/clinical departmentsWorking with different types of reporting including SUS/SLAM/RTT Data/Clinical SystemsExperience of producing NHS activity and also financial implication reports to assist in cost savings ofthe NHSs current climate