STEVEN R. GRAVILLA

**** ******** **. 248-***-****

Waterford, Michigan 48329 248-***-****

abg84g@r.postjobfree.com

PROFILE

A solutions oriented Data Analyst with 24 years demonstrated abilities in

computer programming and development expertise with an array of programming

software. Professional with a proven record as a valued contributor to

diverse technology teams, with a history of developing and supporting

successful projects and solutions incorporating a wide range of

applications and technologies. A top team member and Individual producer

skilled in developing exceptional client relationships through attention to

detail, subject matter expertise, personal commitment and technical

knowledge.

Technically savvy and a quick study in emerging technology, able to quickly

assess and utilize the appropriate response to meet the specific needs of

the business requirement at hand. A welcome addition to any team, ready,

willing and able to function in any role necessary to insure project

success and on time project delivery.

TECHNICAL

. SAS 9.1

. Enterprise Guide 4.1

. Crystal Reports (Create and modify reports)

. Data Hygiene / Data Stripping / Data Analysis

. Excel ver 2003/ver 2007 (Pivot tables, Abstract and complex formulas,

Charts)

. Access ver 2003/ver2007 (Create Database, Queries, Forms, Reports)

. Lotus ver. 1-5 and Millennium

. Mozilla Firefox/ Internet Explorer

. Cognos Impromptu

PROFESSIONAL EXPERIENCE

COMERICA BANK, Auburn Hills, Michigan (Displaced Jul 2010) 1986-

2010

Quantitative Solutions - Data Analyst 2005-2010

. Initiated, created and maintained yearly spreadsheets for Mortgage

delinquency. Displaying Overall Outstandings, 30 day, 60 day and 90 day

+ delinquency number and dollars along with percentages

. Created and modified Crystal reports for the Appro Front End Loan

Processing System. Enhancing the reports for managers and supervisors

to have the option of using parameters when running reports. Thus one

report could do five or ten variations due to parameters instead of

creating and updating five to ten separate reports.

. Modified SAS program related to County Tax Project, due to counties

changing their data structure

. Maintained County Tax Project to strip/clean 400,000 records received

per year from counties in Txt, Rtf, Doc, PDF, or other formats, moving

data into like fields for comparison with bank data.

. Updated collector efficiency spreadsheets for collection managers and

supervisors

. Created various forms and spreadsheets to assist collectors, clerical

and managers

. Assisted

other

departments

with

programs in

Excel,

Crystal

Reports,

SAS, and

Access as

needed

STEVEN

R. GRAVILLA

Page 2

Collateral Liquidation - Methods Analyst 1995-2005

. Created

Spreadshee

ts with

prior

three

years

charge

off

activity

by market

and

product

to track

variances

. Developed Approach data base to hold all activity relating to collateral

liquidation accounts to assist in retrieving old data

. Restructured process of tracking and maintaining Mortgage delinquency

data and reports

. Developed program for tracking mortgage accounts for the three aspects of

their timeline - Pre Foreclosure, Post Foreclosure and Owned real Estate

(ORE)

. Created programs for the Bankruptcy department to assist in tracking and

maintaining activities related to bankrupt accounts

. Created spreadsheet program to track collector performance and Profit and

Loss Collector Activity

. Upgraded older Lotus Spreadsheets into Lotus Millennium

. Promoted in 2005

Collateral Liquidation - Charge Offs and Reports Processor 1987-1995

. Processed and balanced 3 million plus charge offs per month (Prin, Int &

Late Chgs). Created reports to break down activity into 23 markets, 18

different products and charge off type.

. Created reports reflecting Collateral Liquidation Auctions. Reporting

current available units to be sold. Auction efficiency showing yearly

activity

. Created reports reflecting rolling 13 month Delinquency broken down by

market, product type. Displaying Overall Outstandings, 30 day, 60 day

and 90 day + delinquency number and dollars along with percentages

. Modified database to incorporate several tasks being performed manually

by other departments - consolidating the processes and saving time by

increasing efficiency

. Created reports reflecting Repossession balances, reserves and losses

broken down by Repo, Statutory, Balance Deficiencies and Misc charge off

type. Further breakdown by product and market.

. Promoted in 1995

Document Input - Lead Worker Data Processing 1986-1987

. Collected Faxed Applications, Prep Apps, Input into front end Loan

System, forwarded to Credit Analyst

. Distributed work to data entry personnel

. Tracked data entry efficiencies

. Created Lotus Programs to store data, replacing typewriter thus

increasing productivity

. Promoted in 1987

EDUCATON

SAS Institute - Southfield, MI - Programmer/Analyst Certification Program

. SAS Programming - Introduction - Basic Concepts

. SAS Programming 1 - Essentials

. SAS Programming 2 - Data Manipulation Techniques

. SAS Enterprise Guide 1 - Querying and Reporting

Oakland Community College - Auburn Hills, MI - Course work

. Pascal

. Cobol

. C++

. Basic Computer Classes

Park College- Kansas City, MO - Course work

Veteran - U.S. Air Force - Sergeant

1977-1983

Contact this candidate