Data Analyst Resume

Objective

Seeking a challenging position as Report Data Analyst /Accounting Clerk with the ability to utilize computer, organizational, analytical, and report writing skills using Crystal Report, JD Edwards, A/S400, ACCESS, EXCEL, Word and Computerized Accounting Systems (A/P, A/R)

WORK EXPERIENCE

01/2007- 12/2008

2005- 2006,2003-2005

Confidential,Employee Survey Consulting company Cherry Hill, NJ
Data Analyst

Responsible for generation of existing Detail and Summary Survey Statistical analysis data reports for Employee Survey Consulting company.
Gathered, validated and manipulated data in Excel, performed spreadsheet calculations using formula, pivot table. Run existing reports based on user’s criteria.
Exported data from Microsoft ACCESS to Microsoft EXCEL and formatted reports.
Developed and maintained ad-hoc reports, data extract, queries, forms, tables and macros in Microsoft Access to validate and clean up Employee survey results data files.
Performed Data entry of Customer information into Access Database for Employee Survey based on demographic criteria: Employee’s title, region, ethnicity and gender.
Created Graphs and Charts for Survey Analysis Worksheet.
Used Query Analyzer to query data in SQL.
Using Crystal report generated Summary report by Region.
Accounting: A/P matching and batching invoices entering information into JD Edwards .
Prepared Purchase Orders and created a new items for Retail operations.

Confidential, NJ
Report Analyst

Responsible for Inventory Control Database maintenance for large Furniture Rental Company using Macola ERP System for 9 different state locations.
Prepared Weekly/Monthly Inventory Summary Reports using EXCEL for Rent, Retail and Warehouse locations to support Management team. Collected, validated and manipulated data, performed spreadsheet calculations.
Using Crystal Report created: Weekly report that tracks Inventory by Location;
List of items with no activity; Summary by Products; Weekly activity report.
Extracted data from Macola using comma delimited format and imported it into Excel.
Maintained Cycle Count Report using ACCESS database and generated weekly reports.
Gathered invoice information from General Ledger Trial Balance Report to prepare a FIXED ASSET BOOK. Sorted, matched invoices and entered it into the system. Prepared Monthly Bank Reconciliation using Macola A/P system and Bank statements for CFO of the company. Year End A/R bad debts write-off.
Created Graphs and Charts to show Inventory performance by locations.

Confidential, Pennsauken, NJ

QC Data Analyst / Document Control Coordinator
Responsible for maintaining and coordinating the company’s document control database Maintained Master document binder and Master document files,SOP and Documentation
Prepared Quality Weekly Minutes Repots to support Management team.
Performed Data entry of Customer Complaints information into ACCESS Database for Quality Assurance Department Management team. Used Pivot Table to sort and filter data
Prepared EXCEL spreadsheet for Non-Conforming Material Disposition. Gathered data, performed spreadsheet calculation, create a PowerPoint presentation, graphs and charts.

INFORMATION TECHNOLOGY CONSULTING EXPERIENCE SUMMARY

1994-2002

Confidential,Voorhees, NJ
Computer Consulting job for a various companies:
Computer Programmer/Consultant

Confidential, -AS/400 Programmer Voorhees, NJ
( Utility Company )
Confidential,-AS/400 ProgrammerPhiladelphia, PA
( Real Estate Management Company )
Confidential, -AS/400 ProgrammerVoorhees, NJ
( Insurance Company )
Confidential, - AS/400 Programmer Deptford, NJ ( Precious Metal Refinery )

Education

Business Administration Specialist

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship