Technical Analyst Customer Service

CHEDMUND LEE

*** ********** **** ***********, ******* M1W 2J4 416-***-**** *******@*****.*** SYSTEM DATABASES AND REPORTING PROGRAMMING

SCO Open Server 5.0.4, 5.0.7, HP-

UX 10, AIX, Sun, Solaris, Linux

Windows 10, 8,7 / Windows

Server 2012

TCP/IP, DNS, DHCP

Zoom, WebEx, GotoMeeting,

Teamviewer, Skype

Microsoft Office Suite Word /

Excel / Outlook / Access /

Powerpoint / OneDrive

Google Suite Docs / Sheets /

Google Drive / Calendar / Meet

Crystal Reports

SQL Server 2010

Ingres / Sybase / Oracle

MS Access

T-SQL / PL-SQL

Store Procedure

VB6 / VBA / VBS / ASP

DOS Batch / Window Script

C++ / C

Borne Shell, C-Shell, Awk, Sed

Perl / CGI/ HTML

Java, JavaScript, Python

Visual FoxPro

EMPLOYMENT EXPERIENCE

JAN ‘13 – PRESENT (9YEARS)

CONTRACTOR - COURT OF APPEAL FOR ONTARIO

Provide remote access & telephone support of their SCO Unix network infrastructure, Ingres Application, and Court Operation

Convert & virtualize the SCO 5.0.7 Unix physical box into VM Ware Player 4.0.2 & Hyper V

Migrate the legacy SCO 5.0.4 and Ingres 6.4 application into the newly built SCO 5.0.7 VM (ie. Design, plan, implement and test)

Update & Program their Ingres application (Court Office System) to suit their business needs

Create a Court Office System Web server so that statistical report is web accessible on the intranet.

Analyze & discover Court Office System (ie. Case Preview Screen) user usage inefficiency. Develop and create a module that increases user productivity by 50% - 70%

Implement a Judicial Conflict System to help the Appeal Scheduling Unit identify any potential judge’s conflict. Appeal Scheduling Unit has reported detection rate has improved by 30% - 40%.

Able to provide the Ingres database data to be accessible into MS-SQL. Debug MS-SQL store procedure when COS Web report is not working.

Work with the Law Society of Upper Canada to load the lawyer information into the Court Office System database

Listen and gather all user’s requirements & issues to resolve all Court Office System issues

Designing & integrating Unix & Window report printing system with MS Office platform which is used throughout the COA environment.

Participated in gathering business requirements and providing feedback for design decisions.

Create an e-document generation system that is accessible on the Window server environment for users to access

Coordinate with the user and other departments on software & hardware change management with version control

Provide user documentation & training of new Court Office System modules & updates

Support & train the on-site technical support team to resolve any Window or COS issues or challenges CHEDMUND LEE

306 Timberbank Blvd Scarborough, Ontario M1W 2J4 416-***-**** *******@*****.*** JAN ‘15 – PRESENT (7YEARS)

IT ADVISOR SUPPORT– WORLD FINANCIAL GROUP

Participated in gathering business requirements and providing feedback for design decisions.

Create a simple Microsoft Access 2007 contact management database system for agents to manage contacts & activity

(ActivityLogger)

Program ActivityLogger MS DB all forms, queries, and reports by analyzing agent system workflow to customize solutions to suit their needs

Interface the ActivityLogger with the agent’s Android phone to dial out and send text messages. Also, interface with a 3rd party system API to send a text messages out

Create a Window Visual Basic Script automation to access their web-based WFG Email Campaign Manager system

Provide application support for insurance agent insurance quotation software

Setup the Window laptop to access the office’s local wireless network and printer

On occasion provide Android & iPhone cellphone support (eg. Setup mobile Salesforce application) MAY ‘12– OCT ’12 - (1 YEAR)

WEB PORTAL PROGRAMMER - SOLUTIONS 360

Developed a web-based time billing interface using Javascript, CSS, PHP, and HTML to their existing Web Portal application software

Fixed numerous existing issues of core applications written in Java, MS-SQL, and Visual Fox Pro

Met with clients for training, investigating issues and presentations

Coordinated support, development, testing, and implementation of software updates by facilitating communication between the business and technology areas

JUL ‘12– NOV ’12 - (1 YEAR)

COGENIX CONSULTING LTD.

Write MS-SQL server store procedure to transform data from Demand Solutions supply change management software into forecasting report system

FEB ‘04 – MAY ’12 – (8 YEARS)

IT BUSINESS ANALYST - TD SECURITIES, ENTERPRISE TECHNOLOGY SOLUTIONS, CAPITAL MARKETS

Gathered business requirements, wrote process specifications, developed test scenarios and automated testing applications for in house financials applications

Interviewed business leaders for gathering process data for AS-IS processes and worked with senior management for the modeling of TO-BE processes for the business continuity planning initiative

Supported nightly Linux grid-enable RiskWatch batches for market & credit risk systems from business infrastructure, architecture, and technology in related areas from a design support perspective

Analyzed the system & operation process workflow to improve system efficiency and ensure it is in compliance with corporate Disaster Recovery Plan (DRP) standards

Directed, trained, and developed staff to enable them to meet daily operational challenges to achieve their potential

Developed a Unix Shell, Perl, and several Visual Basic utilities to improve system automation which contributes to effective solution development deliveries

Performed bug, code, and function validation on application changes to ensure promotion quality CHEDMUND LEE

306 Timberbank Blvd Scarborough, Ontario M1W 2J4 416-***-**** *******@*****.*** SEP ‘98 – JUN ’03 – (5 YEARS)

TECHNICAL SYSTEMS ANALYST - ROYAL BANK OF CANADA DOMINION SECURITIES, GLOBAL MARKETS SYSTEMS,

Spearheaded teams for performing UAT, developing test cases and obtaining sign off from project sponsors by conducting sessions and communicating extensively with clients

Architected, developed, tested, and deployed a 3-teir Exotic Global Trading Client Server application using Visual Basic v6.0 COM components, RPC HP/UX Unix C servers, and Sybase 11 SQL store procedures

Supported applications to all Front, Middle, and Back Office users on a global basis in Toronto, London, and Sydney

Coordinated with other system groups to integrate their processes to suit the global need of the organization

Collected user’s requirements to process change requests and new system implementations

Reverse engineered the entire VB5 thick client into several VB6.0 COM components to separate the entire business logic from the presentation layer

Maintained and enhanced business logic layer (i.e. Unix C servers) to add additional functionality to interact with other global applications and databases, wrote several Unix & Perl scripts to perform nightly schedule processes

Added additional application functionality, write/update numerous of store procedure/triggers to generate reports/ensure data integrity

JUN ‘97- SEP ’98 (1 YEAR)

QUALITY ASSURANCE ENGINEER - ALGORITHMICS INC., QUALITY ASSURANCE

Programed various regression test scripts (Perl, Bourn, Awk) to validate RiskWatch financial instruments

Developed RiskWatch & Risk++ build & post automation Bourn script ensure its quality

Introduced process control policies that effectively improve the build development

Analyzed customer needs to document optimal hardware environment for performance testing

Designed and developed web-based license creation tool using CGI/Perl which is used by client services SEP ‘94- JUN ’97 (3 YEAR)

JUDICIAL IT SUPPORT OFFICER /INGRES DATABASE ADMINISTRATOR/SCO UNIX SYSTEM ADMINISTRATOR – COURT OF APPEAL FOR ONTARIO

Design/program/test/maintain Court Office System (Ingres) database applications

Generate Court Office System(COS) letters and statistical reports

Install, set up, and maintain various network software, operating systems and X stations such as SCO Unix, SunOs, Linux, DOS, and Window 3.1.x & Wollongong Pathway

Setup PPP, LAN, MAN and Internet network connection using a Linux box

Provide Window & COS technical support for Court Administration team, judges, and judge’s secretary EDUCATION

2006 - Oracle Database 10g Comprehensive Introduction

2005 - Life License Qualification Program (LLQP)

2004 - Canadian Investment Funds Course (CIFC)

2000 - Microsoft Certified Solution Developer (MCSD) program

1996 - SCO Unix Advanced Certified Engineer(ACE) program

1994 – Bachelor in Computer Science - University of Toronto, Computer Science and Data Management CHEDMUND LEE

306 Timberbank Blvd Scarborough, Ontario M1W 2J4 416-***-**** *******@*****.*** AWARDS

Toastmaster Advance Communicator Gold & Competent Leader

APUS Scholastic Award in Computer Science

York University Renewable Entrance Scholarship

Ontario Scholar Award

Outstanding Achievement Award in Computer Technology - Victoria Park Secondary School INTEREST AND HOBBIES

Condo Board Director

Toastmaster

Community Leader

Rollerblading

Chess & Board Games

Contact this candidate