Summary
Skilled Data Engineer and Business Intelligence professional with over five years of experience, specializing in data pipeline development, BI reporting, and data architecture.
Solid background in designing and maintaining scalable end-to-end data solutions, leveraging tools like Snowflake, Power BI, Azure, GCP, GitHub and Python.
Working Experience
- Developed and maintained data pipelines in Snowflake to ingest data from diverse sources, ensuring high performance and scalability
- Designed and optimized data marts within Snowflake, adhering to star schema best practices to support advanced analytics and enterprise-wide insights
- Updated and managed Power BI datasets and reports, enabling all corporate employees to efficiently perform daily operational tasks
- Supported the BI Operations team to resolve issues and improve processes as needed
- Provided technical support to team members, fostering skill development and enhancing project delivery
- Offered guidance to other departments on BI-related queries, facilitating better decision-making and interdepartmental collaboration
- Proposed and implemented innovative enhancements to improve task efficiency and streamline workflows for Power BI and the BI Operations team
- Migrated Power BI Paginated Report data sources from SSAS Cube into Snowflake, modernizing reporting infrastructure
- Implemented customer attributes to define and segment target audiences for Customer Journey analytics, driving tailored engagement strategies and actionable insights
- Re-engineered data pipelines, resulting in monthly cost savings exceeding 1,000 USD
- Led experiments on new Proof of Concepts (POCs), including GitHub CI/CD for Power BI and Snowflake, Master Data Management with Streamlit, and Power BI email automation
- Managed and co-led multiple concurrent projects
- Provided technical guidance to team members on Power BI and SQL, ensuring best practices and improving overall project efficiency
- Designed and developed Finance Data Products leveraging DBT (Data Build Tool) and GitHub
- Played a key role in the recruitment process by interviewing and assessing potential candidates,
- Resolved ad hoc issues in production dashboards, maintaining operational continuity
- Providing team members and junior colleagues technical support in SQL and Power BI related matters
- Transferring Power Query steps to Native Query to modernize and clean up legacy Power BI datasets
- Addressing incidents and fulfilling enhancement requests for existing Power BI datasets and reports
- Developing and maintaining multiple finance-related dashboards for various departments and countries across Asia Pacific, tailored to clients’ needs
- Generating end-user Power BI datasets for self-service reporting using Analysis in Excel
- Maintaining comprehensive documentation for all datasets
- Improving SQL scripts in Google BigQuery for Power BI datasets
- Advocating for process enhancements and implementing best practices for Power BI development and SQL scripting within the department
- Contributed to the development of Python applications related to Power BI
- Explored a variety of third-party tools for Power BI, including DAX Studio, Tabular Editor, Measure Killer, and PBI Tools, with the aim of enhancing the performance of the Power BI dataset
- Resolved a range of Power BI issues, including problems with formatting, chart discrepancies, DAX formula errors, inconsistencies in calculated tables, and data irregularities
- Designated as the go-to person for Power BI related subjects
- Managed Power BI Workspace and Tenant administration duties, including access provision and data source gateway setup
- Implemented Power BI enhancements such as incorporating new visuals, DAX formulas, and database connections
- Created new dashboards from the ground up for various departments such as Digital Marketing, Operations and Sales
- Conducted three levels of Power BI training for clients and advised on best practices for Power BI
- Migrated and reconstructed a SAP Lumira Dashboard into Power BI
- Updated SQL scripts on Azure Synapse using SSMS and Azure DevOps
- Gathered technical and functional requirements from stakeholders for Power BI projects
- Maintained comprehensive documentation for all datasets
- Developed three reporting dashboards using Qlik Sense for internal users of the Customer Service and Billing teams in Malaysia and Singapore
- Created an Invoice Accuracy and Timeliness Dashboard for the Billing Team and Finance for internal users in Malaysia and Singapore using Qlik Sense
- Implemented a weekly predictive modeling report using Python and Machine Learning to identify instances of incorrect code usage, thereby reducing revenue leakage
- Automated repetitive tasks for various reports by creating three hybrid Excel VBA and Power Query macros
- Designed Excel Logic Templates to identify inconsistent data entry by users
- Conducted “Introduction to Excel Macro” training sessions for internal users in Malaysia
- Utilized SQL, Microsoft Excel, Power Query, Pivot Table, and Power BI to process and transform data
- Developed an automated web entry process using UiPath macros
- Designed a VBA macro for Outlook that generates and stores data
Education
- Received Book Prize, President’s List, and Dean’s List awards with a CGPA of 3.92
- Completed coursework in Problem Solving and Programming, Applied Statistics, Operations Research, and Financial Mathematics
- Achieved a Band 5 score in the Malaysian University English Test (MUET)
- Conducted a final year project on the effectiveness of Technical Analysis, Time Series Analysis, and Machine Learning Approaches in predicting stock market movement direction
- Earned 2nd runner-up in the DOSM Datathon 2019 competition
Projects
List of projects
Online Resume
- Online Resume powered by Github
Investment Dashboard
- Investment Earnings Tracker for stock market (ongoing development)
Malaysia Covid Dashboard (Schedule Refresh Halted)
- Power BI Covid Dashboard using data from MoH and CITF GitHub
Business Case Study
- Business Case Study for previous interviews