Objective: SAP BASIS Consultant

Good interpersonal and communication skills to interface with technical, managers and customers.

Extensive experience in implementing Basis components of SAP R/3 with ABAP/4 as workbench and Oracle as back end server on Windows NT platform.

· SAP R/3 3.0F installation with (SAP Customer Solution) Cable Solution on Windows NT 4.0

· SAP R/3 Upgrade 2.2F to 3.0F / Kernel upgrade to 31H

. SAP R/3 Implementation in 3.0F

· SAPDBA functions.

Operating System : Windows 3.51 ; Windows NT 4.0

. ABAP/4 Dictionary, Internal tables

. ABAP/4 SQL

. Screen painter, menu painter, logic flow, lock object, authorization checks, message class

. ABAP/4 Query (logic database)

. SAP Script

. Self-Definition information system

. SAP Data model, entity type and relationship (E-R)

. Trace & Debugging

. Oracle 7.3.3.2.0 installation on SNI PRIMERGY 760/Compaq PROLIANT 5500 .

. Oracle upgrade from 7.1.3.3.6 to 7.2.2.4.3, 7.2.2.4.3 to 7.3.3.2.0 and apply patches.

. Physical and Logical design of Oracle database. Designed and implemented

. Backup strategies, recovery methods. Performance tuning and application tuning, Database Creation, User Management, Tablespace Management, Rollback segment, Application Tuning, Database Security, import/export, SQL*DBA, SQL*PLUS.

Mar. 1998 – Aug. 1998

Responsible for upgrade the SAP R/3 from 2.2F with Cable Solution to 3.0F with Cable Solution in Central instance and Application Server system , fresh installation SAP R/3 3.0F system with Cable Solution Windows NT 4.0 environment. Check list requirements to confirm to installation, creating file systems for normal install. SAP R/3 Kernel upgrade 3.0F/3.1H , Installation of SAP R/3 front-end software in PC's (Windows 95 and NT 4.0) and Log on Load Balancing, Installation local/remote SAP printer

Responsibilities included:

· SAP R/3 3.0F installation on Windows NT 4.0 with (SAP Customer Solution) Cable Solution

· SAP R/3 Upgrade 2.2F to 3.0F / Kernel upgrade to 31H and Apply hot packages

· Standalone Application Server Installation

. Oracle upgrade from 7.1.3.3.6 to 7.2.2.4.3, 7.2.2.4.3 to 7.3.3.2.0

· Set up Workbench Organizer and the Transport System.(SE06)

· Configured the Workbench organizer after installation of R/3 system.

. Customization for Cable Solution module.

· Transporting profile and authorization between clients .

· Transporting Programs, Tables, Authorization objects from one system to another systems .

· Monitoring different transport logs. (SE01)

. Chinese language installation (SMLT)

· Client Import and Export across two systems. (SCC2)

. Siemenes Cable Solution Model Company Installation

· R/3 System complete client copy. (R/3 transaction:SCC0; OS level r3trans.exe)

· Copy of specific tables between two clients and two systems. (r3trans.exe)

· Deleting client using R3trans on OS level. (r3trans.exe)

· User maintenance and Authorization and profile maintenance. (SU01)

· Changing and Importing Instance, Default and Startup profiles. (RZ10)

· Set up background processes/jobs. (SM36)

· System monitor, Alert monitor, workload and buffers. (SM50,ST03,ST04)

· Log on group maintenance, Alert thresholds. (SMLG)

· Operation mode configuration. (SM63)

· System trace, developer trace, SQL trace. (ST01,ST11,ST05)

· Set up OSS connection and installation of SAP Router.

· Solving R/3 Software problems reported by Team members.

· Downloading Patches.

· Downloading and Applying Hot Packages for 3.0F(SPAM)

· Tablespace Administration including review and expansion , reorganization of tablespace and Tables.

· Well conception with backing up database and archive log backup and monitoring different backup logs.

· Changing Archive modes.

· Import and export of different objects.

. Automatic online backup script on OS level

. Define Chinese printer in SAP system and import Chinese print driver into system

. Setup local and remote printer

. Install Barcode print driver and import fonts for special printer

. Make additional program to export and import CS data during SAP Upgrade.

. Make examination program to check the integrity of the CS data .

. Change MRP display screen to show some special information for Cable property.

. Combine to use ABAP/4 report and SAP Script to design print out format such as delivery notes, purchase order, work instruction.

. Design print out format to print Barcode

. Program reports for display some Cable Solution property information

. Use SAP Query tools to make information system reports

. Make customer self-define information system

. Dialog program for end-user use screen-painter and menu-painter

. Authorization define and set for reports

. Data recorder lock and unlock in ABAP/4 program

Sep. 1998 – Dec.1998

Responsible for design inspection lot result recorder input program using screen-painter, menu-painter , flow-logic, lock objects(ENQUEUE and DEQUEUE), matchcode object, message class, number ranges, and make well known about the QM data model , entity type and relationship.

ABAP/4 Programming

. Well known using screen-painter, menu-painter, flow logic, lock objects, matchcode object, message class, number ranges to design interactive program.

. Make aware that QM data model, entity type and relationships of the entities.

. Create archive file using archive management (SARA) for inspection lot result recorder.

. Design finish goods certification print out forms using barcode

Jul. 1997 - Till date

Responsibilities included:

ABAP/4 programming

SAP System administration

SAP R/3 Upgrade

SAP R/3 Implementation

Oracle DBA

Jul. 1995 – Jun. 1997

Oracle DBA and System Administrator for South-West Institute of physics, China.

Responsible for various DBA activities like Oracle Installation, Database Creation, Tablespace Management, Rollback Segment, user security, Stored Procedure, Application tuning, Import/Export utility, Backup Strategies, Database Recovery, Granting Privileges and Roles, User management and securities, Rollback segment allocation.

Programming use Power Builder based on Oracle database for human resource management.

Environment: NT, Oracle 7.2, Power Builder, SQL*DBA and PL/SQL.

Sep. 1998 to Dec.1998 Spoken English training in Sichuan Union University, China

Mar. 1998 SAP Upgrade training in Munich, Germany

Dec. 1997 SAP ABAP/4 BC400 training in Shanghai ,China

Sep. 1991 to Jul. 1995 Bachelor Degree with major Auto-Control in Chongqing University, China