Chakradhar C Reddy
*******@*****.***
Summary
. Experienced Senior SAP BASIS administrator on Unix and Windows NT
environments with databases Oracle, UDB DB2 and SQL Server 2008, 2005
with Shell scripting on all flavor's of Unix.
. All Upgrades are performed for projects taken up by SAP AMERICA,
ACCENTURE, FUJITSU and SIEMENS.
. Experience in Pharmaceuticals, Utility industry with components IS-U/CCS,
FERC, Public sector management, Retail and chemical industries.
. Combined Upgrade & Unicode Conversion in a cluster environment from 4.6C
to ECC 6.0 Including Enhancement Package 4 support release 1 for ABAP.
This is for IS-U and IS-CCS/FERC and Funds management and PSM (Public
Sector management) in Navajo Tribal Utility Authority(Siemens). Export &
import is implemented in parallel using distribution monitor with
Multiple servers.
. Data migration/import is executed using Distribution Manager with table
split and package split options for cutting down the downtime.
. Installation & configuration and Setup of BSI tax on SQL server 2008.
. Implementation, Installation and integration of Enterprise portal with
backend systems, ABAP systems, BI and CRM. Setting up of Single-sign-on
with abap and java systems.
. Installed Netweaver 04s SR2 system by selecting JAVA with usages type EP,
EP CORE, BI_JAVA..
. Portal installation and NDWI and ESS/MSS configuration and SSO setup.
Performed post installation activities like License Adapter, Memory
Configuration using Config Tool, JVM Parameters, Creating two Admin
Users, Assiginig UME Roles, SLD Data Supplier Service, http service.
. Defined WebDynpro Connections to BW and CRM Systems. Defined checklists
to monitor the Portal and Fine Tuning the Expensive Iviews and Portal
Components. Designed Portal Desktop, Logos and banners etc. Worked with
all Tools of Netweaver.
. Installation & configuration of Solution manager 4.0 with Service desk,
early watch alert set up for R/3 systems.
. Setup of maintenance Optimizer for downloading the support packages and
EHP's and SLD configuration.
. BO-BI integration and SLD set up for the systems in landscape.
. New Implementation of SAP ECC6.0 with SQL server and Solution manager for
USEC (Honeywell)-- Confidential
. Unicode Conversion of MDMP system with SAP 4.7 ext 2.0 and basis package
level 59 on Sun solaris system and oracle database for Boston scientific,
Boston,MA - Accenture, and Export & import is implemented in parallel
using distribution monitor.
. Combined Upgrade & Unicode Conversion of MDMP system with 4.7 on AIX
system with oracle database for Honeywell, tempe, Arizona- Fujitsu.
. Combined Upgrade & Unicode conversion on HCM system with 4.7 WAS6.20 with
SP61 on HP-PARISC to ECC6.0 to Itanium Machine for Wyeth
Pharamceuticals,Malvern,PA -- Fujitsu
. Unicode conversion of Single code page on ECC 5.0 with WAS6.40 with Basis
SP14 for Wyeth Pharamceuticals,Malvern,PA - Fujitsu. Export & import is
implemented in parallel using distribution monitor.
. Unicode conversion of Single code page on SRM NW 7.0 with Basis SP 11 for
Wyeth Pharamceuticals,Malvern,PA - Fujitsu and Export & import is
implemented in parallel using distribution monitor.
. Plan, design and setting up of Microsoft cluster service for windows
environment..
. Upgrade from SAP 4.6C to ECC 6.0 for Cadbury-schewepps, plano,Tx - SAP
America. Defining upgrade strategy, backup strategy, initial hardware
sizing, planning the system landscape.
. Cloning Oracle 10.2.0.2 and oracle upgrade from 9.2.0.7 to 10.2.0.2.
. BIW Upgrade from 3.5 to BI7.0 with Unicode and java.
. Installation of Enhancement package II with level II.
. Set-up, Install and Administration of SCM/APO 4.0 and Livecache.
Integration with ECC6.0
. Hands on experience in migration from SAP 4.6C to ECC 5.0.
. Install Versa fire fighter and configure.
. Enterprise Portal 6.0 Installation, Configuration and Troubleshooting the
Java components.
. Install, set-up and configure SAP solution manager 3.2.
. Configure & set up of VERTEX, IXOS and UC4 scheduler.
. Setup of SAP Router, STMS configuration, slicense, Sap message creation,
registering users at SAP market place and Analysis of ST03, ST04 and
ST06, set up of day light saving time using report TZCUSThelp. Security
concept in SAP R/3 with Authorizations using automatic profile generator,
Central User Administration (CUA), Profile maintenance, Database
Monitoring, System Monitoring, Applying OSS Notes, SPAM/SAINT Updates,
Plug-ins, Various Support packs, etc. in SAP R/3 (Enterprise
ECC6.0/ECC5.0/4.7/4.6C).
. Performance Tuning and Monitoring of SAP servers by using some t-codes
like SM51, SM50, SM12, DB01, ST03, ST22, SM21, DB02 and some other
related codes and procedures if needed, ST05 Trace.
. Scheduling (time and event-triggering)and monitoring the applications.
Creation of operation codes, switching of operation codes for manual
testing and defining events etc with the use of relevant transaction
codes like SM36/SM37/SM62/SM61/SM69/SM64 and parameters related to this
task.
. Experience in implementing SAP security, including activity groups,
profile generator, central user administration and structural
authorizations.
. Extensive experience in design/layout of partition database on operating
systems AIX and Linux UDB DB2 versions V5.x/6.x/ EEE 7.1 and ESE 8.x on
AIX.
. Very strong UDB DB2 EE/EEE(DPF)experience on versions V5.x/6.x/ EEE(DPF)
7.1 on AIX, which includes design/layout of partition database,
configuring,db2nodes.cfg,creating,logical/physical partitions, offline,
online incremental/delta backup of database. Routine maintenance tasks
like running reorg checks/reorgs/runstats/snapshots/db2explains etc of
UDB and use of db2look, db2move and db2advise utilities.
. Hands on experience as an Oracle DBA with SAP on Oracle 10.2.0.2.
.
Technical:
Database & Operating Systems
UDB DB2 on AIX with 256 Logical partitions, 8 application nodes and 2
TSM nodes.
Oracle on AIX and HP-PARISC/HP-Itanium / HP-Itanium
Oracle on Sun Solaris and Windows
SQL server on Windows 2000, 2005 and 2008.
Educational Summary:
. MS in Computer Science and Networking. - University of Missouri at
Kansas city.
. BS in Production Engineering.
Training:
. SAP Basis Administration.
. UDB DBA training with IBM.
. MQ series Administration.
Status :
US Citizen
Professional Summary
Client : Navajo Tribal Utility Authority.
Aug 2009 - current
Implementing Partner : SIEMENS
Location : Fort Defience, AZ
Operating system : Windows 2008
Migration tools : Distribution Monitor
Database : SQL SERVER 2005 and 2008 on a cluster /
Virtualization using VMware on Netapps filler01 and
netapps filler02.
This is a Utility distribution corporation primarily distributing the power
and water & sewage in Navajo reservation area. The source system is SAP
R/3 4.6C with IS - Utility, FERC and IS-CCS and Public Sector management
components implemented. This has been upgraded to SAP ERP 6.0 Including
Enhancement package 4 for NW 7.0 support release 1 for ABAP.
I am the sole in-charge from hardware specification, Upgrade and Unicode
conversion of 4.6C system and setting up of Distribution monitor using 2
servers for Export and import of data into target system with Unicode
kernel.
Upgrade & migration key generation, installation of license, sap online
documentation and enabling RFC connections based on Target system
(Unicode/non-unicode) and Tasks included are User-role matrix creation and
implementation and maintenance of new and changed roles to suit the client
needs. Installtion & Setting up of BSI Tax software and integration with
ECC 6.0 System.
Upgrade is performed on a stand alone server with sid change and imported
into Cluster environment with Active - Active servers and also imported
into virtualization server.
Upgrade is also performed on a standalone system for system identification
change(SID) and imported into Unicode kernel system on Virtualization
system.
Client : Willsys info systems Dec 2009 -
June 2009
Operating system :Windows 2003
Database : SQL Server 2005
As a team member Planned, designed and Implemented Enterprise Portal 6.0 on
SQL Server. Installed Netweaver 04s SR2 system by selecting JAVA with
usages type EP, EP CORE, BI_JAVA.. Performed post installation activities
like License Adapter, Memory Configuration using Config Tool, JVM
Parameters, Creating two Admin Users, Assiginig UME Roles, SLD Data
Supplier Service, http service.
. Deployed ESS & MSS and established Connectivity to backend systems.
Established SSO with Backend Systems. Defined WebDynpro Connections to
BW and CRM Systems. Defined checklists to monitor the Portal and Fine
Tuning the Expensive Iviews and Portal Components. Designed Portal
Desktop, Logos and banners etc. Worked with all Tools of Netweaver.
. Designed IVIEWS, Pages, Roles, Work Sets and Customized Portal as per
the Customer requirements. Deployed ESS and MSS using JSPM and Define
the WebDynpro connections and Systems Aliases.
. Defined Portal Desktop for the Users like Portal Themes Using Theme
Editor.
. User Management by creating Users and groups and assigned roles to
them.
. Configuring Single Sign On by exporting and importing certificates
(Logon ticket Methods).
. Configured SSO and connecting to the backend systems and uploaded
roles from backend systems to EP.
. Created JCO RFC Connections between EP and other ABAP based SAP
Systems.
. Monitoring Portal and Knowledge Management in System Administration.
. Monitoring Locked Objects, Thread Overview in Monitoring.
. Monitoring the performance of Iviews and Pages.
. Deployed Best practices and Business Packages (BP_ESS and BP_MSS and
PCUI) and roles to users.
. Creating Iviews, Pages, work sets and roles by using copy/delta link
method.
. Activating Collaboration Launch Pad (CLP) and Real time collaboration
(RTC) to Collaborate Between Groups, Users and Teams.
. Uploaded various documents, Publish NEWS, Quick Poll, Rooms and
Defined Room Categories etc.
Integration:
. ESS/MSS configurations with HR system.
. BI and CRM integration with EP.
. Installed BI7.0 System along with Bo-XI Integrator, Crystal Reports
2008, BO Enterprise, XCelsius 2008, Java Connector 2.18, and Imported
BI Content and applied Support Packages up to 18 Level.
. Installation and Configuration of Solution Manager (Service Level
Reporting, Service Desk, MOPZ, System Monitoring and Administration).
MSCS set up:
Design and implementation and testing of Microsoft cluster service for
windows environment.
CRM installation and integration with EP 7.0 . installation of snotes and
other required sap notes.
Client : USEC / HTSI Oct 2008 - Nov
2008
Implementing Partner : Fujitsu
Location : Piketon, OH
Operating system :Windows 2000/2003
Database : SQL Server 2005
Client details : Confidential
This is an Implementation project for Department of Energy implemented by
HTSI (Honeywell subsidiary). Primary responsibilities includes Basis role
and Security role like which contributes Routine Implementation tasks of
Infrastructure architecture, Landscape Strategy, Client Transport
methodology and Backup strategy. Involved with Installation of SAP ERP 6.0
with SR3, post-installation tasks, sap online documentation and creation of
multiple clients and client copies also Import of Pre-configured
customization transports into the newly created clients in sand box client
and gold clients. Also implemented security roles excluding basis functions
to the functional users.
Client : Boston Scientific Aug 2008 - Sep
2008
Implementing Partner : Accenture
Location : Natik, Boston, MA
Operating system :SUN solaris 8 and Target SUN solaris 10
Migration tools :Distribution Monitor
Database : Oracle 10.2.0.2
This is a Unity project pahse II with MDMP Unicode conversion consisting of
code pages 1100 and 8000(JA) on SAP 4.7 ext 2.0 with SAP basis package
level 59. Responsibilites includes, all MDMP Unicode steps
preparation,conversion cut-over plan, pre-conversion (SPUMG scans), pre-
export and post Unicode conversion (SUMG), setting up distribution monitor,
transports, changing profiles, enabling RFC's for Unicode compatible.
Vocabulary (SPUMG and SUMG) assignment is partly done by me based on Sap
notes 756534 and 756535 by using Import method, and the rest is assigned by
native language speakers .
Client : Honeywell June 2008 - July 2008
Implementing Partner : Fujitsu
Location : Pheonix, AZ
Operating system : AIX 5.0
Migration tools :SNP Client -- Germany
Database : Oracle 10.2.0.2
This is an Upgrade and MDMP Unicode conversion consisting of different
code pages on SAP 4.7 ext 2.0 with SAP basis package level 62 to ECC 6.0
.Responsibilites include, all Upgrade and Unicode steps, transports,
changing profiles, enabling RFC's for Unicode compatible. Vocabulary (SPUMG
and SUMG) assignment is taken care of by native language speakers after I
imported the SAP provided vocabulary files.
Client : Wyeth Pharmaceuticals Jan 2008 -
June 2008
Implementing Partner : Fujitsu Consulting Inc.
Location : Malvern, PA
Operating system : HP-Unix 11.23
Database : Oracle 9.2.7.0 --- 10.2.0.2
Hardware : HP-PARISC and HP_Itanium.
Project: HCM System Combined Upgrade & Unicode conversion &
Pilot projects for Unicode conversion for bidding purpose.
Client is upgrading their HR (HCM) SAP R/3 system from 4.7 Ext 2.0 (SP61)
to ECC 6.0 with Unicode conversion of single code page system. It is a
technical upgrade of HCM system from 4.7 to ECC 6.0 using combined upgrade
& Unicode conversion with resource minimized strategy.
Upgrade is done On HP-PARISC HP-UX 11.23 server and ECC6.0 installation and
system copy (Import is done on to HP- Itanium M/c). My responsibility is to
upgrade the 4.7 system and Unicode preparation, pre-conversion and pre-
export conversion phases are carried out on HP-PARISC i.e UCCHECK,
RSREFILL, UMG_ADD_PREP_STEP, SMLT and SPUMG etc.
Install Oracle 10.2.02 on HP-Itanium, Install Unicode ECC 6.0 on HP-
Itanium, Using system copy with R3Load is imported into Ecc6.0 on HP-
Itanium. Use of distribution Monitor to run parallel export/import on pa-
risc and itanium servers. Other tasks involved are: Confirming the SMLT.
Post-conversion activities, Post-installation steps, Re-configure of RFC's,
Install of sap license.
Tuning default and instance profile parameters etc.
Combined Upgrade & Unicode conversion of HCM system with 4.7 on HP_PARISC
to ECC 6.0 SP11 on HP-Itanium.
Highlights of this project are Execution of prepare and pre-conversion
steps of Unicode conversion while executing the Prepare step of Upgrade and
use of Distribution Monitor for R3load export/import of the data using
table/package split for top 20 tables based on DB02 and Oracle upgrade from
9.2.0.7 to 10.2.0.2.
Unicode conversion of ECC 5.0 was 6.40 and Basis SP14. (PILOT)
This is only a Unicode conversion of Non-Unicode ECC 5.0 was 6.40 and SP 14
to ECC 5.0 was 6.40 with SP14 Unicode kernel. Highlights are, as the
support pack is at very lower level, I had to apply snotes and build some
reports manually, which will run as part of UMG_ADD_PREP_STEP.
Unicode conversion of BI NW 7.0 and Basis SP15. (PILOT)
This is only a Unicode conversion of Non-Unicode BI 7.0 and SP 11 to SRM NW
7.0 with SP11 and Unicode kernel. Since this is a NW 7.0 kernel, most of
the reports are in-built and run as part of UMG_ADD_PREP_STEP.
Distribution monitor is used to
Reduce the export times using 4 servers.
Unicode conversion of SRM NW 7.0 and Basis SP11. (PILOT)
This is only a Unicode conversion of Non-Unicode SRM NW7.0 and SP 11 to SRM
NW 7.0 with SP11 and Unicode kernel. Since this is a NW 7.0 kernel, most of
the reports are in-built and run as part of UMG_ADD_PREP_STEP.
Distribution monitor is used to
Reduce the export times using 4 servers.
Cadbury Schweppes: July 2007 - Dec 2008
Plano, Dallas, TX
Implementation Partner: SAP AMERICA
SAP Basis Consultant (UPGRADE).
Project: DPSU Probe( Dr. Pepper & 7Up Probe.
. This project is R/3 Technical Upgrade of Non-Unicode from 4.6C to ECC
6.0 and is implemented by SAP AMERICA for client CADBURY Schweppes.
. Upgrade of SAP R/3 4.6C to ECC 6.00 SR2 on AIX with Oracle 10.2.0.2
Database.
. DPSU Probe is a 3 System landscape with Dev/Qas/Prod(SM2/SQ2/SP2) at 4.6C
on AIX Operating System in a HA cluster environment with Oracle
database at 10.2.0.2 of size 2.3 TB.
. Built similar landscape at SAP Hosted environment with development and
quality with 4.6C by System copy and then upgraded to ECC 6.0 at Hosted
environment without interruption to the client's landscape systems.
. File system copy of Cadbury SM2 and restore on Hosted environment with
4.6C, changing control file, profiles and environment files to change the
SID from SM2 to SD2.
. Upgraded to ECC 6.0 on SD2, SI2, ST1, ST2 and SP2 with 4 application
servers from 4.6C to ECC 6.0.
. Configured TMS between SD2, SI2 and a virtual Production system and
performed transport administration and software change management.
. Configured STMP mail distribution to mail server, background jobs and
spool system.
. Install VIRSA fire fighter for compliance calibrator.
. Configuration of Spool devices through stream server and direct printing.
. Enable RFC/TCP/IP connections to all external interfaces, BW/APO/CRM/HR,
MQ series, Mail server, spool server(stream serve), UC4 for scheduling
the jobs, IXOS, Vertax, Janpack and IDOCs.
. Configuration of Revtrac for transport mechanism.
. User maintainance, creation, roles creation etc.
. Configuration of System Landscape in Solution Manager 4.0 to get SAP
Solution Manager Key for Upgrading SAP ECC 6.0 SR2.
. Applied all Support Packages two levels below the market place for all
components of ECC 6.0.
. Upgrade of SAP R/3 4.6C to ECC6.0. Analysed the Upana.htm to concentrate
on the time consuming phases of Upgrade process.
. Configuring/installing the additional application servers for ABAP and
JAVA systems.
. Configured STMP mail distribution to mail server, background jobs and
spool system.
. Configured Application server load balancing and operation modes.
. Creating RFC's and ALE between SAP Application servers and Administration
of RFC's.
. Installed and configured SAPROUTER, scheduling the go-live check,
configuring the Early watch report and tuning the system as per the SAP
Support recommendations and EWA.
. Tablespace administration - Monitoring landscape directory.
. Installed Live compare tool to compare the difference between 4.6C and
ECC 6.0.
SCM/APO Separation Project
. Cut-over Planning for basis activities in Dev, QA, Prod.
. Installation and System-Copy of the existing landscape to build a
separate landscape.
. Set-up RevTrac tool for Transports
. Integrate the system with UC4 master for job-scheduling.
. Supporting the Functional team.
. Livecache Administration and SAP Basis Administration of SCM4.0.
. Supporting the servers for production issues after Go-Live.
. Performance Monitoring and Tuning of Livecache, SAP, and database
parameters.
General Chemical March 2006 - May 2007
Parsippany, NJ
SAP Basis Consultant.
Responsibilities:
. Upgrade of SAP R/3 4.6c to ECC 6.00 SR1 on AIX with Database as DB6
Fix pack 10.
. Upgrade of 3 Application Servers in the Production System using SAPUP
and applied the New Kernel 7.0.
. Upgrade of Solution Manager 3.2 to 4.0 on Database as DB6.
. Instalation of SCM 4.0 and integration with ECC 6.0 and live cache
administration.
. Performance monitoring of LIVECACHE, data cache, OMS HEAP, User tasks,
CPU etc.
. Configure and Install Business content and ADD-on like FINBasis and
SEM on top of BI.
. Applied Support Packages like BASIS 7, ABAP 7, and APPL 500 & HR 500
on R/3 systems and aligned the Dictionary and Repository Object.
. Configuring/installing the additional application servers for ABAP and
JAVA systems.
. Created the client strategy, and configured the systems with clients
for development, testing, training and production.
. Configured TMS and performed transport administration and software
change management.
. Adding the Application servers based on the workload and administering
the ABAP and J2EE Clusters.
. Implementing Central user administration.
. Implementing/Auditing the security settings in the application servers
and LDAP Directory.
. Configured STMP mail distribution to mail server, background jobs and
spool system.
. Configured Application server load balancing and operation modes.
. Creating RFC's and ALE between SAP Application servers and
Administration of RFC's.
. Performed analysis, troubleshooting and managed the escalation of
basis related issues with SAP support.
. System and Application backup to protect the system from failure.
. Routine proactive monitoring and logging the system health to ensure
the uninterrupted operation of the mission critical and supporting
systems.
. Installed and configured SAPROUTER, scheduling the golive check,
configuring the Early watch report and tuning the system as per the
SAP Support recommendations and EWA.
. Tablespace administration - Monitoring growth, adding data files, I/O
monitoring, reorganizing.
. Planning and implementing the backup strategy for the DB and
Application servers.
. Tuning the database parameters as per the EarlyWatch report and SAP
support recommendations.
. Performing recovery verifications, setting up standby db for DR.
. Installation and Configuration of SAP SRM 5.0 Server.
. Apply support packages on SRM 5.0 SERVER.
. Configure SRM 5.0 Server with Solution manager 4.0 to perform SDCCN
checks.
. Installation and Configuration of SAP PI server.
. Prepared SAP Web AS 7.0 for SAP PI.
. Performed SAP PI Integration Server configuration, Messaging system
properties.
. Configure and activate System landscape directory (SLD) for SAP PI.
. Create Roles and groups in System landscape directory.
. Run Template Installer for Usage type PI for all post-install
activities of SAP & J2EE engine.
. Applied Support packages and performed post installation tasks for SAP
PI.
. Configured HTTPS for J2EE engine.
BI Upgrade from 3.5 to BI7.0 and Brief Description of activities of SAP
BIW :
. To schedule and monitor PSA cleanup, SAP infocube Index Repair, IGS Test
and other Housekeeping Jobs.
. Number Range Buffering.
. Defining Authorization Objects
. Checking the Source System Availability.
. Monitoring and troubleshooting of Process chains.
. Monitor and troubleshoot the Data load activities and improve the
performance of BW Quaries.
. Analysis and repair of BW Objects - Master data to Transactional Data,
Master Data lock checks.
. Repair InfoObjects(RSD1), Analysis and repair of BW Objects - Master
data to Transactional Data ratio(RSRV).
. Troubleshoot Query processing errors and investigate the problem
Area(RSRT) like Query authorization, Network bottlenecks, Bex Gui
issues.
GE Infra structure April 2004 - Feb 2006
Trevose, PA
Betz and Water Technologies
Division of GE infrastructure water & process technologies.
Role : Consultant Basis (Upgrade and Implementation)
Responsibilities:
. Installed and configured Solution Manager 4.0.
. Upgraded the Systems from R/3 4.6C to ECC5.0.
. Installed and configured Net Weaver 2004s SR2 with BI component on Sun
Solaris.
. Installed and configured EP, XI and WAS 6.40 on both ABAP and Java
Stacks and tested successfully in the Sand box environment.
. Performed Client copies.
. Performed DB Refreshes from Production to Quality Server to get the
data in sync with Production System.
. Applied Support Packages and Plug-ins in case of any issues related to
both Technical (SPAU) and Functional Modules (SPDD).
. Configured all the satellite systems to SOLUTION MANAGER with SMSY
transaction so that they can be monitored with a given threshold for
different alerts.
. Monitored database usage, effect sizing and parameter changes in
conjunction with Early Watch alert.
. Installation of Application Servers for both R/3 and BIW systems
(Dialog instances).
. XI base configuration for Profile Parameter settings - Role of
Integration Server.
. HTTP and RFC destinations for XI Setup.
. WAS administration using tools Visual admin, Config tool, User
creation, roles CCMS registration.
. Responsible for monitoring all XI interfaces.
. Installed Maestro 8.x and configured Maestro 8.x.
. Administration of EP/ XI and Java Administration.
. Scheduling and monitoring the applications. Creation of operation
codes, defining events etc. using SM36/SM37/SM62/SM61/SM69/SM64 and
parameters related to this task.
. Applying Patches to Java stack.
. Configured SLD (System landscape directory).
. Installation of PORTALS includes Installed and configured Adapter
frame work.
. Oracle patch set up gradation from 9.2.0.4 to 9.2.0.6.
. working on Solution Manager Upgrade from 3.1 to 4.0 and Netweaver
(ABAP+JAVA) System copy using R3Load and JLoad
GE Fanuc May 2003 - March 2004
Charlottesville, Virginia, USA
Role : Basis Consultant
Environment : Oracle 9i, Sun Solaris, 4.6c
Responsibilities:
. Trouble shooting and configuring Printers and Fax like set up the printer
device, format type, and page sizes. Also maintaining Print Servers Using
third party tool like Columbus OM Explorer.
. Handling the tickets Using Clarify tool and Interact with Core users/End
users to provide the necessary technical support for resolving problems
like User's authorization, logon problems (SAPGUI issues) and other
issues related to users.
. Working on different responsibilities of system administration like
creation of users and assigning roles according to module (Cloning
Method).
. Perform daily and weekly transports from CON, QAS and GEB in Support
Central.
. Scheduling and Monitoring the Background Jobs both at SAP Level and also
at OS level using third party tool like Maestro.
. Monitoring Database growth/size of table space and check for Space
critical objects, Exclusive lock waits.
. Effectively use the SAP OSS and Service Market Place system to resolve
complex productive issues.
. Proactively monitor and take necessary corrective actions for the
Landscape by doing Health checks at regular intervals.
. System Monitoring: System Response / Performance Consideration.
. Check for Update records, check for the ABAP dumps.
. Installing the Front end and generating Services and Logon files
. Monitoring and controlling active users
. Monitor User Lock entries, System Log analysis of all remote instances
. Archiving activities like (archive data, delete, index and darting).
. User Administration: Created and Maintained User master records and
Users. Customized User Login Controls.
. Computing Center Management System (CCMS): Using this tools Changing and
importing Instance and Startup profiles, Performance monitor, Alert
monitors, workload analysis, Database monitor and Buffer monitors. Also
using these tools to configure operation modes to optimize work process
requirements of R/3 4.7 and BW 3.1C
. System Administration: Performed Dump Analysis, Lock entries, System Log
Used Alert Monitoring.
. Database Administration: Analysing Dictionary Buffer. Analyzing Database
Performance, Database parameter changes, checking the status of the
Primary Files and Transaction Log File.
. Performance Monitoring and Tuning: Performance of BW 3.1C and SAP R/3
system and database using CCMS utilities. Tuning application and database
Buffers and various R/3 4.7 and BW 3.1C Parameters.
. Backup and Restore: Planning Backup Policies and Recovery Policies. Full
Backup/Differential Backup/Transaction Log Backup of SQL Server Database
Nexus Technology, Rosemont, IL May 2002 - Apr 2003
SAP Basis Administrator
Platform: Windows NT
SAP Systems: R/3 4.6C, BW 2.1C
Database: Oracle 8i
. 4.6C installation, setup and post installation activities.
. System monitoring tuning and trouble shooting (SM04, ST06, ST03, AL08)
. Database monitoring and problem solving (DB02, ST04, DB12, ST04)
. SPAM update, plug-in installation, Imported profiles, Client Copy
. Client creation and management, Profile management and configuration
. Database table space management and extents management (SAPDBA)
. Resolved user database table locks and table space fragmentation
. Configured Transport Management system with transport domain controllers
and transport groups.
. Created RFC Server groups for ALE parallel processing and distributed
work processes efficiently.
. Applied support packages with SPAM in DDIC at client 000. Used SAINT to
install Add-ons/Plug-ins and handled SPAU resolution.
. Transported HR, SD tables and dependent tables, User master records with
profiles and authorizations, Background jobs from one R/3 system to
another R/3 system.
. General system Administration, CTS and system maintenance.
. Trouble shoot R/3 security problem by using different scenario such as
system trace, parameter change, buffer reset, SU53, and SU56 in order to
find security problem.
. Set up Spooling and Printing devices, configured company logo and page
sizes.
. Performed Role administration and troubleshooting.
. Configure and maintain system operation modes & profiles, apply SAP
Patches and support package application, resolve SAPGUI issues.
. Configured system alert thresholds through CCMS
Sprint PCS March 1999 - May 2002
Overland Park, KS
Role: UDB Db2 Database Administrator.
Worked as a DB2 UDB Database Administrator for designing and layout of
physical databases on 56 nodes m/c with 112 partitions. Install, configure,
set-up and support database in Development, QA, staging and Production
environments.
Use of utilities like Export/Import/Load/db2move and db2look for Creating
multiple copies of databases using redirected restore.
Developed shell scripts for maintenance, backup, recovery. performance
tuning for sortheap, dbheap, locklist, catalog cache and maxlocks etc.
Performance tuning using snapshots, db2explain, create indexes as and when
required. Tune Buffer Pool's to enable more caching database data pages in
memory and reduce the physical I/O access to disks.
EDS Nov 1997- Feb 1999
Lansing, MI
Information Analyst
Worked as a Database analyst providing support for application development,
testing and production database server. Responsible for developing database
design by analyzing business requirements and develop physical and logical
data models. Support regular maintenance activities like backups, update
statistics, check status of the tablespaces etc.
Supporting SQLServer 6.5 databases for different applications and
application for db2 on AIX. Install, configure, set-up and support database
in Development, QA, staging and Production environments.