System Project

Sebastian Yuan Xue

** ********** **** *** **: 416-***-****

North York, ON, M2H 1N4 E-Mail: ***********@*****.***

• 15 years Mainframe and Micro Focus Cobol experience at IBM mainframe and Unix/Linux.

• 5 years working experience on multiple MS Access systems such as Access 2000,2003, 2007 and 2010.

• 5 years Cobol, IBM 370 Assembler, CICS, DLI and DB/DC experience.

• 15 years programming experience working with C/UNIX and 5 years programming of C++, Oracle and PL/SQL

• 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, PL/SQL, Assembler, JCL, VB6, 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/11g, 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

Programmer Analyst Jan/15 – Present

Greenwich Associations

• Write perl, shell script and xml configuration files for marketing tools of DASH and Confirmit.

Programmer Analyst Jun/09 – Oct/14

Social Development Department of New Brunswick

• Write Micro Focus 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, PL/SQL, Unix/Linux Scripts (k-shell, c-shell, bash, awk, sed),VB6, VB.net, etc.

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

• on-call support for nightly jobs.

• Support llean six-Sigma project.

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

System Support Analyst Dec/08 – Jun/09

Moneris Solutions Inc.

• 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

• 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: Transfer daily files between RBC and merchandise

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

Programmer Analyst Jul/08 – Oct/08

Express Script Inc. (ESI)

• 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

Programmer/Analyst Apr/08 – Jul/08

Scotiabank International

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

Programmer Analyst Jan/07 – Mar/08

Moore Canada

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

• Ajilon and Adecco project (Jan/07-Feb/07)

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

• TD water House project (Feb/07-Mar/07), (Oct 07-Feb 08)

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

• Connect Direct for File Transfer Station project.(Apr/07)

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

o File Transfer Station server.

• Primus Communication project (Apr/07)

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

• Manulife Mutual Fund Statement project (May/07-Jul/07) (Feb 2008)

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

• Flex Server project (May/07-Jul/07)

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

• Guardian Confirm CPC report project (Aug/07)

o using C and shell scripts

• Hydro One T4/T4A project (Nov 07-Jan 08)

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

Programmer Analyst Jan/06 – Jan 07

Rogers Inc. (Sent by Data Format Consulting and ITSP Inc)

• Rogers Invoice Validation Data Format System Project

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

Programmer Analyst Oct/05 – Dec/05

Front Line Technologies Inc.

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

Programmer Analyst Sep/04 – Sep/05

Electronic QC Technologies Inc.

• Market Research Project: Scanned paper into excel files using VBA.

• Automatic email sending by using ASP.Net.

• SMTP client side program to send e_mail by Base64 encode-decode algorithm using C

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

Customer Representative Jan/04 – Apr/04

Digital Security Controls Ltd.

• Assembling electronic equipment

Shanghai, China Mar/03 – July/03

Customer Representative Jan/02 – Jan/03

Digital Security Controls Ltd.

• Assembling electronic equipment

System Administrator Aug/00 – Nov/01

Overseas Union Bank, Singapore

Project: IBC (Internet Bank for Customer) and ACU (Asia Currencies Unit) system.

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

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

• Created shell scripts of process scheduling using cron-job, c_shell and k_shell.

• Controlled version of SIT, UAT and production using the tools of SCCS

Programmer Aug/98 – Aug/00

Singapore Engineering Software PTE Ltd, Singapore

Project: Air traffic simulation system

• Coded, debugged and troubleshoot a simulation system using C programming and shell scripts, IRIX (SGI unix system), TCP/IP and debug tools of CVS

• Prepared test cases for QA, SIT and UAT

• Wrote documents of system modules

• Mentored programmers in the development of their skills

• Demonstrated systems to customers

Programmer/Analyst/Project Manager Aug/95 – Aug/98

Unisys China Ltd, Shanghai

Project: Payroll system for a telecommunication company of telephone charges of PTSB. 1997-1998 Postal Telecommunication Savings Bank (PTSB).

• Transaction process: received message from front system, updated database (Oracle), sent message back to front system. Technology: C, Oracle, SQL and shell.

• All reports are in mainframe

• All reports received (batch process): daily process, monthly process and annual process and “house keeping” process could all be accessed through front system

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

Software Engineer Jul/90 – Aug/95

Bank of China Shanghai Branch

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

• Developed, coded, tested, maintained and troubleshoot 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 IBM 370 Assembler language.

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

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

Education & Training

1986 – 1990 Bachelor Degree of Computer Science

East China University of Science and Technology, Computer Science Department

2000 Java Programming Singapore Engineering Software Pte, Ltd

1994 Certificate of Senior Programmer

1995 Certificate of System Analyst

2003 Certificate of Patent of Chinese Character Input Method

References available upon request

Contact this candidate