Data Medical

Resume of Yanjie (Luke) Zhao, citizen of Canada Resume dated on Aug. 12, 2015

Email Address: ****.****.********@*****.*** Ontario Security Clearance until Dec. 5, 2016

Mobile Phone: 647-***-**** or 306-***-****

CAREER HIGHLIGHT

Total IT Career in North America: 16 years (Canada since 2000 and USA in 1999 ~ 2000)

Business Analyst and BI Analyst roles 4 yrs (2005 ~ 2014) for healthcare, education & environment, practised BABOK, DMBOK

Architect role 7 yrs (2005 ~ 2015) for designing large application systems, practised TOGAF, Zachman, EABOK, DMBOK, BIZBOK

Software Team Leader role 6 yrs (2005 ~ 2011) for leading up to 20 developers + 1 tester, practiced SWEBOK, BABOK, agile, etc.

Technical Project Management role 6 yrs (2005 ~ 2011) for 61 projects (the largest revenue $10 million), practised PMBOK, ITIL

Software Developer role 9 yrs (1999 ~ 2015) for developing enterprise/government large application software systems

System Programmer role 5 yrs (before 2000) for inventing & implementing software vendor’s algorithms, compilers

Consultant: 5 yrs for Government of Saskatchewan, eHealth Ontario, CML Healthcare Inc., Chicago Stock Exchange

Practiced Paradigms: TOGAF, Zachman, IBM RUP, CMM, SOA RM, UX, ITIL, EABOK, DMBOK, BIZBOK, SWEBOK, BABOK, PMBOK, agile

Experienced Business Analysis Platforms:

Database: 15 yrs since 1999 on Oracle, SQL Server, MySQL, DB2, Access, and NoSQL: MongoDB with Java API

ETL: 3 yrs since 2006 on Oracle OWB, Microsoft SSIS, IBM DataStage, Pentaho Data Integration

BI Application and Reporting: 5 yrs on Oracle BI Discoverer, Oracle Reports, JasperReports

Scripting: 15 yrs on Oracle PL/SQL, SQL Server T-SQL, DB2 SQL, MySQL, SAS

Modeling Tool: Visio, Enterprise Architect, SmartDraw, BoUML, PowerDesigner, ERwin, MySQL Workbench, Oracle Designer

Documentation Tool: Microsoft Project, SharePoint, Exchange, Lync and Skype for Business, Office

Notation and Markup Language: UML, ERD, BPMN, XML, WSDL, XSD, HTML 2-5

Experienced Other Programming Platforms:

Java OO Programming: 10 yrs since 1997 on Java, J2SE/J2EE (EJB, Servlet, JSP, JSTL, JMS), Apache Spring, Hibernate, Apache Wicket, Java SE/EE, SWT, GWT, JasperReports, Oracle ADF, BI Publisher on JBoss, Tomcat, OC4J, WebLogic, WebSphere

C++ OO Programming: 10 yrs since 1992 on Sun Forte C++ & Gnu C++ on Unix, Borland C++ & Visual C++ on Windows

C Structured Programming: 10 yrs before 2003 for TCP/IP event broker, C compiler, string search, data encipher & compress

Scripting Programming: 10 yrs since 1990 on Unix Shells, JavaScript, JQuery, Perl, Tcl/Tk

Logical & Functional Programming: 5 yrs on Object-Oriented Prolog, Common Lisp, Mathematica, Maple, XSLT, XQuery

Network Protocol: TCP, SDP, UDP, IP, IPsec, ICMP, SMTP, FTP, LDAP, HTTP, SOAP, JNLP, UUCP, SSH, SSL, TLS, AMQP, HL7

Knowledge: big data, data mining, faceted retrieval, mobile architecture, C# .Net architecture, cloud computing, MDA

Experienced Healthcare IT Standards: 12 yrs on HL7 v2/v3, LOINC, DICOM, IHE, EHRS, PHC EMR, CDISC, CDA, XDS, ASTM for device

English Presentations: about 50 requirement specifications, 10 RFPs, 17 papers for journals and 12 international conferences

CAREER SUMMARY

2012 – 2015: consultant for Government of Saskatchewan: development of Java web applications and data warehouses on Oracle,

data modeling, performance tuning, Java-Oracle platform upgrade, business analysis: report investigation, BI reports

2011 – 2012: architect/team leader for CML Healthcare: 3 contributed & 3 required architecture design and data modeling for

government & clinic integration, web GUI in HTML5, UX design, testing scenario, release support, team recruiting

2011 – 2011: senior information architect for eHealth Ontario: web service application/infrastructure/security architecture design,

data modeling and staging, platform migration from DB2 on MainFrame to Oracle-SQL Server on Linux Server

2005 – 2011: architect/team leader for CML Healthcare: 4 web/desktop application systems’ architecture & infrastructure design

data modeling, data warehouse, BI applications, data integration, web service, UX user interface design, software

development in Java, C++, Oracle and other databases, ITIL management, team leading, project management,

business analyst and BI analyst roles: 48 specifications, BI analysis on data warehouse, IT solutions for business, etc.

2000 – 2005: senior developer for CML Healthcare: data modeling, server side application development in Java and C++ on MySQL

2000 – 2000: system programmer for Soliton Associates: development of compiler and string search utility in C on Linux

1999 – 2000: software consultant for Chicago Stock Exchange: development and data modeling of stock reconciliation on Oracle

1990 – 1999: R & D researcher for Japan Mitsubishi and others, system programmer for software vendor, university assistant fellow

CAREER HISTORY

1.Job Title: Consultant (contract full time)

Duration: May 2012 ~ 2015 May (3 years)

Employer: Information Technology Division, Ministry of Central Services, Government of Saskatchewan, Regina, Canada

Played Roles: Development work with architecture design

1.1.Solution architecture design work with hands-on coding:

Designed and proposed architecture for 3 education application systems’ platform upgrade from Oracle 10g to 12c (4000 tables), Forms to Oracle ADF or Apex or QAFE, Reports to BI Publisher or JasperReports, Java J2SE & J2EE to Java SE & EE, OC4J to WebLogic, Sun Solaris to IBM AIX, Windows XP to 7, and a smaller system merge into a big system.

Modeling tools: Visio for the architecture design, PowerDesigner for the data model changes.

Designed and implemented a portal prototype on Oracle Apex 4.2, Oracle PL/SQL on existing Oracle database, to show the possibility of using Oracle Apex in the proposed 3 education application systems’ platform upgrade, in a team of 2.

1.2.Information architecture design work with hands-on coding:

Designed architecture for platform upgrade, improvement, and enhancement of 4 Data Warehouses (7000 tables):

oThe 4 data warehouse: for ministries of education, economy, environment, labour relations and workplace safety.

oPlatform upgrade design: from Oracle 10g to 12c, OWB 10g to ODI 12c, BI Discoverer 10g to 11g, Solaris to AIX, give up Unix Shells on 4 servers machines, and no change to Oracle BI Suite (OBIEE) and OLAP server.

oArchitecture: based on Kimball architecture, designed the entire new architecture by 1) clearly separating ETL, data vault, data marts, BI applications, and error processing aspect, 2) separating database objects for code tables, master data, transient data, metadata, and control/management data, 3) accurately implementing star schema.

oImprovement: 1) based on start schema, built clear dimension and fact tables by extracting historic time data from complex change log tables, 2) ETL data extracting from entire to incremental, 3) restricted data marts dating to the end of yesterday, 4) job scheduling and email sending from Unix Shells to Oracle database scheduling.

oEnhancement: added 1) confirming system for data consistence, 2) error event schema and data cleansing, 3) master data manager, 4) dimension change manager, 5) metadata manager for both data vault and data marts, 6) security manager, and 7) created data warehouse development naming convention.

Modeling tools: Visio for the architecture design, PowerDesigner for the data model changes.

Proposed ITIL based Service Asset and Configuration Management for Ministries’ Software Products to a director.

Fulfilled 5 performance tuning tasks for Education Data Warehouse in Oracle PL/SQL, OWB, Unix Shells and by using PowerDesigner, Visio. Some amazing Successful performance tuning examples:

oOn a daily run ETL package, improved runtime from 13 hours to 10 min, code size from 10K lines to 2K lines.

oOn SQL script of a Discoverer report, improved code size from 6K lines to 100 lines, runtime from 2 hrs to 30 min.

1.3.Business analysis work:

Investigated all business reports in 3 education application systems for preparing the platform upgrade project and a report demography change project, documented 774 reports with their 30+ maintenance properties and 50+ logo images, where decommissioned 97 reports by talking with 20+ business analysts, and found 20+ hard coding problems.

Created new BI reports on provincial Environment Data Warehouse by using Oracle PL/SQL, Oracle BI Discoverer.

1.4.Development work:

Implemented data persistence, server business logic, Web user interface, financing system integration, quality monitoring, reporting for creating a new education Web application system by using JavaScript, JQuery, CSS, Java, Servlet, JSP, JSTL on WebLogic, Oracle PL/SQL, Reports, JDeveloper, StarTeam, SharePoint, under an Agile team of 9.

Led a team of 2 and implemented project Ministry Demography Changes on 2 education application systems’ 391 reports, and created a logo/signature image registry on Oracle database, by using Oracle PL/SQL, Reports & Forms, Java, JSP, PowerDesigner, JDeveloper, StarTeam, BMC Magic.

Designed & implemented Web Browser Detection and Analysis in JavaScript, Java, Oracle database PL/SQL, JDeveloper.

Maintained 2 education application systems and their portals, created a certificate image registry, by using JavaScript, Java, Servlet, JSP, Oracle PL/SQL, Forms, Reports, PowerDesigner, JDeveloper, Photoshop, StarTeam, BMC Magic.

Improved existing ETL packages, data marts and reports, built new ETL packages, data marts and reports, created job schedulers, and repaired damaged data, for provincial Education Data Warehouse, and Implemented several fundamental dimensions in star schema by merged timestamp data from complex change log in the data warehouse, by using Oracle PL/SQL, OWB, BI Discoverer, Unix Shells, PowerDesigner, StarTeam, BMC Magic, SharePoint.

Created a new data mart on provincial Environment Data Warehouse by using Oracle PL/SQL, OWB, Unix Shells.

Joined a project to upgrade 2 education application systems by Oracle 10g to 11g, Forms 10 to 11, Reports 10 to 11, Java 1.4 to 7, OC4J to WebLogic, JDeveloper 10 to 11, Sun Solaris to IBM AIX, Windows XP to 7, in a team of 20+.

Joined a project to upgrade Windows from XP to 7 and MS Access by examining 800+ applications, in a team of 10+.

2.Job Title: Architect/Team Leader (contract part time)

Duration: Jun. 2011 ~ Apr. 2012 (11 months)

Employer: CML (Canadian Medical Laboratories) Healthcare Inc., Mississauga, Canada

Played Role: Architect, Team Leader

2.1.Solution Architect and Information Architect Roles:

Used Visio for architecture design and Sparx Enterprise Architect for data & component modeling for the following:

Designed architecture for company’s Radiology Information System and PACS integration with eHealth Ontario’s project DI/PACS web service via XDS (Cross-Enterprises Document Sharing) registry on AMQP, by using HL7, SOAP, PKI digital signature, WSDL, Java Spring-WS on Oracle database, Tomcat, Linux Server, based on IHE, CDA, DICOM.

Designed architecture for eHealth Ontario’s project OLIS (Ontario Lab Information System) eOrdering web service integration with company’s lab information system and partners’ clinic EMR systems, including lab and cooperated clinics’ business process changes, by using HL7, SOAP, PKI, WSDL, Java Spring-WS on Oracle database, Tomcat application server, Linux server, based on EHRS, PHC EMR, CDISC.

Contributed, designed and proposed architecture for Lab Information System’s cytology ordering-testing-reporting-sharing integration among clinic EMR systems, CML specimen collection centres, vendor’s cytology information systems, and AIM’s Cytobase, and prototyping of its corresponding web user interface, based on UX, EHRS, PHC EMR, CDISC, and prototyped in using HL7, HTML5, JavaScript, Java Spring-WS, GWT on Oracle database, MySQL, Tomcat application server, Linux server, Windows, Android tablet, Apple iPad. Praised by cytology manager and vendor.

Contributed, designed and proposed architecture for Cardiology Information System’s ordering-reporting integration with clinic EMR systems, and prototyping of its corresponding web user interface, based on UX, EHRS, PHC EMR, CDISC, and prototyped in using HL7, HTML5, JavaScript, Java Spring-WS, GWT on Oracle database, MySQL, Tomcat application server, Linux server, Windows, Android tablet, Apple iPad. Praised by doctor, manager and vendor.

2.2.Information Architect Role:

Contributed, designed and proposed architecture for clinic EMR data analytics (about data & service quality, financing query, medical statistics, data and images for clinical trial and medical research, etc.) on a shared MySQL data warehouse by importing data from clinic EMR systems and the in-house data warehouse via Pentaho Data Integration, HL7. Praised by an EMR system owner.

Modeling tool: Visio for architecture design, Sparx Enterprise Architect, MySQL Workbench for data modeling.

Designed architecture and renewed data model for the in-house data warehouse and its BI applications by introducing Pentaho Community Edition, its connection to Oracle and MySQL, and its HL7 ETL integration.

Modeling tool: Visio for architecture design and Sparx Enterprise Architect for data modeling.

Transferred operational and billing data from in-house data warehouse to Oracle Data Mining in Oracle PL/SQL.

2.3.Business Analyst Role:

Designed and proposed software systems and IT service transfer process for imaging division’s selling company’s 80 imaging sites in Ontario, by using Visio.

Prepared mission critical, very complex testing scenarios and errors correction in Lab Information system in Java.

Created a big software release and back-out plan and on-site supported the release for cardiology vendor integration.

2.4.Development Team Leader Role:

Led a project for moving from Solaris to Linux, Apache Ant to Maven, upgrading versions of JBoss, Tomcat, MongoDB.

Provided support to developers’ daily code maintenance including 1 support for a midnight operational urgent call.

Recruited and trained 2 contract senior software developers and 1 permanent software tester.

3.Job Title: Senior Information Architect (contract full time)

Duration: Jun. 2011 ~ Dec. 2011 (7 months)

Employer: Solution Architect Team, eHealth Ontario, Toronto, Canada

3.1.Solution Architect Role and Information Architect Role with hands-on coding:

Architecture design and data modeling for web service project Pan-Canadian Provincial Provider Registry 2012 ~ 2015:

oDesigned business case, business architecture, system functional requirements, solution architecture by Visio.

oDesigned Logical data model, physical data model, HL7 message data model by using PowerDesigner and Visio.

oPerformed budget estimates, resource estimates, project planning, and prepared RFP presentation.

oDesigned legacy provider registry’s SOA platform migration from WebSphere Application Server on MainFrame to IBM Initiate Master Data Service’s EMPI on Tomcat and Linux server, DB2 to Oracle and SQL Server.

oDesigned architecture for web service and its publish-subscription service by using IBM WebSphere DataPower, ESB, XSLT, WSDL, SAML, SOAP, JMS on MQ in application infrastructure system Integration Facility, by using Visio.

Joined architecture design and data modeling for web service project Pan-Canadian Provincial Client Registry (started):

oEnhanced Logical data model, physical data model, HL7 message data model by using PowerDesigner and Visio, found 50 minor discrepancy issues and 20 minor problems.

oDesigned legacy client registry’s SOA platform migration from WebSphere Application Server on MainFrame to IBM Initiate Master Data Service’s EMPI on Tomcat and Linux server, DB2 to Oracle and SQL Server.

oRe-designed architecture for the web service and its publish-subscription service by using IBM WebSphere DataPower, ESB, XSLT, WSDL, SAML, SOAP, JMS on MQ in infrastructure system Integration Facility, by using Visio.

Enhanced software maintenance process by clarifying and documenting names, functions, lunching applications, environments, and naming conventions of 1270 scheduled and started jobs (most for DB2 data staging and from IBM Tivoli and Omegamon) running on CICS on MainFrame through cleansing MainFrame JCL scripts, working together with IBM and HP maintenance teams, and transferring knowledge to eHealth Ontario’s internal maintenance team.

Enhanced Client/Provider Registry helpdesk process by adding 10 roles, 80 entities, 20 ticket templates to BMC Remedy

Joined On-Going Provider Data Feed project team by hands-on coding: performance tuning, reengineering, metadata driven feature recovery, and feature extension on 10K lines of T-SQL code for ETL from 27 medical colleges and organizations data feeding database to data staging database on SQL Server, SSIS through IPsec on Windows Server.

Created 3 new Architecture and Standard Decisions by defining change requirements and designing alternative solutions for On-Going Provider Data Feed projects’ next big release.

Enhanced maintenance by examining status and fixing discrepancies of all Client Registry business rules in DB2 SQL code in views, Change Data Capture, DataStage ETL of InfoSphere by working together with IBM data staging team.

Security: digital signature, message digest, single sign-on, firewall, DMZ, DHCP, IPsec, authentication, authorization, STS, user registry, security token, secured email (so called One Email), system and database audit log, log server.

3.2.Common Qualification Experience:

TOGAF, Zachman, OASIS SOA RM, ITIL in architecture design, business process documentation, and management.

Healthcare IT standards: Pan-Canadian HL7, EHRS, PHC EMR, OPS, and related laws, such as CHA, PHIPA, FIPPA.

4.Job Title: Architect/Team Leader (permanent full time, Multi-Hats as the chief of company’s in-house IT solutions)

Duration: May 2005 ~ May 2011 (6 years)

Employer: IT Division, CML (Canadian Medical Laboratories) Healthcare Inc., Mississauga, Ontario, Canada

(CML was a large private healthcare service company with 3000 employees in Canada 5 provinces & USA 2 states)

Played Roles (Multi-hats): Architect, Team Leader with Hands-on Coding, Project Manager with usually 50% overtime work

4.1.Application Architect Role

Designed, implemented and maintained 4 products Lab Information System, Radiology Information System, Cardiology Information System, Billing System to providing 7X24 medical operational business process control and services on 200 specimen collection centers, 100 imaging sites, 1 central lab, headquarters offices, on Java, C++, Oracle.

Successful story in vendor negotiation: contributed improvement idea about patient notification function to imaging integration vendor InteleRad and got praised from its vice-president, so simplified process and saved cost for the both.

Successful story: won final competition between in-house Radiology Information System and out-sourcing COTS McKesson’s Canada version via doctors’ real use and vote, our in-house one became company’s permanent solution.

4.2.Information Architect Role with hands-on coding

Designed conceptual/logical/physical models on UML & ERD, implemented database 500 tables (largest table 0.5 billion records), 500 stored objects, 600 GB data including a data warehouse in Oracle 10g/11g, PL/SQL, based on DMBOK.

Performed database and data warehouse migration from MySQL 4 + InnoDB to Oracle 10g by using Perl, SQL.

Fulfilled all performance tuning tasks on Oracle database, data warehouse, and PL/SQL code.

Built data warehouse, ETL, BI applications for providing historic medical report services, data and images for doctors’ clinical trial services and medical research, doctors’ and government’s statistics, and operational management’s investigation and monitoring, by using Oracle database, Oracle OLAP, SAS 9 (Base SAS, SAS/STAT, SAS/GRAPH, SAS/QC).

Built XML based web document content management for generating business & medical documents, and synchronizing their version maintenance with on-line help in Java, XQuery, JDOM, C++, PL/SQL on Oracle XML DB.

Built a very urgent medical document database with its website by using MongoDB, its Java API, JSP, Servlet, JavaScript.

System and Application Integrations: totally 30 projects, where 23 used HL7:

o5 for CML internal on MediTech/Caché database, DB2 on IBM AS400, Microsoft Navision ERP (SSIS on SQL Server)

o14 for external companies’ systems with radiology information systems (InteleRad, Agfa, McKesson, etc.), PACS, DICOM viewer, e-dictionary, cardiology scanning/reading systems, lab testing devices, lab testing automation systems, AIM’s Cytobase, clinic EMR systems based on HL7, ASTM, DICOM, IHE, EHRS, PHC EMR, CDISC in Java.

o1 for medical reports web services by NexJ’s cloud based Customer Relationship Management in Java.

o3 kinds of specimen barcode label symbology for 20 kinds of lab testing instruments in C++.

o7 for government and organizations: Cancer Care Ontario, eHealth Ontario’s OLIS, Ministry of Health’s CPDB provider database, CDA Diabetes, OHIP health card validation, and OAML regulations and auditing in Java.

4.3.Solution and Infrastructure Architect Roles

Built TOGAF, OASIS SOA RM models in architecture design, continued IBM RUP process for C++ platform in 2 years.

System architecture: 4-tier architecture: a) database, data warehouse on EMC storage, tape backup, b) Oracle database servers and Data Guard, c) application servers on JBoss and Tomcat, Sun Clusters server, d) 3 Websites, client PCs.

Servers: 30 application servers on Unix TCP sockets, JBoss, and Apache Tomcat, 30 scheduled jobs, 180 remote report print servers on Winsock, 1 fax server, 2 FTP sites, LDAP, VMWave server for development/testing, Citrix XenApp.

Clients: 500 Windows terminals for 2000 users in head office, 200 locations in Ontario, migration for Windows upgrade.

Websites: 3 Websites in JBoss and Tomcat, and 1 Website for development repository in Apache Subversion.

Web service: integration with eHealth Ontario via HL7, HTTPS, SOAP, PKI digital signature, WSDL, Java Spring-WS, LDAP.

Network: a) AKN private network with Real VNC and TeamViewer remote access, and then evolved to b) extranet through Citrix reverse proxy server, and Cisco VPN with Altiris, and c) security on VPN, host, middleware, application.

Security: digital signature, message digest, firewall, DMZ, VPN, LDAP, DHCP for dynamic IP address, user registry, authentication, authorization, database password automatic change, system & database audit log, patient confidential.

Data Centre: joined infrastructure team to provide in-house solution’s requirements, architecture design, & purchase, and to introduce some other infrastructure solutions: Sun Cluster, EMC storage, SAN, VMWave, Citrix XenApp, Citrix Reverse Proxy, Altiris, MS SharePoint, MS Exchange, Lync and Skype for Business.

4.4.Software Development Teams Leader Role with Hands-on Coding

Lead 3 in-house teams up to 20 Sr. developers + 1 tester by team member recruiting and management, work assignment, performance management, code version and deployment control, contractor invoice management.

Software process: waterfall, incremental, unified process, spiral, concurrent, agile scrum, test driving, SWEBOK, BABOK

Co-created ITIL management and co-conducted Zachman analysis together with VP of IT for in-house systems/teams.

Practised CMM to improve software process levels from initial to repeatable, to defined, and to managed in 6 years.

Successful story: hands-on recovered deeply troubled Lab Information System (May 2005 to Dec. 2006) by a) recovered 100+ destroyed features and 2 lost tables, b) cleansed 3 confused C++ code versions, c) fixed hundreds of bugs, d) fulfilled or cut 20 unfinished features, e) performed 5 reengineering projects, f) built version control on C++ code by GNU CVS, g) recovered database mirror, h) cleansed documentation and models, by using Java, C++, MySQL, ERwin.

Hands-on coding for mission critical components: from 2006 to 2009

1)TCP multiplexing event broker and multi-threading application server components in Java on JBoss and Tomcat

2)Application server for integrating (medical reports sending) to NexJ cloud web service by HL7 in Java on Tomcat

3)Application server for Agfa PACS system integration in HL7, Java Spring, Hibernate on Tomcat, PL/SQL on Oracle

4)ETL from SQL Server to Oracle for purchase data integration with Cancer Care Ontario in T-SQL and PL/SQL

Maintenance: the chief who reacted to service desk, direct calls from doctors and operational, and made the first maintenance guess, and the final person who had to solve production problems in 24/7 by using remote access tools.

Co-DBA roles for application aspect: on MySQL + InnoDB (1.5 years with 1 co-DBA), on Oracle (1 year with 3 DBAs).

Experienced and shared teams’ software development platforms (mainly open-source based):

1)System Infrastructure: Sun Solaris, Sun Cluster, EMC storage, SAN, Windows, Linux Red Hat, VMWave

2)Server: Apache HTTP server, Apache Tomcat, JBoss, Windows Server, Citrix XenApp, Citrix Reverse Proxy

3)Database: Oracle 10g-11g, Oracle RAC 11g, MySQL 4 + InnoDB, SQL Server & SSIS ETL, DB2, MongoDB

4)Java: J2EE, JDBC, EJB 2, JSP, JSTL, JSF, Servlet, Applet, JTA, JMS, JAXP, JAX-WS, Apache Spring Framework, Java SE 7 & EE 6, Hibernate, Apache Wicket (including Ajax) on Tomcat and JBoss, Java Eclipse SWT/JFace on Windows

5)C++: Sun Forte C++, Gnu C++, Borland C++, Cmake on Solaris, Linux, Windows

6)Script: JavaScript, JQuery, Unix/Linux Shells/Awk/Expect, Perl, Python, SAS, ActiveX, JSON, XML, HTML, CSS, WSDL

7)Networking: TCP/IP (via sockets), SDP, UDP, ICMP, SSH, SSL, SMTP, HTTP, SOAP, LDAP, JNLP, FTP, UUCP, TLS, Altiris

8)Security: authentication, authorization, digital signature PKI, TLS, SSH, HTTPS, FTPS, SMTPS, IPsec

9)IDE: Eclipse 3, IBM RMC, IBM RSA, Borland Builder, Oracle SQL Developer, Apache Subversion, GNU CVS, Hudson

Modeling Tool: Visio, Sparx Enterprise Architect, SmartDraw, BoUML, ERwin, Navicat, JDeveloper, IBM RMC/RSA

4.5.Business Analysis Role

Contributed and analyzed operational requirements and designed IT solutions to 55 projects for internal and government projects, prepared 48 requirement analysis specifications in UML, ERD, BPMN, in Visio, Smart Draw, BoUML, Enterprise Architect, ERwin, based on DMBOK, BABOK.

Performed User Experience (UX) Design on very high efficient and friendly Web/Desktop GUI for medical order/study entry, doctor’s dictation-recording, technologist’s transcription, and specimen barcode label symbology by conducting user group meetings, standardizing user experience, practising ergonomics, and high reusability software design.

Designed testing scenario and conducted testing process for software change and release with coordinators, users.

Joined company’s out-sourcing by a) contributing our Radiology Information System’s top 10 features to vendor McKesson’s Canada version, b) analysis, design and planning together with Microsoft’s analyst for migrating and out-sourcing legacy financing system and billing system to Microsoft Dynamics ERP on SQL Server and SSIS on Windows Server, c) analysis and design together with Deloitte’s analyst for migrating legacy billing system from IBM AS400.

Built BI applications on data warehouse for providing historic medical report services, data and images extraction for doctors’ clinical trial and medical research, doctors’ and government’s statistics, and operational management’s investigation and monitoring, by using Oracle database, Oracle OLAP, SAS 9 (Base SAS, SAS/STAT, SAS/GRAPH, SAS/QC).

Analyzed and introduced COTS products and medical devices to lab and imaging business, joined automation projects: biochemistry testing automation (a SCADA system), cytology automation, microbiology automation, with vendors.

Prepared annual/seasonal roadmaps, budget and resource planning and management for IT in-house systems/teams.

Frequently changed roadmaps to fully support operational market changes and annually double digits revenue growth.

Joined lab and imaging operational management meetings periodically, proposed IT solutions to operational business.

Practised standards: IEEE 830 Software Requirements Specification (SRS), IEEE 730 Software Quality Assurance (SQA), IEEE 829 Standard for Software and System Test Documentation (STD), IEEE 1012 Software Verification and Validation (V&V), IEEE 1063 Software User Documentation (SUD), and other methodologies (MoSCoW, PESTEL, JAD for agile).

4.6.Project Management Role (during 2005 ~ 2007 full management, 2007 ~ 2011 co-management)

Full management and technical co-management on 61 projects, with 12 companies & 7 government organizations.

Management of software deployment, user training, vendor integration for 200 remote locations, a big lab, offices.

The project largest revenue: $10 million from Cancer Care Ontario; the longest project: 3 yrs for eHealth Ontario OLIS.

Projects’ planning, management of scope-time-cost-quality-resource-risk, team recruiting, performance reporting, stakeholder communication, vendor negotiation, testing/release/back-out planning and control, based on PMBOK.

Worked very close with operational general managers, directors, managers, doctors, technologists, assistants, vendors’ negotiators, engineers and salesmen, other project managers, and kept communication with 100+ people.

5.Job Title: Sr. Software Developer (permanent full time)

Duration: Oct. 2000 ~ May 2005 (5 years)

Employer: Canadian Medical Laboratories Ltd., Mississauga, Canada

Successful Story: designed and implemented a better HL7 coder than a top COTS product to reduce daily server application running from 24 hours to 6 hours, and to achieve better object-oriented architecture, and saved a lot of license fees and maintenance cost for the company. The result was published on a paper for HL7 international conference in 2005.

Lab Information System’s data modeling on MySQL + InnoDB by using Eclipse Modeling Framework, ERwin.

TCP multiplexing event brokers with multi-threading for high performance servers in C++, Java on Unix, Windows.

Lab Information System backend, Billing System, HL7 coding in C++ and Java, EJB, Servlet on JBoss, Solaris, Linux, Windows.

Publish-subscribe and queue messaging services by Java JMS on JBoss MQ and on MySQL (later on Oracle).

Designed and implemented ETL (difficult data cleansing and damaged data repair) for 14 years of historic medical reports data and data from a stat lab, and stored into a simple data warehouse by C++, Perl, Unix Shells on MySQL, Sun Solaris.

Very complex formatted medical report view on public Website and printing by using Java, JSP, JavaScript and HTML.

Lab Information System’s integration with a medical testing device control system MediTech by using C++, Unix Shell.

IBM Rational Rose & Eclipse for IDE, IBM Rational Method Composer for UP software process, GNU CVS for version control.

6.Job Title: System Programmer (permanent full time)

Duration: Mar. 2000 ~ Jun. 2000 (3 months)

Employer: Soliton Associates Ltd., Toronto, Ontario, Canada

Designed/implemented 2GB text 1-parsing Multi-Pattern Search/Replace in C on Linux; Prepared C compiler enhancement.

7.Job Title: Software Consultant (contract full time)

Duration: Mar. 1999 ~ Feb. 2000 (1 year)

Employer: Chicago Stock Exchange, Chicago, Illinois, USA

Designed and implemented Reconciliation System of Midwest Securities Trust Company for Chicago Stock Exchange, and with New York Stock Exchange, by Oracle 8 PL/SQL, Forms, Reports, Designer, ERwin, MS Access and Visual C++.

Designed and implemented Expert Experience Logistics Website by SQL Server, ASP, JavaScript, HTML on Windows NT.

EDUCATION

Ph.D. degree of Engineering in Computer Science, Nagoya University, Japan, 1996. Dissertation: Knowledge-Based Parsing Method of Mathematical Notation for Improving Mathematical Computation Environment (in English), published in Sep. 1996.

TRAINING

CAI Canada in 2011: 1) a software implementation of ITIL v3, 2) Curam ERP on IBM RSA, Eclipse, SQL, H2, Java, JavaScript.

Oracle Public Sector Canada: Oracle ADF, WebLogic, Fusion Middleware, Oracle Database 12c.

Contact this candidate