Roger Yang Email & Phone Number

Sydney, Nsw, Au

Sydney, New South Wales, Australia

Works on database management and performance tuning, supporting or testing large scale web-based distributed applications on containers Apache/Tomcat, JBoss, Web Logic, and Web Sphere in a Unix environment, developing on a SaaS, PaaS, or Cloud Infrastructure product/solution with concurrency, multithreading, and distributed system architectures, including Unix development, navigation, file manipulation, permissions, searching/finding files and text contents, and administrative actions.

Sydney, New South Wales, Australia

 Lead to support IBM Cognos Analytics users worldwide for BI resolutions on IBM Premium and Cloud products. Troubleshoot the clients issue of the applications, reporting, modelling and databases, built same system environments to reproduce the client problems, have the meetings with clients to support complicated cases, fix the clients’ difficult problems and win the high score of clients satisfaction without any negative feedback, have a very good cooperation with the team and share my broad knowledge and experience to other peers.

Sydney, Australia

Lead to provide technical support and development for IBM Cloud platform that helps developers rapidly build, manage and run web and mobile applications. Focus on support and development of the Cloud infrastructure, applications and services such as containers, node.js, API Connect, DB2 on Cloud and Cloudant etc. on the IBM Cloud platform.Use problem determination skills, while harnessing the knowledge across IBM to deliver support to like-minded developers who are at the forefront of moving their respective companies to the public, private and/or hybrid cloud, with technologies such as Java, node.js, Hypertext Preprocessor (PHP), Python and Ruby amongst others.

Lead to design and implement DB2 database systems integrated with other applications or data warehouse etc. for many IBM clients such as RACV, David Johns, Metlife Insurance, Westpac Banking Corp. etc. Provided database system architecture design, database installation and configuration, huge data analysis, HADR/TSA and Cluster implementation, TSM backup scheduler, performance tuning, database health monitoring, system support and trouble shooting etc. Won the IBM GTS Excellence and Eminence (Tier 2) Award in 2012.

Sydney, Australia

Lead to support IBM customers with DB2 database systems and related tools such as DB2 Clients, gateway, connectivity related products, Optim Data Studio, Websphere, jcc drivers, DB2 Mainframe etc.Lead to Support IBM World Wide DB2 database servers including Data Partitioning Feature, connectivity and application programming tools with the strong DB2 diagnostics and debugging skills, strong DB2 System performance and recovery experience by reviewing DB2 trap files, core dump analysis, db2support utility and DB2 tracing etc.Led to support DB2 database products application in customers, includes tools FTS (Follow the Sun 24*7 Urgent Case for customers) and WT(World Trade Normal Long Running Case for customers) as PMRs (Problem Management Records) handling. Provide Advanced technical support assistance to customers using problem determination/problem source identification skills. Works closely with the DB2 development lab to correct identified issues. Utilizes technical and negotiation skills in collaboration with other support operations/organizations to prioritize and diagnose problems to resolution. Communicates action plans to the customer or IBM representative as appropriate. Recommends and implements new or improvements to existing technical support tools, procedures, and processes. Provide training for and mentor others in the team. Contributes to department attainment of organizational objectives and high customer satisfaction.

Shanghai, China

Developed a Generator Web Server System independently and analyzed the whole software about data running flow, database building and the interfaces of all core modules, with the languages of C++, HTML and CGI technology etc.Analyzed the business requirement and made the data modeling included many types of banking business such as deposit, loan, CIF, card, payment, general ledger and so on.Developed the Core Commercial Banking System (CCBS) for China Construction Bank (CCB) Shanghai in the IBM 40-member financial project, The system was programmed in MVS, CICS, IMS/DB, JCL and COBOL etc. on IBM S/390 Mainframe, and got the bank transactions from front end based on Unix and Informix database.Implemented and maintained the Data Center Consolidation (DCC) of the China Construction Bank (CCB) Core banking system. The system ran on IBM OS/390, CICS sysplex, IMS/DB, JCL, COBOL and REXX language etc. Made the data conversion from old system to the new CCB DCC system for many branches, analyzed the data mapping between the old system data and the new one, transferred the large amount of data in a short time with the new modules programmed in JCL, REXX and COBOL.Created the structure of the IFW ODS solution to meet ICBC bank ECIS system requirements, adjusted the ECIS ODS model based on DB2 on OS/390 Mainframe.Lead the team in AIX DB2 access engine developments, system benchmark and DB2 performance tuning for IBM CBOD (Core Banking On Demand) system, keep the CBOD DB2 system stable and CICS platform maintenance, ported the mainframe core banking system to open system AIX successfully.

Master, Computer Science

Activities and Societies: Basket Ball teamDatabase research

Bachelor, Computer Science

Activities and Societies: A Newsman/Report for UniversityComputer Software