. Built customized applications using VBA to automate account reconciliation processes.. Performed payroll data, credit card data cleaning and validation using SQL and Python.. Automated membership payment entry process. Reduced days’ work to minutes’ work.. Prepared quarterly budget reports and profit and loss reports.. Verified and approved monthly payroll reconciliation.. Led annual audit preparation.. Managed fixed assets depreciation and accounts receivable schedules.

. Built customized VBA programs to automate payroll process, bank reconciliation, and reclassification journal entry process. Reduced processing time by at least 200%.. Cleaned and validated payroll timecard data using SQL and Python.. Provided pivotal assistance in annual audit preparation.. Revised and implemented needed internal controls.. Conducted thorough overhaul of general ledger accounts, bank reconciliation, and monthly closings.. Completed and filed annual 990 report for the organization.

· Conducted month profit and loss analysis.· Processed payroll and verify payroll data using MySQL and Excel.· Created grant budgets, produced monthly financial reports.· Managed fixed assets, accrued expenses, and deferred revenue schedules.· Filed and distributed 1099 forms.· Led and collaborated with finance staff in annual audit preparation.

· Processed invoices and payments.· Conducted financial research and analysis for marketing department.· Constructed complex online payment data analysis and reconciled payments using SQL and Excel.· Reconciled accounts in the general ledger.· Filed annual 990 report and 1099 forms in a timely manner.

· Processed payroll.· Performed monthly and annual module closings.· Reconciled general ledger accounts.· Managed fixed assets amortization schedule and investment account.· Assisted in annual audit preparation.· Supervised a junior staff accountant and an intern.