Projects · 02

Data & Automation

Document control, ERP integrations, reporting pipelines, scrapers and data analysis.

← Back to the portfolio

  1.   Paredes, J. “DocFlow SaaS, End-to-end document control for engineering project orders, reading the company ERP in read-only mode. Parses client transmittal returns from 8 portals (eGesDoc/Técnicas Reunidas, AYESA, SACYR Proarc, PRODOC/Wood, Document Space/Hyundai, GAIA, Aconex, Sendoc), auto-downloads portal packages and files every returned PDF into its network folder without ever overwriting an archived revision. Also generates client cover sheets from Word/Excel templates, the monthly Vendor Progress Report, 3-level claim escalation, DocuSign envelopes, departmental views (sales, purchasing, production, quality, administration, warehouse) and interactive web + Excel reporting, with AI summaries via Claude.
    [code]

  2.   Paredes, J. “TABLEAU, Documentation Flow Dashboard, A visual progress report designed to monitor document inflow, processing, and delivery across projects.
    [View on Tableau Public]

  3.   Paredes, J. “DocuControl, Automation of reports and document control, focused on the analysis of data exported from ERP and the generation of advanced visual reports.
    [code] (Private repo)

  4.   Paredes, J. “Email MAPI Tools Automation” Automation of documentation entry through email (Outlook/IMAP) to excel and BBDD (ERP).
    [code]

  5.   Serrano, E., Paredes, J. “EIPSA ERP” Based on an ERP (Enterprise Resource Planning) system to manage the different daily activities of the different sections of the company.
    [code]

  6.   Paredes, J. “HLTV Team and Player Stats Scraper” Scraping and data analysis of each individual and team player for the Counter Strike 2 competitive game.
    [code]

  7.   Paredes, J. “Twitter - Sentiment Analysis with Emojis” using emojis to classify the emotional tone of tweets. By leveraging Natural Language Processing (NLP) techniques.
    [code]

  8.   Paredes, J. “Twitter Sentiment Analysis” identifying positive and negative emotions while exploring various natural language characteristics.
    [code]

  9.   Paredes, J. “Analysis of Traffic Accidents” Analysis and predictions of Traffic Accidents in the City of Madrid
    [code]

  10.   Paredes, J. “Data Wrangling Titanic” - Complete cleaning and analysis of the Titanic dataset using pandas.
    [code]

  11.   Paredes, J. “Monitoring Report Automation” - Reduce report generation times and minimize manual data entry errors.
    [code]


Click here if you'd like to collaborate with me:)