Database Migration

A major client managing numerous hotels switched from their old CRM to ours and needed to migrate their database into our system. We received a sample of their data, which allowed us to assess the feasibility of the migration and be fully prepared for migration day. I decided to log the old IDs and their new counterparts in a separate file, enabling us to reuse them later for foreign keys and ensuring we wouldn’t need to process the same row again in case of a crash or timeout.
It was a complex migration. The migration data was divided into multiple files, one for each table, with some files containing up to 60,000 rows. The only format provided was Excel.

Refactoring

I worked on refactoring parts of the CRM on my own Git branch, including adding more user roles, improving the display of certain pages, and enhancing the JavaScript for pre-filling fields.

Roles

I added a role, functions associated with it, and access to pages based on roles.

Refactoring of 'Day' View

Our 'day' view did not match the display of the other views. My task was to adapt it to ensure consistency with the others.