David Yu Email & Phone Number

Canada

Toronto, Canada Area

• IFRS 17 - Data Asset
• Assessed source data from Actuarial & Risk, Finance, Policy, and Billing systems. Developed data mapping sheets between IFRS 17 inbound data model to a CSM vendor solution. Narrowed down over 3000 attributes across 500.
• Led workshops with client’s finance and IT teams to gather requirements for new changes. Designed and documented mapping updates for the data layer. Coordinated efforts with vendor resources to ensure data layer.
• Led the test execution activities related to Aptitude’s Revenue Recognition Engine (RRE) for IFRS 15 standards. This included the coordination of efforts between both offshore and onsite teams – running batches against.
• Designed and refined the test case templates used by the team for RRE testing. Created test cases in ALM and tested against them according to priority. Combining both technical and functional knowledge to develop SQL.
• Worked closely with the business team to reconcile daily and monthly loads. Working experience with the ARRE product, such as the DSRs, contract and contract product part objects, product catalogue, profile map, and.

Toronto, Canada Area

• Public Sector - Data Migration
• Governed overall requirements process, requirements gathering, and documentation. Communicating new business and technical requirements inwardly to the data migration team. Analysis of new requirements to plan build.
• Led Remediation & Mitigation work stream for Agencies and studied the legacy data, technical and business issues. Identified the root cause and developed solution from technical standpoint while engaging business and.
• Assisted with QA – writing SQL scripts to find the root cause of data errors. Responsible for collaborating with team members and clients and managing the remediation process. Documented and verified defects and fixes.
• Conducted the end-to-end data migration of legacy procurement data into Coupa. Migrating requisitions, purchase orders, invoices, and receipt data. Led the overall data conversion activities including gathering.

Toronto, Canada Area

Richmond Hill, Ontario

• Designed a national sales dashboard used by executives; summarizing key sales information with graphs and charts connected to live SQL server database and integrated into SharePoint
• Developed VBA macros across several departments to automate repetitive tasks with increased speed and accuracy
• Provided support with data migration of multiple databases into a centralized location

Richmond Hill, Ontario

• Analyzed customer database for marketing objectives such as finding cross selling opportunities; communicating potential opportunities to marketing coordinators to advance marketing objectives
• Compiled contact lists from Microsoft CRM database and various data sources for marketing initiatives
• Performed data de-duplication techniques for contact lists. Communicated between finance and marketing to determine the parameters for accurate data extractions

Bachelor Of Arts In Honours, Economics And Accounting

Graduate Certificate, Marketing Management, Marketing

•President's Honour List •Customer Relationship Management, Strategic Marketing Management, Interactive B2B Selling, Marketing Research.