ULD Management system

ULD Management system

Business Needs

Client wanted Software solution design spawned across Tablet Application and Web-Based interface with key objectives being – Overall cost reduction of operations by reducing manual efforts involved in execution of jobs, Data trace-ability, system generated least laborious reports, executive analytics along with visualizations, notifications for key aspects that require attention increase throughput by at least 30% with same resource/infrastructure cost.

Technology Skill Set

Asp.Net MVC
95
SQL Server 2016
65
Azure Web Apps
60
App Insights for Health Monitoring
75
Azure CDN
70
Entity Framework
70
Technical Objectives
  1. Global Search on Driver Ticket No, Repair Job No, Form1, ULD Serial No,CoC No
  2. Predictive analysis of cash flow
  3. Calendar Integration
  4. Tracing ULD across different stages
  5. Activity based contract Generation.
  6. Bulk Import of the parts.
  7. Roles and permission-based access.
  8. Creating masters for modules such as offices, approvals, Bank Accounts OEMs etc.
PSSPL Solution
  1. Azure cloud-based Enterprise System – Tailored to ULD maintenance service operations
  2. Android Tablet App and Web Interface Powered by robust REST API architected and deployed over Azure
  3. Job-creating option along with the functionality to add all the details such as pick up and drop location, schedule pickup with a calendar view.
  4. Service lifecycle for all offered services – Repair, Storage, Rebranding, Leasing
  5. Container-based parts administration with bulk Import and inventory management along with integration with job execution process
  6. Automated EASA Form Generation
  7. Reports – extensive reports generation along with CSV and PDF exports- Which included reports for Service Request, Parts and attendance management with some of the important filters which included
    • Customer selection and location
    • ULD Type
    • Equipment Type
    • Selecting Office
    • Frequency – Weekly, Monthly, Yearly
  8. Analytics – dashboard with key business statistics and trends to identify bottlenecks in seconds
  9. Payroll module to handle wages with least efforts
  10. Automated invoice generation and sent through customer portal with the option for configuring rates for repair and storage services
  11. Contract Management functionality for each of the companies
  12. Rights management based on offices creating separate layer of authentication between the offices
  13. Beyond Economic Repair Management – Controlling a threshold amount beyond which the repairs request should not be processed
  14. ULD Movement management which enabled tracking of each and every driver and vehicle
  15. Calendar integration for showing allocation
  16. Different Administrative options including OEM Management, Closures, Documents, Material etc.
  17. Time Tracking for each of the employees with punch in and punch out functionality and also the employees would be able to add his timesheets and also fill miss pinch request
  18. Functionality of categorizing job as Repair or Storage

net

Benefits
  1. With the integration of dashboard, every information was available for the admin at one glance
  2. Automation of their manual process meant that their time was saved and hence increasing their efficiency
  3. Keeping track of each and every part was made easy
  4. Employee tracking was just a click away
  5. Paperwork was reduced to Nil
  6. With a step by step execution automated process, it made their daily work process smooth
  7. Invoice management with the functionality of Tax inclusion proved a masterstroke for them in term of handling and getting the funds release
  8. Future analysis/Prediction of the cash flow helped the client to plan his investments accordingly
  9. Drill down report – Giving even a micro level information at a single glance