Phil Costin

Phil costin

bookmark on deepenrich
location of Phil CostinGreater Brighton and Hove Area
Followers of Phil Costin427 followers
  • Timeline

  • About me

    Manager FP&A Systems - Corporate FP&A at Travelport

  • Education

    • University of sussex

      1991 - 1995
      Bachelor's degree german and european studies
  • Experience

    • American express

      Apr 1997 - Nov 2015

      - Establishing, developing and maintaining positive relationships with the franchise card business, and delivering effective planning, forecasting, analytical support and solutions to global finance teams - Managing all aspects of the quotes process by liaising closely with various service groups, extracting, manipulating and uploading accurate forecast data into reports, and verifying submission integrity - Providing effective support for strategic decision making, including recommending data management outlining key areas for Cognos TM1/Excel model development and margin analysis - Significantly reduced the delivery of the 5-year plan from 2 weeks to 10 minutes and consequently saved circa 10 person days, by leading the development of an automated 5-year forecasting TM1/Excel model calculating over $1b in global revenue - Enabled instant access to key metrics and statistics through the implementation of a chore-based month end process to load companywide monthly management results to Cognos TM1 cubes - Took ownership of the quotes process from the finance teams during the forecast period, providing them with more time to conduct other analyses, and substantially reduced time taken to deliver results from five days to one day after extracting, uploading and analysing forecast data vs. actuals Show less - Responsible for providing the global GNS monthly results, maintaining P&L integrity and accuracy by efficiently reconciling back to source data, and delivering in depth support to the financial team with analysis and tracking unusual entries - Conducting comprehensive analysis of monthly results, investigating variances to forecast and previous year, and producing detailed variance analysis with commentary - Providing effective TM1/Excel technical and analytical support to various global finance teams with over 300 users and ensuring the resolution of issues with optimal efficiency - Delivering an effective training program to globally based Cognos TM1 end users, the majority with no prior TM1 experience, and tailoring the syllabus in alignment with key customer requirements - Enabled the GNS business to view more up to date and accurate actuals data five days earlier than was possible by leading the migration of the GNS monthly results from Oracle to TM1. The new platform allowed me to easily analyse, troubleshoot and resolve booking issues, and work with different teams to understand the drivers of different changes in the P&L Show less - Responsible for providing technical implementations and robust solutions to the finance back office travel systems, including the Germany & Austria ACE/GMAX implementation and the Rail MI project - Managing all phases of end to end testing for all travel systems affected by various platform migrations and upgrades- Managed the technical relationship between American Express and various 3rd party companies including Citibank and Diners in order to rollout automated invoicing and billing processes. Resulted in more accurate and timely settlement of payments linked to the Travel business.- Significantly improved the customer experience resulting in increased travel bookings by facilitating the rollout of effective new tools - Played a key role in the team responsible for devising and delivering a robust new standardised user interface for travel customers Show less Managed and resolved production support issues for over 500 GMAX users. Required establishing prioritisation protocols to manage the pipeline of global requests and documenting system faults to assist developments in creating a more robust user environment.Worked with internal and external counterparties to implement system changes and enhancements to the database or any downstream feeds, improving data integrity in line with business and compliance requirements. Allowed each bank partner to receive a bespoke solution which met their own internal system needs. Show less

      • Manager Business Planning & Financial Data Analysis

        Jul 2012 - Nov 2015
      • Data Analyst Business Planning & Financial Analysis

        Apr 2008 - Jun 2012
      • Project Manager - Europe Travel Projects

        Aug 2005 - Mar 2008
      • Global MAX Production Support EMEA (AS/400) – Technical Analyst

        Jun 2000 - Jul 2005
      • American Express Travel – MIS Analyst

        May 1998 - May 2000
      • American Express Travel – Reconciliation Clerk

        Apr 1997 - May 1998
    • Hastings direct

      Nov 2015 - Apr 2016
      Finance systems and data analyst

      - Responsible for delivering all TM1 production support functions in the UK-based finance department to support the achievement of day to day objectives - Extracting and manipulating monthly financial data, producing detailed, accurate monthly and ad hoc reports, and conveying findings clearly and efficiently to senior managers and customer groups - Defining and creating comprehensive user stories for the development of a TM1/Excel underwriting planning and forecasting tool as part of an Agile team Show less

    • Travelport

      Jul 2017 - now
      • Manager FP&A Systems - Corporate FP&A

        Mar 2021 - now
      • Senior TM1 Finance Analyst

        Jul 2017 - Mar 2021
  • Licenses & Certifications

    • Ibm certified developer - cognos tm1 10.1

      Ibm
      Jun 2015
    • Ibm certified specialist - cognos tm1 10.1 data analysis

      Ibm
      Jun 2015