Datastage, SQL, ETL, Netezza, Data Warehouse, Mainframe, Cics Develope

Resume of John H. Maas

**** **** ***** *****

Charlotte, NC 28262

704-***-**** Cell

*******@*****.***

Professional Skills

Project Leader – 11 years of experience

Managed up to 13 senior programmers on large scale projects. Managed onshore and offshore contractors

and demonstrated a proven ability to multitask and work on several projects at one time.

IBM Mainframe – 27 years of experience

Cobol I and II, CICS, BMS, XML, DB2, VSAM, JES, Z/OS, ISPF, CICS, TSO, FileAid, Endevor, Platinum,

Intertest, Spufi, QMF, JCL, Procs, Data Mapping, Business Objects Web Intelligence, SQL, FTP, TOAD

9.7.2., Expediter, ISPF, NDM, ABEND Aid, CA 7, Librarian, File Manager, Rexx, Changeman, ABEND

AID, Expediter, SQL, IBM Batch Pipes, Roscoe, EZtrieve, Stored Procedures, Agile Methodology.

Developed test plans and scripts.

Informix/Unix ETL/DataStage – 5 years of experience

Linux, ETL, DataStage 8.5, Director 8.5, Data Lineage, QualityStage, Metadata Workbench, Autosys,

Netezza Data Warehouse, Unix, Scripting, Aginity, FastTrack, Agile Methodology. Wrote 215 DataStage

jobs and sequencers. SSIS Sequel Server Integration Services.

AS/400 – 6 years of experience

Cobol/400, RPG I thru IV and RPG/400, QUERY/400, CL, DFU, SEU, PDM, IDDU, DDS.

JD Edwards on Unix Environment – 2 years of experience

JD Edwards 8.12, Oracle, JD Edwards 8.96 toolset, Report Design Aid, Object Management Workbench,

Batch Versions, TOAD 9.7.2.

Microsoft – 22 years of experience

Word, Excel, PowerPoint, Visio, MS Office Suite

Professional Experience

Compass Group September 2014 to April 2015

Charlotte, NC

DataStage/Data Warehouse Developer

• Oversaw and building and implementation of databases and file structures.

• Retrieved data from multiple sources and worked to generate XML, DOS, and Unix versions of this

data.

• Met with end users bi weekly and discuss project needs and strategies for various projects.

• Worked with SQL on DB2 and Unix to perform Perl Scripting and Unix Scripting.

• Copied the retrieved data to VM’s using FileZilla and wrote DataStage 8.5 jobs and sequences that

transformed the data then loaded the results into Netezza Databases.

• Wrote Unix scripts inside and outside of DataStage jobs.

• Utilized Aginity to verify the written results in Netezza databases

• Wrote 155 DataStage jobs to date.

• Used Director 8.5 for debugging.

• Worked with Visual Studio to track tasks per Agile Development.

• Utilized SSIS Sequel Server Integration Services.

Vanguard Group June 2014 to September 2014

Charlotte, NC

Mainframe Programmer

• Acted as project lead to manage on shore contractors.

• Performed all work in the Institutional Systems area.

• Worked with CICS, TSO, COBOL, VSAM, CA Easytrieve/Plus, Insync, Apptune, Endevor,

DumpMaster, JCL, batch and online programming.

• Utilized tools which included MicroFocus Mainframe Express and Intertest and worked on a Z/OS

operating system.

Bank of America September 2010 to September 2014

Charlotte, NC

Senior Programmer/SME – Permanent Employee

• Served as the Senior Programmer/SME in the Customer Systems area.

• Designed and managed projects by using XML, XSD, Cobol II, DB2, TSO, Z/OS, IBM Utilities,

SPUFI, DCLGEN, VSAM, ISPF, TSO, FileAid, SAN (Shared DASD), FTP, NDM, Stored

Procedures, and IBM Batch Pipes.

• Worked with SQL on DB2, Oracle and Unix to perform Perl Scripting and Unix Scripting.

• Conducted code reviews.

• Wrote BRD’s, HLD’s, and LLD’s.

• Managed all projects via DMAIC (Design, Measure, Analyze, Improve, and Control) processes.

• Acted as the Release Lead on 24 releases.

• Involved in migration from mainframe to Data Integration platform using: Agile process, Linux,

ETL Informatica, DataStage 8.5, QualityStage, Metadata Workbench, FastTrack, Autosys, and Data

Lineage.

Gained an understanding of business objects and SSRS reports.

•

Bank of America May 2010 to September 2010

Charlotte, NC

Remote Contract Mainframe Developer

• Worked on Programming Commercial Leasing systems using XML, Cobol II, DB2, VSAM, ISPF,

CICS, TSO, FileAid, NDM, WebSphere MQ Series.

Fidelity Investments September 2009 to December 2009

Raleigh, NC

Contract Developer

• Worked with programming systems using XML, Maui, Cobol II, DB2, VSAM, ISPF, CICS, TSO,

FileAid, Endevor, Platinum, Intertest, Spufi, QMF, and JCL on an IBM mainframe Z/OS.

• Wrote all CICS programs written on mainframe backend with web based Java front end.

• Systems involved were investment financials and brokerage.

• Installed all new and modified modules into production error free.

American & Efird INC. September 2005 to May 2009

Mt. Holly, NC

Developer/Project Leader

• Managed in house and off shore JD Edwards 8.12 reporting project.

• Used 8.96 Toolset and other tools included Report Design Aid, Object Management Workbench,

Batch Versions, Business Objects Web Intelligence, Visio, SQL, Oracle, and TOAD 9.7.2.

Applications were both manufacturing and finance.

• Managed and programmed large systems in Cobol II, VSAM, ISPF, TSO, CICS, BMS, FileAid, and

JCL on an IBM mainframe.

• Developed business functions and test cases. Systems involved manufacturing, Supply Chain, and

financial applications.

• Performed multiple tasks which included: writing new programs, Data Mapping, modifications,

analysis, writing technical and user manuals.

• Managed up to 7 programmers on different projects.

• Performed all work using System Development Life Cycle SDLC.

• Reduced inventory planning time from 5 days/week to 1.5 days/week.

Advanced Software INC January 2002 to June 2005

Charlotte, NC

Contract Programmer

• Programmed and consulted on systems written in Cobol II, RPG/400, RPG III, VSAM, CICS, DB2,

QMF, SPUFI, and JCL on an IBM mainframe and AS/400 Cobol systems involving different

banking and financial applications.

• Worked with SQL on DB2 and Unix to perform Perl Scripting and Unix Scripting.

Performed all tasks which included writing new programs, modifications, and analysis.

•

Related software: Expediter and Endeavor.

•

Performed work using System Development Life Cycle.

•

Completed all work flawlessly ahead of schedule.

•

Duke Energy January 2000 to January 2002

Charlotte, NC

Contract Programmer/Technical Writer

• Programmed systems in Cobol II, VSAM, ISPF, CICS, and JCL on an IBM mainframe.

• Involved systems were for Emergency Service Restoration.

• Performed duties included writing new programs, modifications, and analysis.

• Documented all systems using Word.

• Used other systems involved for project costing and accounting.

• Performed work included new programming and modifications as well as analysis and design.

• Developed business functions and test cases.

• Related software included PeopleSoft and SQR.

• Wrote all technical documentation for projects.

Education

Appalachian State University B.S. Degree: Computer Science Minor: Mathematics

Contact this candidate