Public Shools Data Management, An American Company, Aug 2024 – Sep 2024

Gabriel Avadani
Published

0
  • Project creator

Full Stack Developer

Project description:
development of an application that retrieves data from the Public Schools API and compares it with data from Excel files provided by the client.

Responsibilities:

  • built the application using React, TypeScript and NextJS; used Tailwind and CSS for styling the application;
  • called REST services from the Public Schools API to extract data about public schools in the U.S.;
  • implemented functionality to compare the data retrieved from the API with the data written in Excel files and to fill in any missing fields in the files using information from the API;
  • uploaded the Excel files to Azure Data Factory and created triggers to update the data whenever new Excel files were uploaded to a specific cloud folder;
  • used React Context for global state management;
  • used Vercel to deploy the application;
  • worked in a team of three, following a combination of AGILE and Feature-Driven Development methodologies; used peer-to-peer programming to help junior developers learn and to speed up the development of certain features;
  • used Git and GitHub for code versioning and branching.

Technologies:
REST, Vercel, React, TypeScript, NextJS, Tailwind, CSS, Public Schools API, Excel, Azure Data Factory, Git, GitHub, React Context.