Management Project

Proposed Resource – Wayne Budnick

PROFESSIONAL PROFILE

Work for a Government Corporation\Agency of development programming, analysis, quality assurance and deployment at the National Office having both Reliability and Secret clearance.

More than 25 years of application programming, analysis, design, development, quality assurance, deployment and 24/7/365 support for a multi-site retail environment within Canada.

Highly skilled in building trusting long term partnerships with multiple stakeholders for a national retail provider.

Exceptional analytical skills, critical thinking and the ability to problem solve complex information technology systems.

Experience with system programming, problem decomposition, code organization with and across files, source tree organization, database administration, build automation, analyzing information, problem solving with attention to detail and effective communication skills.

TECHNICAL PROFICIENCY

Database management systems and data access methods: DB2, CICS, VSAM, OS/390, Z/OS, IDMS

Programming languages and scripting tools: COBOL, JCL, SQL, SPUFI, EASYTRIEVE, SYNCSORT, Statistical Analysis System (SAS), PL/1, SFTP/FTP, Data Definition Language (DDL), Advance Function Printing (AFP)

Productivity tools: TSO/ISPF, Interactive Output Facility (IOF), System Display and Search Facility (SDSF), Screen Definition Facility II (SDF II), Query Management Facility (QMF), Report Manage and Distribution System (RMDS), Platinum, INSYNC, Dumpmaster, Abend-Aid, VIA/Smartest, FILEAID, Expeditor, Construction and Analysis of Distributed Processes (CADP), Changeman, Endevor, CA7, Control – M, Marval, Reflection Workspace, Host On-Demand, Virtual Private Network (VPN), SmartClould, MS Office Word/Excel 2013, Lotus Notes Email, Lotus Domino Document Manager, Bell Turbo Stick

EMPLOYMENT HISTORY AND SELECTED ACHIEVEMENTS

Project No 1

Canada Mortgage Housing Corporation (CMHC), Ottawa, Ontario October 2015 – June 2016 Senior Production Operations Support – Disaster Recovery Coordinator

Canada Mortgage and Housing Corporation (CMHC) is Canada’s national housing agency. That was established as a government-owned corporation in 1946 to address Canada’s post-war housing shortage which has grown into a national institution. CMHC is a provider of mortgage loan insurance, mortgage-backed securities, housing policy, programs and research.

Project Description: DR Coordinator for CMHC IT, coordinating the development of procedures to ensure the CMHC Data Centre can respond to a disaster, bringing Mission Critical Applications to full functionality within a define time frame and to minimized any financial loss that could be encountered. As DR Coordinator, the responsibilities includes coordinating the design, development, maintenance and execution of DR Test/Exercise documents for Servers and Mainframe applications. Specific responsibilities included:

Establish and maintain the overall plans for executing all DR procedures and understand their interdependencies.

Develop and understand all testing necessary for a successful DR execution.

oWork with the IT Technical Staff to ensure that disaster recovery solutions are adequate, in place, maintained, and tested as part of the regular operational life cycle.

oWork with management to ensure that new equipment, services and systems are installed that the disaster recovery issues are addressed.

Conduct walkthrough meetings with IT Technical and Business Staff to review the DR procedures prior to a schedule event.

oConduct disaster recovery training for staff members in all functions.

oProviding instructional information materials on how staff are expected to respond during a DR.

Schedule and lead all DR exercises.

oRegularly report Disaster Recovery activities to upper management.

oRecording all success and issues that occur during the DR.

Maintain contact with outside organization participating in reciprocal agreements.

Work with Business Continuity management to ensure that the disaster recovery and business continuity plans drive disaster recovery strategy and procedures.

Conduct debriefing meetings with IT Technical and Business Staff to review all success and issues that have occurred during a DR.

Technical Environment: IBM Mainframe Z/OS with TSO/ISPF, Marval, Mircosorft Office 2013

Project No 2.

Public Works Government Services Canada (PWGCS), Gatineau, Quebec September 2015 – October 2015

System Analyst (1 Month)

The Receiver General (PWGSC) sector is a central government service, support both the Treasury and the Accountant functions of the federal government. The of the RG is to safeguard the integrity of the Consolidated Revenue fund (CRF) and accounts of Canada.

Project Description: Standard Payment System (SPS) is a mainframe system that issues payments on behalf of all federal government departments and agencies. The SPS is an integrated system that incorporates the entire payment process,including receipt and validation of the requisition for payment, payment issue,payment redemption control and reconciliation, redemption reporting, post issue process and exception. Specific responsibilities included:

Develop requirements, feasibility, design and specification documents for systems.

Translate business requirements into system design and specifications.

Analyzes and recommend alternatives and options for solutions.

Develop specification for systems development, designs and implementation.

Technical Environment: IBM Mainframe Z/OS with TSO/ISPF, Microsoft Office 2013

Project No 3

Canada Revenue Agency (CRA), Ottawa Ontario January 2015 – June 2015

System Analyst/Developer – Programmer – Contractor (6 Months)

Canada Revenue Agency (CRA) administers tax laws for the Government of Canada and for most provinces and territories. Administers various social and economic benefit and incentive programs delivered through the tax system.

Project Description: T1System Redesign Project, a re-write of existing and implement new business and system process of simplifying filing of individuals income tax returns. Working on the technology of an IBM Mainframe Z/OS that uses CICS, COBOL Batch/Online, Java, IDMS and DB2 that interfaces with multiple applications on various platforms. As a Team member provided expertise throughout all stages of the systems development life-cycle: including coding, testing, generating test scripts and maintaining documents. Specific responsibilities included:

Working with the System Management to translate business requirements to enhance or create new or existing procedures and on-line process

Upon approval of the design, worked independently on the following items:

oWorking with DDL concepts such as primary keys, foreign keys, trigger and constraints to construct and Batch/COBOL DB2 programs with JCL, CICS/COBOL DB2 on-line programs for the ETL.

oDocument the detailed design down to pseudo-code level with HTML of existing Batch/COBOL DB2 programs with JCL and CICS/COBOL DB2 programs.

oConstructed and unit-test existing JCL Batch/COBOL DB2, CICS/COBOL DB2 on-line application programs.

oConstructed and unit-test of existing JCL procedures to run the Batch/COBOL DB2 programs.

oProvide results to System Management or Senior Developers on daily basis.

At the Quality Assurance and Deployment phases:

oUsing several stages of development to validate JCL procedures to run the Batch/COBOL DB2 programs

oBatch data validation was accomplished by using SPUFI to query the DB2 tables and FILEAID was use to browse and validate sequential output files from the batch programs.

oOn-line data validation was accomplished by using SPUFI to query the DB2 tables and Platinum /FILEAID to validate VSAM files and Construction and Analysis of Distrusted Processes by having the execute the CICS conversations.

oDevelop and maintain current specification documentation for existing Batch/COBOL DB2, CICS/COBOL DB2 programs and Web Screens.

oPerforming independent verification and validation of software applications and system function and performance.

oDevelop and maintain interfaces between new and existing systems

oBatch/COBOL DB2, CICS/COBOL DB2 programs and procedures where monitor ensuring successful execution.

Working with System Management and head Developers to execute End-To-End Testing on Batch Cobol DB2, CICS/Cobol DB2 programs WEB Screens.

oValidate Test DB2 tables by Platinum/FILEAID that data is set correctly to prevent unwanted Abends.

oExecute at set of JCL procedure, validate XML record sequential outputs.

oPerformed CICS screen function as part of the End-to-End Testing.

oPerformed WEB screen function as part of the End-to-End Testing.

oPassed all sequential outputs to Developer for their End-to-End Testing procedures.

Technical Environment: IBM Mainframe Z/OS with TSO/ISPF using IDMS, DB2, COBOL, XML, HTML, SPUFI, JCL, FILEAID, Abend-Aid, Expeditor, Endevor

Project No 4

Canada Mortgage Housing Corporation, Ottawa, Ontario August 2014 – December 2014 Systems Developer - Programmer – Contractor (5 Months)

Canada Mortgage and Housing Corporation (CMHC) is Canada’s national housing agency. That was established as a government-owned corporation in 1946 to address Canada’s post-war housing shortage which has grown into a national institution. CMHC is a provider of mortgage loan insurance, mortgage-backed securities, housing policy, programs and research.

Project Description: Business System & Information Management for Assistant Housing is a very large and complex built on a IBM Mainframe Z/OS that provides budgets and forecasting, to monitoring budget take-up and generating financial reports for decision making purposes. As a member of the team, provided expertise throughout all stages of the systems development lifecycle: including requirements/systems analysis, project/systems design, coding, testing and implementation. Specific responsibilities included:

Working with the System Management to translate business requirements to enhance or create new or existing procedures, reports or on-line process

Upon approval of the design, worked independently on the following items:

oWorking with DDL concepts such as primary keys, foreign keys, trigger and constraints to construct JCL and SAS control members, or Batch COBOL DB2 programs, CICS/COBOL DB2 on-line programs for the ETL.

oDocument the detailed design down to pseudo-code level, existing Batch COBOL DB2 programs, CICS/COBOL DB2 programs, JCL and SAS control member into Marval.

oConstructed and unit-test existing JCL Batch COBOL DB2, CICS/COBOL DB2 on-line application programs and CICS Screen with SDF II.

oConstructed and unit-test of existing JCL procedures to run the Batch COBOL DB2 or SYNCSORT members or Z/OS Utility Programs.

oProvide results to System Management or Senior Developers.

At the Quality Assurance and Deployment phases:

oUsing several stages of development to validate JCL procedures to run the Batch COBOL DB2 programs or SAS and SYNCSORT members or Z/OS Utility Programs.

oBatch data validation was accomplished by using SPUFI to query the DB2 tables and FILEAID was use to browse and validate sequential output files from the batch programs.

oOn-line data validation was accomplished by using SPUFI to query the DB2 tables and Platinum /FILEAID to validate VSAM files and Construction and Analysis of Distrusted Processes by having the Business Analyst execute the CICS conversations.

oCreating Change Request documentation was pass to Senior Team members for validation.

oMarval was use to install request.

oBatch COBOL DB2, CICS/COBOL DB2 programs and procedures where monitor ensuring successful execution.

Working with Business Analyst to execute End-To-End Testing on Batch Cobol DB2 and CICS/Cobol DB2 programs.

oValidate Test DB2 tables by Platinum/FILEAID that data is set correctly to prevent unwanted Abends.

oExecute at set of JCL procedures individually, validate and record from sequential outputs or DB2 tables.

oReport any issues to Business Analyst, Senior Developers or System Management, wait for reply to continue or stop the test.

oPerformed CICS screen function as part of the End-to-End Testing.

oPassed all sequential outputs to Business Analyst for their End-to-End Testing procedures.

Technical Environment: IBM Mainframe Z/OS with TSO/ISPF using DB2, COBOL, SAS, SYNCSORT, SPUFI, JCL, Marval, FILEAID, Abend-Aid, Construction Processes, and Analysis of Distributed (CPAD)

Project No 5

Sears Canada Inc., Toronto, Ontario May 1992 – January 2014

Senior Systems Analyst - Programmer –Employee (260 months)

Sears Canada is one of the largest retailers in Canada with an average annual revenue of almost $5 Billion. As of March 13, 2014, Sears employed over 11,000 individuals, operated 176 corporate stores, 233 hometown dealer stores, 7 Sears home services showrooms, approximately 1,400 catalogue and online merchandise pick-up locations, and 97 Sears travel offices, as well as home maintenance, repair, and installation network.

Project Description: Distribution Operation System: The Distribution Operation System is a very large and complex merchandising system built on an IBM Mainframe OS/390 encompassing an estimated project value of over $20M. It provides real-time management of all Sears product to be received, stored, picked, and loaded onto trucks and ship to the customers, other distribution centers or stores. As a critical member of the team, provided expertise throughout all stages of the systems development lifecycle: including preliminary investigation, requirements/systems analysis, project/systems design, coding, testing, implementation, maintenance, and support. Specific responsibilities included:

Working with the Business Analyst to translate business requirements to enhance or create new or existing procedures, reports or on-line process

Upon approval of the design, worked independently on the following items:

oWorking with DDL concepts such as primary keys, foreign keys, trigger and constraints to construct SPUFI either in QMF, JCL control member, or Batch COBOL DB2 programs or CICS/COBOL DB2 on-line programs for the ETL.

oDocument the detailed design down to pseudo-code level, new Batch COBOL DB2 programs, CICS/COBOL DB2 programs, QMF or JCL control member into Lotus Domino Document Manager.

oConstructed and unit-test existing or new JCL Batch COBOL DB2, CICS/COBOL DB2 on-line application programs.

oConstructed and unit-test new of existing JCL procedures to run the Batch COBOL DB2 or QMF with Easytrieve Plus, SYNCSORT members or OS/390 Utility Programs.

oProvide results to BA or National Distribution Centres.

oCOBOL Batch or CICS/COBOL Manage the timeline for delivery of components.

Providing system support, operation support and maintaining the DB2 databases for the Distribution Centres across Canada.

oDaily maintenance on DB2 tables using SQL Queries after nightly production run.

oWorking with Business Analyst or from Distribution Centres to generate ad-hoc reports using ETL with complex SQL SPUFI’s and construct JCL Procedures with Easytrieve Plus, Syncsort or OS/390 Utility programs and FTP data onto a spreadsheet.

oHandling incoming inquiries from the Business Analyst or Distribution Centres and provide explanation or solution to the issue at hand.

oUpdating log on all batch and on-line issues and its resolution.

At the Quality Assurance and Deployment phases:

oUsing CHANGEMAN to validate JCL procedures to run the Batch COBOL DB2 programs or QMF with Easytrieve Plus, SYNCSORT members or OS/390 Utility Programs with JEM/JSCAN.

oBatch data validation was accomplished by using SPUFI to query the DB2 tables and INSYNC/FILEAID was use to browse and validate sequential output files from the batch programs.

oOn-line data validation was accomplished by using SPUFI to query the DB2 tables and INSYNC/FILEAID to validate VSAM files and Construction and Analysis of Distrusted Processes by having the Business Analyst execute the CICS conversations.

oCreating Change Request documentation was pass to Operation Support Team member for installation instructions, Distribution Centres notified of enhancement.

oCHANGEMAN was use to install request.

oBatch COBOL DB2, CICS/COBOL DB2 programs and procedures where monitor ensuring successful execution.

oQMF Report where validated by browsing sequential output or Report Management and Distributing System.

Working with Business Analyst to execute End-To-End Testing on Scheduling Stream Batch Cobol DB2 and CICS/Cobol DB2 programs.

oRefresh Test DB2 tables by ETL data from production DB2 tables.

oValidate Test DB2 tables by INSYNC/FILEAID that data is set correctly to prevent unwanted Abends.

oExecute at set of JCL procedures individually, validate and record from sequential outputs or DB2 tables.

oReport any issues to Business Analyst, wait for reply to continue or stop the test.

oPerformed CICS screen function as part of the End-to-End Testing.

oWhen required, generated customer tickets and passed to Business Analyst.

oDestroyed Customer tickets after each End-to-End Testing to protect customer information.

oPassed all sequential outputs to external departments for their End-to-End Testing procedures.

Working with Development Team to execute Yearly Audit on transactions of merchandise the passes through the Distributions Centres across Canada for the Accounting Team.

oDevelopment Team provided a set of sequential outputs from an ETL from the parameters given from the Accounting Team.

oSequential outputs passed through a series JCL procedures with a set of OS/390 Utility programs, Easytrieve Plus and SYSNCSORT to generate report data that was FTP and place onto a spreadsheets, then copied onto CDs and given to Accounting Team.

Off-site from Sears, responsible for nightly Batch run of Distribution Operation System Scheduling Stream. Scheduling Stream function to obtain merchandise from the Distribution Centre across Canada.

oNotified of Abend from Operation Support Team by a paging system with details of the JCL procedure that has failed.

oNotified Distribution Centre that customer tickets are not going to be produce on time.

oLogging by Virtual Private Network with given IBM Laptop with Bell Turbo Stick or home internet connection.

oViewing cause of Abend on the Batch COBOL DB2 programs with aid of the Interactive Output Facility or Dumpmaster/Abend-Aid.

oUsing Dumpmaster/Abend-Aid tool to investigate Abends in more detail, to point out what part of the code failed or the current input record from sequential file input or DB2 table.

oWhen required created a backup of sequential output with TSO/ISPF commands, then obtain access to production sequential output data and either delete or modified the record that cause failure.

oContact Operation Support Team restarting information for Abended JCL procedure and monitor procedure and notify Distribution Centre that Abend has be corrected.

Off-site from Sears, participated in Disaster Recovery Exercise at the IBM Facility.

oRecover all JCL procedures from point of failure that was determine Disaster Recovery Team.

oMonitor Scheduling Stream JCL procedures and demand in JCL procedures via CA7 when required.

oRecord any issues into common file.

oMeet with Project Lead and Development to discuss any issues that occurred during exercise.

Technical Environment: IBM Mainframe OS/390 with TSO/ISPF using DB2, COBOL, EASYTRIEVE Plus, SYNCSORT, SPUFI, JCL, CHANGEMAN, INSYNC, FILEAID, Abend-Aid, Construction and Analysis of Distributed Processes, CA7, Query Management Facility, Report Management and Distributing System, Lotus Domino Document Manager

Project No 6

Sears Canada Inc., Toronto, Ontario

Programmer - Employee

July 1987 – April 1992 (58 months)

Project Description: Retail And Parent Inventory Distribution (RAPID), group was absorbed by the DOS project.

On-site at Sears, responsible of support system in test and production environments: perform complex problem resolution/debugging.

Technical Environment: IBM Mainframe OS/390 with TSO/ISPF using PL/1,SYNCSORT, JCL

Education & Professional Development

Computer Science Technology, Sheridan College, Brampton, Ontario 1984-1987

Contact this candidate