Senior Data Analyst
Current1. Conducted data analysis to identify operational improvement areas, thereby enhancing operational efficiency• Used SQL and Python on Databricks and QlikView to query the data and transform the retrieved data for further data analysis• Investigated the transformed data and KPI reporting dashboards, proposed improvement plans to business units and IT team to enhance the Straight-Through-Processing (STP) rate and reduce turnaround time (TAT)• Collaborated with the teams to… Show more 1. Conducted data analysis to identify operational improvement areas, thereby enhancing operational efficiency• Used SQL and Python on Databricks and QlikView to query the data and transform the retrieved data for further data analysis• Investigated the transformed data and KPI reporting dashboards, proposed improvement plans to business units and IT team to enhance the Straight-Through-Processing (STP) rate and reduce turnaround time (TAT)• Collaborated with the teams to successfully uplift the STP rate by 5%, demonstrating a tangible impact on operation efficiency2. Performed data visualization to enhance data transparency and provide comprehensive performance illustration for the management level• Used Power BI to build interactive KPI reporting dashboards to detect data anomalies and draw business insights such as identifying digital adoption trends, top performers and underperformers3. Initiated reporting automation to minimize manual tasks• Created automated workflows that consist of Databricks, Power BI, Excel, Power Automate and UiPath to automate repetitive tasks such as data entry, file transfers and file conversion, saving 80% of original manpower and reducing the risk of human error Show less