Diana R Loyer
* ****** ******, ************, ** *7043
717-***-**** *****@*****.***
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