Sql Developer Resume
4.00/5 (Submit Your Rating)
Jacksonville, FL
TECHNICAL SKILLS
- COBOL II, COBOL 370, IMS DB/DC, VSAM, DB2, SQL, QMF, SPUFI
- DB2 utilities, CICS, TSO/ISPF, MVS/JCL, Endevor, Panvalet
- Changeman, Librarian, File - AID, XPEDITER, SYNCSORT
- MS Winrunner, Visual Basic, Access, Microsoft office
PROFESSIONAL EXPERIENCE
Confidential, Jacksonville, FL
SQL Developer
Responsibilities:
- Corrected online program with queue overflow when loading from DB2 table
- Resolved reporting issue were service fee was being reported for wrong client
- Created new field on screen and the security for that field, both online and batch report
- Created two new screens and business logic modules for rate change project for consumer loans
- Reviewed changes at code review
- Unit tested code changes
- Platforms: Remediation and testing were done on the mainframe using FM, Cobol 370
Confidential
SQL Developer
Responsibilities:
- Trained on transaction based proprietary FM system
- Made coding changes to batch and cics programs causing Wamu accounts to process like Chase
- Reviewed changes at code review
- Unit tested code changes
- Platforms: Remediation and testing were done on the mainframe using FM, Cobol 370
Confidential
SQL Developer
Responsibilities:
- Made coding changes to process transactions for both old and new LPARs
- Ran unit and UAT tests on both LPARs
- Modified JCL to minimize maintenance for future store acquisition
- Created process to help with out of balance abends
- Platforms: Remediation and testing were done on the mainframe using JCL, Cobol II with DB2
Confidential
SQL Developer
Responsibilities:
- Researched critical datasets
- Documented jobs referencing critical datasets
- Converted datasets from tape to dasd disposition
- Set up Disaster recovery JCL
- Ran and verify correctness of Disaster recovery jobs
- Platforms: JCL changes and testing w8ere done on the mainframe
Confidential
SQL Developer
Responsibilities:
- Reviewed specs for accuracy
- Made coding changes, batch and online including reports and maps changes
- Ran baseline and Unit test
- Documented results and any discrepancies
- Led role in correcting comm. area mismatches because of new data
- Major contributor in meetings with client
- Platforms: Remediation and testing were done on the mainframe using JCL, Cobol II, CICS with DB2 and Install-1
- Reviewed specs for accuracy
- Mada coding changes, batch only
- Reworked JCL for unit testing
- Ran baseline and then parameterized versions with switch on or off
- Created fileaid compares of output to verify results
- Documented results and any discrepancies
- QA systems test for all remediated code.
- Platforms: Remediation and testing were done on the mainframe using JCL, Cobol II with Vsam files
Confidential
SQL Developer
Responsibilities:
- Created procedure and documentation for expanding IMS segments using MFE
- Performed analysis for programs effected by expansion
- Coded and tested changes to programs affected by expansion
- Performed code changes for iso2000 changes
- Created programs to transform old endorsements into new format
- Assisted in QA sytem testing
- Platforms: The ISO2000 changes are being coded in Cobol 370 and tested using MFE/MCS on the PC