Career Ontology

2026

Work Experience

  • Spearheading AI Strategy and Deployment for BCA Supply Chain Functional Excellence, integrating AI into scalable solutions to free up human capital to make accelerated decisions and actions
  • Developed batch OpenAI API Python script to augment system data, integrating AI into SQL tables for enhanced analysis in Tableau Dashboards
  • Developed proof of concept RAG Chatbot using Flask in Python
  • Supporting Multi-Cloud Hybrid Data Architecture Strategy and Governance team, driving transparent, cost effective and reliable production solutions
  • Led Analytics development supporting BCA Inventory Optimization, using data to navigate dynamic production schedules by balancing Purchase Order Spend with Supplier Stability resulting in $500M+ cost reduction in 2024
  • Developed an R Shiny application to simulate supply, demand, and inventory projections, facilitating strategic rescheduling decisions
  • Mentored team members in leveraging R for web development and data analytics, fostering skill development and knowledge sharing

  • Developed R Shiny application to search and ingest semiconductor component availability and lead time data using multiple distributor APIs
  • Technical Lead for the development of the Enterprise Health & Visibility projects
  • Develop Data Pipeline and Tableau Dashboards for BCA/BGS Inventory Price Differential Project
  • Identify and implement new technologies and tools for team (GitLab, DataIku, RStudio Professional)
  • Supported BCA ESRC Wire Bundle Recovery Project

  • Developed React web applications that enable users to input data into SQL databases used for creating program level KPI dashboards. Created CI/CD pipelines to push apps to Dev, Test and Prod CloudFoundry servers.
  • Developed dashboards that integrate multiple data sources and systems to provide holistic program level performance metrics.

  • Connected disparate databases from multiple organizations to create business intelligence solutions that provide comprehensive value stream visibility for program management.

  • Integrated unstructured data from Excel files with SQL database connections to create an executive summary report that identifies tool readiness risks to production schedule.
  • Worked with Tooling Engineering, Tooling Operations and Tooling Construction to develop and create performance to plan metrics from multiple data sources using basic programing and database queries in Microsoft Excel, Microsoft Access, and Tableau.
  • Iteratively created and updated 777x Tooling Line of Balance dashboard using database queries according to shareholder needs. Identified and shared missing and incongruent information to data owners, and revised models according to shareholder feedback.
  • Created and maintained automated ETAC Line of Balance reports
  • Compiled supporting data to develop estimates and schedules
  • Assembled tooling product data, presentation and support materials for manufacturing, procurement and shop-floor teams
  • Gathered and prepared data for offload tooling business systems
  • Identified, coordinated and processed customer requirements for tooling products and information
  • Assisted in the creation of project schedules and updated project status using Microsoft Project
  • Collaborated in reviewing and creating tooling product documentation and procedures

  • Joined supply chain data with production quality data to identify reoccurring defects that created part shortages and impacted production schedule through drill-down exploration. This data drove multiple projects and workshops to identify root cause and take corrective action. Defects and shortages decreased and process adherence increased.
  • Led 787 cross-functional value stream mapping accelerated improvement workshop based on data analysis to reduce defects and re-ordering of parts. Defects decreased by over 50% in test area.
  • Requirements owner for 787 MMO C&D Zodiac Online Horse Blanket tool. I collected requirements from MMO managers, SCAs, and MPRFs and translated them into logic that was used by IT to develop and deploy the tool. This supplier shortage visibility tool was used in support of a critical supplier recovery effort to ensure coordination in the global supply chain.
  • Teamed with other job roles to help define, build, test and certify the 787 battery solution that directly led to returning the fleet to service. This included tracking and reporting the fabrication and shipping status of the recovery solution parts for planes that were in service or being assembled in the factory.
  • Integrated and analyzed part shortage data using Access, Excel, and Cognos to create reports for manufacturing, procurement and quality teams.
  • Supervised multiple teams as a Temporary Manager and Team Lead.

Education

  • Network and System Administration (October 2022 - December 2022)
  • Certificate in Python Programming (October 2021 - June 2022)
  • Foundations of Statistics (2021)

Information Technology and Administrative Management

Business Administration and Management

  • The Complete 2023 Web Development Bootcamp
  • Data Science A-Z
  • R Programming A-Z
  • R Programming: Advanced Analytics in R for Data Science
  • Tableau 10 A-Z

Skills

Tableau
SQL
RMarkdown / Jupyter Notebook
ETL Pipelines

GitHub / GitLab
RShiny
Python
API Integration
Web Development
Linux
Cloud Services

Team Leadership
AI Strategy and Deployment
Cross Functional Project Implementations

Portfolio

Rick Steve's YouTube Channel Chat

A Python Retrieval Augmented Generation (RAG) application deployed on Heroku that uses PostgreSQL as the vector store and the OpenAI API for the GenAI model. I vectorized YouTube channel transcripts so users can ask questions about the channel, discover relevant videos, and get referenced links in the responses.

Try the app

Connect

Interested in AI, Analytics, or Digital Transformation?
Let's connect.

LinkedIn Email