Pedro Cordon

Experience

• 

  TecPro Guatemala (Exxon Mobil Contractor)

  Feb 2004 - Jul 2006

  Safety, Health & Environmental Advisor
• 

  ExxonMobil

  Jul 2006 - Jul 2011

  - Developing yearly planning and budgeting reports using SAP ERP and BI for presentation to senior stakeholders.- Monitoring and overseeing OPEX and CAPEX cost centres, account analysis and corrective accrual and journal posting.- Coordinating a team of 15 employees at various levels. - Negotiating with suppliers to minimise expenses incurred across the whole organisation.- Serving as custodian of the Controls Integrity Management System (CIMS) and the Operations Integrity Management System (OIMS)- Collating and presenting operational KPI’s to senior stakeholders and budget owners. Show less - Super user in SAP ERP in the logistics team, involving business process analysis, testing, user training, solution implementation, and post go-live support.- Designing strategies to minimise stock losses, identify theft and improve inventory accuracy in SAP. This involved analysis across the whole supply chain process to identify the source of variations.- Training new SAP system users and writing training documentation, including user guides, help cards, exercise booklets and PowerPoint slide decks.- Serving as Business Intelligence power user, designing and customising of new reports and queries for use across the entire logistics department.- Generating reports and KPIs for using SAP, Business Intelligence, Microsoft Access and Excel Show less

  • Facilities Planning & Operations Advisor

    Jan 2011 - Jul 2011

  • Logistics Senior Data Analyst

    Jul 2006 - Jan 2011
• 

  NCC Group

  Mar 2012 - Oct 2021

  - Leading the data and reporting workstream in a £25M systems transformation programme across all company regions (UK, EU, APAC and North America). Systems implemented include Salesforce (CRM), Workday (Financials, HCM and PSA), Domo (data warehouse and BI) and Microsoft Azure.- Designing, planning and managing the data migration from over 40 legacy systems, including Microsoft Dynamics CRM, Navision, ADP, Sage HR, QuickBooks, Xero, Infor CRM, Salesforce, Sage X3 and multiple SQL databases.- Devising the programme data migration strategy, including data scoping, cleansing, ETL process, reconciliation and signoff, plus the transition into BAU.- Designing and implementing a data warehouse solution incorporating new and legacy data sources to support the data transformation and future reporting. - Designing the company reporting strategy, and leading the delivery of operational and management reporting, and management intelligence across the new solutions. Show less - Defining and building the Master Data Team from scratch to support the company global data and reporting needs.- Working with the company CEO on a project to redefine and implement the data management strategy.- Implementing and embedding validations, monitoring and alerts to support GDPR legislation across all CRM solutions.- Managing and leading Master Data Team members in addition to sourcing and integrating new starters.- Leading the data migration on all internal projects across the company, including acquisitions, new system implementations and system upgrades. Covered business process analysis, data mapping and ETL. Relevant systems include Sage HR, Infor CRM and Sage X3 (covering HR, sales and finance areas). Show less - Supporting the data migration process from legacy system to SAP, including data cleansing, transformation and loading.- Performing reconciliations between SAP and legacy systems.- Managing transactional and master data across SAP CRM and ERP.- Coordinating project RAID logs across data and reporting stream.- Ensuring operational effectiveness between Operations and Finance Department in preparation for SAP system go-live- Delivering reports across SAP BI, Crystal Reports and SQL SSMS. Show less

  • Data and Reporting Transformation Lead

    Jan 2019 - Oct 2021

  • Data and Reporting Manager

    Jul 2015 - Dec 2018

  • Data Migration and Reporting Analyst

    Mar 2012 - Jun 2015
• 

  PwC UK

  Nov 2021 - now

  Technology, Data & Analytics Senior Manager