SUMMARY:

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

CORE COMPETENCIES:

• SQL PERL ORACLE DBA IDMS DBA JAVA MYSQL XAMPP VSE/SP 3.1 Panvalet DOS BATCH HTML OLM (Online Mapper) ASP IDD (Integrated Data Dictionary) IDMS COBOL IDMS ADSO TSO/ISPF MVS JCL and Utilities CULPRIT Microsoft Word Microsoft Access Design Acceptance Criteria Systems Analysis Analyst Software Development Usability Manual Testing Project Management Configuration Management LINUX/UNIX - Level I & II

PROFESSIONAL EXPERIENCE:

Confidential, Oakton, VA

Mainframe Programmer

Responsibilities:

• Modify existing IDMS COBOL programs.
• Modify JCL and Procs to include parameters.
• Using ENDEAVOR to modify the program, compile the program and move the program from one environment to another. Creating Packages so that the JCL, Proc and Source can be moved to Production.
• Responsible for executing daily, monthly and quarterly reports. Sending them to the client using WINZP to zip and encrypt the file.
• Creating SQA package for each program assigned to me. The package consists for source code, superc, specs, test plan and test results.

Confidential, Washington, DC

Mainframe Programmer

Responsibilities:

• Modify existing ADSO dialogs and maps. Modifying process and adding elements using Integrated Data Dictionary.
• Modifying existing COBOL programs.
• Creating test scripts for each program that is modified. Creating result files to show screen prints on how changes of the program work.
• Modify Program Design Document (PDD) for the programs working on. Insert in the PDD - any inut changes or output changes that might have been added to the program.
• Responsible for Production Support-statistics for certain jobs, recording records for certain files, making sure that all the jobs have been run and if not contacting personal to inform them of the issue

Confidential, Washington, DC

Shift Supervisor / Command Center Operator

Responsibilities:

• Monitored Command Center Daily Journal
• Responsible for filling the shift during a call out Prepared incident reports
• Prepared work orders
• Creating files, retrieving records and placing new information in existing files
• Performed equipment inventory checks at the start of the shift
• Observed and Monitor building using the security MDI and Camera systems
• Respond to customer care (telephone/emails) with the appropriate information
• Responsible for sending out (FYIs) to appropriate address for emergencies/non - emergencies

Confidential, Washington, DC

Production Systems Analyst

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 with 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 with 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 have to enter the date or keyword after entering in the program name.
• Facilitated and scribed monthly interface meetings.

Confidential, Washington, DC

Systems Analyst

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 with 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.
• Maintained the BMIS Government “Alien Tracking” System that managed information on 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 with the client to design the screens, reports, elements that made up the records. Met with 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. I then had to create the document describing the screens, reports and what the program did.
• Developed and conducted slide show using Powerpoint for training..
• 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 modified COBOL programs that updated the database or created reports.
• Created and maintained the systems website