Robert — Sr. Solution Architect

2007 The Healthcare CIO Boot Camp (by College of Healthcare Information Management Executives) 2016 Business Architecture Fundamentals by IAG Consulting

PG&E San Francisco, CA, October, 2015 - July 2017 Sr. Solution Architect In charge of technology part of a project. Responsible for developing solution blueprint and many other architectural artifacts (high-level architecture design, infrastructure design, disaster recovery plan, non-function requirement, etc), helped with Job estimate, system security package, service introduction, detail functional design, etc. Practiced the enterprise project development methodology and oversaw the implementation of all I.T. related components throughout the project. Collaborated with business analysts/architects, technology domain architects, cross-functional technical teams to enhance the design and deliver the solution. Projects worth mention: - Designed and implemented enterprise cloud solution for engineering drawing system that will likely consolidate all 9 such systems in company (including one for nuclear plant), and potentially save $5M in in upgrade and at least $1.25M in annual expenses. - Designed and implemented an integration solution to use REST API to integrate 3 rd party SaaS application with company's enterprise system (SAP). This application improved the services to +20K employees as well as external clients. - Designed and implemented infrastructure for enterprise GIS data mart on private cloud to support multi lines of business and various mobile applications in the field. The system includes 4 Oracle RAC to support 7 GIS databases. Cross data center DR was implemented through Oracle Data Guard for DB and standby application and web servers, with more than 80 virtual machines in all environments. - Enhanced the architecture of business process and data management for newly acquired business of geographical gas pipeline aerial survey by airplane: data collection, processing and storage, and supporting mobile device iPad, with size of 100TB for recent years. - Designed a mini data center that meets NERC CIP compliance (in Utility Industry) for operation control centers, and with virtualization cluster - VMWare ESX cluster, security, SRM, and data protection. - Designed and implemented the architectural expansion of appliance cluster for enterprise Documentum system to double the search processing capacity on enterprise records of size of 9.2PB

Huawan Techology, San Francisco, Bay Area, CA, January 2014- October, 2015 Consultant Providing solution services in customized jewelry design, mainly in multi-tier architecture design, database design, and related project management. The system is to support the online custom design, the data feed and control of 3D printing, and the control of auto manufacturing

Dahl-Chase Diagnostic Service, Bangor, Maine, June 2006 - January, 2014 I.T. Director/ Architect Revamped company I.T. practice. Upgraded outdated infrastructure and standardized hardware and software platform, migrated or upgraded almost all I.T. systems resulting dramatically improvement of productivity, service quality, and patient safety. - Set up I.T. strategy to align with company business goals; Provided I.T. strategic and tactical planning including yearly updated project list as basic roadmap; - Established proper governance of enterprise architecture standards including unified to servers and OS and enterprise systems to handful vendors (Dell, Microsoft, Cisco); I.T. asset inventory; technology life cycle upgrade - Enforced I.T. policies and procedures to meet HIPAA and CAP standards; - Managed I.T. project portfolio: reviewed and approved all I.T. project requests, prioritized their implementations (50+ projects in the first 3.5 years); - Redesigned or introduced various key architectures: storage architecture, integration architecture, data backup and disaster recovery architecture, enterprise applications (email system, AD, etc.), web architecture, networking/telecomm services, etc. - Conducted POC for various systems and services (like Pathology BI, Medical Imaging System, and Voice recognition). - Introduced online training program, built and transferred I.T. employee competence in alignment with future architectures. - Budgeted annual I.T. capital and operating expenses; Oversaw I.T. operations for whole company. Categorized Projects - Data and information management (database, application dev, data cleansing, etc., internal BI, online reports for partners) - Data center (Platform upgrade, storage, server, backup and recovery) - Network/telecomm, remote access, wifi. Telecommunication, wireless services. - Security (AD, antivirus software, system monitoring, DC security). - Customer care (compliance, incident tracking system, SLA, etc,). - Enterprise Integration (billing, LIS system, accounting, web (customer and partner), medical device, external Partner's EMR or HIS, LIS, 3rd party SaaS, etc.) - Enterprise Application (multi-tier architecture, billing, LIS system, web for customers, web for partners, email system migration)

OneSource Information Service, Inc., a division of InfoUSA, Concord, MA, Oct, 2004 - June 2006 Principal Software Engineer Involving in the strategic planning for online financial business service and software architecture design. Concentrating in the areas of ETL, reporting, performance tuning. Databases are SQL Server 2005 and Oracle 9i/10g. Computer Sciences Corporation (CSC), San Francisco, California, May2002 - June 2004 Principal Consultant Designed a new data warehouse architecture and application architecture: - multi-tier architecture with Oracle 9i in backend and J2EE for application and administration portal. - business process specification and process flow design. - data warehouse conceptual/logical/physical design (for Oracle 9i RAC). - business intelligence system dimensional database design. - ETL process specification and process flow Also involved in several enhancement projects while in charge of the operation for a marketing data warehouse system. - reformed several business processes and resulted in the reduce of 75% in operation cost. - re-engineered data transfer protocol between datacenter and clients. - introduced a new mechanism for promotion QA process that eliminated errors in real time data launch. - redesigned the whole cross-sell process and simplified the procedure for weekly special. Other activities: Filed two patents; Administrated systems (databases, web, network, and system); Fixed bugs; Managed small team of engineers; Communicated periodically with clients, marketing and sales personnel to resolve escalated technical and business issues

InformLink, Inc., San Jose, California, February 2000 - April 2002 Director of Engineering/ Database Architect As a database architect, I helped founding InformLink, Inc. in the end of 1999. Led the development effort and launch company's in-house production system - a promotion CRM, in about six months with extremely limited resources. Major achievements: - Timely delivered the whole data warehouse design and the implementation in Oracle 8i, which covered business process analysis, architecture - Led seven patents filings, one of which was tree-structured category mapping and was a key to enable the whole (system specification, data modeling, three-tier web application architectural design), coding, testing, documentation, and deployment to several clients. Key subsystems included a promotion data mining engine and category management module. design business model to work. - Designed and implemented a dynamic analytics engine specifically suitable for promotion performance analysis. - Designed and implemented a distributed data warehouse architecture that cost at only 20% of normal centralized implementation at terabyte level. In management side (since March 2001 as duty of Dir of Eng), responsible for the operations of in-house production systems, responsible for product development, streamlining operation processes, setting up standard, policies and procedures for product development, working with marketing and sales team to shape and define product development and delivery strategy, managing projects, and managing several small teams (4 DBA, 2 web dev, and 2 QA)

Oracle Corporation, Redwood Shores, California, July 1997 - May 2000 Technical Specialist Worked as administrator for Oracle parallel database (OPS and 9i RAC) running on massive parallel processing computers (MPP platforms). Duties included the installation, configuration, backup and recovery planning, application analysis, troubleshooting, performance turning, and most importantly, handling critical or escalated business situation (usually caused by technical issues like database crash, data corruption, software bugs, etc.). Frequently, conducted database design review (for performance and storage issues) for application from various industries (credit card company, bank, database marketing company, retailer, etc.) Besides the technical duties, I also acted as escalation team leader and/or situation manager on critical customer situation, communicating to customer's senior management on escalated issues; coordinated resolution of escalated or high priority bugs with development and/or porting organizations; developed and delivered technical training to other analysts; and were a mentor to senior analysts and promoted the technical and professional development of others