Gu Tianxu

Digital Engineer

Reckitt Benkiser

04.2022 - Current

As the project manager, participate in the whole process of the project, feasibility assessment,user requirements specifications, bidding, contract signing, software production, testing, launching, improvement and project closure.
The wechat mini program project is one of the important bases for the daily operation of the factory, and the CMMS software project is currently in the process of production.Established the Power BI Report Server and became the report center of the factory. Now the daily operation of the factory is inseparable from this report center. Its influence has spread to China, and about 200 users are active.
Build daily operation reports at the factory leadership level and monthly operation reports at the supply chain level in China.
Build packaging production line daily OEE report, to be able to reflect in time trends of OEE analysis and BD time, factory operations team daily review yesterday's performance KPI. The report data is from Excel.
Packing line real-time report shows the level of each line hours of production and the comparison of theoretical yield and production plan.Frequency refresh level in seconds, the report data from the PLC.
The Energy report shows the consumption of water, electricity, and steam used by the plant at the hourly level, and this part of the data comes from the API interface.
Use python to read Hikvision's API interface, and the data is transmitted every 30 minutes, which is the data source of the attendance system and an important basis for the daily factory human resources operation.
Provided input to team lead regarding areas for process and procedural improvement.
Daily maintenance of the database of reports, sucha as manage database accounts, regular remote backup of database, write views and triggers, regular extraction of OT network database into IT network.

Similar Profiles