AREAS OF EXPERTISE

• Experience in systems analysis, design, software implementation, documentation and production support.
• More than 17 years experience in IBM Mainframe application development (CICS, COBOL, MVS, JCL, VSAM)
• 7 years experience in Client-server application development.
• 7 years experience in Relational database systems (DB2 UDB, SQL Server, MS ACCESS) database systems architecture and components database systems configuration (instance and database) database storage (storage management methods / Tablespaces and containers)
  backup and recovery planning and implementation (logging / backup methods / database utilities (data movement / export / import / reorganization) ) constraints including referential integrity, triggers
• Programming experience with IBM MQSeries.
• SAS Mainframe and SAS EG programming.
• Experience in application conversion.( Micro Focus COBOL to windows VB application)
• Experience in Web technologies including IIS, ASP and HTML programming
• Experience with reporting tools (Crystal Report, Cognos Impromptu)
• Experience with Change Management AR System and Remedy processes.
• Experience promoting software into multiple application environments.
• Participating in an on call rotational period for production support ( nightly Batch Cycle).
• Academic training in Java.

• Operating Systems: OS/390, MVS, Windows , VM, Z/OS
• Programming Languages: COBOL, Visual Basic, SQL, Java, PL/SQL, Developer 2000, HTML, JavaScript, PL/1, JCL, Micro Focus COBOL
• Database Systems: DB2 UDB V7.1, MS ACCESS, SQL Server 2000, ORACLE 8, ODBC
• Software: CICS TS V1.3 , TSO, ISPF, VSAM, FILEAID, MQSERIES, PVCS , IIS, FrontPage 2002, Impromptu, Crystal Report , Change Management AR System

ITIL Service Management Foundation
Introduction to XML
Computer/ Business Management
Programming with Microsoft Visual Basic .NET
MQSERIES Application Design
Database Administration (DB2 UDB V7.1)
MQSERIES Application Development
Database Developer Certificate (36 weeks)
Training course in advanced CICS Programming
Training course in CSP
Training course in VSAM
Associate Degree in Computer Science

Confidential, Ottawa, On (March 2008 -Now)
SAS Developer / Analyst
The role of the SAS Developer / Analyst is to:

• Perform ad-hoc analysis at the clients' request
• Maintain the applications by providing help to production support
• Update the applications by implementing new features
• Be the subject matter expert on the applications
• Recover the applications in case of failure or corrupt data
• Convert SAS Mainframe programs to SAS EG
• Be creative to the extent that that improves the applications

Environment: MVS, ISPF, JCL, FILE AID, SAS Mainframe ,SAS EG, Cognos Impromptu, Power Play, COBOL, DB2, SQL SERVER

• Installed DB2 V 9 on Windows 2003 and planned migration from DB2 V 7.1 to DB2 V 9. As a part of this plan installed DB2 V 8 on Windows 2003 and migrated Db2 V 7.1 databases to version 8 and took back up from migrated databases and restored them on version 9 successfully.
• SwiftNet Phase 2 Project
• Identified impacted programs and modified Cobol/CICS programs to handle migration from MAC (message authentication code) to PKI (Public Key Infrastructure). New Swift message includes 2000 byte Signature in XML format.
• Mainframe upgrade project
• Completed required application testing and trouble shooting to ensure our application systems continue to run when software and hardware infrastructure upgrades occur. ( CICS TS 1.3 was upgraded to CICS TS 2.2, MVS Cobol to Enterprise Cobol and Z/OS V1.3 to Z/OS V1.4 )
• LVTS (Large Value Transfer System) V6.0 Development and implementation.
• As a member of team of 3 identified impacted programs, modified CICS COBOL programs in order to replace security system. LVTS system was modified to work with VPN clients as well as maintaining the old functionality for other users without VPN. The technology consists of MQSeries, COBOL, CICS, VSAM, VB, Defnsor mainframe.

• LVTS (Large Value Transfer System) V5.0 Development and implementation.
• As a member of team of 3 identified impacted programs, modified CICS COBOL programs in order to add a new functionality to LVTS system. The new function will be used for sending large value payments over LVTS Direct Network . The technology consists of MQSeries, COBOL, CICS, VSAM, VB
• Mainframe upgrade project
• Completed required application testing and trouble shooting to ensure our application systems continue to run when software and hardware infrastructure upgrades occur. ( CICS V 4.1 was upgraded to CICS TS 1.3, MQSeries 1.2 to MQSeries 5.3, OS/390 V2.10 to Z/OS V1.3 )
• LVTS (Large Value Transfer System) SWIFTNET project.
• Changed the MERVA/LVTS application interface to SAA/LVTS/MQSERIES application interface in order to support the incoming SWIFTNET network.
• Application consists of CICS COBOL programs that read messages from the MQSERIES queues then process and formulate outgoing messages.
• I worked also on design and development of Error handling routines and programs that monitor MQSERIES queues.
• LVTS (Large Value Transfer System ) V4.0 Development and implementation
• As a member of team of 3 identified impacted programs, modified CICS COBOL programs from specs, Modified VSAM database and DB2 tables for the new release of LVTS. This task required use of PVCS for checking out old versions and checking in new versions of Programs.
• ACSS (Automated Clearing and Settlement System) V10.1 Application interface conversion.
• As a member of team of 6 developed a new Windows based interface for ACSS system using Visual basic 6 and MS Access database. ACSS is a large MVS mainframe PC based system.. New interface consists of MS Access database, which consists of 70 tables and views, 90 VB forms and 30 different reports.
• Development of Centralized Database system and CPA Intranet
• Designed and created a relational database consisting of 6 tables using SQL Server 2000.
• As a member of team of 2, designed and developed Web Application and set up Intranet using FrontPage 2002, ASP and IIS.
• Developed WordPerfect reports and formulated views in order to merge data from database into the documents using SQL Server database views, WordPerfect and ODBC
• Upgraded existing DB2 UDB V5 databases to DB2 UDB V7.1
• Development of Bank of Canada Extracts and Reporting System for LVTS (Large value transfer system)
• Retrieval and set up data for Reporting System.
• Wrote Cobol Programs and Set up JCL to extract data from Mainframe database VSAM files.
• Used macro to download Extracted sequential files from Mainframe to PC.
• Development of Database and user Interface.
• Installed and configured DB2 UDB database in a client server environment.
• Designed tables and Formulated views and queries that satisfied our Client requests for extracting information.
• Developed Crystal reports.
• As a member of team of 2 participated in design and development of user interface.
• Providing technical support as a DBA to the internal users of 4 different databases.

Environment: MVS, ISPF, JCL, FILE AID, CICS, COBOL, MQSERIES, Defensor Mainframe, SQL,VB V6 , DB2 UDB v7.1, SQL Server 2000, MS ACCESS, IIS, Crystal Report, FrontPage 2002, ,Micro Focus Cobol , XPEDITER, PVCS, Change Management AR System

• Assist in the creation of dimensional data marts in SQL Server 7 including physical design, Load strategies and implementations
• Do Quality Insurance on data in the dimensional data marts using SQL, and Cognos Impromptu.

Confidential, Ottawa, ON (February 1999 - April 1999)
Test Analyst

Year 2000 project for the Department of Fisheries and Ocean

• Participated in preparing test scripts and test execution for a MVS Mainframe PC based System that was converted for year 2000 compliance and was upgraded from OS COBOL to COBOL for MVS.

Environment: CICS, COBOL, JCL, MVS, ISPF

Confidential, Ottawa, ON (September 1998 - February 1999)
Programmer / Analyst

Project for Inventory & Purchasing System Implementation with Canada Post Corporation

• As a member of team of 7 developed jobs for the conversion from current system to the new GEAC IP system.
• Built French screens in DCI
• Built Inventory & Purchasing Batch JCL, created unit test plan and completed unit test of Batch loading Process. Project for Priority Post Call Pickup System with Canada Post Corporation
• Produced on-line and Batch programs from specs for the Priority Post Call Pickup Service, system consisting 6 screens, 5 VSAM Files. Coded and tested all functions of the system.

Environment: MVS, COBOL II, CICS, VSAM

Confidential, Ottawa, ON (October 1997 - September 1998)
Programmer/Analyst

• Year 2000 Project for PWGSC
• Worked as a Systems Analyst on a Year 2000 Project in the Public Works and Government Services Canada (PWGSC)
• Responsible for the impact analysis for PCS (Payment Control System)

• Year 2000 project for the Canadian Payments Association (CPA)
• Impact analysis, conversion, testing, and support of various MVS Mainframe and PC based systems.
• Analyzed and validated reports generated by an automated impact analysis tool (ENG2000TM)
• Prepared unit and system test cases
• Upgraded COBOL for MVS from the previous COBOL II version
• Executed test scripts and provided support to the client during User Acceptance Testing.

Environment: MVS, COBOL, CICS, JCL, Micro Focus COBOL, ENG2000.

Confidential, Tehran, Iran (February 1995 - June 1997)
Programmer/Analyst

• Participated in the end-to-end development cycle of two large applications: a Purchase Order System and an Inventory Control system.
• Determined customer requirements, analyzed data requirements, designed the system and user interface, and prepared reports using the COBOL report writer tool.
• Provided support and maintenance services for the Inventory Control system.

Environment: CICS, COBOL, VSAM, JCL, Sequential and Magnetic Tape files, and TSO/ ISPF.

(February 1994- August 1995)

• Worked as a member of a team responsible for the development of the Personnel System for use by the Human Resources Department. Coded and unit tested on-line and batch programs.

Environment: COBOL, PL/1, CICS, JCL, VSAM.

Confidential, Tehran, Iran (December 1989 - August 1994)
Programmer/Analyst

• Participated in designing and development of interactive systems (Inventory, Payroll, Export/Import of Goods and Ordering).

Environment: PL/1, CICS, VSAM, JCL and TSO.

• Participated in the coding and testing of on-line and batch programs of the Payroll and Accounting systems for Bank of Industry and Mine.

Environment: PL/1, JCL, CICS, VM, and OS/VS1.