Singapore, Singapore
Welcome! I'm pursuing a Bachelor of Science in Information Systems at Singapore Management University, focusing on Business Analytics and Digital Cloud Solutioning. Currently, I'm interning as a data engineer at Synapxe, where I harness a variety of data sets to drive business solutions. My role involves setting up ETL, developing analysis scripts, and working closely with stakeholders to translate business needs into actionable data-driven insights. I'm proficient in Python, PowerBI, and SQL and I apply these tools to perform data validation, ETL and Analysis. I'm enthusiastic about the power of data to transform businesses and lead innovations. Let's connect to explore how we can drive progress together.
- Developed and maintained stored procedures, views, and functions in SQL server to optimize data processing and automate complex business logic, resulting in a 50% reduction in time spent on manual data processing. - Developed and maintained extract, transform and load (ETL) processes using Informatica to automate data integration. - Automated data cleaning process using python library, increasing efficiency by 60%. - Documented coding standards and SOP, providing a comprehensive reference manual for team and increasing productivity by 25%.
- lead integration efforts between international and local students by organizing events and working with 13 cultural clubs - provided guidance to the ICON events and welfare departments to drive diversity and inclusion initiatives within the SMU community.
- Extracted, cleansed and transformed Excel data sets using Power Query - Designed and developed interactive IT Budget Management Dashboard using Power BI, offering real-time insight into budget allocation, spending and KPIs - Collaborated with cross-functional teams to identify user requirements and formulating the structure of the dashboard
Sourced and coordinated sponsorship from external stakeholders to fund the production by distributing email blasts to 50 organizations