production systems built in enterprise environments. code is private; concepts are public.
Automated Audit Trail Reporting
AbbVie NCMEnd-to-end compliance reporting tool replacing a fully manual monthly process at a pharma manufacturing site.
- •Queries production Oracle 19c database across 18 distinct audit dimensions
- •Detects anomalous entries and flags data findings automatically
- •Generates formatted Word report with pre-drafted SME email
- •Streamlit interface requiring zero SQL knowledge from end users
- •Navigated parallel enterprise deployment: compliance registration, ComplianceWire training, 5 concurrent IT tickets
- Python
- Streamlit
- Oracle 19c
- oracledb
- python-docx
- AWS
Controlled Document Workflow Agent
AbbVie NCMLLM-powered document editing agent for a regulated manufacturing environment.
- •Accepts natural language comments against controlled Word documents
- •Generates structured edits with version history and change previews
- •Performs gap analysis against global reference standards
- •Replaces slow email-based review cycle with one-button workflow
- •Built under enterprise API proxy constraints in GxP-adjacent compliance environment
- Python
- Claude API
- python-docx
- LangGraph
- Enterprise API
Predictive Maintenance Intelligence
AbbVie NCMscopedScoping a predictive maintenance system for manufacturing equipment using time-series sensor data.
- •Anomaly detection on live OSI PI process tags
- •Failure prediction from historical sensor patterns
- •Maintenance window optimization to reduce unplanned downtime
- •Internal dashboard for operations and engineering teams
- •Designed to integrate directly with existing PI infrastructure
- Python
- OSI PI
- LangGraph
- RAG
- Docker
- AWS EC2
Single Cell Robotic Extraction System
UIUCcompletedSweedler Lab ↗Undergraduate research extending a Python-based robotic automation platform for single-cell metabolomics.
- •Extended microMS Python platform for cell coordinate registration and automated probe movement
- •Optimized capillary geometry, extraction parameters, and solution preparation methods
- •Validated dye standards achieving R²=0.9953 vs R²=0.9441 for BSA standards
- •Developed full operational manual including step-by-step probe assembly flowchart
- •Presented at 3 UIUC conferences and 1 national conference
- Python
- Robotics
- Lab Automation
- Statistical Analysis