Skip to content

Executed the full Software Development Life Cycle (SDLC) for a database management system migration using MySQL, leveraging Agile Scrum methodologies and achieving a projected ROI of 40.14%.

Notifications You must be signed in to change notification settings

samiksha-khare/software-project-management-OSS-migration

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

4 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Eco-Friendly Furniture Co. - Environmental Management System (EMS)

πŸ“‹ Company Overview

Eco-Friendly Furniture Co. is a sustainable furniture manufacturer dedicated to producing stylish and environmentally friendly solutions.

  • Headquarters: San Francisco, CA
  • Founded: 2013
  • Company Size: 100-150 employees
  • Mission Statement: To minimize our environmental footprint while providing high-quality, functional furniture for homes and businesses.

πŸ› οΈ Business Problem

Eco-Friendly Furniture Co. faces challenges in managing and analyzing its environmental impact data effectively:

  • Decentralized Data: Environmental impact data is stored in Excel files within SeedDMS, making analysis cumbersome.
  • Manual Processes: Reliance on manual analysis restricts informed decision-making and increases compliance risks.
  • Scalability Issues: Current workflows cannot handle growing data volumes efficiently.

Key Environmental Impact Data Includes:

  • Energy Consumption: Electricity usage, renewable energy, fuel consumption.
  • Material Sourcing: Types, quantities, and origins of raw materials.
  • Logistics: Emissions from the transportation of materials and goods.
  • Waste Generation: Types and quantities of waste generated during production.

πŸ’‘ Proposed Solution

To address these challenges, we propose developing an Environmental Management System (EMS) web application that:

  • Utilizes a MySQL backend for centralized data storage and management.
  • Integrates with SeedDMS for compatibility with existing workflows.
  • Provides Python-powered data analytics for automated processing and reporting.
  • Implements user authentication and access controls to ensure data security.

πŸš€ Technologies Used

  • Backend Database: MySQL
  • Analytics Engine: Python
  • Integration: SeedDMS
  • Security: User authentication and access controls

πŸ” Database Research Summary

  • DBMS Competitive Analysis
  • MySQL SWOT Analysis
  • MySQL Upstream & Downstream Evaluation
  • MySQL User Success Stories

πŸ›‘οΈ Risk Management

To mitigate potential risks like software failures or security breaches, the project includes:

  • Regular Database Backups
  • Stringent Access Controls
  • Thorough Testing Protocols

πŸ“‹ Project Development Lifecycle

We adopt a Scrum + Incremental Model to ensure agile and iterative development:


πŸ§ͺ Testing Strategy

The EMS system will be rigorously tested for:

  • Unit Testing
  • Integration Testing
  • End-to-End Testing

πŸ—‚οΈ Key Deliverables

  1. Fully functional EMS Web App with a centralized MySQL database.
  2. Python-powered analytics and reporting modules.
  3. Documentation, test reports, and user manuals.
  4. Scalable architecture ready for future data growth.

🏁 Conclusion

The EMS will enable Eco-Friendly Furniture Co. to efficiently manage and analyze environmental impact data, improve transparency, and support sustainable growth.

About

Executed the full Software Development Life Cycle (SDLC) for a database management system migration using MySQL, leveraging Agile Scrum methodologies and achieving a projected ROI of 40.14%.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published