VARUN MALLELA
SAP Basis - NetWeaver Administrator
Email: abmkhd@r.postjobfree.com
Cell: 862 - 368 - 2935
SUMMARY
. Over 3+ years of IT experience of which 3 years of SAP Basis
Administration with extensive expertise in all SAP NetWeaver
Components.
. SAP NetWeaver products implementation: Excellent experience and
understanding of NetWeaver 2004s (7.0)/2004, EP 7.0/6.0, PI/XI
7.0/3.0, BI 7.0, BW 3.5 and NWDI/Adobe Document Server (ADS).
. SAP New Dimensional products implementation: Experience with
installation and maintenance My SAP Business suite 2005/2004, ECC
6.0/5.0, WAS 7.00/6.40, CRM 5.0/4.0, SRM (EBP) 5.0, SAP R/3 4.7 EE
SR1, SAP R/3 4.6 B/C, Solution Manager 4.0 Installation,
Administration and Upgradation.
. Involved in 2 complete full Life cycle implementations of ERP, Quick
Sizing and ASAP methodology.
. Expertise in SAP Basis administration including Client Administration,
Change Request Management, Transport Management System (STMS), User
Administration, Upgradation, Applying Support Packages on both ABAP
and Java Engines. Memory management and Parameter adjustments for
Database, Operating Systems, SAP application servers, SAP applications
(SQL statement, Programs). Trouble shooting System problems,
Performance tuning, Workload Analysis, Database Administration.
SAP BASIS SKILLS
. Business Intelligence (BI): Added BI Content on NetWeaver ABAP stack.
Performed Installation and Post installation activities on BI 7.0.
Configured UD Connect for external databases, JDBC connectivity. BI
System administration tasks include System Refreshes, Support,
Creating source systems, BI Performance tuning, Data loading and
security issues.
. Exchange Infrastructure (XI): Installed, configured SAP PI 7.0 with
J2EE Add-in on HP-UX and Oracle 10g. Installed configured Business
systems in SLD (System Landscape Directory). Integration Engine
Administration, troubleshooting Adapter configuration. Administration
and configuration activities in Integration Repository, Integration
Directory and Runtime workbench. Defined ports and IDOC metadata
Adapters in XI System. Migrated Java developments, Repository objects
in system landscape.
. SCM/APO: LiveCache administration, LiveCache and Database Manager
Monitoring in APO System. Monitoring qRFC Queue, Data channel monitor,
Alert monitoring in SCM/APO systems.
. SAP J2EE Engine: Installation, Adding additional Java Server
Processes, Administration, Startup profiles and startup problems,
Applying support patches to Java engine using (SDM, SAINT and JSPM).
Maintained java parameters, created RFC connections, added java server
processes using Configtool and Visual Administrator.
. Solution Manager (SM): Installed and managed SAP SOLMAN for System
Landscape. Configured and Generated Early Watch Alert Reports for all
Production systems in the Landscape. Generated Installation key,
Defined and configured Satellite Systems. Created Solutions and
monitored messages and alerts. Downloaded support packages using
Maintenance Optimizer for all systems in the Landscape.
. Upgrades: Performed various upgrades from SAP R/3 4.6 C to ECC 6.0 and
SAP BW 3.5 to BI 7.0. Involved in proof of concept (POC) for CRM 2007
upgrade on Oracle database. Unicode conversion.
. Support Packages: Downloaded current support packages from Service
market place using Maintenance Optimizer by Solution Manager 4.0.
Applied support packs, SAP Notes on SAP Systems (ABAP, JAVA) and BW
systems. Updated SPAM/SAINT Versions. Applied Add-ons. Performed
Kernel Upgradation.
. Daily Monitoring Activities: Defined and monitored Background jobs,
Updates and maintained Spool queue. Scheduled SAP housekeeping jobs.
. Performance Tuning: Research ABAP performance problems and advise
developers on code optimizations including SQL and index
recommendations.
. Database Administration - Performed Oracle DBA functions including
Tablespace management, Oracle performance problem resolution, REORGS
when required. Familiar with SAPDBA & BR*TOOLS for Database
Backup/Recovery and Space management. Performed Disaster Recovery (DR)
Exercises..
EDUCATION
Master of Science in Computer Science, Governors State University, Chicago,
USA
AUG 2006 - DEC 2007
Bachelor of Technology in Computer Science Engineering, Kakatiya
University, Warangal, INDIA
JUN 2001 - MAY
2005
TECHNICAL SKILLS
ERP : My SAP Business suite 2005/2004, SAP NetWeaver 2004s/04, ECC
7.0/6.0, BI 7.0, BW 3.5, CRM 5.0/4.0, XI 3.0, EP
7.0/6.0, SRM (EBP) 5.0, SCM 5.0 and Live Cache.
Ticketing tools : Peregrine, Star team 2006, Control -M, HP Open view.
Backup Tools : Veritas, Netback up,
Functional Modules : HR (Payroll, Benefits), SD, MM, FI/CO
Operating Systems : HP UX, UNIX, Red Hat LINUX, IBM AIX, SUN SOLARIS
WINDOWS NT/2003.
Languages : C, C++, JAVA, ABAP.
Databases : Oracle 8i/9i/10g, MS SQL Server 2005.
PROFESSIONAL EXPERIENCE
Employer: US Software Corporation, Downers Grove, IL
DEC 2007 - Till Date
Client 1:
Prudential Financial Retirement, Iselin, NJ
MAY 2009 - Till Date
Environment: SAP ECC 6.0, SAP NetWeaver 2004s, EP 7.0 EHP1, Supplier portal
7.0, BI 7.0, SRM 7.0, Solution Manager 7.0, Oracle 10g, HP-Unix
SAP Basis - NetWeaver Consultant
Responsibilities:
. Performed System builds for ECC 6.0, BI 7.0, EP 7.0 systems. Configured
System Landscape Directory.
< Configured and Generated Early Watch Alert Reports for all Production
systems in the Landscape. Analyzed and Submitted EWA reports to
management on weekly basis. Configured solutions and systems in
Solution Manager 4.0.
< Performed installation of EP 6.0 and Upgradation to SP14. Configured
Single Sign on (SSO) between Portal and SAP BW and other Systems in
the Landscape. Defined Portal Authorization and User Management Engine
(UME).
< Performed NetWeaver 2004s BI and EP 7.0 Portal Integration. Setting up
BEx Web Applications in Portal.
< Extensively worked in change request management SE01, SE09 and SE10.
Performed ABAP Transports in ABAP systems through entire landscape,
Migrated XI Java codes and Enterprise Portal transports.
< Maintained java parameters, administered J2EE Engine using Configtool
and Visual Administrator.
< Performed Alert configuration, Support desk configurations in solution
manager 4.0.
< Setup SSL communications between SAP system and LDAP servers.
< Resolved critical portal related issues during Release 3 Project and
involved in cutover activities.
< Maintained java parameters, administered J2EE Engine using Configtool
and Visual Administrator.
< Applied java support patches to J2EE engine using SDM, JSPM tools.
Upgraded JDK version.
< Applied ABAP support patches on SAP R/3 4.7EE, BI 7.0 and SRM 4.0
systems during Production cutover
< Upgraded Kernel, SDM and JSPM. Applied support packages through Java
Support Package manger (JSPM) and SDM. Worked in co-ordination with
Development team to resolve SPDD and SPAU phases while applying
patches.
< Administered Integration Engine Configuration Data using SXMB_ADM
transaction in PI 7.0 systems
< Monitored XML Message failures production XI system using transaction
SXMB_MONI and trouble shooting errors. Also checking Integration
engine and System landscape directory availabilities using SLDCHECK
and SXMB_IFR transactions
. Created and Maintained Logon groups, Batch Server Groups in ECC 6.0, SRM
5.0, BI 7.0 Systems
. Involved in troubleshooting RFC connection issues between SAP ABAP and
JAVA Engines.
< Performance Tuning at R/3 System level, Database level and OS-level
using ST02, ST03,STAD,ST04, DB02,ST06 and checked for system logs
using SM21 and ST11
< Monitoring SM51, SM59, AL08, SM12, SM13, DB01, DB02, DB14, DB24, ST22
and Disk space monitoring and taking appropriate actions
Client 2:
Process Weaver, Fremont, CA APR 2008 -
MAY 2009
Environment: SAP ECC 6.0, SAP NetWeaver 2004s, BI 7.0, SRM 5.0, SM 4.0, EP
7.0, Oracle 10.2, IBM-AIX
SAP Basis - NetWeaver Consultant
Responsibilities:
. Performed Unicode conversion and Upgrade from SAP R/3 4.6 C to ECC 6.0
for entire system landscape.
. Performed upgrade of SAP BW 3.5 to BI 7.0 on Oracle database.
. Involved in Non Unicode to Unicode conversion of SAP R/3 4.6 C on
oracle database.
. Installed and Administered SCM/APO 5.0 system. Administered both
SCM/APO & LiveCache Databases.
. Performed installation of NetWeaver 2004s, ABAP and JAVA stacks and
applied Support packages.
. Installation of the sandbox environment with NW2004's BW7/Oracle10g
SAP NetWeaver BI.
. Gathered all necessary OSS Notes and Support packs from the service
market place for the upgrade process. Worked in both Resource-
minimized and Down-time minimized upgrades.
. My tasks included preparing (resize the database and run the prepare
utility) the source system for the upgrade, running the upgrade phases
using the Upgrade Assistant.
. Performed Homogeneous System copies and DB Refreshes during the
Upgrade process.
. Analyze and resolved several errors during upgrade phases and prepared
a document. Perform post-upgrade activities.
. Created Portal content and maintained connectivity between EP 7.0 and
SAP backend systems and implemented Single Sign on (SSO). Migrated
Portal transports in system landscape.
. Generated installation key for all upgrades using Solution Manager in
SMSY.
. Performed daily health checks, Memory and Buffer monitoring to ensure
Optimal Performance from the SAP system. Carried out day-to-day
administration and daily monitoring of SAP systems.
. Worked with team SAP Basis team members and Business analysts to
resolve technical issues during process of data migration, data
cleansing and storage.
. Responsible for providing support to all development and production
environments for the SAP system including SAP ECC 6.0, BI 7.0, CRM 4.0
and various server components.
. Tuned R/3 buffers, database buffers and shared memory parameters with
CCMS reports.
. Maintaining table space management administration using BACKUP
RECOVERY tools.
. Checking Database growth, Archive directory and adding data files or
resizing the table space size.
Client 3:
Hallmark, Kansas City, MO
JAN 2008 - APR 2008
Environment: SAP ECC 6.0, SAP NetWeaver 2004s, BI 7.0/BW 3.5, SCM/APO 5.0,
EP 7.0, Oracle 10g, HP-UX.
SAP Basis - Net Weaver Consultant
Responsibilities:
. Taken up this short project to back fill a resource for Project
Horizon at Hallmark international Inc.
. Worked in Data transfers issues in BI 7.0, helped developers in fixing
the Data load issues.
. Performed Source system creations and Source system Restores in BI 7.0
system.
. Created Portal content and maintained connectivity between EP 7.0 and
SAP backend systems and implemented Single Sign on (SSO). Migrated
Portal transports in system landscape.
. Administered and monitored stand alone Java Engine (EP7.0) using
Monitoring services of Visual Administrator.
. Performed error analysis is resolving IBM Data stage issues.
. Involved in resolving BI transports and Open Hub related issues
Client 4:
Adani Exports, Ahmadabad, INDIA
JUNE 2005 - MAY 2006
Environment: SAP R/3 4.7 EE, WIN 2003
SAP Database Analyst
Roles and Responsibilities:
. My duties involve working on the Software as Data interpreter,
analyzing the data, finding the utilization factors of teams and
individuals and promptly checking the mail volumes.
. Performs Duty Observations a day in a week to guide the keyers to
change the MDEC of all teams promptly to maintain the mail volumes.
. Defined and Configured Satellite Systems in Solution Manager 4.0.
Created solutions and monitored the alerts & messages from the
configured Satellite systems. Configured and monitored Service Desk.
. Participates in Work time learning to discuss new updates in the
Software.
. Prepares the Team Activity Report daily.
. Developed excellent international and communication skills working
in teams.
. Developed professional working environment experience.
. Setting up & configuring RFC connections between R/3 & BIW systems.
. Monitoring, Administration of Java Engine using Config Tool and Visual
Administrator.
. Performed Load and Performance Testing in Quality Assurance Box.
. Created clients and defined settings. Performed client copies like
local client copy, remote client copy.
. Performed daily administrative activities such as Alert monitoring,
Scheduling periodic jobs, Background processing, User management, R/3
Buffer monitoring (CCMS), database monitoring, Verification,
troubleshooting of Short Dumps, system logs etc.
. Creating users and assigning the roles depending on work and restricts
the user access.
. Configuring the printers for network and also for standalone systems.
. Administered Users and Groups with all permissions as well as trusted
relation ships between domains that are between Windows NT/98.