RUSHI DOSHI

Core Features Authentication & User Management 8-Step Lifecycle Workflow Data Handling & Storage Logic Automated Email System Offline Packaging & Deployment Tech Stack Outcome

Engineered a robust, fully offline PLM (Part Lifecycle Management) system for managing mechanical part workflows using JPC (Job Process Card) numbers. Designed with Flask and Excel-backed storage, the system streamlines part tracking, inspection, documentation, and submission — all accessible through a browser-based interface on a local intranet.

• Landing page with role-based redirection.
• Login system with session handling for admin and user roles.
• User registration auto-generates usernames from email prefixes.
• Role-specific field access and visibility at each step.
• Excel-Based Storage:
  Structured across multiple sheets (Sheet1, Sheet2, etc.) per stage.
  JPC number is the primary key for tracking updates.
  Only writes to Excel if data has changed, avoiding redundant writes.
• Form Persistence:
  Supports partial saves (drafts) and resume-from-where-left logic.
  All user-entered data is persisted across sessions.
  Both admin and user views load prefilled data for edit or review.
• File Handling:
  All file uploads (images, PDFs) saved under static// folders.
  File paths stored in Excel as file:/// URLs for direct browser access.
  Preview and " View File" buttons dynamically rendered if file exists.
• Controlled Finalization:
  Upon Step 8 submission, the row for that JPC is marked as locked.
  Earlier steps become read-only for both roles (no further updates allowed).
• Integrated SMTP email module using smtplib, ssl, and email.mime.
• Sends templated alerts when deviations are flagged or reviews are required.
• Admins and users notified with relevant JPC context.
• All assets bundled into a .exe using pyinstaller.
• Operates entirely without internet on local network.
• Uses ReportLab to generate PDFs, and Jinja2 for dynamic HTML rendering.
• Backend: Flask, pandas, openpyxl, os, smtplib, datetime
• Frontend: HTML, CSS, Bootstrap, JavaScript, Jinja2
• PDF & File Handling: ReportLab, Werkzeug
• Packaging: pyinstaller
• Storage: Excel as the primary backend database substitute
• Efficiently digitized part lifecycle tracking in an offline manufacturing environment.
• Reduced manual errors by automating inspection logging, deviation handling, and document management.
• Ensured secure, auditable, and persistent storage of both data and documents.