Resume

Sql Programmer Analyst/ Crystal Reports Developer

Location:

Tallahassee, FL, 32303

Posted:

December 18, 2012

Contact this candidate

Resume:

NAME: Herman R. Davenport Jr.

D.O.B.: **/**/****

MAILING ADDRESS: 2110 Mulberry Blvd.

Tallahassee, FL 32303

COUNTY: LEON

TELEPHONE: Home: 850-***-****

Cell: 850-***-****

EMAIL ADDRESS: abgmb7@r.postjobfree.com

EDUCATION: S.H. Blair High School - Diploma

Hattiesburg, MS 39401

COLLEGE, UNIVERSITY OR PROFESSIONAL SCHOOL: (TRANSCRIPTS MAY BE REQUIRED)

University of Southern Mississippi

Hattiesburg, MS 09/76 - 06/81 - BS in Computer Science

Jones County Jr. College

Ellisville, MS 39437 01/83 - 08/83 and 09/1983 – 12/1983

RPG II Programming - Certificates(2) - 84 hours of Instruction

University of Southern Mississippi

Hattiesburg, MS 09/86 06/87 - Mississippi Teacher Certification

Job Related Training: Crystal Decisions 8.5 - 08/2001

Orlando, FL

Crystal Reports – Certificate

ProTech Training 08/2007

Tallahassee, FL

Advanced SQL - Certificate

LICENSE : Mississippi Teacher Certification 07/87- 06/1992

EMPLOYMENT:

Name of Employer: Intuition Systems Inc.

Address: 325 John Knox Rd.

Tallahassee, FL 32317

Phone: 850-***-**** ext 4130

Title: Crystal Reports Specialist

Supervisor: Thomas Richardson

From: 01/11/2010

To: 08/19/2011

Employment Type: FullTime

Duties and Responsibilities: Intuition is a records management company that manages the Florida College Prepaid and Investment Tuiition Plans. Crystal Reports was used in converting the letters from Crystal 8.5 and Microsoft Word into Crystal XI. The letter process began with a file that was created from the Tandem system. This file was then used by the Letter Writer Application, to import the file into an SQL table. The Crystal report/letter was then linked to the SQL table. For the Prepaid letters, each letter had its on individual table and for the Investment letters there was one table for all of the Investment letters. The Letter Writer Application was also used for printing and archiving a copy of the letter. SQL procedures were developed for updating the SQL table by either adding fields or changing the field names.

Software Development – The Systems team developed, updated processes and procedures by Phases. Phase1 would be for Enrollment, Phase 2 was for Cancellations and Payments, and Phase 3 was for Matriculation. The Letter Team, of which I was the Developer, was a group of 4 from the Systems Team.

Reason for Leaving: Staff Reduction

Name of Employer: Capital Health Plan

Address: P.O. Box 15349

Tallahassee, FL 32317-5349

Phone: 850-***-****

Title: Programmer Analyst

Supervisor: Leon Greene

From: 04/15/1998

To: 01/08/2010

Employment Type: FullTime

Duties and Responsibilities: I was hired as a MUMPS programmer to create reports from a UNIX system (1998-2003). MUMPS was used in a Cache environment. Reports were created according to users specifications. There would be an initial meeting, in which timelines were setup for programming, testing by the user, BA testing and a final completion date.

2003 – 2009 Create reports using MS SQL Server database by creating stored procedures. Crystal Reports was used to link to the SQL procedure and create the report. There was a NEXTGEN system for the Medical staff and a QNXT system for the Insurance. Both were Microsoft SQL Server Databases. Nightly extracts updated the backup databases. Once reports were completed, the reports were placed on a file server where the users had access to run them. The SQL procedure used parameters and had the capability of using a single table or multiple tables by joining them. Also, some reports were set up to be run on a schedule. The last 6 months I learned the basics for Microsoft Analysis Services/OLAP programming, the building of cubes and how Excel with Pivot Tables was used to retrieve info from the cubes.

Worked with users when they had problems running a report, using either MUMPS or SQL and with the DBA when the users needed access to a specific database. Reason For Leaving: Advance my Crystal Reports knowledge

Name of Employer: Automated Wagering International

Address: 250 Marriott Drive

Tallahassee, FL 32301

Phone: 850-***-****

Title: Computer Operator

Supervisor: Jerry Burton

From: 10/01/1991

To: 04/01/1998

Employment Type: FullTime

Duties and Responsibilities: Monitor online and backup Transaction Systems for the Florida Lottery on Cyber 932 systems and HP RISC 6000 systems. Provided transaction tapes to the state. Update logs, run reports. Overnight processing after systems were brought down at midnight and were readied for the next day. Tested the software for new games, matrix changes for games and promotions. This testing knowledge gave me the opportunity to go to Arizona and Maryland, when AWI was awarded those contracts.

Updated logs for the off-site facility, where system backup tapes were stored, in case of a disaster.

Software Development- When the State wanted a new game or changes to an existing game or promotions. The programming staff in New Jersey would create the software and send to Tallahassee for the operators to test. I would test with other Operators and any problems or issues would then be reported to the Senior Operator. He would then contact programming staff in New Jersey and get an answer when the fix would be sent back to Tallahassee for us to test and complete AWI testing. The State would perform their testing. Then a date for moving the software into Production was established and then it was moved to production.

Reason For Leaving: Hired as Programmer Analyst by Capital Health Plan.

Name of Employer: G. Pierce Wood Memorial Hospital (HRS)

Address: 5847 SE Highway 31

Arcadia FL 34266-9627

Phone:

Title: Computer Programmer

Supervisor: Glenn Palmiere

From: 04/01/1989

To: 05/01/1991

Employment Type: FullTime

Duties and Responsibilities: MUMPS programming language was used to create reports and applications. Modify existing reports. Install B25 workstations: Troubleshoot hardware and software problems. Fix software problems and work with the Operations department and users when they had problems. Train users on new applications and reports.

Reason For Leaving: Moved to Tallahassee.

KNOWLEDGE / SKILLS / ABILITIES

SQL Programming Language – 2000, 2005

SQL Server Management Studio

DTS Packages - SQL 2000

MUMPS Programming language

Crystal Reports 8.5 Enterprise - Crystal Reports XI

EXCEL

Sharepoint - used for setting up meetings and uploading documents such as Meeting Minutes, Work Order lists for co-workers and users to access.

REFERENCES:

Mr. Thomas Richardson - Systems Manager

850-***-****