SUMMARY:

• Over 20 years of professional information systems work as an Analyst, Consultant, Developer, and QA Tester
• Approximately 18 years of experience in a Unisys environment using COBOL, LINC/EAE, MCP, MARC,CANDE, WFL, DUMPALL, DMS II, and DMSINQUIRY
• Direct involvement in several conversion projects involving programming language, architecture, or database transitions
• Worked on several multi - million dollar projects
• 7 years of experience working on state government mainframe projects
• Industry experience: K-12 education, insurance, government, consulting, banking, wholesaling
• SDLC, QA, DQ, CRUD, ETL, Use Cases

TECHNICAL SKILLS:

Hardware: Unisys Clearpath and ES7000, IBM mainframes, PCs, Apple computers, Sun Solaris

Operating Systems: and software Visual Studio, .Net, Windows, Excel, Word, TFS, MCP, ISPF, Unix, Mac OS Systems

Programming Languages: COBOL, LINC/EAE, AB Suite, C++, Basic, SQL, PL/SQL, Pascal

PROFESSIONAL EXPERIENCE:

Software Consultant

Confidential, Bismarck, ND

• Developed applications using Agile Business Suite and Visual Studio
• Participated in the migration from EAE to Agile Business Suite
• Was a major participant in a multi-state, seventy million dollar project to migrate from an existing UI system to a new Unemployment Insurance system..
• Responsible for ETL related activities
• Developed over 200 Unisys EAE programs for the analysis and cleansing of twenty million records, in 168 tables contained in the UI database of Job Service North Dakota.
• Developed Work Flow Language to test batch programs
• Employed full CRUD functions in software written
• Participated in data mapping sessions, wrote and tested extract programs that pull data from the UI database, write it to a flat file, and then FTP’d to the vendor HCLA to be driven into the new database.
• Use OLE DB to analyze data in Excel spreadsheets
• Use established business rules to perform Data Quality functions to ensure validity, accuracy, completeness, consistency, and uniformity of data
• Modified and designed datasets and profiles
• Wrote load/unload programs to extract Unisys DMS II datasets to flat files and load DB from flat files.
• Extensive updating of documentation and testing results provided to users, QA, and project managers.
• Assisted in the development of a data dictionary for the entire DMS II database
• Communicate progress and identify data discrepancies during regular meetings with users, QA, senior analyst, and project manager
• Provided recommendations when requested, for improving the process and prioritization of tasks and increasing production.
• Consistently finished the majority of 200 plus assignments ahead of schedule
• Work ten to fifteen hours over overtime each week
• Use complete SDLC to develop software solutions for Job Service of North Dakota
• Responsible for implementing required state and federal enhancements and new development
• Perform work on Unisys Clearpath with Linc/EAE
• Use MCP for testing WFL jobs, executing individual programs, creating test data, checking logs on jobs executed, and transferring files and other objects to different packs
• Use DMINQUIRY for black-box testing
• Use EAE debugging tool for white-box testing to QA software
• Wrote Web Service design specifications
• Received training in the Rational Unified Process (RUP)
• Use a HEAT and ITSM systems for project assignments and tracking
• Provide recommendations, when requested, for improving the process and prioritization of projects, and increasing production

Programmer Analyst

Confidential,Sacramento, CA

• Used LINC/EAE on Unisys ES7000 for modifications and new development to a student information system (SchoolMax) for the attendance, grade reporting, census, administration, health, inventory, and other modules.
• Performed QA on work done by others
• Performed system analysis to make application compliant with state regulations
• Developed technical documentation for more than 1200 screens and subprograms, to assist in the reverse-engineering of a student information system
• Assisted in the design and development of a C++ program to convert objects to JAVA-like pseudo-code during the migration from Unisys EAE/COBOL to J2EE
• Wrote C++ programs to extract data from model directory objects

Software Consultant

Confidential,San Francisco,CA

• Worked as a software consultant to modify and improve the AR system for a freight forwarding company using Unisys Clearpath MCP, L INC, COBOL, CANDE, and WFL
• Work was done to save the company hundreds of thousands of dollars in uncollected receivables

QA Consultant

Confidential,Richmond, VA

• Interviewed state agencies during the IV&V process to ensure Y2K compliance
• Analyzed test plans, test results, contingency plans, compliance letters, inventories, and other documents to ensure the existence of due diligence
• Analyzed IBM COBOL code
• Made recommendations to the Y2K coordinator for additional test case execution
• Helped train new employees and functioned as assistant team lead

QA Consultant

Confidential,Des Moines, IA

• Functioned as team lead for system integration testing and QA of a multi-million dollar project for EDS
• Performed the functional analysis of an IBM mainframe CICS COBOL banking application
• Used ISPF to navigate the applications and analyze and test JCL
• Was the liaison to business analysts to develop test specifications, methods and strategies
• Wrote hundreds of test scripts for testing an installment loans application
• Executed test scripts and documented results
• Provided support to users during user acceptance testing

Senior QA Analyst

Confidential,Des Moines, IA

• Worked on the Year 2000 team for the state of Iowa’s software conversion project
• Interviewed state employees responsible for the Y2K conversion
• Developed testing standards to be used during the QA process
• Performed project tracking of state agencies
• Wrote risk assessment reports of applications analyzed
• Analyzed IBM COBOL code
• Was trained in the use of a software analysis tool to assist the conversion effort
• Performed system analysis and QA on hundreds of computer programs
• Wrote training manual and trained CTA staff how to use code analysis tool

Programmer Analyst

Confidential,Cedar Rapids, IA

• Developed insurance applications for the financial systems team and maintained the online billing system using COMS, MCP, L INC, COBOL 74, WFL, MARC, CANDE and LINCLITE
• Performed system enhancements and testing for three conversion projects: COLOL 68 to COBOL74, Unisys V to Clearpath, database modification to ensure Y2K compliance
• Performed SDLC activities for major enhancements to the billing system
• Modified and added data base structures to the DMSII database and performed database reorganizations using MCP
• Was the project manager for a new voice response system that interacted with the COMS billing system