Romy Li Email & Phone Number

Sydney, NSW, AU

Sydney, New South Wales, Australia

• Integrated shopping centre traffic data from 3 vendor systems into the client’s Unified Data Platform (UDP) on Google Cloud using Cloud Storage, Dataflow and BigQuery
• Wrangled millions of raw traffic data (including both batch-loaded and streaming), and developed data models using complex SQL in dbt to transform the data and optimise query performance
• Built Tableau dashboards to provide traffic overview and compare accuracy of technology vendors, thus enabling better people counting capabilities
• Developed a CI/CD pipeline leveraging Github to extract survey and customer review data from a third party API using Python and Airflow and ingested the data into UDP to support analytical requirements
• Worked closely with a wide range of stakeholders to understand the business process and requirements and improved data solutions iteratively based on stakeholder feedback

Sydney, New South Wales, Australia

• Building automated and self-serve Tableau dashboards to track trends of key metrics pertaining to our digital newspaper products; achieved significant time savings by replacing existing manual Excel reports
• Writing complex SQL queries in both Google BigQuery and Vertica to extract and manipulate large volumes of data to help answer analytical requests
• Developed a comprehensive data solution in two weeks to support BI reporting ahead of a major product launch

Sydney, New South Wales, Australia

• Developed the AU Credit Insights visualization product that incorporated various advanced features in Tableau and was used to help clients benchmark key metrics against market peers
• Revamped over 30 credit application related Tableau reports to improve usability, consistency, and functionality, oversaw the deployment of these reports from development stage all the way to production
• Enhanced regular BAU items by simplifying and automating the data refresh process and creating more insightful Tableau reports, driving efficiency and reducing workload for the team

Sydney, New South Wales, Australia

• Undertook 4-month’s intensive training on modern analytics tools and systems such as Tableau, Alteryx, Power BI, MS Server, etc.
• Completed 15 mini analytics projects for clients from various industries; leveraged modern tools to help turn their data from its raw format to actionable insights and recommendations