Over 7 years of experience in SAp Basis and Oracle DBA; Oracle OCP DBA Certified.
? Over 7 years of experience in SAP R/3 Basis and oracle 7/8/8i/9i DBA. ? Experience in administration of whole data center setup and management including infrastructure and fully-outsourced for data center operations and DRC (disaster recovery center), such as full systems management, disaster recovery, and 247 helpdesk for mission-critical systems.
SAP Basis and oracle DBA Skills Expertise: ? R/3 system installations and implementations (R/3 3.1I/4.0B/4.5B/4.6C/4.7; oracle 7/8/8i/9i) ? SAP BW, CRM installations and support ? SAP R/3 upgrade (4.0B to 4.6C; 4.5B to 4.6C); CRM upgrade (2.0B to 4.0) ? oracle database upgrade (8 to 8i; 8i to 9i) ? SAP systems migration (including hardware and OS Windows) ? SAP systems landscape and transport system setup, maintenance and troubleshooting ? Backup and recovery strategies implementation and troubleshooting (including third-party backup software, such as Veritas Exec.) ? SAP security setup and maintenance (users administration, roles and authorizations setup and maintenance) ? oracle disaster recovery systems setup, maintenance and rebuilding ? Disaster recovery trials for SAP systems ? R/3 homogeneous system copy (on AIX/oracle and Windows/oracle) ? SAP R/3 SID change under Windows/oracle environment ? SAP R/3 and oracle database day-to-day administration and technical support ? SAP R/3 and oracle database system performance tuning ? SAP/oracle database reorganization ? Client transport and client copy ? SAP kernel patches update, SAP support package upgrade, PI add-on installation and upgrade, Note assistant installation and upgrade ? SAP language import ? SAP spool system management CERTIFICATION oracle8i Certified Professional Database Administrator (OCP DBA) EDUCATION Bachelor of Engineering B. Eng. (1984 ? 1989), from Dept. of Electrical Engineering and Information Science in University of Science and Technology of China (USTC) PROFESSIONAL EXPERIENCE (SAP R/3 BASIS) SAP Technical Consultant Hewlett Packard Singapore, Singapore (5/2001 ? 7/2006) Major Responsibilities: ? Managed an SAP Data Center for clients? outsourced hosting machines and provided SAP/oracle technical support and consulted for clients. ? Performed the following SAP R/3 basis within Multi OS/DB Environments: Windows/oracle, UNIX/oracle, Windows/MS-SQL Server ? Managed 8 clients with over 30 SAP servers, some of which are hosted servers in HP data center, some of which are supported remotely, and some of which are supported on clients? sites Accomplishments: ? SAP systems migration and oracle database upgrade (Windows/oracle) Independently undertook a relative big project from plan to implementation. The project included hardware migrations for 14 servers (5 development systems, 1 QA system, 4 productive systems and 4 disaster recovery systems, SAP releases were 4.0B, 4.5B, and 4.7 Enterprise), oracle upgrades from 8i to 9i for them, and disaster recovery SAP/oracle servers setup and configured. Firstly, OS was installed and configured on the new servers by the Windows 2003 Server. Secondly, the SAP systems were moved from old hardware (OS: Windows 2000 Server) to the new ones, including SAP/oracle installation and DB transferred. Thirdly, oracle was upgraded from 8i to 9i and latest patches were applied. Fourthly, disaster recovery SAP/oracle servers were set up and worked (transferring archived logs and applying them to standby DB by scripts). Non-productive systems were performed on weekdays and productive systems had to be performed on weekends. ? SAP system migration (homogeneous system copy) (Windows/oracle) Independently performed this small project, which migrated SAP system to a new hardware (SAP 3.1I and oracle 8). Firstly, OS Windows 2000 Server was installed and configured; secondly, SAP/oracle was installed; thirdly, DB was transferred from the old hardware to the new one and made some configurations. ? SAP security setup and maintenance (SAP ECC 5.0) Joined a big project ?SAP systems upgraded and merged? as a team member. Based on functional requirements and user/role matrix provided, roles for the client company were created and their authorization profiles were generated as well using SAP transactions PFCG, SU02, SU03, etc.. Then those roles were assigned to individual users. Meanwhile, in the whole project process, the security was maintained according to users or functional consultants? requirements. ? SAP R/3 homogeneous system copy (Windows/oracle, UNIX/oracle) Independently performed this task according to different clients? requirements. A faster method, which is based on DB backup and restoration, was used instead of the SAP normal method by using the tool R3COPY. After the DB restoration, some modifications have to be done, including generating a new oracle control file, changing SAP and oracle services, running some oracle scripts, running SAP transaction SE06, modifying instance name, background jobs, printer configurations, etc.. ? SAP/oracle disaster recovery systems setup and maintenance (OS: Windows) Independently undertook two projects that set up disaster recovery systems for two clients. One client has 5 systems (R/3 4.0B, 4.5B, 4.7), and another one system (R/3 3.1I). Set up the systems from scratch and maintained them. Meanwhile, performed 4 trials of disaster recovery emulation for clients. ? SAP/oracle systems recovery Independently performed DB recovery for clients whenever hardware was crashed or users made mistakes. Generally, this includes hardware replaced, DB restoration, and DB recovery. ? SAP installation on Windows/oracle (R/3 3.1I, 4.0B, 4.5B, 4.6C, 4.7; CRM 3.1) These were new installations, including DB export (DB created). The procedure is just followed by installation guide; but configurations had to be based on different clients? requirements. ? SAP upgrade on Windows/oracle and Windows/MS-SQL Server (R/3 4.5B to 4.6C; CRM 2.0B to 4.0) It divided by two phases: one is the preparation stage, and another upgrade stage. ? Rebuilding the whole SAP system from a backup tape (Windows/oracle) Based on a DB backup tape that client provided, a productive SAP system was rebuilt. It included OS installation and configurations according to requirement, SAP/oracle installation, and DB restoration and recovery (if necessary). ? SAP/oracle DB reorganization (OS: Windows) Using SAPDBA tool to perform this task. ? Client transport and client copy Performed some big DB for some clients and before did it, a big rollback segment had to be created and switched in order to make it. ? SAP kernel patches update, SAP support package upgrade, PI add-on installation and upgrade, Note assistant installation and upgrade Performed this kind of tasks using SAP transactions SPAM and SAINT. ? SAP R/3 and oracle database system performance tuning Based on SAP advices or system demands, some SAP or oracle profile parameters were modified. ? SAP system landscape setup and the CTS configuration Did it in client 000 by using user SAP* with transaction STMS. Day-to-day Operations: ? SAP R/3 and oracle database daily administration and technical support, including using some tools, such as SAPDBA, BR* tools, SQL*PLUS ? System and database backup, restoration, recovery ? SAP security maintenance, including users administration, authorization and roles ? Configuration and management with CCMS: monitoring, operation modes ? Transport system administration ? Management of background jobs ? Front end installation ? Administration of spool system and printing ? Correction of bugs by applying SAP notes ? Support of the functional team with data loads and interfaces ? Assistance in the technical areas of cross-applications such as ALE, IDOC, EDI, or workflow ? Working with the functional team and support their requirements Environment: SAP R/3 Enterprise, 4.6C, 4.5B, 4.0B, 3.1I; oracle 9i/8i/8/7; Windows NT/2000/2003 Server, UNIX AIX 4.3; IBM Servers, DELL Servers, IBM RS6000 Systems Engineer Allied Technologies (S) Pte. Ltd., Singapore (6/2000 ? 4/2001) Led MIS staff in the company, Was responsible for planning, advice and management of the information infrastructure and systems; set up the whole company network, including RAS from Malaysia; It is a stamping manufacturing for computer parts and others with several factories in the region (Singapore, Malaysia, China, and Vietnam). The company implemented almost all functional modules, including FI/CO, MM, PP, SD, PM, PS, QM, HR. The system platform is SAP/oracle/Windows. As an SAP Basis engineer for the entire implementation of project, handled systems? set-up and all of R/3 basis jobs. For network infrastructure: built 2 internal Ethernet subnets (including fiber optic), leased line, RAS dial-up, ISDN line. For SAP R/3, set up the Windows NT servers, 3-system landscape (production, QA and development). Set up the network printing system with HP JetDirect print servers. Managed all SAP basis tasks: Performed database backup with SAP tools (SAPDBA and BR* programs) and full system backup with HP OmniBack II. Performed daily tasks with SAP transactions, which are checking system logs, short dump analysis, monitoring SAP processes, system performance using CCMS, checking spool problems, background jobs, etc.. Performed user administration and generated roles and authorization profiles using SAP transaction PFCG based on functional requirements. Applied SAP Support Packages and kernel patches. Managed transport requests, including object import, client copy and client transport. Also maintained around 100 PCs and 20 printers and network infrastructure. Environment: SAP R/3 4.6C; oracle8; Windows NT Server; HP OmniBack II; HP Servers; Novell 4.11. SAP Basis Consultant Melandas Casa Mobili Pte. Ltd., Singapore (11/1999 ? 6/2000) Worked in the SAP implementation project from system settings and preparation for going live, to live operation (every phase of an SAP implementation project). It is a furnishing factory, which implemented SAP R/3 4.5B with 4 business functional modules FI/CO, MM, PP, SD. As a basis consultant, handled all technical part of SAP implementation and others except SAP system installation. The system platform was SAP/oracle/Windows and landscape 2-system. Performed database backup with SAP tools (SAPDBA, BR* programs) and full system backup with VERITAS Backup Exec 7.3. Performed daily tasks using SAP transactions: checking system logs, short dump analysis, monitoring SAP processes, system performance by CCMS tools, checking SAP spool problems, checking background jobs, etc.. Performed user administration and generated roles and authorization profiles based on functional requirements using SAP transaction PFCG. Set up printers for SAP using and managed printing jobs. Managed transport requests, including object import, client copy and client transport. Upgraded system by using hot patches and kernel patches. Provided problem resolution according to SAP OSS notes. Also maintained 80 PCs and 10 printers and company LAN and Windows NT file servers. Review SAP GoingLive check and modified parameters and configurations based on SAP report. Environment: SAP R/3 4.5B; oracle8; Windows NT 4.0 Server; VERITAS Backup Exec 7.3. Systems Engineer Parkway Group Healthcare Pte. Ltd., Singapore (2/1999 ? 11/1999) As a team member, provide technical support of network systems, UNIX platform, SAP and database (Informix 7). In the process of SAP R/3 implementation, performed daily monitoring duties using SAP transactions, performed transport requests, performed database management (adding datafiles), based on SAP OSS notes, provided problem resolution, and set up network printers for SAP using as well. Environment: SAP R/3 4.0B; Informix 7; Compaq Tru64 UNIX (Digital Alpha 8200); Windows NT Server PROFESSIONAL EXPERIENCE (Signal Processing) Project Engineer DSO National Laboratories, Singapore (9/1996 ? 12/1998) (Under Gateway Technologies Services, Singapore before Feb. 1997) Synopsis: Continued to study ocean acoustics and signal processing. Role: Acoustic shallow-water reverberation computer modeling including sea-bottom and sea-surface reverberation; a new technique of passive ranging in shallow water by using frequency cross correlation processing; wrote a lot of programs by using FORTRAN and C/C++ on UNIX platform and MATLAB codes; wrote one paper and two internal technical reports. Engineer (6/1994 ? 6/1996) Engineer Assistant (7/1989 ? 6/1994) Institute of Acoustics, Chinese Academy of Sciences, P. R. China
Synopsis: Undertook the project ?Underwater Acoustic Communication?. Worked on computational ocean acoustics and acoustic signal processing. Role: Developed a wide-band transmitter, receiver and high speed A/D converter, including analog and digital circuits, signal design (MFSK), signal detection by FFT spectral estimation and other methods, error correct codes, i.e., convolutional codes and Viterbi algorithm. Built the model of sound propagation in ocean channel and developed the fast algorithm; Studied the sound pulse propagation in shallow water that is more complicated than that in deep sea; Studied the spatial coherence in ocean in theory and experiments; Studied matched-field processing in ocean acoustics; Did much work about data analysis for ship noise and ambient noise in the ocean; Wrote a lot of computer codes by using FORTRAN and C/C++ on numerical model and signal processing programs by using MATLAB. AWARDS: In August 1994, I was awarded the Certificate of National Science and Technology Achievements by the State Science and Technology Commission of P.R. China for the project "Underwater Acoustic Communication".