Robert E. Motza

*** ***** *** ******

Farmersville, Ohio 45325

Phone: 937-***-**** e-mail: acr7v4@r.postjobfree.com

CAREER OBJECTIVE

As a Financial Data and Portfolio Analyst with more than fifteen years’ experience, I am seeking a position that will both challenge and expand my existing analytic and mathematic proficiencies. WORK EXPERIENCE

PNC Financial Services (Formerly National City Bank) January 2006 - Present 3232 Newmark Drive, Miamisburg, Ohio 45342 Financial Analyst Duties:

Access – Created and maintain databases for provision of regular reporting to the Wholesale Operations, Asset Quality, Collateral Management and Asset Resolution departments

VBA – Augment functionality of Access forms

Excel – Produce automated formatting and supporting database documentation for quarterly and ad hoc reporting

SAS – Implement and maintain code for the production and improvement of quarterly reporting; access enterprise- wide data sources via ODBC

SQL – Write, modify and execute statements for daily reporting efforts

Tableau – Used infrequently to create management reporting upon request

Leadership – Led management calls and web presentations; conducted an Excel class and provided training to analysts on an as-needed basis; developed written procedures for previously undocumented reporting processes Awards:

Excel Award – received for assuming responsibilities outside of my department

Champion Award – from the Collateral Management department for exceptional report design and implementation

Numerous Spotlight Awards – received from various management teams for exceptional performance Union City Body Company August 2005 – November 2005 301 South Jackson Pike, Union City, Indiana 47390 Production Scheduler, Contractor Duties:

Access – Designed and implemented a database to track sales quotes and order information

VBA – Automated tasks and improved Access form functionality

Excel – Provided inventory and sales reporting for the Sales and Finance departments

AS400 – Entered and updated daily order information NASCO Services (Formally Huffy Service First) September 1999 – June 2005 3100 Research Boulevard, Kettering, Ohio 45420 Systems Coordinator II Duties:

Access – Designed and implemented a database to track payroll issues

VBA – Customized Access forms and automated tasks

Excel – Parsed, formatted, and manipulated data downloaded from various sources to create reports for Sales and Operations departments

Data Collection Application – Maintained and updated Project Management tracking tools to include retailer-specific promotional information as well as new and existing employee schedule planning

VRU – Implemented and maintained system functionality for daily employee reporting requirements Awards:

Flexibility Award – received for providing field personnel with impromptu reporting EDUCATION

Sinclair Community College

444 West Third Street, Dayton, Ohio 45402

Associates’ Degree – Applied Sciences with Emphasis in Software Development – June 1994 o Courses of Note: Java, C++, Visual Basic 6, Oracle SQL/PL, Database Management, Computer Systems Analysis, Software Systems Troubleshooting and Object Oriented Design

Associates’ Degree – Liberal Arts and Sciences with Emphasis in Mathematics – June 2003