Om te solliciteren op deze stage, moet je met je HvA-emailadres een account aanmaken.

account aanmaken

Bedrijfsinformatie

KLM
Schiphol N-O
1117 ZL
Schiphol
102 - Convair
IMO Finance

Accounts Payable Datamart Innovation @ Air France - KLM


The Air France KLM - IMO Finance & Procurement team contributes to operational excellence in Finance through process improvements and IT innovation. Key projects are: - Finance Data Hub and –Analytics - Upscaling Robotic Process Automation use cases for Finance - Rationalization of the IT landscape of business solutions - One central Direct Operating Cost System at Procurement

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 FiCoBasware, 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 dashboardinge.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

 


Geschikt voor studenten
  • Business IT & Management
  • Software Engineering