Hong Yuen Tam

Key Achievement Projects:

• Implemented the SAGE accounting system, transforming manual accounting processes into computerized and resulting in 50% time savings.
• Managed projects through budgeting, scheduling and complex problem-solving.
• Generating accurate and timely financial reports, These reports help Director understand the company's financial position and make informed business decisions.

Regular Tasks:

• Managed payroll operations for team of employees.
• Prepared the monthly budgets, financial forecasts and variance analysis using EXCEL and SAGE.
• Maintained cash flow by monitoring bank balances and cash requirements.
• Oversaw accounting department of 2 employees in managing all aspects of accounting, e.g. payment collection.
• Applied advanced Excel skills to efficiently analyse large data sets.
• Uploaded the invoices data from Purchase system to SAGE.
• Handling 10 invoices and 2 credit notes daily from suppliers and uploading them to the SAGE system.
• Reconciled the funds collected from drivers with 100% accuracy.
• Liaised with 50 suppliers, and handled varied repayment deadlines prepared daily repayment lists for the Director, ensuring timely payments to different suppliers and preventing any overdue payments that could potentially impact the company's reputation.

Key Achievements/Projects:

• Collaborated with IBM in participating in a big data market analysis initative, ultizing 2 system IBM Big Insight and Congnos. We can conduct the multi-faceted analyses on customer data collected from social platforms like Facebook.
• Branch Rationalization Project
• Developed the Corporate Grouping Indicator. It can provide another angle to explore the business potential.
• Attended the conference with The Shanghai Commercial Saving Bank(Taiwan) and The Bank of Shanghai(China) to share the experience on analysis regularly.

Regular Tasks and Campaigns:

• Liaised with stakeholders to develop data analytics strategy in response to key business objectives.
• Evaluated system linkages and optimised connections to improve compatibility and function.
• Supervised Customer Analytics department operations and team of 3 employees.
• Using the SAS & SQL tools to prepare the Financial reports for:

a.) Chief Executive and Management committee e.g. Counter Traffic Statistics

b.) Corporate Banking Division e.g. Remittance and CHATS report; Corporate Lending report

c.) Wealth Management Division e.g. Commission and Fee income performance by Branch level

d.) Loans & Deposits Department e.g. Transaction Movement Report; Fixed Deposit performance report

e.) Branch Operation Department e.g. Cash Limit Projection;

f.) Digital Banking Department e.g. E-channel penetration report; Fast Payment System (FPS) performance report

port generation to reduce the manual work.

• Co-ordinated and worked with vendor (IBM) to use big data for marketing targeting campaigns.
• Using the SAS & Teradata to performe Pre and Post campaign analysis for campaigns within Card, Consumer Loan and Mortgage Products.
• Conducted with Credit Management Team and Marketing Team to develop the Customer Segmentation based on Customer internal spending behavior and external TU records.
• Prepared the Channel Performance Report for Credit Cards and Consumer Loans.
• Launched the cross-selling card acquisition programs and merchant joint Promotion programs.
• Provided the credit risk reports to Compliance Department and Hong Kong Monetary Authority.
• Prepared MIS reports regarding the business targets and prudential measures on property mortgage loans and exceptional mortgage loan approvals.
• Extracted the customer risk data to credit management team for monitoring and reporting the customer risk rating and prepared the various reports to Account Control team for bankruptcy predication and the Charge-off ratio.
• Liaised with I.T. and business users to support new marketing initiative and enrich the CRM Database Warehouse.

• Operated the card embossing machine DC310, DC9000 and Smart card module
• Arranged and handled the card distribution procedure
• Generated the keys for Smart Card embossing
• Verified the cardholder's signature and issued the PIN as requested by cardholders
• Ensured all plastic cards are in safe custody and production records are properly reconciled