Wenhan Zhang

Draper, UT *****

ad0rmv@r.postjobfree.com

+1-801-***-****

Over 20 years of experience as Oracle database administrator and developer with a strong background

in designing, developing, and optimizing Oracle database solutions. Proficient in Oracle database

administration in architecting, installing and maintaining of database instances in both data center

environment and AWS. Expert level in writing efficient SQL queries, creating stored procedures,

triggers, and functions to enhance application functionality. Skilled in database performance tuning

and query optimization, ensuring optimal response times. I also implemented and maintained EBS of

earlier versions. fairly familiar with Oracle forms/reports.

I am a seasoned I.T. manager from leading a small team to the officer level. Over the past 15 years, I have been part of two start-ups. I played an important role as the total I.T. solution. I lead a group of professionals and developed complete I.T. systems in house including online transactions, online analytical, mobile APPs, internal customer service APPs, data warehouse, Business Intelligent, and ERP/MRP integrations.

Work Experience

CIO International/DBA

KWIK, LLC - Bountiful, UT

July 2020 to Present

KWIK, LLC is a start-up company that offers e-commerce a loyalty and reward platform. I am a co-founder of the company, the head of I.T. I led teams of developers of both on-shore and off-shore, also participated as the Oracle DBA.

Architect, develop, deploy and maintain the customer APPs and vendor portals.

Develop the core commission engine in PL/SQL to implement the bonus, commission and loyalty points calculations.

Implement integration with third-party e-commerce platforms to enable the KWIK features.

Implemented cloud ready architecture and codes fully hosted in AWS.

As the Oracle DBA, I create, design, maintain and tune the Oracle database hosted in AWS.

Coded the key functionalities in PL/SQL

Chief Information Officer/DBA

ARIIX - Bountiful, UT

June 2011 to June 2020

ARIIX was a direct selling company. I was a co-founder, the Chief Information Officer. I managed all aspects of I.T. and developed a complete package of industry propriety systems.

Architected, developed, deployed and maintained the applications including:

order entry, online transactions, online back office (REACT)

mobile APPs (REACT Native)

customer service APPs (C#)

products and pricing module (C#)

middle layer of logics (Java)

commission engine (Oracle PL/SQL)

data warehouse and business intelligent (OWB, Tableau)

ERP/MRP integrations (NetSuite)

As the Oracle DBA:

created, designed, and maintained the Oracle database hosted in data centers.

designed the data model to be scalable and performing.

programmed the key functionalities in PL/SQL packages.

performance tuning of SQLs by in-depth analyzing the execution paths.

ETL process using Oracle Warehouse Builder

Oracle DBA/Data Architect

ACS/Xerox - Austin, TX

June 2007 to June 2011

Oracle DBA and data architect for government assisted programs.

responsible for day-to-day Oracle database operations.

participation in states governments' projects to implement and upgrade social benefit systems.

data conversion and migration from legacy systems.

architecture evaluation of database setups and configurations

building of data warehouse using OWB and OBIEE

trouble-shoot performance issues by identifying the slow running SQLs

Education

Master's degree in Engineering

The Ohio State University - Columbus, OH

Bachelor's degree in Engineering

Anhui University of Science and Technology - Anhui, China

Contact this candidate