PROFESSIONAL SUMMARY:
Over ** years of IT experience in Database Development, Database Administration, Information Security, Cloud Computing. Solution-oriented with proven success designing, implementing and integrating cost effective, high-performance technical solutions to meet challenging business needs.
SKILLS:
SQL Server, Oracle, PostgreSQL, Database Tuning/Optimization, Redundancy/HR/DR.
Data Modelling, Data Warehouse, Data Lake, ETL, Snowflake, SSIS, Hadoop, Power BI.
Azure, AWS, Apache, EC2, Web Service, Kusto, Python, Jenkins, Ansible, Kafka, Agile.
Cloud Security, Cyber Security & Compliance, Vulnerability Assessment, NIST (CSF).
CAREER EXPERIENCE:
The Boeing Company, Bellevue, WA
Solution Architect / Senior Database Engineer - Information Security 2015 – present
Led the device inventory data warehouse architecture design and development to support Cybersecurity vulnerability assessment, IT compliance, Cloud and Perimeter network security.
Designed and developed a new network endpoint discovery system to replace a COTS product that saved the company millions in hardware cost and annual support cost.
Oversaw system integration with Azure inventory data, security architecture design, data pipeline, ETL and REST API design and implementation.
Designed and developed real-time data stream pipeline by using Apache Camel ActiveMQ.
Worked on NIST 800-171 Cybersecurity, CMMC, PII, DFARS and IT audit.
[Environment: Azure, Data Warehouse, Data Modelling, ETL, SQL Server, Postgres, Oracle, Web Service, Big Data Analytics, REST, VMWare, Kusto, Python, Jenkins, DevOps, Snowflake]
The Boeing Company, Bellevue, WA
Technical Lead - Advanced Persistent Thread March 2010 – July 2015
Led the implementation and system integration of The Endpoint Discovery System on Boeing enterprise network (Domestic, NFIS, and International).
Managed system redundancy/HA/DR planning, test and execution.
Designed and implemented the enterprise discovery data warehouse to profile network traffic data anomalies to address cybersecurity and APT concerns.
Worked with Boeing Cloud platform team to conduct vendor product selection for Boeing Cloud infrastructure and Cloud security.
[Environment: AWS, Hadoop, MapReduce, Hive, HDFS, Linux, SQL Server, SSAS, SSIS, SQL, Data Modelling, Python, Wireshark, Load Balancing, HA, DR, Power BI and Cloud Computing]
The Boeing Company, Bellevue, WA
Lead System Integrator - IT Infrastructure June 2009 – February 2010
Led the implementation and system integration of uCMDB on the Boeing network.
Managed the deployment team and oversaw the enterprise deployment on Boeing network and all data centres.
Led the system integration and data warehouse design and implementation.
[Environment: UNIX/Linux, Oracle, SQL, ETL, LDAP, Python, Perl, PowerShell]
The Boeing Company, Bellevue, WA
SXTS Product Manager - Server Tool Management June 2008 – May 2009
Managed the server configuration management tools and block point release compliance process. Worked with each of the OS owners – Linux, AIX, HP-UX, and Solaris to get SXTS agent compliance with new OS upgrade.
Managed enterprise server inventories and supported database migration/modernization.
[Environment: Linux, UNIX, Perl, Oracle, SQL Server, OLAP and Shell Scripts]
The Boeing Company, Bellevue, WA
Full Stack Developer - Server Tool Management January 2005 – May 2008
Designed, developed Distributed Configuration Information System (DCIS) to support enterprise server compliance project.
Oversaw all the technical aspects of the project and system release to enhanced DCIS system.
Worked as Oracle application DBA for DCIS and SIS databases.
[Environment: Windows, Oracle, Web Server, ETL, SQL, PL/SQL, VBScript, JavaScript, Perl]
Honeywell International, Redmond, WA
Senior Solution Architect May 2004 – December 2004
Led the middle tier system architecture design, workflow/dataflow design, and enterprise system integration and application support for aerospace industry.
Developed real time application in Oracle, IBM Middleware and ERP system.
Designed and implemented the security rules, high available solution and DR solutions.
[Environment: Linux, Data Modelling, Oracle, OLTP, WebSphere MQ, Perl, SQL, PL/SQL]
AT&T Wireless Corp., Redmond, WA
Senior Database Consultant/Database Architect March 2003 – April 2004
Acted as lead on database architecture design, data modelling, capacity planning, database performance tuning and database administration of SQL Server 2000.
Designed and implemented data warehouse for data analysis and network traffic forecast.
Managed project progress to standardize and improve systems and business processes.
[Environment: Windows, AD, SQL Server, Data Warehouse, ETL, SQL, PowerShell]
EDUCATION AND TRAINING:
MASTER OF SCIENCE, University of New Orleans, New Orleans, Louisiana, USA
BACHELOR OF ENGINEERING, Chengdu University of Technology, P. R. China
Camel Integration and Development with Red Hat Fuse 2018
SEC600 Certified Information Systems Security Professional (CISSP) 2017
Big Data Analytics Certificate (Carnegie Mellon University) 2015
CCNA Network Security 2015
Troubleshooting and Maintaining Cisco IP Networks – CCNP 2014
Interconnecting Cisco Networking Devices - CCENT 2013
Certified Information Systems Security Professional (CISSP) 2012
Certified Ethical Hacker (CEH) 2012
Interconnecting Cisco Networking Devices - CCNA 2012
Oracle 11i Financials Functional Foundation 2008
Oracle Database 10g: Administration I 2006; Administration II 2007