Chung-Chen Lin

*** ******** *****

Ottawa, Ontario

K2G 6S2

Home Phone :613-***-****

Email: abosuh@r.postjobfree.com

SUMMARY OF QUALIFICATIONS Certified IBM Cognos 8 & 10 BI Data Warehouse Developers – IBM Cognos Data ManagerCertified IBM Cognos BI Metadata Model Developer – IBM Cognos Framework Manager.Certified IBM Cognos 8 & 10 BI Report Designer – IBM Cognos BI Report.Certified IBM Cognos BI Report User – Cognos Report Net.Proficient in IBM Cognos 8 BI products and excellent DW/BI development skill using Cognos BI tools.Excellent data warehouse and data mart implementation skill based on Ralph Kimball's Dimensional Modeling approach.Excellent problem solving and troubleshooting skills.Good communication and presentation skills and able to work individually or in a team.

WORK HISTORY

Project 1

Senior Cognos BI Developer June 2011 – Sept.

Human Resources & Skills Development Canada, Ottawa, Ontario, Canada

(3 Months)

Data mart/ Data Warehouse development using Oracle Warehouse Builder (OWB) ETL tool & PL SQL.OLAP cube and Relational metadata modeling using IBM Cognos Transformer 8 and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Setup Framework Manager Security for different users, groups and roles.Business Intelligence Report developing against Relational and OLAP cube data source by Cognos Reporting tools. Create standardized OWB ETL process documentation.

Project 2

Cognos BI Developer & Architect Nov. 2009 – June 2011

VON (Victorian Order of Nurses), Ottawa, Ontario, Canada

(18 months)

1 a)

VON (Victorian Order of Nurses) Jan. 2011 – June 2011

Cognos BI Developer & Architect

(6 months)Data mart and BI report development for varieties of VON KPI Reports to track the performance of VON service provider vs. clients by funders.Develop data mart using IBM Cognos 8 & 10 ETL tool -Data Manager.OLAP and Relational metadata modeling using IBM Cognos 8 & 10 Transformer and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Business Intelligence Report development against Relational and OLAP cube data source using Cognos 8 & 10 Reporting tools (Report Studio, Analysis Studio, Event Studio, etc.). Some advanced reports might use HTML, CSS and JAVA script to implement.ETL catalogs, Transformer & Framework Manager models, BI report content store deployment from development to production environment.Write the technical documentation for development.BI reports upgrade from Cognos 8 to Cognos 10, from 32 bit to 64 bit(OS & BI product), from SQL 2000 server to SQL 2008 server; tasks including install Cognos 10, configure and upgrade existing Cognos 8 data manager catalogs, Transformer and Framework Manager model files and deploy Cognos 8 BI content store to Cognos 10 for both development and production environments.Plan & setup Cognos 8 & 10 BI web portal access security.Writing automation scripts to refresh data marts and OLAP cube routine jobs by using database trigger and stored procedure.Participate the discussion of data archiving strategy and technical issue solution.

1b)

VON (Victorian Order of Nurses) June 2010 – Dec. 2010

Cognos BI Developer & Architect

(6 months)Data mart design and BI report development for variety of VON BI Reports to improve the performance of VON service provider’s scheduling & assignment efficiency.Develop live-data BI reports for VON meal provider across different routes & kitchens in Canada to assist them in preparing the accurate and on-demand meal delivery requests and meet the requirement of different allergy types and food preference clients.Develop the data mart using IBM Cognos 8 ETL tool -Data Manager.OLAP and Relational metadata modeling using IBM Cognos 8 Transformer and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Business Intelligence Report development against Relational and OLAP cube data source using Cognos 8 Reporting tools (Report Studio, Analysis Studio, Event Studio, etc.). Some advanced reports might use HTML, CSS and JAVA script to implement.ETL catalogs, Transformer & Framework Manager models, BI report content store deployment from development to production environment.Write the technical documentation for development.

1c)

VON (Victorian Order of Nurses) Nov. 2009 – May 2010

Cognos BI Developer & Architect

(6 months)Maintain and improve VON existing data warehouse issues by redesigning the architecture and remodeling the structure, modify the ETL codes, fix or remodel Framework Manager & transformer models.Troubleshoot the existing BI report issue and fix or redesign the reports. Data mart design and BI report development for 3 sets of EXCEL KPI Reports to improve VON branch management on the VON scheduling & assignment system.Develop the data mart using IBM Cognos 8 ETL tool -Data Manager.OLAP and Relational metadata modeling using IBM Cognos 8 Transformer and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Design and publish Finance scorecard to Cognos 8 Metric Studio by Metric Designer.Business Intelligence Report development against Relational and OLAP cube data source using Cognos 8 Reporting tools (Report Studio, Analysis Studio, Event Studio, etc.). Some advanced reports might use HTML, CSS and JAVA script to implement.ETL catalogs, Transformer & Framework Manager models, BI report content store deployment from development to production environment.Discuss, analyze and develop BI strategy for VON Single Instance project; which consolidates 7 existing Procura system (scheduling & assignment) from originally 7 different regions into one single data source. Write the technical documentation for development.

Project 3

Software Engineer July 2000 – Oct. 2009

IBM Cognos Incorporated, Ottawa, Ontario, Canada

(111 months)

1 a)

IBM Cognos Localization Oct. 2008 – Oct. 2009

Software Engineer

(12 months)Data mart and BI report development for varieties of QC testing performance monitoring reports to track QC test activity and improve project management. The BI reports are able to communicate with a web application portal by performing drill through from BI portal to web application portal.Business requirement collection and analysis create the development plan and strategy.Setup data mart& BI report development environment.Develop data mart using IBM Cognos 8 ETL tool -Data Manager.OLAP and Relational metadata modeling using IBM Cognos 8 Transformer and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Business Intelligence Report development against Relational and OLAP cube data source using Cognos 8 Reporting tools (Report Studio, Analysis Studio, Event Studio, etc.). Some advanced reports might use HTML, CSS and JAVA script to implement.ETL catalogs, Transformer & Framework Manager models, BI report content store deployment from development to production environment.Write the technical documentation for development.New versions of Cognos BI & PM product study and knowledge transfer to the team.

1 b)

IBM Cognos Localization Sept. 2007 – Sept. 2008

Software Engineer

(12 months)Data mart and BI report development for project management team to plan and review the resource and contractor hiring effectively and improve the budge spending. The BI reports should be able to perform drill through from Manager BI reports level to individual performance details. Business requirement collection and analysis create the development plan and strategy.Setup data mart& BI report development environment.Develop data mart using IBM Cognos 8 ETL tool -Data Manager.OLAP and Relational metadata modeling using IBM Cognos 8 Transformer and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Business Intelligence Report development against Relational and OLAP cube data source using Cognos 8 Reporting tools (Report Studio, Analysis Studio, Event Studio, etc.). Some advanced reports might use HTML, CSS and JAVA script to implement.ETL catalogs, Transformer & Framework Manager models, BI report content store deployment from development to production environment.Write the technical documentation for development.New version of Cognos 8 BI & PM product study and testing.

1 c)

IBM Cognos Localization Oct. 2006 – Oct. 2007

Software Engineer & Test Prime

(12 months)Data mart and BI report development for the analysis of department internal web application- Test Case Management System using newly release Cognos 8 BI product.Business requirement collection and analysis create the development plan and strategy.Setup data mart& BI report development environment.Develop data mart using IBM Cognos 8 ETL tool -Data Manager.OLAP and Relational metadata modeling using IBM Cognos 8 Transformer and Framework Manager for both relational and DMR (Dimensionally Modeled Relational) packages.Business Intelligence Report development against Relational and OLAP cube data source using Cognos 8 Reporting tools (Report Studio, Analysis Studio, Event Studio, etc.). Some advanced reports might use HTML, CSS and JAVA script to implement.Cognos 8 BI & PM products testing and product installation and configuration documentation writing.

1 d)

IBM Cognos Localization June 2005 – Sept. 2006

Software Engineer & Test Prime

(15 months)Develop web services applications against SQL DB using HTML, DHTML, CSS, ASP, VB and Java scripts as department internal tool.Created test plans, test conformances and test schedules for product testing projects.Cognos BI & PM product testing; products including Impromptu 7, Powerplay 7, IWR 7, PPES 7, Transformer, ReportNet and Cognos 8 beta reporting BI tools.Investigate and troubleshoot on technical issues, study new tools and transfer knowledge and provided the solutions to the team.Cognos products testing, bug logging and fixed bug verification. Testing environment including Oracle, DB2, SYBASED, INFORMIX, TERADATA database and across UNIX and Windows platforms.Attended project meetings, updated project status to project management team.

1 e)

IBM Cognos Localization Sept. 2003 – May. 2005

Software Engineer

(20 months)Develop and maintain Unix/Linux environment setting tool using C shell script for team to automate the UNIX/LINUX login and testing environment setup against different DBs(Oracle, DB2, INFORMIX, SYBASE etc.), the tool is transparent to users for HP-UX, AIX, Solaris UNIX systems and different flavors of Linux platforms.Create different OS and language images using VMware WorkStation for multi-lingual product testing and simulate a small network environment for client-server testing.Investigate and troubleshoot on technical issues, study new tools and transfer knowledge and provided the solutions to the team.Write and review product install and configuration documentation.Cognos 7 BI & PM products testing, bug logging and fixed bug verification.Test products including Impromptu 7, Powerplay 7, IWR 7, PPES 7 and Transformer.Testing environment including Oracle, DB2, SYBASED, INFORMIX, TERADATA database and across Unix and Windows platforms.Attended project meetings, updated project status to project management team.

1 f)

IBM Cognos Localization Feb. 2002 – Aug. 2003

Software Engineer

(18 months)Develop in-house Windows base SQL Console tool using Visual Basic 6.0 to allow users connect to MS-SQL, Oracle and DB2 database servers and manipulate SQL statements through ODBS connections from one single interface.Develop in-house Windows base tool using Visual Basic 6.0 to allow users import data from Excel files, stored to MS-SQL server, and automate multiple email sending tasks.Cognos 6 &7 BI & PM products testing, bug logging and fixed bug verification. Test products including Impromptu 6, Powerplay 6 & 7, IWR 6 &7, PPES 6 & 7 and Transformer 6 & 7.Testing environment including Oracle, DB2, SYBASED, INFORMIX, TERADATA database and across UNIX and Windows platforms.Write and review product install and configuration documentation.Attended project meetings, updated project status to project management team.

1 g)

IBM Cognos Localization July 2000 – Jan. 2002

Software Engineer

(22 months)Cognos Hotsite issue evaluation and verification for Customer Support. Cognos 6 BI & PM products testing, bug logging and fixed bug verification. Test products including Impromptu 5 & 6, Powerplay 6, IWR 6, PPES 6 and Transformer 6.Testing environment including Oracle, DB2, SYBASED, INFORMIX, TERADATA database and across UNIX and Windows platforms.Write and review product install and configuration documentation.Attended project meetings, updated project status to project management team.

Project 4

Software Engineer Feb. 1999 - Jun. 2000

Corel Corporation, Ottawa, Ontario, Canadamonths)In house tool development: developed Winboot and ImageBrowser by Visual Basic as the testing tools to improve testing performance and shorten testing time.Window base testing: tested the usability and functionality for Corel Print House, Print Office, Photo House, and Corel WebDesigner2.0 for both English and other language products.Web base testing: developed and created 2 web sites as the test cases for Corel WebDesigner2.0. The testing languages including HTML, Java and Visual Basic scripts, CGI, CSS, Forms, Frames, Java Applet and Active X .

Project 5

Software Engineer Feb. 1997 - Apr. 1998

International Integrated System Inc., Taipei, Taiwanmonths)Printer driver localization testing: localized and tested Lexmark printer driver administration tool, the test covered printer driver user interface usability and functionality, on-line help, on-line documentation, and books.Documentation testing: localized on-line help, documentation and books for windows based applications. Tools to use including WinHelp Workshop, HC31, and Hot Spot Editor. CD testing: Localized interactive multimedia tours and tutorial CD – How to Used Windows 95 into Chinese version for CRT Inc., England.

Project 6

Software Engineer Apr. 1996 - Dec. 1996

Symbio System Co., Taipei, Taiwanmonths)Technical translation for Database application development for Kansai Public Welfare Department, Osaka, Japan. In-depth knowledge of SQL Language, and Relational Database application architecture. On site testing for The Performance Monitor Work, the UNIX system monitoring application, at Landmark Co., Virginia, U.S.A. Localization test for Microsoft Windows NT and 95 Traditional Chinese editions at Microsoft Inc., Taiwan. The tests include verification on localized functionality, user interface, and stability when running with other commercial applications.

Project 7

MIS Software Engineer Jan. 1995 - Apr. 1996

Delta Electronics Inc., Taipei, Taiwanmonths)Designed and developed employee payroll database system by Visual FoxPro as the pilot project for Windows based database applications.System maintenance on both software and hardware for company internal network for over 150 employees.Database integration test and Database programming language evaluation for upgrading MS-DOS applications to Windows applications.

EDUCATION

Jan. 1994 – Aug. 1994

Computer Science Course, University of Southern California (USC), California, USA

Jun. 1993 – Dec. 1993

MBA Course, Texas A&M International University - Laredo, Texas, USA

Sept. 1992 – May 1993

ESL Course, University of California Los Angels (UCLA), California, USA

Apr. 1988 – May. 1992

B.S., Information Science, National University of Tsukuba, Ibaraki, Japan

Apr. 1987 – Mar. 1988

Japanese as Second Language Certificate, KoKuSai GaKu YuKai Japanese Language School, Tokyo, Japan

Certificate & TrainingIBM Cognos Report Net User Certificate.IBM Cognos 8 & 10 BI Data Warehouse Developer Certificate- Data Manager.IBM Cognos 8 BI Metadata Model Developer Exam Certificate – Framework ManagerIBM Cognos 8 & 10 Report Designer Certificate – Cognos 8 & 10 BI Report.Cognos 8 BI Modeling part I and part II Course Completion Certificate.Cognos Transformer 8 OLAP development Course Completion Certificate.Oracle PL/SQL Course Completion Certificate.

OPERATING SYSTEM

MS-DOS, Windows 3.1/95/NT/NT Server/98/ME/2000/2000 Server/XP/Vista

Unix: Solaris, IBM AIX, HP-UX.

Linux: Redhat Linux, SuSe Linux, and Corel Linux.

VM Ware: VM Ware Workstation & Lab Manager.

PROGRAMMING LANGUAGE AND SOFTWARE

Language: C, Visual Basic, VB Script, Java Script, ASP, HTML, SQL.

Business Intelligence Tools: Cognos Access Manager, Cognos Impromptu, Impromptu Web Report, PowerPlay, PowerPlay Enterprise Server, Transformer, Decision Stream/Data Manager, Cognos ReprotNet, Cognos Planning, Cognos Metric Manager, Cognos 8, Framework Manager, Cognos LAVA, Cognos Controller, Business View Point and TM1.

Reference Available Upon Request

Contact this candidate