## BIO
Jon Roberts
SUMMARY OF PROFESSIONAL EXPERIENCE
· Over 11 years experience in usage, design, and implementation of relational and client-server database systems
· Extensive experience in various programming languages including C++, MS Visual C++, Delphi, Pascal, Visual Basic, DataFlex, ASP, XML, VBScript, and Visual DataFlex
· Experienced in the following Database Systems: Oracle, DataFlex, Btrieve, MS SQL, and MS Access
· Extensive experience in reports generation using Crystal Reports
· Extensive experience in graphic design using various applications: Adobe Photoshop, Adobe Illustrator, Corel Draw, Bryce, LightWave, and Calgary TrueSpace.
· 11 years experience in maintaining/upgrading computer system hardware
· Wide-ranging experience in the customer relations field
EDUCATION
Miami Dade Community College, A.A. in Computer Science
Microsoft Certified Professional
· Windows NT
· Microsoft IIS 4.0 Server
Pervasive Certifications
· Pervasive SQL 2000 Level 1
· Pervasive SQL 2000 Level 2
Courses Taken:
· Fundamentals of Database Structures -Florida International University
· Migration of Legacy Systems - Data Access Corporation
TECHNICAL EXPERIENCE
Skill Name Skill Level Last Used Experience
Visual Basic Expert Currently Used 7 years
Delphi Expert Currently Used 5 years
Adobe Photoshop Expert Currently Used 5 years
ASP Intermediate Currently Used 2 years
Visual InterDev Intermediate Currently Used 3 years
Visual Dataflex Intermediate Currently Used 4 years
Dataflex Intermediate Currently Used 4 years
HTML Intermediate Currently Used 5 years
Visual C++ Intermediate Currently Used 3 years
PROFESSIONAL EXPERIENCE
Systems Engineer, Vector Solutions Inc., 2/2002 - Present
Responsible for development of custom solutions for use in Florida state agency&'s public Internet and private extranet sites. Assisted in the design and implementation of database structures. Interacted with customers to gather requirements and customers needs for software solutions. Designed and developed custom Crystal Enterprise reports solution. Developed custom tools for deployment and administration functions. Developed custom solutions using APS, CSP (crystal enterprise custom scripting language), Visual Basic 6, JavaScript, VBScript, XML, Crystal Reports, Visual Interdev, and MS SQl Server 2000.
Consultant, First Impression Advertising & Marketing Inc, 10/1999- 12/2001
Responsible for systems integration and management. Maintain company computers. Installation and figuration of software and operating systems. Perform duties as graphic artist for art worked used in production of marketing materials for clients. Graphics work preformed with Adobe Photoshop, Adobe Illustrator, Freehand, LightWave, 3dsMax, Bryce, Corel Draw, and Calgary TrueSpace.
Consultant, Micro Software Systems, 7/2001-10/2001
Development of employee time tracking system using Delphi, MS SQL server, ADO, and RDO. Preformed required updates to preexisting software using Delphi.
Consultant, PMR Technologies, 6/2001
Development of Call center integration system with Visual Basic, MS SQL Server, SQL Script, stored Procedures, and triggers. Planned and implements database table structures Using Ms SQL server. Generated Reports Using Crystal Reports. Generated user Web interface to allow clients to retrieve individual account information via the World Wide Web using ASP, vbScript, Javascript. and Visual Interdev.
Consultant, Assurant Insurance Group, 5/2001
Development of complex Crystal Reports against Oracle database system.
Consultant, Financial Technologies Inc, 1/2001-5/2001
Responsible for enhancement of existing systems using Visual basic, MS SQL Server, SQL scripting, triggers, and store procedure.
Consultant, Kemper National Services, 10/2000-1/2001
Responsible for development of data conversion and validation system from DataFlex to Oracle using Visual Basic, Connx, Oracle, DataFlex, Com, and DCom. Established standards for development in Visual Basic for department. Recommended and established developer library for department. Generated and integrated Crystal reports into system to allow retrieval of formatted report of system statuses and converted batches.
Senior Technical Specialist, Data Access World Wide, 10/1996-10/2000
Responsible for development of relational database reports and user interfaces Provide customer service and support for relational and client-server database systems (DataFlex, Btrieve) Formulated research and development of company&'s main product line (Visual DataFlex) Participated in development of company&'s WebApp Server product line Provide customer service and support for various database reporting software (FlexQL, WinQl, Seagate Crystal Reports (4,4.5,5,6,7,8)) Developed support applications for ERP software system (Visual DataFlex, DataFlex), Development of various systems using Delphi(3,4,5), Visual Basic(4,5,6), and DataFlex (2.6/3.0/3.05/3.1/3.2).
Senior Developer, J&M Computer Consulting, 5/1994-10/1996
Responsible for Project Management Visual C++, Visual Basic (3), Delphi (2), Relational Databases, HTML, ASP, VBScript, XML, Java, and CSS Managed customer relations department generated and implemented custom software training courses
Aircraft Mechanic/Crew Chief, United States Army, 9/1989-5/1994
Responsible for inventory exceeding $16 million Maintained all electronic documentation and records for over 16 aircraft Supervised and trained 10 personnel Performed Database Administrator duties for aircraft parts and history tracking system
## Area of Expertise
**OS** Windows (31,95,98,ME,2000,XP) Linux (redhat, suse, mandrake) AS/400 Amiga **Languages** Visual Basic (6,.NET) Delphi C# C++ E VBScript JavaScript Ada APS HTML XML XSL **Databases** MS SQL DataFlex DB2 Oracle MySQL bTrieve Pervasive SQL Access ** Graphic Tools Photoshop Illistrator Corel Draw Maya Lightwave 3DS Max Poser Bryce Quark Express Special Skills Crystal Reports Crystal Enterprise Com+ MCP IIS PSQL**
