KIMBERLY SHEK
PowerBI Specialist
Tai Po
Summary
Kimberly Shek is a passionate and professional advanced analytics consultant with structured problem solving and solution-oriented mind-set. She is familiar with programs such as PowerBI, MySQL, Cypress, Alteryx, R, Python, and able to write scripts.
Overview
11
11
years of professional experience
14
14
years of post-secondary education
1
1
Certification
Work History
Business Analytics
Hong Kong Science and Technology Park
11.2023 - Current
- Gathering Business Requirements: Collect business requirements from different departments. Conduct data analysis to support business requirements. Document business requirements, analysis, and project progress.
- Data Visualization Solutions: (PowerBI) Develop data visualization solutions using dashboard to achieve business goals. Collaborate with multiple business units to achieve business goals while ensuring internal customer satisfaction.
- Project Management: Responsible for business requirements gathering, analysis, and project documentation. Manage projects simultaneously while building strong relationships with user teams. Assist in developing and reviewing requirements, specifications, business processes, and recommendations for the proposed solution from various parties. Analyze operational matrices, interpret data, and analyze results using statistical techniques such as dashboards. Conducting user acceptance tests and user training prior to implementation.
Data Analytics Consultant
PINEWOOD ASIA PACIFIC (HELIOS DIGITAL)
04.2020 - 11.2023
- Developed customized dashboards (PowerBI) for real-time monitoring of key performance indicators, leading to quicker response times and informed decision-making processes.
- Enhanced data-driven decision making by implementing advanced analytics techniques and tools (PowerBI Report Builder).
- Develop data analytics tools, ETL solutions and Python Scripts to enhance the business proposition to clients
- Articulate the value proposition and relevant use cases for a variety of Pinewood Asia Pacific services to prospective clients, developing a deep understanding of the client business operations and challenges.
- Work closely with multiple stakeholders to achieve business goals while ensuring internal and external customer satisfaction.
- Manage multiple campaigns in multiple regions concurrently.
- Perform testing on new web product (Cypress).
Associate Consultant
RXP
09.2018 - 04.2020
- Perform data analytic regarding different projects.
- Pinewood - Dashboard reporting (PowerBI): Perform analysis on data and create data model. Build dashboards for decision making.
- WeLab - Collibra Implementation & Data Governance (Collibra): Build data catalog. Configure collibra settings. Aid in creation of data governance operating model.
- ANZ - Compliance Reporting Automation (Alteryx): Perform ETL transformation for data from excel to XML. Generate output file using ETL.
- HKEX - Next Generation Data Warehouse (NGDWH) (Pentaho - PDI, R): Perform ETL transformation for data throughout different layer. Generate output file using ETL for calculating risk. Perform QA Analysis. Perform system test.
- Pandora - Initial Data Quality Assessment (MySQL): Perform data cleansing with the CRM data. Facilitate the migration process. Transform the data into Pandora standard POS way. Deliver the cleansed CRM Data on the go live day.
Quality Assurance Assistant
ANGLO-EASTERN SHIP MANAGEMENT LIMITED
05.2017 - 09.2018
- Maintained incident and on-board training records for compliance and analysis purposes.
- Developed automation reports to improve efficiency, eliminate waste and free up labor hours for other needs.
- Promoted workplace safety by adhering strictly to all guidelines during routine inspections within a manufacturing facility setting.
- Aided QHSE Manager in the creation of comprehensive training materials for fleet officers on best practices in quality assurance, fostering a culture of excellence within the team.
KYC Officer
STATE STREET
09.2016 - 03.2017
- Reduced risk exposure by diligently reviewing client information for potential red flags and escalated issues as necessary.
- Uplifting case details onto new platform.
- Maintained accurate records of all client data, ensuring timely updates to reflect changes in risk profiles or regulatory requirements.
Data Analyst
THINKCOL
07.2016 - 09.2016
- Writing a proposal regarding Anti Money Laundry for casino in cruise.
- Used statistical methods (R scripts) to analyze data and generate useful business reports.
- Improved decision-making processes with accurate data analysis and visualization techniques (Tableau).
Outreach Analyst
ACCENTURE
11.2015 - 03.2016
- Collect FATCA form and documents from Client. Know-Your-Customer for Client onboarding and renewal.
- Support data analyst in FATCA team, help organizing complex excel.
- Support Client Manager in sector of Global Market in HSBC.
Underwriting Clerk
METLIFE INSURANCE COMPANY
08.2015 - 10.2015
- Data Capture with Life 400 system.
- Daily routine such as handling internal document, replying email for B2B and ad hoc project.
- Liaised with different teams to ensure completion of tasks.
- Enhanced department efficiency by streamlining processes for data entry, application review, and documentation.
- Cross-referenced information from multiple sources and extracted any additional information as needed.
Administrative Clerk
METLIFE INSURANCE COMPANY
05.2014 - 08.2014
- Help to increase working efficiency by writing excel formula.
- Input data and processed system change to generate accurate reports.
- Supported staff on special assignments and ad hoc projects.
Education
Bachelor of Science - Economics and Statistic
UNIVERSITY OF TORONTO
Canada 04.2001 - 01.2015
Skills
PowerBI reporting
Business intelligence solutions
Performance analytics
Data analytics experience
CRM business processes
MS office
Problem-solving
Teamwork and collaboration
Friendly, positive attitude
Certification Or Education
Collibra Expert - Level 3, Domo Professional Services, Pentaho PDI Fundamental, UNIVERSITY OF TORONTO, Toronto, ON, Honor Bachelor of Science: Economics and Statistic, 2015, BELL HIGH SCHOOL, Bell, ON, Ontario Secondary School Diploma, 2011
Certification
Microsoft PowerBI Data Analyst
Timeline
Microsoft PowerBI Data Analyst
10-2024
Business Analytics
Hong Kong Science and Technology Park
11.2023 - Current
Data Analytics Consultant
PINEWOOD ASIA PACIFIC (HELIOS DIGITAL)
04.2020 - 11.2023
Associate Consultant
RXP
09.2018 - 04.2020
Quality Assurance Assistant
ANGLO-EASTERN SHIP MANAGEMENT LIMITED
05.2017 - 09.2018
KYC Officer
STATE STREET
09.2016 - 03.2017
Data Analyst
THINKCOL
07.2016 - 09.2016
Outreach Analyst
ACCENTURE
11.2015 - 03.2016
Underwriting Clerk
METLIFE INSURANCE COMPANY
08.2015 - 10.2015
Administrative Clerk
METLIFE INSURANCE COMPANY
05.2014 - 08.2014
Bachelor of Science - Economics and Statistic
UNIVERSITY OF TORONTO
04.2001 - 01.2015
Similar Profiles
Xxx XxxXxx Xxx
Officer, Ecosystem and University Technology Transfer at Hong Kong Applied Science And Technology Research InstituteOfficer, Ecosystem and University Technology Transfer at Hong Kong Applied Science And Technology Research Institute
Victoria AnkrahVictoria Ankrah
Research Associate/ Head of External Relations at The Hong Kong University of Science and TechnologyResearch Associate/ Head of External Relations at The Hong Kong University of Science and Technology
Pak Him (Ryan) KwokPak Him (Ryan) Kwok
Summer Internship at ASTRI - Hong Kong Applied Science and Technology Research InstituteSummer Internship at ASTRI - Hong Kong Applied Science and Technology Research Institute
Cheuk Hei ChanCheuk Hei Chan
Assistant Administrative Manager at TopBest International LimitedAssistant Administrative Manager at TopBest International Limited
Lau Cheong HungLau Cheong Hung
Senior Project Manager at Atelier TAG Interiors LtdSenior Project Manager at Atelier TAG Interiors Ltd