Winkie Wong

• Assigned to a BI project for a luxury brand, responsible for their beauty, fashion, and jewelry division.

Data preparation and reporting

• Used Alteryx to extract, transform, and load data from various sources. Performed daily checks on APAC's online and offline sales data, ensuring the accuracy and integration of the data in the data warehouse.
• Conducted quarterly end-of-quarter data extractions using Nprinting and Alteryx, generating reports for different business divisions.

QlikView Dashboard Administration

• Responsible for maintaining over 30 QlikView dashboards across three business divisions. Ensured the data in the data warehouse was accurately loaded into the dashboards.
• Developed and enhanced dashboards based on user requests, creating custom charts and calculations.
• Performed UAT for major projects. Analyzed impacts on dashboards after system changes.
• Ensured dashboard access controls met audit standards through biannual access reviews.

User / Client Communication.

• Handled user requirements. Investigated and identified user-reported issues, explaining dashboard definitions, and troubleshooting.
• Conducted QlikView training sessions for internal stakeholders.

Getting requirement

• Collaborated cross-functionally with business and IT teams to understand requirements and facilitate the software development lifecycle.
• Elicited, analyzed, and documented detailed business and functional requirements.
• Designed and delivered RPA and digitization solutions.

Power App and Power Automate Building

• Leveraged low-code platforms like Power Apps and Power Automate to build custom applications and workflows, in order to validate user input, reduce errors, automate repetitive tasks and enhance productivity.
• Developed and implemented solutions that streamline approval workflows and improve efficiency.

Replacing legacy RPA solution

• Replaced the legacy RPA solution with an improved automation system for the DBS Hong Kong Branch.
• Performed data analysis and utilized Power Query to convert raw data into a format suitable for reporting and visualization.

Updating P/L

• Maintained and updated the Profit and Loss Statement to ensure financial reporting accuracy.

Communication

• Utilized Jira to manage project tasks, track progress, and communicate effectively with stakeholders across different teams.