Experience

• 

  W.f. welding & overhead cranes ltd.

  Jul 2012 - Jan 2014

  Design engineer, e.i.t.

  Achievements:• Mastered Excel skills by daily checking more than 600 rows of structural model worksheets with built-in formulas to ensure 100% accuracy to pursue 100% construction site safety. • Maintained 100% accuracy on databases of more than 3000 crane design data.

• 

  Promount consultants ltd.

  Aug 2014 - Feb 2015

  Structural designer

  • Acknowledged clients’ needs, interpreted them into the drafting and structural model to conduct analysis, and provided excellent customer service through construction meetings, phones, and emails.

• 

  Mary help of christians - edmonton

  Aug 2019 - now

  Finance administrator

  Work collaboratively with Finance Committee members, Accounting Clerk, and Office Administrator to timely provide routing accounting tasks, analysis, dashboard, and reports.Key Achievements:1. Generate year-to-date year-on-year comparison chart• Insert Excel formulas into tables to generate a monthly year-to-date year-on-year comparison chart on various contribution revenues for the Senior Management.2. Year-end contribution revenue report• Successfully automate year-end revenue summary sheet by writing Excel VBA codes to extract partial worksheets from more than 52 weekly various contribution revenue workbooks. • Pivot Table, Power Query, or MySQL generate parishioners' tax receipts, including their addresses.3. Fundraising sales net revenue report• Wrote VBA codes under the complex Excel worksheet environment to automatically summarize on-site cash amount collections and improve revenue recording time by 80%.• Provided the Excel data visualization tool for ten years' fundraising sales revenue report and identified the lowest COGS ratio to management for future event performance improvement.• Conducted variance causes in fundraising sales revenue and costs compared to budgeting.4. Weekly contribution revenue report• Improved revenue summary process by 50% by pre-setting up Excel Sumif formulas to sum contribution revenues from different worksheets and trained accounting clerks to use it. Show less