Brief introduction about experience
Over 13 years of professional IT experience and more than 7 years of experience with SAP BASIS, NETWEAVER and SECURITY Implementation, Support, Upgrade and Enhancement projects. Experience includes infrastructure Architecture, design, landscape solutions, system installation, system configuration, system monitoring, system testing, user training and documentation. SAP expertise apart from core SAP BASIS activities are typical system administration activities on SAP NetWeaver Portal, NetWeaver Development Infrastructure, SAP WebDispatcher, SAP BW/BI/PI/CRM/SRM, Portal Integration, Single Sign-On and SAP transport layer security (SSL).

Experience Summary

• Proficient in Installations of ECC 6.0 EhP4/EhP5, SAP NW 7.0/7.01/7.02, SAP NetWeaver 2004s, SAP R/3 (4.6B, 4.6C, 4.7), BW 3.5, BI 7.0, Web AS 7.x, Solution Manager 7.0, PI 7.0, CRM 7.0, SRM7.0, GRC 5.3, NWDI 7.0, TREX 7.3.
• Experience in SAP BW/BI, update support packs, add-ons and kernel upgrade. Involved with creation of source system with setting up RFC between the systems.
• Performed homogeneous/heterogeneous system copies using Export/Import method, Database refresh, Migration.
• Proficient in Database Administration, Performance Tuning, Kernel Upgrade, Log Analysis, Workload Analysis, SAP Router configuration, scheduling background/batch jobs, Spool Administration.
• Hands on experience as SQL Server DBA with SQL 2008\\2005\\2000\\7.x
• Excellent troubleshooting skills acquired over the years by analyzing system logs, traces and ABAP dumps.
• Expertise in typical SAP application security activities in Profile Generator (PFCG), Role/Profile creation and modifications. User Administration activities like User creation, deletion, lockdown, activation, Password management.
• Proficient in Client Administration – Client Creation, Client copy, Client export, Remote Client Copy, Client Deletion, & Assigning Logical System to client.
• Strong experience in Portal System Administration, Portal User Administration, Portal Security and Portal Content administration/management.
• Installed and configured SAP NetWeaver Portal 6.0/7.0, TREX search engine, SAP WebDispatcher, System Landscape Directory.
• Proficient in Transport Management System (TMS) – Complete setup of Correction & Transport System (CTS) using STMS, troubleshooting TP import problems.
• Extensively used Data archiving tools provided by SAP using the transaction SARA.
• Strong experience in setting up the transport layer security environment through the use of SSL and SNC protocols and exposing the federated portal to the Internet via a secure mechanism using a reverse proxy (SAP Web Dispatcher, Microsoft ISA server).
• Strong expertise in setting up the NetWeaver Development Infrastructure (NWDI 7.0), including installation, configuration, integration and maintenance.
• Excellent verbal and written communication skills to present proposed solutions and observed results to management and team members.

Technical Skills

SAP BASIS/NetWeaver

SAP R/3 4.6C/4.7 EE, ECC 5.0/6.0, SAP BW 3.5, BI 7.0, BO XI 3.1, EP 6.0/7.0, SAP NetWeaver 04/04s, XI 3.0, PI 7.0/7.1, WAS 6.40, CRM 5.0/7.0, SCM 5.0/7.0, SRM 5.0/7.0, Solution Manager 4.0/7.0

VB.NET, JAVA, C, C++ and SQL

Windows NT, Windows XP, Windows 2000/2003/2008 Server, IBM AIX V6 6.1/5L 5.3 and Solaris (Unix).

Visual Admin, NWA, Configtool, NWDS, BR / Oracle xx / NWBC and DB2 9.1 and Redwood, GRC 5.3

HP Proliant, IBM

Education:

• Master of Computer Applications (M.C.A)

Project Details:

Confidential,Chicago, IL Sep‘2011 to Tilldate
Role: Sap Basis Administrator

Responsibilities:

• Installation and Upgraded CRM 7.0 to CRM 7.0 EHP1
• Installation and Upgraded kernel.
• Clients Maintenance i.e. Local / Remote Client Copy using SCCL / SCC9
• Upgradation of Support pack using SPAM/SAINT and Applied OSS using the T-code SNOTE.
• Created Users Masters using SU01.
• Downloading s/w patches from OSS. Getting the latest release , installation and upgrade information.
• Performed BW upgrade from BW 7.0 to BW 7.3
• Performed Enterprise Portal upgrade from EP 7.0 to EP 7.3
• Performed WebAS upgrade from WebAs 6.40 to WebAs 7.11
• Performed an ECC upgrade from ECC 6.0 EHP4 to ECC 6.0 EHP5
• Printer/Spool Admin using SPAD & Spool Trouble-shooting using SP01
• Instance Profile Maintenance using RZ10 to tune for better performance.
• Database performance analysis and tuning (ST01, ST02, ST03, ST04, ST05, ST22), RFC and ALE configuration. (SM59, SALE)
• Worked with transactions that were being used but not limited to SM21, SM50, SM51, SPAM/SAINT (for applying Support Packs and to add Plug-Ins), AL11, SM28, SM01, SM02, RZ03, RZ04, SM63, and SM66.
• Daily monitoring and Analysis of the SAP system landscape -ABAP dumps, System logs, System Locks, Updates, Background jobs, Work processes, Spool data, and Workload statistics, Monitoring of the System trace/logs and lock.
• Defined Job profiles for various Functional Areas
• Created and Maintained User Master records
• Utilization of SU53, System traces and Debug utilities to Optimize authorization checks, Customized User Logon Controls.
• Transporting of Authorizations and Users Master Records across clients
• SAP GUI Installation on clients and rollouts, System Maintenance Strategy, Posting System Messages, ESS & MSS Configuration
• Installed SAPGUI, patch uploading, client copy, kernel upgrade, performance tuning, backup & performance monitoring of R/3.
• Performed activities of SAP security and User and spool management.
• Configuring Output devices, spool servers and TMS.
• Transporting the transport requests from development to quality server.
• Configuring the backend systems in EP and configuring the RFC between EP6.0 and BW servers.
• Performing the system copy from development to quality server.
• Creating roles and profiles to the end users.

Environment: SAP R/3 ECC6.0, CRM 7.0, SAP Solution Manager 7.0, Oracle, UNIX.

Confidential,Libertyville, IL Oct 2010-Aug’2011
Project: Sap Basis Administrator

Responsibilities:

• System monitoring (daily checks, logs, dumps, locks, updates, IDOCS).
• Batch job management.
• Output/Spool monitoring and management.
• Performance monitoring and analysis and improvement.
• Landscape management (RFC destinations, transports ABAP & JAVA, apply OSS notes, client settings, client copy, client refresh).
• Environment management (system restarts, parameter changes).
• ALE configurations between IS-Retail and AFS systems.
• SQL Server 2008 performance monitoring and management.
• Input to functional team for problem resolution where necessary.
• Helpdesk call monitoring and resolution, Service desk and Bug host Call resolution.
• Responsible for creating R/3 users with defined Role based authorizations.
• Thoroughly understanding the requirements of the business and technical architects, carrying out the Role design, Role Configuration, Role Derivation as per the specification of clients.
• Unit testing of Transactions and Roles.
• Maintaining authorizations, determining authorization failures and resolving.
• Supporting IST, UAT by Bug fixing before Go–Live of the each deployment.
• Supporting Post Go-live of the deployments.
• Was responsible for Basis and SAP Security Support at onshore.
• Planning resource requirements and schedule for further phases, coordinating with off shore resource management team.
• Assisting recruitments and ensuring optimum utilization of resources at onshore.
• Time sheet and Handling invoicing and billing with onshore Project Office.
• Managing logistics and on boarding of new joiners at onsite.
• Was also responsible for obtaining periodical feedback from the client, causal analysis and designing preventive mechanism

Environment: SAP ECC 6.0,EHP5, SCM, BW 7.3,PI 7.1,BPC 10.0, BOE (BOBJ) 4.0, Trex, SAP Solution Manager 7.0, GRC 5.3 and SQL Server 2008 , WIN 2008.

Confidential,Irving, TX May 2009 – Sep 2010
Role: Senior SAP Basis Consultant

Responsibilities:

• Monitoring System with CCMS, Background job processing, Spool jobs, Spool and Queue administration.
• Adjusting Operation modes and WPs depending on the load and job type to be scheduled and executed, profile maintenance.
• Worked on SAP Check Indicator Defaults and Field values, reduced the scope of Authorization checks using transaction SU24 and maintained check indicators for Transaction codes.
• Configured Profile Generator (PFCG) and transported settings to all clients, setup security for the developers and end-users.
• Database administration, working with Oracle DBAs to define data archiving steps and performing the same using TCs, SAP DBA integration with SAP DBA.
• Database performance analysis and tuning (ST01, ST02, ST03, ST04, ST05, ST22), RFC and ALE configuration. (SM59, SALE) Administering lock entries and update records. (SM12, SM13, SM14)
• Worked with transactions that were being used but not limited to SM21, SM50, SM51, SPAM/SAINT (for applying Support Packs and to add Plug-Ins), AL11, SM28, SM01, SM02, RZ03, RZ04, SM63, and SM66.
• Version upgrade of SAP 4.0B to 4.7Enterprise and database related activities involved in the upgrade process.
• SAP Net Weaver suite of products from SAP, with special focus Web AS 6.4, SAP BW, XI, MI, Development Tools and Enterprise Portals installation, configuration and administration.
• Data Archiving of Info-Cubes and ODS objects (SARA) and checking the archive files using extractor checker (RSA3).
• Created database copies of an SAP source system and BW system. Experience on BW Security Administrator in 3.5 B.
• Day to day database monitoring and maintenance such as extents limit for objects, storage structures, data loading, performance tuning, user security.

Environment: SAP R/3 4.7Enterprise, SAP BW 3.5B, UNIX, Oracle 9.0.2

Confidential,San Antonio, TX Aug 2007 – Apr 2009
Role: Senior SAP BASIS Consultant
Responsibilities:

• Installed Development, Technical testing ,Quality system for SAP ERP 6.0 with EHP4, SAP CRM 7.0 , SAP BI 7.0 SAP PI 7.1
• Performed system refreshes for SAP ISU,SAP CRM 7.0
• Database backup using Brtools.
• WEBAS Netweaver CE installation.
• SAP note installation
• CRM 5.0 to CRM 7.0 upgrade
• Enhancement pack 3 application for ISU components.
• Enhancement pack 4 application for ISU components.
• Homogenous system copy to Build Development systems of ISU , CRM
• Post installation of System copy of ISU & CRM
• Support pack application on ERP 6.0 & CRM 7.0
• ORACLE 10.2g database installation
• Oracle 10.2g database patch installation
• Service Desk configuration for Solution manager.
• CRM middleware technical configuration between ERP & CRM systems.
• Performed Solution manager 7.0 installation
• Support packs installation on Solution manager
• Installation of Business objects enterprise XI 3.1.
• Install SAP Web Application server for Business object. Install Business Objects XI 3.1 SP2 (BOBJ).
• Deploy Web Applications on SAP Application server.
• Install Business Objects SAP Integration Kit (IK)
• Registering all systems in Solution manager landscape.
• Early watch configuration for all systems in landscape to solution manager
• Generating weekly Early watch reports
• SAP BI integration with source system SAP CRM.
• Application server installation for ISU & CRM systems.
• ISU data migration initial server setup
• Prerequisite Performance changes for ISU migration objects
• Performance monitoring & support for ISU DATA migration.
• Monitor & support CRM Data loads to ERP.
• CCMS alert configuration for all systems to Central monitoring structure.
• CRM WEB IC integration with SAP EP portal as federation.
• Database backup using BRTOOLS
• Databases restore using brtools.
• Brtools initial parameter setup & profile initialization.
• Create a new database, Tablespace.
• Stream serve installation for Print based architecture.
• Configurations of stream serve printer queues.
• Heterogeneous system Exports for ISU & CRM systems.

Environment: System P Series AIX 5.3 servers (Power5, Power6), SAN EMC, Clarion, DB6 V9, SQLServer, Cognos BI8.4, SAP Net weaver 7.0, 2004s, Kernel 7.x, TSM, TDP, Networker, SAP XI/PI, MDM, EP, SM, BW, SRM, ECC, Windows, J2EE, HR, FI, Accounting, GA, Interfaces, SLD, HACMP, NetWeaver

Confidential,Woodcliff Lake, NJ Apr 2006 – Jul 2007
Role: SAP NetWeaver Administrator

Responsibilities:

• CRM 2007 installation on AIX server.
• CRM 2007 Distributed installation.
• SAP Solution manager installation 4.0
• SAP ERP Installation.
• Support pack application for CRM
• SAP Kernel upgrade on AIX server.
• Best Practice for CRM 2007.
• Installation of SAP Biller Direct 6.0
• Configuration of Biller directs 6.0 to ERP backend & web server.
• Post installation for ISU ,CRM , PI
• CRM WEB Interaction centre set up & configuration.
• Application Server install for ERP, CRM system.
• Client Copies, Client Deletion & client exports.
• Support pack installation on ERP , CRM , PI
• Enhancement pack 2 for ERP installation done for utilities specific components
• Backup & restore of database using BRtools.
• Configured SAP systems for EMAIL & SMS communication
• Setup Early watch session for all systems in Landscape.
• Oracle 9i database patch installation
• CRM middleware technical configuration between ERP & CRM systems

Environment: SAP 4.7, ECC 6.0, Solution manager 4.0, BW 3.5, BI 7.0, CRM 2007\\5.0, TREX, MDM, Oracle 9i, AIX.

Confidential,Raleigh, NC Jul 2004 – Mar 2006
Role: SAP R/3 Basis Consultant & SQL DBA
Responsibilities:

• Installed and configured SAP R/3 4.6C SR2 on Windows NT.
• Installed and configured SAP BW 2.1C
• Configured the Transport Management System of newly created SAP systems.
• Applied R3 Support Packs, upgraded Kernel and OSS notes.
• Performed homogeneous system copies.
• SPAM update, plug-in installation, Imported profiles, Client Copy
• Client creation and management, Profile management and configuration
• System monitoring tuning and troubleshooting (SM04, ST06, ST03, AL08)
• Database monitoring and problem solving (DB02, ST04, DB12, ST04)
• 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.
• Configure and maintain system operation modes & profiles, apply SAP Patches and support package application, resolve SAPGUI issues.
• Performed workload analysis and tuning
• Involved in Printer Setup and Spool Administration.
• SQL Server DBA activities like backup, recovery and daily jobs monitoring.

Environment: SAP 4.7, ECC 6.0, Solution manager 4.0, BW 3.5, BI 7.0, SCM 4.0, CRM 5.0, TREX, MDM, SQL Server 2005\\2000, windows 2003.

Confidential,Plano TX Dec 2003 – Jun 2004
Role: SQL Server DBA

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Installed and configured SQL Server 2005 32-bit in a Test Environment and migrated & tested databases to production server.
• Implemented log shipping in standby mode to support DR servers.
• Documented and tested Merge replication in test environment for generating reports.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Worked with management to develop database strategies to support company needs.
• Responsible for creating and maintaining technical documentation for the database environment.

Environment: SQL Server 2000, Windows 2000 Advanced Server.

Confidential,Honolulu HI Feb 2002 – Nov 2003
Role: SQL Server DBA
Responsibilities:

• Installation and configuration of SQL Server 2000.
• Created new database using SQL Server Enterprise Manager, Database Wizard and T-SQL Statements.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log.
• Managed databases on multiple disks using Disk Mirroring.
• Used log shipping for synchronization of database.
• Completed documentation about the database and analyzed long running slow queries/stored procedure for better tuning.
• Involved in automation of the job and was also involved in daily monitoring of the tables and indexes to ensure excellent performance.
• Analyzed the problems in the production environment and developed new procedures and methods to monitor problems and automate alert messages to take pro-active action.
• Performed daily backup on System and Users database.
• Setup Replication and Database Mirroring to ensure high availability.
• Worked on DTS, BCP Import and Export utility for transferring data.

Environment: Windows, SQL Server 2000, DTS

Mar’00 – Jan’02. Software Engineer. Savitr Software Services Ltd, Hyderabad INDIA
Project: Hyderabadcakes.com (In house project)
Role: SQL Jr DBA + Developer
Technologies: ASP 3.0, IIS, VB Script, SQL Server 7.x