Jerry Roberson
180 Clerk Street
Jersey City, NJ 07305-4425
201-946-9314(home)
201-780-1667(cell)
jeyroberson@gmail.com
SUMMARY:
An expertly skilled data-processing professional, with extensive experience in all facets of the software development
life cycle, from initial specification and application design, to legacy-to-relational conversion of mainframe DBMS systems.
LANGUAGES & DBMS'S:
COBOL II, DC-COBOL, MicroFocus COBOL, EZTrieve +, DYL-260/280, Datacom/IDEAL, IDMS DB/DC, ADS/O, SQL, Focus,
DEC DCL, CICS(Command Level), IMS DB/DC, DB2, VSAM, Culprit, SQL Server 7.0, ORACLE, Java, ANT Scripting
PACKAGES:
MSA AMAPS/Q, CAS 1.2 & 1.3, McCormack & Dodge, Genesys,
AMSoft (ASI), Dun & Bradstreet (GL/E, FC/E, CP:M, IE)
APPLICATION ENVIRONMENTS:
Aerospace, Airline, A/P, A/R, Banking, Billing,
BOM, CRM, Customer Service, G/L, Insurance, Inventory, Manufacturing, Purchasing, Railway, Real Estate, Retail, Sales/Marketing,
Telecommunications, Time & Attendance, Utilities
ANCILLARY SKILLS:
Eclipse, MicroFocus Mainframe Express, Net Express,
Microsoft Visual Source Safe, JCL(OS, DOS, MVS), TSO/ISPF, VM/CMS, Roscoe, Wylbur, Panvalet, Endevor, Librarian, Lotus Notes,
MS Word/Excel/Project, Oracle CEDF, Intertest, Expeditor, ADS Alive, Online Debug, CICS Playback, CA7 Scheduler, DEC
Scheduler, SV2000 Xchange, DB2 Move/Access/Compare, IBM MQ(Message Queue), SQLizer, DL/1, TPI, QMF, Spufi, BMS, Tpsort, OLP,
DME, OLM, IDD, DML/O, LRF, SSC, Schema, OLQ, ADS/A, ADS/G, Crystal Reports
EXPERIENCE:
2004 - Present Xitec Software, Inc. Stamford, CT
Sr. Technical Consultant
Responsible
for conversion/migration of mainframe IDMS databases and applications to relational replacements such as Oracle and DB2. Duties
include data collection, data structure analysis and validation, data conversion and population, application integrity analysis,
conversion code modification, application testing(using both customer-supplied and automated testing scripts). Assisted in
every facet of customer support from demonstrations for potential clients, to final delivery of finished products. Expertise
was gained in the use of Java, ANT Build Scripts, and the Eclipse platform.
2002 - 2004 Bi-State Development Agency St. Louis, MO
Consultant
Responsible for IDMS programs
within the CAS General Ledger system. Automated G/L reversal process. Wrote conversion programs to assist Payroll in switch
from Genesys to Cyborg. Responsible for mainframe support of Payroll, Accounting, and Procurement departments. Performed major
system PTF upgrade to CAS Master Production Scheduling (MPS), MRP, Inventory, and Purchasing applications. Created process
to automate Budget load for FY04 from Adaytum to CAS G/L. Assisted Internal Audit department with data extracts. Responsible
for administration of the Kronos NextTrak Time and Attendance software, utilizing SQL Server 7.0 and Crystal Reports.
07/2001 - 12/2001 Nabisco, Inc.
Parsippany/East Hanover, NJ
Consultant
Responsible for IDMS conversion
programs within the CAS Purchasing modules to integrate Nabisco's systems with Kraft's systems following the acquisition of
Nabisco by Kraft. Various duties related to A/P Integration and the Stella D'Oro conversion process.
10/2000 - 06/2001 DST Interactive, Inc.
Charlotte, NC
Software Engineer III(Consultant)
Responsible
for project management, functional requirements specifications, detailed program
designs, coding, analysis, problem resolution on the Subscriber Transaction Management System(STMS), in a DEC/VAX environment
using ORACLE 7.1. The STMS is a CRM product for the largest direct broadcast satellite provider in the country.
03/2000
- 10/2000 Carefirst BC/BS
Washington, DC
Consultant
Sr. Programmer Analyst responsible
for automating ftp processes between the mainframe and various client companies. Responsible for client ID card software.
Responsible for invoice software. 90% of work done on the mainframe, using COBOL and DB2.
08/1998 - 12/1999 UMMS,
Inc.
Baltimore, MD
Consultant
Sr. Programmer/Analyst working
for the University of Maryland Medical Systems (UMMS). Worked as technical support analyst on existing Cullinet/IDMS financial
applications. Assisted in implementation/testing of OS/390 operating system upgrade. Supported Genesys Payroll system software,
including revisions to over 150 COBOL programs for software upgrade to release 5.5. Performed Y2K software remediation/testing,
initially through windowing techniques, later through upgrade of COBOL compiler to provide 8-digit dates. Participated in
on-call rotation to support all mainframe applications.
01/1998 - 08/1998 AAR/Railinc,
Inc.
Washington, DC
Consultant/Team Leader
Team
lead in an on-going development effort for the Association of American Railroads (AAR/Railinc). Work involved various types
of Equipment Tracing, Transfer-of-Liability, and Haulage routines, using DB2 and IBM s MQ (Message Queue) technology. Responsible
for 6-9 programmers. Worked closely with the client's DBA staff concerning timing of database table revisions necessary to
accommodate program specifications. Assisted in the design of programming standards, organized code walk-thrus, and provided
timely turnover and support to the client's QA staff. Coordinated turnover of new releases of software.
07/1997 -
01/1998 Sallie Mae
Reston, VA
Consultant/Team Leader
Team
lead on a Year 2000 Conversion project. Responsible for 3 - 5 programmers. Utilized System Vision 2000 product to analyze
entire libraries of COBOL code. Created detailed project plans using MS Project. Coordinated code walk-thrus, conducted peer
reviews, prepared SDLC documentation for turnover to QA department. Wrote and executed test plans. Served as liaison between
user community and junior programming staff. Instructed programming staff in usage of Xpeditor/Xchange (Year 2000 date modification
product), and Compuware's DB2 Move/Access/Compare (Year 2000 data aging product). Entire Acquisitions subsystem of Sallie
Mae's CLASS system converted to be Year 2000 compliant. Assisted with analysis/design phase of Originations and Servicing
subsystems.
04/1997 - 07/1997 Fannie Mae
Washington, DC
Consultant
Mainframe coordinator for Fannie Mae's IRW Pilot
Application. Responsible for collection of mainframe data, ftp transfer of mainframe data to the UNIX server environment for
display on Fannie Mae's web page. Responsible for scheduling and coordination through CA7.
05/1995 - 04/1997 Saks Fifth Avenue
Dallas,
TX
Consultant
Responsible for
code maintenance, application design changes, timely problem resolution and application performance tuning for the Quick Response
Team at Saks
Fifth Avenue
in New York
City. Converted LRF code to native DML within IDMS batch COBOL/COBOLII programs and ADS/O dialogs. Duties included
on-call support.
11/1994 - 05/1995 Federated Systems Group
Norcross, GA
Consultant
Responsible for numerous changes
to programs within the credit division. Worked on batch Datacom programs using COBOL and COBOL II. Increased functionality
of location-specific (retail store) logic for processing of Pier One stores.
05/1994 - 10/1994 L. L. Bean, Inc.
Freeport, ME
Consultant
Responsible for work on three different projects.
Made extensive modifications to the existing CICS/VSAM-based Gift Certificate System. Assisted with database design and concurrent
processing logic for the new DB2 Gift Certificate System, to be implemented in 1995. Wrote several Datacom/IDEAL programs
for the Telephone Response System.
03/1994 - 05/1994 Michelin Tire Corporation
Greenville, SC
Consultant/Help Desk Leader
Short-term return assignment,
at the client's request, to assist in the formation of a help desk. Prepared turnover documentation, and production JCL procedures
for the CP:M system. Made modifications to the nightly CP:M batch job stream resulting in over 75% improvement in processing
efficiency. (See October 1993 to January 1994)
01/1994 - 03/1994 Broadway & Seymour, Inc.
Charlotte, NC
Consultant
Working with COBOL II in a CICS/VSAM environment
on the NationsBank PACE/AM Trust project. Worked on Options, Cash Projections, and other sub-systems. Assisted staff in resolution
of Testing Problem Reports (TPR's).
10/1993 - 01/1994 Michelin Tire Corporation
Greenville, SC
Consultant
Worked with various Dun & Bradstreet Software
(DBS) application software packages, including General Ledger (GL/E), Financial Controller (FC/E), and Capital Projects CP:M).
Assisted the accounting users in implementing many new reports written using Information Expert (IE). Worked closely with
users to convert existing software to the DBS CP:M environment. Designed and wrote extract programs to interface data in the
CP:M file formats with other systems.
03/1993 - 10/1993 Delta Air Lines
Atlanta, GA
Consultant
Working with DB2 and COBOL II in an Arthur Andersen
INSTALL/1 environment. Project was Maintenance and Rebuild Control(MARC). Worked from specifications written using DESIGN/1.
Worked on maintenance event creation, product structure, and materials management subsystems. Worked very heavily on the data
conversion portion of the project. Assisted in training of Delta personnel in the efficient usage of DB2, with both embedded
SQL, and using the INSTALL/1 ADAM interface.
02/1993 - 03/1993 American Greetings
Cleveland, OH
Consultant
Short-term return assignment assisting
Ernst & Young with database design for a former client on an IDMS order processing system, using Arthur Andersen's METHOD/1.
Worked closely with the database group to develop efficient access standards, and participated in fine-tuning existing database
architecture. (See August 1988 to December 1988).
03/1992 - 02/1993 American Software
Atlanta, GA
Database Administrator
Worked within the database group
on various projects. Worked exclusively on AMSOFT mainframe package software. Applications included bill-of-materials, product
costing, and accounts receivable. Client specific modifications were made using IDMS, DB2/SQL w/CICS, and VSAM.
03/1992
- 02/1993 Consumer's Power
Jackson, MI
Consultant/DBA
Worked on the Workload Information
Network (WIN) system (release 5.32). Designed database structure and necessary processes to facilitate archival of historical
work orders. System used IDMS queue and scratch processing extensively. Designed processes to reduce excessive maintenance
coding using OLQ qfile processes. Responsible for specifications and procedural guidance for several members of the programming
staff. Assisted client DBA staff in preparations for database expansion. Made presentations to client staff on use of programming
techniques, automated processes for user testing and correction of invalid production data.
08/1991 - 03/1992 Progressive
Insurance
Cleveland, OH
Consultant
Worked on the Lender's Collateral
Protection (LCP) system. Coded, tested, and implemented changes for variety of banking clientele in a VSAM/COBOL environment.
Assisted in conversion of data from various tape formats to compatible VSAM file formats.
01/1990 - 02/1991 GE Aerospace
Utica, NY
Consultant/DBA
Responsible for database design and alterations;
analysis and comparison of old/new business functions. Coded programs for conversion of data from old to new IDMS database,
using McCormack & Dodge package software. Designed, coded, tested, and implemented new addition to Purchase Order Entry
system to accommodate Shipping Notices. Assisted junior staff and DBA staff in troubleshooting conversion problems.
08/1989
- 01/1990 ROLM Systems, Inc.
Santa Clara, CA
Consultant
Responsible for coding, testing, and implementation
of an on-line replenishment system for warehouse and shop floor personnel, using MSA AMAPS/Q software. Responsible for detailed
(program-level) design of a Physical Inventory system. Coded, tested, and implemented a total of seven (7) screens and 16
batch reports/file-utility programs. Used DB2/SQL for Physical Inventory reports.
04/1989 - 08/1989 Glidden Corporation
Cleveland, OH
Consultant/DBA
Responsible for designing,
coding, testing, and implementing portions of Customer Service system. Wrote approximately 30 ADS/O dialogs. Designed database
conversion strategy; coded 12 COBOL load programs for data conversion. Used OLQ extensively for database reporting. Used TPSORT
within ADS/O dialogs.
03/1989 - 04/1989 DOW Chemical Corporation
Cleveland, OH
Consultant
Analyzed and documented Inventory
Control system being implemented by another consultant. Reviewed requirements, cross-referenced to actual programs, wrote
user documentation manual.
12/1988 - 03/1989 Loral Corporation
Akron, OH
Consultant
Designed, coded, tested, and implemented
front-end Billing system for use with Cullinet's A/R package (CAS 3.1). Worked closely with users in design/feasibility studies.
08/1988 - 12/1988 American Greetings
Cleveland, OH
Consultant/DBA
Worked on design and analysis
of an Inventory Control sub-system to be integrated with existing Cullinet software (CAS 3.1). Designed software to facilitate
downloading of a portion of production data to an off-line system test database. Worked closely with DBA staff to implement
major database design revisions. Assisted junior staff members with debugging and design revisions. Served as a member of
design walkthru team.
06/1988 - 08/1988 Data-Link Corporation
South Bend, IN
Consultant
Worked on design of a front-end
processor to allow programmers to design screens without knowledge or proficiency in CICS, using Fast Programming System (FPS).
Language was limited in its use, as all screens had to be built using 1K or less of screen storage area.
01/1988 -
06/1988 Zimmer Corporation
Warsaw, IN
Consultant
Used COBOL in an IMS/VS environment
to rewrite existing Sales and Marketing system. Resulted in a performance increase of 45 percent, in addition to savings of
approximately $35K per month in operating costs.
10/1986 - 01/1988 Whirlpool Corporation
St. Joseph, MI
Consultant
Major
focus was on Cullinet's manufacturing system (CAS). Developed application structures and prototypes using ADS/A and implemented
several major database changes. Worked on both the Shop-Floor Control and Bill-of-Materials systems. Other projects included
a rewrite of the Physical Inventory system (formerly written using CICS) to be integrated with the Manufacturing Control system;
troubleshooting and timely design for the Financial system; provided in-depth database lookup techniques for the staff; training
of inexperienced personnel in the use of ADS/O and related IDMS utilities.
03/1986 - 10/1986 Southern Company Services
Atlanta, GA
Consultant
Work was done on a Maintenance system for a nuclear
power plant (NPMIS). Worked on the database logical design, wrote portions of the schema, responsible for coordination of
independent subschemas with other programmers' needs. Contributed to IDD definition and population. Participated in database
design walkthrus, code walkthrus, wrote ADS/O dialogs, and used ADS/A to integrate dialogs within applications. Responsible
for direction and supervision/training of junior corporate personnel on the project.
10/1985 - 03/1986 Georgia-Pacific Corporation
Atlanta, GA
Consultant
Worked on an IDMS Financial Reporting
system (FIRS). Wrote ADS/O dialogs, assisted other programmers in writing and debugging dialogs. Wrote COBOL and CULPRIT programs
(both regular and ad-hoc) to access the database.
06/1984 - 10/1985 Martin-Marietta Data Systems
Greenbelt, MD
Consultant
Worked on the Department of Labor's
Federal Employees' Compensation system (FECS). Designed and coded ADS/O dialogs, reviewed and corrected dialogs written by
junior programmers, and served as a general ADS/O consultant. Used the Logical Record Facility (LRF) extensively.
08/1982
- 06/1984 TELIC, Inc.
Rockville, MD
Programmer
Used CICS and IDMS to write software specific
to the long-distance Telephone industry. Some work was done on Hewlett-Packard HP-3000 systems.
01/1980 - 08/1982
Allegany Community College
Cumberland, MD
Programmer
Worked with COBOL in an NCR environment.
EDUCATION:
05/2001 Enlightened Leadership Int'l US-NC-Charlotte
Certification in Managing For Success
03/2001 Mind IQ/COMPAQ
US-NC-Charlotte
Certification in Open VMS DecForms Programming
03/2001 Franklin Covey
US-NC-Charlotte
Certification in The 7 Habits of Highly Effective People
04/1992 Platinum Technology
US-GA-Atlanta
Certifications in DB2 Application Programming &
DB2 Database Administration
09/1989
IBM Educational Services US-CA-Santa
Clara Certification in DB2 Application Programming
MILITARY SERVICE:
06/1977 - 06/1978 United States Air Force US-CA-Merced
Security Police Officer
US-TX-San Antonio
Honorable Discharge