Sap Sql Server
Resume:
Jim Huang
Chicago, IL ***47
ac1yie@r.postjobfree.com
Seeking a position as a SAP Basis administrator
Employment History:
Deloitte Consultant – Contractor Philadelphia
Sr SAP Basis Consultant 07 /2016 – 03/2017 (9 Months)
Client: Oil & Gas company – Philadelphia / American Airlines Corp – Dallas
Troubleshooting the issue in SAP MII, ME and SAPMEINT related by AS JAVA, poor performance, database, resource and ECC Connection issues.
Setting up printers, Scheduling Batch jobs, Client maintenance, has worked on analyzing support pack levels, system requirements and compatibility issues.
• Performed TDI Solution for SAP HANA Scale-Out(4+1), network, and storage. Design, Installation Hana database Scale out, and Migration(S4hana/BW) from Oracle database by DMO on UAT system. And final reviewing project on migration, testing, cutover, and fallback plans, uncovering improvement opportunities across the migration project.
• Installation and Upgrade to S/4 HANA 1511 - 1610 and post activities.
• Performance Tuning and Troubleshooting on HANA and SAP system, include partition table, HANA system using SQL plan cache, Delta merge analysis, Compression of a Column Table and analysis of long running statement in HANA.
Finished Fiori Configuration of Factsheet Apps.
• Implement Gateway and SAP SLT for real time replication.
Installation and Upgrade NW 7.5 on SAP S4/Hana ERP EH7, BW on HANA, Oracle, Sybase and post activities, and Configurations for SLT Connection for Oil & Gas project.
• Successfully Configured DR flips between Primary data center and DR data center.
• Performed and configured HANA System Replication, configuration and backup recovery.
• Assign security roles to HANA and SAP users.
Key Technologies/Skills: SAP ERP 6.0 BW 7.5, S4HANA, Oracle, DB2
CF Industries – Contractor Chicago
Sr SAP Basis Consultant 11/2015 – 07/2016 (9 Months)
Deploying JDBC Driver in SAP NetWeaver Java AS Hosting SAP MII, SAPMEINT Component in SAP NetWeaver Java AS Hosting SAP MII, SAPMEINTCTC Component in SAP NetWeaver Java AS Hosting SAP MII, SAP MII IDOC Listener, ERP, SAPMEINT Interfaces and SAP ME configurations. Post CTC Execution testing, checking SAPMEINT applications started in MII Netweaver, validating SAP ME Integration,
Worked on SAP S4HANA Platform and BW/BOBJ/BPC, HANA, HANA, BW/BPC installation, then start migration from Oracle to HANA. Successfully configured SAP parameters and resolve the performance issues on BW/ BOBJ /BPC consolidation with high data volume. Upgraded NW 7.4 on EP, BW from 7.4 to 7.5 on Dev servers.
Performance tuning and testing on ECC 6.0, APO, PI, EP, NWDI, SRM and Hana database.
Key Technologies/Skills: SAP S4HANA, APO, BW 7.5, HANA, SQL Server
JPMorgan Chase & Co – Full time Employee Chicago
Sr SAP Basis Administrator 01/2007 – 08/2015 (8.5 Years)
Successfully Configured failover on SAP instances HANA scale out 6+1, Oracle RAC failover and PowerHA/SAPCTL for app server failover on Primary and standby on Primary and DR environment. Successfully Configured DR flip between Primary data center and DR data center. Migration(S4hana/BW) from Oracle database by DMO on DEV, UAT system.
Installation, configuration, upgrades, patches, performance tuning, backup and recovery
Installation and migration(BW) to SAP HANA from Oracle database by DMO/Imp exp on DEV, UAT and PRD system.
Successfully configured HANA DR Replication and SAP BWP DR Flip, created Replication monitor shell scripts to monitor replication status on BWP and BWP DR.
Successfully installed configured Oracle RAC/SAPCTLHA for sap application servers.
Successfully Configured IBM AIX powerHA failover on AIX Cluster between Oracle, Hana database and SAP application instances.
Performance analysis of HANA system using SQL plan cache, Delta merge analysis, and analysis of long running statement in HANA/Oracle.
Build a testing environment Vmware on Linux server, include SUSE LUNIX and HANA SP8 installation on NFS shared file system before start installation and migration on DEV environments.
Installed and configured BW/BPC HANA SP7, Upgrade BPC SP7 to BPC10 SP14 and Hana BPC package, performance tuning BPC after migration.
Installed and configured GRC on Windows 2008 servers.
Setting up RFC RSA1 data source system connections between BW system and ERP.
Applying Support SAP ERP (FI, CO, HR, HCM, MM, QM, PP) PRD, APO, BW EP, NWDI, SRM by 24 x 7.
Refresh of SAP ERP/APO(liver cash)/BW quality system refresh from production. Verification Checklist work.
Upgraded SAP ECC 4.7 to ECC 6 and EHP 7 upgrade on DEV, UAT/DR, and PRD/DR.
ECC Unicode migration on ECC 6 EHP7 before HANA migration.
Upgraded SAP SCM/APO 7.0 EHP3 on SCM DEV, UAT and DR.
Installed and configured SAP BW Net weave 7.0, and upgrade to Net weave 7.3, 7.4, include BPC 10 SP7 upgrade on RAC/SAPCTL HA and HANA/PowerHA SAP application servers.
Installed, upgrade and configured SAP PI 7.1 EHP1.
Installed, upgrade and configured SAP CRM7 0_EHP3.
Installed, upgrade and configured SAP EP 7.3.
Installed and configured Web dispatcher ABAP and Java stack on ERP and BW.
Created security Encryption key between ABAP instance, Hana, and Oracle database, created SSL, SNC security encryption key on Web dispatcher for BPC, EPM SP19, BO 4.1 and Ariba.
Successfully installed ECC 4.7, BW7.0, GTS, EP 7.0, SRM 7.0, SolMan 7.0, GRC 10, SCM 7.0 on AIX Server.
Installing 9i, 10g and 11g databases on AIX and HP– UX. Migration of Database from 9i, 10g and applying patches whenever required. Upgrade of Databases from 10g to 11g.
Successfully Installed and configured Oracle 10g/11g RAC high availability. Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC.
Performed Data Guard, backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN.
DATABASE MIGRATION: Successfully performed OS/Database more than 60 SID migration on HP/AIX, AIX/Linux, MS/Linux Migration of SAP BW/ECC/CRS/SRS systems, include Oracle RAC 10/11g, Data Guard, SAPCTL, PowerHA installation and configuration and moving the production, DR, UAT and DEV SAP ERP environments by use Oracle Transportable table spaces over a dedicated 10GB Network connection on SAP servers in different data centers.
STMS configuration, Printer configuration, Spool Administration.
Applying Support Packages, Kernel Upgrade. Upgrading/Installing Service Tools and Add– Ons using SPAM/SAINT.
Setting up printers, Scheduling Batch jobs, Client maintenance, has worked on analyzing support pack levels, system requirements and compatibility issues.
Installation of Solution Manager and configuring it to collect the alert messages from the SAP system.
Key Technologies/Skills: IBM AIX 6.1, SUSE Linux 12.2, Windows 2008, GPFS 3.2, Oracle CRS & DBMS 11.2.03, SAP, NW 7.0, APO 7.0, BW 7.3, Business Objects 4.1. SAP ERP ECC 6, HANA 1.0 SPS9, Sybase, Oracle 11.2, RAC, SQL Server, DB2, Sybase IQ, BWA, SQL Server 2012
WW Grainger In – Full time Employee Chicago Sr SAP Basis Administrator 10/2004 – 12/2006 (2 Years)
Responsible for support SAP ERP MII, ME, MEINT, BW, R/3, GTS, BW, APO instances and Bolton database, Participate SAP Go– Lives in Grainger on DB2, Oracle, SQL Server and SAP DB database on UNIX, Linux and Windows Server platforms.
Troubleshooting Inefficient SAP SQL processing or error on memory paging alerts, SAP system log error message on CRM, R/3 APO and BW. BW performance issues from data extraction to data reporting, and General System Wide Slowdown problem on R/3 and CRM.
DB2 UDB – Support database DB2 UDB of Grainger, Installed, upgrade DB2 database from 7 to 8.
Key Technologies/Skills SAP ECC, BW, CRM, MDM, DB2 UDB
Northern Trust Bank – Contractor Chicago
DB2 UDB DBA Consultant 04/2004 – 10/2004 (6 Months)
Provide support for development, test, and production environments, including installed and setup of new servers, databases, and objects within the database.
Perform backup and recovery of databases as needed and Participate in Production on– call support rotation.
Design and implementing appropriate changes to the physical database indexes, database and server configurations, etc. as needed for optimal performance. Provide appropriate suggestions to developers in their implementation of SQL or other data access code.
Monitor and troubleshoot performance, availability, and scalability/capacity issues, fixed locking and slow problem.
Key Technologies/Skills DB2 UDB, Java/J2EE/JDBC
Spiegel group Inc. – Full time Employee Chicago
Sr SAP Basis Administrator (Oracle, Sybase, DB2) 04/2001 – 04/2004 (3 Years)
Responsible for support SAP ECC MII, ME, MEINT, MDM, BW applications.
Performance tuning, troubleshooting on SAP ECC MII, ME, MEINT, CRM, SRM, ERP, MDM. Performance tuning by adjusting by various profile parameters, and buffers sizes. Client Administration and handled client copies/exports and client deletions. Making batch files for backup jobs and scheduling them. Installation and Configuration of different types of R/3 Printing/Output Devices.
Client transport: The client transport of production client of size 30 GB to development system.
Support for Sybase, Eddie Bauer Merchandise production system running on Solaris. Provided assistance regarding database– coding techniques, use of DBMS– specific functions, database utilities. Capacity planning: based on volumetric from a data model, calculate size of tables and associated indexes, accounting for fragmentation and
DB2 Database 7/8 Responsible for support all critical database of Spiegel Catalog and Newport News, physical maintained and tuned of multiple DB2 UDB Databases on AIX UNIX. Installed, configured and maintained DB2 UDB databases for Merchandise production system..
Key Technologies/Skills Sybase, SAP CRM, SRM, ERP, MDM, Oracle RAC, DB2 UDB
Chicago Board Options Exchange – Full time Employee Chicago
Oracle RAC Database/SQL Server DBA 01/1997 – 04/2001 (4 Years)
Database support for and Trade History database on Oracle RAC
Responsible for designed and developed the Membership and Trade History database, physical maintenance and tuned of multiple ORACLE instances on HP, SUN, AIX UNIX, WEBSITE, SQL Server platforms.
Installed and upgraded of Oracle RAC database in the Sun Solaris environment. Handled administrative duties for Oracle Parallel Server clusters which support highly visible, mission critical applications.
Support PeopleSoft Time & Billing application, including database administration and monitoring, and troubleshooting production issues in a production environment.
Performed backup, recovery and minor administrative duties for recovery and minor administrative duties for MS SQL Server database.
Create DDL and build database objects from logical and physical models by used Erwin; tuned SQL/PLSQL by SQLlib and create necessary indexes, and store procedures; enforced business rules by created required referential constraints. Design and implement stored procedures, triggers, and user defined functions. Design and implement data security and data integrity strategies.
Build database related scripts by KORN SHELL and PERL; supervised Project Data administrators with their data base related task; and reviewed and approved all new development and changes to logical Database Models.
Key Technologies/Skills: Oracle, KORN SHELL and PERL
CSC corporation as consultant – Full Time Employee Chicago
Client – US Environmental Protection Agency
Oracle DBA 7/1995 – 1/1997 ( 2 Years)
Worked for US Environmental Protection Agency information center. Duties include:
Constructed and developed Lake Michigan Mass Balance LMMB, Integrated Contract Management System ICMS, Super fund Cost Recovery Image Processing System SCRIPTS project, physically and logically designed database.
Created oracle distributed database with SAS interface by using the ORACLE Call Interface OCI, loaded Data, and changed schema, tuned performance Memory, I/O, and Contention.
Estimated space management backed up recovery, created database security.
Upgraded and installed database in ORACLE 7.26, SQL*netV2 multi– threaded server, form5.x, Oracle Case tools 5.0.
Key Technologies/Skills ORACLE 7.26, loaded Data
RR Donnelley Mobile publish Company – Full Time Employee Chicago
Software engineer C/C++/Java Developer 11/1993 – 7/1995 ( 2 Years)
Created and maintained ORACLE database objects. Designed and developed database Publishing Catalog projects for United Stationer and Case Company. Created database, extracted C/C++ programs, OCI with C++centerline, GUI interface, and programs of loaded data and used utilities to maintain database, backed up recovery, created database security in ORACLE 7.0, Erwin case tool, Pro*C, POWERBUILDER, SQL*Form3.0, SQL*Plus, SQL*PL/SQL. Also using Awk and Perl translated SGML to MML Framemaker under UNIX SUN/OS X– WINDOWS and MS– DOS Novell– LAN environment.
Key Technologies/Skills C/C++/Java
Education:
Degree
AA/AS, BA/BS, MA/MS/MBA, PhD, JD
Area of Study
School/College/University
Location
Was the degree awarded? Yes/No
OPTIONAL: Date MM/YY
BS
Computer Science
Computer Science
Beijing, China
YES
02/83
MS
Computer Science
Computer Science
Chicago, IL
YES
02/92
Certifications and Certificates:
Certification
Issued By
Date Obtained
MM/YY
SAP Basis Administratration Netweaver Certification
SAP
2017
Certified Professional Class Training Courses:
Hana HA100, HA200, HA240(DMO), SAP BW/BPC, ERP Upgrade, CRM upgrade, SAP Java, ASP, JSP
DB2 DBA, Sybase DBA, ORACLE DBA Master Program, Oracle DBA11, Oracle12 RAC Server
Performance Tuning, Backup, Recovery, Oracle distributed, Database, SQL
Server DBA, SQL, 4GL, UNIX SYSTEM and UNIX TCP/IP
Contact this candidate