Jonathan S. Email & Phone Number

United Kingdom

London Area, United Kingdom

• Bordereaux/Delegated Authority data project - this included implementing Power Automate flows that allowed for DAX queries to run against an industry standard BDX model. These DAX queries would be embedded in Power.
• The Power Automate, Python and SSIS jobs created for the process described above were developed and implemented in a DEV environment, the data was then exposed to various end users via Power BI dashboards.
• Creation of python scripts that allowed for DAX queries to be executed on a loop, these DAX queries were based on a industry standard Bordereaux/Delegated Authority Power BI model - once the looped DAX queries were.
• Implementation of data extracts for Solvency II, this includes claims and premium data extracts that are based on the Solvency II Pillar 3 Step B templates.

London, England, United Kingdom

• Document requirements from Treaty, Single Risk and MGA Claims teams to understand and document the full scope of dashboards required from the business.
• Design and manage a central backlog of Tableau dashboards to ensure the development pipeline is prioritised, transparent and avoids duplication of effort.
• Ensure a standardised look and feel across all Tableau dashboards – using best practice to ensure easy consumption of information and implement relevant drilldowns as required.
• Upskill junior members of the Global Claims Reporting team – enhancing in-house capability on Tableau.
• Act as the key point of contact between the business and Data Engineers to ensure underlying data is staged in DataBricks (in-line with our requirements), tested and reconciled before rollout.
• Support communication activities and project governance - providing regular updates on progress and sharing success.

London, England, United Kingdom

• Data Analysis: Utilize SQL, Power BI, and Python to extract, transform, and load (ETL) data from various sources.
• Report Development: Design and create visually compelling reports and dashboards to present key performance indicators (KPIs) and trends.
• Data Modeling: Develop and maintain data models that facilitate accurate and efficient analysis.
• Collaboration: Work closely with cross-functional teams to understand business requirements and translate them into actionable insights.
• Performance Optimization: Identify and implement optimizations to improve the efficiency and effectiveness of data processes.

London, England, United Kingdom

• Collaborate with Data Migration Lead, external providers, and inhouse developers to design, implement and execute the Data Migration framework (DMF)
• Represent the NPAS Data Migration team in meetings with senior stakeholders
• Review Mapping documents and provide feedback
• Generate Migration Code using SSIS and TSQL
• Maintain code and release processes in line with company standards.
• Design and creation of Azure pipelines and releases via Azure dev environment and through to test server.

London, Greater London, United Kingdom

• I have extensive knowledge of the Lloyds Bordereau/Coverholder market due to my time spent at Liberty, I worked on a number of analytical projects to deliver Bordereau reports and dashboards using MS products such as.
• Other projects that I worked on included testing of the new Lloyds DDM Bordereau/Coverholder system for Liberty, this covered database and data testing of new DDM.
• Collect and understand requirements for new SSRS reports, validate and reconcile the data presented on these report and then liaise with the MI team to get the work peer reviewed and promoted to production.
• Assist MI BA’s with project tasks during busy periods.
• Migrate ‘Legacy’ Excel and MS Access reports that were being administrated by the various UW teams to SSRS or Power BI.
• Develop business knowledge and technical skills to be able to provide support to MI BA’s.

Brighton, United Kingdom

• Using Jira to manage a variety of support queries, assist client's managers with set-up, maintenance and management of tracked data within the analytics software platform.
• Debugging, development and some administration of key database and BI systems (MS SQL, Vertica, Postgres and icCube) Configuration, and monitoring of messaging systems such as Apache Kafka, and Hbase Working with both.
• Communicating with team and peers promptly and effectively, documenting changes and tasks regularly and methodically.

London, United Kingdom

• The role that I undertook for Deloitte was working solely on an end to end profitability data model that detailed the cost efficiencies for one of their clients. This work including taking source data files from the.
• The above work including creation of DB tables to load the source data into, update and inserts statements to create additional levels of data which were not present in some of the source data files, creating bespoke.
• Once the technical data modelling was complete I then created a series of Tableau dashboards to showcase the data to the relevant clients.

Soho Square

• Development of Trade Reports based on an Amazon Redshift / PostGreSQL data warehouse, the project that I was working on involved the automation of data from the source data warehouse which would replace the previous.
• Key metrics within the reports included counts of passes sold, monetary value of passes sold, location of key attractions that were visited by customers and data relating to when passes were scanned and used.
• I also had to take on the role of technical BA to help define and gather the reporting requirements by analysing the original reports that were produced manually.

City Of London

• Development of Tableau dashboards for the Operations, Finance and the Under writing departments, I used a number of different data sources for these dashboards which included existing Excel reports, Oracle and MS SQL.
• Creation/Design/Testing of SQL scripts that were used to provide data for the actuarial reserving process, these aggregated scripts covered the data areas of outstanding claims, premiums, reinsurance and two.
• Creation of SQL scripts and reports that identified profit commission being paid by ANV, originally this data was being taken from a Framework aggregated table but my script allowed for a more inclusive way to.
• Providing technical and process documentation for all reporting streams that I was responsible for, these were created to allow a new/existing team member insight into how reports were created from source to.
• Creation and testing of SSAS cubes based on a SQL server data warehouse environment, these were created to be used by both the MI team and Underwriters and covered the reporting areas of Risks, Policies, Bordereaux and.
• I was also involved in the design and testing of SSIS packages which extracted data from a DWH source, the data was then compiled into a series of MI data tables and then used for the PMD process. Once the data was.

London, United Kingdom

• Gathering of user requirements and performing a Business Analyst role to match the users specs to the technical end of the process, e.g. database/universe/report design.
• Creation of new universe and 30+ reports for the business area of Theatrical/DVD/Blu ray/Digital media releases, this work consisted of creating a new universe and the associated reports based on a new application and.
• As well as the new universe and reports I was also responsible for creating scheduled instances of these reports which were used by end users. This project covered the design of the universe/reports/schedules across.

Richmond

• CRM Reporting Application - Business Objects - Develop and provide the business with effective cyclic and ad-hoc reports.
• Develop and provide effective report templates via the web-based reporting tool for all fieldforce Area Managers and Regional Managers.
• Consistently monitor and evaluate the data being entered into Siebel, and to make sure that thebusiness is receiving back the optimum level of information.
• Maintain and evolve the existing Business Objects environment (inc reporting Data mart).
• Ensure that the automatic scheduler for reports is always kept up to date with latest versions and is always functioning correctly.
• Liaise with Reporting Data Mart Support Services and ensure that Service Agreements are used to an optimum.

London, United Kingdom

• Testing and design of content that has been migrated from the BoXi 3 to BoXi 4 environments, this included 400+ reports, 15 universes and 200+ users. This piece of work covered testing the reports across both.
• I was also responsible for rebuilding any Deski reports that had failed to be converted over to Webi reports using the Report Conversion Tool. Once this process of re-designing the reports was complete I then had to.
• Conducting onsite training session for end users, this covered a classroom setting where I would demonstrate to the end users to the new functionality and look and feel of Business Objects report developing tools.

Lewes, East Sussex

• Implementation of SAP service packs for entire Live, DR and Test Business Objects environments. This included service packs for servers and client machines.
• I was responsible for recommendations for the migration from BoXi 3r5 to BoXi 4.
• Daily duties also covered a helpdesk type role to help and advise report creators within Sussex Police on best practice on how to develop/create adhoc reports.
• Development of Publication procedures through the CMC to help with the automation of real time dashboards used by end users.
• The role that I filled also included data analysis for the areas of Crime Intel (40+ universes), Management Accounting and Human resources. This work also covered gathering of user requirements which would entail.
• Development/Administration of core universes based on both Oracle 10g and SQL Server 2008 databases. This included the development of new objects, adding new tables, custom hierarchies, aggregate awareness and.

London, United Kingdom

• Design and implementation of core HR reports for global clients across the entire HR area for Unilever, this included reports based on business analyst specifications for third party vendors who ran Unilever’s.
• This role has also included working with business analysts and end users to provide key reports based on HR metrics using BOXI Webi version 3. Working closely with clients and end users also included weekly updates.
• Liaising with project managers and clients to accurately decide on achievable time scales for report development and when such reports would be available for UAT. Once UAT was complete new timescales would be agreed.

Blackfriars, London

• Design of new and enhancement of existing Business Objects universes for SWAPS, Trade Flow and Client Asset areas.
• Conversion of reports from Business Objects Deski to Webi for the purpose of migrating from SAP Business Objects XI version 3 to 4.
• Creation of Dashboards using SAP Business Objects Dashboard version 4.
• Setting up of scheduled reports via the CMC and administering DEV, QA and PROD environments.

Lewes, East Sussex

• Liaising closely with customers to capture, verify and document business requirements for Business Objects universes and reports.
• Migration of Business Objects platform from 6.5.3 to BOXI 3.1 r2. This included all users, reports, universes plus the setting up of user security matrix, XI server Admin through CMC, client and server software.
• Maintaining and designing 40+ universes for Sussex Police which covered areas such as Crime Analysis, Emergency Call Centre, Forensics, Custody/Case and SAP HR/Finance.
• Implementation of 100+ scheduled reports from BOXI that were distributed via email or save to file destinations.
• Designing of complex multi query reports for the Finance (SAP) e.g. Financial Accounting, General Ledger & Financial Accounting, HR (SAP) e.g. Strength/Establishment, Sickness, New Joiners & Leavers, Crime analysis.
• Administration of the entire BOXI 3.1 r2 environment for all of Sussex Polices 400+ users.

Zurich/London

• Universe design and report development for the Investment Banking area.
• Gathering of user requirements for new reports and changes/enhancements to existing reporting suite.
• Lifecycle management of universes and reports from DEV to UAT to TEST and finally LIVE Business Objects environments.
• Administration of Supervisor software, this was mainly for setting up new users but also included user and group data restrictions using user/group specific SQL.

London

• Creation of new Universes for the Sales, Finance, Provisioning and Marketing departments, continued maintenance and administration of existing Universes for the Billing and Network departments.
• Implementation of Dashboard Manager for the use of Sales and Provisioning senior management, this was designed around core metrics as detailed by business requirements.
• I had to also liaise with the front end users to gather business requirements for new reports plus also help new users with a help desk type role to help troubleshoot any issues that the user had with reports created.

London/Luxembourg

• Gathering of client requirements from both internal and external sources across the UK and Europe.
• Implementation and design of universes for external clients from a “grounds up” perspective.
• Training across various clients site in the UK and Europe, to show how to best use and optimize reporting through Web Intelligence application.
• Designing a suite of “core” reports for external clients that covered analysis of asset and trade movements through customer funds across Europe, Asia and the US.
• Designing of client specific reports through both Business Objects Full Client and Web Intelligence.

South London/Newbury

• In this role my main function was to design and test Business Objects report that were detailing the uptake to Marketing Campaigns run by the Vodafone Marketing team.
• These Marketing Campaigns were usually the product of a direct dial to customers who were nearing the end of their current contract or targeted customers who may wish to switch price plans to better suit their.

Education record

Education record