Software Engineer Computer Science

Tian-Li Ou

** ****** *******, **** *********, NY 11552

516-***-**** ? ******@*******.***

SUMMARY

Technical professional with extensive experience functioning as a Software

Developer, Automation Integrator, Technical Supporter and Project Leader.

Expertise in UNIX, LINUX, Korn Shell Script and Sybase-AutoSys. Recognized

for quickly analyzing requests and identifying solutions related to process

improvements, operational efficiencies and automation.

TECHNOLOGY

Languages: Korn Shell Script, C, SQL, AutoSys-JIL Script

Hardware: HP9000, HP 3000, PC

Operating Systems: HP-UX, LINUX, MPE-X/L, WINDOWS, DOS

Databases: Sybase ASE/IQ, MS Access, Unicenter AutoSys

EXPERIENCE

Nielsen, Syosset, NY 1990-2009

Associate Technical Business Analyst (2007-2009)

Application Analyst (1999-2007)

. Designated system support resource for global projects. Designed and

coded software within UNIX/LINUX platform to support ETL processes.

Participated with multiple projects simultaneously.

. Defined batch jobs to Unicenter AutoSys JM. Designed and implemented

queue structure, load balancing using JIL Script, Sybase stored

procedures and tables for UNIX/LINUX backend. Designed and coded

Autosys support utilities for monitoring and managing batch processes.

. Participated with Market Research Report Generator upgrade project within

a UNIX environment. Performed set up and configuration for the migration

of more than 26 countries requiring ongoing communication with global

support teams.

. Consistently provided quality work for SHARP/CASE application. Completed

activities in accordance with project plans. Completed the application

enhancements and responded to ad hoc tickets as well as off-hour support

requests.

. Designed and coded improvements to Autosys job scheduler which reduced

batch jobs by 90%, reduced queue management work. Moved AutoSys from UNIX

to LINUX, and provided multiple utility enhancements for SHARP,

Syndicated market report application.

. Developed a set of UNIX/LINUX tools used to compress and transfer the

huge files from the warehouse server to local server. Enhanced file

compression and transfer for web database loading by using GZIP-SCP-

GUNZIP. Designed and coded the FTP tool set, which is used widely for

file transfer between servers (UNIX, MPE, IBM, NetRatings remote server).

. Designed, coded, tested and monitored common utilities and provided Hands-

on training for off-shore consultants and QA support team. Responsible

for UAT training and documentation to teach CCA team how to monitor and

handle the sophisticated SHARP backend process by using the system

utilities.

. Designed and coded a Sybase Open Client server application in C, and its

related Korn Shell scripts for SHARP. Also designed and coded Korn Shell

scripts and utilities, which support the Web Client Server. Designed,

coded and implemented the tool set for SHARP status tracking, batch job

launching, old job/file cleanup and system status monitoring.

. Designed and coded KSAMPULL program in C/XL, which is used for Syndicated

Annual Report to extract Purchase data from MPE machine.

Tian-Li Ou Page 2

516-***-**** ? ******@*******.***

. Designed and coded the key application for Global SHARP data prep. It was

successfully used to generate Syndicated Annual report. Setup 17 SHARP

backend UNIX environment, including all production systems for U.S.,

Canada and France, SQA and Develop systems.

. Won several Art Awards, 2005 Gold Medal Awards of contribution for

Syndicated Annual report delivery and Sharp Enhancements for MegaPanel.

Won 2001 Performance Excellence Award.

Programmer / Senior Software Engineer (1993-1998)

. Designed and coded Sybase Open Client Server and its related scripts to

enable PFW front-end to invoke the programs in UNIX environment.

. Designed and implemented AutoSys, queue structure and queue related

Sybase tables for PFW to dynamically launch batch jobs for data prep and

report process.

. Designed and developed some key MPE/UNIX PFW programs including PROJMAST

package for Global PFW data prep, TRIPLOAD for Trip data transfer from

MPE to UNIX, TRIPPULL in C for extracting Trip data.

. Enhanced MPE Projection system in Pascal to develop projection factors

for PFW reports.

. Designed and coded Korn Shell utilities to support PFW backend system for

data process, job scheduler, status tracking and file transfer.

. Responsible for setup PFW backend UNIX environment for U.S., Canada, UK,

Germany, Mexico, Columbia, and South Africa.

. Won Homescan "System Most Valuable Player" Award for 1998. Won

Recognition Awards for 1996, 1997 and 1998, Recognition Award from the

Country Manager for work on Canada Syndicated Products. Won 1999 Art

Award for contribution in implementing Global PFW.

Programmer Trainee (1990-1992)

. Designed and coded the NHS applications in Pascal for Brand Linking,

Coupon Reporting, Order Entry, P*F Manu System, RG, and Media.

. Won Recognition Award for the installation program used by Panel*Fact

Menu System.

Hofstra University, Hempstead, NY 1989-1990

Computer Lab Assistant/Teaching Assistant

Detected and reported hardware and software problems. Aided students with

a variety of computer languages in University Computer Lab. Implemented

programming projects using Turbo Pascal on IBM PC in Computer Science

Department.

China Textile University, Shanghai, China 1982-1989

Lecturer

Taught courses in Environment/Water Treatment Engineering. Conducted Water

treatment research by using biochemical/physic-chemical methods. Completed

a series of designs for water treatment stations in east China.

EDUCATION

MS, in Computer Science with Distinction, 1990

Inducted into Upsilon Pi Epsilon - National Computer Science Honor Society

Hofstra University, Hempstead, NY

BS, in Water Supply and Sewage Engineering, 1982

Tong-Ji University, Shanghai, China

Contact this candidate