赵嘉熙 Email and Phone Number

Advanced Operations in Video Stream Data Validation:Executed complex data queries and analysis using SQL during video stream data validation. For instance, employed JOIN statements to link video data with transaction records, and used GROUP BY and HAVING clauses for data aggregation and filtering to ensure consistency between video surveillance data and actual transaction data. Additionally, utilized Python's Pandas library for further data cleaning and formatting, such as using DataFrame.drop_duplicates() to remove duplicate records and DataFrame.fillna() to address missing values, ensuring data accuracy and completeness.Specific Technical Applications in Data Analysis and Comparison:Conducted comparative analysis between video stream backend system data and merchant SAAS system operational data using advanced features of Excel. Specifically, applied the VLOOKUP function to match and compare information from different data sources and used conditional formatting to highlight data discrepancies, effectively revealing potential inconsistencies or anomalies. In Python, utilized the Matplotlib library to create intuitive charts and visualizations, such as bar graphs and line charts, to display data trends and differences, significantly enhancing the intuitiveness and understandability of data analysis.Tool Utilization in Project Coordination and Communication:Collaborated with the video stream project manager, using project management tools like Jira to track project progress, and Microsoft Teams for daily communication and coordination. The use of these tools not only improved project management efficiency but also strengthened communication and collaboration among teams.Major Achievements:Enhanced Data Accuracy: Improved the data validation process, including the use of advanced SQL queries, Python's data processing capabilities, and Excel's advanced analytical techniques, collectively increasing data accuracy by 15%.

1. [Data Monthly Reports]: Creating data reports for CNNC Kelly Technology using PowerPoint and Excel. Collecting and organizing departmental performance data, ensuring accuracy and completeness, and visualizing data for readability.2. [Management Innovation Application]: Assisting in China Treasure's 2023 Management Innovation Achievement application. Compiling and formatting innovation achievement information, assessing potential award recipients.3. [Research Reports]: Writing industry research reports for the software and IT services sector. Gathering and analyzing data, researching industry trends, and supporting report writing.4. [Intellectual Property Contract Review]: Participating in intellectual property service contract review and modification. Ensuring compliance with regulations to protect company and client interests.5. [SD-WAN Network Design]: Designing smart network applications for SD-WAN technology, including architecture, protocol selection, configuration, and performance optimization for efficient, secure, and manageable networks.