BUSINESS · DATA · SYSTEMS · AUTOMATION

Sebastian Perejra

Turning complexity into clarity.

I help businesses untangle complex processes, clean up their data, and build systems that eliminate manual work and support how work actually gets done.

11+ years of hands-on experience
PROCESSES experience inside real-world operations
less manual work
Illustrative image of a specialist in a manufacturing environment
PROCESS ANALYSIS ACTIVE
SCROLL TO CONTINUE

I came from real processes, not from code.

For more than 11 years, I've worked inside real business and manufacturing operations—where an order moves from the customer to the system, production, data, and reporting.

I've seen how ERP, MES, CRM, Excel, reports, and people interact—not on a diagram, but in day-to-day work. Where delays happen. Where data gets duplicated. Where the status in the system doesn't match what's actually happening.

That's why automation, for me, doesn't start with choosing a technology. It starts with understanding how the process really works—and where it breaks.

PROCESS FIRST Technology second.
REAL PROCESS FROM ORDER TO OUTCOME
01 Customer request
02 Order requirements
03 ERP business data
04 MES execution
05 Manufacturing real-world process
06 Data control
07 Reporting decisions
duplicate data
manual step
status mismatch

Understand first. Automate second.

I don't start with a tool. I start with one question: what's actually happening here?

01

Understand

Map the process, the data, the people, and the way the work actually flows.

WHAT'S HAPPENING?
02

Ask "why?"

Find unnecessary steps, duplication, dependencies, and weak points.

WHY THIS WAY?
03

Simplify

Remove what isn't needed and keep only the logic that adds value.

WHAT CAN WE REMOVE?
04

Automate

Only then build a system that runs reliably.

NOW WE BUILD.
PROCESS Less complexity. Fewer manual steps. More control.

Not a collection of tools. One connected system of experience.

My experience sits at the intersection of business processes, manufacturing, data, systems, and the people who use them.

SEBASTIAN Integrator of processes business ↔ systems
01

Business processes

Rules, logic, roles, and real-world workflows.

02

Manufacturing

Orders, execution, status tracking, and production operations.

03

ERP / MES

Business data and end-to-end process control.

04

CRM

Customers, activities, interactions, and data.

05

Excel / Power Query

Data prep, cleanup, logic, and modeling.

06

Power BI

KPIs, analytics, models, and reporting.

07

Testing / UAT

Scenarios, defects, retesting, and system behavior.

08

Data migration

Cleansing, mapping, validation, and reconciliation.

Automation doesn't start with automation.

There are a few principles I check in almost every process before any technical build begins.

01

If data is entered twice, sooner or later it won't match.

02

Automation doesn't fix a bad process. It just makes the problems happen faster.

03

A dashboard can't fix bad or unreliable data.

04

If only one person understands the system, that's a dependency—not a system.

05

Exceptions need to be designed alongside the standard workflow.

06

If users hate the system, being technically correct isn't enough.

THE QUESTION THAT MATTERS Does this make the process simpler, more reliable, and easier to understand?

Not just analyze it. Get it working.

I've worked on problems at the intersection of operations, enterprise systems, data, testing, reporting, and automation.

01
MANUFACTURING OPERATIONS

ERP / MES and order flow

Working with order statuses, business rules, end-to-end scenarios, and actual system behavior.

ERP MES OPS
02
DATA

Data prep, cleansing, and reconciliation

Data cleansing, mapping, validation, migration prep, and result checks.

Excel Power Query Migration
03
TESTING

Test scenarios, defects, and UAT

Reproducing defects, documenting evidence, verifying fixes, retesting, and supporting user acceptance testing.

Testing UAT Retest
04
ANALYTICS

KPIs, models, and reporting

Preparing data for analysis, building models, metrics, reports, and analytical dashboards.

Power BI DAX KPI
05
AUTOMATION

Manual work → repeatable logic

Automating repetitive operations, data processing, checks, reporting, and workflows.

VBA Apps Script JavaScript
06
INTEGRATIONS

CRM, systems, and operational data

Working with integration scenarios, data exchange logic, CRM behavior, and system-to-system interactions.

CRM Integration Data Flow
FROM PROBLEM TO OUTCOME Understand → validate → simplify → build → test

The tools changed. The approach became more systematic.

From my first steps in Excel to data models, enterprise systems, analytics, and my own automation projects.

2000s
THE BEGINNING

First steps in Excel

My first exposure to spreadsheets, formulas, and structured work with information.

EXCEL
2015
HANDS-ON WORK

Excel becomes a real working tool

I started using Excel much more deeply in real business work. Around the same time, I began gaining hands-on experience with ERP and real business and manufacturing processes.

EXCEL ERP OPS
2016–2017
DATA MODELS

Power Pivot and DAX

In Excel, I started working with Power Pivot, table relationships, and data models. That gave me a working understanding of the fundamentals of DAX.

POWER PIVOT DATA MODEL DAX
2017
ANALYTICS

Moving into Power BI

Once I understood the core logic of DAX, I moved into Power BI and started building models, analytical reports, and visualizations.

DAX POWER BI REPORTING
2018
BUSINESS SYSTEMS

CRM and the bigger picture

I started working hands-on with CRM. That expanded my perspective from manufacturing processes to customer data, activities, and how different parts of the business connect.

CRM DATA PROCESSES
2024
INDEPENDENT PROJECTS

Sebastian Automations

I started developing my own applied projects: automation, data processing, reporting, web tools, and custom business logic.

AUTOMATION APPS SCRIPT WEB
Today
SYSTEMS THINKING

From tools to systems

Today I bring together experience across processes, ERP, MES, CRM, Excel, Power Query, Power BI, testing, data, and automation.

UNDERSTAND SIMPLIFY AUTOMATE
PROCESS DATA SYSTEMS
2000s
TODAY
HAVE A PROCESS THAT SHOULD BE EASIER?

Let's remove the unnecessary complexity.

Show me how the process works today. I'll help identify what can be simplified, automated, or made more reliable.

Let's talk