A. Project Objectives
We are connecting and onboarding AirFrance - KLM business and all stakeholders to our new data driven world of Finance to create value with our vast amount of data.
This project will create a consolidated overview of Accounts Payable data from several Source to Pay flows. Various buying channels will be supported for both Airfrance and KLM (systems include SAP MM, SAP SRM, SAP FiCo, Basware, Airpas, Fuelplus etc..).
The solution will be used by Accounting, Controlling, Treasury and External Suppliers, via a portal.
The 'legacy' Accounts Patable Datamart system, currently in use for KLM only, will be replaced and utilized for the Air France KLM group. Key elements are:
- Possibility to look up statuses of invoices (received, approved, paid, rejected) by both internal staff and external suppliers
- Management reporting and dashboarding, e.g lead time reporting, invoice scanning times, approval times, etc..; Data mining
- Related support requirement: Easy access to the data store for all users with standard front-ends like Spotfire...SAP Analytics Cloud ...
- Liquidity forecasting based upon the number and amount of invoices
- Internal Control Framework (double invoices / 50k list) - Signal functions
B. Case description
One of the Business Case drivers is the needed replacement of IS mainframe- and SAS legacy solutions, crucial to reduce support risks and recurring operational cost.
Another major goal is to build a warehouse completely compliant to our Datahub architecture (a.o. HANA/BW, MS-SQL, Hadoop, Powercenter, Talend), and facilitate reporting with Spotfire and SAP-Analytics Cloud.
C. Goals & deliverables for Intern:
1. Project Execution Participation. Interact with our IT Specialists and Business analyst as a full projectmember. Co-work on project backlog with periodic reporting, on:
- Requirement refinement, Documentation
- Data modeling, Design of Data ingestion process
- Report design, Build and test
2. Evaluate Strengths / Weaknesses of organizational aspects with regard to the project target
Eleborate on organizational conditions within Airfrance KLM applicable for execution of this project.
Background : Airfrance and KLM Businesses, Information Management and IT departements are setup in a complex hierarchical and functional model due to the size and origin of Airfrance KLM as a company. The organisation has adopted Agile elements to optimize change management processes.
3. Evaluate Strengths / Weaknesses of the Datahub toolset with regard to the project target
Eleborate on effectiveness and efficiency of current toolset within Airfrance KLM applicable for execution of this project.
Background : Airfrance KLM has designed an architecture to support its Data driven ambition. For the Finance & Procurement domain a clear toolset has been selected that fits into this architecture and is compliant with the Finance roadmap, legacy landscape and organisation.
D. Type of project
Functional Area : Accounts Payable processes; Ordering, Invoicing and Payment processing
Information Technology Area : Data lake. Data modeling. Reporting & Dashboarding
Organizational Area : Airfrance and KLM Company. Business and IT
E. Skills & competences
Result oriented
Organizational awareness
Communication
Analytical
Teamwork
Tenacity
Project owner:
Air France KLM - IMO Finance & Procurement
Information Manager : Johan bij de Vaate
Business Analyst : Marion Kagenaar
Business Architect : Indra Azir