Thomas James Email & Phone Number

Malmesbury, England, United Kingdom

Responsible for managing the Looker platform, as the lead Looker admin:- Managing user license requirements to streamline active licenses within contractual limits- Optimising the user experience through active content & instance performance analysis- Informing analytics community of key upcoming features/functionality in new Looker releases- Prepared and ran developer training sessions with users from around the business- Assisting developers with queries, troubleshooting… Show more Responsible for managing the Looker platform, as the lead Looker admin:- Managing user license requirements to streamline active licenses within contractual limits- Optimising the user experience through active content & instance performance analysis- Informing analytics community of key upcoming features/functionality in new Looker releases- Prepared and ran developer training sessions with users from around the business- Assisting developers with queries, troubleshooting errors & assisting with LookML (Looker's coding language) changes- Assisting developers to implement granular security measures using access grants & folder-level access permissions- Logging & managing support cases on behalf of users, coordinating issues with Google Automating key administrative tasks in Looker:- Worked on Python scripts developed for bulk automationsCoordinated an authentication method change in Looker instances, from Google to MS Azure AD:- Worked with the MS Azure admin to configure the credentials for Dyson's 'sandbox' environment for testing purposes, & setting up the Looker-side configurations- Deployment in sandbox environment, carrying out user testing and scheduling in productionWorking with teams and business units to assist with a reporting migration from Looker to Tableau:- Collaborated with teams across Dyson to analyse each project's transformations and LookML logic- Providing system activity statistics on the usage of the key explores, views and fields- Mapping the project structures and providing recommendations for redevelopment in BigQuery- Researching solutions, attending training sessions held by Salesforce and improving Tableau knowledge with testing of functionality replication using with Tableau Desktop, Cloud and Prep- Attending PowerBI workshops and testing replication functionality of Looker capabilities Show less

Aldwych

Responsible for managing & administrating the Looker environment Responsible for actioning & prioritising BI requests against ongoing tasks:- Daily BI catch-up to review tickets that had been raised and to triage workstack- Building and maintaining daily, weekly and monthly Looker reports including KPI dashboards, headline wallboard figures, origination pool tapes & reconciliation reports- Ad hoc requests including building and updating reports/dashboards in Looker, creating… Show more Responsible for managing & administrating the Looker environment Responsible for actioning & prioritising BI requests against ongoing tasks:- Daily BI catch-up to review tickets that had been raised and to triage workstack- Building and maintaining daily, weekly and monthly Looker reports including KPI dashboards, headline wallboard figures, origination pool tapes & reconciliation reports- Ad hoc requests including building and updating reports/dashboards in Looker, creating dimensions/measures and derived tables to build reporting capabilities & deliver data solutions- Investigating and raising SQL data issues with the front-end developers, to correct or validate- Improving query efficiency in the SQL-built derived tables within LookerData tapes – Worked alongside Treasury team to update funder pool tapes with enhanced reporting metrics. Involved in a securitisation requiring an in-depth review of data being submitted to rating agencies, identifying discrepancies and remedying in Looker, or amending DWH source data Worked on a 6-month data warehouse project for a key client, to deliver a series of reports on funded loans. This required daily monitoring & process performance reporting for successful file delivery Show less

London, United Kingdom

- Responsible for updating and running weekly and monthly reports- Updating the Monthly Scorecard Monitoring Reports and creating versions for new scorecards- Updated/altered existing SQL procedures and scripts to include changes in data structure and output

Tunbridge Wells

Carrying out daily, weekly and monthly client and internal management reporting including:- Running and managing SQL processes whilst updating scripts to provide information to meet client requirements- Updating existing SQL scripts to improve efficiency- Improving usability of final reports in Excel to provide a more useful tool for analysis- Analysing output to ensure accurate deliverance of data- Explaining data trends with commentary to the distribution group-… Show more Carrying out daily, weekly and monthly client and internal management reporting including:- Running and managing SQL processes whilst updating scripts to provide information to meet client requirements- Updating existing SQL scripts to improve efficiency- Improving usability of final reports in Excel to provide a more useful tool for analysis- Analysing output to ensure accurate deliverance of data- Explaining data trends with commentary to the distribution group- Responding to queries regarding the data and trends- Production of new reports that meet the requirements of stakeholders as well as providing data and analysis upon request- Conducting larger analysis on segments of business to deliver useful insight to clients- Managing production and updates to grid calculators for brokers to determine premiums for new customers- Assisting with WPS processes used to produce performance data for latest and month-end data Show less

Watford, United Kingdom

• Worked within the Portfolio Reporting team producing high-level reports for stakeholders• Produced the monthly Portfolio Quality Review (PQR), presenting a view of company performance, latest economic indicators and position in the market• Produced the Integrated Risk Information System (IRIS) Sign-off pack, presenting data validation and data analysis from the monthly IRIS report. IRIS would recreate the company data by running SAS code to calculate metrics and compare to actual… Show more • Worked within the Portfolio Reporting team producing high-level reports for stakeholders• Produced the monthly Portfolio Quality Review (PQR), presenting a view of company performance, latest economic indicators and position in the market• Produced the Integrated Risk Information System (IRIS) Sign-off pack, presenting data validation and data analysis from the monthly IRIS report. IRIS would recreate the company data by running SAS code to calculate metrics and compare to actual data in the Calendar Month End (CME) data tables.• Carried out checks on files using SAS code and VBA to flag data exceptions• Delivered IRIS Sign-off pack to Chief Risk Officer, showing an overview of performance indicators with data validation checks. Exception follow-ups agreed to remedy metrics for future months Show less

Cardiff, United Kingdom

Achievements• Worked for Admiral in their head office on a 3 month internship with Cardiff University as part of my Masters degree where I worked on a Claims Competitor Profiling project.• The Masters project involved creating a market profile of Admiral’s main competitors based upon a number of key insurance related and financial statistics over a 10 year period. Market and company comparisons were drawn using statistical analysis packages and graphical illustrations. • Completed a… Show more Achievements• Worked for Admiral in their head office on a 3 month internship with Cardiff University as part of my Masters degree where I worked on a Claims Competitor Profiling project.• The Masters project involved creating a market profile of Admiral’s main competitors based upon a number of key insurance related and financial statistics over a 10 year period. Market and company comparisons were drawn using statistical analysis packages and graphical illustrations. • Completed a detailed finance project to estimate future company costs based on a number of insurance statistics for Admiral’s main transaction departments using existing corporate data. Show less

Madrid

Achievements: • Spent 9 months on an Erasmus work placement working with colleagues from all over Europe.• Worked in a small office on a series of projects communicating directly with the CEO. This gave me considerably more responsibility than in a standard consulting company. I became more dependable and pro-active and it taught me how to handle high levels of responsibility.• Worked on and managed various databases on Google spreadsheets that I created using a wide range of… Show more Achievements: • Spent 9 months on an Erasmus work placement working with colleagues from all over Europe.• Worked in a small office on a series of projects communicating directly with the CEO. This gave me considerably more responsibility than in a standard consulting company. I became more dependable and pro-active and it taught me how to handle high levels of responsibility.• Worked on and managed various databases on Google spreadsheets that I created using a wide range of mathematical formulas in order to present data in a series of ways. This included anything from monthly average figures to charts and graphs.• Created a PowerPoint presentation and model to propose an idea for the company website which would incorporate a new benchmark study with a new partner.• Learnt the importance of achieving goals and reaching strict deadlines under significant amounts of pressure in a demanding work environment.• Consolidated my Spanish language skills and enhanced my Excel ability to an advanced level. Show less

Operational Research, Applied Statistics And Risk, Msc - Merit

Finance And Economics, Finance And Economics, Ba Honours

Activities and Societies: 5 a side football league Final year modules: Financial Regulation, Risk modelling and Management.