Resume

Sign in

Filenet Datastage DB2 MySQL MSSQL Sybase Oracle security guardium

Location:
Kitchener, ON, Canada
Posted:
September 24, 2020

Contact this candidate

Resume:

FELIX KUAN

OBJECTIVE:

Seek a challenging IT Professional opportunity.

Experiences

Core system transformation Administrator III 11/2019-present

Encova Insurance – Insight Global Columbus, Ohio

Short term consultant to production support Filenet, Kofax, Datacap, Guidewire, Mulesoft, Oracle, Linux and MS-SQL related systems including migration, upgrade and refresh.

DB2 Software Engineer 10/2019 – 11/2019

Veritas Technology LLC with NetPolarity Roseville, MN

Short term consultant to implement DB2 NetBackup solution using TE-Perl, Automation Test Engine, XBSA API and C, C# and C++ to develop Veritas NetBackup solution codes on Linux, AIX, HP-UX, Windows, ZLinux etc platforms.

Source control with bigbucket, JIRA and test engine.

Work on NetBackup release with DB2 version functions change and problem solving like logretain and userexit.

Filenet P8 and ICM Admin 05/2019 – 10/2019

National Government Services with Anchor Point Indianapolis, IN

Short term consultant support WebSphere 9.0, Filenet P8 CPE 5.5.2, IBM Content Navigator 3.0.5,IBM Case Manager 5.3.3, Case builder, Case analyzer, CMIS, Datum RapidCase, RapidAssemby, LetterGen, with Oracle,MS-SQL and Linux.

Using JIRA, BigBucket, version control and Thycotic Secret Server.

Information Security Engineer 5 06/2018 – 05/2019

Wells Fargo bank /ATR International Chesterfield, Michigan

Short term consultant work with DB2, Sybase, Oracle, MSSQL, Teradata, Informix, MongoDB, MySQL, Guardium, Splunk,Optim and Delphix data masking.

Support Risk Matrix, 2FA and Data masking projects.

Experience with security frameworks and regulations i.e. PCI DSS, SOX, SOC1, GLBA, NIST, ISO 270001.

work together to use and implement Guardium, DBSmart,CyberArk EPV and Splunk tools wth different database products.

Support and participate Data Governance. Data isolation, data lake and data masking project.

Application Developer 02/2018 – 06/2018

Bayview Asset Management/Insight Global Coral Gable, Florida

Short term consultant to help document ingestion process papervision migration project. To support Filenet CSS BPM 5.5, ICN 3.0.2, DataCap 9.1, WebSphere 9, Filenet Enterprise record, Encapture and MSSQL.

Image Capture: Capturing the digital image or the physical doc fed through an input device (scanner, fax, phone, multi-purpose copy machine, etc).

OCR: Converting an image into a text based searchable document

Database Architect – IT manager 08/2014 – 12/2017

MUFG Investor Services Waterloo, Ontario, Canada

IT manager of IBM product support team for EDM IS workflow, NAV Dashboard and DWH business with 3-7 direct reports.

As a project manager to work with CGI's project manager together for EDM project which uses Filenet 5.2 Content management, BPM (case foundation), IBM content navigator, Datacap, eForm, case manager, Case analysis, WebSphere, InforSphere DataStage, QualityStage, Cognos BI 10.2.1,Watson explorer, Red Hat Linux, MSSQL and DB2 BLU Databases, Trustwave DbProtect, Solarwind, Kaseya.

As a developer of EDM solution of Cognos, Filenet, DataStage and Datacap .NET and Java coding.

As an education coordinate EDM project training

Project manager for eFax migrate project.

Work with content metadata and content security.

Support, configure and build DB2 BLU on RHEL Linux and Windows servers.

Support and design Business intelligent and Data Warehousing solution.

Design and create data models to support reporting and data management processes.

Design and implement data synchronization routines from source systems to the data warehouse (ETL, Validation). Database performance monitoring and tuning.

Develop and maintain Infosphere Datastage ETL application which to convert 7 different fund related information into DB2 for Cognos to process and For DWH reports. Upgrade InfoSphere from 9.1.2 to 11.5.1.

Review and approve schema and design changes.

Manage the backup and restore process.

Configure, monitor and troubleshoot database and system issues.

Perform Root Cause Analysis for incidents and outages.

Participate database and application monitor tools Solarwind, Trustwave DBProtect.

Setting up and maintaining Development, Test and Production environments for the MS SQL, MongoDB, MySQL, PostGreSQL, DB2 databases, Infosphere, Datastage, Watson Explorer, Cognos, Filenet, eForm, WorkplaceXT, Case manager and ICN (IBM Content Navigator),Datacap, webSphere, MS SQL SSRS SSIS and SSAS, Replication, AlwaysOn group, etc. on Linux and Windows servers.

Configuring high availability, failover and disaster recovery (Business continuity).

Developing with scripting language CLI, Perl, Python, Bash, KSH, java, Powershell, .NET and DevOp.

Work with compliance officers and auditors to make sure security, regulation and compliance be certified. Participate internal and external audit.

Practice AWS cloud solution in lab for AWS EC2 S3 RDS etc.

Proof of concept of following products - biginsight, Netezza, DataPower, Informix Dynamic server, InfoSphere Optim, Guardium, MDM, Stream, Tableau, MySQL, MongoDB, PostGreSQL etc.

Build and manage IBM License Metric Tool ( ILMT ) server and provide report for IBM licenses usage.

Database Application Admin – ERP system support 03/2011 – 02/2014

Memorial Healthcare System Miramar, Florida

Support Infor Lawson S3 ERP and Filenet/Kofax systems.

IBM 04/2002 – 12/2010

DBA Waterloo, ON, Canada

DBA to support MS-SQL,Sybase, Teradata, Infomix, PostGreSQL, Oracle, WebSphere, PostGreSQL, MySQL, KSH and Perl on Windows, AIX, UP-UX, Solaris and Linux mid-range platforms and High availability solution.

Play as a project manager role for class 1 RFS projects like Tumbleweed/SQL, Tax Balance/SQL, QIP/Sybase, CWB/SQL roll out etc.

Support several mission critical MS SQL Cluster, Log shipping VERITAS clustering HA system and VMWARE ESX.

Support Sybase MainframeConnect for OS/390.

Support Sybase/Remedy replication warm standby high availability environment.

As a DBA lead role on many accounts Manulife, John Hancock, MaritimeLife, Equifax, TD bank, Canadian Wheat Board, Bell Canada, Brookfield, Irving Oil, Rogers.

Provide 247 production DBA support and 8X5 QA/UAT/DR/DEV/POC environment support.

Provide system DBA support tasks like performance tuning, backup/restore, SSIS, ETL, database consulting and maintenance.

Perform IBM GSD331/ITS104 data security audit, health checking, Privilege id revalidation.

Developing with scripting language CLI, Perl, Python, CSH, KSH and java.

Creating/migrating/upgrading database instances and databases/table spaces.

Designing, implementing and monitoring backup/recovery and DR plans.

TSM client and TDP/SQL agent support.

Support ETL process DTS package, SSIS and SSAS.

Setup control-M scheduler jobs.

Support Manulife VUI Filenet migration project.

Follow change/problem/RCA management policy and use Infoman, e-ESM, Remedy USD & IMPACT etc with ITIL V3 standard.

Support and apply up to date CIRATE, APAR and patches for all databases environments.

Use Tivoli, MOM, SCOM and homemade script to monitor database.

Trouble shooting and root cause analysis for database problems.

Provide monthly databases inventory and metrics reports.

Offshore coordination with IBM Argentina, IBM India.

Support bank internal and external KPMG audit task.

Work as an IBM project manager for class 2 RFC project work.

Intermediate Technical Specialist & DBA 06/1998 – 04/2002

Manulife Financial Waterloo, ON, Canada

DBA to support Sybase,Oracle,DB2 and MS-SQL SSRS SSIS SSAS.

Intel/Windows NT server Admin.

UNIX (AIX & HP-UX) & ADSM/TSM Admin.

INTEL/NOVELL Security Admin role.

Support Sybase MainframeConnect for OS/390.

Support Sybase/Remedy replication warm standby high availability environment.

Provide 247 production DBA support and 8X5 QA/UAT/DR/DEV/POC environment support.

Support Delta team which implement end to end mutual fund & GIF trading system infrastructure & performance.

Support Network and system performance test.

Support Manulife VUI Filenet migration project.

Build, Migrate, upgrade, install and configure Novell/Windows NT/AIX/HP-UX servers.

Backup/restore user data using ArcServe and ADSM.

Trouble shooting and root cause analysis for database problems.

Provide monthly databases inventory and metrics reports.

Provide system & database support tasks like performance tuning,backup/restore,consulting and maintenance.

AWARD:

IBM Bravo Appreciation Award.

IBM THANKS award.

Manulife Financial CIO achievement award.

Manulife Financial Pride award.

Manulife Rave award.

CERTIFICATION:

CyberArk CyberArk Certified Trustee

MCSD Microsoft Certified Solution Developer

MCDBA Microsoft Certified Database Administrator

MCSE Microsoft Certified System engineer

DB2 IBM Solution expert – DB2 UDB V7.1 DBA

OCA DBO Oracle 8i Certified Internet Database operator

TSM IBM Certified Deployment Professional - Tivoli Storage Manager V5.2

FCP IBM FileNet P8 4.5 Certified Administrator

AIX IBM Certified Specialist – AIX V4.3 System Administrations

HP-UX HP Certified HP-UX 11.0 System Administrations

CCNA CISCO Certified Network Associate

CNA Certified Novell Administrator

A + Certified Service Technician

HP-UX HP-UX System Administrator

HP SA HP Certified System Administrator

TRAINING:

MONGODB MongoDB M001 MongoDB Basics

MONGODB MongoDB M103 Basic Cluster Administration

CyberArk CyberArk Privileged access Security course

SPLUNK Splunk 7.x fundamentals part 1

FILENET IBM FileNet Content Manager 5.0 & 4.5 : Implementation and Administration (F115G)

BPM IBM FileNet Content Manager 5.0 : IBM FileNet BPM Administration (F144G)

WebSphere IBM WebSphere Application Server V8.5.5 Administration (ZA855G)

ICN IBM Content Navigator 2.0.2: Customize and Extend the Features (F120G)

DB2 IBM DB2 10 for Linux, UNIX and Windows Bootcamp (CAMPDB2-220)

DataCap IBM Datacap Taskmaster 8.1: Configuration and Implementation (F168G)

Cognos IBM Cognos 10.2 Framework Manager: Design Metadata Models (J2252)

Cognos IBM Cognos 10.2 Administrator (J2255)

BigInsights IBM Big Data Fundamentals Bootcamp (CAMPBDATA-100)

DataStage IBM InfoSphere DataStage Fundamentals Bootcamp (CAMPDSF-200L)

QualityStage IBM InfoSphere QualityStage Fundamentals Bootcamp (CAMPQSF-210L)

BigInsights Data Click V10 for Big Insights - WBT - InternalPartner 1M230i

IBM Big Data IBM Big Data Fundamentals Bootcamp (CAMPBDATA-100)

BIG SQL IBM BigInsights Big SQL - WBT - InternalPartner 1W632i

InfoSphere IBM InfoSphere Warehouse 10 and Smart Analytics System Training (CAMPISW-260L)

Netezzs IBM Netezza Bootcamp Introduction

Informix Informix Dynamic Server Bootcamp (CAMPIDS-210L)

Informix InformixWarehouse Bootcamp (CAMPIDSW-200)

Guardium InfoSphere Guardium Bootcamp (CAMPGRD-300L)

Optim InfoSphere Optim Solutions for Distributed Systems Bootcamp (CAMPOPT-230L)

Sybase Power up to ASE 15

Sybase System and Database Administration: Adaptive Server Enterprise 12.0

Sybase Fast Track to Replication Server Administration 12.0

Microsoft Implementing Microsoft Windows 2000 Clustering

MySQL MySQL DBA course

VCS/VOM VERITAS Cluster System simulator & VERITAS operations manager course (IBM internal)

Oracle 8i Database Enterprise DBA Part 1B: Backup and Recovery

MongoDB MongoDB NoSQL self study

ConchDB ConchDB self study

LAMP Self study LAMP Linux, Apache,MySQL, PHP and TOMCAT

CISSP CISSP - IBM internal training course

ITIL ITIL v3 - IBM internal preparation training course

MAJOR PROJECTS:

PaperVision Migrate legacy Papervision 12 millions documents to Filenet P8 system with Datacap.

GuideWire Merge Filenet Kofax system for Motorist insurance and BrickStreet insurance.

NETBACKUP modify DB2 version updated related perl codes.

Data Isolation support test for DB2 and Sybase codes.

Data Masking data masking solution deployment project.

EDM Hedge fund trading and DWH system with Filenet, Datacap,DB2, Cognos & InfoSphere. Develop eForm solution.

Filenet ECM Upgrade ECM FileNet P8 from 3.5.2 to 4.5.1 and 4.5.1 to 5.1.

Filenet UVP Upgrade Filenet Oracle 7.3.4 to 8.1.7.

WebSphere Migrate 10 WebSphere ND from v6 to v7 and v8.5.

EPSi Deploy AllScripts EPSi.

Skyline Upgrade SkyLine Annually.

Lawson upg Upgrade Lawson S3 annually from 2011 to 2013

DR exercise DR exercise three times for Sovera and Lawson.

Delta End to end mutual fund trading system performance improvement.

E-Messaging Install/upgrade E-vault/MOM/SQL on VCS/MCSC clustering

GB Hub Install/upgrade GB Vital Object HUB SQL clustering project.

InoDirect Migrate 200 InfoDirect servers from MarineTime Life to IBM servers farm.

PACE Migrate Remedy/Sybase warm standby system

QIP Security Network Setup/upgrade Websense, Site protector, Integrity & QIP SQL/Sybase

Sybase GW Migrate Sybase DirectConnect/MainframeConnect CICS system

ChangePoint Upgrade Changepoint/SQL system

DB2 Upg Upgrade DB2 V7.1 to V8 and Lawson S3 DB2 upgrade to 9.5 and 9.7

Tumbleweed TumbleWeed/SQL fine tune.

EDUCATION:

Master of Business Administration (Courses taken) Wilfred Laurier University, Canada

Master of Computer Science/Applied Mathematics National Chung-Hsing University, Taiwan

Bachelor of Industrial Engineering University of Feng-Chia, Taiwan



Contact this candidate