KENNEDY BUTLER

**** ***** **** ******

Chicago, Illinois 60621

773-***-****

qwcopt@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Programmer Analyst

Diversified technical background in data analysis (11 years), computer programming (11 years), and computer operations (+20 years). Sound understanding of relational databases. Possess strong problem-solving and analytical skills. Reliable and conscientious with proven efficiency working with others. Results-oriented and solution focused to achieving corporate goals.

TECHNICAL SKILLS

Languages: SAS (11 years), COBOL (4 years), PL/SQL (4 years), JCL (+20 years)

Operating Systems: Windows XP, MVS/XA, ISPF, TSO, CICS, JES II, TMS, DOS

Databases: Oracle, MS Access, MS Excel, VSAM, Lotus 1-2-3

Systems Tools: Crystal Reports (7 years), MS Word, CA-7, JobScan, FileAid, Form Design Aid, ETL

RELEVANT CAREER EXPERIENCE

CHICAGO POLICE DEPARTMENT – Chicago, Illinois

PRINCIPLE SYSTEMS PROGRAMMER - December 2001 – March 2009

SENIOR SYSTEMS PROGRAMMER - May 1998 – December 2001

SYSTEMS ENGINEER - April 1997 – May 1998

Developed, modified, and tested various programs of considerable complexity utilizing

PL/SQL, SAS, and COBOL which encompassed all primary applications: Hot Desk, Traffic, 911/Radio

Calls, Crimes, Arrest, Medical, Payroll, Personnel, Gun Registration, and Physical Inventory.

Utilized SAS and Crystal Reports to create frequency, cross tabulation, and summarized

statistical data analysis reports on crime, offenders, traffic, medical, and personnel.

This included data cleansing and data diagnostics to ensure accuracy of results.

Created a SAS program to randomly select Chicago Police Officers from a list of those

who applied for overtime for CTA or airport detail.

Applied knowledge acquired through education to work with COBOL programs. Performed

basic to intermediate modification to code as needed. Afterward the programs were

recompiled, tested, and placed back into production.

Developed Oracle database tables for the Patrol Division utilizing PL/SQL. Data was

imported from the Office of Emergency Management Communication tables and extracted data

from the police department tables. Data was manipulated and cleansed to ensure accuracy

of results. This project took slightly over a year.

Processed new recruits into the personnel system. Received a file via disk from a legal

firm and uploaded the data into an empty flat file on the mainframe. Manipulated the data

to coincide with the prescribed organization record fields which included formatting and

resizing the data. Afterward the file was then merged with the organization recruit file,

sorted, and the data was uploaded into the VSAM personnel file. This project was performed

when the need arose.

Investigated and debugged application problems promptly to insure that production jobs were

completed in a timely manner.

Researched and developed various ad hoc reports utilizing SAS, COBOL, and Crystal Reports to

identify organizations needs both internally and externally (City of Chicago Law Department,

Independent Police Review Authority, Internal Affairs, Cook County Public Defenders Office,

Federal Bureau of Investigations etc.).

Managed all production jobs for the entire organization which included creation,

documentation, and distribution to the proper users.

COMPUTER SUPPORT SPECIALIST - December 1995 – April 1997

Initially hired to complete implementation of remaining production jobs into CA-7 automated

scheduling software application which included setup, scheduling, updating, and documenting.

This project was completed ahead of schedule.

Solved abend and JCL errors promptly.

Maintained daily system back-up procedures. Excellent knowledge of TMS.

Created and updated documentation for files and records.

Created and modified forms utilizing Form Design Aid to meet the requirements of users.

Provided training and assistance for computer operation.

CAREER RELATED TRAINING

Oracle PL/SQL, Oracle9i and 10i, Oracle Data Modeling, Oracle Database Design,

Oracle Developer/Designer 2000, Oracle Forms, Oracle Flows Builder, Crystal Reports, and Business Objects.

EDUCATION

Bachelor of General Studies in Computer Science

Roosevelt University - Chicago, Illinois

Associate of Applied Science in Data Processing

Triton Community College - River Grove, Illinois

Certificate in Computer Programming

The Bryman School - Chicago, Illinois

Contact this candidate