Lucas Formagio

About

I am a Business Intelligence and Data Analyst focused on Sales Operations Analytics, process automation, and agile project management. I design end-to-end BI solutions to turn data into commercial and operational decisions, integrating sources such as SAP BW/SD, Protheus, SQL, and Databricks into executive and operational dashboards, KPIs, strategic reports, and automated workflows using Power BI datasets and Power Automate. I built and evolved a data ecosystem focused on efficiency, standardization, and analytical scalability. Among the main results, I highlight: - Automation of 13+ recurring workflows; - Enablement of 80+ reports per month; - Reduction of 100+ hours of manual work per month; - 50% reduction in the processing time of 45k+ quote lines per month; - Reduction of budget and profitability analyses from 2 weeks to just a few minutes. In parallel, I led initiatives such as Workflow Automation Engine, Customer Financial Overview Suite, Quote Flow Tracker, MRP Demand Monitor, and Sample Investment ROI Tracker, strengthening visibility into backlog, forecast, demand, ROI, and financial performance. ✧ I combine an Industrial Engineering background, business and analytical acumen, and agile execution to generate tangible gains, sustainable growth, innovation, and competitive advantage through data, automation, continuous improvement, and stakeholder alignment. ⧉ I am open to connections and opportunities in Business Intelligence, Data Analytics, Sales Operations, and DataOps, with a focus on generating strategic value and scalable solutions. Business Intelligence | Data Analytics | Sales Operations Analytics | Automation and Operational Efficiency | Agile Project Management | Continuous Improvement

What I'm looking for

I’m looking for remote or hybrid roles in Business Intelligence, Data Analytics, Sales Operations Analytics, or Process Automation. I want to apply Power BI, SQL, SAP BW/SD, Databricks, ETL, and Power Automate to build dashboards, automate workflows, integrate data, and support strategic business decisions in an international, data-driven company.

Experience

Sales Intern

Avnet

Nov 2020 – Present

▪ Lead the development and implementation of BI solutions for commercial and engineering teams, integrating data from SAP BW, Protheus, Databricks and SQL into executive dashboards, KPIs, and operational analyses. ▪ Automated 13+ workflows in Power Automate, generating 80+ monthly reports and eliminating 100+ hours of manual work. ▪ Modeled and structured budget, profitability and market potential metrics, reducing consolidation time from 2 weeks to just minutes. ▪ Optimized and managed 45k+ lines of monthly quotations, reducing processing time by 50%. ▪ Created centralized multi-source analyses to track backlog, forecasts, ship debits and ROI on sample investments. ▪ Set up monitoring demand fluctuations for strategic customers, aligning forecasts with billing cycles. ▪ Delivered BI training, reducing manual dependency and enabling independent, data-driven insight generation. Highlighted projects: Workflow Automation Engine, Customer Financial Overview Suite, Quote Flow Tracker, MRP Demand Monitor, and Sample Investment ROI Tracker, AI Agent Development.

Sales SupportProcess ImprovementAdvanced ExcelCRM SupportOperational EfficiencySAP SDSales OperationsCustomer Relationship ManOpportunity ManagementData-Driven Decision MakiBusiness IntelligencePower BIProcess AutomationData IntegrationSQL

Education

Certifications

Skills

Languages