ERP System Development - Tailored MVC Solution

Project Overview:

I'm a skilled developer who optimized an ERP system, tailoring modules to diverse needs. Achievements include dual-currency displays, a streamlined payment system, multi-branch features, and revamped POS for international standards. The system offers comprehensive stock reporting, robust HRM, CRM for customer engagement, and efficient production management. Notably, it seamlessly integrates with ZATCA, meeting Phase 1 and Phase 2 e-invoicing requirements. This project showcases my ability to create versatile, secure, and compliant solutions.

Core Modules

• Accounting
  
• Successfully implemented dual-currency displays to navigate distinct accounting restrictions. Notably, tax limits align with government exchange rates, while sales restrictions are calculated based on dynamic black market rates. This showcases adept management of complex financial features within diverse regulatory environments
• I created a dual-currency payment system for efficient transactions, displaying remaining values and allocating payments to the respective currency funds. This showcases my expertise in designing precise and streamlined financial systems.
• Inventory
• Empowered invoicing, quotation, order, and return processes for enhanced flexibility, tailored to meet the specific requirements of businesses in Lebanon, Saudi Arabia, and Europe. Designed to cater to a diverse range of industries, including commercial companies, airline offices, local and international delivery services, and more, showcasing my ability to create versatile and adaptable solutions. .
• Elevated system capabilities by implementing a multi-branch feature, enabling each branch to independently showcase products and invoices with separate invoice sequences—effectively treating each branch as a distinct system. Additionally, incorporated advanced user permissions, allowing selected users to access all invoices and products while providing filtered activity tracking for enhanced security and accountability. This demonstrates my proficiency in creating comprehensive and secure systems tailored to the unique needs of diverse organizations.
• POS (Point of Sale)
• Revamped POS to meet international restaurant standards, featuring flexible sales, returns, and exchanges. Implemented user-specific floor permissions for enhanced security. Extended functionality to resorts, replacing tables with rooms, facilitating diverse services accessible via phone scanning. Streamlined cash transactions for all services, showcasing adaptability in POS design for hospitality industries.
• Facilitated dual-currency cash transactions with remaining amount display. Integrated VAT calculations at government rates seamlessly into accounting. Designed flexible invoice template to handle any customer format. Demonstrates proficiency in versatile and user-friendly financial solutions.
  
• Stock
• Developed a comprehensive reporting system to track item movements, including sales, purchases, returns, and damages. Utilized flow charts to visualize quantity changes for each item, facilitating insights into best-selling items, item costs, top customers, and preferred suppliers. The system provides a detailed overview of all item-related activities, streamlining the process of monitoring and analyzing various aspects related to items.
• HRM (Human Resource Management)
• development of an HRM system with essential components like an Employee Database for efficient personnel management. It includes modules for Attendance Tracking, Leave Management, Payroll Processing, and Performance Management. The system also excels in handling Employee Benefits and offers robust HR Analytics for insightful reportinge control.
  
• CRM (Customer Relationship Management)
• I comtimue developed a user-friendly CRM system to enhance customer relationships. The system incorporates features such as a detailed Customer Database for efficient management. It includes modules for Contact Management, Deal Tracking, Task Automation, and Email Campaigns. Additionally, the CRM model excels in providing insights through Analytics and Reporting, facilitating informed decision-making for improved customer engagement
  
• Production
• optimize manufacturing processes, featuring detailed Product Information for efficient tracking. The system includes modules for Production Planning, Inventory Management, Quality Control, and Order Fulfillment. Additionally, the Production model excels in providing insights through Analytics and Reporting, supporting informed decision-making for enhanced operational efficiency

E-Invoice Zacta Integration:

Successfully submitted the implemented system to ZATCA for review and obtained approval for compliance with both Phase 1 and Phase 2 requirements.

Phase 1:

• QR Code Implementation:
  • Successfully integrated a QR code onto e-invoices, adhering to ZATCA's standards.
  • Included essential details in the QR code, such as invoice number, date, supplier information, and total amount.
• UUID Assignment:
  • Assigned Universally Unique Identifiers (UUIDs) to each e-invoice to ensure unique identification.
• Hash Function Implementation:
  • Implemented a basic hash function to maintain data integrity, preventing tampering of e-invoice contents.
• Digital Signature Integration:
  • Integrated a digital signature mechanism for authentication and verification of the e-invoice origin.

Phase 2:

• QR Code Enhancement:
  • Expanded the QR code to include additional fields as specified in Phase 2, covering a more comprehensive set of information.
• Advanced Hash Function:
  • Enhanced the hash function for improved data integrity and security features, meeting Phase 2 requirements.
• XML Invoice Standard:
  • Structured e-invoices according to ZATCA's XML standard, aligning with the specifications for Phase 2.
• Detailed Invoice Fields:
  • Incorporated additional fields into the e-invoice XML structure, covering a broader range of information as per Phase 2.
• Extended Digital Signature:
  • Improved the digital signature mechanism to meet advanced authentication requirements for enhanced security.
• Encryption Enhancements:
  • Enhanced encryption techniques to comply with more stringent security standards specified in Phase 2.
• Additional Exchange Rate Handling:
  • Adapted the system to handle additional exchange rate complexities as per Phase 2 requirements.
• Comprehensive Testing:
  • Conducted thorough testing to ensure that the system meets all Phase 2 requirements, including simulations and interactions with the ZATCA system.
• Continuous Compliance Monitoring:
  • Established processes for continuous monitoring of ZATCA updates, ensuring ongoing compliance with the latest standards.