Diana R Loyer

* ****** ******, ************, ** *7043

717-***-**** absvwk@r.postjobfree.com

Qualifications

. Extensive (15+ years) Access and Excel experience and query

development.

. Self motivated, automate routine reporting to enhance productivity and

maximize accuracy.

. Background in programming, database and project design, specifications,

and test scenarios.

. Well organized and logical approach to problem solving.

. Creative with attention to detail, professional reports and

presentations.

Professional Experience

. Provided financial and statistical analysis to identify areas of

opportunity for high level management.

. Developed Access and Excel tools to analyze large amounts of MIS data

to facilitate productivity and produce automated and accurate reporting

to support high level management processes.

. Developed Profit Analysis tool to drive gross margin and profit

awareness at the Organizational, Customer and Product levels.

Adopted Nationally in Technical Services.

. Developed Employee Headcount tool which tracked actual and funded

headcount for Managed Service accounts and provided a wide

variety of summary reports including Organization Charts and Data

Exception output. Adopted Regionally as a LSS recommendation.

. Developed Managed Service Invoice tool which summarized monthly

account billing at the Product Serial Number level and reduced

stacks of detailed output to a manageable Invoice report. Adopted

Regionally in Sales.

. Analyzed and developed modules for the Administrative and Personnel

System for Kuwait Air Force. Acted as team lead for the system module

development, including coding, testing and internal specifications.

Coordinated and implemented a production migration and final install in

Kuwait. Functioned as DBA interface for the development and maintenance

of the database structure.

. Designed and developed test scenarios for COBOL and ADS/O applications

to be implemented during all levels of testing for the Department of

Labor's Workmen's Compensation project.

Employment

Winrock / SPI - Lancaster, PA

Consultant April 2012 - June 2012

Xerox Corporation - Harrisburg, PA

Contract AA to Financial Analyst November 1992 - January 2012

Martin Marietta Information Systems - Camp Hill, PA

Senior Computer Systems Designer June 1986 - November 1990

Martin Marietta Data Systems - Greenbelt, MD

Business Systems Designer May 1985 - June 1986

Education

Harrisburg Area Community College, Harrisburg, PA Information Technology,

Honor Student (ongoing)

Computer Learning Center, Springfield, VA Programming Diploma, Honor

Graduate

Virginia Polytechnic Institute, Blacksburg, VA BA Art, Minor in

Mathematics

Contact this candidate