Sean Tan, MSA
Staff Accountant-GL Controll Group at Atlantic Broadband- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Atlantic Broadband
-
United States
-
Telecommunications
-
300 - 400 Employee
-
Staff Accountant-GL Controll Group
-
Apr 2021 - Present
-
-
-
RLA Insurance Intermediaries, LLC
-
United States
-
Insurance
-
1 - 100 Employee
-
Senior Accountant
-
Mar 2016 - Mar 2021
• Reconciled and month-end closing cash flow activity in General Ledger system against bank statement monthly• Provided brokers production analysis report and directly presented to CFO.• General Ledger management for A/P, A/R, and payroll.• Trained and supervised new A/R specialist and A/P specialist.• Coordinated with branch staff and managers to ensure proper A/P and A/R processing and approvals on client invoices• Prepared and process journal entries in the Brokerage Management systems and General Ledger systems • Prepared analysis of aged open receivables and payable on a weekly basis• Reconciled payment receipts against client A/R statements• Maintained existing clients/ carriers database for correct information• Provided direct support to the Accounts Payable Supervisor as require• Business tax filing for MA, FL, TN, SD, and WY• License maintain for organization and brokers for over 50+ states • Analyze, research and resolve complex problems
-
-
-
-
SQL Data Analyst Project and Training
-
May 2017 - Jul 2017
• Wrote complex SQL queries using joins, grouping, aggregation, nested subqueries, cursors, etc• Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts• Imported, exported, and manipulated large data sets in multi-million-row databases under tight deadlines • Wrote complex SQL queries using joins, grouping, aggregation, nested subqueries, cursors, etc• Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts• Imported, exported, and manipulated large data sets in multi-million-row databases under tight deadlines
-
-
-
-
Billing Manager
-
Jun 2014 - Sep 2015
• Ensured of approximately 90 providers’ book notes and accounting information prepare purpose for 2014 Auditing• Claimed providers and coordinator’s services through insurance companies and New York State Health CommerceSystem• Processed over 100 employees and contractors payroll semimonthly • Ensured of approximately 90 providers’ book notes and accounting information prepare purpose for 2014 Auditing• Claimed providers and coordinator’s services through insurance companies and New York State Health CommerceSystem• Processed over 100 employees and contractors payroll semimonthly
-
-
-
Internal Revenue Service
-
United States
-
Government Administration
-
700 & Above Employee
-
Tax Preparer
-
Jan 2014 - Apr 2014
• Assisted approximately 10 clients daily including low income U.S Citizens, foreign students, and military sources by collecting and preparing all documents needed for a successful tax return• Provided customer service to all by explaining the process, documents needed and next steps for all procedures • Assisted approximately 10 clients daily including low income U.S Citizens, foreign students, and military sources by collecting and preparing all documents needed for a successful tax return• Provided customer service to all by explaining the process, documents needed and next steps for all procedures
-
-
-
Southern New Hampshire University
-
United States
-
Higher Education
-
700 & Above Employee
-
Tax Preparer
-
Dec 2012 - Apr 2013
Assisted clients daily of low income U.S Citizens, foreign students, and military sources by collecting and preparing all documents needed for a successful tax returnProvided Customer service to all by explaining the process, documents needed and next steps for all procedures Assisted clients daily of low income U.S Citizens, foreign students, and military sources by collecting and preparing all documents needed for a successful tax returnProvided Customer service to all by explaining the process, documents needed and next steps for all procedures
-
-
Education
-
St. John's University
Master of Science (MS) Accounting, 3.3 GPA with Ethical Leadership Certificate -
Southern New Hampshire University
Bachelor of Business Administration (BBA), 3.6 GPA with Dean's List