Sales Analyst

EXPERIENCE SUMMARY:

. Performed in the following Information Technology positions such as a

systems programmer, an application programmer, a business analyst, a

trainer/mentor, a team leader and manager for over thirty years.

. Responsible for using multiple life cycle methodologies to perform such

tasks as analysis, design, business and technical specifications

(including use cases for other programmers to follow), extensive coding,

testing, documentation (including user manuals and system operations

manuals) and training (including individual, small group and classroom).

. Supported many industries such as the automotive industry in the sales

and marketing, order entry, warranty, advertising, accounting, and

finance departments; telecommunications industry in the billing system;

the insurance industry in the life insurance system; and computer

integration in the operating systems and utilities.

. Provide technical expertise on mainframe systems using such software as

DB2, COBOL, and IMS DB/DC; provide technical expertise on client/server

using such software as UNIX, Oracle, Java, Perl, and C/C++.

. Supported systems internationally in Netherlands and Mexico.

. Demonstrate excellent written and verbal communications skills.

. Managed a union staff of five people and a non-union staff of three

operators and two programmers.

TECHNICAL SKILLS SUMMARY:

Certifications: UNIX, C, MCDST, A+, Network+, HDA, CSS

Hardware: IBM 3090, PC, Unisys A series

Languages: COBOL II, Visual Basic, HTML, XML, CGI/Perl Script,

C/C++, JAVA, J2EE, PL/I, ASSEMBLER, ALGOL

Operating OS/390, MVS, UNIX, Windows, MCP

Systems:

Databases: ORACLE, DB2 (QMF and SQL), SQL Server, IMS DB/DC (MFS),

DMSII, VSAM

Communications: CICS, COMS, NDLII, BNA

Utilities: File-Aid, Abend-Aid, Expediter

Methodologies: Object Oriented (UML), System Life Cycle

Ancillary TSO, ISPF, JCL, Microsoft Office Suite, SAS, Vi, Ed,

Software: WFL, TELON, SQL, Visio, QUIKJOB, CA7, CA11, Control M,

Control R, MS Project, Project Workbench, Rational Rose,

Dreamweaver, Flash, Fireworks, CORBA, Websphere, PHP,

Coldfusion, DataDirect Shadow and Shadow Studio

SOFT SKILLS SUMMARY:

Industries: Automotive, Telecommunications, Insurance, System

Integration

Functions: Programmer/Analyst, Business Analyst, Trainer/Mentor,

Team Lead, Manager

Applications: Sales and Marketing, Warranty, Order Entry, Advertising,

Accounting/Finance, Life Insurance, Billing, Operating

Systems

EDUCATION:

Master of Business Administration, Finance, Saginaw Valley State College

(1987)

Bachelor of Science, Data Processing, Saginaw Valley State College (1979)

PROFESSIONAL EXPERIENCE:

5/10 - Present

Aquent Corporation, Southfield, MI

Business Analyst

. Support the Vehicle Sales North America (VSNA) and North America Sales

Reporting (NASR) systems for GM Vehicle Sales, Service and Marketing

division by meeting with supplier; write specifications based on GM

information; test, and implement client changes, train client on

changes as needed; work on updating the Sharepoint site with current

systems documentation and data load files.

. Technical environment is UNIX, PowerBuilder, Oracle, PL/SQL, IBM 3090,

COBOL, VSAM, DB2, JCL and Windows XP.

5/08 - 02/10

Progress Software, Inc, Bedford, MA

Senior Solutions Consultant

. Performed the installation and proof of concepts (POCs) at perspective

customers using Progress Shadow and Progress Shadow Studio;

performed professional services including programming and mentoring at

customers using Progress Shadow and Progress Shadow Studio.

. Technical environment is IBM 3090, COBOL, VSAM, DB2, CICS, IMS, JCL,

Visual Studio .NET, Java, Shadow, Shadow Studio and Windows XP.

11/06 - 5/08

Capgemini, Southfield, MI

Senior Business Analyst

. Supported the Vehicle Sales North America (VSNA) and North America

Sales Reporting (NASR) systems for GM Vehicle Sales, Service and

Marketing division by meeting with clients; write specifications based

on client information; test, and implement client changes, train

client on changes as needed.

. Completed data models of the Oracle data of VSNA and NASR using Visio.

. Supported extracting of data from the mainframe using COBOL, JCL, and

DB2; support the loading and reporting of data using UNIX,

PowerBuilder, Oracle, and PL/SQL.

. Technical environment is UNIX, PowerBuilder, Oracle, PL/SQL, IBM 3090,

COBOL, VSAM, DB2, JCL and Windows XP.

07/06 - 11/06

Techni-Serve. Inc, Troy, MI

Business Analyst

. Supported the cemetery and property management systems by meeting with

clients; write specifications based on client information; program,

test, and implement client changes, train client on changes as needed.

. Technical environment is MS Access, UNIX, PHP, Cold Fusion, MS SQL,

VB6, VBA, Dataflex, COBOL, and Windows XP.

05/06 - 07/06

Acutech Resources, Flint, MI

Systems Analyst

Assigned to GM Service and Part Organization

. Created and implemented global parts list system using MS Access and

VBA; extracted data from the IBM mainframe using Java based program.

. Technical environment was MS Access, VBA, VB6, Windows XP, and IBM

mainframe.

11/05 - 04/06

Express Personnel, Shelby Township, MI

Analyst

Assigned to SKF-TCM

. Provided support by creating, designing, programming and implementing

the maintenance request system using MS Access and VBA.

. Technical environment was MS Access, MS Excel, VBA, and Windows XP.

09/05 - 10/05

Cook Systems, Memphis, TN

Programmer/Analyst

Assigned to Commonwealth of Kentucky, Commonwealth of Technology

Tax Modernization Project

. Provided support for the Individual Income Tax System by meeting with

client/customer; wrote specifications based on information gathered;

programmed, tested and implemented changes; and trained

client/customer on changes.

1. Technical environment was COBOL II, IMS, TELON, DB2, SQL, and JCL on

an IBM mainframe.

05/04 - 12/04

Vastera Incorporated, Dulles, VA

Senior Systems Analyst/Team Lead

. Provided support for the TradeSphere Importer system by meeting with

client/customer; wrote UML based specifications passed to development

team; tested the changes from development team; trained

client/customer on changes

. Technical environment was Java, Websphere, and XML.

01/01 - 01/04

Oakland Community College, Auburn Hills, MI

Technical Lead Support Analyst

. Resolved computer and network related problems encountered by students

in the lab as well as assisted in their understanding of the computers

and its applications

. Tutored and taught the Database Design Processing using Visio for data

modeling, Object Oriented Systems Analysis and Design, Java I,

Microsoft Office Suite, and Introduction to Computers classes.

. Technical environment was Windows NT, Windows XP, Java, C/C++, Visual

Basic, Perl, HTML, FrontPage, MS Office XP, and ORACLE.

05/99 - 08/99

Computer and Engineering Systems, Rochester, MI

Senior Systems Programmer/Team Lead

Assigned to Daimler Chrysler

Depot Code Expansion Project

. Provided support by reviewing all programs used by client/customer;

wrote technical specifications passed to development team.

. Technical environment was COBOL, DB2/Stored Procedures, IMS DB/DC,

TSO/ISPF, JCL, and CICS on IBM mainframe.

05/98 - 02/99

CDI, Troy, MI

Senior Programmer/Analyst

Assigned to Ford Motor Credit

Red Carpet Lease System

. Provided support for the Red Carpet Lease by meeting with

client/customer; wrote specifications; programmed, tested and

implemented changes; and trained client/customer on changes.

2. Technical environment was COBOL II, IDMS, GTFM, DB2/Stored Procedures,

SQL, and JCL on an IBM mainframe.

11/95 - 05/98

Perot Systems, Auburn Hills, MI

Specialist/Business Team Lead

Warranty System Rewrite Project

. Provided the use case analysis and design (UML) specifications, data

modeling, data warehouse, and object model designs using ORACLE and

Data Architect for California Air Resource Board (CARB) subsystem as

well as the Warranty Information Network System rewrite by meeting

with client/customer; created and loaded database with customer

production data using Oracle PL/SQL; tested programs and system when

programmers completed the changes.

. Technical environment was ORACLE, Rational Rose, PL/SQL, JAVA, CORBA,

and C/C++ on a DEC Alpha Server.

Analyst

Warranty Systems

3. Provided analysis and proposal for the Warranty system implementation

in Mexico; provided analysis, design, programming, testing and

implementation support for the CARB reporting system; provided support

to Warranty Information System by meeting with client/customer; wrote

specifications; programmed, tested, and implemented changes; trained

client/customer on changes

4. Technical environment was COBOL II, IMS DB/DC, DB2/Stored Procedures,

SQL, JCL, Procedures and CICS on an IBM mainframe.

05/94 - 11/95

Alexander Hamilton Life Insurance, Farmington Hills, MI

Systems Analyst

5. Provided maintenance support for the LIFE COMM system by meeting with

client/customer; wrote specifications; programmed tested and

implemented changes to LIFECOMM system; trained client/customer on

changes.

6. Technical environment was ASSEMBLER, COBOL II, JCL, DB2, SQL, SAS,

QUIKJOB, Procedures and CICS on an IBM mainframe.

06/93 - 05/94

Various Consulting Companies

Programmer/Analyst

. At Ford Motor Company in the Body and Assembly General Offices,

designed, coded, tested, and implemented portions of the Convert 6 to

12 car lines project using COBOL II, IMS DB/DC and DB2 and in the

Sales and Marketing area, analyzed and designed the Dealer News

Bulletin.

. At Alexander Hamilton Life Insurance, coded, tested and implemented

year-end report changes and analyzed a cash disbursement problem.

. At Mazda Corporation, coded, tested, and implemented the batch portion

of the Ship to Europe project using IMS DB and COBOL II.

. At Chrysler Corporation analyzed and designed the forecasting release

of parts subsystem for the Parts Group.

. Technical environment for all these positions was IBM 3090 using COBOL

II, IMS DB/DC, SQL, and DB2.

09/89 - 6/93

Electronic Data Systems, Plano, TX

Systems Engineer/Team Lead

General Motor Dealer Information Database (GMDID) System

. Provided team leader and production maintenance support for the

General Motor customer on GMDID and DNPS Dealer Network Planning

System) systems by meeting with client/customer; wrote specifications;

programmed, tested, and implemented changes; trained client/customer

on changes

. Technical environment was TELON, COBOL II, QMF, and DB2 on IBM

mainframe.

Chevrolet Preference Systems

. Provided programmer/analyst by meeting with customer/client; wrote

specifications: programmed in COBOL, PL/I and SAS, tested, and

implemented changes; trained client/customer on changes

. Technical environment was IBM 3090 using COBOL, IMS DB/DC, SAS, and

PL/I on IBM mainframe.

Contact this candidate