Developer Life Insurance
Resume:
Mississauga, ON
Cell: 416-***-****
Email: *************@*****.**
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