Build a microservice on AWS with a small DB

We need to build a microservice to qualify customer base. This microservice will ------------------------------------------------------------------------ Upload basic tables -these may be updated with a tradidional DB admin tool ATECO codes ADRESS Country, Region, Province ROLES CATEGORY INDUSTRIES ---------------------------------------------------------------------------- FLOW 1: INGEST COMPANIES 1. upload contacts data of companies in .xls or .csv in company table - Company Id - VAT - Company Name - Company Address (Country, Region, Province, Street) - Industry - Categoy - ATECO codes (standard industrial code) - Status (initially STATUS="in qualification") Primary key may be VAT or Comany Id -when we upload an external DB we may use alternatively one of these two keys -To be discussed- 2. look in company table if company data are already in company table (look-up VAT or CompanyId) then do not import Otherways check for missing fields (i.e. category industry) and ask for completion upload Place Of Business (Locations) - POB primary key - POB Address (Country, Region, Province, Street) ------------------------------------------------------------------------------ FLOW 2: INGEST INDIVIDUALS 1. upload contacts data of individuals in .xls or .csv in employee table - Name - Surname - Mail -Unique no duplicate - Company - Job title - Role - LinkedinURL -Unique no duplicate - Status (initially In Qualification) - Address (Country, Region, Province) 2. look into the employee table to see if there is a record with same name+surname 2.a. if it finds one or more records (or similar) name+surname already in the db the sys show the 2-3 records Name, Surname, Company, Role so that the user can: merge,remove duplicate, cancel this because there may be homonymy cases 2.b. if there is no duplicate record then we go to step 3 3. sys look into comapny table if there are SIMILAR Company Names 3.a. if there are similar company names the sys returns a set of similar records so that the user can choose the proper one i.e. Barilla Fll.i Spa (on the xls upladed): Fratelli Barilla Spa, Barilla Logistic, Barilla e Figli Spa if a proper company match is found we go to step 4 3.b. if the company is not in the sys yet it goes on a special list the user insert company name in a special list and the sys set company status:="To be Qualified" individual:="To be Qualified" The user will look into Italian Company Register to qualify them (see FLOW3) 4. sys shows individual job title uploaded and a set of possible role (based upon company category small, medium, large, insitution) the user select the most appropiate role based on job title the sys stet company status="Qualified" individual status="Qualified" --------------------------------------------------------------- ----- NOTE A company get qualified when it has at least an individual company linked and the same for an individual (when we match with companY) and we know company details and have a mail. ---- --------------------------------------------------------------- FLOW 3: COMPANY TO BE QUALIFIED If the company is new (Flow 2) and not present in the sys it is placed in a qualification list (when we have no VAT or company Id) The user access this list of company to be Qualified and manually update all fields on a webform or just uplad an xls After company data are updated the user also qualify employees (FLOW2) and update company status=Qualified individual=qualified and updated staus Company Status= "Qualified" There is another status that may be "Died" if we do not find the company or it is bankrupt