**** ********* *****,

Mississauga, ON

L*N *J*

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

Email: ac98b7@r.postjobfree.com

Over 20 years of technical development and design experience with multi-tier application projects in the insurance, financial, marketing loyalty, and software industries.

Microsoft Certified Professional

Extensive experience in providing technical consultating and expertise, functional requirements analysis, data/systems analysis and design

Solid knowledge of application design principles, methodologies and SDLC

Sound analytical and problem-solving skills with proven aptitude in relational database modelling and design

Provide technical expertise to ensure development plans align with long-term architecture

Programming Language:

Python, C#, VB.NET, MVC, ASP.NET, Visual Basic, SQA Basic, C/VC++, OLTP/SSIS/SSRS/DTS/Stored Procedure/Triggers, Rational Robot, Pascal, ADA, LISP, HTML, XML

Software/Technology:

SQL RedGate, Service Broker, MS TFS, MVC Entity Framework, ADO.NET, SAO, OOD, Web Services, Jira, Crystal Reports.NET, Multi-threading, XML/XSLT, ASP/DHTML/HTML, ADO, COM+, ActiveX Controls/OCX, Active Reports, Document! X, FTP, Secure Shell (SSH), various .NET framework

Database:

All versions of MS Sql Server up to 2016, Oracle, Sybase, dBase, Paradox 5.0

Modeling Tool:

Visio,Rational Rose/UML, MS Visual Modeller

Platform:

Windows Server 2013, SQL Server 2014, UNIX, AS/400, VMWare

Mainframe:

AS/400 including PLEXUS (mortgage applications), ISPF/TSO, Information Management System, DCF, JCL, DB2, COBOL

Multimedia:

Adobe Premiere, Photoshop and Lightroom CC, ULead Video Studio

Mar 2011 – Current (Contract)

Bond Brand Loyalty

Mississauga, Ontario

Lead Database Deveper/Technial BA

Architect BI solutions for real business problems and clients need

Design/Implement BI framework as a standard for all ETL related jobs

Design all database models, define and implement business processes

Lead client meetings to review solution architecture and documentation

Lead estimating efforts for new work and enhancement to existing projects

Data warehouse design for BI solution

Provide database solutioning and processes

Play a key role in supporting existing business solution by architecting and documenting changes, investigating/troubleshooting/tuning and optimization

Share technical wisdom by providing work direction, mentoring junior staff

Act as project leader with the responsibilities of coordinating a small project team

Successfully implemented numerous projects for various clients including Ford, Mazda, Hond/Acura, Toyota/Lexus, Aveda, and Mastermind Toys

Solid knowledge of SQL/DB technologies, .NET, C#, XML data structures and different operating system/browser environments

Technology used: C#.NET, ASP.NET, MVC, Framework 3.5, 4.5, 4.6 (VS 2013-2017 ), MS Sql Server 2014/2017, RedGate, SolarWind

May 2010 – Feb 2011 (Contract)

Davis and Henderson

Mississauga, Ontario

Senior Software Developer

System Integration project with Capital One client

Provides support, enhancements, and customization to Express OS (XOS), a small-business and commercial loan credit review web application

Technical design and implemention of ETL SSIS package which loads Credit Review data from Capital One to Cyence (XOS)

Provides data analysis, modelling and database design

Fix and enhancement to core XOS application to prevent cross scripting attack

Technology used: C#.NET, ASP.NET, Framework 3.5 (VS 2008), MS Sql Server

CGI – on site at Foresters

Toronto, Ontario

Jan 2008 – Apr 2010 (Contract)

Lead Developer

Provides technical consultation and development expertise on FASAT System - a comprehensive distribution management and compensation software solution designed exclusively for the life insurance industry

Performs system analysis, technical design and detailed program specifications as well as hands on coding and testing

Technical design and primary developer for Debt Recovery Methodology

Technical design and lead developers for Unity Life Feed Conversion to FASAT

Oversee all phases of the Software Development Life Cycle

Application architect/technical design, lead development, and testing

Technology used: MS Sql Server 2005, SSIS, VB.NET2003 and 2005, C#, SSRS, ASP.NET, Web Services

Mar 2009 – Sep 2009 (Contract)

Cancer Care Ontario

Toronto, Ontario

Application Architect

Provides technical consultation and development expertise leading to the creation BSPT(Biospecimen Shipping & Process Tracking) tool to track information related to specimen transportation and processing for the Ontario Health Study for chronic cancer research pilot project

Performs requirement gathering, technical design as well as hands on coding and testing

Database modelling and design

Technology used: VB.NET 2008 (framework 3.5), Visio

Mar 2007 – Dec 2007 (Contract)

Manulife Financial – Reinsurane IT

Toronto, Ontario

Senior .NET Developer/Systems Consultant

Perform .NET conversion of legacy reinsurance systems

Provide project management and leadership

Application architect/technical design, lead development, and testing

Coding, Construct and implement technical solutions to business requirements

Ensure technical solutions align with corporate architecture framework

Technology used: MS Sql Server /2005 (SP, DTS), C# (3.0 framework), IIS

Mar 2006 – Mar 2007 (Contract)

CIBC - Technology & Operations

Toronto, Ontario

Senior Programmer/Database Developer

Provide DBA role for IBCS (Integrated Business Control Systems) Server Consolidation. This project consolidates and decommission servers for Portfolio Management, Field Risk Services and National Risk Monitoring (NRM)

Provide various setup & configuration of servers (DEV, UAT, PROD, and Contingency) – install Sql Server, setup IIS

Database Migration

Perform DB backup and restore

Transfer logins and Scheduled Jobs, and reconfigure DTS packages

Develop VB utility app utilizing SQLDMO and DTSPackage object libraries. This application provides a GUI interface performing numerous DBA functionalities

DB backup & restore

Transferring & reconfiguring DTS packages

Generating Sql Scripts (logins, dts/job transfer, db restore, etc.)

Exporting & Importing DTS packages to storage file

String search capability in Stored Procedures, Triggers, Views, UDF, and Extended Stored Procedures for selected databases

Design and develop multi-threaded performance test tool for applications performance testing with VB.NET

Technology used: MS Sql Server 2000, ASP.NET, VB.NET, C#.NET, IIS, FTP

Sep 2005 – Dec 2005 (Contract)

ACNielsen Canada

Markham, Ontario

ACNielsen is the world's leading marketing information company. With 21,000 employees worldwide offering services in more than 100 countries, ACNielsen provides market research, information, analysis and insights to the consumer products and service industries.

Senior Developer/QA Analyst

Develop test automation for proprietary analytical software product, Workstation Plus

Create test strategies, design test plans, and implement test cases based on the business requirements

Ability to work in a very fast pace, time critical environment

Technology used: VB 6.0, SQA Basic, VB Script, Rational Robot, Workstation Plus

Jun 2005 – Aug 2005 (Contract)

Honda of Canada Mfg.

Alliston, Ontario

Founded in 1969, Honda Canada now ranks as one of Canada's five largest Automobile Manufacturers, the largest retailer of Motorcycles and ATVs and one of the largest Power Equipment/Marine companies in Canada.

Senior Business Application Analyst

Provide application development and enhancement to wide range of business applications. GoldTime, a time tracking system written in VB design to manage associates time management.

GoldTime project conversion to VB.NET

Creating and modification of various Crystal Report ASP.NET applications in C#

Technology used: VB.NET, C#, ASP.NET, ADO.NET, Oracle, Sql Server, Crystal Report 10, MS Access

Feb 2004 – Jun 2005 (Permanent)

DSPA Software Inc.

Mississauga, Ontario

DSPA Software Inc. is a Microsoft Technology Partner focuses on implementing sales compensation systems in the insurance industry. DSPA Software has spent over seven years working with insurance organizations such as Manulife Financial, Sun Life, Transamerica Life, Empire Financial, Equitable Life, Canada Life, AIG and RBC Insurance.

Senior Technical Analyst/Consultant

Provide application development and enhancement to large multi-user systems, FASAT. FASAT is a sales compensation and productivity software solution based on multi-tier Microsoft technology.

Engage in numerous projects consulting for DSPA clients. Including Manulife Financial, Transamerica Life, and Equitable Life performing customization, enhancements, and system optimization

Technology used: VB.NET, VB 6.0, COM+, API, MS Sql Server 2000, Active Reports, ASP, VBScript, JavaScript

Oct 2002 – Nov 2003 (Contract)

Sun Life Financial - Retail Distribution & Wealth Integration Team (formerly Clarica)

Waterloo, Ontario

Sun Life Financial is a leading international financial services organization providing a diverse range of wealth accumulation and protection products and services to individuals and corporate customers.

IT Consultant/Lead Developer

The purpose of this project is to enable Client Data System (CDS) users to manage their entire block of business exclusively through a single contract/client management system. To accomplish this, a data feed will be sent from the mainframe systems (IM) to CDS (an Advisors' desktop application) for all Clarica-branded products.

Implemented CDS Update, a mechanism, which accepts and applies mainframe data feeds to CDS. It provides 3500 plus Advisors with the necessary information to service their clients.

Participated in functional requirements gathering, design review and project risk assessment.

Provided alternative solutions and participated in recommendation.

Worked closely with lead Architect to provide technical expertise to ensure development plans align with long term architecture.

Technology used: Visual Basic 6.0, XML/XSL, COM+, API, Sybase, Borland C++, MS VSS, MS Access, MS Excel

Jun 2001 – May 2002 (Contract)

CIBC – Credit Risk Technology (division of Cibc World Market)

Toronto, Ontario

CIBC World Markets is a full-service investment bank, active throughout North America and with a range of exceptional capabilities in Europe and Asia. Credit Risk Technology is a division dedicated to providing state-of-the-art technology for credit risk evaluation.

Senior Programmer Analyst

The purpose of this project is to review and propose alternative solutions to existing data feed processes. Provide innovative solutions to improve performance and eliminate intensive procedures. Data feeds are being transmitted daily from World Market (i.e. Europe, Asia) via various file transfer methods, which are being used for trading credit risk evaluation.

Defined, designed & implemented standard COM architecture components. These components were accepted as the set of infrastructure standards across all internal applications.

Leverage & redesigned data feed processes to improved reliability, scalability, performance, automation and security.

Technology used: VB 6, COM/DCOM, MS Sql Server 2000, MS VSS, FTP, Novel & NT network environment

Nov 1997- May 2001 (Contract)

RBC Insurance (formerly Prudential Life Insurance of Canada)

Toronto, Ontario

RBC Insurance is the insurance specialist of Royal Bank Financial Group, which provides a complete range of insurance solutions to more than two million customers across Canada.

IT Consultant/Senior Systems Analyst/Developer

The purpose of this project is to create PASport, a $15 million enterprise wide Policy Administration System that allows users to manage every aspect of insurance policy administration. It records the identification and information for policy clients and agents. It tracks the status of policies and premium schedules, keeps tabs on the billing of policies, calculate commissions for agents.

Created an innovative Code Generator utility, which generates VB codes for multi-tier application development based on MS Sql Server table definition. Overall, this utility saves at least 60% of development time effort.

Assisted lead architect in the design and construction of various architectural components used for business applications.

Lead numerous development projects within PASport, including the design and development of sub-project for Premium Schedules, Client Roles, and Policy Information Inquiry application.

Proficient in the development and implementation of large sized systems.

Technology used: Visual Basic 5 & 6, MS Transaction Server (MTS) 1.0-2.0, Rational Rose 98(object modeller), ActiveX (OCX, DLL), COM/DCOM, Pure Object Oriented, MS Sql Server, Stored Procedure & Triggers, Crystal Report, MS VSS

University of Waterloo, Waterloo, Ontario

Bachelor of Honours Mathematics, Computer Science Major (Co-op program).

Courses in Computers, Mathematics, Accounting, Corporate & Computer Law, Languages, Statistics, Economics, Actuarial Science, and Physics.

Python Bible (2018)

Javascript Bootcamp (2018)

Microsoft SQL Server 2008 Report Services (2011)

Microsoft ASP.NET using C# 2008 (2010)

Microsoft ASP.NET Web Services (2009)

Microsoft Certified VB.NET Developer (2006)

Microsoft VB.NET, ADO.NET, ASP.NET (2005-2006)

Keystone's XML & Associated Technologies (2001)

Keystone’s Active Server Pages Level 1,2,3 (2000)

Microsoft Object-Oriented Analysis and Design with C++ (1998)

Microsoft Certified Visual Basic Programmer (1997)

Microsoft Solution Development Discipline (1996)

Microsoft Certified Product Specialist (WinNT Workstation -1996)

References Provided Upon Request

S

S

lution

ftware

Inn

vative

Ken Trinh

Experience Summary

Technical Summary

Work Experience

Education

(1990-1995)

Professional Achievement/ Training

Contact this candidate