SUMMARY

• Over twenty years’ of experience supporting mission critical applications in business systems analysis, production, database administration and programming roles, including extensive experience conducting root cause analysis, issue triaging overall production support analysis.

TECHNICAL SKILLS

Programming Languages: SQL, PERL, JAVA, ASP, HTML, COBOL, DOS, MVS JCL, CULPRIT

Relational Database Management Systems: ORACLE, IDMS COBOL, MYSQL, Microsoft Access, IDMS ADSO

Operating Systems: LINUX, UNIX, MVS JCL, VSE/SP 3.1

Tools: OLM (Online Mapping), TSO/ISPF Interface

Skills: Design, Acceptance Criteria, Systems Analysis, Software Development and Testing, Project Management, Configuration Management

PROFESSIONAL EXPERIENCE

Mainframe Programmer

Confidential, Oakton, VA

Responsibilities:

• Developed and modified IDMS COBOL programs.
• Modified JCL and Procs to include parameters to allow multi environment execution.
• Managed version control via ENDEAVOR.
• Created Packages (consisting of COBOOL program, JCL and/PROCS) for production deployment
• Generated daily, monthly and quarterly client reports.
• Produced program SQA packages to include source code, superc, specs, and test plan and test results.
• Responded to and resolved issues via ServiceNow process.
• Prepared documentation and instruction on generating reports.
• Prepared documentation and instructions for scheduling jobs wif dependencies and follow up actions
• Managed response resolution for nightly job alerts from Production Service
• Developed reports using CULPRIT

Mainframe Programmer

Confidential, Washington, DC

Responsibilities:

• Modified existing ADSO dialogs and maps.
• Maintained process and adding elements using Integrated Data Dictionary.
• Debugged ADSO dialogues using tools such as ADSALIVE
• Adapted existing COBOL and ADSO programs to meet requirements.
• Assessed and developed appropriate IDMS COBOL programs to pass XML data and certain IDMS database records to that called program and necessary return code determining if the Database would be updated or not.
• Developed test scripts and test results (including screen prints of before and after results)
• Modified Program Design Document (PDD) for program work to include applicable input/output changes added to the program.
• Provided production management including job statistics, recording records and assuring jobs ran as planned and triaging issues identified.

Production Systems Analyst

Confidential, Washington, DC

Responsibilities:

• Developed Perl script that would upload previous month’s text files to the hard drive and delete it from the File Transfer process directory. The program would add these text files to a zip file, which would be downloaded to the file transfer process directory. Files would then be deleted from the hard drive.
• Developed Perl script to download daily, weekly or monthly reports from the Local Area Network (LAN) to the hard drive. Script would then rename the report to include the date, and then add it to the zip file (that also included the date). The zip file would be password protected. Script would e - mail the zip file to the respected personnel.
• Developed Perl script that included SQL “select” statement that would retrieve data between two dates. The data would be inserted into an excel spreadsheet. The script would format and sort the data by a certain date.
• Developed and/or modified Perl/DOS scripts for the following interface; DOS, NIV, CLAIMS, I901 US VISIT and ADIS. Many of the modifications or enhancements dealt wif new business theories.
• Modified all Perl scripts for the interfaces when Homeland Security went from File Transfer Process to Secure File Transfer Process. To accomplish this feat, a third party software (Chilkat) was used along wif Perl.
• Modified all Perl scripts to give the user options to run the scripts for certain dates or to create certain reports. The user would then has to enter the date or keyword after entering in the program name.
• Facilitated and scribed monthly interface meetings.

Production Systems Analyst

Confidential, Washington, DC

Responsibilities:

• Developed and implemented program that collated information from Central Index System (CIS) pinpointing U.S. location of aliens from a specific country during a specific time-frame
• SDLC - Worked in all stages of the SDLS, including collaborating wif coworkers, planning updates, implementing changes, documenting changes, peer review, regression testing, and deployment to production.
• Developed and modified COBOL programs
• Created, maintained and executed test plans.

Systems Analyst

Confidential

Responsibilities:

• Maintained the Confidential Government “Alien Tracking” System regarding students immigrating to U.S.
• Tracked and maintained critical application processes to ensure reports were created on time, data updated accurately and that the online systems were up and running on-time
• SDLC - met wif the client to design the screens, reports, elements that made up the records. Met wif the DBA to create the records and areas. Developed the program and tested. Then showed the client what the outcome would be just in case there were changes. After the client signed off it was put into production. me then had to create the document describing the screens, reports and what the program did.
• Produced a PowerPoint slide show on how the system works for training purpose.
• Developed VISIO diagrams in the document to show system use, program flow and layouts.
• Developed and modified - IDMS ADSO and IDMS ADSA. Developed the Online Mapper.
• Developed and changed COBOL programs that updated the database or created reports.
• Created and maintained the systems website