Core Duties Resume Profile

Work History

Confidential

Key Skills

Strong Excel skills, including advanced formula generation, graph generation, and data referencing.
Strong Access skills, including the ability to link tables by means of a common key, the generation of calculated fields, and the generation of customized queries and reports.
The ability to port data between Access and Excel applications, as well as to acquire data from non-standard formats.
Familiarity with accounting vocabulary and the structure of financial statements.
Familiarity with basic statistical concepts and the ability to implement them using Excel and/or Access.
Ability to quickly design and execute wide variety of ad hoc reports.
Experience with a range of other software products and tools, including VBA, Crystal Reports, the C programming language, Linux/Unix, SQL Server and MySQL.

Achievements

Became aware of a consistent data transposition error in the incoming 990 data, identified the records within our system affected by the error and devised an SQL-based fix.
Worked on CRM program iMIS adding EIN Employer ID number field and NTEE Code an IRS code denoting programmatic focus of nonprofits fields to the record structure, enabling the program to talk to other databases.
Created Google-style maps to illustrate the geographic distribution of nonprofits, with icons keyed to agency traits e.g. programmatic focus, budget size of the mapped agencies.
Using VBA programming language, created program to conveniently select records from Access database.

Confidential

Core Duties

Estimation of the costs related to the European purchase, importation and domestic processing of the company's full product line as well as customized quotations for the company's institutional customers.
Inventory Control including the maintenance of accurate records of inventory levels and unit FIFO valuation
Information Services including:
the generation of ad hoc reports on a daily basis using Crystal Reports
the conception and execution of operational efficiencies, e.g.:
a computer program drawing order data from our accounting system and porting it to what became our production program
a Reorder Advice Report , which pulled together, for the first time, information on sales and inventory levels of the entire line of furniture models
A computer programming to aid in the reconciliation of the results of physical counts of inventory items with the computerized counts of those items, including dollarization of the variances