SUMMARY

• Over 12 Years of working experience in IT Industry. Held responsibilities as SAP Basis Team Lead, Senior Basis Consultant, Manager - Data Processing, Systems Analyst.
• Certified SAP consultant in SAP NetWeaver BI (BW & SEM)
• Specialized Basis Administration in the key areas of SAP installations, configuration, planning and managing application and database upgrades, workload balancing, client maintenance, client copies, security, performance tuning, transport management, output management, applying abap and java support patches, add-ins, system copies, DB upgrades etc.
• Expert in BW System administration and troubleshooting.
• Experience in installing and configuring NetWeaver 2004s products and J2EE components such as: installing and configuring SLD, configuring UME using Visual administrator tool, performing post installation activities for XI and portal systems, installing and upgrading Java instances, trouble shooting J2EE issues, connecting back systems to Enterprise Portal systems, configuring ADS services, creating transactional iviews in portal systems, performing transports, importing/ exporting content into SLD, XI and portal systems, downloading and applying support pack stacks to J2EE engine using JSPM and SDM, configuring SSO using SSL from portal system to backend systems.
• Configuring CUA
• R/3 Database Administration using Oracle and SQL server. Expert in using tools like BRTOOLS, SAPDBA, DBA Studio & SQL Enterprise Manager to perform activities such as table space administration, backup, restore, database performance monitoring.
• Experience as Oracle DBA (10.x, 9.x, 8i, 8.x, 7.x) such as installation, upgrade, maintenance, configuration, and backup/recovery operations, security, performance monitoring and tuning, managing database objects, log archiving, tablespace administration, importing and exporting java schemas
• Completed the course TADMBW (SAP BW Implementation and Operation) from SAP Training Academy, PA, USA in Nov’05.
• Having experience in work scheduling, resource planning, process enhancements to cut down cost and time

TECHNICAL SKILLS

Languages: ABAP/4, C, PL/SQL, JAVA, HTML

RDBMS: Oracle7.x/8.X/9.X/10.x, Sql Server 7.x/2005, DB2 on iSeries

ERP: SAP R/3 (3.1h/3.1I/4.0B/4.5B/4.6B/4.6C/4.6D/4.7E/2005)

Data ware housing: BW (1.2B/2.0A/2.0B/2.1C/3.0A/3.0B/3.1C/3.5/7.0) SEM (3.1/3.2)

SAP Portal: 2004s EP 7.0

SAP XI/PI: 2004s XI 7.0

J2EE: 2004s platform (UME, ADS, ESS, MSS)

SAP Solution Manager: Ver 3.0/ 3.1/ 4.0

Hardware: Confidential iSeries /HP/Compaq/Dell Servers on INTEL

Operating System: Windows NT/ 2000/2003/2008 , AIX, OS/390, UNIX

Other Software & Tools: MS office, Visio, Snagit

PROFESSIONAL EXPERIENCE

Confidential

SDM( Service Delivery Manager, Technical)

Responsibilities:

• Worked as PDL ( Product Delivery Lead )
• Attending status meetings with customer and Project Manager and providing status updates on pending SRs
• Planning and scheduling work, creating change service requests and following change management procedures
• Coordination between tech teams and driving the tasks to completion
• Providing technical support and guidance to the technical teams( Tier1 and tier 2)
• Providing training to support team( Tier-II & Tier-I ) as and when required
• Providing Tier-3 support in the day to day technical issues and updating the resolutions in trouble tickets.
• Systems analysis, troubleshooting, escalations and coordination between technical teams and management. Analyzing system performance reports (monthly reports) and adding recommendations. Following proactive approach in resolving issues.
• Planning, scheduling the maintenance activities and SAP system changes .working with other teams in assigning resources to the maintenance activities (SR and CSRs).
• Attending weekly, monthly status calls and providing status information on current issues and future planned activities to upper management. Bring up issues to management notice such as complex issues that could lead to a system outage and customer requests.
• Writing SOP (standard operating procedures) for standard maintenance activities such as system copies, client copies, kernel patching, DB upgrades, sap system tuning etc.
• Creating and updating customer specific policy and procedure documents.
• Involved in Customer commission and decommission process.
• Configuring and trouble shooting TMS, writing scripts to import bulk transports during production cut-over.
• Helping BW and BI teams on system copy, load failure trouble shooting, migration and performance tuning such as improving load performance, query performance, enabling, collecting and analyzing BW statistics.
• Performing DB reorgs, DB performance and tuning
• Helping tier1 and tier2 teams and providing guidance during sev-1 resolution, performing complex changes such as system copies, DB upgrades, DST time changes, poor performance, issues with clusters, applying J2EE support packs, kernel, Spool Issues, configuring Printers and trouble shooting.
• Applying Tax tubs to other 3rd party applications such as Taxware, Vertex & BSI.
• Applying maintenance licenses to SAP
• Configuring Outbound mail (SMTP) and trouble shooting
• Connecting SAP systems to Solution manager, configuring maintenance optimizer to down load SAP support packs from OSS, and generating service level reports and early watch alerts.
• Installing application servers and enabling load balancing

Environment: ECC 6.0/BW 7.0/EP 7.0/XI 7.0/Solman 4.0/Windows 2003 64 bit Unicode/AIX 5.0 64 bit Unicode/ Oracle 10.x /DB2 9.x/MS SQL server 2005

Confidential, Houston, TX

Basis Lead Consultant

Responsibilities:

• Acting as Principal Consultant and main contact for all SAP Basis related issues
• Actively participating in analysis, trouble shooting, reporting and documenting the day to day technical issues communicated to me by the client IT managers through trouble ticketing system.
• Performing and monitoring various tasks related to Production Support
• 24*7 on call to attend emergencies
• Installing Net weaver 2004s platform based Enterprise portal, configuring UME
• Installing Employee service system, Management service system in EP J2EE
• Installing Net weaver 2004s platform based ECC6.0 ( Both ABAP & JAVA engines)
• Installing Net weaver 2004s platform based BI 7.0 ( Both ABAP & JAVA engines)
• Installing Net weaver 2004s platform based XI 7.0 (Both ABAP & JAVA engines)
• Installing Net weaver 2004s platform based EP 7.0 (JAVA engine only)
• Installing 32-bit ADS system ( Standalone J2EE engine)
• Installing Solution Manager 4.0 and running SLD on this system
• Post installation activities for all these applications, particularly configurations using Visual administrator and config tools
• Trouble shooting using log viewer
• Installing ADOBE acrobat 32 bit system(J2EE) and configuring it to use it through ECC 6.0
• Configuring SSL and single sign-on for ECC using portal, and using WebGUI
• Configuring remote printing
• Configuring SAP router and connecting all SAP application servers
• Opening and closing service connections to SAP
• Creating customer messages and communicating with SAP on various technical and license related issues.
• Installing software to monitor the SAP application servers
• Performance and tuning the SAP, instances
• Creating, scheduling the standard basis jobs for housekeeping and monitoring them
• OLSS maintenance, creating and maintaining OSS users, supplying developer keys to developers, maintaining the system data, applying for SAP licenses and system auditing
• Collecting objects in to Transports using Transport tool in BW
• Performing transports using STMS, Copying transports and collecting objects in to transports, creating transport groups and automating the transport process
• Performing Client copies and system refreshes
• Creating source systems, installing and activating business content in BI system
• Applying JAVA and ABAP support pack stack using JSPM and SPAM
• Creating CSR requests and applying SSL certificates to Portal and R/3 backend systems.
• Configuring SSO from portal to all backend systems.
• XI system post installation configurations
• Installing and configuring central SLD, and exchange profile maintenance
• Day to day trouble shooting and performance monitoring
• Security administration, checking security logs using SUIM, regenerating standard SAP roles, creating users in Portal system and assigning portal roles
• Downloading and applying Content to SLD, XI and BI systems.

Environment: ECC 6.0/BW 7.0/EP 7.0/XI 7.0/Solman 4.0/Windows 2003 64 bit Unicode/MS SQL server/HP proliant servers

Confidential, Peoria, IL

BW Specialist

Responsibilities:

• Troubleshooting BW load failure Issues, performing root cause analysis, documenting the issue and updating the (Siebel) trouble ticket
• Issues with BW process chains- Collecting Objects into a transport, Failed Process chain, issues with variant configuration, errors with timeout OR false alarms, PSA deletion
• Performing emergency migrations from development environments to mutable quality control and test environments and later into production environment
• Transport Failures- analysis and rectifying the issues
• Opening and closing production environments
• Opening service connections to allow SAP to log in to PRD system, in case the issue could not be resolved in general OSS customer message.
• Unlocking users and changing passwords in FDC & PRD environments, using workplace
• Studying BW performance, and making recommendations for improvement
• Training BW Basis teams on techniques to improve BW system performance - BW load performance & Query performance
• Checking the system logs, and short dumps for any possible bugs with the current code. If any bugs identified, then perform research in SAP OSS, and figure out the advance correction or a missing support pack. Request basis teams to apply these (Either advance correction or support pack) in CT, test it QA and migrate to all production environments. Supporting all these activities.
• Applying advance corrections to code ( Applying source code corrections as described in SAP OSS notes), using transaction SNOTE
• Preparing test documents, and validating test procedures
• Writing / Validating Basis operations (procedures) documentation
• Suggesting latest support packs, plug-ins and any corrections associated to maintain the SAP software bug free, and up to date with all the latest possible features, which indirectly improves the availability of the application bug free and with most recent features to handle the business processes more efficiently.
• Analyzing BW system using RSRV
• Reactivating or reconnecting the source systems in BW, in case the connection is broken
• Running SGEN, and reactivating all programs in quality control and production environments ( After completing a major transport from common template environment)
• Reactivating all transfer structures in BW after any major transport migrations
• Involved in a major project (Redesigning the BW loads using BW process chains and rolling out to all 28 independent dealer environments) and performed various activities such as: applying support packs, Plug-ins, Configuration for sending Email notifications, Collecting the objects and Transporting the Process chains, Resolving issues related to missing objects in transports, testing the process chains functionality in development QC and test environments, documenting the procedures for resolving the issues with transports, Supporting the Change management Teams in transporting code, troubleshooting the issues related to transports, creating or altering the security roles, testing and transporting them to production environment, tuning the production environments to improve the load performance and read performance after importing the process chains, and KT to support teams to maintain the process chains.
• Involved in a transport management system redesign and implementation project. This project is designed to merge development environments to all dealer environments by creating domain links, redefining transport layers and development classes.
• Lead a BW performance improvement project to improve the loading and query performance for all BW environments. Studied the statistical history from BW statistics, performance history from standard transactions (ST03N, ST03, ST04, ST06 and DB02) and query trace analysis using query monitor RSRT, and prepared data sheets with all the appropriate information. Turned on query caching and filling the query cache regularly to improve query read performance and turned on parallel processing for ODS and other possible adjustments which are applicable.

Environment: SAP 4.6C/BW 3.0B/ AS/400/DB2

Confidential, NJ

SAP Basis Admin and Practice Manager

Responsibilities:

• Responsible for SAP Training and Implementations.
• Responsible for SAP R3, BW, APO, KM system landscape installation, upgrades and maintenance
• Involved in recruiting SAP professionals by conducting technical interviews
• Screening consultants and conducting mockup interviews.
• BW system architecture and implementation studies using ASAP methodologies,
• Training consultants in ABAP and BW and preparing them for SAP certifications. (Over 100 consultants achieved SAP BW certification under my training)
• SAP systems auditing, applying and installing license keys, developer keys and SSCR keys.
• Performance and tuning application and database servers.
• Log on load balancing, work process distribution using operation modes and instance configuration.
• Installing and configuring JRE and SDK.
• Regular backups to SAP application servers.
• Upgrading BW application servers.
• Upgrading database servers.
• Applying support packs and add-ins.
• Applying OSS notes to correct software bugs.
• Monitoring and troubleshooting the systems using CCMS.
• Checking update modules, troubleshooting cancelled updates.
• Monitoring the background jobs, analyzing the failed jobs and restarting them after error correction.
• Monitoring BW process chains, Info packages and troubleshooting.
• Scheduling recording the statistics of BW info cubes and creating aggregates to improve the query performance.
• Using SAPDBA tool, tablespace maintenance, Db check and Db verify.
• Configuring TMS and moving transports from development box to test box.
• SAP servers security administration. Creating users, maintaining authorizations
• Creating and maintaining OSS users.
• Installing SAP ROUTER. Opening service connections
• Booking training courses and certification exams with SAP.

Environment: SAP 4.7E/BW 3.0B/BW 3.1C/Oracle9.x/Win2000 Adv SRV/DELL Hardware

Confidential, MN

Basis Admin

Responsibilities:

• 24X7 Production Support
• Responsible for TMS configuration, moving transports from Dev to Test and production boxes.
• Defined Printers in SAP and spool trouble shooting
• Applied SAP Support Packages and kernel patches.
• Opening and closing OSS connections, maintaining SAPROUTER
• Maintaining SAP system data, applying SSCR keys, Developer keys
• Configured Centralized Alert Monitor for system monitoring.
• Analyzed system using ST06, ST04 and ST03
• Resolved performance issues by tuning instance profile.
• Installed a new dialog instance and performed load balancing

Environment: SAP40b/SQL server/WinNT /Compaq Hardware

Confidential

SAP Basis and Network Administrator

Responsibilities:

• SAP servers installation and maintenance
• Client Maintenance
• TMS configuration, moving transports, and trouble shooting issues with transports
• Creating RFC destinations, source system in BW 1.2b.
• Upgrading BW application server from 1.2b to 2.0a.
• Installing business content, moving transports from dev to test Box.
• Applying Support patches and plug-ins
• Downloading add-ins from OLSS and applying using transaction SAINT
• Creating users and assigning authorizations.
• Applying for license keys in OLSS.
• License auditing
• Applying for SSCR keys in OLSS.
• Performance and tuning
• Monitoring the SAP servers using CCMS
• Checking system logs using SM21.
• Conducting training sessions in ABAP/4 and BW
• Conducting technical interviews, seminars and presentations
• Installing proxy server and configuring mail server.
• Upgrading the system RAM, upgrading the OS from Win98 to Win 2000 professional.
• Installing network printers in SAP using transaction SPAD.
• Installing SAP CRM, SIEBEL CRM servers on WIN 2000 server.
• Installation and configuration of SAPROUTER.