- SUMMARY : Full Stack Database Inventory System.
- Created relational database for inventory mgmt w/ one-page UI web interface, one click data reporting & upload. (To See UI feature screenshots & detailed summary CLICK upper right Link )
- Wrote versatile Python ETL script to ingest and transform online XML or local CSV data, with DB upload & error log reporting.
- Automated ETL - with duplicate filtering, data formatting, writing to offline logs, and bulk data uploads
- JavaScript implemented to listen, and process user HTML query requests to and from REST API.
- DB results dynamically output to formatted HTML tables, with CSV & PDF download options.
- Database (SQLITE3) - w/ automated triggers (conditional / procedural) saved views/queries for client ease
- Tech Stack: Python, SQL, SQLite3, SQLAlchemy, Flask, JavaScript, D3, HTML, CSS, REST API
- To See UI feature screenshots CLICK upper right Link
|