Romer Alexander Bracho
Senior Business Analyst
Seasoned Supply Chain professional with 5 years of experience in Business Analytics and Operations Management. With a Supply Chain and Data Analytics background, along with P&L management experience, I provide a unique approach to problem-solving. Whether it is meeting revenue targets, managing supply constraints, or developing new systems and processes I have a well-rounded skillset ideal for facing complex operational dilemmas.
Experience
Austin, TX
Senior Business Analyst
Jan 2021 - Present
Reporting to the VP and GM of Embedded Solutions, I manage revenue attainment for the Embedded business unit. Coordinating with sales, marketing, procurement, and supply chain, I provide supply allocations to customers, calculate raw material requirements, and report on any inventory gaps towards meeting our quarterly targets.
- Embedded Solutions’ two-time Award of Excellence recipient for delivering outstanding quarterly results, facilitating 80% YoY growth through aggressive design-win strategy and revenue optimization.
- Integrated sales, product management, finance, operations and engineering inputs to balance product roadmap implementation, product lifecycle management, along with gross margin and revenue attainment.
- Developed 12 executive-level dashboards, using Power BI, summarizing quarterly revenue projections by geography, customer account, business segment and SKU.
- Presented to executive-level management on weekly revenue attainment progress, changes in customer demand forecast, product development progress, and raw material funding requirements.
- Eliminated 600+ man-hours per year by merging 8 data sources using SQL Server and Power Query to automate data analysis for 450+ SKUs relating to demand, supply, and revenue
- Example Dashboards (also available here):
Supply Chain Analyst I / Supply Chain Analyst II
Jul 2017 - Dec 2018 / Jan 2018 - Dec 2020
As the leading technical expert of a 10-person team, I served as the Excel, reporting and process improvement guru for the Supply Demand Planning division.
- Directed a four-person team on best practices for tactical order management deliverables, enabling 97% On Time Delivery.
- Implemented 6 executive-level Power BI dashboards highlighting remaining quarterly shipments by product line, business unit, and workweek to highlight any risk to revenue based on shipping capacity.
- Obtained a Lean Six Sigma Greenbelt by completing an 8-month long project utilizing DMAIC methodologies to enable a 30% improvement in supply forecast accuracy for Ryzen CPUs.
- Built a process document repository of 50+ Visio documents, reducing onboarding time from weeks to days.
- Standardized excel macros and SQL queries to automate business analysis, saving 300+ man-hours per year.
Intern
May 2014 - Aug 2014
Assigned to providing a shop floor process improvement for a warehouse transition project, I presented to the
manufacturing director a shop floor redesign proposal.
- Collaborated with shop floor teams to conduct time studies for each of the 5 main manufacturing processes
- Created process flow diagrams to demonstrate non-value-added processes leading to several wasted man-hours per day.
- Proposed implementing a straight-line flow of raw material layout in a new warehouse location, which resulted in a 20% improvement in order cycle time.
Education
Georgia Institute of Technology (Remote), College of Engineering
Master of Science - MS, Data Analytics
Jan 2021 - May 2025 (est.)
Texas A&M University at College Station, Mays School of Business
Bachelor of Business Administration - BBA, Supply Chain Management
Aug 2013 - May 2017
Certifications
Advanced Micro Devices, Lean Six Sigma Academy
Lean Six Sigma Greenbelt
Jan 2018 - Aug 2018
The University of Texas at Austin, McCombs School of Business
Data Analysis & Visualization Professional Certification
Jan 2019 - Jun 2019
Tools
- Excel (Expert)
- Visio (Expert)
- SQL Server (Expert)
- Power BI (Expert)
- SAP ERP (Advanced)
- VS Code (Advanced)
- Github (Advanced)
- Sharepoint (Advanced)
Languages
- T-SQL (Expert)
- VBA (Expert)
- Python (Advanced)
- HTML (Advanced)
- CSS (Advanced)
- Javascript (Advanced)
- Git (Advanced)
- Spanish (Intermediate)
- Mandarin (Intermediate)
Core Competencies
- Revenue Forecasting
- P&L Management
- Operations Management
- Continuous Improvement
- Business Intelligence
- Project Management
- New Product Introductions
- Lifecycle Management
- DevOps
- ETL
- Version Control
- DMAIC
Interests
