projects@APDCA

by

[2017-2023]

During 2017-2023 I developed some solo projects in this entity. Actually I was the only one in the IT department, per se. This is a non-profit association that represents used car dealers (APDCA) in Portugal… and to be fair, at the time it started up with scarce financial and human resources. My job was to support them in technology and internet, creating solutions, services, optimizing processes and operations, creating the website, CRM, etc. Here I am as IT consultant and full stack developer.

  • Programa Usado Certificado APDCA [php, MySQL, API integrations]
    A “Program for Used car Certified by APDCA” kinda translated into english. This refers to a quality certification program that is assigned to a used car that is on sale. It is exclusive to APDCA associates and started in 2021. It is based on an internal service with an API exposed to partners (vehicle inspectors and entities that make the request). We centralize all vehicle information from dealerships certified by us, managing certification requests, evaluating and generating reports.

  • Filemaker apps [Filemaker, REST API integration, Custom API integration]
    Faced with some situations of the need to develop local applications quickly and efficiently, I choose to use the application development platform Filemaker (Claris Filemaker) since I already had experience with it and it was a good ally in RAD development where it saves us time in UI development for example, being also cross platform.
    • APDCA Eventos
      application for managing registrations, tickets and check-in for APDCA conventions
    • APDCA Prospection Mailing
      new members prospection and scraped data quality check and physical mailing management
    • IC from BdP Mailing
      new members prospection and data quality check and physical mailing control
    • APDCA Admissão e Regulamento
      small tool to generate the welcome email with legal documents attached, for the admission of a new member
    • CTT Impressões
      small tool to easily print paper forms to be sent by registered mail with acknowledgment of receipt

  • APDCA institutional site & members back office area [php, MySQL, WordPress integration]
    Site based on WordPress (a decision taken due to the limitation of human resources vs. deadlines) with close integration with the association’s internal data, resorting to the use of customized code, with private areas of the members where they have numerous services and documents generated at runtime.

  • Web Apps for mobile screens [php, MySQL, Javascript]
    • Matrícula Cancelada
      A small web app for checking whether a car registration license is canceled or not. It uses as a resource a proxy rest service that I created that actually replicates the post/request to the official website that provides this information (they don’t provide API). Kind of a hybrid scraping service in realtime. We created this for our associates so they would have a simple and mobile interface version to use.
    • Data Matrícula
      A small web app for checking the year date of a car registration license. Created this for our associates so they would have a simple and mobile version to use.

  • Transversal services for use on the website and internal applications
    • PDF document generator service [php]
    • custom QR CODE generator service [php]
    • Geolocation service for validation of districts, municipalities, postal codes
    • Internal API for obtaining data from association members [php, MySQL]

  • Cron Job processes [php, MySQL]
    Synchronizing internal membership database with external partners and providers
    • Sync AgileCRM via API with main APDCA members database
    • Sync Invoicexpress via API and process information from members in debt
    • Sync WordPress database with members in debt to control their site access

  • Process IC from BdP [php, MySQL]
    This web application was born voluntarily on my initiative. There was a recurrent manual procedure by an employee that was tedious and not very productive; it involved downloading an excel file from one site on a regular basis, filtering certain rows in that file and using those results to search for other related data on two other sites and putting it all together in another excel for future prospecting. This process was repeated because the excel file to be downloaded was regularly updated by the site and it was necessary to fetch new data. I ended up with that manual process… of course.

  • Instrumenta [php, MySQL]
    This is a web application created for the association’s internal use with the aim of streamlining internal and administrative processes in order to alleviate the lack of human resources. Used to consult affiliate and associate programs, their contracts and their activations or cancellations. It is a scalable project to support new setups and programs.

  • Online elections for new board members [php, MySQL, WordPress integration]
    Due to the confinement caused by the COVID pandemic, in 2020 there was a need to create a way to carry out elections online in a safe and confidential manner. Members received a unique token code via SMS, which they could then use to vote in their private area on the association’s website. This token was crossed and validated with the logged in user’s information. This was supported all in a database with the appropriate lists and candidate members data, that also served to render on the voting page. There was also a page for the management board to follow the voting progress.

  • Console app scrapping [C#, MySQL]
    Perhaps the second application I made in APDCA, was about creating a second database with potential associates for prospecting. The data came from public information on public websites via custom scraping. Used also a process to OCR GIFs that contained email. It was interesting.

  • Prospecções web tool [php, MySQL]
    Simple web application created for the early board members who competed with each other to attract new members. In this way, it registered who recruited whom, also creating a ranking. It was synchronized with the main CRM web application, AgileCRM.

Tags