“Jason” Zhizhong Zhang

Living Area: Atlanta Area in Georgia.

adinag@r.postjobfree.com, adinag@r.postjobfree.com

Cell/Text: 901-***-****

SUMMARY:

Total 17 years of continues experience in IT fields, Oracle Database Environment in particular.

6 years of experience in Oracle Apex Developer and PL/SQL Developer

6 years of experience in Oracle PL/SQL Developer.

7 year of experience in Oracle PL/SQL Developer (60%) and DBA (40%)

Major Technical skills:

RDBMS: Oracle, MS SQL Server, MS-Access

Languages: Oracle SQL, PL/SQL, T-SQL, HTML, JavaScript, CSS

Developer Tools: Oracle Apex Application Builder, PL/SQL Developer, Oracle Report, Oracle Discoverer, TOAD, Crystal Report, SQL*Loader, ODI, JIRA, PVCS on unix, Smart SVN, SQL Navigator.

Background Industry:

Finance, Credit Cards, Social Service (None-Profit), Purchasing, Sales and Marketing, Food Manufacture

EXPERIENCE

White Clarke Group (Alpheratta,Georgia) 11-2019 - Present

Company Industry:(Software Services), Commercial Lending

website: https://www.whiteclarkegroup.com/about/our-company

create and maintain database packages, tables, sequences and triggers.

Create and maintain reports using crystal report platform. Utilizing sub-report, section suppress, pdf and excel output format, etc.

Create and maintain pipeline table functions for reporting purpose.

Project: supplier credit proposal: using package for inserting, reporting and crystal report pdf/printing technology.

Build application on apex platform

Gradkell Systems Inc. (Huntsville, Alabama) 11-2018 – 11-2019

Work at client's site in Memphis Area in Tennessee

Company Industry: (Software Services), website: https://www.gradkell.com/

Oracle Apex Developer and PL/SQL Developer

Major Achievements:

Apex Developer: Create Applications. Financial related. Create related tables, triggers and stored procedures to support Applications. Migration from Oracle Forms to Apex.

Mentor student/internship for Apex and Database. Train others on products and processes.

Using oracle pipeline function for dynamic list of value from different tables.

Create App Data Manager for maintain standard code list and General Ledger correlation.

Debug and maintain Apps Invoice, Receiving Report.

Using Apex API host_url to navigation between applications from different workspace/host.

Riceland Food Inc. (Stuttgart, Arkansas) 06-2014 – 11-2018

Company Industry: (Food Manufacture), Website: https://www.riceland.com/

Oracle PL/SQL Developer and Oracle Apex Developer

Major Achievements:

Build Web Application using Oracle Apex, also create database objects such as tables, triggers, packages for the application. This also involves JavaScript, css, html etc. Migration from old applications to new applications.

Projects completed:

CBOT Application, Work-Order Information, Capital Budget Management and Cost sheet Application built on Oracle Apex platform.

Dunning Letter App and EDI Advance Ship Notice: Built on Oracle Scheduled Job.

Above apps: From requests gathering and design all the way to the production support all by myself. Train others/new employee on products and processes.

FleetCor Tech, (Norcross, Georgia) 06-2008 – 05-2014

Oracle PL/SQ Developer

Company industry: Fuel Credit Card Processing System(Financial), Website: https://www.fleetcor.com/

Major Achievements:

Build query to report a card purchasing transaction over 10 in 24 hours using group by.

Build query to report audit of table using lead function.

Build control file to load data to oracle database using Oracle SQL Loader Utility.

Build query to display one row from multiple rows using SYS_CONNECT_BY_PATH.

Ad hoc update script using bulk collection.

Delete duplicate records using rowid.

Write query to report last 4 billing records using rank over.

Monthly Analysis Report: use pivot feature in SQL, use utl_file, write shell script to schedule.

Write Merge script, using utl_file to load from text file.

Create Weekly report, using PL/SQL Developer multiple sheet feature, using macro feature in MS Excel.

Project: Conversion Data from FleetNet system to iFleet system.

Project: Create new line of business in iFleet and ATS system.

Production database developer support.

Remove unwanted characters using regular expression.

Build Tax Exempt Query for customers.

Build Welcome Page using HTML

Pathways Community Network Inc., (Atlanta, Georgia) 12-2001 – 06-2008

Oracle PL/SQL Developer and DBA

Company industry: Social Service (None-Profit), Website: https://www.pcni.org/

HMIS (Homeless Management Information System) is a data entry, reporting and database systems. It is a web accessed system used by more than 300 organizations.

Major Achievements:

Database Developer ( 2001 - 2008)

Create and maintain fictions, packages. Create ad-hoc update and query to customer’s needs. Backup data using

Import and export. Sql load to load text file into database. Create special report for fraud alert ( same card purchase multiple times out of state within 24 hours). Create sql script to lock fraudulent customers in bulk quantity. Solve tickets timely and accurately.

Create and maintain all 38 triggers in the database, including automatically set up create date by the system, change one table only and triggers will change other tables without user making same change and database detailed auditing.

Create and maintain all 6 procedures, 17 functions and 1 package, including merge the duplicate records features.

Create and maintain124 Oracle Report programs needed by different organizations.

Create and maintain Oracle Discoverer programs. ( 10 Business Areas, 66 folders )

Database Administration ( 2001-2008)

Installation of Oracle Database 8, 8i, 9i and 10g on Windows2000, Windows2003 and Red Hat Linux ES 3 and 4.

Management of Database Users.

Change initial parameters for performance tuning.

Backup and Recovery Database using Export and Import utilities.

Design and create tables, create control files, load data of ZIP codes and Taxonomy codes from vendors into database using SQL Loader. In this way, when user inputs address, only ZIP code is needed and county, city, state will automatically be populated. Also user can pick and choose from more than 7000 names of the services they provide using Taxonomy Codes.

Implementing RAC on the Red Hat Linux environment with 3 nodes.

Others Related Skills and experience ( 2001-2008)

Oracle Report Server Administration including programming and publishing on windows2000 and Linux.

Oracle Discoverer Server Administration including programming and publishing on Linux.

Installation of second CPU, hard disks and memory cards on Dell machine.

Non-IT related Work:

Tianjin, China

TRAINING

Oracle Apex Training: ( Arkansas, US )

1 week in the year 2015, 2016, 2017, 2018, 2019

Oracle DBA Training at some training school/center - 3 months ( Georgia, US )

Oracle ODI Training at Oracle Corporation - 1 week (California, US )

Oracle Discoverer Training at Oracle Corporation - 1 week ( Georgia, US )

Computer hardware and software Training at UNVA - 1.5 years (Virginia, US )

Lotus Domino Training – 1 week ( Georgia, US )

Lotus Sametime Training – 1 week ( Michigan, US)

Certification:

Oracle Certified Database Administrator

CompTIA Security+

Education

Bachelor's Degree

Tianjin Open University

Website: http://www.tjrtvu.edu.cn/open/open.html, http://www.tjrtvu.edu.cn/english.htm

Major: English and Computer on Scientific and Technology.

Associated Bachelor's Degree

Tianjin Foreign Economic and Trade Vocational College

Website: http://www.tjdwjj.com/

Major: International Trade.

Graduated in 3 years.

I am legally authorized to work in the United States and Canada for any employers.

Contact this candidate