Profile

15 years Cobol experience at IBM mainframe and Unix/Linux micro focus

5 years working experience on multiple MS Access systems such as Access 2007 and 2010.

15 years programming experience working with C/UNIX and 5 years programming of C and Oracle.

1 year Amdocs Bill Formatter development experience and 2 years billing process experience.

3 year project management experience.

2 year experience of PHP/Apache/MySql PERL ASP VB scripts HTML SQL Server programming experience on windows.

Demonstrated ability of setup and trouble shooting experience on Sun Solaris system administration.

Expert at Linux/Unix shell scripts cron - jobs and backup.

Effective oral and written communication skills.

A good team player goal and dead line oriented.

Over 11 years financial system including 6 years retail /online bank system development maintenance operations and support experience

5 years experience in social assistance system of housing including leadership experience in development operations support and user testing of following projects System migration from SCO to RedHat Cron Job and Rental Supplement New Owner Code etc.

7 years working experience in public sector including 5 years in government and 2 years in air force.

Technical Skills

Languages Cobol C/C Unix Shell AWK Sed Assembler JCL VB VB.net Java scripts PHP Html DHTML ASP Perl

Data Base Systems MS SQL Server 2000 Oracle 7.0/8.1/8.5/9.2/11 g DL/1 Informix

Operating Systems Windows 95/NT/2000/XP/Vista/Server 2008 HPUX HP3000 DOS SCO Unix RedHat Linux5/6 Suse Linux Sun Solaris

Network TCP/IP SNA

Software Vi FTP SMTP Telnet MS Office Word Excel and MS Project

Hardware PC HP-UX SGI Onyx SUN 450 work station IBM mainframe.

Professional Experience

Confidential

Write Cobol K-shell bash c-shell perl awk sed SQL server store procedures MS batch job programs for Housing System.

Operating System Windows Vista Windows 7 SCO Unixware RedHat 5/6 and TIP online system etc.

Language Cobol SQL Unix/Linux Scripts k-shell c-shell bash awk sed VB.net etc.

Maintain and trouble-shooting many housing related programs create cron jobs for nightly batch process.

Be on-call support for nightly jobs.

Database SQL server Oracle 11g MS access etc. Files system ISAM SAM.

Recent project system migration from SCO Unix to Linux Red Hat 5 and 6.

Confidential

Write Perl Batch VB and K-shell scripts and programs to implement file transfer by using Connect Direct.

Operating System Windows Red Hat Linux MVS OS400 etc.

Language Schedule tasks cron jobs SMTP email system etc.

MTD Files Transfer System Transfer day-end files from merchandise to RBC mainframe

CARDS File Transfer System Jan 09 Transfer daily files between RBC and merchandise

DR system Jan 09 Set up Disaster Recovery System environment unit test SIT and UAT.

Confidential

Rewrite pharmacy and dental claiming system from Micro Focus Cobol to PL/SQL.

Database Oracle 9

Operating System HP-UX HP3000 .

Language Cobol PL/SQL shell scripts cron jobs etc.

Confidential

Create reconciliation ABM reports including deposit payment and transfer summary and detail reports by using C Unix Informix sql and ace reports.

Modify and insert new reconciliation logic into existing online ATM transaction system by using C at AIX platform.

Insert new attributes into existing Informix database table to calculate amount of new ATM transactions.

Create reconciliation ACE reports by using SQL.

Prepare test cases for unit test and user acceptance test.

Run ATM report by End of Day batch job for testing.

Create test report by using excel.

Operating System HP-UX HP3000 .

Confidential

As a contractor of Moore Canada my job is coding trouble shooting and debugging Micro Focus Cobol C and K-Shell scripts syncsort for printing programs including Loomis Rogers Cycle 38 Ajilon and Adecco Sunlife DRP and TD T5/R3/T3/R16 projects. Connect Direct File Transfer Station project using ASP.

Operating System HP-UX HP3000

1 Ajilon and Adecco project

Get input data from customer create print file and XML file of T4 tax and reports by using Micro Focus Cobol and Shell Scripts.

1 TD water House project

Get EBCIDIC file from customer create T3/R16 and T5/R3 print file XML file and reports by using Micro Focus Cobol Shell Scripts.

2 Connect Direct for File Transfer Station project. Apr/07

Use Direct Connect to replace FTP by using ASP including file selection dividing and transferring to

File Transfer Station server.

3 Primus Communication project Apr/07

Investigated and fixed a bug in AFP splitting program of system by using C and Shell.

4 Manulife Mutual Fund Statement project Feb 2008

Accept data from customer create account statements in PDF for Client Representative and Dealer create reports and CD files by using C and shell.

5 Flex Server project

Transfer files from different projects to Flex Server by using Shell scripts Awk and Sed.

6 Guardian Confirm CPC report project Aug/07 using C and shell scripts

7 Hydro One T4/T4A project

To create a report for Canada Post to print and calculate weight of which mailing package by using C and AFP modeling

Confidential

Rogers Invoice Validation Data Format System Project A Production Revenue Assurance System Invoices creating and processing using Bill Formatter Oracle Cobol C Toad SQL HPUX shell Awk sed sqlplus php html dhtml java script and C/C .

Confidential

E Mail archive and search project Create update and search email files at Suse Linux 9.3 and Oracle 10 using shell Awk sed sqlplus php html dhtml java script and C/C .

Modules PHP-OCI PHP-MimeDecode imap Sq l scripts CSS etc.

Confidential

Market Research Project Scan paper into excel files using VBA. Send email automatically using ASP.Net.

SMTP client side program to send e mail by Base64 encode-decode algorithm using C programming Vi editor FTP Telnet on unix.

Internet Caf Management System PHP/MySQL/Apache HTML DHTML.

Workflow project-Multi language translation program Translated displayed statement of web system among different languages according to an excel file using C excel xml asp VB script java script and asp.net.

Software Development Change Management Work Flow ASP VB scripts Java Scripts IIS and SQL Server.

Confidential

Duties Electronic equipment assembling.

Confidential

Duties Electronic equipment assembling.

1 Confidential

2 Coded debugged and trouble shot system modules such as applications for mobile buzz funds transfer account statement inquiries change of mailing address and contact number. Developed front-end system using JSP and HTML.

2 Developed business modules and front end system using C JSP Perl TOAD and debug tools of SCCS

3 Created shell scripts of process scheduling using cron-job c shell and k shell.

4 Controlled version of SIT UAT and production using the tools of SCCS

2 Confidential

3 Coded debugged and troubleshot a simulation system using C programming and shell scripts IRIX SGI unix system TCP/IP and debug tools of CVS

4 Prepared test cases for QA SIT and UAT

5 Wrote documents of system modules

6 Mentored programmers in the development of their skills

7 Demonstrated systems to customers

Confidential

Transaction process received message from front system updated database Oracle sent message back to front system. Technology C Oracle SQL and shell.

Batch process daily process monthly process and annual process and house keeping process. All reports are in mainframe. Front system could get them through report receive process.

Managed project of a payroll system in 17 cities across China that worth 15.4K US Dollars.

Environment: Unisys A series/U series Oracle 7.0 AT T Unix SCO Unix C/C programming and SQL shared memory message queue and TCP/IP.

Confidential

Developed coded tested maintained and troubleshot saving system based on PC-Xenix environment using C and Cobol.

Developed interest calculating system printing and display sub-system.

Developed coded tested maintained and troubleshot daily batch process of saving and card accounts using Cobol DB2 IMS DB/ DC CICS and assembler.

Created report of balance sheet branch transaction records list.

System migration from 4381 to ES9000. Recompiled source code backed up database from 4381 and restored to ES9000.

Project SAFEII System of Advanced Financial Environment Interactive Interface system and RMB savings system

Environment: IBM 4381 ES9000 JCL DL/I MVS VSE/SP VSE/ESA IBM 370 Assembly language.