Data Analyst

• Aug 2021 - Present

Data Analyst Intern

• Feb 2020 - Aug 2020

• Implemented a predictive model with a feedforward Artificial Neural Network for an E-commerce client that reduced operational expenditure due to order cancellations by 25% • Built Tableau dashboards structured data to quickly explore and obtain insights aiding to client’s customer relationship management (CRM), marketing optimisation and campaign management applications • Introduced an automatic report generation tool to highlight latent semantic similarities between client’s primary patent document and a set of other patent documents. Project succeeded in eliminating laborious work involved using text analytics • Recognised by The Director for well-articulated presentation of analytical insights using Tableau, Power BI and project reports

Casual Academic

• Jan 2020 - Jul 2020

• Tutored students of bachelor’s degree level in “SIT307: ML and Data Mining” available within faculty of Science, Engineering and Built Environment • Provided expert academic guidance and practical coaching to 25 students per semester in a classroom setup • Developed and administered assessment regimes and activities to help access student progress and student's knowledge of key concepts • Prepared study guides and assessments aligned within university curriculum. Marked and supplied constructive feedback to 200 plus student task submissions

Junior Data Analyst

• Feb 2019 - Jul 2019

• Charted interactive dashboards using Power BI to convert complex data from XERO database into reports that highlight trends, opportunities, challenges between inputs and performance of organisation in terms of profit, expenses and revenue. Performed composition analysis to explore constituent business revenue sectors and expense categories • Access web data using PHP MySQL queries and/or extract relevant data from software APIs in required format. Convert extracted data from one format to other using various data wrangling techniques as required. Clean and prepare unstructured data for downstream analytical purpose • Designed and installed a dynamic customer analytics dashboard using Tableau to help analyse key customer demographics. Customer segmentation enabled users to see core customers by region, profession and services purchased

Associate Data Consultant

• Sep 2017 - Oct 2018

• Directed “Investment Maintenance” project commissioned by Royal Bank of Canada (RBC). Mentored a team of five with expert guidance and knowledge transfer. Achieved “Best Engagement Award” under Financial and Services umbrella• Spearheaded the project as a single point of contact with RBC. Responsible for analysis of high-level business requirement document. Create project understanding report, project plan with deliverables and timeline, and project closure report• Delegate tasks to team members. Provide insights and project progress to client with extensive daily, weekly and monthly reports• Pioneered in automating Term Investment system portal with ConfirmIQ to reduce repetitive task involved in opening a term deposit account while testing an online TIS portal

Senior Engineer

• Sep 2016 - Aug 2017

• Experienced in analysing BI needs, interpreting business user requirements and translating it into reports by dealing with different structures of data• Developed new reports and delegated tasks to team members and presenting the findings and data to the team to improve operations and strategies. Manage project testing phase and procedures for metrics reports and also providing Ad-hoc analysis reports to counterparts as per requirements• Regulated daily stand-up and triage meetings to collaborate with clients, subject-matter experts, developers and testers

Software Engineer

• Jul 2015 - Aug 2016

• Reviewed and improved report automation effectiveness through extensive use of Macros, Power Pivots and Data Models. Utilized other advanced Microsoft Excel functionalities to develop daily, weekly and monthly reports. Automatic report generation reduced time and efforts required while ensuring consistent and accurate business report delivery• Orchestrated exploratory analysis on performance of quality assurance team for critical insights such as the relationship between defect type, defect reproduction time, defect priority and tester• Execute SQL queries on MS SQL server to fetch necessary data from the repository. Gather data and convert it into required format with data munging techniques followed by data cleansing