Mainframe Programmer/Analyst

Continuing Education, George Washington University, ••••• Continuing Education, Prince Georges Community College •••••Present MCSE (Microsoft Certified System Engineer) Hardware: IBM •••••/•••••/•••••/•••••/•••••/•••••/•••••/•••••/•••••XX, AMDAHL, CDC, AS•••••, Minicomputers and Personal Computers. Software: DB2, ADABAS, VSAM, DATACOM, IMS, IDMS, INFORMIX, C•••••, COBOL LE, COBOL II, COBOL, CICS, PL/I, PASCAL, JCL, EASYTRIEVE, UNIX, JES2, MVS, VM, VM Execs, TSO, IDCAM, SYNCSORT, NATURAL, SQL and Windows NT. Toads, Data Junction, Oracle 8i client server database, Crystal Reports. Summary: Over ••••• years experience in Project Management, Facility Management, and marketing Technical Support and Proposal Preparation. Experience in Data Management Systems (VSAM, DATACOM, DB2, ADABAS, IMS), and Computer Performance Evaluation. Managed and participated in computer programming projects which designed, developed, tested, debugged, implemented, and documented COBOL II, COBOL, PASCAL, CICS, VSAM, EASYTRIEVE, VM Execs, TSO, MVS-JCL, SYNCSORT, NATURAL, AND SQL language programs for the fourth generation IBM, AMDAHL, CDC Computers, and Personal Computer systems. Conducted user interviews to formalize system requirements and developed system/program specifications for various computerized information systems. Related Work Experience: Abridgments from December ••••• to present for these assign contract clients: October 7, ••••• Present Ingenium Corporation: Mainframe Application Team Lead Client: Prince George County Government, Environment: OITC (Office of Information Technology) Application Team Lead for application maintenance and development on a mainframe IBM •••••/mvs system and client server systems. Manage nine member staff, which is responsible project management, application programming, and concepts of new technology presented to client. Performed and responsible for employee evaluations and Day-to-Day task management as the Technical lead on Projects such as ACS Justice Conversion Project. Recommend system changes, consult client on new emerging technologies, communicate with users written and orally of pending requirements where necessary. Lead Team through a major conversion for Prince Georges County Circuit Court on the ACS Justice Conversion project. Put together system requirements, QA, and programming specification for the conversion of data from mainframe to client server. Also, advised and lead client through the following bullet items Acquire new software tools. Seek out and retire that legacy application thats not in use such as Boilers, Water/Sewer that tie up DASD space. Performed day to day task management of CICS Cobol/VSAM database system for Courts Users Brought about management of cohesion team concept with our group. Created Clean-Up team to fix ACS Conversion Project and establish a valuable QA process that identified issues with the ACS Justice process. Establish ACS Justice client server database with a fully loaded database. Better working relationship with Court concerning the ACS Justice Conversion Project. Rehired Junior LMIT employee and establish mentoring of junior members on Mainframe team. Identified and cleaned up test regions based upon recommendation to government management. WIP on team communication with government management and Team Leads. Established meeting between CORE1, CORE2, and CORE3 to better understand and improve IT solutions. Established Testers for Mainframe and Client Server environment. Established Configuration Management and QA cross Mainframe and Client Server environment. Configuration Management monitors DASD utilization and identifies recovery of DASD datasets that use unnecessary space. This cuts down on application ad-bends such as B••••• for lack of DASD space. WIP on Management of Courts and Mainframe groups. Put Quality Assurance in place for documentation of legacy application. March ••••• March ••••• Paragon Client: Bell Atlantic/Verizon Performed work in the Marketing systems Long Distance (MSLD). Wrote and designed two programs for Real Time Scrub using Cobol-II programming language on Mainframe computer. Wrote detail design document for Customer Care Touch. Programming in SQL/DB••••• Provide support for Commercial Electronic Interfaces, CLEC Support and Project Management. Responsible for applications design, programming to refold data from mainframe to UNIX environment. Wrote various programs and designed system for support and maintenance of the CLEC data in the PON Shop. Programs written in Cobol interface with FTP (file transfer process). Checked status in Unix codes for update and script processes and Cron jobs. Wrote various SQL queries to extract data. Wrote and designed reports using INFORMIX query language. March ••••• VistaRMS Client: MCI WorldCom Environment: SCA Custom Solution Responsible for the development and maintenance of business systems for SCA Custom Solution branch. Served as a lead analyst in the design of three Information Systems comprised of Cobol-II, JCL, File Aid, and Syncsort in client server environment. Personally responsible for redesign and maintenance of IBM Audiovisual Conferencing reporting System. Wrote various requirement documents, using window applications knowledge (Word, Excel, and i.e.). Provided ADP technical guidance to and worked with user representatives in their formulation of requirements for NASDAQ, Citicorp, Dell Computer. Advised on alternate methods of approach and suggest how to automate systems. July ••••• February ••••• DMR Consulting Group, Inc. Client: Bell Atlantic Environment: System Test Performed work for client in a Client Server and Windows application environment on Data Conversion on ExpressTrack System. Travel between Washington Metro-Area to Philadelphia to gather user requirements on data conversion under ExpressTrack System for users in Philadelphia. Responsible for a working knowledge of all data processing policies and procedures in Bell Atlantic on efficiency and maintainability; communicated finding of analysis and problem determination of testing of Cobol-II, JCL, Syncsort, and DB2, and Lotus-Notes modules to user community. Performed analyses, design, and wrote requirement for open architecture systems such as, NPD Consumer/LBS NPA/Pulls, SSNS/LiveWire. April ••••• June ••••• DMR Consulting Group, Inc. Client: Cable & Wireless Environment: System Development & Maintenance Performed work for client to convert COBOL programs to a higher level of proficiency within an Amdahl (IBM compatible) MVS/ESA mainframe environment. Responsible for the redesign, system analysis and programming of program modules written in COBOL-II, and ADABAS/Natural. This project required a take charge leader to put project back on track for client and company. March ••••• March ••••• DMR Consulting Group, Inc. Client: AT&T Environment: Production Support Responsible for database recovery to a low middle market account maintenance system which "process business account service orders" through IMS/COBOL/PLI code and translate it into a IMS hierarchical database components. Also responsible for the coordination and isolation of IMS database problems of all types relating to the Subscribed Component System (SCS) DataBase. I resolve those problems through data recovery methodology based upon data correction software. As Lead Production Support/Analyst, I was responsible for maintaining Account Subscribed Service Components to support the billing for the Subscribed Billing System (SBS) database. Served as Subscribed Components System (SCS) Subject Text Matter specialist within SCS organization that consisted of the usage and maintenance of the SCDB (Subscribed Component DataBase). Also, I was on call to perform data recovery when required by SBS (Subscribed Billing System) which included correction to data flow problems that stops the billing system from processing customer bills on schedule. As Lead Production Support/Analyst, I analyzed and identified errors in OBS/OON (Outbound Order Negotiations), Subscribed Component System (SCS) DataBase, and TOPAS/SUBARU (On-line Transaction Order Processing Account System) systems that required various debug tools. This usually involved gathering data from various users, programmer/analyst: observation of work processes; consultations with other subsystem application teams and counterparts in other districts. Where controversial problems arise, draft recommended alternatives to supervisors and top management. Upon approval of synopsis prepare data recovery process that includes changes to database customer accounts. February ••••• February ••••• DMR Consulting Group, Inc. Client: Sallie Mae Performed work within a Amdahl (IBM compatible) MVS/ESA mainframe environment in support of the Electronic File Transfer system (EFT). On a local area file server network system environment using windows ••••• to modify and develop CICS, COBOL II programs within a VSAM database system. Responsible for the design, system analysis and programming of program modules written in COBOL-II, and CICS, to perform the maintenance and monitoring of student loans for Sallie Mae. Designed, and wrote various CICS, COBOL II program for Automatic Scheduling of Loan Serving. Some of these programs are used for monitoring and disbursement of student loans, the confirmation of money transfers via electronic wire, and the monitoring of mainframe transaction error processing for the EFT system. August ••••• January ••••• DMR Consulting Group, Inc. Client: U.S. Sprint Supported client in a MVS mainframe, local area network system environment using windows ••••• to control update and monitor long distance telephone traffic for a major communication corporation. Responsible for the design, system analysis and programming of program modules written in COBOL-II, CICS, DB2 environment to perform the maintenance and monitoring of telephone message traffic for U.S. Sprint. Designed, and wrote program interface to report by tape. The distribution billing of the total number of telephone calls for all government agencies. Wrote the specification and code of a program, written in Dy••••• programming language. This sub-system is used for adhoc reporting of all Internal Revenue Service ••••• telephone calls, which reported and summed the number of calls and minutes used by IRS phone customers. This sub system searched U.S. Sprint total number of calls to date record system of more than ••••• million record from January 1 through May •••••, ••••• Other program projects included modifications of CICS/DB2 system for tax table update to include code changes to DB2 tables. April ••••• July ••••• Mnemonic Systems, Inc. Client: FBI Wrote and modified Nautrual/OS2 programs in a development environment. Establish a PC database on Nec Personal Computer for a test bed of employee information database system. Up loaded natural programs to mainframe for final production tests. February ••••• - March •••••: Ellsworth Associates, Inc. - Senior CICS/COBOL Programmer (U.S. Customs Service) Performed debugging and development of COBOL/CICS programs in support of the U.S. Customs Seized Property Management System. He has supported, implemented, and led a major design modification to the Seized Property Management System for U.S. Marshal Service under a memorandum of understanding between U.S. Customs Service and U.S. Marshals Service. Wrote project plan which was accepted by major Seized Property user community, hence steered the direction for inclusion of other U.S. Treasury agencies to be included in the Seized Property Management system. Such as, Alcohol Tobacco & Firearms, Secret Service, and Internal Revenue Service. Wrote and modified numerous COBOL/CICS programs under a DATACOM database environment to accept U.S. Marshals data. January ••••• - February •••••: Orkand Corporation - Senior Staff Consultant/Team Leader (Office of Personnel Management) Acted as a technical advisor to and coordinated the efforts of project team members in the operational support of computer programs and computer system enhancements for the Retirement system financial Branch. Responsibilities included team management, client interface, analysis, design, testing, and quality assurance of finished assignments. Developed programs written in ADABAS/NATURAL and COBOL to automate the Voluntary Contribution System. Performed conversion of ••••• programs for two operational systems written in Natural ••••• to ••••• Wrote a CICS program to browse VSAM records for basic Government Life Insurance amounts of Moines. Designed specification and wrote the COBOL programs for a Financial management System to select Retirement annuitants under the United States Postal Services Retirement System for their Government contribution owed OPMs supplemental basic Life Insurance fund. February ••••• - December •••••: Quantum Information Resources - Consultant (for Continental Insurance Company, Cranbury and Neptune, NJ) Division Work Performed - Reinsurance Branch Office: Performed major modifications to existing financial application system called Schedule F, which reports overdue Reinsurance recoverable. Modifications required financial programs to report accounts ••••• to ••••• days overdue and calculate late payments based upon insurance formula. Additional information produced is a summary of data to be used by PC LOTUS used in Continental Insurance Branch in New York City. Wrote two financial programs in COBOL via VM/MVS crossover product. Used Easytrieve as a method for testing and loading financial data to the system. Division Work Performed - MOAC (Marine Office America Corporation: Responsible for the redesign of the Cumulative Claims Analysis Reporting System (CCA). Developed two COBOL programs that selected and matched policy and accident master records from VSAM master files. Made enhancements to a existing COBOL program with embedded Structured Query Language (SQL) to accept the process data and produce a financial cumulative claim report on the amount of Moines paid for marine accidents utilizing file access discipline with VSAM and DB2 database files. Modified and enhanced a DB2/SQL COBOL programs (Excess Treaty Report) to properly balance financial losses of commercial insurance business. Related to Marine, Boiler and Machinery, Ship Cargo, Aviation, and War Risks. Wrote and designed COBOL program (Surplus Treaty Report) to load financial data related to written, commission, and paid expense of data for a COBOL DB2/SQL program to produce a report. The surplus treaty report program developed using COBOL and embedded SQL that excesses the premium loss file database on a quarterly basis. September ••••• - February •••••: Key Data Systems, Inc. - Senior Software Systems Analyst (Contractor for Army Material Command) Responsible for software installation and tuning of the IBM Model •••••, ••••• on a virtual machine (VM/IS) computer and the Plexus/P••••• microcomputer utilizing UNIX Operating System ••••• The function of position includes software maintenance, documentation, and enhancements to each environment. Assist users with problem isolation and resolution relating to all types of personal computers, dumb terminals, data line communications, and other technical support activities. Maintain user account data, e.g., change user privileges, passwords, stop, abort, delete user processes where required. Serves as the local ADP (Application Data Processing) organizations technical specialist in the use of a DBMS (DataBase Management System) software package and those obtained from vendors (DB2/SQL, FOCUS/SQL, VTAM, RSCS, etc.) February ••••• - September •••••: T. DOC Consultants, Inc. - Contractor/Consultant Engineering Support Branch of U.S. Postal Service Responsible for the design, programming, administration, and implementation of various levels of database authority, and conventions relative to user IDs, database tables, and uses of direct mini access storage for the Failure Analyst Project (FAP). Performed detail design of application systems (written in COBOL, SQL/DS) for the FAP project. Computer system software requirements (utilizing database system utility), database structure, computer system operation methodology, which utilized telecommunication disciplines in IBM •••••, ••••• environment. October ••••• - February •••••: Naval Medical Data Services Center - Lead Programmer/Analyst Head a four-person team in the development of the Non-Availability of Patient Care System. Designed system and program specifications, testing and implementation procedures in NATURAL/COBOL and the optical character recognition input form. Performed maintenance and redesign of all facets of systems and developed edits for an Optical Character Read (OCR) capture of data. Performed Systems Analysis on maintenance and upgrades of supply, inventory, and personnel computer systems, maximizing operational efficiency while maintaining high standards of document and user compatibility. May ••••• - October •••••: U.S. Coast Guard - Computer Programmer Developed, enhanced, and maintained Pollution Incident Reporting Systems, comprising of ••••• batch programs on the CDC ••••• Worked with the Coast Guard personnel nationwide in capturing pollution data and provided customer support to various groups requiring pollution data. Worked in complex environment involving parallel use of CDC ••••• and IBM ••••• Identified system requirements and developed performance criteria. January ••••• - May •••••: Informatics Information Systems - Programmer Performed cumulative process for NASA Star publication, including data collection, processing, and formatting. Participated in design, writing, and implementation of program modules written in PL/1 to process foreign languages for AGARD Multilingual Dictionary project. Developed program to eliminate duplicate records from large database. Salary: Open References: Available upon request