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.

TECHNICAL EXPERTISE

• 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

EDUCATION

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

EMPLOYMENT HISTORY

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 

Confidential, Ottawa, On (April 2000- March 2008) Programmer Analyst \\ Database Administrator

• 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 

Confidential, Ottawa, On (March 2000 – April 2000)

Test Analyst

• 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)

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)

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)

• 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)

Confidential., Tehran, Iran (February 1995 - June 1997)

• 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.