Hi, my name is Geraldo. I am a tenacious, energetic, and game-changing Supply Chain Data Analyst with 15+ years of experience in business management and development, with proven track record delivering consistent, profitable growth in revenues through strategic planning, direction, execution and leadership. I have a strong background providing support and guiding implementation of business information systems across multiple industries.
Being a revenue-focused executive, I utilize data and analysis to leverage insights and trends and identify key issues and opportunities for growth. As a problem-solver, I always strive to deliver quality products that streamline business operations and optimize processes. I am recognized for being a forward-thinking, dynamic individual, with an extraordinary talent to upgrade efficiency levels and monitoring metrics to satisfy reporting needs.
My academic background includes an MBA in Data Science and a Bachelor’s Degree in Mathematics and Certificate in Software Development. I am fluent in English and Portuguese.
15+ years of experience in data analytics applied to supply chain, demand planning, and risk mitigation.
Developer of the ProComp Risk Model (Python), used to forecast revenue risk from component shortages across hundreds of end-products.
Creator of the CPB Model (Cross-Plant Build), combining Google Data Studio and Python to optimize production feasibility across global sites.
Built the RunOutDate (ROD) Engine to anticipate component depletion and guide transition decisions.
Delivered over 2 million dollars in cost avoidance through product realignment strategies and surplus identification.
Expert in AWS, Tableau, SAP, and statistical modeling to automate reporting and enable proactive planning decisions.
Technical Tools
Python, SQL, Pandas, NumPy, Tableau, Power BI, Google Data Studio, Excel VBA
Cloud & Data Infrastructure
AWS (EC2, S3, Lambda), Google Cloud Platform, SQL, SAP ERP (MM, PP, SD modules)
Data Engineering & Automation
ETL Pipelines, Dashboard Automation, BOM Correlation, EDI Testing, Script-based Reporting
Supply Chain & Analytics
Demand Forecasting, Inventory Optimization, Revenue Risk Analysis, Component Shortage Mitigation, Multi-Plant Build Strategy
Project & Collaboration Tools
Jira, Confluence, Agile Workflows, Cross-functional Communication
Senior Data Analyst – Demand & Supply
Motorola Solutions | Remote, Canada
Sep 2021 – Present
Motorola Solutions is a global leader in mission-critical communications and enterprise security technologies, serving governments and businesses in over 100 countries.
Developed the ProComp Risk Model in Python (internal tool: VSC Web In-Use) to quantify revenue exposure caused by component shortages, supporting proactive procurement actions and executive prioritization.
Created the Cross-Plant Build Model (CPB Model) using Google Data Studio and Python to evaluate build readiness across sites, integrating inventory, supply schedules, and demand distribution.
Built the RunOutDate (ROD) Engine to forecast material depletion dates and support product transition mitigation strategies, reducing obsolescence and supply disruptions.
Developed the Where-Used Proportionality Dashboard using AWS, SQLite, and Tableau, improving component impact visibility and reducing response time during shortage events.
Delivered a product transition analysis that avoided 2 million dollars in excess inventory by identifying surplus early and recommending adjusted forecast timing.
Created the Bill of Materials Correlation Engine to surface interdependencies and improve sourcing and capacity planning decisions.
Led onboarding and internal training for new analysts, promoting consistent analytical standards and productivity ramp-up.
Demand Planner
Motorola Solutions | Richmond, BC
Apr 2021 – Sep 2021
Developed material availability and procurement processes to support timely execution across planning cycles.
Collaborated with Product Management, Operations, and Development teams to forecast demand for new product introductions and align transition planning.
Analyzed and validated historical and forward-looking demand data to improve forecast accuracy and decision-making.
Flagged risks related to material availability, supply constraints, and production capacity to relevant stakeholders.
Enabled visibility for executive decisions through custom reporting and data validation tools.
Business Analyst – Supply Chain
Motorola Solutions | Richmond, BC
Oct 2018 – Apr 2021
Designed and implemented Power BI dashboards to provide supply chain and operations insights to executive leadership.
Maintained Revenue Impact and Risk Assessment reports to support decision-making at the VP level.
Automated planning workflows using VBA and SAP data integration, increasing planning department efficiency.
Participated in SAP ERP migration by validating data and building EDI test cases to support system readiness.
Identified opportunities to reduce shipping costs and improve fulfillment capacity, resulting in 15 percent logistics savings.
Conducted cross-departmental process evaluations and presented optimization recommendations to stakeholders.
Supported compliance with European environmental standards through reporting automation.
Facilitated onboarding and tool adoption across planning, logistics, procurement, and engineering teams.
Cycle Counter
Motorola Solutions | Richmond, BC
Nov 2017 – Oct 2018
Performed daily inventory counts and reconciliations in a high-volume manufacturing environment. Worked closely with planning and logistics teams to identify discrepancies, implement corrections, and support accurate material availability.
Conducted physical inventory audits and SAP updates for over 10,000 SKUs.
Identified and resolved recurring variances, contributing to improved cycle count accuracy and audit readiness.
Supported warehouse layout changes to optimize material flow and tracking.
Business Manager (Owner)
Império Som e Geradores LTDA | Brasília, Brazil
2005 – 2017
Owned and operated a mid-sized business specializing in audio systems and power generators for corporate and event clients.
Managed all aspects of operations, from finance and inventory to customer relationships and vendor negotiations.
Developed custom technical solutions for live events and off-grid installations.
Built a customer base of over 500 recurring clients through service quality and technical reliability.
Led a small team and implemented internal controls to reduce loss and improve service delivery.
Education & Certifications
AWS Certified Cloud Practitioner
Amazon Web Services – Issued Sep 2022
MBA in Artificial Intelligence, Data Science and Big Data
Pontifical Catholic University of Rio Grande do Sul (PUC-RS), 2021
Certificate in Software Development
British Columbia Institute of Technology (BCIT), 2020
Bachelor’s Degree in Mathematics
Catholic University of Brasília, 2013