Automation, Data &
AI Systems Architect
I design systems that reduce operational costs, save time and improve decision-making.
I design systems that reduce operational costs, save time and improve decision-making.
Intelligent systems that grow with your business.
I help companies reduce operational time through automated systems that reduce manual work and improve operational efficiency, designing robust data architectures and strategic AI integration.
I design and implement systems that reduce manual work and improve operational efficiency:
Automate reporting workflows to ensure data accuracy and eliminate manual spreadsheet management.
Clean and structure fragmented data into reliable architectures that serve as a single source of truth.
Connect tools into unified operational systems, breaking silos and ensuring seamless information flow.
Reduce manual workload and operational time, allowing your team to focus on high-value strategic tasks.
Improve visibility for better decision-making through real-time data monitoring and automated insights.
A structured methodology to transform operations into high-performance systems.
I analyze your current processes, tools and data flows to identify gaps and opportunities.
I design a structured solution based on automation, data architecture and tool integrations.
I build and connect the system using the most appropriate tools and advanced technologies.
I refine and improve the system based on performance metrics and real operational usage.
Selected case studies of high-impact automation and data systems architecture that reduce manual work and improve operational efficiency.
Problem: 85% manual reporting time wasted in logistics.
Solution: Automated finance workflows & system overhaul.
Stack: Python / VBA / Data Engineering.
Result: Significant operational time recovery & error reduction.
Problem: 5 disconnected ERP data silos.
Solution: Unified real-time dashboard.
Stack: SQL / Data Integration.
Result: Instant visibility for executive decisions.
Problem: SAP migration data integrity risks.
Solution: Automated cleanup & migration pipeline.
Stack: Python / SQL / SAP B1.
Result: 1M+ records sanitized with zero loss.
Problem: EMEA expansion without growth modeling.
Solution: Data-driven market growth forecasting.
Stack: Python / Data Modeling.
Result: Strategic expansion backed by analytics.
Problem: Inefficient supply chain order flow.
Solution: Process re-architecture & integration.
Stack: Process Engineering / SQL.
Result: 20% faster processing & zero bottlenecks.
The capabilities behind the systems I build.
Designing scalable workflows that eliminate friction and improve visibility.
WorkflowsTurning complex data into clear, decision-ready systems.
AnalyticsBuilding automation systems that reduce manual work and improve operational efficiency, scaling operations.
Core SpecialtyConnecting systems into a single, reliable source of truth.
Data SystemsFrom operations to automation systems design.
Manufacturing Industry
Led global trade operations across multi-team workflows
Built automation systems reducing reporting time by 85%
Designed KPI frameworks enabling real-time decision visibility
Previous Experience
Built operational tracking systems handling 1M+ records
Developed Excel/VBA tools integrated with SAP B1
Transformed reporting into dynamic decision systems
The structured approach behind every project
Understanding the business process and identifying data friction points.
Cleaning, validating and organizing operational datasets.
Building repeatable workflows and reducing manual processing.
Delivering structured datasets, dashboards and documentation.
The core stack I use to build scalable automation, analyze complex enterprise data, and leverage artificial intelligence.
Technical Authority
Proven experience in designing systems that impact the bottom line.
Data structuring, cleaning pipelines, and advanced visualization for informed decision-making.
Autonomous systems that execute repetitive tasks with surgical precision, unlocking your team's potential.
Practical implementation of generative models and intelligent agents to boost operational productivity.
The Decision Driver
Over 15 years leading operations in corporate environments, understanding business pain points before coding.
I automate on your current tools (Excel, Python, APIs) to avoid costly migrations or operational disruptions.
Combining a strategic mindset with applied code to ensure every automation eliminates real bottlenecks.
Expertise
I have 15+ years of experience in operations, logistics and data-driven environments.
I specialize in designing systems that reduce manual work and improve operational efficiency, automating workflows and enhancing decision-making.
The Studio
I run BarViCa Flow, where I design systems that improve operational efficiency and business performance.
I help companies eliminate manual work, structure data, and build automation that actually delivers results.
Or email me directly:
francisco@franciscogomez.devNo commitment. Just a quick conversation to explore your case.