Design And Implementation Of Delivery Associates’ Payroll Management System

With the rapid growth of E-Commerce industry in China, the shipments of online shopping increase almost by geometric ratio in every single day. The team of delivery associates continues to expand. The accuracy of delivery associates’payroll calculation has gradually catched the attention of e-commerce corporations, with Amazon no exception to this trend. Before this, the complex calculation process has always been accomplished in an excel file by the staff of human resource department, which not only cost too much human and financial resources, but also leads to mistakes caused by various kinds of problems.Amazon takes in the consideration of the condition that the The total quantity of data grows beyond the loads of human resouses, the number of delivery associates, cities, shipments and rules continues to increase and the logic of business process becomes more complex. A delivery associates’payroll management system project is set up and implemented by the SDE team to achieve transparency of rules, payroll and delivery associates’management. Contemporarily, through data analysis, Amazon could adjust the rules and conduct data mining.The system can meet the demands of Human Resource department, station leaders and devlivery associates. To the role of human resource staff, the functions of configuration of the system, salary management, rules configuration and exception handling are supported. At the same time, the station leaders and delivery associates are also allowed to use the system within the role configuration of the system, such as querying payroll and its details.The author has been responsible for this project at its very beginnig, including the requirement acquisition, the project and database design, developing and testing. The core of this project is payroll calculation, rule configuration and the complex business process. Therefore, the cooperation and communication between departments seem much more important. After the requirement analysis, the author designed the whole frame of the system and the modules of functions according to the requirement. In this process, the author discussed a lot with my boss and my colleague to confirm the detail realization. Then the author began to do the code process including the pages and backstage developing. In the period of my internship,6functions and more than10interfaces have been completed and the system has been used for calculation for3 months.The important points and difficulities are as below:first, the pulling and matching of the data is difficult to handle for the reason that the sources and patterns of the data is different and the process of matching is complex; second, the rule configuration. The accuracy and effectiveness should be guaranteed to make the calculation correct; third, the calculation of shipment commission, which is a major part of DA payroll. Its logic of calculation is very complex.To support better expansibility and maintenance, the system is based on the traditional pattern B/S architecture, using SSH frame. Pages are built with JQuery and Ajax to send parameters. Data is storaged in Oracle database. Tomcat is used as the application server and Git is used as the version management tool.