Man-hour management is a very critical part of the pharmaceutical R&D project management process. Taking CRO (pharmaceutical R&D outsourcing service organization) as an example, its service charge is calculated according to the man-hours spent by project personnel and the unit price of man-hours, and man-hours management directly reflects the project cost; in addition, scientific and accurate man-hours management can also reflect whether the allocation of resources is reasonable or not, and provide a basis for decision-making to optimize the project’s resource allocation, so that the purpose of cost reduction and efficiency increase can be achieved. To achieve the purpose of cost reduction and efficiency.
For CRO enterprises, they undertake many R&D projects, and there are new projects joining in the middle of the process, and the process data formats and standards of different projects are different. Traditional project management software, due to its low degree of freedom, is often unable to help in the face of such a complicated task of working hour statistics, and many enterprises have to export working hour data regularly, and clean and organize a large number of data forms manually, which is a tedious workload, and project management personnel have to face the problem. In the face of such a cumbersome workload, project managers are simply overwhelmed! In addition, manual processing is difficult to ensure that the data is instantly updated, which can easily lead to information lag, and cannot provide agile and powerful support for project decision-making. Moreover, from the perspective of data security, manual processing inevitably leads to data tampering due to various reasons, and these changes are difficult to be traced back, which also makes it difficult for the regulatory authorities to verify the data.
SDH Scientific Data Genome Platform provides a fast, efficient and safe solution to the above labor management problems.
▶ Automatic cleaning and conversion of a large number of data tables, and one-step splicing of new tables.
In the SDH platform, first select “File Connection & Management” in the Data Connection section, and upload the monthly working hours statistics table to SDH.
After entering the data editing page, we can make use of a series of conversion tools such as “Delete Empty Rows” and “Inverse Pivot” to organize and clean the working hours data; meanwhile, the “Conversion Rules” workflow generated together with the conversion and cleaning can be saved. At the same time, the “conversion rules” generated with the conversion and cleaning workflow can be saved, which is convenient for the subsequent one-click cleaning of the work hour data table.
By customizing the saving, we can summarize the work hour statistics table of multiple months into a single data table, and quickly realize the data splicing of multiple months. At the same time, the subsequent addition of the project hours data table can also be realized one-step splicing.
▶ Multi-dimensional statistical report presentation, data synchronization and updating with one click
After completing the data cleaning, we can use the platform’s BI report function for data statistical analysis. The established statistical table can be saved, and when there is a subsequent update of the working hours data, you can directly click on the report to view the latest statistical results, which can efficiently help accurate decision-making.
In addition, project management and materials (reagent) management and other systems within the budget and expenditure, can also be achieved through the SDH platform data fusion project cost statistics and display.
▶ Strict Audit Trail and Permission Management to Ensure Data Security and Traceability
The SDH platform does not allow any modification to the data, while built-in strict audit trail and authority management, all operations are clear at a glance, adding layers of security to the data.
