Lorenzo Tunioli M.Sc. Email & Phone Number

Borgosesia, It

Greater Biella Metropolitan Area

Main duties include:♦ Reporting Automation♦ Data Analysis (MS Excel, MS Power BI, Business Central)♦ Data Mining (MS Access, MS SQL Server, Business Objects)♦ Process and Operations Analysis ♦ Presentations (MS Power Point)♦ Accounting Procedures

Greater Biella Metropolitan Area

Working in the business analytics team.Main duties include:♦ Preparation of Business Reports and stats using SAS, Sequel, MS Power BI e MS Excel♦ Market Research Analysis♦ Data Mining♦ Data Warehouse Management♦ Company Budget preparation ♦ A/B Testing

I had to leave my previous job to care for a family member. I’ve relocated from London UK to Northern Italy where I have invested my free time studying French, Spanish and Russian to further improve my knowledge in these languages. I have also attended professional courses in e-commerce and management. Due to Covid 19 my sabbatical year got further extended.

London, Greater London, United Kingdom

Delivered internal management, sales (pipeline / leads / conversion rates) and operations reporting for Cadence and supported the project team at the Department for Education (DfE) with complex data related solutions

London, Greater London, United Kingdom

Joined the team working with client, Q – The Health Foundation, analysing data to identify business growth

London, Greater London, United Kingdom

Joined the team at the London borough of Waltham Forest, to analyse and evaluate their recent Selective Licensing project

London, United Kingdom

Assigned to the organisation design project team at the Ministry of Justice (MoJ)Key tasks:♦ Collection and manipulation of internal client data for the creation of a master staff list showing all the FTEs working in the Digital & Technology (D&T) division of MoJ.♦ Preparation of a cost model for D&T to evaluate the actual and future cost of the division.♦ Supporting the team members with ad hoc reporting, assisting the staff data lead with the reconciliation of people data from… Show more Assigned to the organisation design project team at the Ministry of Justice (MoJ)Key tasks:♦ Collection and manipulation of internal client data for the creation of a master staff list showing all the FTEs working in the Digital & Technology (D&T) division of MoJ.♦ Preparation of a cost model for D&T to evaluate the actual and future cost of the division.♦ Supporting the team members with ad hoc reporting, assisting the staff data lead with the reconciliation of people data from different sources, such as finance and HR reports.♦ Achievements:♦ Creation of a staff master list for new D&T organisation design;♦ Production of a solid cost model for D&T;♦ Successful execution of ad hoc internal reporting. Show less

London, United Kingdom

Supported the project manager for efficient execution of day-to-day operations, guaranteeing realisation of operational goals.♦ Directed business evaluations and analysis for a cross-functional array of operations, resulting in efficient procedural enhancement.♦ Controlled excel data manipulation for development and delivery of managerial reports.♦ Supported the migration of MS Access based system to newly developed finance systems.

Slough, Berkshire, United Kingdom

Managed the procurement function; analysed sales data, processes and systems to effectively report on and evaluate a variety of solutions, enabling the implementation of enhanced business processes.♦ Played a key role in assuring synchronisation of operational procedures by controlling resourceful process mapping.♦ Evaluated P&L activities, aiming to successfully mitigate losses and enhance organisational profitability;♦ Single-handedly supervised computerisation of three complex… Show more Managed the procurement function; analysed sales data, processes and systems to effectively report on and evaluate a variety of solutions, enabling the implementation of enhanced business processes.♦ Played a key role in assuring synchronisation of operational procedures by controlling resourceful process mapping.♦ Evaluated P&L activities, aiming to successfully mitigate losses and enhance organisational profitability;♦ Single-handedly supervised computerisation of three complex reports pertaining to the finance and sales function with the aim to support senior management in decision-making.♦ Automated operational invoicing process and weekly reconciliation procedures for accurate data management and to strengthen organisational integrity. Show less

London, United Kingdom

Worked closely with international brokering team to analyse their customer and business data and deliver regular operational, sales and financial reports, supporting business strategy and decision making. Streamlined data manipulation process and delivered effective recommendations by utilising bespoke CRM, MS Excel and SQL systems. Oversaw a diverse range of periodic forecasting, reforecasting, and budget development pertaining to broking divisional performance, leading to effectual attainment… Show more Worked closely with international brokering team to analyse their customer and business data and deliver regular operational, sales and financial reports, supporting business strategy and decision making. Streamlined data manipulation process and delivered effective recommendations by utilising bespoke CRM, MS Excel and SQL systems. Oversaw a diverse range of periodic forecasting, reforecasting, and budget development pertaining to broking divisional performance, leading to effectual attainment of organisational goals. Pooled resources with a cross-functional range of digital agencies to ensure performance augmentation, efficiency recognition, budgetary compliance, and assess ROI. Organised a superior knowledge base for effectual development of a superior search engine marketing, resulting in streamlined staff operations.♦ Played a key role in the efficient execution of sales evaluation for effectual identification of market opportunities and constitutive development of superior resources allocation strategies.♦ Assured successful attainment of profitability goals relating to the online broking business.♦ Oversaw optimisation of reporting operations by automating and streamlining a diverse array of financial and operational reporting procedures.♦ Rendered expertise for effectual business enhancement and procedural transformation by coaching and leading a variety of professionals. Show less

London, United Kingdom

Reporting directly to the Recruitment & Admissions Executive Director, and worked collaboratively with the project team on the implementation of a new CRM system. Through data analysis and interpretation, created regular business reports and identified trends, as well as opportunities / gaps on both new and existing applicant enquiries / records. This enabled staff to see where the market was stronger / weaker and tailor their admissions strategies accordingly♦ Created new types of… Show more Reporting directly to the Recruitment & Admissions Executive Director, and worked collaboratively with the project team on the implementation of a new CRM system. Through data analysis and interpretation, created regular business reports and identified trends, as well as opportunities / gaps on both new and existing applicant enquiries / records. This enabled staff to see where the market was stronger / weaker and tailor their admissions strategies accordingly♦ Created new types of management reporting, using programme-specific data, which consistently measured the success of all courses.♦ As part of the CRM project, took part in UAT Testing and scripts, throughout the different stages of the project lifecycle.♦ Ms Access DB/CRM super user within the Degree Programmes team and provided support/training to colleagues, and created guidelines for new users.♦ Built strong departmental relationships at all levels, enabling regular communication and transparency across teams. Show less

City Of London

• Achievement in February 2013 of the post-graduate certificate in management• Achievement in June 2013 of the post-graduate diploma in management• Completion of the full MSc programme in Management with Project Management (Highest achiever of the Sep-12 intake)

Potters Bar, United Kingdom

Supported the UK & Ireland Financial Controller and the CFO on the analysis of financial and transactional data to produce monthly client-facing trading statements which formed the basis of client reporting and client settlements, using multiple databases and Excel macros.♦ Responsible for the invoicing process and intercompany transactions/payments, as well as departmental process improvements and standardisation: managed commissions’ analysis and rebate matching projects, which were… Show more Supported the UK & Ireland Financial Controller and the CFO on the analysis of financial and transactional data to produce monthly client-facing trading statements which formed the basis of client reporting and client settlements, using multiple databases and Excel macros.♦ Responsible for the invoicing process and intercompany transactions/payments, as well as departmental process improvements and standardisation: managed commissions’ analysis and rebate matching projects, which were successfully implemented.♦ Regularly produced internal P&L statements used as the basis of reporting to the Programme Management team and performed month-end duties (calculation of accruals, Month-end journal, profit adjustments analysis, etc.)♦ Managed the transition/migration process from Ms Access 2000 DB to Ms Access 2010 DB, and acted as an internal consultant for the migration from Ms Access DB to Hyperion Essbase in Commercial/Finance.♦ Carried out an audit of key corporate clients to help the team develop sales strategies.♦ Effectively worked and communicated with internal contacts, including national and global Program Management teams, Finance and Operations to ensure contractual terms agreed with clients were accurately fulfilled.♦ Deputised for the Finance Manager and trained new members of staff within the team. Show less

Potters Bar, United Kingdom

Involved in all aspects of day-to-day finance tasks: monthly matching of payments for payables, including the preparation of supplier statements to put through the matching process in the company financial system and posting journals. Actively managed the implementation of new ways of putting through matching of payments statements received from the company’s suppliers♦ Assisted the manager in leading a team of 6, reconciling statements, invoices/credit notes for various types of suppliers… Show more Involved in all aspects of day-to-day finance tasks: monthly matching of payments for payables, including the preparation of supplier statements to put through the matching process in the company financial system and posting journals. Actively managed the implementation of new ways of putting through matching of payments statements received from the company’s suppliers♦ Assisted the manager in leading a team of 6, reconciling statements, invoices/credit notes for various types of suppliers such as BSP (Air), Rail, Cars, Ferries, Passport & Visa.♦ Liaising with the various departments within finance and branch support to resolve queries regarding operational issues.♦ Deputised for the departmental managers and trained and supported new members of staff. Show less

London, United Kingdom

Maths, Accounting and Italian Language tuition to adult learners performed face to face and online, whilst attending business and academic English Language courses.

London, United Kingdom

Assisted the Credit Controller in all daily duties including; processing payments and refunds, and chasing up on outstanding payments.♦ Liaised with the sales/commercial department for queries regarding the nature of the contracts entered with the clients♦ Assisted the Income Auditor in their day-to-day tasks, i.e. verifying sales from the Operational department.♦ Assisted the Procurement Manager.♦ Supervised on stocktaking and deliveries.

Level 7 Professional Qualification (Master'S Degree Level) - Strategic Management And Leadership, Business Administration And Management, General, First Time Passes

Activities and Societies: MCMI - Full Member's events - Strategic performance management (7 credits) - Financial Management (7 credits).

Master Of Science (Msc), Management & Project Management, Merit - First Time Passes

Activities and Societies: Member of the UK Finance and Investment Society; Member of the UK Commercial Awareness Society; BPP Alumni Stage.

Certificate In Business Accounting Qualification, Accounting And Finance, 65%, First Time Passes

- Financial Accounting - Management Accounting - General and Business Mathematics - Business Economics - Ethics, Corporate Governance.

Bachelor'S Degree (Honours), Department Of Economics And Business - Management, Geography And Social Sciences, Full Marks (2.1)

Activities and Societies: Days of the Tourism (Yearly Economic's Seminar) [ECONOMY] - Applied Economics - Business Administration.

High School Degree (Esame Di Stato/Maturità) In Mechanics Engineering And Industrial Management, Mechanical Engineering, B

Activities and Societies: Professional Summer Internship MAIN MODULES: - Maths, Physics, IT, Mechanics, English, Planning and Control.