Financial Staff Accountant with 3 years of Experience in Treasury and Managerial Accounting along with Data Analyzing through SQL, VBL, Complex Power Queries and aggregations. CPA and master's in computer science candidate. Highly Skilled in Excel, People soft, Sage 100 and Sage50.
Provide Expertise in transaction/cashflow details in support of process and profit improvements. Assist business managers to resolve variances, refine forecasts, and identify opportunities for improvement. Handle numerous deadlines, accounting issues, sales tax Compliance and projects while ensuring high quality execution.
Provide Assistance in Financial Review, Analysis and Management for Period End, Quarter End, Mid-Year and year End Reports along with Internal and External Audit. Provide support to controller with annual Budget Process and business Analysis.
Prepare Daily Cash Flow reports, AP/AR reporting, P&L analysis, analysis of monthly fluctuations including foreign currency Conversion along with GST returns with ITC's, PST returns, and FNT Schedules. Reconcile Balance Sheet Accounts with month end to year end Journal Entries.
Track business revenue and expenditures. Apply proper codes to invoices, files, and receipts to keep records organized and easily searchable. Report financial data and update financial records in ledgers and journals. Investigate daily variances and correct errors to resolve discrepancies.
Provided Expertise in Developing and Breakdown of complex models along with normalization and optimization. Automated rebates, donations and coupons reports for all level of management and clients. Experienced in creating dashboards to displays key metrics and reconciled internal and external advertising accounts.
Managed data analytics projects independently with advanced level proficiency in MS Office Suite (Word, Excel, PowerPoint, Visio, Project). Acted as a liaison between the business units, technology teams and support teams. Conducted tests to ensure the reliability, accuracy, and functionality of system.
Analyzed and interpreted Sales, AR/AP trends or patterns in complex data sets. Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations.
Certificate Of AutoCAD
Vancouver Hospital Project:
Designed and implemented a relational database for a hospital to analyze Cancer Patient and their History. Utilized SQL to extract valuable insights and generate reports for doctors' decision-making. B+
Non-for-Profit Project:
Developed a relational database for a Richmond Non for Profit to analyze Pledges vs Actual Donation.
Utilized SQL to extract valuable insights and generate reports for Business decision-making. A