BacklogConsultingTell me your case

IT consulting · Barcelona

Your businessis not standard.Your solutions,neither.

Custom development that understands your processes. I turn scattered spreadsheets into systems that hold the business up: consolidated data, automated processes and reports worth making decisions with.

Profile
Computer Engineer · UAB
Experience
Industry · Retail · Finance
Way of working
Direct, no middlemen
Q1 contributions · real caseExcel → DataMart

Input · manual Excel

PlantAmountStatus
CTE-0135.200,00 €ok
CTE-02#N/A—
BCN-0312.480,50 €manual
MAD-04(pending)—

PowerShell · SQL · ETL

Output · DataMart

PlantAmount EURStatus
CTE-0135200.00validated
CTE-020.00excluded
BCN-0312480.50validated
MAD-048100.00pending

Before four sheets, 50-55 plants, manual phase-by-phase close. After one consolidated source, with balance sheet and P&L.

Usual stack
  • Excel
  • SQL Server
  • Power BI
  • PowerShell
  • Python
  • .NET
  • PostgreSQL
  • Apps Script

Services that fit the way you work

I don't sell hours, I sell outcomes: data where there used to be spreadsheets, processes where there used to be manual tasks, reports where there used to be guesswork.

  • Data

    Data extraction, loading and transformation (ETL)

    Creation of structured data environments for sales, stock and operational performance analysis.

    • DataMarts
    • Loads
    • Migrations
  • Backend

    Databases: SQL analysis, creation and optimization

    Modeling, queries and maintenance of the data stores that underpin reporting.

    • SQL Server
    • MySQL
    • PostgreSQL
    • SQLite
  • Decision

    Reporting and Business Intelligence

    Financial and operational reports, Excel dashboards and training so your team can use them without me.

    • Financial
    • Operational
    • Dashboards
    • Training
  • Consolidation

    Distributed budget contribution

    Coordination of information across international delegations, integrating flows with existing tools such as Excel or databases.

    • EXCEL–WEB–DB
  • Product

    Custom software creation and maintenance

    Online catalogs, control panels, internal and public websites. APIs, .NET and legacy maintenance too.

    • APIs
    • .NET
    • Apps Script
    • VBasic 6
  • Automation

    Process automation and improvement

    I design solutions that eliminate repetitive manual tasks, improving efficiency and reducing errors.

    • PowerShell
    • Python
    • Excel

I pick the tool that holds up the expected result

From automation with PowerShell to data management with SQL, from custom development with .NET to intelligent reports in Excel and Power BI.

Data

  • SQL ServerMicrosoft database, secure and used in companies to manage large volumes of information.
  • MySQL / MariaDBPopular and fast database system, widely used in websites and applications.
  • PostgreSQLVery powerful and flexible database, ideal for complex data and growing applications.
  • SQLiteSmall, powerful and simple engine that stores data in a single file: apps and mobile devices.

Automation

  • PowerShellAutomates complex tasks on Windows: alerts, backups, email.
  • PythonSimple and versatile, from web development to data science.
  • Apps ScriptGoogle scripting language for Drive, Sheets and Docs.

Product

  • C# / .NETBuilding Windows applications and web services, modern and easy to understand.
  • HTML / CSS / JSThe base of any interface: structure, style and interactivity.

Decision

  • ExcelVersatile with numerical data, automatic calculations and dashboards.
  • Power BITransforms data into visual reports and interactive dashboards.

Real projects, concrete results

Details nobody tells on a consulting website: users, deadlines and what changed after handover.

Finance

Distributed budget contribution system

Multinational in the automotive sector, with 50-55 production plants in Europe.

See the detail
Solution
Automated financial contribution system from Excel.
Technology
Excel templates adapted to existing processes.
Results
Remote data collection, phase control and centralized consolidation (balance sheet and P&L).

Real Estate

Online real estate platform

Real estate company based in Catalonia.

See the detail
Solution
Online property catalog.
Features
Advanced filters, favorites, interactive map, image carousel, product sheet and suggestions.
Objective
Improvement of user experience and visual navigation.

Finance

Financial environment support and automation

Spanish financial institution with international presence and 50 branches.

See the detail
Area
Regulatory compliance: anti-money laundering law.
Solution
Database maintenance and data contribution tools.
Extra
Budget follow-up comment system between delegations and headquarters on Google Sheets, with access control and restricted areas per role.

Retail

DataMart design and implementation in the Retail sector

International retail company (DIY / home improvement).

See the detail
Solution
Sales and stock DataMart.
Scope
Design and functional analysis, database model programming and ETL processes, data exploitation for reporting and analysis.
Objective
Improvement in commercial decision-making from centralized data.
Marcelo, IT consultant at Backlog Consulting

Marcelo · Backlog Consulting

I'm Marcelo, a computer engineer

From the Autonomous University of Barcelona, specialised in programming and development of customised IT solutions for companies.

With solid experience in sectors such as industry, retail and finance, I help my clients optimize their processes through automation, data analysis and custom tool programming.

I translate your business needs into real and sustainable technological solutions, always with clear communication, aimed at non-technical users. The way work is done is as important as what is developed.

  • Active listening

    Before developing, I carefully listen to what the company really needs.

  • Analytical thinking

    Breaking complex problems down and finding clear, viable and scalable solutions.

  • Collaborative work

    I integrate into multidisciplinary teams, working autonomously or in coordination with IT services.

  • Adaptability

    Every client and every project is different: I adapt to new methodologies and tools.

  • Clear communication

    I translate technical language into understandable terms, so everyone stays aligned.

  • Time and priority management

    Development in phases, adjusting time and resources according to objectives and needs.

I believe in a human and honest approach to technical work: close, committed and oriented to generating trust.

Tell me what is eating your time

A manual process that won't scale, an Excel that no longer holds up, a report nobody trusts. That's enough to start.

  • 01Understanding the context and the current process.
  • 02A proposal with scope, timeline and tooling.
  • 03Development in phases, with follow-up.