Database Analysis, a German Ministry, Jul 2024 – Aug 2024

Gabriel Avadani
Published

0
  • Project creator

Full Stack Developer

Project description:
Analyzed and processed database tables to identify correlations between them and to understand the type of data stored in each table.

Responsibilities:

  • developed an application using NextJS, React, TypeScript, Tailwind, and CSS to display data in data grids, generate charts, and perform CRUD operations;
  • used large language models (LLMs) to interpret table name abbreviations – such as 01GF2100KLN111 – to understands what kind of data the tables might contain and to identify possible linking tables;
  • worked closely with a team of consultants to better understand potential business requirements and to analyze the data using Excel functions, pivot tables, and various charts;
  • used Lucidchart and its AI features to create entity-relationship diagrams and gain a clearer understanding of table relationships;
  • worked in a team of five, including one developer, one project owner, and four consultants following AGILE and Lean Software Development methodologies;
  • used Git and GitHub for code versioning and branching.

Technologies:
NextJS, React, TypeScript, CSS, Microsoft Excel, LucidChart, Git, GitHub, Vercel.