Johann Dekker
Cobol/DB* Developer
e-mail: *************@*****.***
***** ********** *****, ***** *******, CA 91355
Status – US Citizenship
TECHNICAL SKILLS
COBOL II, DB2 STORED PROCEDURES (IBM Data Studio 2.2), SQL, CICS, VSAM, IDMS, MQ, XPEDITOR, INTERTEST, TSO, FILEAID, JCL, PANVALET, ENDEAVOR, UNIX, JAM, ORACLE, MS Office.
EXPERIENCE SUMMARY
• Application development using Cobol, SQL/DB2, Stored Procedures, JCL
• Participated in all aspects of SDLC
• Requirements definition and program specification and design
• Responsible for test plans, unit testing, system integration testing
• Data extracts and analysis in support of testing and quality assurance
• Application support
• Experience working in cross functional team using Agile methodology
• 4 years experience in telecommuting
• Financial and Gaming industries
PROFESSIONAL EXPERIENCE
04/2010 to 2011 – Glacier Financial Solutions, Tygervalley (Consultant – Paracon SA (Pty) Ltd, Cape Town, South Africa) - (Pty) Ltd.
DB2 Cobol, Stored Procedures, SQL, JCL
Major achievements
• Analysis and design of modules to rectify pricing related data for investment funds covering 2 years’ worth of data. Process called for the creation of approx. 200+ files, developed validation routines written and performed to verify database and SAP system.
• Analysis, design and development of data transfer and database upload of stock broker data between Glacier and external Stock Brokers. Project required liaising with external client IT resources to define specifications for file layouts and transfer processes. Worked closely with client resources during development and testing phases.
• Part of a team that re-engineered and developed Glacier’s online system. Requirements analysis, detail program specifications, development of DB2 Stored Procedures, participated in test plan development and end to end testing with front end. Project managed by Agile methodology.
07/1997 to 2008 - Lehman Brothers Jersey City, NJ, USA (Consultant)
Cobol, DB2, Stored Procedures, CICS, IDMS, VSAM, MVS/JCL, MQ protocol
Major achievements
• Design and development of Fixed Income application used in tracking of interest payments and pay-downs.
• Regulatory reporting of trade data.
• Database access routines written in DB2/stored procedures servicing VB front-ends.
• Sub-system to re route failed trades through the FPS process.
• Wrote programs for the conversion of Bear Sterns.
• Wrote CICS modules utilizing MQ protocol, for the MTS/Cameo Bank Link.
• Analysis and enhancements to optimize performance of the critical path applications.
• Production support of Batch cycle.
05/94 to 06/97 - Automated Wagering Hackensack, NJ, USA
Lottery and Gaming industry
Unix, JAM, Oracle, C and Microfocus Cobol
Major achievements
• Development Lead for all COBOL development and support.
• GUI, database development, validation and installation for a sports betting and lottery system. Liaised closely with user situated in Norway
• Production Support.
07/90 to 04/94 - Lehman Brothers Jersey City, NJ, USA (consultant - RCG Consulting, Paramus, NJ)
COBOL, IDMS, VSAM and JCL
• Designed, coded and implemented a process to monitor all NDM transfers.
• Ad hoc report programs.
• Modified and tested all programs(100+) that referenced the coupon rate.
• System enhancements and support.
09/89 to 05/90 - Pam Am, Rockleigh, NJ, USA (consultant - RCG Consulting, Paramus, NJ)
COBOL II, DB2 and JCL
• DB2 development to capture Frequent Flyer miles
EDUCATION
Purchasing Management - Cape Town Technicon, South Africa
Computer Programming Diploma (1989) - CPI Business School, Paramus, New Jersey, USA