Michael Robinson
Michael L. Robinson
Canton, GA 30114
OasysConsulting@aol.com
** AVAILABLE JULY 1, 2009 **
Resume of
Michael L. Robinson
SUMMARY OF EXPERIENCE:
Languages and tools:
COBOL II, COBOL, MicroFocus COBOL, SQL, JCL, ADS/*, IDD, IDDM, DMLO, OLQ, Progress, Assembler, Gamma, Natural, UNIX shell scripts, Key (ADW) Enhanced COBOL, SPF macros
Operating Systems:
MVS, UNIX, Windows 95/98, Windows 3.1, WFW 3.11, OS/2, DOS
Database:
DB2, IDMS, VSAM, Progress, Sybase, IMS, Adabase, Datacom, MS Access
Client Server/Editors/Timesharing/Teleprocessing:
TSO, ISPF, ICCF, Librarian, Panvalet, Vedit Plus, CICS, Sybase Open Client/Open Server (including CICS Open Client/Open Server), Sybase Stored Procedures, Sybase SQL Server, Microsoft SQL Server, TCP/IP, FTP
Micro-computers:
IBM PC, SPF/Pro(for Windows, OS/2 and UNIX), PCTools, WordPerfect, Lotus 123, Freelance, TAB, Fastback, MS Word, MS Excel, Tvalue, MicroFocus COBOL, cc:Mail, GroupWise, Quatro-Pro, Test Director, Turbo-Tax, Quickbooks Pro, S-Designer
CASE and GUI tools:
Sterling KEY 4.1, ADW (1.6 & 2.7), IEW, PowerBuilder, Visual Basic, Telon
Other Software Tools:
Xpediter (batch and CICS), IBM Utilities, File-Aid, Abend-Aid, CICS CE** Transactions, DataXpert, DB2Xpert, Animater (OS/2 and UNIX), QMF, Dbug, Intertest, Spufi, DFSort, Syncsort, DB2 AM, Strobe, Flow, ISQL, Jobtrac, Enterprise ControlStation (Control-M, Control-D)
EDUCATION:
M.S. Computer Science
B.S. Business Management
DETAIL OF EXPERIENCE:
The candidate presents a variety of skills as a systems consultant and developer in IBM mainframe, client/server and
personal computer environments. His experience encompasses project management, analysis, design, programming,
training, and technical support on medium to large custom development efforts. During his 15 years of consulting
experience, he has worked with a wide variety of Database Management Systems within several different system
configurations. As a project manager, he has a proven track record in delivering quality, efficient systems within project
deadlines and within the allocated budget.
04/2002 � present
Mike is currently working for a large county public school district. His primary duty is to maintain and
enhance the current IDMS/EasyTrieve/Cobol/VSAM mainframe (OS/390) production environment. In addition, Mike is
aiding in the analysis and design to facilitate the transition of all current mainframe systems and interfaces to
a new package in a Sun/Unix/Oracle based environment.
11/1993 � 03/2002
Most recently, Mike spent two years involved in a large scale project to convert all major IDMS mainframe Customer
and Delivery systems to the MediaPlus Circulation Management (CM) systemÃâ� , a purchased package running on a
Unix platform and using a Progress database. His duties included 24-hour on-call support, data conversion (from IDMS,
VSAM, Sybase and Focus databases to Progress databases), building temporary bridge systems between Progress and
existing mainframe telemarketing Focus and IDMS database systems, and writing Progress data extraction and
processing programs. Mike was also responsible for the design, coding, implementation, and maintenance of custom
procedures to modify or enhance package functionality to meet the needs of the client. Examples of his work include a
process for automatic complaint dispatching to a paging system, new styles of carrier route and delivery lists, automatic
batch processing for new subscriber orders, customized subscriber invoices using the invoice/renewal export, creation of
new General Ledger reports and interfaces to PeopleSoft, one-time ABCZone/Address update, generic
Subscription/Address/Occupant extracts, and a wide variety of miscellaneous reports.
Additionally, Mike developed methods and standards to aid in the migration between the testing and production
environments for custom portions of the CM system. He also developed the shop scripting and procedure templates and
standards, trained the staff on their use, and aided the staff in the Progress and Unix environments. He also designed and
implemented the methods required to capture scripts and procedure logs from the Control-M scheduling package for
display in the Control-D Webviewer.
Concurrent with and prior to the above project, Mike was involved in making modifications to and providing 24�hour
production support for the current MVS mainframe systems. Functionality changes were implemented in batch Cobol
and Cobol II accessing IDMS databases and VSAM KSDS files. On-line enhancements were developed in IDMS
DC/Cobol and ADS. In addition, the candidate was exclusively responsible for the maintenance of an ADW designed
and implemented Customer Data Warehousing system on a Sybase database. This included production monitoring,
abend recovery, performance tuning, and �scheduling� maintenance. Also during this same time period, Mike spent a
significant portion of his time training new employees and consultants on current systems and technologies.
Prior to his maintenance and training duties, Mike served 2 years as project lead in a Year 2000 conversion project. He
was responsible for the development and implementation of a project plan, supervision and task assignments for the
project team, development of QA/testing procedures, end user coordination and notification, and project status
reporting. He also made modifications to a project tracking system using an Access database and created various
reports using the Access database. Because of the success of this project, the client suffered zero downtime and no
major problems as a result of the �Year 2000 bug�.
Before the Year 2000 project, Mike spent 6 months as the member of a team developing a Customer Data Warehouse
system. He aided in the design and creation of the Warehouse in a Sybase Database. He developed the mainframe data
capture, conversion and download processes, and batch database load shell scripts. Mike also wrote a series a UNIX
shell scripts to perform as a UNIX based scheduler. This scheduler automated the procedure of detecting data to be
downloaded from the mainframe, preventing duplicate scripts from executing, and ensured the execution order of the
program shell scripts by monitoring job dependencies and predecessors. UNIX programs were developed using ADW
to generate Micro Focus Cobol. The Cobol used Sybase stored procedures to load and modify the database.
Documentation on the batch processes and database design was maintained using S-Designer.
Prior the Customer Data Warehouse project, Mike spent two and one-half years in the development of a Customer
Service System. During the latter part of this project, Mike spent two years focused primarily on the batch environment.
His initial assignment was to develop the batch architecture, including the creation of template batch modules to be used
for all batch program creation. Initial test platform was created using Sybase's Open Client and Open Server for CICS.
Batch jobs ran under CICS, using Open Client to access the Sybase databases. Testing included the use of both
Animator and Xpediter for CICS. Because of performance problems, the batch platform was changed to execute in a
UNIX environment. The candidate was responsible for 'proving' this environment, developing standards and scripts to
run the batch COBOL modules, and performing usability testing. In addition, due to problems between the Sterling's
Key generated COBOL and the requirements of the Sybase COBOL pre-compiler, he wrote a 'pre-precompiler' that
modifies the COBOL into a form acceptable to Sybase. This included changing SQL statements from a DB2 to Sybase
accepted syntax and removing duplicate host variables.
Mikes initial assignment for the newspaper was to perform various duties for the Customer Service System. He was
involved with proving the viability of an environment that included batch COBOL programs running on UNIX and
accessing Sybase databases, CICS Open Server programs that processed OS/2 client requests for access to existing
mainframe IDMS databases, and mainframe IDMS batch programs that sent/received data to/from Sybase databases.
In addition to these duties, Mike was also a member the 'Change Control Team', aiding in encyclopedia management
and change control. The online portion of this new system was developed using Sterling's KEY Case tool (formerly
KnowledgeWare ADW), as well as some Visual Basic. The system was to be installed on client workstations running
OS/2. The database for this new system was Sybase. The on-line programming language was PM COBOL, compiled
using MicroFocus's OS/2 COBOL compiler. Access to the database was accomplished from back-end COBOL
modules that use Sybase Transact-SQL for the Sybase SQL-Server. Initial involvement with the project was to modify
online template modules, help develop project and coding standards, investigate methods to connect to segmented
databases on multiple servers, research methods for performing two-phase commits (including COBOL interface to 'C'
functions), develop standards for use of stored procedures and Sybase System 10 cursor processing, and update
existing GUI windows to these new standards and techniques.
07/1990 - 11/1993
Previous to his current assignment, the candidate was utilized for three years by a Big 6 accounting firm as a project lead
and technical resource in the development of a student loan servicing system. This complex environment consisted of
CICS, COBOL II, DB2, IMS, and tableBase. This application was developed using KnowledgeWare's ADW/IEW
and GAMMA CASE tools. As a project lead, he was the application architect for the financial subsystem. This major
portion of the system contained the core processing for the project, including calculation and amortization of loan
repayment schedules, interest accrual, interest capitalization, processing of payments, bill and coupon generation, and
loan balancing. His duties included analysis, batch cycle design, performance tuning, user training, test database creation,
and test plan coordination between the testing group and the developers. As a technical resource, he was responsible for
the development of standards for use by the project, as well as training and assisting all team members in the use of
various technologies. He was heavily involved in the analysis, design, coding, and testing of a key portion of the financial
subsystem.
07/1992 - 8/1992
Concurrent with the above project, the candidate was also involved with a major foods company. He assisted the firm in
the use of KnowledgeWare's ADW Design and Construction Workstations, and advised them of various methods and
procedures that could be implemented to enhance productivity and effectively utilize the tool. In addition, he designed,
developed, and tested a CICS, DB2 program for use as a model using ADW's Design and Construction Workstations.
11/1989 - 7/1990
On a previous project, the candidate was brought in by another Big 6 accounting firm as a key player in the development
of an oil and gas accounting package. This very large-scale project was developed in a DB2, CICS, TELON, and
COBOL II environment. The project also involved the conversion of batch COBOL IMS programs to COBOL II DB2
programs. His responsibilities included analysis, design, coding, and testing of 60 percent of the batch regulatory
reporting subsystem. In addition, he had total responsibility for all phases of an on-line and batch ad-hoc reporting
subsystem, and all phases of a batch severance tax calculation system. The candidate developed a "shell" program to
serve as the standard for other team members. For each of these subsystems, he was also responsible for the creation of
the JCL and TSO panels to run these programs. This included generation of JCL by three methods: (1) CICS programs
which submitted the jobs to the internal reader for batch execution, (2) JCL created and submitted by TSO/CLIST
panels and (3) standard JCL jobs and procedures.
In addition to these duties, the candidate also served on the technical support staff. He aided the DBA's in the creation of
a stress test environment, which included the definition of databases, table spaces, tables, and indexes. He calculated
space requirements and created and loaded stress test data. He also assisted the DBA's in performance and tuning
analysis of the DB2 programs.
10/1987 - 11/1989
Previously, he functioned as a chief designer and programmer for a batch and online system to handle inquiry of
customer invoices, reports, and invoice summaries for a large telecommunications company. This system was
implemented in a CICS, DB2 environment, using COBOL II.
The candidate has also served as Lead Analyst in the design and rewrite of a major telecommunications billing system.
Individual functions included high level and detailed system design, program development, test plan coordination, system
migration, and development procedures in a COBOL, ADABAS batch environment with some VSAM file interaction.
09/1987 - 10/1987
The candidate has also helped develop a major CICS and VSAM system for a tax collection and delinquency reporting
software package presently being marketed nationally.
03/1987 - 9/1987
He has also previously served as a project leader for a critical task tracking system for a financial trading company. His
tasks included overall project management responsibilities, such as scheduling task assignments for other team members,
tracking activities, and design of the database. In addition, he completed the general design and performed program
coding. He led the successful implementation of this system using IDMS/R and ADS/O as the development tools.
01/1987 - 03/1987
At a previous client, the candidate implemented components of the IDMS/CAS manufacturing software and created
programs to convert from IMS to IDMS for a helicopter manufacturer. His tasks on this project included COBOL,
IDMS/R, and ADS/O programming, testing, and analysis in a DOS mainframe environment.
08/1986 - 01/1987
On his first client project, he played a major role in the development of a generic questionnaire system for a major human
resources and benefits consulting firm. The environment was DATACOM/DB with CICS and COBOL. He was solely
responsible for implementing the Keyword subsystem of the Editor facility. This included design, programming, unit, and
system testing, as well as the testing of the link between the Editor and the Keyword subsystems.
04/1995 to Present
In addition to his consulting experience, the candidate has substantial managerial experience. He is currently responsible
for all aspects of the systems consulting firm of Oasys Consulting, Inc. This includes staff management, marketing,
recruiting, payroll, financial, and regulatory management.
08/1986 - 04/1995
He was previously a Senior Managing Consultant with a large consulting firm.
09/1978 - 08/1984
Prior to his data processing career he managed a staff of 40 union and non-union employees for a public water utility. He
was involved in virtually all aspects of the day to day operations of this company.
Member number:7280
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2001 Michael Robinson and Software Contractors' Guild,
Post Office Box 257,Nottingham, NH USA 03290-0257