SUMMARY

• Confidential is an experience mainframe Programmer/Analyst wif many years in the IT profession and at times, has functioned as a business analyst.
• He as worked on a number of different systems, including IBM 370 & 3090 ZOS systems, UNIX, and AS400. His primary programming language skills include COBOL, DB2, CICS, IDMS & ADS/O, and SQL.
• He has also worked on mainframe/PC integration projects and has some experience wif PC applications such as C#, Access, Crystal Reports, HTML, and Microsoft Office Suite applications.
• The business environments Confidential has worked in most often have been insurance related businesses, of one form or another, including Life & Health Insurance, Property/Casualty Insurance, and Crop Insurance for private insurers and the USDA.
• Confidential has also had experience wif Health Claims processing involving HIPAA compliance, projects that dealt wif Child Support Recovery Reporting for state government, Employment/Unemployment access to state government resources, magazine subscription processing, and credit card processing.
• Confidential is dedicated to providing those he works for, wif well documented, quality applications and systems.
• He recognizes that well documented systems and standardized approaches to how applications are written and implemented, are valuable company assets.
• To that end, he is a strong advocate of project methodology and programming standards.
• Confidential is a strong advocate of reusability and elimination of redundancy in code, data referencing, and application execution.
• He recognizes that a large part of an application’s lifecycle is maintenance and he advocates that applications should be easily understood and easily modifiable.
• He is pro - active in his approach to improvement of the systems and processes he comes in contact wif, always looking for ways to enhance the performance and user-friendliness of systems.
• In a Business Analyst role, he views each IT system as to how it relates wif all other IT systems, and how those systems will be adaptable to future changes.
• He works well alone and in team environments.
• He interacts well wif subordinates, managers, and top management and is able to interact at a level that is easily understandable wif all he comes into contact wif.
• He strives to expand his business knowledge as quickly as possible so that he may become a valuable asset to those he works for. He embraces new ideas and opportunities.
• Confidential has never had a problem wif any of the FBI background checks required for the job.

TECHNICAL SKILLS

Software: MQ-SERIES, IDMS, ADSO, UNIX SQL, VI Editor, Microsoft WORD, Microsoft EXCEL, Microsoft PowerPoint, VISIO

Languages: COBOL, COBOL II, COBOL 370, MICROFOCUS COBOL, CICS, EASYTRIEVE +, IDMS, ADSO, DB2, C# (limited), Informix SQL and Windows SQL, Crystal Reports training, Assembler

Tools: IBM Mainframe JES2 JCL, VSAM, IDCAMS, TSO/ISPF, PANVALET, EXPEDITOR, File-Aid, Data Expert, Endevor, Changeman, MFE (Micro Focus Express), SPUFI

Databases: UNIX, IDMS, DB2

Hardware: IBM mainframe 370 & 3090 (Z/OS), UNIX, AS400

Applications: Life & Health Insurance Reserves, Property & Casualty Insurance quote and maintenance, Crop Insurance maintenance, Employment/Unemployment Insurance Interfaces, Child Support Recovery information maintenance, Credit Card Cycle Processing maintenance

Industries: Life & Health Insurance, Property & Casualty Insurance, USDA, State of Iowa (Employment/Unemployment Insurance & Child Support Recovery), Credit Card Processing

Operating Systems: Very large IBM mainframes, UNIX, AS400, Windows (98, 2000, XP, VISTA)

Methodologies: Various project methodologies, Top Down Structured Programming, Speed Reading concepts that help improve readability of applications and documentation

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Programmer/Analyst

Responsibilities:

• As part of a 4 person team, he assisted wif diagnosing both PC and mainframe Claims processing applications.
• dis included installing and uninstalling PC applications remotely on claims adjusters PCs. As part of an 8 person team, he assisted wif diagnosing and correcting production mainframe issues on a daily basis.
• Corrections to production files were handled by running SQL queries to modify errors in policyholder data.
• Occasional COBOL and DB2 COBOL program changes were sometimes needed. Some of these contained embedded SQL queries.
• When major systems were being installed, Confidential had primary responsibility for running and coordinating the mainframe tests of the relevant nightly ‘cycle’ test jobs, requiring anywhere from 2-6 hours per ‘cycle’ test to run. At times, SQL queries were crafted to run ad hoc reports for users. The mainframe system was a IBM 3090 (Z/OS).

Confidential, Madison, WI

Programmer/Analyst

Responsibilities:

• As part of a moderate size team, Confidential assisted wif writing new and updating old programs needed for the military health insurance claims.
• Confidential worked wif the company’s stringent programming standards in developing programs based on flat files, VSAM files, and DB2 tables.
• He also assisted in mid-level design and detail design of the part of the project he was assigned to.
• Approximately a third of the assigned programs involved DB2 wif SQL.
• Applications were developed and run on a large IBM mainframe using COBOL, CICS, DB2, SQL, and IBM Debugger.
• dis assignment required an FBI background check, which Confidential passed.
• The mainframe system was a IBM 3090 (Z/OS).

Confidential, Minneapolis, MN

Programmer/Analyst

Responsibilities:

• As part of a large team, Confidential assisted wif writing new and updating old programs needed for the Federally mandated NPI Coordination of Benefits revisions to the company’s Medicare processing system.
• Confidential worked wif the company’s stringent programming standards in developing programs based on flat files and DB2 tables.
• He also assisted in mid-level design and detail design of the part of the project he was assigned to.
• Applications were developed and run on a large IBM mainframe using COBOL, CICS, DB2 (wif SQL queries), MicroFocus Express, and Xpediter.
• dis assignment required an FBI background check, which Confidential passed.

Confidential, Owatonna, MN

Programmer/Analyst

Responsibilities:

• As part of a 5-person team, Confidential assisted wif writing the report programs needed for the new Property/Casualty insurance system that is to be installed in 2010.
• Confidential worked wif the company’s stringent programming standards in developing reporting programs based on flat files and DB2 tables.
• He also created programs that accessed the CICS interface systems for verifying Top Secret security roles.
• Using his Property/Casualty experience, Confidential was able to spot deficiencies in program and system specifications, working through those deficiencies wif the responsible analyst.
• He also had responsibility for updating existing Easytireve applications.
• Applications were developed and run on a large IBM mainframe using COBOL, CICS, DB2 (wif SQL queries), Easytrieve, and Xpediter.

Confidential Omaha, NE

Programmer/Analyst

Responsibilities:

• The assignment involved trying to absorb the business knowledge of credit card processing in the span of 1 month, wat the company normally spends 6 months in training of new employees.
• He was then assigned tasks to modify production code.
• His extensive background in programming and analyst experience helped to devise alternative solutions to the problems that were put before him in modifying the main 1 million plus lines-of-code ‘Supdate’ cycle programs. Confidential also served as a primary ONCALL support person to fix two production problems that arose during his assigned ONCALL time.
• Applications were developed and run on a large IBM mainframe using COBOL and DB2.
• dis assignment required an FBI background check, which Confidential passed. The mainframe system was a IBM 3090 (Z/OS).

Confidential, West Des Moines, IA

Programmer/Analyst

Responsibilities:

• Confidential served in a contract Programmer/Analyst role at a Property/Casualty insurance company.
• His role was to maintain the current COBOL programs while the company is in the midst of a conversion to a new system.
• His function was to take identified program problems, make changes, document those changes, test the changes, and work wif the users for production transfer signoff.
• Confidential was given the responsibility to work on online, as well as batch programs.
• His Business Analyst skills and business knowledge identified at least 2 problems that would have been a liability to the company if modifications had been done as originally written in the specs.
• Most of the interactions wif CICS and DB2 (wif SQL queries) programs were in a batch environment.
• Testing involved manual submissions of test JCL that was a variation of production runs.
• Most of the applications relied heavily on copybooks and called modules.
• Confidential was instrumental in setting up email notifications for production environment problems.
• At one point, Confidential reviewed the current coding and IT Standards, making recommendations for improvements based on his experience at other clients.
• Confidential also proposed standards improvements for application implementation documentation that would cut down on the time needed to implement changes.
• File-Aid and Expediter tools were sometimes used to validate code changes.
• Changeman version control software was used for program version control and migration.

Confidential Kansas City, MO

Programmer/Analyst

Responsibilities:

• Confidential served in a contract Programmer/Analyst role for a Pharmacy Number Conversion project that was a federally mandated pharmacy identification number revision at a prescription drug insurance claims processor.
• The project entails reviewing all programs that deal wif files and reports that have a pharmacy number code.
• His analyst skills were put to use on more TEMPthan one occasion in devising solutions to file conversion issues.
• coz of the volume of prescription drug insurance claims the company processes, the company uses a large IBM mainframe to manipulate large DB2 databases and files in COBOL and other applications.
• Endevor was used for program version control and migration.

Confidential, Minneapolis, MN

Programmer/Analyst

Responsibilities:

• Confidential served in a contract Programmer/Analyst role for a project that was a major revision in a property and casualty client’s web based Policy Application System.
• The system is divided into 3 areas; web server database, web page code, and AS400 mainframe support programs. Confidential ’s primary role was to make revisions to the AS400 COBOL code, along wif some shared responsibility for revisions to the C# code that collects information from the web pages.
• The project Confidential worked on was the 2nd phase of a 3-phase project. Wif Confidential ’s 2nd phase responsibilities mostly completed, Confidential helped wif analysis on how the 3rd phase revisions would be implemented.
• While also helping to maintain the legacy system, Confidential used ad hoc SQL queries to create test data and verify test results.
• Whenever possible, Confidential employed his Analyst and Business Analyst project methodology experience to enhance new and existing systems, while also stressing the importance for better documentation of existing systems..