Analyst Manager

Professional Profile

of

Stephen Liu

Phone: (h) 248-***-****

(cell) 248-***-****

E-mail: abncs4@r.postjobfree.com

Professional Summary

Mr. Liu is an Information Technology (IT) Professional with industry

experience since 1991. He is a Senior Programmer Analyst and Systems

Analyst with strong experience in the design, development, production

support and modification of systems utilizing a broad range of technology

including COBOL, DB2/SQL, IMS DB/DC, CICS, JAVA, WSAD, HTML, JAVASCRIPT,

XML, and VSAM. His responsibilities have included working in all phases of

the development life cycle (SDLC). His background includes experience in

automotive, banking and insurance industries. Stephen is a strong analyst

with excellent oral/written communication and interpersonal skills,

allowing him to effectively interface with users.

Technical Skills

Languages: COBOL II, COBOL, VISUAL BASIC, PASCAL, REXX, JAVA and NATURAL

Hardware: IBM MAINFRAME, DEC VAX, IBM PC

Operating Systems: OS/MVS, MS WINDOWS 2000/XP, VMS

Ancillary Skills: DB2/SQL, QMF, SPUFI, IMS DB/DC (BMP MPP), CICS,

XPEDITER, CHANGEMAN, OS/JCL, SYNCSORT, LOTUS NOTES,

ACF 2, SAVRS, ASP, REXX / CLIST, ISPF ONLINE, ABEND

AID, VIA SOFT/INSIGHT, FILE AID, PANVALET, DCCS,

DATAVAN, WORKFLO SCRIPT, VSAM, ENDEAVOR, ADO 2.0,

UCC7/CA7, PROFS, PRO EDIT, LOTUS 1/2/3, ORACLE, DCCS,

STROBE, FTP, MS OUTLOOK, VISIO 5.0, ACCESS,

JAVASCRIPT, VB SCRIPT, MS EXCEL, VISUAL INTEDEV6.0,

PUPS, DB2 CONNECT, MOBIUS, SQL SERVER 7.0,

CONNECTDIRECT, XML, RATIONAL 2000, MQSERIES, BTS,

ZENA, WINDOWS SCRIPT, ONDEMAND, WEB SERVICES, VB,

.NET

Professional Experience

ACMIC (American Community Mutual Insurance Company)

07/2008 - Present

Assigned to: Direct employee of American Community, Information Systems -

Agent Team

Programmer Analyst

* Maintain P+ (Performance Plus) - A Server-Based and Web-Enabled

Repository of all Agent Data. Agents appointed to sell ACMIC business are

added and maintained. Commission payment rules for all contracts, plans,

states, agents are maintained including policy-specific exceptions.

* Production support for Marketing Production Statistics - This is our

Marketing data holding tank for any premium change for policies within

their first year of existence and key group premium changes. The daily

data extract, load, weekly, monthly, quarterly and yearly reports are

created based on these databases.

* Agent Retention Project - Create new DB2 tables to store Agent Retention

information and create Web Services and Stored Procedures for Agent

Retention and Policy Retention to allow the consuming programs (Web

Pages) to request the Agent Retention records through Internet.

* Interface with Individual Health (Including Short Team, self-employed or

those in between jobs) and Group Health (Group PPO, Consumer Choice or

HSA). Any new Group Health added must be tested through P+.

* Agent 1099s tax process - Year End roll over, MDRT (Million Dollar Round

Table), Agent Earnings processing and generate Agent 1099s forms for

Federal/IRS, State of Michigan and Municipalities in Michigan for those

Agents who have the total of commission and non-commission greater or

equal to 600 dollars. All the Agent earnings summary reports must be

balanced.

* Disaster Recovery testing - Key person to perform systems testing for

Agent Team to ensure when Disaster happens, data center can be

recovered/restored to prior business day and all tasks and batch Cycles

will still run normal.

* NATURAL 3.5, CONSTRUCT 4.2 and DB2 9.7 upgrade. Responsible for all

phases testing to ensure the business as usual.

* Provide on-call responsibilities. Problems solving during midnight.

* Tools: DB2/SQL, NATURAL, VB, .NET, SourceSafe, Share Point, Stored

Procedure, Web Services, ZENA, OnDemand, Windows Script/Commands, FTP,

COBOL, SYNCSORT, VSAM, XPEDITER, JCL, FILEAID, CICS, JAVA, Servlet, Web

Sphere, HTML, JavaScript, MS-OFFICE 2003, WINDOWS XP.

CES (Computer Engineering Services) 02/2004 - 07/2008

Assigned to: Daimler Chrysler, Purchasing System

Senior Programmer Analyst

* Key analyst for Purchasing System Production Support (270+ Mainframe

Online IMS DC and 630+ Batch programs IMS DB/DB2 and 95 Interfaces) and

provide on-call responsibilities.

* MPAB (Module Pay-as-Built) project - an enabler for corporate goals to

achieve Lean Processes (using Mainframe IMS DB/DC BMP, MFS, MPP and DB2)

through Unit, Systems Integration, User Testing and Post Launch

evaluation per Sarbanes Oxley Act framework

* Well versed in the Systems Development Life Cycle (SDLC) with strong

analytical skills.

* Mentored and coached new team members as needed in order to help them

provide required deliverables that are of high quality and within

expected timeframes.

* IMS-to-DB2 Conversion

* MOPAR WEB RFQ (Production and Service parts - Request for Quote via web

for Purchasing Systems) using JAVA, JSP, Servlets, Java Beans, HTML,

JavaScript, IMS and DB2

* Converted NET.DATA to Java for Special Supplier using JAVA, JSP,

Servlets, Java Beans, HTML, JavaScript, IMS and DB2

* Maintain and develop new functionality for COMPASS (COMmodity Procurement

Analysis and Support System) per customer requests using IMS (DB/DC BMP,

MFS, MPP), DB2, JCL, XPEDITER, COBOL, FILEAID, CICS, MQSeries for OS/390

* Tools: IMS DB/DC, DB2/SQL, CICS, JAVA, Servlet, WSAD, EditPlus, HTML,

JavaScript, COBOL II, XPEDITER, FTP, DATAVAN, PRO EDIT, MQSeries for

OS/390 EASYTRIEVE, QMF, JCL, FILEAID, DCCS, VISIO 5.0, MS-OFFICE, LOTUS

NOTES, STROBE, DISTRIBUTING SYSTEMS, WINDOWS NT/2000

CDI Information Technology Services 04/2002 - 10/2003

Assigned to: Daimler Chrysler, C& D Segment, VCM (Vehicle Configuration

Manager) Project

Senior Programmer Analyst

* Created modules to manage shared parts repository to be accessible by the

Chrysler Group, MMC (Mitsubishi Motor Company), HMC (Hyundai Motor

Company).

* Documented shared parts management Use Case, and create extract modules

of EBOM (Electronic Bill of Material) to do an initial load of shared

parts information.

* Performed data extracts from EBOM (Electronic Bill of Material) to

support AUTOMOTIVE SCHEMA and FAST CAR.

* Wrote the Stored Procedure programs for New Part Introduction and some

CICS Enhancement

* Provide on-call responsibilities. Maintain and add new functionality to

EBOM SYSTEMS per customer requests.

* Video Conference for database design, changes and reach all agreements

between MMC (Japan) and DCC (U.S.)

* New release for VCM (Vehicle Configuration Manager) 2.8.3 including

coding, testing using JAVA, Servlet, HTML, JavaScript, XML, IMS and DB2

* Tools: JAVA, Servlet, WSAD, CuteFTP 2.6.1, HTML, JavaScript, COBOL II,

DB2/SQL, STORED PROCEDURE, CICS, IBM MQSeries for OS/390,

RUP/RATIONAL2000, IMS, XPEDITER, FTP, DATAVAN, PRO EDIT, EASYTRIEVE, QMF,

JCL, FILEAID, DCCS, VISIO 5.0, MS-WORD, LOTUS NOTES, MS-EXCEL, STROBE,

DISTRIBUTING SYSTEMS, WINDOWS NT/2000, UNIX (IBM AIX ENDEAVOR)

CDI Information Technology Services 03/2001 - 03/2002

Assigned to: Ford Motor Company, Plant Code Expansion project

Senior Systems Analyst

* Led two systems (Invoicing and Vehicle Drafting ) on plant code expansion

project to have the flexibility and capability to support plant / import

launches.

* Designed and Developed the project plant ( using REXX / CLIST, ACCESS and

EXCEL ) analyst / programmer checklist

* Identified and coordinated the external interface systems that will be

affected by plant code expansion.

* Created the implementation plan including SPEC for each Job / Program /

Utility and ISPF Online Screen that will be required to change.

* Designed, tested and implemented programs ( POST-RELEASE and TRAILER

systems ) for production support

* Completed two systems (Invoicing and Vehicle Drafting) program flowcharts

(using MICROSOFT VISIO 5.0) that have been analyzed.

* Tools: COBOL II, DB2/SQL, VSAM, ISPF ONLINE, REXX/CLIST, IMS DB/DC (BMP

MPP), CHANGEMAN, JCL, UCC7/CA7, XPEDITER, FILEAID, OUTLOOK, ACCESS,

EXCEL, MOBIUS, WINDOWS 98.

CDI Information Technology Services 12/1998 - 02/2001

Assigned to: Daimler Chrysler

Systems Analyst

* Responsible for development of and rewrite of (SC) Service Contracts,

Claim Contracts, Adjustment, Reinstatement, and Cancellation Systems.

* Meet with users to determine requirements, develop system and program

specifications, design, develop, test, and implementation.

* Performed data extracts from service contracts to the Warranty Decision

Support System (WDSS) for loading new databases ( UDB).

* Designed, developed, tested and implemented new programs to support CAIR

System using COBOL II, IMS DB/DC (BMP MPP), and DB2/SQL.

* Provide on-call responsibilities. Maintain and add new functionality to

Service Contracts Systems per customer requests.

* Tools: COBOL II, IMS DB/DC, DB2/SQL, XPEDITER, FTP, DATAVAN, PRO EDIT,

EASYTRIEVE, QMF, JCL, BATCH-QMF, DCCS, FTP, MS-WORD, LOTUS NOTES, STROBE,

DISTRIBUTING SYSTEMS, WINDOWS 98

Compuware 11/1996 - 12/1998

Assigned to: Ford Motor Company

Senior Programmer/Analyst (Production Support)

* Participating in production support of a Material Planning and Logistics

system written in COBOL, IMS DB/DC (BMP MFS MPP) and DB2/SQL.

* Responsible for analysis, modification, troubleshooting and testing of

mainframe programs.

* Performed Y2K analysis for unit, integration and system testing on

domestic special order systems utilizing COBOL, IMS DB/DC and DB2.

* Provided on-call responsibility for the system.

* Tools: IMS DB/DC (BMP MPP), XPEDITER, DB2/SQL, FILE AID, PUPS, JCL,

UCC7/CA7, PROFS, MS WORD, IBM utilities, TSO/ISPF.

Environment: IBM MAINFRAME, WINDOWS 95

Assigned to: Chrysler Corporation

Programmer/Analyst

Responsible for modification and development of an International/Domestic

Parts Processing system. Duties included:

* Analyzed, modified and tested program modules to convert Dealer, Zone,

Sales District and Region from numeric to alphanumeric.

* Modules required update, insert, fetch, and select activities in IMS and

DB2.

* Interfaced with client to acquire and provide information.

* Responsible for miscellaneous assignments.

* Developed test data.

* Wrote menu and query programs using CICS.

* On-call responsibilities.

* Tools: COBOL II, IMS DB/DC, DB2/SQL, CICS, UCC7/CA7, JCL, DCCS,

PANVALET, XPEDITER, MS WORD, LOTUS NOTES, FILE AID, SQL, STROBE, ACF2,

PRO EDIT, SAVRS, QMF, DATAVAN, VSAM

Environment: IBM MAINFRAME, WINDOWS 95

Assigned to: Comerica

Programmer/Analyst

* Implemented new supplier version of Purchase Orders and Account Payable

for year 2000 compliance.

* Uploaded program from PC to Mainframe for year 2000 compliance.

* Tools: JCL, FILE AID, CICS, VSAM, FILENET/WORKFLO SCRIPT, VISUAL BASIC,

WINDOWS 95, WORDPERFECT, LOTUS 1/2/3

Environment: MAINFRAME, WINDOWS 95

Assigned to: AAA

Programmer/Analyst

* Responsible for analysis programming, coding and QA testing in Auto POS

Claim System for year 2000 project modifications.

* Tools: XPEDITER, ENDEAVOR, VIASOFT/INSIGHT, DB2, VIASOFT/SMART EDIT,

PANVALET, IMS DB/DC.

Environment: MAINFRAME, WINDOWS 95

Fu Pun Insurance Company, Taiwan 10/1991 - 06/1993

Programmer/Analyst

* Maintained and enhanced auto insurance applications utilizing COBOL, IMS-

DB, JCL and IBM utilities.

* Interfaces with customers to determine needs.

Training

. IBM File Manager for z/OS and OS/390 and Fault Analyzer Version 8.1

(CHYSLER March 2008)

. IBM SQL Performance Analyzer (DAIMLERCHRYSLER)

. RC/Updates, WindowsXP Migration (DAIMLERCHRYSLER)

. JSP, SERVLET, JAVASCRIPT, HTML (OCC)

. JAVA PROGRAMMING II (OCC)

. XPEDITER/DevENTERPRISE CODE COVERAGE (DAIMLERCHRYSLER / COMPUWARE)

. Rational Unified Process (RUP) Best Practices - Model Visually (IBM)

. JAVA PROGRAMMING (OCC)

. XML (DAIMLERCHRYSLER / CROSS LOGIC)

. JAVA, JSP, XML, VISUAL CAFE 4.0 (UM CONSULTING).

. ASP, VISUAL INTERDEV 6.0, ADO 2.0, SQL SERVER 7.0, VB SCRIPT, JAVASCRIPT,

HTML

. UM CONSULTING

. WDSS (WARRANTY DECISION SUPPORT SYSTEM) DCX

. CICS, XPEDITER, FILE-AID, COMPUWARE

. VISUAL BASIC, ORACLE (PL SQL, SQL*PLUS), PROBLEM SOLVING

. IMS DB/DC, ABEND-AID, COMPUWARE

. DB2, COMPUWARE

Education

M.A. - Computer Science

Eastern Michigan University: Ypsilanti, MI

B.S. - Computer Science

Chinese Cultural University, Taipei, Taiwan

Contact this candidate