Resume

Sign in

Data Analyst Accounting

Location:
White Plains, New York, United States
Posted:
August 29, 2017

Contact this candidate

LAURENCE H. KLUSKY

White Plains, NY ***** (914) ***-**** ac12dy@r.postjobfree.com

Summary

Experienced Accountant and Data Analyst with both public and private accounting experience.

Excellent analytical skills with advanced expertise in Excel and macro programming.

Experience

Trinity Packaging Corp., Armonk, NY 05/2017 to 06/2017

Robert Half Management Resources – Contract Assignment

Data Analyst – Financial Statement

Data mining and analysis.

Developed Excel templates using Pivot Tables VLOOKUP’s and multiple functions for accounting system conversion, consolidations and reconciliations.

Sun Products Corp., Wilton, CT 10/2016 to 03/2017

Brooke Street Staffing – Contract Assignment

Data Analyst – Demand Forecasting

Data mining and analysis.

Developed Excel templates using Pivot Tables VLOOKUP’s and multiple functions for customer past and future product consolidations and reconciliations.

HAIER, America, New York, NY and Wayne, NJ 09/2011 to 04/2016

Data Analyst – IT Department

Data analysis involving the creation of regional and corporate performance indices.

Commercial Inventory Optimization analysis resulted in savings.

Inventory Optimization for Distribution Center allocation resulted in savings.

Agent Consolidation Report to reduce scheduled pick-ups.

Creation of Excel VBA Macro programmed templates that enabled department personnel to analyze and report department performance and highlight upcoming problem areas in time to correct them.

Preparation of presentation graphics of future projections as well as past performance.

Staff technical and instructional support in Microsoft Excel.

L.G. Electronics USA, Inc., Englewood Cliffs, NJ 07/2005 to 08/2011

Data Analyst – Supply Chain Management and Logistics

Data analysis involving the creation of regional and corporate performance indices. Reliance upon these indices enabled management to save more than 35 million dollars in transportation costs and reduced customer chargebacks.

Commercial Inventory Optimization analysis resulted in savings of approximately 2.5 million dollars.

Inventory Optimization for Distribution Center allocation resulted in savings of approximately 1.5 million dollars.

Agent Consolidation Report to reduce scheduled pick ups resulted in savings of approximately 3 million dollars.

Creation of Excel VBA Macro programmed templates that enabled department personnel to analyze and report logistic department performance and highlight upcoming problem areas in time to correct them.

Preparation of presentation graphics of future projections as well as past performance.

Staff technical and instructional support in Microsoft Excel.

Fuji Film USA, Inc., Tarrytown, NY 01/2001 to 05/2004

Data Analyst & Accountant – Financial Reporting

Data mining and analysis.

Developed macro coding for multiple film processing labs for account consolidations and reconciliations.

Paul H. Lenok, CPA, Scarsdale, NY 03/1989 to 12/2007

Senior Accountant

Prepared corporate, partnership and individual tax returns.

Full support of business clients through use of Quick Books, Peachtree Accounting and Sage Business software packages.

IT Support for office network and clients.

Education

Lehman College, Bronx, NY

Bachelor of Science

Major Course of Study - Accounting

Proficiency

Excel, Word, QuickBooks, Peachtree Accounting

References available upon request

Earlier Experience Available Upon Request



Contact this candidate