Database Analysis, a German Ministry, Jul 2024 – Aug 2024
Gabriel Avadani
Published
0
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.