Daniel Chui Email & Phone Number

Hong Kong Sar

Hong Kong Sar

Experience Highlights:- Solid knowledge and experience in finance and insurance industry- Solid knowledge and experience in financial accounting, investment accounting, regional and local project implementation etc- Have project experience in changing accounting standard from IAS39 to IFRS9 for local ledgers reporting by BI solution- Have project experience in GL data model conversion from from BW 7.x to BW 7.5 on HANA.- Have project experience in BI reporting solution for balance sheet reconciliation on top of SAP BlackLine.- Have production experience in tuning BI extraction and overall performance to accelerate month-end closing- Have project experience in Power BI supported by Azure and SAP BI- Have basic knowledge with data analytics and visualization tools e.g. Tableau and PowerBI- Have basic knowledge with RPA tools e.g. Tricentis Tosca Commander and UiPathRole:- Lead and drive offshore BI support team and external consultants in delivering project deliverables to meet business objectives within the budget, resource and timeline- Manage business requirements gathering, gap analysis, effort estimation, timeline planning, solution design, and lead the development, UAT, go-live cutover, user-training, hyper-care and post-production support- Provide expert guidance to external consultants, offshore BI support team on BI skills and technologies, change requests solution, development plan and direction, problem resolution- Define BI standards, guidelines and best practices for business groups and technical teams.- Recommend strategies to improve the performance and capacity in BI systems- Manage system integration with other solution architects across key functional pillars- Collaborate with different level of management, business stakeholders, vendors, various teams across functions or systems- Plan ahead BW roadmap on the transformation to S/4 or BW/4 HANA- Ensure BW solutions scalable, sustainable and aligned with business needs and standards

Hong Kong Sar

Experience Highlights:- Solid knowledge and experience in finance and insurance industry- Solid knowledge and experience in financial accounting, investment accounting, regional and local project implementation etc- Have project experience in changing accounting standard from IFRS4 to IFRS17 for group ledgers reporting by BI solution- Have project experience in changing accounting standard from IAS39 to IFRS9 for group ledgers reporting by BI solution- Have SAP S4 project experience in implementing FAM and BI group solution to S/4 HANA system in ChinaRole:- Lead and drive offshore BI support team and external consultants in delivering project deliverables to meet business objectives within planned budget, resource and timeline- Manage requirements gathering, gap analysis, effort estimation, timeline planning, solution architecture design and lead the development, UAT, go-live cutover, user-training, hyper-care and post-production support- Provide business and technical solution to offshore BI support team on major change requests from project and BAU perspective- Provide expert guidance to external consultants, offshore BI support team on BI skills and technologies, development plan and direction, problem resolution- Manage system integration with other solution architects across key functional pillars- Collaborate with different level of management, business stakeholders, vendors, various teams across functions or system platforms for successful deployment of BI reporting and analysis solutions.- Oversee all project and BAU design decisions ensuring the integrity and conformance of group SAP and BI system- Ensure that BW solutions are up to date with AIA business processes, upgrades or changes thereof and aligned to operational needs and standards at all times

Hong Kong Sar

- Have in-house MNC experience especially on insurance and finance industry- Have end to end regional project experience and full participation in country roll out - Collected and analyzed user requirement then translated as functional or technical specification- Designed and implemented BW solution to integrate with different source systems e.g. SAP ECC, Bloomberg MARS, other investment systems, interface files etc.- Planned BW project timeline and resource as well as performed impact analysis on project requirement- Have hands-on experience of implementing BW solution for different SAP modules in various projects including FI-CO, AR, AP, FA, CCA, BPC, FAM, FX-RE, CM etc.- Coordinated and communicated with different level of stakeholders and end users across business units and functions throughout the project cycle- Managed external consultants and ABAP developers to ensure that BW deliverables were meeting the requirement and completed on project schedule- Performed UAT support and resolved all the challenge till project completion- Provided hypercare support, user training and transferred the knowledge of new implementation to BW support teams in Malaysia post go live- Played an advisory role to assist Malaysia BW support team for new change request in terms of timeline, resource planning, solution architecture design and implementation as well as quality check approach- Have hands-on experience in BW role authorization with S&A team- Have hands-on experience in Solman transport with BASIS team- Have project experience in service pack upgrade with BASIS team- Have project experience in fiscal year conversion with SAP vendor and consultants- Have project experience in FAM data model conversion from from BW 7.x to BW 7.5 on HANA- Have hands-on experience with data visualization tool such as Tableau- Proficient in data or reports reconciliation and quality assurance

Hong Kong Sar

- Developed and maintained Microsoft Access program for group investment accounting team to prepare OTTI in the month end closing and assist the SAP TRM-FAM data conversion for different countries- Developed and maintained business intelligence reports for group investment accounting and group reporting team to facilities IFRS financial reporting disclosure, management reporting analysis and month end closing- Reconciled FAM BI reports with sub-ledgers, GL and BPC reports in UAT to ensure report accuracy and completeness- Collected the user requirement from group office and formalize the report specification for BI development- Performed UAT support, resolution and knowledge transfer to group investment users for BI report deliverables- Developed Microsoft Access program as interim solution to automate the reconciliation between FAM and GL which facilitated GL integration project, accelerated and standardized the year end closing process of group investment and enhanced the accuracy of financial reports which contributed to IPO

Hong Kong Sar

- Supported Hyperion users and maintained VBA program and reports for group reporting team that facilities USGAAP financial reporting disclosure- Developed VBA program to prepare the chart of account for AC4 mainframe system and the interface mapping to SAP 4.7 and 6.0

Hong Kong Sar

- Monthly loaded actual data from Oracle General Ledger to Oracle Financial Analyzer to synchronize actual data of two systems- Ensured OFA data accuracy and completeness after pulling actual data- Quarterly uploaded forecast data to parent company through Hyperion spreadsheet loading form and retrieved the reports for financial analysts after running consolidation in Hyperion business rule- Prepared ad hoc OFA and EBIS budget reports or analysis for different cost center users and financial analysts- Uploaded the annual budget to Oracle General Ledger in the new accounting year and set the budgetary control on specific accounts- Performed budget and encumbrance journal transactions in Oracle General Ledger and resolved the problem regarding fund available balance- Provided Oracle Financial Analyzer system support and administration for HTHK and HGC in daily operation and budgeting cycle- Liaised with cost center users to ensure proper and timely budget input in Oracle Financial Analyzer within budgeting cycle- Participated the system implementation project – Oracle Enterprise Planning and Budgeting(EPB)- Supported Oracle Indian consultant with local oracle project team in requirement gathering, system development, UAT and production rollout for EPB- Assisted in defining and testing EPB management reports, budget templates, user access right, dimensions hierarchies and business processes- Ensured EPB data accuracy and completeness for historical budget and actual data pulled from OFA and Oracle EBIS- Supported the users in stress testing to find out the system performance issues- Reviewed sales plan proposal submitted by sales team and reported to manager

Hong Kong Sar

- Completed finance system projects for Shinwa International Holdings Limited and Hong Kong Exchanges and Clearing Limited- Participated user meeting with a senior colleague to collect the user requirement to assist system development- Used Excel VBA programming with Hyperion to generate finance reports for users to enquire online and perform what-if analysis- Used Hyperion spreadsheet add-in function to extract and upload the financial data as well as viewing the financial data from different points of view- Utilized Hyperion Interactive Reporting and Financial Reporting tools to generate Business Intelligence reports for users to enquire online and perform what-if analysis- Constructed and maintained multi-dimensional cubes in Hyperion Essbase for data storage and retrieval- Constructed the simulation environment and uploaded real data to Essbase for user acceptance testing- Communicated with different users to satisfy ad hoc requirement on systems and reports- Supported the system production on site and user acceptance test- Wrote the user manual and provided training to the users