Skip to content
View stephanyalves-eng's full-sized avatar
🎯
Building sourcing tools.
🎯
Building sourcing tools.

Block or report stephanyalves-eng

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
stephanyalves-eng/README.md

Stephany Alves · Industrial engineering, procurement, operations and data · Complexity, made clear. · SIGNAL & STRUCTURE

Procurement × Engineering × Data · Signal → Structure → Decision → Impact · Evidence-based sourcing decisions

Procurement & Supply Chain · Industrial Engineer · Data and AI for sourcing decisions

LinkedIn Medium Peerlist DEV Community Kaggle Hugging Face Tableau Public Belo Horizonte, Brazil Follow on GitHub Profile views

I work where procurement, engineering and data meet: structuring complex supplier information
so that sourcing decisions can be made on evidence, and their impact can be measured.

Industrial engineer with about four years in aerospace procurement and supplier management.
I build portfolio projects that turn real sourcing problems into working tools, using synthetic data only.

🏭 200+

suppliers managed in aerospace
direct materials

💰 Six-figure (USD)

savings on strategic items,
validated by Finance

⚡ 97%

less effort in supplier due diligence
renewals, through a Kaizen

01 · 🌱 Right now

  • 🔭 Building: AeroQuote Compass and a should-cost model for wire harnesses and connectors
  • 📚 Learning: SQL, Python, Tableau and Databricks, through the portfolio projects below
  • 💬 Ask me about: should-cost, strategic sourcing, procurement, supplier quality, maintenance engineering, vendor management and procurement analytics
  • 🤝 Open to: Senior Procurement Analyst · Procurement Analyst · Strategic Sourcing Analyst · Supplier Quality Engineer · Data Analyst
  • 📍 Availability: Belo Horizonte, Brazil (UTC−3) · remote, hybrid or on-site · available immediately · 📅 Book a 30-min call
  • 🗣️ Languages: Brazilian Portuguese (native) · English (fluent) · Spanish (fluent)
  • ⚡ Fun fact: I can't look at a cable anymore without estimating its should-cost, copper price included.
  • 📖 Outside work: reading

02 · 🧾 Featured project: Vendor Spend & Renewal Cockpit Live

Renewal Cockpit Overview: clicking Cloud switches every KPI to that category

Budget and contract-renewal cockpit for the indirect-procurement team of a fictional fintech (BRL 18.5M third-party spend).
It answers the three questions a procurement lead gets every month: will we land the year on budget,
which contracts need a decision before they auto-renew, and where can we cut or consolidate spend.

+5.5% over budget

and it is volume, not price: cloud usage grows 3.5%/month against 2% planned

BRL 1.04M / year

from acting on 15 contracts that renew within 120 days, more than the whole overrun

2 urgent decisions

decision deadlines in December; both contracts auto-renew if nobody acts
Budget vs. actual: setting Category to Cloud updates the KPIs and the budget-to-landing waterfall Renewals: opening Dealstream shows the decision deadline and the rule behind the recommendation
Budget vs. actual
budget to landing, split into price, volume and unbudgeted spend
Renewals
decision deadline, recommendation and the rule behind it
▶ AI contract intake an AI step extracts five renewal terms from a contract PDF, each checked field by field against the contract on file
Contract intake: AI-extracted contract terms checked field by field against the contract on file

Synthetic spend and contracts → Python: forecast, variance split, renewal rules (tested) → Supabase views (row level security) → Web app + weekly alert e-mail

Stack: Python pandas pytest SQL Supabase TypeScript React TanStack Start Recharts Lovable

Live app Data and logic repository Web app repository

03 · 🚀 Featured project: AeroQuote Compass Live

AeroQuote Compass: from 20 supplier quotations to a checked and released purchase order. AI extraction with buyer validation, annual landed cost and explained recommendation, PO Check, revision control and audit trail.

Aerospace procurement workspace that takes supplier quotations from RFQ to a released purchase order.
AI extracts quotes into a fixed schema, the buyer confirms every critical field, and deterministic code computes
annual landed cost, eligibility and an explained recommendation. The PO is then checked against the approved decision,
revision-gated and released, with an exportable audit trail (PDF, Excel, CSV).

RFQ → AI extraction → Buyer validation → Landed cost & eligibility → Explained recommendation → PO Check → Release

Stack: TypeScript React 19 TanStack Start Tailwind CSS Supabase Vitest Playwright Lovable

▶ Watch it work 20 quotations from buyer validation to an explained recommendation (19 s)
AeroQuote Compass demo: 20 synthetic supplier quotations validated by the buyer and compared until the explained supplier recommendation

Live app Code

04 · 🧭 Selected work

Project What it shows Stack Status
Procurement market briefs Six one-page decision briefs for procurement (aerospace supply market, Brazil EV supply chain, procurement performance, supplier quality, Six Sigma and non-conformance), rebuilt every month from Comex Stat, BLS PPI and BCB PTAX data, in English and Portuguese, by a GitHub Actions workflow. Python pandas Matplotlib Playwright GitHub Actions Live
Repo · Editions
Procurement analytics with SQL and Python Spend concentration (Pareto, HHI), seller dispatch SLA and a weighted supplier scorecard on 99k public Olist orders. 17.7% of sellers hold 80% of spend; measuring at delivery hides 78.8% of late dispatches; a 633-seller scorecard narrows action to 60 priority sellers. SQL DuckDB Python pandas Plotly pytest Complete
Repo · Summary (PDF) · Kaggle
Brazilian mining performance and market concentration SQL-first analysis of ANM open data (2010–2025, 2.43M CFEM royalty rows): price vs volume, commodity and state mix, and HHI concentration. Iron ore's share fell from 75.8% to 56.7%, VALE pays 70.6% of iron ore royalties, and a duplicate export in the Feb 2024 file would overstate 2024 growth (12.8% instead of 8.4%). 117 tests. SQL DuckDB Python pytest Tableau Complete
Repo · Dashboard
Brazilian oil and gas production analytics Python pipeline on ANP monthly production (1997–2026): growth regimes, regional concentration, stability and gas use. 97.6% of oil is offshore, more than half of the gas is now reinjected (54.4% in 2025) and flaring fell from 17.9% to 2.8%. 90 tests. Python pandas NumPy Matplotlib pytest Tableau Complete
Repo · Dashboard
Supplier performance dashboard in Tableau Supplier scorecards and delivery risk, built for decision meetings. Tableau In progress
Wire harness and connector should-cost Bottom-up should-cost and category strategy for wire harnesses and connectors, calibrated on Comex Stat import prices, with a copper price-adjustment clause backtested for both buyer and supplier. Python Comex Stat Should-cost In progress
Repo
Field failure intelligence and crimping SPC Links field failure modes from NHTSA and FAA data to crimp height control, with SPC charts, Cpk, Gage R&R, an 8D on a real recall and an AIAG-VDA PFMEA. Python SPC PFMEA 8D In progress
Repo
Assembly line simulation for rate ramp-up Discrete-event simulation of a subassembly line moving from 42 to 47 aircraft per month, comparing line improvements by cost per additional unit. Python Discrete-event simulation In progress
Repo
Mine-to-port planning and fleet reliability Linear programming model of a mine, rail and port network that maximizes margin within iron grade limits, uses shadow prices to rank bottlenecks and adds Weibull-based fleet availability. Python Linear programming Weibull In progress
Repo

Latest edition of the market briefs
Rebuilt automatically on the 16th of every month. These previews update by themselves.

Aerospace Supply Market Brief, latest edition Monthly Procurement Performance Report, latest edition Monthly Supplier Quality Report, latest edition

05 · ✍️ Latest writing

More on Medium and DEV.

06 · ⚙️ How I work

Signal → Structure → Decision → Impact

Every project starts from a business question, organizes the data that answers it, shows the decision it supports and states what changed. AI handles the repetitive work; calculations stay deterministic and every recommendation shows its reasoning.

principles.md: 1. AI extracts. Code calculates. You decide. 2. Calculations stay deterministic. 3. Every recommendation shows its reasoning. 4. Synthetic or public data only.

07 · 🎯 Capabilities

Area What I do
Strategic sourcing RFQs, should-cost, adding qualified sources to single-source parts, negotiation backed by evidence, supplier due diligence
Supplier quality Supplier qualification, PPAP, 8D, SPC and Cpk, PFMEA
Procurement analytics Spend, savings, on-time delivery and supplier scorecards in Power BI, SQL and Python
Continuous improvement Lean, Kaizen, A3, Ishikawa, 5 Whys

08 · 🧰 Toolkit

Procurement

SAP MM SAP QM SAP Ariba Supplier qualification Lextegrity

Data

Power BI Power Query Advanced Excel SQL Python Tableau Databricks Git GitHub

SQL, Python, Tableau and Databricks: building portfolio projects now.

Product and AI

Lovable Claude Claude Code Prompt design ChatGPT Codex Copilot Gemini Gemini Notebook Google AI Studio Figma Notion Jira

Process

Lean Kaizen and A3 Ishikawa 5 Whys

📊 GitHub stats and activity (click to expand)
GitHub stats Most used languages across public repositories

Commit streak

⚡ Recent activity

  1. 🔨 brazil-resources-intelligence: Tableau dashboards: cards and charts follow every click · Nov 21, 2026
  2. 🔨 renewal-cockpit: Replace README screenshots with GIFs of the app in use · Nov 21, 2026
  3. 🔨 vendor-renewal-cockpit: Replace README screenshots with GIFs of the app in use · Nov 21, 2026
  4. 🔨 procurement-market-briefs: Restyle the one-page briefs in Stephany Alves Design System 2.0 · Nov 19, 2026
  5. 🔨 procurement-analytics-olist: Link the published Kaggle notebook · Nov 16, 2026

09 · 🎓 Background

  • Procurement analyst in aerospace direct materials (propulsion and avionics) until 2026, managing 200+ suppliers.
  • Six-figure (USD) savings on strategic items without purchase history, validated by Finance, partly by adding new sources to single-source parts.
  • Led a Kaizen that removed 97% of the effort in low-risk supplier due diligence renewals.
  • B.Sc. in Industrial Engineering and B.B.A. (UFVJM) · Postgraduate degree in Aeronautical Maintenance Engineering (PUC Minas) · Brazilian Portuguese (native), English and Spanish (fluent).

10 · 📬 Contact

Belo Horizonte, Brazil · LinkedIn · Himalayas · Medium · Peerlist · DEV · Kaggle · Hugging Face · Tableau Public

Book a 30-min call on Google Meet

All public projects use synthetic or public data. No confidential company information.


"One machine can do the work of fifty ordinary men. No machine can do the work of one extraordinary man."
— Elbert Hubbard

Pinned Loading

  1. aeroquote-compass aeroquote-compass Public

    Aerospace procurement workspace from RFQ to released PO: AI quote extraction with buyer validation, annual landed cost, eligibility and explained supplier recommendation, PO Check with tolerances, …

    TypeScript 1

  2. procurement-market-briefs procurement-market-briefs Public

    Monthly one-page procurement decision briefs from public data, in English and Portuguese.

    Python

  3. vendor-renewal-cockpit vendor-renewal-cockpit Public

    Budget vs. actual, forecast, variance analysis and contract-renewal recommendations for a fictional fintech's indirect procurement. Synthetic data.

    Python

  4. renewal-cockpit renewal-cockpit Public

    Web front end of the Vendor Spend & Renewal Cockpit: budget vs. actual, renewal decisions and savings for a fictional fintech. Synthetic data.

    TypeScript

  5. brazil-resources-intelligence brazil-resources-intelligence Public

    SQL (DuckDB) and Python analytics on Brazilian mining (ANM) and oil & gas (ANP) open data, with tested pipelines and Tableau Public dashboards.

    Python

  6. procurement-analytics-olist procurement-analytics-olist Public

    Procurement analytics on the public Olist dataset: spend concentration (Pareto, HHI), seller dispatch SLA and a weighted supplier scorecard. SQL (DuckDB) + Python.

    Jupyter Notebook