Sr Developer & Analyst

Qi Chen

Database Administrator, Analyst, Modeler, Developer

DB2 V6/V7/V8/V9

ORACLE 7/8i/9i/10g/11g

Tel: 416-***-****

Email: ***.****.**@*****.***

1. PROFILE

• Qi Chen is a seasoned cross-platform DB2 / ORACLE DBA with 12 years experience on multi-platforms, from IBM MAINFRAME to distributed systems (UNIX and Windows) since 1999.

• He is a multifunctional DBA, with rich experience as both Production DBA (physical DBA) and Development DBA (logical DBA).

• He has rich experience with VLDB (very large databases) and high volume OLTP processing for critical 24 X 7 systems.

• He is a seasoned database designer / modeler / developer, with solid experience in database modeling, from conceptual model to logical model, then physical implementation.

• He has solid data warehousing, ETL (data Extraction-Transformation-Loading) & BI (business intelligence) skill, familiar with multiple solutions/products.

• He has rich experience in database migration among different database products in complex distributed system environments.

• He has strong software development background, especially database-related, with at least 400,000 lines of coding experience since 1994.

• Beyond database, he has depth and breadth of technical knowledge of IT industry, capable of making technical decisions.

Summary of skill:

• 7 years cross-platform DB2 DBA experience, from DB2 V6 up to V9, passed all IBM certifications for DB2.

• 8 years cross-platform Oracle DBA experience, from Oracle 7 up to 11g.

• 7 years DB2 SQL/PL programming for triggers, procedures.

• 8 years experience in Oracle SQL, PL/SQL, JDBC/SQLJ, OCI and PRO*C.

• 8 years experience in database modeling, for both OLTP and data warehouse.

• 8 years experience in database performance tuning & trouble-shooting.

• 8 years experience in cross-platform database migration and data conversion.

• 8 years experience in supporting large-scale development teams.

• Strong BI background, 3 years experience with Oracle BI (Siebel Analytics) and Hyperion (Brio).

• Strong ETL experience in Enterprise Reporting System (non-data warehouse).

• 13 years experience with Unix-variant hosts, including AIX, HPUX, Solaris / Sun OS, Digital Tru-64, SVR4 for Motorola 68k/88k, SGI IRIX and Intergraph CLIX.

• 5 years experience with IBM Z/OS (OS/390).

• 8 years experience with C & Perl programming.

• 5 years experience with Power Builder and Delphi.

• A certified CCNP (routing and switching), with in-depth knowledge of TCPIP network management system.

• Exposure to Microsoft SQL Server, MySQL, PostgreSQL, Sybase & Informix.

2. WORK EXPERIENCE

2.1. DB2 DBA Aug / 2010 – Jun / 2011

BMO (as IBM contractor)

Toronto, ON

• Being the primary development DBA and level 3 production support DBA in charge of risk-management banking data warehouse (200+ Terabytes).

• Supporting the full SDLC (Systems Development Life Cycle), working in DEV, QA, SIT/UAT and Production environment, with DB2 V8.2, 9.1 & 9.5, on AIX 5.3 & 6.1.

• Building, deploying and administering distributed DB2 database management systems, using multiple high availability features (DPF, HACMP, HADR).

• Managing, tuning, and resolving issues in large Data Warehousing environments.

• Managing availability, data integrity, and security in large Data Warehousing environments.

• Diagnosing performance issues, tuning SQL and XML/XQuery.

• Performing back up and recovery.

• Performing database auditing.

• Performing capacity/performance planning & management, using multiple performance features (DPF, MDC, MQT).

• Performing data modeling.

• Writing Perl and Shell scripts to automate DBA tasks.

Use of Time: 70% DB administration, 30% enhancement development.

Technical Environment: DB2 V8/V9 for LUW, Oracle V9/10g/11g, ERWIN, Rational Data Architect, Perl/Shell, Java, SQL, PL/SQL, SQL/PL.

2.2. Product Manager Jun / 2009 – Jun / 2010

NetStars E-Commerce CO., LTD.

Qingdao, China

• Product management for mobile applications.

Use of Time: 70% management, 30% architecting.

Technical Environment: Android, Linux, Java.

2.3. Senior Dev DB2 DBA Feb / 2009 – Apr / 2009

Prinova Inc.

Kitchener/ Toronto, ON

• Database migration from DB2 V7 on Z/OS to DB2 V8 on Z/OS.

• Database migration from DB2 V7 for LUW to DB2 V8 for LUW.

• Database migration from base development environment (MySQL) to multiple product environments (Oracle, DB2 on Z/OS, DB2 for LUW, MS SQLSERVER).

• Application data migration for Oracle, DB2 on Z/OS, DB2 for LUW, Microsoft SQLSERVER.

• Supporting the full life cycle of software development, DEV, QA, SIT/UAT and Production.

• Database modeling for new application functions.

Use of Time: 90% database migration, 10% database modeling.

Technical Environment: DB2 V7/V8 on Z/OS, DB2 V7/V8 for LUW, Oracle 10g on multiple platforms (Linux, Solaris, Windows), Microsoft SQL Server 2005, MySQL, Perl/Shell, Java, ERWIN, PL/SQL, SQL/PL, JCL, REXX.

2.4. DBA / PLSQL Developer Jul / 2008 – Jan / 2009

Noetix Research Inc.

Ottawa / Waterloo, ON

• Geo databases administration for joint projects with University of Waterloo.

• Database modeling for new application functions.

• PL/SQL module development for new application functions.

• Managing availability, data integrity, and security.

• Diagnosing and tuning performance issues.

• Performing back up and recovery, and database migration.

• Capacity planning & management.

Use of Time: 50% database administration, 50% database modeling and development.

Technical Environment: Oracle 9i/10g on multiple platforms (Irix, Linux, Windows), PostgreSQL, PL/SQL, MS SQLSERVER 2000/2005, ERWIN, Perl/Shell, Java.

2.5. Senior DBA / BI Dev Leader Apr / 2005 - Mar / 2008

IBM(China) Global Delivery Service

Dalian / Beijing, China

Siebel BI development leader (April 2006– October 2007)

• Being assigned to Motorola North-Asia Retail & Channel Management team (a 40-million US$ project), the biggest Siebel BI implementation then in China.

• Working throughout all phases of Data Warehouse development, including prototyping, requirement analyzing, logical & physical modeling, developing, deploying, SIT/UAT testing, and documentation

• Performing data mapping and ETL definition between Siebel OCRM database and ACRM database, creating and sustaining enterprise reporting data warehouses to fulfill enterprise reporting strategies and objectives..

• Managing and delegating daily tasks to a team of 4 Siebel Analytics Developers, receive guidance from architects and provide guidance for ETL developers.

• Doing Siebel Analytics development.

• Building, deploying and administering distributed Oracle/Siebel environments for testing and system integration purposes.

• Diagnosing and tuning performance issues, doing capacity planning & management.

Use of Time: 70% development, 20% system administration, 10% Team Lead.

Technical Environment: Siebel Analytics, Oracle 9i/10g on multiple platforms (Solaris, Windows), Informatica, PL/SQL, Perl/Shell, ERWIN.

Senior DB2 DBA (April 2005– March 2008)

• Being DB2 DBA for IBM (Global) Enterprise Business Intelligence Hyperion CoC, support IBM’s report systems based on Hyperion Performance Suite (Brio).

• Design, develop and maintain the enterprise reporting data warehouses for IBM (Global) to fulfill enterprise reporting strategies and objectives.

• Building, deploying and administering distributed DB2 database management systems for developing, testing and system integration purposes, using multiple high availability features (DPF, HACMP, HADR).

• Supporting the full SDLC (Systems Development Life Cycle), working in DEV, QA, SIT/UAT and Production environment.

• Managing, tuning, and resolving issues in large Data Warehousing environments.

• Managing availability, data integrity, and security in large Data Warehousing environments.

• Diagnosing performance issues, tuning SQL and XML/XQuery.

• Performing backup, recovery and database auditing.

• Performing capacity/performance planning & management, using multiple performance features (DPF, MDC, MQT).

• Writing Perl and Shell scripts to automate DBA tasks.

• Performing database modeling for new function modules.

• Performing database development (stored procedure/trigger/UDF using SQL/PL & Java) for new function modules.

• OLAP development and administration using Essbase

Use of Time: 70% database administration, 30% database modeling and development

Technical Environment: Hyperion Performance Suite (Brio), DB2 V7/V8/V9 on multiple platforms (AIX, OS/390, OS/400), Perl/Shell, JCL, Rational Data Architect, Java, SQL/PL, Essbase.

2.6. Senior DBA Sep / 2000 - Mar / 2005

Lenovo Systems Services Co. Ltd.

Guangzhou/Beijing, China

• DBA lead for several critical large-scale database systems of telecom service providers of China, e.g. Guang Xi Mobile (provincial level, 30+ oracle instances), Guang Xi Telecom (provincial level, 20+ oracle instances), Shanxi Telecom (provincial level, 30+ Sybase instances), Qing Hai Telecom (provincial level, 10+ oracle instances), Beijing Telecom (metropolitan level), Wen Zhou Telecom (regional level, 10+ oracle instances), Daqing Telecom (regional level), etc.

• Development DBA/Database modeler of billing and accounting systems for several Telecom service providers, physical modeling, schema design.

• Database application prototyping for conceptual billing & accounting processing, ETL processing and reporting systems.

• Building, deploying and administering distributed Oracle/DB2 database management systems.

• Managing, tuning, and resolving issues in large OLTP and ODS (operational data store) environments, managing availability, data integrity, and security.

• Diagnosing and tuning performance issues, especially with troublesome OPS/RAC technology at that time.

• Performing back up and recovery, performing database auditing

• Performing Capacity planning & management.

• Doling database server-side development and troubleshooting.

• Providing guidance for developers in database-related issues.

• Doing database engine troubleshooting and fixing, especially with troublesome OPS/RAC technology at that time.

Use of Time: 50% as production DBA, 50% as development DBA

Technical Environment: Oracle 7, 8, 8i, 9i, 10g & DB2 V6/V7 on multiple platforms (AIX, HPUX, Solaris, Windows, HP (Digital) Tru64, IRIX), MS SQLSERVER V7/2000, Sybase ASE, C, PRO*C, PLSQL, SQL/PL, Transact-SQL, Perl/Shell, ERWIN, Power Designer, PowerBuilder, Delphi.

2.7. DBA May / 1999 - Aug / 2000

Ricsson Group

Guangzhou, China

• Production DBA for CRM databases of Guangdong Mobile.

• Development DBA/Database modeler for several databases for CRM applications based on CTI (computer telephony integration) and IVR (interactive voice responder) technology provided by Lucent.

• Building, deploying and administering distributed Oracle database management systems.

• Managing, tuning, and resolving issues in OLTP environments.

• Managing availability, data integrity, and security in OLTP environments.

• Diagnosing and tuning performance issues.

• Performing back up and recovery, database auditing, capacity planning & management.

Use of Time: 50% as production DBA, 50% as development DBA.

Technical Environment: Oracle V7/V8 on Solaris, Sybase ASE, MS SQLSERVER V7, C, PRO*C, PLSQL, Perl/Shell, Transact-SQL, PowerBuilder, Delphi, ERWIN, Power Designer.

2.8. Database developer Jul / 1994 - Apr / 1999

Chief Top Computer Co. Ltd.

Zhuhai, China

• Enterprise MIS system developer, majoring on database development.

Use of Time: 100% development, with emphasis on database development.

Technical Environment: PowerBuilder, Delphi, Oracle 7 on Solaris, MS SQLSERVER V7, Sybase on Solaris, Perl/Shell, C, PRO*C, PLSQL, Transact-SQL.

3. EDUCATION / PROFESSIONAL DEVELOPMENT

3.1. Bachelor of Arts in History, Lanzhou University (China) 1994

3.2. Informix database training 1997

3.3. CA data model & process model training (ERWIN & BPWIN) 1998

3.4. HP HP9000 & HPUX system administration training 1998

3.5. IBM RS6000 & AIX system administration training 1999

3.6. Sun storage training 2000

3.7. Cisco routing & switching training 2001

3.8. IBM DB2 training 2005

3.9. Hyperion(Oracle) Essbase & OLAP training 2005

3.10. IBM project management training 2005

3.11. Siebel(Oracle) Business Intelligence (Siebel Analytics) training 2006

3.12. IBM leadership training 2007

4. CERTIFICATIONS

CCNP (Cisco Certified Network Professional) Routing & Switching 2001

CCNA (Cisco Certified Network Associate) Routing & Switching 2001

IBM Certified Advanced Database Administrator – DB2 Universal Database V8.1 for Linux, UNIX, and Windows 2005

IBM Certified Database Administrator – DB2 Universal Database V8.1 for Z/OS 2005

IBM Certified Database Administrator – DB2 Universal Database V8.1 for Linux, UNIX, and Windows 2005

IBM Certified Application Developer – DB2 Universal Database V8.1 Family 2005

IBM Certified Solution Designer – DB2 Business Intelligence V8 2005

IBM Certified Database Associate – DB2 Universal Database V8.1 Family 2005

5. PROJECTS SUMMARY:

Project Name & Summary Duration Role Products, Languages & Tools

banking risk-management data warehouse 2010/08

to

present DB2 DBA DB2 V8/V9 for LUW (on AIX)

SQL, SQL/PL(DB2), Korn Shell, Perl

Erwin, Rational Data Architect, PVCS, Eclipse.

Database migration

Migrate database schema and data from development platform (Mysql) to various production platforms 2009/02

to

2009/08 Senior DEV DBA DB2 V7/V8/V9 on IBM Z/OS (OS/390, MVS), DB2 V7/V8/V9 for LUW (Linux, Unix & Windows), Oracle 10G, MS SQLSERVER 2000/2005, Mysql, SQL, SQL/PL(DB2), PL/SQL(ORACLE), JCL, Perl, JAVA, XML, Eclipse, Erwin, Toad.

Canadian Cryospheric Information Network (CCIN) 2008/07

to

2009/01 DBA,

PL/SQL

Developer Oracle 10g, PL/SQL, Perl, JAVA, XML, Toad, Erwin, Eclipse.

Siebel BI for Motorola

The Business Intelligence part of Siebel CRM 2006/04

to

2007/10 Business Intelligence Dev Leader Oracle 9i/10g, MS SQLSERVER 2000/2005, Siebel Analytics(Oracle BIEE), PL/SQL, Perl/Shell, Informatica, Erwin, Toad, Eclipse, Bugzilla, Subversion(CVS), LoadRunner.

IBM (Global) Enterprise Business Intelligence Hyperion CoC 2005/04

to

2008/03 Senior DBA DB2 V7/V8/V9 on IBM Z/OS (OS/390, MVS), DB2 V7/V8/V9 for LUW (Linux, Unix & Windows), Hyperion Performance Suite (Brio), Essbase,SQL, SQL/PL, JCL, Perl, Java, XML, Rational Data Architect (RDA), LoadRunner, TestCenter.

Billing and Accounting System for Telecom service providers

More than 10 projects

(This is an application skeleton that would be customized for different customers. It has been implemented for more than 10 customers. Each implementation/deployment should be counted as a different project since lots of customization involved.)

2000/09

to

2005/03 Senior DBA,

Data Modeler Oracle 7/8/8i/9i/10g, DB2 V6/V7, Sybase ASE, MS SQLSERVER, C, Perl/Shell, Java, SQL, Transact-SQL, PL/SQL, PRO*C, Toad, Erwin, Power Designer, Power Builder, Delphi, Eclipse, Bugzilla, Subversion(CVS), AutoRunner, TestCenter, LoadRunner.

CRM & Call Center

for Telecom service provider 1999/05

to

2000/08 DBA,

Data Modeler Oracle 7, Sybase, MS SQLSERVER,C, Perl/Shell, JAVA, SQL, Transact-SQL, PL/SQL, PRO*C

Erwin, Power Builder, Delphi, Subversion(CVS).

Enterprise MIS & Website Dev

Many projects

Management Information System for small-medium-size companies had been implemented/deployed for at least 50 customers, and should be counted as many projects since lots of customization involved. 1994/07

to

1999/04 Developer Oracle 7,Sybase, MS SQLSERVER, SQL, Transact-SQL, PL/SQL, C, PRO*C, Shell, Perl/CGI, HTML,

Power Builder, Delphi.

Contact this candidate