Oracle Database Administrator/developer
Resume:
Wenhan Zhang
Draper, UT *****
*.*****.*****@*****.***
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