Kaman Li Email & Phone Number

• Facilitation of commercial settlement via SWIFT, EFT, and Interac
• Payment of vendors from company accounts via SWIFT
• Maintaining up to date transaction records and reconciling across multiple interfaces
• Providing merchant and other operational support as required
• Maintaining relationships with Finance staff at banks and clients

Calgary, Canada Area

• Design, develop and implement strategies to mitigate and remediate data quality, performance and data integrity issues.
• Experience with SQL Server, SQL Server Integration Services (SSIS), SQL database queries (T-SQL), stored procedures, functions.
• Familiar with ETL and Cognos Reporting Tool.
• Experience with JIRA, GIT, SVN, SFTP
• Develop and maintian inactivity fees stored procedure automation

Calgary, Canada Area

• Delivered and prioritized analytic & reporting requests (ad-hoc & regular) to the business globally supporting business decisions, operational process and provided business recommendations to senior management with.
• Supported project to build auto reconciliation system in Oracle EBS
• Respectfully managed minimized escalations with stakeholders including senior management
• Worked closely with the Data Management Development Teams to determine and resolve reporting / data issues.
• Participated in building strategy and vision for the future of reporting within the organization internationally
• Designed JIRA workflows across BI teams internally across North America and Europe to facilitate an efficient and agreeable workflow for all teams.

Calgary

• Developed and implemented e-commerce transactional reconciliation procedures using MS Excel and MS Access for all new products in the system. Included: debit cards, credit cards, Astropay, Bitcoin, bank deposits.
• Established financial criteria on upcoming product releases with Product Managers, BI Analyst, IT Developers and Risk Managers to capture all Finance requirements
• Managed a team of 5 employee to deliver accurate and timely daily reconciliations
• Authorised and approved outgoing bank transfers and wire payments up to $3M USD
• Developed and implemented e-commerce transactional reconciliation procedures using MS Excel and MS Access for all new products in the system

Calgary, Canada Area

• Updated senior management with team’s monthly progress on product performance, cost, and revenues. Highlighted products with underperforming IT system workflows to senior management to increase positive customer user.
• Redesigned & implemented new reconciliation system for Cambridge office improving efficiency and accuracy on receivables
• Completed Accounting month-end journals via Navision in advance of deadline to minimize errors during limited time constraints
• Final approver for detailed monthly finance reconciliation entries. Identify any errors and provide solutions on discrepancies.
• Managed a team of 5 employee to deliver accurate and timely daily
• Forecasted and prepared funding for bank accounts as required

Calgary, Canada Area

• Presented accurate itemized product performances and forecasts to manger and Controllers.
• Reconciled all incoming / outgoing daily transactions against service providers and ensured all transactions are paid and balanced.
• Collected outstanding balances and adjusted customer’s account
• Managed and coordinated tasks within the team on daily basis
• Guided junior team members

Calgary, Canada Area

• Reconciled daily incoming and outgoing transactions against bank statements / 3rd party processor efficiently and accurately to using Excel and Access to ensure all transactions are accurately settled.
• Daily reconciliation and balancing includes service providers such as cheques, debit cards, credit cards, bank deposits, EFT, bank wires,
• Resolved internal customer account variance with investigations and adjustments
• Assisted and supported team lead to met month-end deadlines

Calgary, Canada Area

• Managed accounts and resolved funds disputes for global customers while retaining loyal customers, collecting debt and preventing escalations
• Coached customers on troubleshooting account setup, deposit, transfer & withdrawal of funds
• Assisted Risk Dept to perform customer risk related assessment when required

Calgary, Canada Area

Coped with fast paced environment, encoded and balanced average 3200 cheques / Utility bills per hour with precise accuracy and efficiency

Certification In Business Intelligence, Business Intelligence

Bachelor'S Degree, Economics