Muhammad Bashir Ahmad

Freelance Mainframe Programmer & Quality Assurance Freelancer

629
Location:Regina, Saskatchewan, Canada
Profile:https://www.freelanced.com/muhammadbashirahmad
0
Kudos
4.0
2 Skills
$60
Rate/Hr
Muhammad Bashir Ahmad Tel: 647.880.1318
3020 Hawktail Cres Mississauga ON. L5M 6W3 Canada mbahmad07@gmail.com

EXPERIENCE SUMMARY

Accomplished Systems Analyst / COBOL / CICS/ DB2 / SQL developer with over 15 years of progressive IT experience with IBM Mainframe in all phases of Software Development Lifecycle (SDLC) in enterprise applications, which includes project lead, systems analysis, designing, development, implementation, system conversions and systems documentation. Recognized for attention to detail, adherence to system standards, and meeting business objectives through creative design and efficient implementation of enterprise systems. Possess strong analytical, problem solving and communication skills. Demonstrated ability to interact with people on different levels in a fast-paced work environment with constantly changing priorities. Expertise in the following areas:
? Analysis and Design
? SQL Programming
? Database Design and Implementation
? Data validation and Testing
? Mainframe Programming and Procedures
? Data Extracting, Formatting and Load
? Production support
? System convertion
? Requirements Documentation
SKILL SET

Industry Exposure: Banking / Finance, Telecommunication, Inventory, HR
Platforms: IBM Mainframe ZOS/390, MVS, MS Windows, Unix
Database / Access method: DB2, IMS, VSAM, Oracle
GUI/Tools: Microsoft Office, MS Project, VISIO, MS Word, Ms Excel
Languages: COBOL, Microfocus cobol, CICS, JCL, CLIST, REXX, SQL, PL/SQL, Crystal report, Easytrieve
Utilities: FTP, IDCAMS, VISIO, TSO, ISPF, SPUFI, QMF, DFSORT, FILE-AID, CICS-ABEND-AID
PANVALET, CHANGEMAN, Xpediter, Lotus Notes.
PROFESSIONAL EXPERIENCE

IT Consultant (Systems Analyst)
Sasktel International 12/2012 – date
Martens Telecommunication System is a mainframe based system that manages the circuit provisioning
process, manages jeopardy and inventory of equipment.
Responsibilities:
o Analysis planning, design, production support and maintenance telecom system in IBM mainframe / multi-platform environment.
o Production support and modification of Martens Telecom System.
o Production support and modification of Martens Telecom System.
o User change requests handling and production fixes – tickets
o Setup the Environments for QA’s and coordinate in testing
o Created detailed functional specifications for both the batch and online programs.
o Prepared detailed test cases to verify system functionality. Development includes working with the clients to gather and identify functional requirements, designed and documented technical requirements then wrote new code and modified existing code from specifications as required. Tested and implemented enhancements and /or support applications. Performed conceptual, logical and physical designs to generate computer programming specifications based on user requirements. Conducted functional testing to ensure that the application could support all requirements.
o Prepared System flow chart and Process flow chart using Microsoft Visio to illustrate the input data feeds from different sites and flow of processing of the front end and downstream feeds
o Performed as the user liaison for gathering business application requirements.
o Use of ISPF and Micro focus for compiling, managing programs and configuring system
o Using FTP to upload and download files over the internet as the application layer protocol that handles file transfers.
o The SDLC methodology used throughout the project for all phases of project planning.
Environment: IBM Z/OS, CICS, COBOL, JCL, SQL, DB2, IMS, SPUFI, QMF, VSAM, MVS, TSO, ISPF, FILE-AID, FTP, VISIO, Xpeditor, Windows-7, Word, Excel, IBM Utilities.

IT Analyst
Tier One systems 02/2008 – 11/2012
Analyzed and planned the design, development, testing and implementation and maintained payment system for funds transfer and CSI banktrade system for L/Cs and bills transaction handling in IBM mainframe environment.
o Tech Lead, production support and modification of Payment System (SWIFT).
o Systems analysis and development of payment system
o Co-leader of migration mainframe payment systems conversion to oracle server platform
o Lead Mainframe reports migration to BI/ETL environment area to facilitate end users online enquiries.
o Have information about SAS and ETL.
o Has knowledge of environments (LAN/WAN, client-server, internet/intranet).
o Managed all user change requests and added functionality enhancements to applications
o Production support of BankTrade System of CSI (Vendor) for L/Cs and Bills.
o Created detailed functional specifications for both the batch and online programs.
o Developed test scenarios and detailed test cases to verify system functionality. Development included working with the clients to gather and identify functional requirements, designed and documented technical requirements then wrote new code and modified existing code from specifications as required. Tested and implemented enhancements and /or support applications. Performed conceptual, logical and physical designs to generate computer programming specifications based on user requirements. Conducted functional testing to ensure that the application could support all requirements.
o Prepared System flow chart and Process flow chart using Microsoft Visio to illustrate the input data feeds from different sites and flow of processing of the front end and downstream feeds
o Performed as the user liaison for gathering business requirements and prepare detailed specifications for the line of business applications
o Use of ISPF for compiling, managing programs and configuring system
o Interfaced with various applications using FTP. Used FTP to upload and download files over the internet as the application layer protocol that handles file transfers.
o The SDLC methodology used throughout the project for all phases of project planning.
Environment: IBM ZOS/390, CICS, COBOL, JCL, SQL, DB2, SPUFI, VSAM, MVS, TSO, ISPF, FILE-AID, FTP, VISIO, Xpeditor, Windows XP, Word, Excel, IBM Utilities.
IT Analyst
OAO Technology 03/2003 – 01/2008
Developed, implemented and maintained inventory and vehicle system according to end user requirements. Provided overall technical support for IBM Mainframe applications.
o Tech Lead/ Systems analysis and production support of Inventory system.
o Designed, analyzed, developed and deployed Depot Shipping subsystem of Supply and maintenance Inventory System (SMI) using SDLC (System Development Life Cycle) Methodology.
o Analysis, development, and implementation and production support of Nissan auto vehicle project.
o Development included working with the clients to gather and identify functional requirements, design and document technical requirements, then write new and modify existing code from specifications, test and implement enhancements and /or support applications. Wrote SQL queries using SPUFI to examine output results.
o Acted as the user liaison roll for gathering business requirements and prepare detailed specifications for the line of business applications
o Assignment includes analysis, Investigation, fixing online and batch programs.
o Developed test strategy and test cases to verify system functionality for all of the phases of the software development life cycle.
o Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
o Prepared detailed functional specifications for both the batch and online programs.
o Use of ISPF for compiling, managing programs and configuring system.
o Participated in the on call production support periodical rotation.
o Reports for weekly progress of all the activities.
o Preparation of analysis and creation of data flow diagram.
o Documented project details and status reports.
Environment: IBM 390, CICS, COBOL, SQL, DB2, SPUFI, VSAM, JCL, MVS, TSO, ISPF, FILE-AID, VISIO, XPEDITER, Word, Excel, Windows, IBM Utilities.
Sr. Analyst
Bell Canada / CGI Telecom Information System and Services Inc. 04/2000 – 02/2003
Designed, developed, implemented and maintained production applications. Provided overall technical and on-call production systems support for IBM Mainframe applications plus maintained these systems according to end user requirements.
o Development of 416 Overlay project (replacement of compressed NPA (Number Plan Area) by full NPA i.e. Increase from 7 digits to 10 digits Phone number)
o Development of CDMA (Code Division Multiple Access) application and resolved systems problems faced by the end user.
o Analyzed user requirements and developed reports from SOF Print (Service Order Feed), PIC/CARE (Primary Interchange Carrier/ Customer Account Record Exchange) System.
o Managed all user change requests and added functionality enhancements to applications.
o Coordinated in the process of migration of Applications from PANVALET to CHANGEMAN environment.
o Developed, coded, enhanced, unit tested (wrote unit test plans using Excel and word), supported and maintained structured DB2 COBOL programming code. Batch tested programs for insertion of data into a DB2 database using COBOL for all of the phases of the software development life cycle. The SDLC methodology used throughout the project for all phases of project planning was in-house developed.
o Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
o Used TSO/ISPF to set up DB2/SQL queries using SPUFI to set up test data.
o FTP was used to transfer departmental files for testing and SPUFI to examine the output results on the DB2 database tables.
o Debug and test the programs with XPEDITER after making changes for expected results.
o Provided support for RACF in the test environment.
o Reporting for weekly progress of all the activities.
Environment: IBM 390, CICS, COBOL, SQL, DB2, SPUFI, VSAM, JCL, MVS, TSO, ISPF, FILE-AID, VISIO, XPEDITER, Changeman, RACF, Windows, Word, Excel.
IT Analyst
Carlton Cards 07/1997 – 03/2000
Using Carlton cards’ internal development methodology analyzed and planned the design, development, enhancements, testing and implementation of application system in IBM Mainframe environment.
o Responsible for systems analysis, batch and on-line programming, testing and documenting of financial and accounting systems. These systems were developed using COBOL, CICS, and VSAM.
o Analyzed, developed and deployed a customized solution for Financial/Accounts using SDLC (Systems Development Life Cycle) methodology.
o Developed and deployed online inquiries for end-users to monitor profit variations.
o Coded the new conversion program using Cobol II that handled input, editing, updating, output, and reporting alone and yet remained simple so that it would be used as a template for future conversions. A walk through confirmed correctness and an adherence to coding standards.
o Established unit and system test plans that were comprehensive and used to allow functional and path testing of the conversion part as well as other parts of the main batch system that were changing as a result of the conversion effort. Due to the complexity, automation tools such as File-Aid were used in the analysis of test.
o Created ad-hoc reports as required.
o Created and modified files and JCLs in order to test the accuracy of System modifications and running the jobs in test region before uploading to production.
o Used IDCAMS for various operations on VSAM datasets for faster access.
o Provide weekly progress report of all the activities.
Environment: IBM 390, CICS, COBOL, VSAM, JCL, FILE-AID, MVS, TSO, ISPF, VISIO, Windows, Word, Excel.
SUMMARY OF BUSINESS APPLICATION EXPERIENCE

Banking / Finance:
? Bank Trade (L/Cs and Bills)
? Payments (Local and Foreign currencies)
? Retail Banking
? Credit banking (demand loan)
? Foreign Exchange dealing
? Treasury Operation
? Banks Reconciliation
? Inter Branch Transactions
? Cheques Entry
? Repurchased cheques
? Stop and Claims of Cheques
? Vouchers Entry
? Dormant Accounts
? Foreign Correspondent Banks Statement of A/c Entry
? Vostro accounts
Telecommunication:
? 416 overlay project (replacement of compressed NPA (Number Plan Area) by full NPA)),
? CDMA (Code Division Multiple Access) extract,
? Test environment Support and RACF Coordination,
? Selective SOF (Service Order Feed) print,
? PIC/CARE (Primary Interchange Carrier/ Customer Account Record Exchange) Extract.
Inventory: Depot shipping subsystem of Supply and Maintenance Inventory System (SMI).
Human Resources: Designed, developed and deployed bank’s HR system.

EDUCATION AND TRAINING

M.Sc. Applied Mathematics
Institute of Business Administration:
System Analysis and Design
Introduction to EDP
I B M: DB2 for MVS, SQL, SPUFI, CICS, COBOL, TSO / ISPF, MVS JCL
NCR Corporation: COBOL, Introduction to Programming
CDI Corporate Education Service:
IPMP Overview
3 D Process Overview
Other courses: Oracle DBA, PL/SQL, JAVA, HTML, VB 8.0, ASP.NET 2.0
Principals of EDP Auditing
Cooperative Application of CASE (CASE TOOL)
Retail, Foreign Exchange and Credit Banking.
Seminars: INFORMIX (Open System)
SWIFT and U.S. Funds Transfer
Institute of Bankers: Banking Diploma
Citizenship: Canadian.