Summary of Qualifications

• Confidential has 26 years of experience in the Information Technology Industry. During this time, he has developed into a Senior Software Designer, using a structured yet creative approach to developing software systems that meet client needs. Confidential works cooperatively and effectively at all levels providing a positive impact on projects. He is adept at bringing technology and people together for the purpose of solving problems and creating systems that work.
• Confidential is flexible in his approach to systems design and development. He has the ability to work with a variety of team members and utilizes his superior people skills to bring out the best in his colleagues.

Application Development Created many new application modules from the ground up on various projects.

Database Design

Using database normalization techniques, have designed database records and associated record structures to meet real world requirements.

Business Analysis

Have worked with clients one-on-one to solve business problems through iterative requirements gathering and design process.

Mentoring Have supervised junior programmers by teaching application functionality and technical skills.

Proposal Writing Worked on teams to address both federal and state government RFP's providing technical writing skills, and research to present a cohesive, clear, submission to the request.

Professional Experience

Confidential

System Designer

• Key Technologies: SAP ECC 6.0, IBM MVS/zOS Mainframe, CA-IDMS 15.0, ADS/O, COBOL 370,SAS 9.0, JCL, DOC1
• Key member of team performing ETL process for Fairfax County in support of the Focus project. This is a legacy modernization project moving data from IDMS to SAP. Responsible for creating 50 conversion ETL programs from SAP functional specifications using both COBOL and SAS. Coordinating with County QA staff to ensure quality data translation into the new system.
• Performing level 3 Functional sign off on SAP Enhancements, Reports, Interfaces. This entails testing application functionality in the SAP ECC 6.0 system.
• As part of a small team, enhanced and maintained the Counties legacy PRISM system. This is a county-wide payroll, performance tracking, and benefits system written in ADS/O with an IDMS database.
• Design a subsystem for the purpose of tracking County CDL drivers. Teamed up with the counties principal architect to design the database and coordinated with end users on gathering requirements. Performed all coding and unit testing.
• Modified the entire PRISM application to use a new unique employee id number instead of employee SSN for security purposes. This entailed modifying 100 on-line programs and using incorporating global routines for translating the data.
• Teamed with two other developers on a very high visibility project to modernize the delivery of employee pay advice statements. Using several technologies Doc 1 Designer, VB Script, FTP, SAS Cobol with IDMS we developed an automated process to email pay advices to all County employee's within the payroll process.

confidential

• Key Technologies: UNIX, Oracle, SAS, Web HTML , Windows XP-IDMS 15.0, Microsoft Word, Adobe 6, VB Script, File-Aid/CS
• Working on a small team, participated in a new development effort, to create a database driven repository for survey data.
• The effort involved database design, data conversion, metadata development, load processes and system documentation.
• Contributed by collaborating with team members to develop metadata standards and database design.
• Developed file conversion and load processes for metadata using Compuware File-Aid/CS.
• Wrote several VB Macros to clean up data and format for loading to the database.

confidential

• Key Technologies: UNIX, Windows XP, Java, Microsoft Word, Adobe 5/6, Siebel 7
• Teamed up with a small group to address a high level crisis at NSF in which scientist's proposals, submitted to NSF, were not being processed and printed correctly and were thus delaying panel reviews.
• Contributed by quickly learning the application flow and correcting PDF formatted proposals by distillation, application un-submit/re-submit, and working with the printing staff to troubleshoot print production issues.
• Compiled and reported statistics on progress to upper management three times per week.

confidential

• Key Technologies: IBM MVS/zOS Mainframe, CA-IDMS 15, ADS/O, COBOL, JCL, DME, IDD,
• ADSALIVE
• Fulfilled several roles as the sole developer on the Debt Collection System DCOS .
• Responsibilities included functional requirements gathering, developing new application design, and working with the database administrator to implement new data structure design.
• As a member of the Asset Management Information System AMIS team, worked to implement a new production ready application.
• This included large scale data conversions and loads, as well as data scrubbing and testing.
• After production implementation, was part of a core team of developers responsible for enhancing and all maintenance.
• Participated in the CMM level 3 certification process for this team.

confidential

• Key Technologies: IBM MVS/ESA Mainframe, CA-IDMS, ADS/O, COBOL, JCL, DME, IDD,
• MAPC
• On the Falcon Conversion Team, designed, coded, and tested complex IDMS batch conversion programs.
• These programs were required to pull as many as 500,000 plus records from the Falcon database for transfer to a UNIX server using FTP facility.
• Worked with the TRAX Development team to determine file structures and program requirements to support parallel processing between the Falcon and TRAX systems.
• Submitted and monitored jobs from CA-7 checking results and correcting faulty logic. Used OLQ and DMLO to verify test results.
• Programmer Analyst SEMA for Food Consumer Service November 1994 to January 1995
• Key Technologies: IBM MVS/XA Mainframe, IDMS/R, ADS/O, COBOL, JCL
• Provided technical expertise in the development of the on-line software for the Store Tracking and Redemption System STARS .
• Analyzed functional requirements and presented the design for the Wholesaler Redemption Application to the user community.
• Designed, coded, and tested ADS/O dialogs for the implementation of this application.
• Worked with the DBA to redesign a batch report program to run 75 faster.

confidential

• Key Technologies: IBM MVS/XA Mainframe, IDMS/R, ADS/O, COBOL, JCL
• Worked on the FNS Food Stamp Program and Special Nutrition Program working with end users on a weekly basis to determine application requirements and operational maintenance.
• Developed on-line programs using CA-ADS with the TPSORT facility. Made large scale modifications to IDMS/Cobol extract programs to provide data for the Quality Assurance Database/Network Data Bank PC system.
• Developed a REXX driven batch report submission process for the Store Tracking and Redemption system STARS .
• Provided production support for the Network Data Bank NDB system involving direct interaction with users and bi-monthly status meetings.
• Developed ADS/O dialogs for the State Connectivity subsystem incorporating the use of CA-IDMS TPSORT facility.

confidential

• Key Technologies: IBM MVS/XA Mainframe, IDMS/R, ADS/O, COBOL, JCL
• Wrote technical specifications and batch IDMS programs for the MBS Release 1.1 Phase 2 project. Specifications ranged in scope from new programs to enhancements for existing programs.
• Coded new dialogs and batch report programs from these specifications and participated in code walkthrough's. Created JCL to run batch programs using SYNCSORT for sorting.

confidential

• Key Technologies: IBM MVS/XA Mainframe, IDMS/R, ADS/O, COBOL, JCL
• Developed application prototype for new subsystems at the Food and Nutrition Service. Presented prototypes to end users demonstrating application flow and proposed capabilities.
• Developed batch programs for complex reports giving regional and national totals for program participation and financial data. Worked with users to verify report data.
• Worked on development of the Disqualified Recipient Subsystem DRS for the Food and Nutrition Service's Software Renewal Program. The DRS was used to track disqualified food stamp recipients from 53 states and territories. Provided database design, software development, and assisted in development of the system test plan.
• Participated on development of the Food and Nutrition Service Special Nutrition Program SNP portion of the Software Renewal Program. Developed ADS/O dialogs for the purpose of maintaining reimbursement rates, meal count information, and food budget data. Used queue file processing for saving data in temporary work areas.
• Coded and tested nine batch report programs using COBOL II for an IDMS/R database as part of the development effort for the FNS Software Renewal Program for the Food Stamp Program's Benefit Instrument and Inventory Management Sub-System

Evaluation Research Corporation

• Programmer/ Analyst Evaluation Research Corp. September 1990 to May 1990
• Key Technologies: IBM Mainframe,IDMS Database, COBOL, COBOL II, ADS/O, DMLO, OLQ, IDD, JCL, Endeavor
• Working at the Office of the Comptroller of the Currency, served as lead programmer/analyst for the Trust BillingAccounts Receivable System.
• Duties included re-design, standardization, testing, and support of the system.
• Supervised a junior level programmer responsible for on-line changes to the system.
• Within the Financial Systems Branch provided technical support for various systems including - Cullinet Accounts Payable and General Ledger systems part of the Cullinet Accounting Software package as well as internal accounting systems.
• Implemented a Cullinet CAP PTF which required retrofitting client code into the new Cullinet software.

Confidential

Junior Programmer

• Key Technologies: IBM Mainframe,IDMS Database, COBOL, COBOL II, ADS/O, DMLO, OLQ, IDD, JCL, Superwylbur
• As a programmer on the Hotel and Auto Rates System developed on-line dialogs using ADS/O on an IDMS/R database.
• Created screens and batch programs in accordance with end-user requirements, performed application and system-level testing using JCL, IBM utilities, DMLO, and OLQ.
• Wrote macros in Superwylbur and had on-call responsibilities for production support of the system.