Summary
Overview
Work History
Education
Skills
Certification
University Projects
Timeline
Generic

Ahmed Javaid

Summary

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.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Financial Accountant

London Drug
07.2021 - Current

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.

Data Analyst

London Drug
03.2021 - 07.2021

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.


Education

BBA - Accounting

Kwantlen Polytechnic University
Richmond, BC
01.2021

Skills

  • Phyton Java and C
  • Databases(SQL ,My SQL)
  • Database Maintenance
  • Compliance Software
  • Oracle Financials
  • Variance Analysis
  • Tax Accounting Specialization
  • Internal Auditing
  • Corporate Tax Filings
  • Accounting Management Assessment
  • Financial Projections

Certification

Certificate Of AutoCAD

University Projects

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

Timeline

Financial Accountant

London Drug
07.2021 - Current

Data Analyst

London Drug
03.2021 - 07.2021

BBA - Accounting

Kwantlen Polytechnic University
Ahmed Javaid