Paras Sawhney

adxlf2@r.postjobfree.com

Morristown NJ 07960

973-***-**** (cell)

EDUCATION

Rutgers University, Rutgers Newark College.

Bachelor of Science degree in Economics.

Cumulative GPA = 3.4/4.0

Phi Theta Kappa Member, inducted in 2003.

APPLICATIONS EXPERIENCE

Expert proficiency in Quickbooks, NetSuite, account reconciliation, bank reconciliations, Google Sheets, MS Office Suite (Access, Excel, PowerPoint), and MS Project. Experience with office administration, customer service, GAAP adherence and compliance, and personnel management.

Technical abilities: Access: Unbound Forms, Tabbed Dialogs, Importing and Exporting Data, interfacing with SQL. Excel: H lookups, V lookups, pivot tables, pivot charts.

WORK EXPERIENCE

10/2022-4/2023 STAFF ACCOUNTANT Abacus Staffing Group Accounts Receivable (consultant)

Responsible for preparing and analyzing facility financial reporting.

Adjustments to A/R accounts.

General ledger analysis and account reconciliations.

Review, investigate, and correct errors and inconsistencies in financial entries.

Review with Global Service Centre to reconcile local books to Netsuite system.

Frequent communication with the Controller and Financial Business Partners, regarding working capital and financial reporting.

Balance Sheet reconciliations performed for monthly closing.

Reconciliation of intercompany transactions.

5/2022-9/2022 STAFF ACCOUNTANT Abacus Staffing Group month-end-close (consultant)

In charge of revenue adjustments and prepaid INS amortization schedule, Month end close process, reconciliation, and research utilizing both Excel and JD Edwards. Utilized sumifs, v-lookups, and advanced use of filters.

Ad hoc reconciliation of spreadsheets for True-up of accounts ie., properties managed by 3rd party vs. total collections to increase the accuracy of reports used in month-end-close.

Research to true-up accounts for month end financial analysis using rent roll, tenant billings, and lease reports.

Variance analysis reporting as part of post close process to analyze month-to-month differences utilizing JD Edwards reports to analyze differences between billings and revenue on an account level.

Depreciation of fixed assets schedule on a monthly basis utilizing SAGE 200 and excel reporting.

9/2020-4/2022 Transcaribe Express Shippers

STAFF ACCOUNTANT AND BOOKKEEPER

Worked closely with CPA to generate a reoccurring forecast, budget, income statement, and full financial report for management review.

In charge of the data migration from Xero to Quickbooks Online.: Balancing of books for 2019 and 2020 as well as the data cleaning and transfer to QBO.

Owned monthly analysis of GL reconciliation, and performed adjustments as needed. Management of month-end-close/ quarter-end-close process and review.

Streamlined preparation and review of the GL through automation, saving 23 hours monthly.

8/2019-8/2020 Thruway Direct, Elizabeth, NJ

FULL CHARGE BOOKKEEPER

Implementation of Netsuite ERP system, integration of eCommerce platform, and EDI functionality. Proficient with scripting (Suitescript) to enhance app synchronization, reporting, and saved searches.

Use of Excel pivot tables/ pivot charts, v-lookups, to build presentations to TD execs which motivated process changes leading to an increase in inventory turnover rate of 8.4%.

Facilitated A/P process which included reviewing, processing (batches) expense & check requests and cutting checks; worked closely with A/P Clerk.

Review of A/R postings/ deposits/ Paypal donations

Reconciled various bank accounts on a monthly basis worked closely with CFO, A/P Clerk, & Office Manager.

Generation of vouchers and posting to A/P as well as validation against receipts.

10/2018-6/2019 Excel Certification Study

EXCEL ESSENTIALS: THE COMPLETE EXCEL SERIES (UDEMY)

Study of simple, AND complex formulas while using some of the Excel’s built-in functions and techniques

Learned how to create a simple data entry screen to auto-populate complex templates, and how to program in VBA from scratch

Power Query its functions and utilization with Excel Spreadsheets

11/2015-6/2018 Jeevy Computers, Basking Ridge, NJ

STAFF ACCOUNTANT

●Handled all aspects of client relations management for billing and financial concerns. Maintained an excel spreadsheet of A/R accounts.

Managed the transfer of data of A/R and A/P accounts from Excel to Quickbooks. Managed and monitored the proper aging of accounts and collection of accounts utilizing Quickbooks.

●Formulated and oversaw the control management protocols and proper recording of receivables in Excel doc: Comparison of bill of lading with product, quality inspection/ diagnostics, recording of shortages and rejection of damaged goods.

●Full Administration Management: the filing of all downstream documents from point of client purchase: purchase order acknowledgement, packing slip, bill of lading and invoice, and pro forma invoice.

2/2015—11/2015 Dish Network. Roseland, NJ

INSIDE SALES ASSOCIATE

●Sales of internet and television accounts. Customer service to assist in handling technical, billing, and application concerns of callers. Accolades for high rate of premium content attachment (upselling) and sales rate within the corporation. Applied general technical knowledge to assist customer at point of sale.

8/2011--1/2015 Technovations Inc. Randolph, NJ

ACCOUNTING CLERK

●Processed inbound and outbound small-yield chemical containers/ packages. Record keeping of inventory in Quickbooks.

●Assisted in business planning by way of Analysis/ charting of client purchases via MS Excel to recognize higher profit margins.

●Made necessary verification of inbound and outbound shipments against documents.

●Calculated prices according to industry specifications, affixed bar codes, prices, and security tags as necessary.

10/2009—7/2011 Atlantic Coast Media Group Jersey City, NJ

SALES SPECIALIST

●Sales of neutriceuticals and cosmeceuticals in a call center environment. Handled customer concerns and queries regarding the use of products. Acquired merit awards based on sales volume, ARPU, and revenue.

Contact this candidate