Bruno Chasqueira

Bruno Chasqueira - - linkedin.com/in/bruno-chasqueiraLondon, UK I am an individual QBE with 27 years working for major organizations, split between Private & Public sectors (like Shell, Santander, Morgan Stanley, NHS, University of Strathclyde, Methods, Embridge, UKAEA, DSRL, BT, Edinburgh City Council, 3 Major Boroughs of London, Brunswick Group, WSP, WebBeds, Unit4, Alzheimers Society and others), with a diverse range of roles within: Accountancy & Finance (including SSC's), Banking & Investments, Corporate Advisory, Public Institutions like UK Government Nuclear sites, and last 8 years as Enterprise Resources Planning Consultant. I have background of using multiple ERP systems across different sectors & implementing them (Unit4, Oracle/ JDEdwards, SAP Business One, AS400). I have 17 years of Accountancy, Financial and Banking experience which can be provided details upon request. I'm an advance user of SQL code & ARC (SQL Report Writer & ARC Developer training taken & certified by Unit4). I have become an intermediate user of JSON coding. I have experience with a full Project cycle, i.e., Unit4 ERP implementation (most modules, including Experience Packs), leading solution design workshops, creating build plans & data collection, build & configure, perform IST testing, assist customer with UAT testing & Go-Live support. I have added to my profile further experience in Internet Marketing and HTML (can create websites, basic user of tools like Dreamweaver & Photoshop, knowledge of SEO, Google tools & Social Book-markings), all achieved through hobbies and personal time. I am a self-motivated, enthusiastic, energetic, analytical, honest, hardworking individual that thrives at an impossible challenge and will always exceed expectations. Experience Career Break Personal goal pursuit Aug 2023 - June 2024 Taking some personal time off to focus on personal objectives pursuit. ERP Implementation Consultant – R2R/Project Management Alzheimer's Society Mar 2023 – July 2023 London, UK Re-Implementing ERPx Re-design of Chart of Accounts, Account Rules, Attributes & Relations, Tax codes/system Design/Build of Project Management module, as it was not considered before Assisting all project team with knowledge share about Unit4 ERPx and how it all works Designing and configuring Workflow maps and rules Implementation of Single client, with 3 entities, using Cat7 Design if Reports within ERPx to match Stakeholder’s Requirements ERP (HRP/RES) Implementation Consultant ERP Unit4 Feb 2022 - Feb 2023 Remote working London - UK Become advanced user of Unit4 functionality "FXFILL - Auto Pop", and applied it to various HR forms build for ROC Various years of SQL experience was used a lot in Auto-pop functionality. JSON code used to create various Service Calls to write back to ERP system All HR processes are build using over 24 forms, where these forms pretty much dictate all HR functionality for ROC Build over 12 forms, and assisted fixing SQL with other ones Assisted Payroll in fixing a lot of Payroll sections, within the forms, with various auto-calculated fields, which needed various complex SQL scripts, to complete these tasks Fix errors with IST1 phase Helped prepare new environment/copy for IST2 phase Regular weekly calls with customer ROC, to discuss flaws with design/build, and different solutions to accommodate proper function of forms and HR processes Regular bi-weekly calls to discuss Payroll calculated fields and enhance them to accommodate customer expected outcome Skills: Forms · web form · SQL · JSON · Service Call · Web Services API ERP Consultant WebBeds Dec 2018 – Feb 2022 London – Palma de Majorca (alternate between 2 locations) Brought in to fix loads of errors & issues with their implementation of Unit4 ERP Milestone 6 – Update 4, of Financials module & Logistics module, in their Office in Palma de Majorca. Resolved major issues & errors arisen from the Data Migration. Development of various Excelerator reports in SQL (RESQL) to accommodate to the way ERP was initially designed & implemented. Assisted full AR reconciliation by Cat2 (Booking_id) Administration of UNIT4 ERP Interface with Booking systems (Hotel Maker; Maker), using Logistics (LG04) Re-designed the whole Bank Reconciliation configuration & process within ERP system Developed different versions of Aged Debtors Report, in SQL, via Excelerator Deployed Year End in PROD, as never been completed before my arrival. Various enhancements on the customization of AR Statements processing (SHT003) – Re-design SQL code behind it Deployed Currency revaluation in Production environment Re-designed the Master Template for GL Journal Post back Re-configuration of all User accounts, Role id’s and respective access rights ERP Consultant WSP Sep 2018 - Nov 2018 (3 months) Leeds - UK Brought in to assist in improving month end processes for Finance & Payroll & any other improvements deemed required Working on Milestone 6, Update 2 Helped design a GL07 Batch Input journal template, that helps users identify “anticipated” fails when loading in BW, to stop various occurrences of errors, and various IT tickets logged by users Analyzed all triggers configured in BW, and due to various errors in postings, corrections, etc…, created a “Master File” where all info sits, for all P&Ds that require to have triggers setup. Then going forward, users only need to update file, and should be very quick for IT to update current Triggers Master File Designed a new process for closing Cost Centers. This is due to the major importance this attribute has on posting, and reporting in the business. This includes designing a new form, workflow process, various browser reports and SQL scripts to be ran for dependencies, including store procedures. Solved issue with Finance having over 237K rows of zero postings in GL from Timesheets. Offered solution to remove configuration of ORR rates from PCB and adjust all relevant dependencies so these postings never occur again Any other had-hoc by the business when my expertise are required. ERP Consultant Embridge Consulting Feb 2017 - May 2018 (1 year 4 months) Representing Embridge in 2 clients: CEC – The City of Edinburgh Council Designing Structured Management Reporting with Browsers, Data Model, Balance tables & SQL BT - for the Tri-Boroughs project (London Borough of Hammersmith and Fulham; Royal Borough of Kensington and Chelsea; Westminster City Council) Completed all configuration, testing and deployment of Payroll Year End for all BT customers (Tri-B) IR35 full implementation. Apprenticeship Levy full implementation Benefits in Kind full implementation. Helping solve “overdue” outstanding issues with current system built (All modules) Helped resolve major issues Tri-Boroughs has on Workflows. Solved big issue with ACRALS service queue and implement it in LIVE servers. Assisting with any other areas around BT SSC, Payroll/HR headquarters services provided to Tri- Boroughs. Designed in SQL Management Studio, Excellerator HR workflow reports to be used regularly by Tri- Boroughs to assist in solving outstanding tasks. System Developer Brunswick Group Oct 2016 - Feb 2017 (5 months) Upgrade of Unit4 ERP system from Milestone 4, Update 5 (5.7.1) “in-house servers” to Milestone 5, Update 3 (5.7.2) in the UNIT4 Cloud Implementing Timesheet, Expenses and Task Management Experience Packs Prepared all IST scripts for upgrade Full testing of all apps Mentoring/Managing 1 junior team member Build of PCB module for UK Head Office Assisting designing & introduction of workflows for Milestone 5 Report designing (Excelerators & Browser Reports, Gauges and Charts) Amendments of specific ARC templates Completing most of IST testing for upgrade to Milestone 5 Build of PCB module for US office branch Run Year End process for 20 companies in Unit4 ERP Maintenance of integration with 3rd Party systems daily (AnaPlan; Concurr; Data warehouse) Senior Enterprise Resources Planning Consultant Methods Jun 2016 - Sep 2016 (4 months) Representing Methods in 3 different projects. DSRL - Dounreay Site Restoration Limited (Public sector): Projects Costing & Billing (PCB) Lead Consultant Implementing Unit4 ERP using Magnox Template for Milestone 4 UKAEA – UK Atomic Energy Authority (Public Sector): Having in the past, built all PCB, Expenses & Payroll and Experience Packs, was brought back in to assist in solving defects for UAT Phase 3 Harlow District Council (Public Sector): Lead Consultant for major Unit4 ERP upgrade & further implementation of additional modules & extra functionality Currently using Milestone 2, version 5.4.0 SP5, to upgrade to Milestone 5, version 5.7.2 SP2 Senior ERP Consultant Agilisys Mar 2016 - May 2016 (3 months) Client Scottish Borders Council (Public Sector): Consultant for PCB and Fixed Assets modules Assisted setting up in Unit4 ERP a “standard template” to be applied specifically to public sector, mainly councils. Setting up all basic functionality in a client in Unit4 ERP Milestone 5 Completed business analysis on 3rd party software SERVITOR (Projects system) of client, which will interface with Business World. Process maps designed and preparation of design PowerPoint slides & Agenda for both PCB and FA modules workshops. Review of Design Alignment Document for Fixed Assets Senior ERP Consultant Methods Apr 2015 - Mar 2016 (1 year) Full Unit4 ERP Milestone 4 & 5 system implementation cycles experience as Lead consultant for Project costing & billing (PCB), Travel Expenses & Payroll (HR), Experience Packs (Timesheets, Expenses, Project Planner, People Planner, Reports, Tasks) All this from presenting workshops to show & design (SDD), built, test (IST), Train & assist users for testing (UAT) & deliver full system ready for go Live & provided 2 week “after-go-live” support/floor walking. Experience with following modules: Financials (AP, AR, GL, Bank Rec, FA), Logistics (Requisitions/ PO's, Sales Orders, Products/Inventory Management), Planner, HR/Payroll Working alongside UNIT4 in 1 client, including all my design/build was audited by UNIT4 with full 100% pass mark. Client UKAEA (Public Sector): Lead consultant for PCB, Expenses & Payroll (HR), Leaded workshops, assisted other Lead consultants with other modules workshops (Financials, Logistics, Planner & HR) Client GEMSERV (Private sector): Lead consultant in workshops for PCB & Expenses, assisted HR Lead Consultant with scribe notes for design workshop & was Lead consultant for PCB & Expenses design workshops. System Developer Steer Sep 2014 - Apr 2015 (8 months) Management of Unit4 ERP security & administration of 16 offices worldwide Led security & maintenance of both Business & Web servers, including Unit4 ERP Management Console Assisting the business with process and system reviews Working with internal clients to design and deliver implementation of new modules and offices Managing implementation of Unit4 ERP hot-fixes, service packs and upgrades. Providing 2nd & 3rd-Line support for existing Unit4 ERP services Creating and maintaining appropriate training materials Implemented upgrade of Unit4 ERP Milestone 4 (5.7.1) from version Milestone 3 (5.6.3) and Report Engine 9 (RESQL) from Report Engine version 8 Led implementing AP process for Head Office (London), including scanning of invoices, online expenses, Requisitions & Purchase Orders, respective workflows, accesses, data control, etc. Led review/re-designing Mexico office Unit4 ERP implementation Led implementing Unit4 ERP for Colombia office SQL Report Writer - regular analyze of SQL reports in detail, including amendments & creating new reports ARC Developer - various amendments in ARC templates, including invoices, remittances, statements, etc. & creating new templates. Assisting Integra consultant to re-design the whole HR setup in Unit4 ERP for all 16 clients Any other Unit4 ERP had-hoc. System Accountant Idox plc Oct 2013 - Aug 2014 (11 months) Led Unit4 ERP for all Group companies); Led Unit4 ERP system maintenance & functionality for all group companies (Systems administrator) Led solving all users queries through Unit4 ERP Helpdesk - Over 1650 queries solved under 8 months Implemented 13 subsidiary companies and currently preparing Implementation of the module GIS (Global Information Solution), which allows all business to be processed directly in 1 company and Unit4 ERP will spread information to all other companies accordingly. Working with modules: Financials (AP, AR, GL), Project (Timesheets, Projects/work orders, Billing), HR (Personnel, Expenses Ledger) & Logistics (Purchasing, Sales Orders) Main objective being assisting Finance with implementation & day-to-day usage of system and looking for ways to enhance Unit4 ERP, subsequently improving processes. Designing workflows, reports & browser inquiries for all group companies and users All other had-hoc related with Unit4 ERP. Financial Analyst University of Strathclyde Feb 2013 - Oct 2013 (9 months) Systems used: Oracle SAP Business One Unit4 ERP Got full Financial Unit4 training Analise current financial processes within Research Contracts Financial Department Liaise with Senior Management to show gaps within current processes, test new ways/ideas to improve efficiency and write down new documentation explaining new process, including training staff in using new procedures and PC tools Directly assist IT department & Finance with implementation of new ERP system Unit4 ERP (system designing, process mappings, staff training, super user) Execute some accounting duties when required Recovered all backlog from Research team accumulated; by myself Ad-hoc work done for Finance Manager/CFO as per requirement Financial Analyst NHS Lanarkshire Oct 2012 - Nov 2012 (2 months) ERP system used is EFIN Reporting system used is SAP Business Objects Help with implementing new Unit4 ERP system in NHS Work closely with AP manager (which is based in Monklands) to help improve their side of the processes and resolved backlog issues. Analise financial data Investigate into root cause of issues within the NHS ledger and resolve these issues Analise current financial processes and identify gaps. Liaise with Senior Management to provide new ideas to improve current processes and implement them Regular contact with laboratories within NHS (Monklands, Hairmyres and Wishaw) to improve process efficiencies and inter-departmental communication. •Various ad-hoc duties done for Head of Finance Inventory Accountant Carphone Warehouse Aug 2009 - Sep 2011 (2 years 2 months) Awarded for 3 consecutive quarters, the biggest bonus of all accounting department between 2009/2010 due to commitment and high standard performances. ERP system used was APTOS. Led all stock proof & control processes. Led producing weekly stock reports (Average cost by part, ageing detail, summary, etc...) 100% Customer support on daily basis with a variety of had-doc performed for them and queries answered Perform month end from day -1 up to +10, completing all reporting, reconciliations, journal postings, data integrity. Schedule various number of crystal reports to execute month end duties. Project Management (Project manager for the Fixed Assets Accounts Standardization project implemented in all countries) Stock writes reconciliation, Fixed Assets register & depreciation & postings, stock insurance claims rec, e-top ups rec, Full stock provision calculations and postings, GRNI and manual GRNI recs, Carrefour (biggest customer) stock movement rec, full Carrefour company movements postings, Full Carrefour balance sheet rec, Carrefour ageing rec, Balance sheet recs: RTV (return to vendor), PP (Price Protection, RR (Retro rebates), CSD (Customer service discount), unmatched Credit notes, stock control account, non-Belgium transactions rec, Stock changed items rec, VAT accounts., Department 80 & 88 transfer correction postings, Stock provision rec, Vat return preparation, VAT intrastate preparation, Intercompany rec, marketing support & costs rec & provision. Market Risk Manager Morgan Stanley Feb 2006 - May 2009 (3 years 4 months) Managing a team of 3 people Producing daily risk reports for traders in London and New York for them to assess what budget they had available for their daily stock market trading Providing daily all necessary analysis & checks to the complete process for all Morgan Stanley Market products Perform daily reconciliations for areas such as: Loans, Repos, FX products, V-Swaps, Bond Options, convertibles, Data modelling, Equity reconciliations. Involvement in many different projects, such as creating reconciliations for new products from scratch and writing down full process of the same Project Management (Led complete new process of reconciliation for new products, assess systems capability, reports available, possible issues along the way, automated all in excel (macros, pivots, various formulas, etc.) and have similar reporting outcome as all other products and fit all this into specific daily time frame Led month end reporting on business day 3, 6 and 10. Managing the demands of a client relationship while balancing the needs of the client against the availability of finite resources Actively seeking out opportunities to develop individual and team knowledge Management Accountant G1 Group Mar 2005 - Jan 2006 (11 months) Led collection from units of actual and forecast information for Sales & Wages Produce weekly Sales & Wages actual and forecast figures analysis reports Produce of weekly Sales performance reports for Management Produce of weekly wages reports Led producing the budget year pack for Management approval and afterwards discussing it with respective units Managers Balance sheet & Profit and Loss accounts reconciliation Assisting in preparation of year-end and month end accounts and all relevant schedules Involved on the project of implementation of reporting system and new procedures for finance department Variances analysis in balance sheet and P & L accounts and provide feedback to Finance Controller/ Director Financial Analyst Santander UK Sep 2004 - Mar 2005 (7 months) Investigating financial system to reconcile backlog accounts Analise current processes to highlight gaps and co-ordinate Management meetings to implement process improvements Follow up implementation by creating new written process documentation Assistant Accountant Collins Debden UK May 2004 - Jul 2004 (3 months) Duties of providing in a monthly basis a Balance sheet support in excel, justifying all entries in each individual account Monitor the budget and explain any variances existing in P & L to Finance Manager in a Monthly basis Creation and input of all journals manually Systems of accounting, sales, stock not integrated which means a constant analysis/reconciliation between systems, making sure information squares Have monthly meetings with all departments (Marketing, editorial, procurement, customer support, administration, IT) to make sure that their costs are within the budget Led Petty Cash and Foreign currency cash and respective reconciliation Preparation of VAT returns Led Inter-company invoicing and reconciliation (Transactions with Singapore, Malaysia and Australia) Making sure that all costs are accrued and paid to our main distributor/warehouse - Harper Collins Publishers Manually input any additions/Disposals for Fixed Assets (Tangible and Intangible) and calculate depreciation values and input respective journals Make in a monthly basis a spreadsheet with Cost Analysis for all departments and accounts, including a narrative for any major variances for Month/Year to Date Provide in a monthly basis all Management information in Excel spreadsheets excluding Trial Balance, examples being: Monthly sales, year to date sales, P&L costs analysis, Advertising and promotion costs, Balance sheet support, Fixed Assets, Customer support costs, administration costs, Marketing costs, Stock accruals, etc… Input 50% of invoices in Accounts Payable Ledger Execute all supplier’s reconciliation Execute manual payments (cheques) Financial Accountant Damovo Apr 2002 - Mar 2004 (2 years) Daily control and analysis of cash flow (Bank Reconciliation for 4 banks of Portugal and 18 banks for Brazil) Daily control and analysis of Fixed Assets (450 FA for Portugal and 4000 FA for Brazil), including running depreciation, Integrity reports and processing additions and disposals Control and Analyze of Inter company, including completing invoicing, creating journals when necessary and completing reconciliation's Journals creation (accruals, prepayments, payroll, bank, projects, Work in progress, etc..) and processing Variance Analyses between ledgers (Group ledger and Country ledger) and between actual against budget amounts Optics pack(Management accounts) analysis and submission to Group Assist local country with Statutory accounts and Local government requirements Assisted Business Analyst with the implementation of ERP system for both Countries and when both were finished assisted countries with difficulties. Been Led projects such as: Intercompany set up for all countries, which created around 650 accounts of customers and vendors and Budgets set up for Group Helped AP and AR standardizing their processes for Portugal and Brazil, again with timings and ways of completing the work Accounts Payable Coordinator Shell Apr 2001 - Mar 2002 (1 year) Perform fiscal control to Invoices for the section of the Accounts Payable Ledger Liaise with FSS team / local co-coordinators/ local business To resolve invoice matching queries Ensure all invoices are processed with appropriate Authorization Ensure all invoices are processed in accordance with Supplier and fiscal terms Deal effectively and efficiently with Supplier inquiries Perform statement reconciliation's Ensure continuity of supply with the Suppliers Maintain the integrity of the Accounts Payable ledger. Maintain archived records to satisfy audit and statutory Requirements Ensure confidentiality of all records especially in relation To the Data Protection Act Operate within the FSS standards for communication and Customer service Solving queries and problems Working in environment AS400 / JD Edwards Assistant Accountant JULAR Madeiras Oct 1999 - Apr 2001 (1 year 7 months) Holding company with 3 subsidiaries) Type of Company: Wood manufacturing/Factory; Reports to the Financial Director Provides financial service for 4 Medium companies Book value 1.5 million (invoicing) p.a. Control the financial payment system (Payroll), completing payroll for about 250 employees Handle the bank reconciliation for 13 banks in a daily basis Led the daily cash control for the 4 companies, completed in excel Analysis of financial reports Financial reports for management Management accounting (concentrated on monthly stock, accruals, pre payments, Fixed Assets and Work in Progress adjustments) Coding and input of financial data into accounting system Control fixed assets including running depreciation, additions and disposals, FA reports Work on the AS400/JDEdwards system Convert financial data into Excel spreadsheets Close the books on Excel Accountant SPORTFABI May 1998 - Oct 1999 (1 year 6 months) Led 2 small and medium size companies Provide financial control and input of data into accounting system Reconciliation of suspense accounts Control and analysis of bank reconciliations and payments Take accounts to Trial Balance Financial reports for Management Complete payroll for around 150/70 employees Management Accounting Assistant Accountant CHASCONTA - Accountancy Services Jan 1997 - May 1998 (1 year 5 months) Bank reconciliations Coding and Input of financial data into accounting system Analyzing Financial Data Education Escola Secundária de São João de Talha Economics, Finance 1993 - 1996 TECLA - Professional Training College Accounts and Fiscal Information, Accounting Technology/Technician and Bookkeeping 1997 - 1998 GESTINDATA – Information and Training College Cost Accounting, Accounting Technology/Technician and Bookkeeping 1998 - 1998 Licenses & Certifications Unit4 Certified ARC Developer - Unit4 Unit4 Certified SQL Report Writer - Unit4 Skills Project Management • Management Accounting • SQL • JavaScript • ERP Software • Management • JSON Honors & Awards Highest bonus of all accounting department - Carphone Warehouse Dec 2010 Awarded for 3 consecutive quarters, the biggest bonus of all accounting department between 2009/2010 due to commitment and high standard performances Super User for the all the Financial Shared Services departments - D–movo Jan 2003 Become the Super User for the all the Financial Shared Services departments Highest Pay rise in Company – Damovo Apr 2003 I was awarded with the biggest pay rise in the company in April 2003 due to my commitment and work presented during year 2002/3 in DAMOVO