Project Manager Data

Richard G. Rawling

*** ******** *****, *******, ** 18966

Home: 215-***-****; Cell: 267-***-****

Email: abltyg@r.postjobfree.com

Technical Expertise: 25 years of application, database and report

design using object oriented technology

Database Environments: Oracle, SQL, Windows NT, Client Server,

Novell, Access

Development Languages: VB.Net, VBA, C/C++, Power Builder, Delphi, HTML,

VBA, OLE

Database Tools: Oracle, SQL Server, ADO, BDE, ODBC, Crystal

Reports, Erwin, Access

Experience

October, 2006 to Present Bank of America/Merrill Lynch,

Hopewell NJ

Data Analyst, Applications Developer - Bank Sales Reporting and Data

Mining

. Designed and developed a reporting system using OLE Automation

Solutions that extract data from SQL Databases and produce Excel

Reports for business management.

. Application produces weekly/monthly report dashboards used by highest

levels of BAC Management.

. Reports that took days to compile using extracts from several sources

and manual manipulation of pivot tables, now take seconds to produce.

. Management Sales Reports include sales trends, business x-rays,

division, region, complex, office and employee level reporting,

opportunity lists and internal performance measures.

. Manage Team of developers to maintain reporting system, including

operations around report maintenance, validation and delivery.

October, 2003 to October, 2006 GMAC Mortgage, Horsham, PA

19044

Data Analyst, Database Modeler, Applications Developer - Operations Risk

Management

. Designed and developed data cleansing applications that enforce data

integrity for import files received from Direct, ditech and Retail

Lending Channels. Developed reports for data errors and exceptions

using Object Oriented Delphi Language.

. Provided applications for end of month, quarter and annual reporting.

. Analyzed Legacy Access Database to provide solutions for orphaned and

invalid data records.

. Developed Visual Basic Application within existing Access Database for

report generation. Reports included on screen monitoring of database

activity in addition to month, quarter and year end reports.

. Developed and supported a Clientele Database Tool for the Voice of the

Customer Department.

. Developed customer survey database application for tracking and

reporting survey information.

. Designed the new database that will be used by the Licensing and

Reporting Department within the Clientele Application.

. Currently developing the Clientele Application Modules that will be

used by the Licensing and Reporting Department.

. Currently developing a one stop shopping application for all reporting

requirements within the Operations Risk Department.

July, 2000 to July, 2003 Advertising Specialty

Institute, Trevose, PA 19053

Database Modeler, Applications Developer

. Converted 150+ Clipper Legacy Applications to Delphi, and C++

. Wrote SQL data input triggers, enforcing Oracle data model integrity

. Develop Crystal Reports for invalid data notification

. Write SQL queries for adhoc reports of Oracle Tables

. Export product data to HTML Tables for review on company intranet

. Build and format data records from a large relational database into

binary files for quick access by HTML applications.

. Develop custom report applications with Crystal Reports, and inline

code.

. Develop applications threading products with associated JPEG Images

. Project Management for teams of five to eight developers

. Write technical documentation for software development team

. Design data model classes for a large Oracle Database

. Data migration from legacy database to new Oracle Database.

. Develop Crystal Reports for statistical and error trapping information

. Develop input and output classes enforcing data model rules

. Develop data validation and correction classes enforcing data model

rules

. Create exception reports where data does conform to the data model

. Review data models for less experienced designers

. Build shared class and function toolbox for use by development team

. Design custom index file format for quick product searches

December, 1996 to July, 2000 Becket & Lee, LLP, Malvern PA

19335

Project Manager / Programmer Analyst

. Convert legacy Clipper Applications to C++ and Visual Basic.

. Developed C++ structures used to transfer multi-formatted bankruptcy

information, to and from all major national banks.

. Write SQL data input triggers, enforcing data model integrity.

. Write SQL statements for data migration from legacy database to new

SQL Database.

. Developed a high speed bankruptcy payment posting system in Visual

Basic, saving the company thousands of man hours per month.

. Write SQL queries for adhoc reports of MS-SQL Tables

. Project Management for team of eight developers

. Write product specifications for software development team

. Technical Support

. Developed a system for importing data from all major national banks.

. Rewrite existing bankruptcy data model for large SQL Database.

. Developed a system of finding account numbers where an exact match did

not exist.

. Develop Crystal Reports for statistics and invalid data notification.

. Write SQL statements to import and export data records.

. Write SQL queries for statistical and error reports.

. Develop validation classes for data migration from legacy data model

into new data model using Erwin.

. Develop import and export classes enforcing data model rules.

. Tracking bankruptcy life cycles, including payment postings.

. Discovery of fraudulent bankruptcy claims.

. Update and validate account information.

. Generation of court documents including proof and transfer of claim.

May, 1980 to December, 1996 Avery Dennison Soabar Systems

Division, Philadelphia, PA 19111

Programmer Analyst / Technical Support Specialist (1986 - 1996)

. Developed product database and applications using C++

. Developed warehouse inventory tracking system using C++

. Design warehouse model and database using Clipper and C++

. Technical support for customers and sales staff

. Training classes for entire line of Avery Dennison software products.

. Project management for teams of six developers

. Technical documentation for development team

. Developed product tracking application for shipments and returns using

C++

. Warehouse item movement including pick, pack and ship functionality

. Organization and control of print queues using Digi Board Technology

. Report generation using in-line coding, and R&R Report Writer

. Drivers for Sato, SPX, and CDX Barcode Printers

Silk Screen Fabricator [non- IT Position] (1980 - 1986)

Education

A.S. in Computer Systems Technology CHI Institute

Coursework in Computer Science LaSalle University

Coursework in Mechanical Engineering Penn State University

Contact this candidate