Summary
Overview
Work History
Education
Skills
Certification
Technology
Corporate Affiliations
Timeline
Hi, I’m

Jeff Li

Manisfield,TX

Summary

Mr. Li has almost 30 years’ IT experience, he has board of experiences in Enterprise architecture, Hybrid-Cloud Integration, Cloud Architecture, Database Management, Enterprise Data Lake/Integration-hub, Cyber security, Middleware Technology, System Architecture, Enterprise Application Integrations, and software development.

Enterprise architect with proven ability to design and implement complex IT solutions. Strong focus on team collaboration, adaptable to changing needs, and reliable in achieving results. Skilled in cloud architecture, cybersecurity, and system integration. Known for logical problem-solving, strategic thinking, and effective communication.

Overview

30
years of professional experience
1
Certification

Work History

Michaels Stores Inc.

Sr. Enterprise Architect/Sr. Technical Architect/Principal Engineer
01.2010 - Current

Job overview

  • Guided DBA team to consolidate MongoDB instances and Google Spanner database instances to reduce cost
  • Migrated multiple open-source database PostgreSQL and MySQL to GCP cloud SQL
  • Migrated multiple Oracle Database-based applications from on-perm to Oracle Cloud
  • And setup hybrid-cloud integration
  • Conducted POC to migrate multiple Oracle databases to Oracle OCI, and Help team to setup OCI environment for Oracle fusion Application in Oracle cloud Implementation
  • Conduct POC to migrate open-source MongoDB cluster to Mongo Atlas, open-source Redis to Redis Enterprise and Google memory store
  • Setup Mongo ops manager and migrated MongoDB from open-source to Mongo Enterprise Edition, open-source Redis cluster to google memory store for production
  • Helped DevOps/Security team to define access roles and key rotation for each application in GCP, help application team to fix application security issues
  • Setup Open-source MongoDB Replica set and Sharding cluster, and Redis cluster, support for company e-commence implementation in GCP
  • Setup MYSQL Innodb-cluster and NDB cluster in GCP
  • Migrate multiple business application databases from IBM Power8 platforms to Dell-platform with Linux to increase performance and reduce oracle database License
  • Designed Hybrids-cloud integration architecture, setup Google Pub/sub, Kafka Cluster and Flink Cluster in GCP, and integrate application in GCP with on-promise applications
  • Install and Setup Tableau server, Azure PowerBI and PowerBI Data Broker
  • Help Application teams to integrate their application with IDM and single-sign-on
  • As the lead of architect, worked with project team to upgrade DC warehouse management system from 2007 version to 2020 and 2023 version
  • As lead of Architect, guided engineering team to build enterprise Monitor and Search system using open-source technology (using Elasticsearch/Kibana/Logstash/filebeats/Grafana/Prometheus)
  • As lead of architect, guided engineering team to build DATA-HUB using open-source technology (using: Apache-hadoop cluster, Apache Hive, Apache SPARK cluster, Impala, Kafka, RABBITMQ, Zeppelin, Superset, Airflow, etc)
  • AS lead data architecture, guided big development team to develop ecommerce application based open-source technology (such as: MYSQL innodb cluster, MYSQL NDB Cluster, Couchbase, MongoDB replicaSet and sharding-cluster, Redis Cluster) and design the strategy to migrate Some Home-grown Oracle Databases and MS SQL server to Open-source database MySQL
  • As the lead architect, guided engineering team and application team to implement Cloudera system/Birst reporting system, successfully migrated Enterprise DataLake from cloud to Michael’s datacenter
  • Worked with infrastructure team and application, successfully migrated multiple cloud-based-applications to Michael’s data center
  • Collaborated with other architects to define company’s infrastructure strategy, hybrid-cloud integration, define future roadmap
  • As the lead architect- Upgraded company’s core merchandise system (such as: Oracle Retail Suite, JDA demand/fulfillment, Warehouse management, etc) to updated technology stack
  • As the lead architect – Guided DBA team implemented Oracle Data Guard for all oracle databases; Worked with infra-structure team to replace storage device and all OS upgrades; Worked with project team to implement and upgrade multiple enterprise applications
  • Data Center Move – as core member of project team, responsible for all the applications on IBM platform, hardware purchase and defining server deployment architecture, move product servers to new data-center and rebuild DR site in Irving Data center
  • Developed company’s technology roadmap, Database/Server/Application/Integration builds standards
  • As lead architect – Provided cost estimate, helped project manager to develop project plan, and designed RETEK (Core merchandising system)/Retail Data Warehouse/ Supply Chain application’s technology upgrade strategy, re-architected application systems, and guided the project team to successfully upgrade IBM hardware/Oracle database/Middle ware /applications/storage LUN consolidation, and move production system from current data center to COLO, and rebuild DR for the application, reduced over 30 process license for Oracle Application Server, and 10 processor license for oracle database
  • As lead architect – Provided cost estimate, helped project manager to develop project plan, and designed Distribution Warehouse Manager System upgrade including Server hardware replacement/OS/Database/Application/TSM server upgrade/SAN framework upgrade, successfully upgrade 6 DC warehouse management in 4 months
  • As the lead architect – Provided cost estimate, helped project manager to develop project plan, designed Oracle Retail R12 –Merchandising system application’s OS/DB/and Application Upgrade Strategy, and guided the project team to successful upgraded OS/Database and Application
  • Guided application performance tuning team to tune multiple business critical systems, reduce 1/3 of batch time windows
  • As the lead of architect, designed massive database upgrade strategy, and upgraded and consolidated many application’s databases
  • As the lead architect, designed new system architecture for Vertex, Sales Audit Replacement into Oracle Retail ReSA, and JDA Allocation; and implemented security and single-sign-on integration
  • Defined Company’s five-year roadmap strategy on > and > and >
  • Upgraded Enterprise Data Warehouse system (NETEZZA Database) and Micro strategy reporting system software and hardware
  • Helped IBM Portal and IBM IDM implementation, designed and conducted performance stress testing, and resolved the performance issue and integration issues
  • Help SAN Storage team to migration SAN storage from EMC DMX3 to IBM XIV storage devices
  • Designed JDA Demand-Fulfillments system architecture and integration strategy and help the project team to resolve application issues and performance issues, reducing 1/3 of batch run time
  • Re-architecture the database and middle tier server’s layout during the hardware refresh; migrated over 100 servers in AIX and Linux to new hardware, and upgrade OS to supported level
  • Reduce around 40 CPU Oracle Database License and 20 CPU Oracle application server licenses
  • Guide Application team to upgrade Oracle E-Business Suites HR and Financial system database from Oracle 9iR2 to 11gR2 and major patch upgrade

Diodes Inc.

Global Database Manager
01.2007 - 01.2010

Job overview

  • Moved the company’s datacenter from California to Dallas and implemented Oracle Data Guard for DR center for business-critical databases
  • Managed global DBA groups to support company’s ERP/ASCP 7X24 global system, on-going new project implementation
  • Upgrade Diodes ERP/ASCP global instances database from Oracle9iR2 to Oracle11g database
  • Re-Architecture Oracle ERP and ASCP system and migrate the two global systems from IBM P570 to new IBM Hardware P6 server
  • Provide Technical Support for Oracle ASCP implementation and Oracle Demantra Implementation

Michaels Store, Inc.

Database Architect
01.2004 - 01.2007

Job overview

  • Worked with UNIX administrator and TSM administrator to implement new database backup solution, it dramatically reduces Oracle database backup time for company’s major databases (it cuts two third of rman run time for all major databases)
  • Re-designed Oracle HRMS applications deployment architecture, configured HA, and enable F5 loading balance
  • Upgrade Oracle EBS-HR from 11.5.7 to 11.5.10.2 and implemented >; Upgrade oracle discoverer4i to Oracle Discoverer 10gR2; Helped identity management team to integrate Oracle Applications with LDAP
  • Designed Retek 12 Application architecture and helped other DBAs to install and set up Retek Applications 12 for Retail Merchandising System, Retail Security Manager, Retail Price Management, and Retail Allocation
  • Defined Oracle EBS Financial deployment architecture; installed and configured Oracle E-Business Suite 11.5.10.2 with HA for Oracle Financial implementation, configured printer, and concurrent managers, defined user responsibilities and users
  • Develop instance clone procedure and help development team for data conversion and support implementation team
  • Migrate Enterprise Data Warehouse from Oracle to Netezza platform, and setup IBM DataStage and MicroStrategy reporting
  • Guided DBA to upgrade all Oracle Databases from 8.1.7 to 10gR2 on new IBM hardware
  • Tuned Oracle Applications HRMS database and middle tier servers
  • All the long run batch jobs have been tuned, no one runs over 2 hours now
  • Worked with Vendor to setup EMC storage, and migrated all Oracle Databases storage from IBM SHARK storage system to EMC SAN storage system and migrated the database servers on new IBM P570 hardware

Oracle Corporation

Senior Principal Consultant
01.1998 - 01.2004

Job overview

  • Conducted Oracle Database, Middleware Server training for multiple clients
  • Conducted Oracle forms/reports/Jdeveloper/Discoverer training for multiple clients
  • Conduct Oracle Application DBA training for multiple clients
  • Designed architecture/Install, setup and implemented Oracle E-Business for multiple clients (from 10.7-11i)
  • Upgrade Oracle EBS for multiple clients (from 10.7 to 11i)
  • Conducted database and application performance for multiple clients
  • Implemented Enterprise Data Warehouse for multiple clients
  • Help Sale team to setup Demo Environments for Oracle EBS and other packaged applications
  • Help multiple clients to design their e-commerce web applications
  • Help multiple clients to move applications from their data center to Oracle hosted environments
  • Help multiple clients to migrate their database from windows/Unix to Linux

JCS Consulting Services, Inc.

Senior Oracle Consultant
01.1997 - 01.1998

Job overview

  • Served as database, Web Server, and applications administrator for a major telecommunications company
  • Responsible for the setup and maintenance of Web Server and Web Development
  • Served as team lead to develop distributed computer application using Visual C++, Visual Basic, IONA Orbix, Java, and HTML
  • Convert existing client/server applications to internet/intranet applications and developed new internet/intranet applications
  • Maintained and supported Oracle database and data repository, built database backup procedures, developed packages, and stored procedures for developers, tuned the database and applications, and performed data cleanup for data conversion

Paragon Group, Inc.

Oracle Developer/DBA
01.1996 - 01.1997

Job overview

  • Customized and maintained Oracle Financial Applications (Application Object Library, General Ledger, Accounts Payable, Fixed Assets, and Accounts Receivable, Versions 10.4/10SC)
  • Worked with end users to develop customized financial reports, forms and add-on applications
  • Tuned production database and applications for better performance, such as building temporary table and indexes to speed up applications system and reorganize database
  • Responsible for the maintenance of development database, built stored procedures and packages, created views for application developers and end-users
  • Designed and developed an in-house forecasting, data entry, and reporting system
  • Developed monthly and year-end reporting processes for the Paragon Group

Sabre Decision Technologies

Oracle Consultant
01.1995 - 01.1996

Job overview

  • Served as a Programmer/Analyst on pricing system for an airline: Project responsibilities included loading conversion data, building on-line systems, and developing graphical user interface
  • Served as a Programmer/Analyst on a Revenue Management System Project for a major cruise line: Designed and developed graphical user interface, batch system, on-line system, reporting system, graphics, stored procedures and packages

Education

University of Houston

M. S from Computer Science
01.1996

University Overview

University of Houston

PhD Candidate from Mathematics
01.1993

University Overview

Chinese Academy of Science

M. S. from Applied Mathematics
01.1988

University Overview

ZhengZhou University

B. S. from Mathematics
01.1984

University Overview

Skills

  • Google Cloud
  • Oracle OCI
  • Server Virtualization Technology
  • System Architecture and Integration
  • Enterprise Architecture
  • Enterprise Applications
  • Data Warehouse
  • Business Intelligence
  • Database Management System
  • Public Cloud
  • Hybrid Cloud Architecture
  • Docker
  • Kubernetes
  • Cloud Integration
  • CICD Pipeline
  • Jenkins
  • Vault
  • Apache Hadoop
  • Apache Hive
  • Apache Impala
  • Spark Cluster
  • Cloudera
  • Apache Flink Cluster
  • Zeppelin
  • Cloudera Cluster
  • Prometheus
  • Grafana
  • Kafka Stream
  • Elasticsearch
  • Kibana
  • Logstash
  • Filebeats
  • MYSQL
  • InnoDB
  • NDB Cluster
  • Postgresql
  • Cluster with HA
  • MongoDB Cluster
  • Couchbase Cluster
  • Neo4j
  • Apache Superset
  • Airflow Cluster
  • Redis Cluster
  • Google MemoryStore
  • PLSQL Developer
  • Shell Scripting
  • Perl
  • Python
  • C
  • C
  • Java
  • Oracle Database Management
  • Performance Tuning
  • Oracle RAC
  • Data Guard
  • GoldenGate
  • Oracle OBIEE
  • EPM
  • Micro Strategy
  • Oracle Application Server
  • Fusion Middleware Technology
  • Oracle EBS Applications
  • Oracle Retail
  • JDA Demand
  • Fulfillment
  • Allocation
  • Space Planning
  • IDM
  • Single Sign-On Integration
  • HP-UX
  • Sun Solaris
  • IBM AIX
  • Windows
  • Linux
  • Enterprise architecture design

Certification

  • Oracle8 DBA master.
  • OCP – Oracle Certified DBA (7.3, 8, 8I, 9i)

Technology

Technology
PLSQL Developer, shell scripting, perl, python, C, C++, java, Oracle Database Management and Performance tuning from v7-19c (Oracle RAC, Data Guard, and GoldenGate), Oracle OBIEE, EPM, and Micro strategy, Oracle Application Server and Fusion Middleware technology, Oracle EBS Applications, Oracle Retail –Release 12 to14, JDA demand /fulfillment/allocation/space planning, IDM and Single Sign-On Integration, HP-UX, Sun Solaris, IBM AIX, Windows, Linux

Corporate Affiliations

Corporate Affiliations
  • Sr. Enterprise Architect/Sr. Technical Architect/Principal Engineer, Michaels Stores Inc., 01/01/10, present
  • Global Database Manager, Diodes Inc., 01/01/07, 12/31/10
  • Database Architect, Michaels Store, Inc., 01/01/04, 12/31/07
  • Senior Principal Consultant, Oracle Corp., 01/01/98, 12/31/04
  • Senior Oracle Consultant, JCS Consulting Services, Inc., 01/01/97, 12/31/98
  • Oracle Developer, Paragon Group, 01/01/96, 12/31/97
  • Oracle Consultant, Sabre Decision Technologies, 01/01/95, 12/31/96

Timeline

Sr. Enterprise Architect/Sr. Technical Architect/Principal Engineer
Michaels Stores Inc.
01.2010 - Current
Global Database Manager
Diodes Inc.
01.2007 - 01.2010
Database Architect
Michaels Store, Inc.
01.2004 - 01.2007
Senior Principal Consultant
Oracle Corporation
01.1998 - 01.2004
Senior Oracle Consultant
JCS Consulting Services, Inc.
01.1997 - 01.1998
Oracle Developer/DBA
Paragon Group, Inc.
01.1996 - 01.1997
Oracle Consultant
Sabre Decision Technologies
01.1995 - 01.1996
University of Houston
PhD Candidate from Mathematics
Chinese Academy of Science
M. S. from Applied Mathematics
ZhengZhou University
B. S. from Mathematics
University of Houston
M. S from Computer Science

Similar Profiles

CREATE PROFILE
Jeff Li