Sap Hana/basis Consultant Resume
Sharptown, TX
SUMMARY:
- Over 11+ years of professional experience in IT. 9+ years as a SAP Basis Consultant on different flavors of UNIX, Windows as well as Oracle/MSSQL Database administrator. Involved in 2 Full Life Cycle Implementation, 2 upgrades and 3 support Projects.
- Exposure in SAP HANA 1.0. Data Provisioning, Data Replication, Modelling, Administration, backup recovery.
- Hands on BW migration from RDBMS to HANA.
- Upgrade, install and configure BO, ECC, ERP suites as well as EPM (BPC) and SEM suites.
- Good working knowledge in Solution Manager 7.0 (Solman).
- Experience in SAP system Upgrade.
- Worked extensively in several SAP products with different landscape includes SAP NetWeaver ECC 5.0/ 6.0 EHP4,EHP5, BW 7.0, CRM 7.0, SR..M 7.0 Solution Manager 7.1
- Experience in SAP R/3 Basis or Netweaver Administration, Maintenance, Homogeneous system copy, monitoring, troubleshooting, and applying hot packages, distributing Patches, Kernel Upgrades and SPAM updates.
- Done a full cycle of SAP system OS/DB migration.
- Proficient in creating Security roles and authorization objects, performing Audit of SAP R/3 users, coordinating user accounts.
- Hands on expertise in Administration, Operations, Transport Management, Performance Monitoring & Tuning, Client Administration and Spool Administration.
- Database Administration Oracle 9i 10g and 11g using SAPDBA, BRTOOLS.
- Experience in System Administration and Network Administration, Systems design, Software installation, Configuration and end user Technical Support project
- Good client facing skills, Problem management and Incident management.
- Extensive experience in analyzing and solving day - to-day Production issues with client facing skills.
- Excellent communication skills, interpersonal skills, adaptive and self-learner.
TECHNICAL SKILLS:
SAP: SAP R/3 Release 4.6B, 4.6C, NetWeaver 2004s/7.x, ECC 5.0/6.0, Enterprise Portal 5.0/6.0, Solution Manager 3.2/4.0 and 7.0, XI 3.0/PI 7.0, BW 3.1/3.5/7.3/BI 7.x, TREX 6.0/7.0 on NW2004 and NW2004s SR..M 4.0/5.0, CRM 4.0/5.0, SCM 4.0, APO 3.1/3.2, WAS 6.20/6.40, MM/SD/HCM/MDM/GDM/FI
Platforms: Linux (CentOS/Suse Enterprise - SLES/Redhat Enterprise - RHEL), Windows (2003/2008/2012 ), Unix (Sun Solaris 10, AIX 5.3/5.2)
Databases: SAP HANA 1.0, Oracle 11g/10g, MSSQL 2005/2008/2012 , IBM DB2, Teradata, MaxDB, SybaseLanguage Hardware Virtualization Project ManagementJava, C#, ABAP, Shell script, Powershell script DELL (PowerEdge), HP (CS series), IBM (System X/ThinkServer), Cisco Routers/Switches/UCS (Unified Computer), NetApp and EMC storage devices VMware vSphere 5.x, Microsoft Hyper - V Server 2012R2. ASAP, Agile, SDR, Workflow, eCATTs
PROFESSIONAL EXPERIENCE:
Confidential, Sharptown, TX
Environment: SAP HANA 1.0, ECC 6.0, SAP NetWeaver 7.4, Oracle
SAP HANA/BASIS Consultant
Responsibilities:
- Part of implementation project to upgrade and migration Business Suite/BW/BPC to HANA
- Planning/preparing and installing SAP HANA 1.0 on customer HP Converged System CS500 for SAP HANA 3PAR SP Block with Suse Linux Enterprise 11 SP2.
- Using DMO to plan upgrade and migrate source system BW to 7.4 and deploying NetWeaver Primary Application Server (PAS) instance on target system. Prepare HANA server appliance for target system.
- Experience with SAP HANA Data Provisioning and Data Replication using SAP LT Replication Server (SLT).
- Exposure with Log Based Replication: Sybase Replication Server and Load Controller.
- Loading data into table definitions, suspending data loads, resuming data loads. Copying contents delivered by SAP.
- Exposure in SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Hands-on experience in modeling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections.
- Experience with SAP HANA Administration including Exporting and Importing systems, Monitoring Disk usage, Performance Monitoring, Monitoring with Alerts, Configuring Alerts and Updating sap HANA studio.
- Experience in managing SAP HANA Database Backup and Recovery.
- Experience with SAP HANA Security including User Management, Roles, and Privileges
- Provide SAP Basis administration Support, Performance monitoring & tuning, Problem analysis & resolution, and other activities required to maintain system integrity and maximize uptime.
- Installation of SAP Netweaver7.4
- SAP BI installation and establishing in BW
- Perform Solution Manager Maintenance Optimizer to download and apply SP stack on sand box and Production Landscape.
- Responsible for Monitoring activities like Transport management, Analyzing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces and Lock Entries
- Background job administration, as per customer request activate the trace for long running jobs & cancel the jobs, provide the solution for canceled jobs
- Applied NetWeaver kernel upgrade, support packages, Add-ons, and OSS repair.
- Well verse on variety of platforms range Windows/Linux/Unix from different hardware vendors: Dell, Cisco, Hitachi, IBM (Lenovo) ….
- High knowledge and experience on system infrastructure: Windows Active Directory (MCSE) or Linux Netboot (Linux+)
- Hands on CISCO routers, switches, PIX as well as VLAN and others CISCO proprietary technologies. Having deep understanding of TCP/IP and other inter-ISP protocols: BGP, OSPF, ISIS, EIGRP, RIP...etc.
- Perform Solution Manager Maintenance Optimizer to download and apply SP stack on sand box and Production Landscape.
- Responsible for Monitoring activities like Transport management, Analyzing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces and Lock Entries
- Background job administration, as per customer request activate the trace for long running jobs & cancel the jobs, provide the solution for canceled jobs
- Experienced with vSphere and HyperV platform.
- Local project: Architect of setting up ESXi 5.1 for SAP environment that includes two HANA servers, 2 BW73 on MSSQL and Oracle, one BW 7.4 on HANA, one ECC6 EHP6, two BODS 4.x, one EPM-PBC and one ECC6 with SLT.
Confidential, Atlanta, GA
Environment: ECC 6.0 EHP7, BW 7.4, CRM 7, PI 7 and Oracle
Sr. SAP BASIS Consultant
Responsibilities:
- Upgrades ECC 6.0 from EHP 5 to EHP6; B.W NetWeaver from 7.0.1 EHP1 to BW 7.4 ABAP; CRM 7 EHP2 to EHP3; BusinessObject 4.0 to 4.2. Perform System copy on ECC 6.0
- System Refresh from Production to Quality in ECC 6.0 landscape system
- Planned and prepared landscape for upgrading Portal Enterprise that including setup and configured NW gateway, DMZ and WebDispatcher.
- Planned and prepared landscape/infrastructure for SAP Fiori installation on ABAP/HANA.
- Installed/configured SAP Fiori and Add-on for end user access from mobile platform (smartphone, tablet)
- Involved in maintenance, enhancement and development work of complex interfaces leveraging SAP PI 7.3 technology.
- Involved in successful technical upgrade from PI 7.1 to 7.3 which had 80+ interfaces
- Involved in successful upgrade from Advantco to SFTP SAP B2b add-on for security interfaces.
- Extensively worked on ABAP proxy, File, web service, Idocs, SFTP/PGP encryption features of SAP PI 7.3
- Worked on B2B adapter and migrating interfaces from Gentran to SAP PI 7.
- System Refresh from Production to Quality in SR..M and CRM 7.0 landscape system. Perform post System Refresh activities. Kernel and Support pack upgrade for all the systems in the Landscape
- Applied/Deployed SAP Java support packages and Business support patches on Portal systems
- SR. M BP Deployed via SDM on portal, Installed SAP JVM4.
- Performed test system monitoring for load distribution running on ECC systems for every quarter ends/release time
- Frequently logging on to SAP Online Support System to check for new features & fixes and downloading Notes for future .
- Setup Email configuration using SCOT. Performed security activities
- Works on Oracle activities such as fix packs, log shipping & on DR systems sync log checking using the command
- Applying SAP NOTES based on the Technical and Functional consultant requirements
- TMS DB tool is designed and implemented by the customer which is integrated with SAP STMS, where Perform the DB related activities for the customer/user transport requests and process the transports Via Same tool to all environment of land scape systems
- System/client settings open for all environments and set the work process runtime parameter depends on customer requirement. Works on spool issues
- Solution Manager Configuration.
- Setting up the system landscape in Solution manager.
- Setting up and configure Change Request Management (ChaRM) and Incident Management.
- Created Domain Links between Solution manager and Managed systems for ChaRM
- Created ChaRM Project for each sector and did the validation.
- Configuring SolMan life cycle management for component upgrading.
- Configuration of Early watch alerts.
- Analysing early watch reports & inform client.
- Downloading Support pack stacks & SAP software from Maintenance optimizer.
- Capturing Installation / Migration key from SMSY.
- Alert configuration for satellite systems.
Confidential, Townson, MD
Environment: ECC 5.0/6.0, HANA 1.0, BI/BO 4.0, EPM 10, Oracle 11g, Windows
SAP BASIS Consultant
Responsibilities:
- Administration, upgrade and patching of BI analytics products-EPM products-Business Intelligence systems
- Installation & configurations of BO Explorer, BO Mobile
- Installation of BPC 10.0 and integration with BI systems
- Installation & integration of BO Financial Consolidation 10.0, Financial Information management 10.0, Profitability and Cost Management 10.0
- Installation ofSAPHANA SPS05
- Installation Strategy Management 10.0 & integration with BI Portal
- Installation, configuration and administration of Enterprise portal 7.3
- Installation and configuration of Business Communication Manager 10.0
- HandledSAPSecurity and Basis Administration of ABAP stack products.
- Configuration of CTS+ for Portal systems
- Installation and post configuration of SCM 7.0, LiveCache
- Installed and configured HP QC, HP ALM 11, HP Load Runner, EIM, TAO for testing acceleration
- Troubleshoot authorizations issues using the transaction SU53 and ST01, ST03, SU56, PFUD and SUIM
- Creation of TCP/IP Connection between portals and ECC with help of SM59
- Documenting backup strategy for variousSAPproducts
- ImplementingSAPPatches, Correction notes and Enhancement packages
- Monitoring updates and locks entries
- Performing system Health checks as scheduled
- Carried out Scheduled refresh activities
- Disaster recovery planning
- Carried out post-installations checks
Confidential
Environment: SAP HANA 1.0, ECC 5.0/6.0, SAP NetWeaver 7, Oracle
SAP BASIS Consultant
Responsibilities:
- Initiated the idea of reducing the storage TCO by database compressions and lead the compression project.
- Reduced the database size from 19 TB to 9 TB with Database compression resulting saving $1.2 Lacs on storage every year.
- Installation of OEM Agents across the landscape and configuration of monitoring.
- Database Patch upgrade from Oracle 11g 11.2.0.1.3 to 11.2.0.1.6
- Database patch and bug fixes application
- Homogeneous system copy of the different systems and perform all the post installation steps.
- Perform Post refresh activities like installing SAP License, Checking RFC destinations, Configuring SAP router, Setting up OSS connection, installing hot packages, installation of SAPGUI, performance tuning etc.,
- Importing the SPDD and SPAU objects adjustments by opening the system for adjustments.
- Validate the SPDD and SPAU objects and upgrade the post validations.
- Solution Manager Configuration.
- Setting up the system landscape in Solution manager.
- Maintenance Optimizer Configuration.
- Configuration of Early watch alerts.
- Analyzing early watch reports & inform client.
- Downloading Support pack stacks & SAP software from Maintenance optimizer.
- Capturing Installation / Migration key from SMSY.
- Alert configuration for Satellite systems.
Confidential
Environment: ECC 5.0/6.0, SAP NetWeaver 7, Sybase, Windows 2008/Linux
SAP BASIS Consultant
Responsibilities:
- Monitoring and preparing reports using Daily and monthly monitoring metrics.
- Database monitoring, Tablespace reorganization, Performance tuning, Backup and recovery of Oracle Database.
- Configuring TMS and integrating all systems into transport domain.
- Managing profile parameters, Buffer management and fine tuning SWAPS, Database Monitoring for analyzing Database performance, Waving and extending table spaces.
- ABAP Dump analysis, Updates termination, Lock entries, System Logs, users Overview and global user monitor, Logon load balancing and configuring load balancing, processes overview, servers & instances, load balancing.
- Spool & printing management & troubleshooting include installation of printer, solving user printing problem.
Confidential
Environment: ECC 5.0/6.0, SAP NetWeaver 2004s, Oracle 9.2/10.2, Windows 2008/Linux SLES
BASIS Technical Architect
Responsibilities:
- Homogeneous System Copy, Rename or Refresh environment, the stages are Prep, Refresh and Post Refresh.
- Applying hot packages, Kernel Upgrades and SPAM updates.
- Online read write reorganizations of Table and Indexes with new dimension tool DBI’s BROTHER WOLF.
- SAP client copy, client export and client import depends on business requirement.
- Checking Dump Analysis, Updates, Lock entries, System Logs, Users Overview, Services & instances, Load Balancing, Operation Modes, Table space administration.
- Performance Monitoring and Tuning for checking alerts with respect of threshold values. Database monitor for analyzing performance, extending table spaces.
- DB Administration like starting and shutting down the database, managing table space administration, managing database objects reorganization, DBA Jobs administration.
- Configuring Printers at operating system level and in SAP level. Configuring printers in R/3 to facilitate local printing.
Confidential
Environment: ECC 5.0, SAP NetWeaver 2004s, Oracle 9.2/10.2, IBM AIX 2.5
SAP System Administrator
Responsibilities:
- Daily system monitoring.
- Performed kernel upgrades.
- Planned and performed Support Package up gradation.
- Performed Database refresh as per customer's requirement.
- Performed Client copy.
- OSS Note implementation using SNOTE and manual implementation.
- Trouble Shooting the End Users queries and communicating with them directly for further complications.
- Creating printers in SAP, defining printer queue at AIX level and monitoring.
- Day-to-day issues.
- Tablespace administration using BRTools.
- Reorg tables with BRTOOLS.
- Background Job monitoring.
- Transports Management.
- RFC connection Issues.
- Monitoring file system's growth.
- Used to handle customer messages by providing necessary logon data, opened the connection to SAP.
Confidential
Environment: SAP R/3 4.6C, SAP R/3 4.7, APO, and BW 3.0, Oracle 8.1.7 to 9.2.0 UNIX (Linux, AIX, Sun), Windows Server 2003
SAP Basis Administrator
Responsibilities:
- Installation of IDES SAP R/3 4.7 on Windows2000/2003 Oracle9i.
- Installation R/3 Central Instance and Application Servers on Windows 2003/Oracle.
- Installation of SAP GUI and ITS.
- Installation of Solution Manager3.2 Creation of solution landscape adding systems to landscape.
- Setting up STMS for the System Landscape. Configuring transport groups.
- Configuring OP modes for different Work Loads.
- Configuring logon load balancing between application servers.
- Monitoring all customer systems using Remote Observe Monitor (ROM).
- Analyzing the system Errors & applying support patches.
- OSS Notes - Checking for all the Pre-requisites and applying the OSS Notes.
- Kernel Upgrade.
- Performance Tuning in SAP.
- Performed Homogeneous System copy of Production system to build the Quality assurance system.
- Maintaining Client strategy (Client Copy/Export/Delete) as per the system landscape.
- Shutdown and Start of SAP R/3 and new dimension products for maintenance.
- Tablespace administration using SAPDBA and BRTOOLS.
- Re-organize Tablespaces with datafiles USING SAPDBA.
- Opening the OSS connection for SAP System.
- Raising the OSS Customer Message and given the feedback to the customer and to the SAP.
- Opening & Closing the SAP System.
- Doing the Transport using the customizing tool & SAP Standard.
- Daily Health Check Monitoring of all systems in Landscape.
- Configured Central User Administration.
- Performed an annual audit of SAP R/3 user accounts & authorizations.
- System (License) Measurement of all Systems in the Landscape.
- Security Audit Log of the system as per Audit Recommendation.
- Management of Emergency Users.
- Creation of new OSS Users, Assignment of developer key.
- Checking the inactive user weekly.
Confidential
Associate Consultant (SAP Basis)
Environnent: SAP R/3 4.7, 4.6CDuration: 2 Months
Responsibilities:
- Communication between Siemens India and SBS Germany.
- Escalation Hierarchy, Defining the responsibilities for the team.
- Technical knowledge transfers for handling the system from offshore.
- Configuring the New system Line with the Customized Central User Administration.
- Creating New Roles according to the needs of the customer requirement.
- Meeting with the customers Every Week for discussing about the Project Details.
Confidential
Database Administrator
Environnent: Windows Server NT/2003 & Oracle 8i, 9i
Responsibilities:
- Monitoring & maintaining the production databases.
- Allocating system storage & planning future storage requirements for the database system.
- Creating primary database storage structures (tablespaces).
- Modifying the database structure as required.
- Enrolling users and maintaining system security.
- Controlling and monitoring user access to the database.
- Monitoring and optimizing the performance of the database.
- Database Backup and Recovery using backup (tablespaces) and logical backup (export).
- Managing the online Redo logs.
- Managing Control files, data files & schema objects.