Intern

China Railway Siyuan Survey And Design Group Co., LTD

Requirement Gathering Stakeholder Collaboration Engaged in regular discussions with engineers and business teams to define project requirements precisely. Identified the scale, type, and sources of datasets, including IoT and operational data from smart meters, transformers, and other devices. Defined key data characteristics and metrics to track (e.g., uptime, temperature, voltage) for statistical analysis and predictive maintenance. Task Planning Collaborated to define the scope of data processing, including tasks such as data cleaning, transformation, and statistical analysis. Established performance metrics (e.g., processing speed, accuracy) and ensured alignment with deadlines. Integrated a Vue.js web component to dynamically display real-time equipment operation data, enhancing visibility for stakeholders through automated dashboards. Data Processing Data Reading and Preprocessing Leveraged Pandas and Dask to efficiently read, clean, and preprocess large datasets. Managed missing data and normalized datasets to meet analysis requirements. Prepared data for statistical analysis by organizing it according to equipment type, time intervals, and operational metrics. Data Analysis and Reporting Conducted detailed data analysis and generated tables, charts, and reports to summarize findings. Delivered visualizations to both engineering and business teams, guiding decision-making and project planning. Automated key metrics dashboards, such as equipment uptime, fault detection, and operational efficiency, using the Vue.js component to support real-time monitoring. Outcomes and Impact Effective Data Management Managed and processed large datasets, ensuring they were clean, accurate, and prepared for analysis, improving overall project efficiency. Improved Communication Maintained transparent communication with stakeholders, aligning data processing tasks with performance goals and business outcomes. Skill Development Gained hands-on experience with Pandas and Dask for large-scale data processing. Enhanced ability to translate complex data insights into actionable recommendations for non-technical stakeholders. Developed proficiency in Vue.js, creating web-based components to monitor equipment operation data and ensure seamless stakeholder access to real-time metrics.

Media