John Spencer

Strategic Pricing, Cost Modelling, Financial Optimization •Defined optimal pricing (Cost+ vs. Value-Based vs Market-Based) using Hadoop (later Azure) for price books using SQL •Developed Python CNN to estimate missing Airport Port costs •Dashboards comparing current book price with final sales price •Collaborated with product managers to ensuring product structure fitted pricing & sales tools •Worked with Sales teams on customer bids with special requests •Subscription-based pricing (with bands) to voice and contact centre products Business Process Management (BPM) •Standardized Business Case tool/process for finance statements and cash flow tools •Optimized new product development by leveraging existing infrastructure and best practices, balancing cost vs. revenue •Migrated airport products to QTB process (Salesforce), replacing manual processes while securing sensitive data ($600 million/year) •Harmonized VAS products in QTB process (Oracle), reducing new product requirement lead time from 1 year to 3 months ($20 million/year) •Guided business units in transitioning from Excel/Word templates to systematic tools Business Intelligence (BI) •Developed Python ML using linear regression to model price-to-speed curves •Dashboard showing the success rate of quotes that became orders, with action plan in under performing countries •Designed Python/Power BI dashboards analysing network speed growth, distribution & outliers vs. Gartner data •Data-driven customer insights to maximize margins and perform predictive analysis on revenue expectations •Dashboards receiving CEO praise Competitor Benchmarking & Price Book Negotiation •Collaborated annually with Gartner to benchmark network products across 114 countries •Negotiated with Orange Business ~$150M annually for Network, Voice, and Contact Centre products •Price books yielding 5-10% annual cost savings •Calculated volume discount on 500,000 supplier invoice records to ensure accurate contract application

Managed Invoice Production Team and acted as a Data Subject Matter Expert optimizing data management systems and processes to enhance revenue tracking and system efficiency. While also transforming key parts of the corporate order to bill process. Management • Between 2012 & 2015 Managed the INC team covering 50% of the company's revenue streams • Between 2015 & 2019 Lead Invoice Production Team – 120M$ Month 500 B2B customers, 4000 invoices globally Project Management & Business Process (BPM) - Agile Method • Development of new in house ordering system (SODA) leaning on Hadoop/Cloudera to replace the aging Oracle/Siebel system. 30% of assets worth 10 million$ a month migrated in year one • Standardization of pricing process within the system across all solution lines (5 solution lines each with a process merged into one) BI Reporting & Follow-up • Data gap reports between systems (BI Dashboards) – comparison between 20000 Assets within ordering system and 20000 assets within billing using Impala/Hadoop including record characteristics • Revenue variation reports (Oracle SQL) – 40 pages of SQL comparing test invoicing data with previous two months (or yearly) across all 200+ products for 100 million+ USD per month • Data rejection reports (API reports) – review of type of error (system issue, rating issue, data issues etc) The above required me to be Data Subject Matter Expert • Requirement definition for Business needs • Project management, Implementation and testing • Change management • Mapping out complex data systems and processes, the roles and responsibilities of each stake holder • Find gaps and weaknesses within, propose solutions • Harmonise process areas and similar data types (bandwidth values harmonised to one format between products, IATA country codes replacing country names etc) • System and process testing to ensure functional completeness compared to functional rules defined in requirements Methods • PMP, Agile, ITIL, 6 Sigma Green Belt

Change & Project Management - Waterfall & 6 Sigma Methods • Passenger Solution Lines data migration from Access and Sharepoint folders into Siebel Contract 2 Cash. 12 Million$ a month. 20M$ Missing revenues recovered in the next 2 years due to better recording of project milestones and automated reminders • Goverment Solution Lines data migration from book shelves of printed documents and excel files into Siebel Contract 2 Cash. 5 Million$ a month. Missing revenues recovered due to better recording of project milestones and reminders Customer Business Requirements Implementation & Follow-up • Provided advice to Sales on standard processes and helped them define and implement customer specific needs • Defined IT requirements both for Customer Specific requirements and New Product requirements or enhancements • Service owner of key processes and products that interfaced with Kenan (Arbor Oracle) such a Orange supplier inputs and Siebel interface • Testing of said processes • Impact Reporting and customer and product variations and improvements of processes made • Data rejection reports (API reports) – review of type of error (system issue, rating issue, data issues etc) The above required me to be Data Subject Matter Expert • Requirement definition for Business needs • Project management, Implementation and testing • Change management • Mapping out complex data systems and processes, the roles and responsibilities of each stake holder • Find gaps and weaknesses within, propose solutions • Harmonise process areas and similar data types (bandwidth values harmonised to one format between products, IATA country codes replacing country names etc) • System and process testing to ensure functional completeness compared to functional rules defined in requirements Methods • PMP, ITIL, 6 Sigma Green Belt