Ana Villena Alguacil

Client : CDiscount Advertising.

Position : Data Engineer

Team : Automation & BI

Task :

- Pipeline building

- Automation management of Google Ads campaigns : creation budget monitoring, modification... Reporting on PBI

- Business API communication

Department : Strategy & Business Improvement for Customer Service Conformance 06/22 - 02/23 Position :

Data Analyst & Business Improvement manager

Task :

a. Support to Supplier Rating Campaign Leader. The Supplier Rating is the annual survey sent by Airbus to Airlines to assess Suppliers in the services and support given in the aftermarket. In this context, the main responsibilities:

- Manage data inputs needed to set-up survey platform : data collection / cleaning / enrichment

- Lead workshops with the different stakeholders to define dashboarding requirements to publish the survey results.

-Colead project of survey tool transfer to Qualtrics tool.

b. Digital Transformation

- Suppliers OTD (On time Delivery) performance monitor dashboard development in Skywise.

- Skill assessment tool development Dashboard to monitor each business unit competence status.

- Dashboard to monitor the performance of teams in the reply process to Airlines request in SAP Analytics Cloud Digital roadmap construction.

Environment :

Skywise (Contour, Reports, Slate, Code Workbook, Repository) Python (Pandas, Numpy) SQL(Postgresql, Spark SQL) Pyspark Javascript Qualtrics Google App Script SAP Analytics Cloud Google Studio Agile LBIP + project management

Task :

- Design, create and maintain dashboards to answer business reporting requirements and tools to support business daily basis.

- Reports based on data exploration & wrangling to identify root causes or improvement opportunities.

- Collaborate with team members to make data accessible to every one

- Key-player in department digital projects

- Quality Control Room (QCT) project co-management :

- Operational data and needs understanding.

- Digital reporting solutions proposition.

- User-story redaction & backlog follow-up

- Development team management

- Demo meeting drumbeat

- Department's finance management support :

- Yearly budget requirements consolidation

- Purchase orders launch, follow-up and reception

- Focal point for FALs performance

- Monthly performance report production & review Yearly KPIs & target definition

Environment

Skywise (Contour, Reports, Slate, Code Workbook, Repository) Python (Pandas, Numpy) SQL(Postgresql, Spark SQL) Pyspark Javascript HTML CSS Agile