Don't be afraid to give up the good to go for the great." - John D. Rockefeller
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.
Education
AWS Certified Cloud Practitioner, 09/2022.
MBA in AI, Data Science, and Big Data, PUC of Rio Grande do Sul, 06/2021.
Certificate in Software Development, British Columbia Institute of Technology, 12/2020.
Bachelor’s Degree in Mathematics, Catholic University of Brasilia, 06/2013.
Technical Skills
Proficient in Python: Strong command over Python programming language, including expertise in libraries such as NumPy, Pandas, and Seaborn. Experience in integrating Python with SAP systems for streamlined data analysis.
Relational Databases and Cloud Querying: Proficient in SQL and adept at querying and managing relational databases. Familiarity with cloud databases, particularly AWS and GCP Power Query, for efficient data extraction and manipulation.
Advanced Microsoft Suite: Expertise in Microsoft tools, including Power BI with a strong understanding of the DAX language, Access for database management, Visio for visual representation, and proficiency in Word and PowerPoint for effective documentation and presentation.
Microsoft Excel Proficiency: Extensive knowledge of Microsoft Excel, including advanced features such as Macros in VBA, Power Query for data extraction and transformation, Pivot Tables for data analysis, and Lookups for data retrieval.
Full-stack Web Development: Experience in web development using frameworks like Django, along with programming languages like C#, Java, C++, HTML, and CSS. Proficient in utilizing project management tools like Jira and Trello.
Advanced Google Sheets: Mastery of Google Sheets, including advanced functionalities such as pivot tables, complex formulas, data queries, and macros using JavaScript for automation.
Advanced SAP ERP System: In-depth understanding of various modules in the SAP ERP system, including material master, production planning, and sales distribution. Proficient in leveraging SAP data for comprehensive analysis and decision-making.
Work experience
Sr DATA ANALYST (Demand & Supply Planning), Motorola Solutions, Remote, Canada
09/2021 – Present
Focused on mitigating risk revenue, ensuring material availability, and driving process improvement initiatives by developing, implementing, and automating secure reporting mechanisms for consistent and accurate insights.
Motorola Solutions is a global leader in mission-critical communications and analytics. Its technology platforms in mission-critical communications, command center software and video security & analytics, bolstered by managed & support services, make cities safer and help communities and businesses thrive. As a Canadian subsidiary of Motorola Solutions, Richmond branch is specializing in the design, development and manufacture of advanced AI, video analytics, network video management software and hardware, surveillance cameras, and access control products.
Spearheaded the end-to-end design, development, and execution of a sophisticated risk revenue component-based report utilizing Python scripts. This report effectively identified shortages, providing critical insights to expedite data-driven business decisions and mitigate risks promptly.
Developed a comprehensive, end-to-end "clear-to-build" report using Python, incorporating components proportion and statistical analysis. This report streamlined the construction process by providing clear and actionable insights, including detailed component proportions and statistical metrics, empowering informed decision-making and optimizing project outcomes.
Successfully developed and implemented a comprehensive data visualization dashboard using Google Data Studio, enabling proactive identification of future risk revenue and empowering strategic decision-making.
Created a Bill of Materials (BOM) correlation report, leveraging data analysis techniques and tools to identify and analyze correlations between different components within the BOM. This report facilitated better understanding of dependencies and relationships, enabling more accurate planning, cost estimation, and improved supply chain management.
Created an efficient where-used components report by integrating SAP, SQLite, and Excel through Python scripts, streamlining the identification of component dependencies and enhancing data analysis capabilities.
Conducted extensive investigation and troubleshooting of ERP component consumption discrepancies, employing analytical methodologies and problem-solving techniques to identify root causes, implement corrective actions, and ensure accurate consumption data for improved operational efficiency.
Successfully delivered in-depth technical training sessions to a new team members, equipping them with the necessary knowledge and skills to excel in their project, fostering a smooth transition and ensuring high productivity from the start.
DEMAND PLANNER, Motorola Solutions, Remote, BC
04/2021 – 09/2021
As a dedicated demand planner, focused on optimizing material availability, driving process improvement, enabled timely insights for effective decision-making and enhanced operational efficiency.
Established a streamlined process to drive the procurement and management of materials and associated components, ensuring efficient supply chain operations and timely availability of resources for project execution.
Gather, analyze and validate data that will be used in preparing forecasts.
Work with Product Managers, Product Development and Operations to forecast demand for new products; and successfully transition them to Production.
Evaluate sales opportunities against forecasted demand and highlight any potential risks including material availability and production capacity.
Work with various business groups to understand their demand planning processes.
Measure and report data quality on forecast accuracy.
SCM BUSINESS ANALYST, Motorola Solutions, Richmond, BC
04/2020 – 04/2021
Jr. SCM BUSINESS ANALYST
10/2018 – 04/2020
Focused on driving operational and process improvement efforts through developing, implementing, and supporting business processes and enabling them in the SAP system while collaborating with key business stakeholders across all business units regularly.
Develop and implement data visualization reports in Microsoft Power BI, providing insights to senior level directors.
Create and maintain Risk Assessment and Revenue Impact reports to the Company’s VP.
Facilitate equipment and instrumentation processes related to product manufacturing by providing process analysis, design, development, and implementation.
Train the three key Stakeholders and two employees to use the Microsoft Power BI through leveraging extensive experience and knowledge of this business analytics service.
Maximize the efficiency of the Planning Department by leveraging VBA Scripts and creating appropriate tools, analyzing business information systems, developing and upgrading processes, and optimizing projects.
Identify business development possibilities and provide recommendations for business processes modifications and optimizations through conducting a detailed evaluation of current business processes while utilizing established methodology.
Responsible for data validation in the SCM SAP ERP system migration.
Perform in implementing a new EDI interface creating unit test cases.
Achieve all deadlines in a consistently transforming environment through independently planning, prioritizing, and coordinating complex and concurrent activities.
Ensure compliance with the new European environment rules by creating proper forms and reports.
Enable shipping capacity increase by 10% through gathering business requirements, interviewing subject-matter experts and presenting analysis results to the Logistics, Global Planning, Production Planning, Procurement, Shipping, IT, Engineering, and Customer Order Management Departments.
Provide savings of 15% in shipping rates and identify opportunities for shipping capacity increase through assessing the shipping method from diverse fulfillment plans.
Increase productivity of the 20-employee department by 20% through developing requirements for the implementation of a specific tool.
CYCLE COUNTER (Inventory Management), Motorola Solutions, Richmond, BC
08/2017 – 10/2018
Concentrated on ensuring overall inventory accuracy through conducting daily cycle counts, identifying and analyzing inventory discrepancy, and investigating consumption in a work order within the SAP system, while collaborating with the Inventory Specialist, Receiving, Shipping, and Production Departments.
Resolved and rectified inventory discrepancies, thereby eliminating future shortages through analyzing and investigating the root cause analysis.
Ensured efficient inventory control and maintained accurate inventory balance through applying material data adjustments, corrections, and updates on the SAP and Excel.
Created and maintained inventory, accuracy, and cycle count reports for the management, as well as compared them with the SAP ERP data by leveraging Microsoft Excel Power Query “DEX”.
Eliminated waste and unnecessary excess through conducting research of the material variances discrepancies and implementing adequate adjustments.
Supported the ‘Annual Physical Inventory’ project, enabling project completion in a timely and efficient manner by supervising and training the Audit team of 16 Counters.
Avoided inventory aging through implementing efficient inventory solutions regarding confidential information.
BUSINESS MANAGER (Owner), Imperio Som e Geradores LTDA, Brasília, Brazil
12/2005 – 02/2017
Oriented on supporting the company’s business needs, goals, and objectives through developing strategic plans, analyzing market trends and customer needs. Developed, established and maintained business architecture and maintained detailed documentation requirements and technical information.
Orchestrated 10 full-time employees and 12 part-time employees, including Financial Assistant, Administrative Assistant, Audio Technician, Video Technician, Light Technician, Electrician, Driver, and Assembler.
Managed supply chain budget and budget for the employee wages, prepared monthly financial statements and conducted account analysis.
Delivered business growth of 10% through study and material acquisition.
Streamlined and standardized workflows through implementing new technology solutions, creating training material, and delivering training to the employees.
Grew customer base by 15% and achieved different market share through conducting the risk assessment and performing cost and benefit analysis for future rentals and new equipment acquisitions.
Increased company assets from 80 minimum wages to 420 minimum wages, full-time employees from 2 to 10, as well as annual events from 50 to 380 by leading business operations efficiently.