Sql Developer Resume Profile
PROFILE
Dedicated, Information Technology IT professional, providing 15 years of mainframe and object-oriented technical experience in the areas of Systems Analysis and Application Design with background in the Healthcare, Automotive, Financial, Transportation, Retail and Wholesale industries. A skilled senior / lead Mainframe Programmer cable of fulfilling roles in several IT areas: analysis, development, production support, database administration, security administration, quality assurance and change management willing to relocate.
TECHNICAL SKILLS AND KNOWLEDGE |
TECHNICAL SKILLS KNOWLEDGE
- Languages: COBOL, Visual Basic, HTML, Javascript, FOCUS, WebFocus Easytrieve, SQL, JCL, DCL, C, C
- Databases: DB2, IMS, CICS, Sybase 8.0, VSAM, MS Access, Oracle
- Management Tools: Changeman, Endeavor, DCCS
- Transfer Tools: Network Data Mover, File Transfer Protocol
- Applications: ABC Flow Charter, Abend-Aid, CA-7, Crystal Reports, FileAid, JES, Lotus Notes, MS Office Suite,
- Microsoft Outlook, RACF, SPUFI, SYNCSORT, Viso Pro, Xpediter
- Operating Systems: Windows 95, 98, 2000, XP, 7 , MVS, TSO/ISPF, VM/VSE, VAX
- Methodologies: SDLC, LEAN, SIX SIGMA
PROFESSIONAL EXPERIENCE |
PROFESSIONAL EXPERIENCE
Confidential
- Environment: IBM TSO/ISPF, COBOL, JCL, DB2/SQL/SPUFI, IMS, Visual Basic, Changeman, XPEDITER, MS Access, RACF, CA-7, FTP, SYNCSORT, IBGENER, FOCUS, MS Outlook, VSAM, IDCAMS
- On assignment as a Cobol Programmer/Quality Assurance Tester at Navistar in Lisle, Illinois. Duties include developing COBOL/FOCUS batch programs and related JCL to conduct quality assurance tests for Marketing and Retail Accounting System MRAS Decommission project.
Confidential
Environment: VAX, COBOL, FOCUS, DB2, SQL, DCL, Lotus Notes
On assignment as a Mainframe Tester and Programmer at Ryder Logistics in Novi, Michigan, accomplishments include establishing standardized procedures and policies for change management through the team LEAN process and was awarded two 100 gift certificates for this and other suggestions. General duties included enhancing VAX FOCUS and COBOL mainframe batch and interactive invoice programs plus related DCL, creating new FOCUS transportation accrual cost programs, generating new and updating DB2/SQL tables, writing and implementing project test plans, providing business requirements and project estimates, producing technical and user system documentation.
Confidential
Environment: IBM TSO/ISPF, COBOL, JCL, DB2/SQL, Visual Basic, EasyTrieve, Network Data Mover,
- DCCS in-house change management application , Lotus Notes, SYNCSORT, IBGENER
- Completed all aspects of the SDLC life cycle phases of Chrysler Financial and Daimler Financial system separation for three financial system. Gathered business requirements, composed required documentation and obtained authorization of work. Modified, tested and implemented a minimum total of 50 mainframe online CICS, batch COBOL, Easytrieve and related JCL programs for financial systems mainframe Dealer Reserve and Added Value Coupons. Updated functionality for Visual Basic 6.0 financial application Chargeoffs including related DB2 tables, data files and Crystal reports. Setup new jobs schedules. Separated data files with IBGENER and data within files using SYNCSORT. Produced documentation as required for three rounds of testing.
Confidential
Environment: IBM TSO/ISPF, COBOL, JCL, CICS, Sybase/SQL, Visual Basic, Crystal Reports, Endeavor,
- Lotus Notes, VSAM, IDCAMS, SYCSORT, IBGENER, FTP
- Highlights as a Lending Technology Credit Systems team member include converting a six hour manual process into automated mainframe process by producing COBOL/JCL batch programs and secure FTP delivery process of customer reports/address files which eliminated SOX violations. Developed a Visual Basic application to track differences within Sybase SQL tables containing mortgage application information. Programs produced Crystal reports that identified errors and data was reconciled. In one month successfully completed 30 system enhancements and 10 required process changes for Loan Tracker, a Visual Basic mortgage application, after a two year halt of the project.
Confidential
Environment: IBM TSO/ISPF, COBOL, JCL, DB2/SQL/SPUFI, IMS, Visual Basic, Changeman, XPEDITER,
MS Access, RACF, CA-7, FTP, SYNCSORT, IBGENER, FOCUS, MS Outlook, VSAM, IDCAMS
Accomplishments include:
- Served as the NESC subject matter expert on Health Update to Dependent Database web system HUDD project. Role called for analyzing system, developing COBOL/DB2/IMS specifications and conducting code reviews.
- Served as lead of NESC Systems team assisted other team members, provided specifications, advised supervisor s on assignments, conducted training courses and composed related documentation on new features and applications when required, scheduled job using CA-7 responsible for system security.
- Reworked GEN monthly reporting process, breaking up a 20 step JCL job into three smaller, logical jobs, adding a FOCUS program to determine job parameters in place of manual calculation and updating COBOL programs to forward file status data to JCL jobs. Enhancements eliminated parameter errors, job reruns and programmer intervention.
- Developed MS Access joint UAW/FORD NESC Employee Training application which listed course information, tracked enrollment and produced reports used to evaluate employees. Developed MS Access Project List System used by management to track the status and progress of team projects.
- Completed Sarbanes-Oxley SOX analysis of NESC and resolved violations.
- Decommissioned EMS COBOL/JCL, DB2 tables and data files