Quality Assurance Analyst

Kim Guinsatao

**** **** ****** *****, ******* Lake, IL 60014, 815-***-****, **********@***.***

Profile

Results-oriented IT professional with extensive experience in IT. Experience building and managing a

marketing database of 75 MM households and managing its operations. A quick learner skilled in

multitasking, effective interpersonal communication, and efficient problem resolution. Motivated and

personable with a track record of accurate and timely delivery of projects. Talent for quickly mastering

technology. Diplomatic and tactful with professionals and non-professionals at all levels. Flexible and

versatile – maintains sense of humor under pressure.

Software

z/OS Cobol JCL

SAS Assembler (BAL) TSO/ISPF

SAS Macros Group 1 Software CLISTS

Easytrieve Plus Natural/Construct ISPF Dialog

Syncsort ADABAS Visual Basic (VB)

Quikjob Java

Professional Experience

TIME INCORPORATED – Chicago, IL, 1993-2009

Senior Systems Analyst/Systems Analyst, 1996-2009

Managed build of a corporate marketing database of 75MM+ households four to eight times per

year from requirements to validation and delivery

Managed transmission of data files to and from third party vendors:

o Automated data encryption (PGP) and transmission (FTP/SFTP) processes

Managed process of transferring data to and from Experian in order to incorporate interest and

demographic data into the corporate marketing database

Saved expense of having outside vendor maintain marketing database by bringing the process in-

house and developing a system for transactional updates

Implemented and supported regression testing in a robust test environment

Fulfilled ad-hoc selection and reporting requests using SAS

Provided database application support for clients/analysts

Implemented file tailoring techniques to build code using CLISTS and/or SAS

Served as primary auditor for database change control and quality assurance

Programmer Analyst, 1993-1996

Coded, tested and implemented changes to the corporate marketing database. Fulfilled ad-hoc

requests

GLOBE GLASS & MIRROR – Chicago, IL

Senior Programmer Analyst/Programmer Analyst, 1990-1993

Played major role in the development and support of online pricing system for field agents to

provide real-time pricing via Natural/ADABAS

Successfully implemented major enhancements to online Customer Database System

NORTH AMERICAN COMPANY FOR LIFE AND HEALTH INSURANCE (NACOLAH) – Chicago, IL

Senior Programmer Analyst/Programmer Analyst, 1988-1990

Designed, coded and implemented long-term quarterly bonus system to compensate agencies based

on consistency and persistency of written business

Designed, coded, and implemented a compensation system to pay sales Vice Presidents based on

their ability to recruit General Agents

Kim Guinsatao

1272 High Plaine Drive, Crystal Lake, IL 60014, 815-***-****, **********@***.***

Education

Northwestern Business College, Rosemont, IL – Java Programming certificate, anticipated 2009

McHenry County College, Crystal Lake, IL – Visual Basic 2008 / MS Visual Studio IDE, 2008

University of Illinois, Champaign, Illinois – Coursework in Business and Computer Science

Training

SAS Institute, Chicago, IL – Basic, Advanced, and Macro Programming

Group One Software, Atlanta, GA – Consumer Merge-Purge Application

Time Inc., Chicago, IL – Numerous in-house computer related courses

Contact this candidate