Viewing entries tagged
Analytics

Toyota - Master Data Management

Toyota - Master Data Management

Toyota

Master Data Management – Accessories Domain

Lead Consultant

The Toyota Accessories MDM project was the first phase of a larger MDM program of work across a number of core domains such as Parts, Vehicles and Customers. During this phase, Lyndon was engaged as a Senior Consultant to lead the analysis, identification and design of the accessories MDM solution under an agile methodology which included accessories, parts, vehicles and associated marketing collateral. During this phase, Lyndon undertook thorough analysis of each the core components of the accessories domain, uncovering and resolving significant modelling challenges and introducing new concepts to enable accurate management of accessory applicability.

  • Lead stakeholder engagement and analysis across the three core business units responsible for accessories master data management.
  • Lead the design of the data model underpinning the MDM platform
  • Undertook extensive stakeholder engagement to inform and influence business decisions to support the introduction of new concepts critical to the successful implementation of the MDM platform.
  • Conducted numerous requirements and ‘story-telling’ workshops with the business, acting as SME to bridge the gap between the technical and data related issues and the impacts to business processes.

Notable outcomes

  • Rapid delivery of an interim model, supporting the development of a proof of concept for presentation to the business within 5 weeks of project initiation. This POC was successful in gaining business support for the successful submission of the project business case.
  • Designed a model that successfully introduced two new concepts (Accessory packs and a marketing model) to Toyota to drive accurate classification and relationships within the MDM environment. This model created a fusion between engineering and marketing to drive accurate presentation of accessories to public facing channels such as the Toyota.com.au website.

Telstra - Big Data

Telstra - Big Data

Telstra

Big Data Office / Chief Technology Office

Program Manager

The Big Data Program, Telstra’s enterprise wide analytics uplift initiative with the objective to create a culture of data driven decision making through four key activities;

  1. Platform establishment – Multi-petabyte Hadoop cluster and associated services for large scale storage and connectivity;
  2. Commercial engagement – Engagement and development of Telstra internal Business Units to identify, shape and execute opportunities through analytical insight;
  3. Data acquisition – Rapid sourcing and consumption of data from across the organisation in a low cost and repeatable manner;
  4. Analytics uplift – Analytical insight, community development, leadership and capability enablement

Lyndon was engaged as Program Manager for the Big Data Office to;

  • Drive the production and socialization of business case through to delivery funding release. ($11.5m)
  • Drive delivery of key program initiatives across platform establishment; data sourcing pipeline prioritisation; commercial pipeline development, scoring and strategic roadmap development
  • Manage ownership and planning of mitigation strategies for program level risks and issues; program spend profile to budget, resourcing plan and logistical matters such as team location and asset management
  • Oversee end to end throughput of program cross functional iterations and continually optimise processes with Agile Coaches to minimize hand-offs and reduce / clear blockers
  • Management of program status reporting and chairing of Big Data management meeting
  • Drive program delivery within the boundaries of Telstra’s complex security, compliance and regulatory requirements

Notable outcomes

  • Upon commencing role, immediately altered program methodology from Waterfall to Agile mid-stream to better support the iterative lifecycle of data / analytics initiatives and enable reduced time to analytical insight.
  • Altering methodology and ceasing Solution Definition reduced the weekly PROPEX burn rate of ~$125K per week down to ~$50K per week (reducing number of resources billing to the program from between 25-30 down to 12).
  • This saving preserved budget to allow the program an additional 8 weeks to overcome challenges in gaining support from the Telstra Investment Community in supporting a negative NPV business case, without running over budget.
  • Re-purposed $900K of budgeted CAPEX to commence purchase of 1.6 petabytes of expandable cloud storage infrastructure
  • Played a key role in successfully gaining support for the negative NPV business case to secure $11.5m in phase 1 funding to;
    • Expand storage to approx. 4 petabytes
    • Ramp up large scale data acquisition
    • Invest in network analytics capability
    • Commence delivery of ‘use case’ development
    • Seeded the establishment of an enterprise wide ‘Analytics Leaders Forum’ with the view to drive cross functional analytical best practices across the numerous community silos across Telstra. This initiative received unanimous support from forum representatives.

AXA Australia - Senior Business Analyst

AXA Australia - Senior Business Analyst

As a senior member of the Enterprise Reporting and Information Management Team, Lyndon was responsible for design and production of information solutions for projects as well as operational and BAU reporting.

  • Worked with other Business Analysts and Project Managers to establish detailed business requirements of the reporting suites and dashboards as part of the project delivery.
  • Advised projects on best practice and ability to achieve implementation of requirements
  • Performed detailed analysis to estimate and quote on the design, development and delivery of reporting requirements.
  • Followed Agile development methodology developing a prototype followed by a number of review and re-work iterations to meet the final business requirements.
  • Provided subject-matter-expertise to projects and business units on data availability and usability.
  • Analysed, reconciled and consolidated existing reporting frameworks to ensure business fit-for-purpose.
  • Provided process improvement consultation to AXA's Marketing Information, CRM and Customer Retention Teams.

Notable outcomes

  • Developed a single client view application for the Customer Solutions Call Centre using the AXA data warehouse client matching technology. This tool enables Call Centre Consultants to search by a customer policy number and locate additional policies that customer holds.
  • Drove the development of the first BI based applications using the Hyperion reporting suite. This was a significant step forward in the depth of services and improvements that the Business Information Team could provide to the business and changed the BI value proposition in an extreme way.

AXA Australia - Marketing & Campaign Management

AXA Australia - Marketing & Campaign Management

As the Campaign Delivery Analyst, Lyndon was responsible for the development and execution of all of AXA’s Customer and Financial Planning direct mail, email and SMS campaigns. This role also demanded a large aspect of solution design to create end-to-end and closed loop marketing sequences linking many contact channels together to drive new sales, cross-sell, up-sell and customer retention initiatives

  • Track sales, click through, registration and other campaign related activity to measure campaign effectiveness and accuracy
  • Developed and monitored complex multi-step, multi-channel campaigns that involved automated life cycles of up to six months using the Affinium Campaign and Affinium E-message application connected to AXA's data warehouse.
  • Developed and maintained trigger based campaigns which would send reactive notification to call centres, BDM's, financial planners etc. based on the activities of customer’s policy record.

Notable outcomes

  • Single handed execution of over 100 campaigns in a single year that contributed to a CRM benefit of $57m
  • Designed and developed a trigger based campaign that detected customer withdrawal activity across different product segments. This single campaign increased customer retention results on written requests to withdraw by over 20% which resulted in a CRM benefit of $18m for the first year.
  • Devised an on premise event check-in process that based on the information fed in via a website delivered targeted emails based on product preferences to clients and advisers