OBJECTIVES
To obtain Mainframe Developer or Programmer Analyst position in a company where I can demonstrate sound and logical business, technical and team-work skills to produce effective results
PROFILE
IT Professional, who is a Canadian Citizen, with over 15 years’ of diversified experience of analyzing, designing, developing, testing, documenting and supporting complex software systems. Detail-oriented worker, who has efficiently performed modifications and enhancements to software systems ensuring compliance with requirements of users, customers and stakeholders. Team collaborator who has done effective code reviews on software programs to ensure consistency in coding standards. Dynamic person who possesses excellent communication, analytical and problem-solving skills.

TECHNICAL SKILLS
Languages: COBOL, DB2 SQL, PL/SQL, SQL Stored Procedures, UNIX Shell Scripting, SAS
Databases: DB2, IMS, Informix, Oracle
Environments: IBM S/390, MVS, CICS, HP-UNIX, SCO UNIX, DOS/VSE, Windows (2000 / XP)
Hardware: IBM Mainframe Servers, HP Servers, NCR 8250 and 9300 Servers
Packages: VISIO, Microsoft Office, Ingenium 6.3 (COBOL based Insurance Package)
Utilities: INSYNC, SYNCSORT
Source Integrity Tools: MKS
Familiarity: WAN/LAN, TCP/IP, security and communication protocol concepts
Documentation Tools: Lotus Notes, Test Director, Quality Center

EXPERIENCE

Confidential (Ottawa, Ontario)
Application Developer II (Mainframe) Jan 2008- Dec 2009

Environments: Multi-server on-line and off-line batch
Hardware: IBM Mainframe Servers
Operating System: S/390
Software: Mainframe COBOL, SAS, DB2 SQL routines, INSYNC, JCL, Ingenium 6.3 (COBOL based Insurance Package)
Data Bases: DB2, IMS

• Reviewed and suggested improvements to technical specifications and Mainframe COBOL code work written by peers to ensure that they meet client expectations
• Wrote technical specifications for new programs and enhancement to existing ones, ensuring accuracy and relevance to technical requirements and organizational goals
• Efficiently coded and tested changes and enhancements to COBOL based programs
• Ensured that assigned development work followed applicable organizational and industry standards and that code was clear, efficient, structured and easily maintainable
• Collaborated with business analysts, data architects and account teams including off shore people working from India to develop and integrate software solutions that best met clients’ needs
• Supported application systems in production including problem analysis, resolution, escalation and reporting which resulted in timely delivery of required files and reports to the management and users
• Provided day and night time oncall support and made emergency changes to software programs and scripts in case of job abends, documented them according to company standards and ensured that these changes were permanently incorporated into the system by following up with the managers and developers

Confidential (Mississauga, Ontario, Canada) Mar 2003 – Dec 2007
PUROLATOR COURIER LIMITED (Mississauga, Ontario, Canada) May 2000 – Feb 2003
Technical Consultant (Programmer/Analyst)

Environments: Multi-Server on-line and off-line batch
Hardware: HP Servers
Operating System: HP UNIX
Software: Microfocus COBOL, COBOL, Database Stored Procedures, UNIX Shell Scripting
Data Bases: Oracle 9i, Informix
Source Integrity Tool: MKS

• Modified, tested and implemented periodic software enhancement packages, known as Managed Releases, where changes to Accounts Receivable and Billing Systems were incorporated to ensure compliance with dynamic corporate requirements
• Coded, tested and implemented key software programs with embedded SQL using optimized SQL queries for fast and accurate processing of jobs
• Introduced audit SQL scripts to ensure accuracy of data across different related database tables to ensure sanctity of data
• Simplified batch processes written in Cogni Case to make future maintenance easier and less time consuming by converting four to six layer processes into one to two layers
• Rewrote key COBOL programs to minimize processing time by using most efficient techniques in embedded SQL, thus reducing their processing time to less than half, enabling provision of timely reports to the users and management
• Made customized changes to the COBOL based Invoicing and Billing Systems for US customers to meet their requirements
• Developed and implemented procedures for running online and batch systems using UNIX shell scripts, Cogni Case scripts and database stored procedures
• Ensured that the latest versions of all modified programs, routines and database procedures and triggers were stored in MKS by performing periodic checks

Confidential (Karachi Pakistan)
Senior Programmer Analyst / Team Lead Jan 1994- Dec 1999

Environments: Client/Server and off-line batch
Hardware: IBM Mainframe, 80486 and Intel based Pentium machines, NCR9300
Operating System: MVS, SCO UNIX, SVR4 UNIX, DOS/VSE, VSAM
Software: Micro Focus, COBOL, ANSI COBOL, ITX COBOL and RM COBOL, Oracle PL/SQL
Data Bases: ORACLE, DB2

• Managed and coached, as hands-on team lead, a team of six programmer analysts who were involved in development and implementation of in-house financial packages named Inter-branch Reconciliation, Consolidation of Transactions, Periodic Reporting, Foreign Exchange Management System and Branch Banking System
• Acted as key liaison between the users and analysts who were developing these software systems
• Developed PL/SQL and UNIX shell routines to process back office batch jobs
• Developed and standardized query routines for on-line inquiries using PL/SQL
• Trained departmental and branch users of the bank to use newly developed packages
• Developed and implemented UNIX shells and procedures for fine tuning the operating systems at user sites according to the requirements of application packages
• Authored portions of user manuals, operation manuals and system manuals for in-house developed software packages
• Managed three software systems developed in COBOL on IBM mainframe server with DB2 as the database, making improvements and changes according to user requirements
• Reformatted and migrated VSAM structured COBOL based flat file data from DOS/VSE environments to Oracle database environments running under UNIX operating system to ensure speedy processing of data
• Developed PL/SQL and UNIX shell routines to process back office batch jobs
• Developed and standardized query routines for on-line inquiries using PL/SQL
• Trained departmental and branch users of the bank to use newly developed packages
• Developed and implemented UNIX shells and procedures for fine tuning the operating systems at user sites according to the requirements of application packages
• Authored portions of user manuals, operation manuals and system manuals for in-house developed software packages
• Managed three software systems developed in COBOL on IBM mainframe server with DB2 as the database, making improvements and changes according to user requirements
• Reformatted and migrated VSAM structured COBOL based flat file data from DOS/VSE environments to Oracle database running under UNIX operating system to ensure speedy processing of data

EDUCATION AND TRAINING

B COM.

Technical Courses

• ORACLE RDBMS & Tools
• UNIX Operating System
• Informix RDBMS & Tools

Business Analysis Courses (At Nextient Canada)

• Introduction to Business Analysis
• How to Gather and Document User Requirements
• Project Management Overview