Crystal Reports 10 Consultant Available for consulting work
Eric Israel
Crystal thru version 10.
ERIC ISRAEL
480-451-9355
SR. SOFTWARE ENGINEER
A seasoned VB developer and consultant that specializes in complex
enhancements, interfaces, and rewrites of application systems.
Skill Name Skill Level Last Used Experience
Visual Basic(4.0-6.0) Expert Currently Used 8 Years
SQLServer (6,6.5,7,2000) Expert Currently Used 9 Years
Oracle(8i,9i) Intermediate Dec 2003 1.5 Years
Crystal Reports(4.5-10) Expert Currently Used 9 Years
ASP/VBScript/JavaScript Intermediate Currently Used 3 Years
APS.NET/VB.NET/C# Intermediate Currently Used 1.5 Years
ACCESS(2-2003) Expert Currently Used 8 Years
ODBC/OLEDB Expert Currently Used 8 Years
Windows(95-XP) Expert Currently Used 8 Years
Windows 2000 Server Expert Currently used 4 Years
PROJECT SOFTWARE ENGINEERING HISTORY
Wells Fargo, Tempe, AZ 1/1/2004 – Present
· Complete Business Loan Application Reporting System
· Designed the Tables, Relations, Indexes, Metrics database, Stored
Procedures, Views, DTS Packages using SQL Server 2000.
· Wrote the ASP.NET pages and VB.NET code for the front end.
· Developed all the reports (25 of them) in Crystal Reports 10
· Documented all of the system level documentation.
· Performed extensive testing on the Report Metric Calculations
Honeywell, Phoenix AZ 10/01/2003-12/31/2003
· Developed Business Reports for Airplane tracking system.
· Designed the Stored Procedures, Views, User Defined Functions, using
Oracle 8i & 9i.
· Developed all the reports (15 of them) in Crystal Reports 9.
· Performed all of the report level documentation.
Progressive Computer Services Inc., Scottsdale AZ 02/2002 – 09/2003
· Developed Report Extract System for a large Mortgage Company in
Phoenix, in which 200 reports were run daily from.
· Wrote many Visual Basic 6, ASP, ASP.NET, VB.NET interface programs
that extracted data from the main Mortgage Software (Interact from
Alltel).
· Wrote over 150 reports in Crystal Reports 8.5.
· Wrote over 50 SQL Server Stored Procedures and Views.
· Performed all testing and system documentation on my projects.
ABS School Services, Phoenix AZ 08/2001 – 02/2002
· Developed Access 2000 front-end, this application was for users to
print accounting reports in a fund accounting charter schools system.
· System consisted of Access 2000, Crystal Reports 8.5, SQL Server 7
Stored Procedures Called from ACCESS.
· Developed Inventory Management System.
· System consisted of VB6, Crystal Reports 8.5 using Access 2000
Back-End.
· Performed all testing and system documentation on my projects.
Acres Gaming, 01/2001 – 08/2001
· Developed complete Reporting System for Casino Floor Accounting
System.
· System consisted of Crystal Reports 8.5, SQL Server 7 Stored
Procedures, views, DTS Packages.
· The Reports were designed to monitor Game coin inflow and outgo.
· All Crystal Reports were scheduled with Crystal INFO.
· Performed all testing and system documentation on my projects.
Mayo Clinic, Scottsdale AZ, 05/2000 – 01/2001
· Developed Reports for Patient Financial System.
· System consisted of Crystal Reports 7, SQL Server 7 Stored
Procedures, views, DTS Packages.
· The Reports were Patient Billing Tracking Reports.
· Mentored Mayo Business Analysts on Crystal Reports 7.
· All Crystal Reports were scheduled with Crystal INFO.
· Performed all testing and system documentation on my projects.
Younger Direct, Scottsdale AZ, Part-time 08/2000 – 11/2001
· Developed Reports front-end to allow users to run reports on the
internet.
· System consisted of VB6, ASP, Crystal Reports 7 and Oracle 8i.
· I wrote queries, stored procedures and accessed Oracle from VB
utilizing ODBC.
· Performed all testing and system documentation on my projects.
JTA Solutions, Scottsdale AZ, 01/2000 – 05/2000
· Installed, configured and supported SQL Server 7 Back-End database
for Goldmine Software.
· There were six client installs in all, total with a minimum of ten
users per install and one client system with twenty.
· Performed all testing and system documentation on my projects.
Production Packaging, Phoenix AZ, Part-time 01/1997 – 05/2000
· Developed a system for a restaurant equipment company to handle all
invoicing, inventory, quoting and reporting
· System consisted of VB6, ASP, Crystal Reports 8 and Access 97/2000.
· Performed all testing and system documentation on my projects.
Temcon Concrete, Phoenix AZ, Part-time 06/1998 – 04/1999
· Developed a system that handled the company's paper flow from
proposal to contract to job order, including special features to
automatically insert industry specific descriptions, pricing etc.
· System consisted of VB5, SQL Server 6.5, Crystal Reports 7.
· The System has since been rewritten in VB6, SQL Server 2000, Crystal
Reports 9.
· Performed all testing and system documentation on my projects.
Paradise Valley School District, Phoenix AZ, 07/1998 – 05/2000
· Developed specialty programs that their canned software Sasixp did
not cover.
· Programs consisted of VB6, Access 97, Crystal Reports 7 using ODBC.
· Performed all testing and system documentation on my projects.
Mobility Electronics, Phoenix AZ, 11/1997 – 06/1998
· Developed accounting and inventory reports for all departments using
Crystal Reports 6.
· Mentored 25 staff members on Crystal Reports 6.
· Performed all testing and system documentation on my projects.
American Express, Phoenix AZ, 05/1996 – 01/1997
· Developed 3 financial applications, including one multi-lingual
application.
· Systems consisted of VB4, SQL Server6/6.5, and Crystal Reports 5
using ODBC.
· I did all testing and system documentation on my projects.
BSI Blood Systems, Phoenix AZ, 10/1995 – 04/1996
· Developed federal medical and financial applications for this
Scottsdale blood bank.
· All systems had to pass strict FDA guidelines.
· Programs consisted of Access, VB4, Clipper, dbase.
· I did all testing and system documentation on my projects.
Independent Consultant, Scottsdale AZ, 11/1993 – 10/1995
· Multiple Client Systems.
· Systems consisted of Access, Clipper, dbase.
· Performed all testing and system documentation on my projects.
Managed Care Software, Scottsdale AZ, 06/1991 – 11/1993
· Lead Programmer on a major revision of existing managed care
software package sold nationwide.
· Responsible for customer support via telephone for many of the
software users.
· Systems consisted of Clipper, dbase.
· Performed all testing and system documentation on my projects.
Paquin Associates, Scottsdale AZ, 05/1990 – 06/1991
· Lead Programmer and backup tech support person for an insurance
package sold nationwide written in Clipper.
· Wrote custom software additions to SBT Accounting software for
company clients.
· Systems consisted of Clipper, dbase.
· Performed all testing and system documentation on my projects.
Hansen Associates, Scottsdale AZ, 09/1989 – 05/1990
· Wrote custom Clipper applications to interface with CYMA accounting
software.
· Did extensive custom support for existing client base.
· Systems consisted of Clipper, dbase.
· I did all testing and system documentation on my projects.
Independent Consultant, Scottsdale AZ, 02/1986 – 09/1989
· Wrote custom applications for clients.
· Projects included a court reporting system written in Clipper and
miscellaneous applications written in dBase dialects
· Did extensive custom support for existing client base.
· Systems consisted of Clipper, dBase III+, dBase IV, and FoxBASE.
· Performed all testing and system documentation on my projects.
Phoenix Union High School District, Phoenix AZ, 06/1982 – 02/1986
· Systems Analyst/Programmer Analyst - responsibilities were as
follows:
· Wrotereal-time update attendance and registration systems for the
13 schools (99 users). Previously the system required 4
people per school 8 hours a day to manage.
· Results after rewrite, it took only 2 people 4 hours per day to
manage, saving each school the equivalent of 1.5 people.
· Wrote the class scheduling system. All systems were written in DEC
VAX BASIXC on 2 Vax 11/780's.
· Wrote system functions that accelerated the other programmers
development cycles.
· Trained staff programmers in VAX BASIC.
· Systems consisted of VAX VMS 11/780 using VAX Basic.
· Performed all testing and system documentation on my projects.
.
Microware Business Systems, Phoenix AZ, 01/1981 – 06/1982
· Developed Software for a PC-based vertical-market accounting
software package.
· Systems consisted of Cromemco Basic.
· Performed all testing and system documentation on my projects.
EDUCATION/ACCREDITATION
AA-Business Data Processing, Scottsdale Community College 1980