Collect_data_in_compliance_with_GDPR_standards

A. Project Overview:

Dev'Immediat, an auto insurance subsidiary, faces GDPR-related sanctions. To remedy this, I am tasked with recommending immediate CRM data management rules, anonymizing data for the commercial team, and creating a comprehensive report. The recommendations aim to ensure GDPR compliance, and the anonymization process involves using Microsoft Power Query on extracted data. The report, a synthesis of quality processes in data collection and preparation, is vital for repeated application during the sanction period. Attachments include the client database, data dictionary, and a checklist for guidance. The mission is crucial to regain full operational capacity within legal boundaries.

B. Steps:

1. Recommendations for CRM Data Management:

I evaluated and provided recommendations on the immediate implementation of data management rules in the CRM to comply with GDPR.

I generated a separate PDF document containing 5 recommendations, each succinctly explained, within a maximum of 2 pages.

2.Data Extraction for Commercial Performance Team:

Data Extraction for Commercial Performance Team:

Full anonymization of CRM data to comply with the imposed sanction and cease processing personal data.

Restricted access to detailed pricing data to prevent unauthorized dissemination.

I utilized Microsoft Power Query for post-extraction data cleaning and anonymization.

3.Documentation of Operations:

• I documented the entire operation in a detailed report, emphasizing adherence to quality in data processes.
• I created a concise 2-page PDF synthesis, showcasing compliance with quality processes, referring to the attached template.

C. Resources:

SQLite client database

Data dictionary

Report Template

Mission steps checklist

SKILLS:

HARD SKILLS:

Data collection, application of protection standards.

Documentation, data transfer, adherence to standards.

Data preparation, adherence to quality processes.

SOFT SKILLS:

Communication and Reporting

REFERENCES:

The anonymization of personal data.(in French)

Documentation Microsoft Power Query(in French)

Documentation Microsoft M language (in French)

Discover and start learning Power Query.(in French)