ALBERT LIU
Philadelphia
Summary
Detail-oriented and analytical accounting professional aiming to apply a strong foundation in financial management and advanced data analytics to deliver actionable business insights and streamline processes through automation.
Overview
7
7
years of professional experience
Work History
Senior Accountant
Language Services Associates Inc.
Horsham
05.2024 - Current
- Ensure integrity of accounting information by completing monthly accounting close procedures and related deliverables (maintaining general ledger, preparing journal entries, account reconciliations, reports and variance analyses) in accordance with GAAP
- Collaborate with the assistant controller to prepare and distribute monthly financial statements, management reporting packages, departmental spending reports and quarterly financials for bank compliance
- Support the company treasury operations by monitoring daily cash activity and preparing bank reconciliations
- Oversee the recording of monthly company credit card expenses ensuring the consistency of coding to the annual budget
- Assist with preparation and monitoring of the annual budget and periodic forecast updates, including monthly reporting and analysis of actual expenses versus budget / forecast
- Prepare analyses and reconciliations to support the external financial audit and tax return preparation. Assist with various regulatory lings and tax compliance work
- Participate in various department and/or company-wide initiatives and special projects.
Senior Staff Accountant
Forman Mills
Pennsauken
11.2018 - 03.2024
- Monthly reconciliation of all cash accounts and credit card account
- Monthly General Ledger account reconciliation including prepaids, receivables, fixed assets, liabilities and accruals
- Preparing and posting of journal entries
- Prepare and file monthly sale taxes for nine different states.
- Handle analysis on bi-weekly payroll & 401k invoices.
- Work directly with the CFO on daily cash flow, assist in preparing financial statements, and create store budgets
- Assist in preparing documentation for external auditors
Education
Master of Science - Accounting
Binghamton University
Vestal, NY01.2011
Bachelor of Science - Accounting
Binghamton University
Vestal, NY01.2010
Skills
- Proficient in accounting practices, including financial statement reporting, budgeting and forecasting, business analysis, and a solid understanding of Generally Accepted Accounting Principles (GAAP)
- Proficient in Office 365 with advanced expertise in Excel/PowerQuery, including pivot tables, lookups, complex formulas, and data visualization
- Skilled in leveraging Python in Excel, and VBA to automate workflows and routine reports
- Experienced in building data infrastructure and utilizing tools such as SQL, Power BI, and Python for efficient ETL processes and insightful, decision-driving visualizations
Certifications Courses
- Certification - Google Data Analytics
- Data Analysis and Visualization with Power BI
- Certification - IBM SQL: A Practical Introduction for Querying Databases
- Certification - IBM Python for Data Science, AI & Development
Timeline
Senior Accountant
Language Services Associates Inc.
05.2024 - Current
Senior Staff Accountant
Forman Mills
11.2018 - 03.2024
Master of Science - Accounting
Binghamton University
Bachelor of Science - Accounting
Binghamton University
Similar Profiles
CHANDANA DASCHANDANA DAS
Freelance Interpreter at Language Services Associates Inc.Freelance Interpreter at Language Services Associates Inc.
MARIA CAROLINA VIDAL ROVIRAMARIA CAROLINA VIDAL ROVIRA
Spanish Interpreter at Language Services Associates Inc.Spanish Interpreter at Language Services Associates Inc.
Mondy CatonMondy Caton
Over the Phone Interpreter at Language Services Associates Inc.Over the Phone Interpreter at Language Services Associates Inc.
KRYSTAL COSBYKRYSTAL COSBY
Housekeeper at Made 2 Shine Cleaning ServicesHousekeeper at Made 2 Shine Cleaning Services
Odile RodriguezOdile Rodriguez
Integrated Care Coordinator – Psychiatry & MAT at Nueva Vida Behavioral Center - Casa De Consejeria Y Salud IntegralIntegrated Care Coordinator – Psychiatry & MAT at Nueva Vida Behavioral Center - Casa De Consejeria Y Salud Integral