Jesus Sansonetti Email & Phone Number

London, Gb

London Area, United Kingdom

ERP Program S4/Hanna– Customers master data for FPA (2021-2022)• Support the FP&A GPO in creation of the master data of Customers and Suppliers in S4/HANNA for FP&A• Regular consistency check of suppliers and customer and provide feedbacks to the teams • Supporting the FPA GPO in attending regular meetings in the definition of processes, data, BPPs• Support the FPA GPO on UATs in master data• Support the FPA GPO in identifying and validating interplatform accounts for customers and suppliersMonthly consistency check of Month End data in FP&A on Vendor dimensions. (2023-Current)• Comparison checks between the information in SAP Postings and Booking information from platforms (Data Lake).• Transformation of data of the Z SAP reports in PowerQuery and bookings information from Data Lake for consistency check.• Reconciliation of Vendor dimensions (Supplier master data information) between SAP data and Platform in excel• Creation, Monitor and validate incidents in Service Now • Support ERP consultants to identify incident's root causeMoving the Month End consistency check (Vendors side) (2024-current) to access• By creating importing process on SAP data• By creating direct connection via ODBC between Access and Data Lake• Creating queries to transform/Compare data between SAP and Data Lake information• Creating visual queries to display the results from the consistency checkERP S4/HANNA Master data analyst - (2024)• Monitor issues in the interface between SAP-Data Lake and consistency check via PowerBi• Improve backlog incidents in the interface• Support the ERP project manager in various projects: OpenText, Archiving project, Voxel, DAC 7• Support Finance teams in incidents and data management.• Manage Credit Limit application in Service Now: collect request from regional sales managers to increase Customers Credit limits or apply for a permanent credit limit

London Area, United Kingdom

Mapping of master data of customers and suppliers coming from the different platforms.• Define format and requested data from sources on customers and sources• On customer side, compile the customer master data into a single Customer common name and assigning a business country. On supplier side, compile the supplier master data and group into a Supplier group and set a contract type• Creation of Business country structure to be used and distribute to the different regional BI and Finance teams.• Establish a communication with the regional BI teams to support and validation of the mappings.• Creation of macros in excel for the automation of mappings. I.e. reading one source and adding new data to the main mapping.• Define macros to set suppliers contract type.• Integrate the mappings to the different FPA reports.• Move mappings of customer and suppliers from excel spreadsheets to MS Access environment (Years 2020-2022)• Support AR team to compile information basing on customer mapping. Creation of billing partners• Creation of new dimensions such as customer profile, trading relationship and AD Managers. .• DATA Lake – Athena AWS project (From 2021). Supporting the Data team in creation of master data and mapping tables of customers and suppliers in AWS Athena. Data Lake becomes source of master data for mappings• Distribute mappings through Data Lake and becomes the Main Source of Data Set for Power Bi reports across the business• Feed data lake with the updated mappings.• Creation of SQL queries in Data Lake to support AD Hoc reports for FPA teamWBID – In house Cloud base application for master data of customers/properties/suppliers (2021-2022)• Support BI Teams, Project managers in creation of customers’ accounts in WBID.• Creation of an importing customers from data lake to create customers’ accounts• Support the AR team in creation of the billing and credit limit information in WBID by creating a consistency check report in PBI

London Area, United Kingdom

• Compile client information from five booking platforms taking in consideration names, addresses, client country and business country into a centralized master file.• Mapping hotel information from different platforms into a master file in excel• Centralize Finance reports based on Client’s master file.

London, United Kingdom

Relationship management between outbound partners and Simplify Digital/ Dixons Carphonewarehouse Group as well as call center for Telecoms/Energy savings campaigns.• Management of first/3rd party opt-in leads from partners to be used for Telecom/Energy campaigns.• Organization and formatting of external/internal data from different partners to be sent to the call center on a daily basis as well as verification of data deliveries agree with the correct volume and format• Set up outbound campaigns on to the CRM and API leads on to Data warehouse system.• Brief the call center on new/update campaigns.• Send daily reports to partners showing leads volume and sales orders• Update weekly performance reports showing data volume/KPIs and sales orders• Facilitating weekly meetings with outbound partners to discuss campaigns statuses, improve performances or setting up seasonal campaigns• Managing weekly meetings with the Call Centre’s dialer manager to discuss volume/performances of Telecom campaign• Update outbound volume forecast and report to Call Centre and outbound partners on a weekly basis• Liaise commercials from outbound partners on monthly basis.• Monthly preparation of volume forecast for each campaign in 3 months in advance and agreed with the call center and partners.• Report to the line manager volume forecast on weekly/monthly basis.• Update monthly reports showing data volume/KPIs and sales orders and send to outbound partners• Liaise/approve invoices from outbound partners to be sent to Finance for payments• Preparation of Outbound MBR and discuss with the line manager.• Preparation of monthly report on performances/volume and profitability of each campaign

London, United Kingdom

I am currently the first point of contact for individuals wanting to know more the programme or apply for funding. I manage the initial liaising with professionals’ interest in becoming a mentor for Startup Direct. Some key tasks include:• Respond to the enquires and invite individuals to events or workshops if relevant• Provide applicants with forms/ cash flow pack and review completed applications• Invite eligible applicants to interview with business advisory team.• Provide mentor enquires with “become a mentor” info and liaise with them as needed.• Update and maintain records for applicants and new mentor leads• Communicate with applicants on funding or support matters• Do customer service and quality control calls and follow ups.

London, United Kingdom

Compass Group had the full catering contract for Citibank's, South East Division. My role was basically to manage the entire operation, from client facing matter to kitchen, suppliers, finance and the Team. Including:• Staff roster preparation and distribution of daily duties• Conflict resolution and customer complaints• Cash flow and banking management• Collection, reconciliation and banking of cash• Providing information and liaising with individuals at all levels both internal and external from suppliers, customers to the general manager• Process invoices on Nexus• Managing and maintaining Nexus( company management system)• General administrative office functions• Processing Ad Hoc reports as required

London, United Kingdom

Compass Group had the full catering contract for Citibank’s, South East Division. As Supervisor a key function was working along side the manager, other tasks included:• Ensuring the food & service delivered met requirement standard• Train and keep staff motivation• Train and ensuring the unit followed a strict Health and Safety regime• Ordering and receipt of goods from suppliers• Maintenance of Stock control system• Preparing Cash Flow daily report

London Bridge

Programming in Access XP, VB 6.0, Crystal Report and XMLDeveloped the statistical analysis of web logs system (SAWL)

Trinidad And Tobago

Programming in Access 97, 2000 and XP; Visual Basic V6.0, SQL 7, HTML, Front Page, Crystal ReportDeveloped and implemented Tax Return and Fixed Assets Systems for PriceWaterhouseCoopersDeveloped and implemented a Fleet Maintenance System for a number of Transport CompaniesDeveloped and implemented Inland Tax System for the Inland Revenue in Tobago Developed and implemented a Student Management System for the School of Continuing Studies a division of the University of West IndiesDeveloped and implemented accounting packages such as: Human Resource System, Car Loan System, and Payroll System for various companiesProduced Help on-line for each developed package using Microsoft Help WorkshopCoordinated sectional trainings for users and supported all the developed packages

Caracas, Venezuela

Programming in Visual Basic 4.0, Access 2.0, Oracle 7.0, and Clipper 5.0. Developed and implemented a variety of commercial packages such as Accounting System, Investment Management System (Equity Derivatives), Payroll System, Bank Reconciliation System, Purchase Ledger System, Accounts Payable and Receivable System, Inventory System for a range of Private and Public companies.Developed and Implemented a Loan Management System for the Caribbean Bank.Producing documentation for each system developed.Supporting all the developed packages

Caracas, Venezuela

Programming in TCL, C (Dos), and BTRIEVE.Implemented a computerized Point of Sales from retailers to conformation of cash availability with Bank.Developed and introduced Internet Banking procedures for the Oil Industry.Developed and implemented modules for Equity Derivative system for the Investment Department.Developed and supported a range of computerized modules for different departments within the group.

Caracas, Venezuela

Programming in Clipper 5 summer 87, Dbase III.Developed a Unit/Fund Trust Management System for a range of Financial Institutions.Developed and Implemented Inventory System and Fixed Assets System for the National Environment Institute.Developed Benefits, Leaves and Attendance modules in a Human Resource Management System for the Venezuelan National Health Authority.Developed and implemented a User Manual Generator System for the Company Procedure and Document Department

Aat Level 3, Accounting

Aat Lever 2, Accounting And Finance

Book-Keeping And Sage 50 Level 1, Accounting

Project Management

Bs(Hons) Degree Computer Science, Information Technology