Lead a team of BI Developers in the migration from a legacy data reporting system (circa 1500 reports) into Power BI utilising the majority of tools within Microsoft Fabric, including the development meta data driven Fabric ELT process, a complex multi-fact Fabric Data Warehouse star schema model, a generic, multi-purpose Power BI semantic model, and various Power Bi and Paginated reports.

See recommendation from Kevin Hall (CFO Together Dental)• Sole BI Developer – Create virgin BI environment giving them up to date access to business data where previously it was available via Excel on a weekly basis• Mentored Finance Data Analyst in the Maintenance of entire data environment with provision of supporting documentation• Advised company on most direct approach to surfacing their MI using Power BI• Implemented Power BI Premium Per User environment• Configuration of role-based Azure AD security groups• Developed Power BI Data Flows utilising existing practice system data outputs to facilitate a complete Power BI reporting solution via Power BI Apps• Developed a meta-data driven Azure Data Factory suite of pipelines to incrementally land, and transform data from company cloud-based practice management system via APIs• Created a SQL PaaS data mart based on combination of practice management system data and other organisation data such as HR, organisation units and finance cost centres• Implemented and utilised Azure Key Vault in conjunction with Azure Managed Identities• Developed Power Automate routines to wherever possible automate processJohn O’Callaghan CV• Develop Power BI paginated reports with automated Power Automate report distribution• Developed SharePoint site, with supporting documentation, and how-to videos, accessible to uses via Power BI App

#Design and implement Azure based end to end data environment including Azure Data Lake; Integration Runtime and SSIS Integration Runtime; Data Factory; Azure Logic Apps; Azure Powershell Runbooks; Azure SQL DB and DW; Azure Analysis Service Tabular models and Power BI reporting environment#Given significant promotion within 4 months of working for the organisation.# Lead on the design, development implementation of full BI architecture, Kimball, ETL, cube design and report development within a MS environment.# Influence management in the best approach for Business Intelligence for a number of insurance sector databases and their BI reporting solutions.# Train staff in data warehouse design and implementation.# Train staff in ETL using TSQL and SSIS.# Train staff in the design and implementation of SSAS Tabular and Multi-dimensional cubes.# Improve significantly on existing reporting approach.

# Lead in the development of information reporting systems# Design of and implementation of organisational Data Warehouse, including Student records, Finance, and Human Resource reporting# Expert in Further Education Funding and performance systems# Mentor, support and advise managers on how to make the most of the organisation data# Oversee, and advise (as appropriate) on Government Education strategies, and potential implications on the organsiation

# Pivotal role in in the latest Ofsted Grade 2 Inspection outcome (previously Grade 3), by highlighting and correcting weaknesses in data management; management accountability; and developing more robust, coherent planning software and supporting processes. # Develop a coherent curriculum planning process, enabling all levels of management to review the plan in progress, ensuring the resulting curriculum plan will achieve contractual targets, utilising resource as efficiently as possible. # Advised, trained and supported all levels of management on how to get the most out of its data. # Research, pilot and implement appropriate cloud based applications to enable greater collaboration across the organisation# Restructured the Information Service resource to make it more effective and efficient. # Advised/trained curriculum management on changing funding rules, direction of Government strategy and the impact this has on the college. # Used data to enable The Senior Management Team to enable greater control over staffing costs. # Direct HR team on better information management, improving data capture process, enabling them greater access to HR data for management reporting# Lead an Information Services team that are consistently referred to as the best service area in the college, with a pro-active, positive, forward thinking workforce, enabling timely, accurate access to information, as well as comprehensive support in the use of Management Information, curriculum planning, timetabling & examination process. # Developed bespoke reporting systems that brought together all of the college disparate data sources into one coherent reporting warehouse. # Lead on the integration of the HR and Finance database systems and enabled easier access to such data including the development of on-line budget and staffing reporting. # Influential in a significant improvement to the service provided by the Information Learning Technology team.

# Interim Director of Information Services for a three to six month periods.# Advise senior management on funding implications of the curriculum model to ensure maximum funding. # Provide mentor support to new MIS manager.# Placed in a number of colleges with failing MIS teams to enable the provision of curriculum planning process, and performance reporting. # Complete management reviews of organisations.# Provide training to a national audience on managing information within the Further Education sector.

After less than 12 months in the post of MIS Manager, was promoted into post of Director, created by the Chief Executive in recognition to enable me to be part of the Senior Management team. # Directed The College Senior Management Team (SMT) on all aspects of the funding methodologies including the current FE funding changes and the potential impact on the college. # Advised the SMT on the current position in respect to funding, retention and achievement whilst forecasting end of year position enabling real time management decisions to be made. # Advised the college SMT on curriculum planning enabling maximisation of funding, retention, achievement and the resulting success. # Managed the college MIS team ensuring the development of various bespoke reporting tools which enables useful access to all levels of college information including College, faculty, programme area and class analysis, mail merge tools etc. # Directed the Student Records and Examinations teams to ensure accurate, speedy data recording in all aspects of student data management including registers and timetabling. # Supported the Enquires and Applications team ensuring a coherent flow of the gathered information from initial enquiry to resulting enrolment. # Supported the Additional Learner Support team in enabling them to track support costs via a bespoke software application linked directly to Student Records system. # Support The College Marketing team in the production of prospectuses and the development of the college new website.

# Managed all college student and personnel database requirements. # Developed bespoke client side Access application onto a large SQL Server database including SQL Server views, data transfer processes and stored procedures. # Developed numerous SQL Server databases which assist in the college dissemination of data. # Developed new college Internet site including informative Active Server Pages by means of manipulating the record sets to produce concise tabular pages. # Developed Internet back end databases and client side data management applications. # Designed, managed and developed new college intranet site including all back end SQL Server databases and MS Access client side applications.

# Sep 99 - Apr 01 Garrison Works Liaison Officer, G4 Estates - Advised Army estate managers on accommodation requirements, construction designs, British Standards, construction contract law and financial planning; Developed an estate management database for all of south west married quarter estate; developed various web sites. # Jul 97 - Sep 99 Construction Engineer, 522 STRE Hameln, Germany Estates - Managed numerous projects from initial concept, design, planning & implementation throughout Europe; designed, procured, implemented and administered LAN. # Sept 95 - Jul 97 Student Construction Engineer, Royal School of Military Engineering - 2 year, full time training on various construction and management techniques. # Sept 93 - Sep 95 GIS Administrator and Engineering Surveyor, Commander Royal Engineer - Administered a Geographical Information System; development of the underlying database schema; training to other GIS users; managed the surveys of all RAF Main Operating Stations. # Jun 86 - Sep 93 Engineering Surveyor, various posts around the world - Assisted in the design and implementation of various construction projects throughout the word.