Roles & Responsibilities:1 - Data Processing & VisualizationConducted SQL queries to extract raw & aggregated data from Hive, Databricks & SQL Server; Used Python & PowerBI for fine-grained data processing, dashboard design and implementation.2 - Data AnalysisUsed trend analysis, comparative analysis, factor analysis, cluster analysis, and other analytical methods to gain a holistic view of key business metrics;Drilled down into lower-level metrics as needed to understand patterns & identify anomalies in data;Used the above findings to reason & diagnose the current issues in business operations.3 - Report WritingConsolidated key findings in data analysis & proposed relevant, reasonable hypotheses relating to the business problem; Collaborated with data scientists & used experimental methods (A/B testing) to test & verify the hypotheses that lead to business insights & recommendations.4 - Process ImprovementContinuously identified the problems and bottlenecks in the workflow, such as those related to data quality, and proactively proposed personal opinions & suggestions on such issues through weekly meetings & reports; Contributed to the improvement of team capacity.

In close collaboration with stakeholders, I undertook the position and provided technical solutions and product training for global users of the Data Integration Platform on Microsoft Azure, successfully helped the clients resolve issues related to Data Acquisition, Task Scheduling, Task Performance, Access Control and more.Achievements:1. Helped one client resolve the problem of excess product expenses and reduced 20% of the overall fees2. Received 0 negative feedback from customers during my tenure

During the time, I took the role of a freelance developer while seeking job opportunities. Specifically, I developed an iOS music player app from scratch and passed the App Store review.Roles & Achievements:1. Native iOS application development with XCode and Swift 4, implemented the key functionalities of the app (Custom Playlists, Player View, Favourites, Playback Control)2. App publishing on the App Store, successfully passed App Store review after submission3. Optimizing app views and downloads using App Store Optimization (ASO) techniques, including careful use of relevant keywords, descriptions, app background, increased app exposure (views, downloads) on the App Store