Bank One, Retail Lending, Indianapolis, IN
January 1998 - January 2005
•Support the incentive data retrieval/data integrity process. Merge data from several different platforms to create a single data source to ensure consistent use of data for all reporting. Process includes use of SAS/ACCESS to attach to Oracle tables.
•Maintain the SAS infrastructure. Automated batch jobs to dynamically read a windows directory. Involved in building a data mart used to store history to allow for management level reporting. Maintain SAS autoexec to ensure consistent use of LIBNAMES and PROC FORMATS by all team programmers.
•Deliver automated web based incentive and management level reporting with drill through capabilities. Converted manual email report process to a secure web based process.
•Program incentive plans and management level reports for both mortgage and consumer lending based plans.
•Participate on Incentive Design Team as Programming Subject Matter Expert.
Tranter Industries, Inc., Franklin, IN
March 1993 - January 1998
•Converted company financial information from outdated Unisys system to QuickBooks Pro format.
•Prepared company weekly payroll and filed appropriate federal and state payroll tax documents.
•Performed all data entry, accounts payable and accounts receivable functions.
National Bank of Greenwood
March 1983 - January 1993
•Assisted Controller in daily functions of General Ledger balancing and daily Federal Funds transfers.
•Reconciled Due from Bank statements. Researched and resolved outstanding items.
•Audited Commercial loan files to ensure proper documentation.