ERP Technical Specialist

Manish Pratap Singh

SAP Basis / NetWeaver & Managing Consultant

Ph: 408-***-****

SUMMARY:

Around 15 years of IT experience, includes around 13 years of experience in SAP as Basis/Net Weaver Consultant and Team Lead with core strength in all aspects of SAP Systems & Database Administration in Production Support, Upgrade & Migration phases.

Full life cycle Implementations of SAP (OS, DB, SAP and Post Installation), System landscape re-design, and Load balancing and experienced production support in some projects on multiple platforms.

Worked extensively in several SAP products with different landscape includes SAP NetWeaver 2004S/7.0/7.3, 7.4, R/3 4.6c, 4.7 EE, ECC 6.0 with EHP4/5/6, EP 7.0/7.3, PI 6.0/7.0/7.3, BW 3.1/3.5, BI 7.0 EHP1,EHP3, SRM 5.0/6.0/7.0 SR1, CRM 5.0/7.0, SCM 7.0, APO 3.1/3.0, SAP BPC 10, TM 9.1, MII 14,15, GRC, Gateway, Solution Manager 4.0/7.0/7.1, HANA, SAP Plug-in’s/Add-on's.

Experience on leading teams for some major clients for Implementation, Roll outs, Upgrades and Support (J&J, GSK, Spansion, Shire, Wolters Kluwer). Includes Onsite & Offshore teams combination.

Experienced in Upgrade for ECC, BW, CRM, EP, GTS & Solman systems.

Experienced in OS/DB Migration for ECC 6.0 from Windows/SQL Server to HP-UX/Oracle systems.

Experience in SAP BPC, TM, MII Installation & configuration.

Expert Knowledge in monitoring the services for the Satellite systems, Remote Systems, Central systems in Solution Manager like EWA, RCA, Alert Monitoring and Early watch.

Installation and Configuration of SAP Web-Dispatcher.

Experience in Third Party Backup Tools (Tivoli, SMSAP).

Expert in Configuring SLD, SSO, SMD, ITS, Integration Server (IS), JCO RFC Destinations.

Experienced in Configuring Change and Transport system (CTS & CTS+).

Extensive experience on all aspects of SAP Basis Administration including System Copy/Refresh, Disaster & Data Recovery, Support Packs, Kernel Upgrades, Add-on installations, applying OSS Notes, Spool Administration, Workload Analysis, SAP workplace monitoring using CCMS.

Experienced working on Standalone, Distributed & High Availability (HA) environments.

Administered and configured LDAP and SSO for several client systems.

Implemented BRTOOLS/ DB13 Backups in Online and Offline phases for a project.

Experienced in Security Administration: Working with PFCG to create roles, profiles.

Experienced in OSS system related activities.

Expert in Client Administration – Client Creation, Client copy, Client export, Remote Client Copy, Client Deletion, Securing Clients, Assigning Logical System to client.

Expert in Performance Tuning – Performance Tuning at System level, Database level and OS level.

Expert in Database Management - Backup, Restoration using BRTOOLs, Table space administration.

Excellent in Monitoring Batch/Background Jobs-Checking the status of Background Jobs, Deleting Batch Record, Generating Batch Record, Scheduling Background Jobs using Red Wood Tool.

Excellent Communication, Team, Interpersonal and Judging skills, which facilitate effective communication with other functional and technical teams in implementing a robust organizational security policy.

Experienced in Database Administration (Oracle, SQL Server & DB2).

Expert in Solving high medium low priorities issues within the client SLAs

Performed Knowledge Acquisition in one of the projects to the off-shore basis team.

Provided 24/7 on-call support, monitoring and provided required services.

Experienced in Support desk tools (Remedy, HP-ALM, Service-Now).

Completed training on SAP HANA Database and Business Suite Installation, Configuration & Maintenance.

Installation & Support for SAP on Microsoft Azure Cloud.

Professional Experiences:

HCL America

Textron Inc.

Senior SAP Basis Consultant Feb 2016 – Till Date

Environment: SAP EHP 6.0 EHP4, EHP5, BI 7.02,7.3, SRM 7.0, CRM 7.0, PI 7.11, EP 6.0, Solaman 7.1, GRC 10, GTS, Oracle 11g, SQL Server 2012, AIX, SLES, Windows

Provide daily support & maintenance for Non-ITAR Systems.

Planning & Implementing SAP Netweaver 7.4 on Microsoft Azure Cloud (Single & High Availability).

SAP BI with HANA DB Installation.

Pkanning to configure HANA SLT connections using Solution Manager

System Refresh Activity for ECC, BW & Content Server.

Daily Support activities for ECC 6.0, CRM, BI, PI, GTS, Solution Manager.

Solman Configuration Fixes for RCA & EWA.

HCL America

WoltersKluwer (CCH)

Managing Consultant August 2012– Feb 2016

Environment: SAP EHP 6.0 EHP4, BI 7.01, CRM 7.0, PI 7.11, EP 6.0, ECC 6.0 Best Practices, Solaman 7.0, 7.1,Oracle 11g, Linux 5.5/ 6.6

Installed and configured Solution Manager 7.1. Configured Technical Systems monitoring, solution monitoring and root cause analysis. configuring Managed Systems.

Installation of ECC, PI, BI & CRM using system copy for project landscape.

PI 7.1 post installation configuration steps.

STMS & CTS+ configuration.

Performed the basic configuration tasks in ECC & BI.

Configured the Message Archiving (ABAP & JAVA) in PI.

Configured the basic and managed system setup for Root Cause Analysis in Solution Manager.

Installation & Configuration for SAP Best Practices System (Baseline Package).

Perform SAP client administration (create client, copy client, delete client, export/import client) as required.

Draft the basis support tasks documentation for project team usage.

Plan and manage team for daily, weekly, monthly Basis support activities.

Quarterly planned QA system refreshes.

Planned & Upgraded Oracle 10g to 11g on SAP Servers (ECC, BI, PI, CRM, EP & Solman).

Planning for upgrade of SAP Landscapes.

HCL America

Shire Pharmaceuticals, PA

SAP Basis Consultant March 2012 – July 2012

Environment: R/3 4.7 EE, ECC 5.0 (HCM), BW 3.5, SRM 4.0, APO 3.1/SCM 5.10, SM 7.0, PI 7.0, ITS 6.20, Content server 6.40, Livecache, MaxDB 7.0, AIX 5L 5.3, Oracle 9.2.0.7.0,11.2.0.3, Windows 2008.

Performed SRM, APO/SCM production copy to QA (System Refresh) on AIX 5L. 5.3 Oracle 9.2.0.7.0

Integrated ATP to SAP APO 3.1 and R/3 for availability check and planning .

Performed Support Pack Stack SPS 19 and Kernel upgrade on HCM ECC 5.0

Upgraded Content Server 6.40, which is defined in R/3 4.7.

Upgraded ITS 6.20 for SRM 4.0 on AIX 5L5.3 Oracle 9.2.0.7.0

Upgraded third part tool Readsoft 3.20 which is used for direct invoice processing.

Performed bi-weekly client copies for ECC 5.0 (HCM) using SCCL

Supported the DBA activities for events such as adding tablespaces, monitoring database file systems etc.

Resolved Severity-1&2 issues within SLA agreements.

Single Point of Contact at onsite for SAP Basis/DBA activities.

Maintained /supported 24* 7 for all the systems irrespective of Prod/Non- Prod systems.

HCL America

Spansion, CA

Senior SAP Basis Consultant October 2011 - March 2012

Environment: ECC 6.0, BI 7.0, CRM 5.0, SRM 7.01, MDM 7.1, EP 6.0, GTS 10, SQL-Server 2005, 2008 & Windows 2008 Server

Performed dual stack SRM 5.5 with MDM 5 upgrade to SRM 7.01 with MDM 7.1.

Performed EP 7.0 upgrade to EP 7.3.

Performed GTS 7.0 upgrade to GTS 10.0.

Performed Solman 7.0 upgrade to Solman 7.1.

Performed System copies (ECC & BW) for hardware migration.

Fine-tuned the ECC 6.0 & BW 7.0 System

Performed the OS Migration for SRM-MDM, EP & GTS Systems

Moniotired and analyzed system performance issue and implemented Zero Memory Performance parameters.

Solving high, medium, low priorities issues within the client SLA’s

HCL Technologies Ltd.

ERP Specialist (SAP Basis) August 2010 – Sept 2011

Client: Glaxo Smithkline

Environment: ECC 6.0 EHP4, BI 7.0, PI 7.0, SCM, SRM 7.01, MDM 7.1, EP 6.0, IDM, CE, Solman 7.0, Oracle 10g, AIX 5.

Installation of ECC, PI, BI, SRM, SCM, EP & Solution Manager.

Post Installation configuration of ECC, BI systems.

Post Installation configuration of Solution Manager.

SMD & E2E Root Cause Analysis configuration on Solution Manager for ABAP, JAVA & ABAP+JAVA Stack.

Post Installation configuration of GRC System.

Post Installation configuration of IDM System.

Post Installation configuration of SRM-MDM System.

Providing support for Issue resolutions on daily basis.

Prepare and Execute TIPs and TIRs for the new installations.

HCL Technologies Ltd.

Technical Lead April 2009 – July 2010

Client: Johnson & Johnson

Environment: R/3 4.7, ECC 6.0, BI 7.0, PI 7.0, SCM, EP 6.0, Solman 7.0, Oracle 9i, 10g, HP-UX Superdomes.

Handling Johnson & Johnson EMEA Region with Over 150 Instances.

Upgraded from SAP R/3 system 4.7EE to ECC6.0 for complete Landscape.

Performed Unicode conversion.

Installation and configuration of High Availability Systems.

Web AS Java monitoring & management: Applying patches and Configuration parameter changes as per requirement using tools Visual Administrator, Config Tool, SDM and JSPM (Older versions).

System Copy/Refresh.

EP (Enterprise portal) responsibilities: Installing Netweaver portal. Implementing patches in EP systems upload and download roles, Transports.

Backup scheduling and analyzing errors for failure.

CRM integration with ECC

Background job administration by SAP, ESP work Manager and ESP Espresso

Printer issues regarding creating and troubleshooting with the help of UNIX team.

Notes implementation and OSS connection opening.

Tablespace Management, adding data files and rebuilding the index activities using BRTOOLS.

Troubleshooting of Disk space issue and file system issues.

Developer key and Object key issues.

Performance monitoring and analyzing and Memory management.

Database Backup and Archive scheduling and troubleshooting.

Experience on BMC patrol and HP Open View tools for CCMS monitoring.

HCL Technologies Ltd.

Technical Lead November 2009 – July 2010

Client: SAPESCO

Environment: ECC 6.0, BI 7.0, Oracle 10g, SQL Server 2005, HP-UX 11, Windows 2003.

Designed ECC, BI Landscape as per client’s requirement

Installation and configuration of High Availability System on HP-UX 11.31.

Performed OS/DB Migration for Development system of ECC 6.0, from Windows/SQL Server environment to Unix/Oracle.

Configuration of Adobe Document Services for Interactive forms generation.

Configuration of BI Java Portal to integrate with ABAP & EP 6.0.

System copy (ABAP+JAVA) of ECC 6.0, BI 7.0.

Backup scheduling and analyzing errors for failure using HP Data Protector.

HCL Technologies Ltd.

Technical Lead August 2008 – April 2009

Client: Fonterra

Environment: SAP ECC6.0, BW 7.0, SCM 5.0, Oracle 8i, 9i, SQL-Server 2000, Solaris 9i, Windows 2003

Installation of SCM & ECC 6.

Applying ABAP & JAVA Support packages on ECC 6.0 & BI 7.0.

Configuration of BI Java Portal to integrate with ABAP & EP 6.0

PI Configuration.

SLD Configuration.

Language Installation (French, German & Spanish).

Performed System Refreshes (ECC 6.0, CRM 5.0, SRM 5, BI 7.0)

Installation of Java Stack for BI 7.0.

Applied Certificates for Single Sign On.

Resolving Performance Issues.

Daily monitoring and resolving day to day issues

Steria India Ltd.

Technical Lead (SAP Basis) April 2008 – August 2008

Environment: SAP ECC5.0/6.0, BW 3.1, CRM 5.0, PI 7.0, Oracle 9i, SQL-Server 2000, HP-UX, Windows 2003

Provide technical guidance to team for on-going Basis and Database administration.

Installation of CRM 5.0, ECC 6.0.

Performed system recovery on Production Server (R/3 3.1).

Installation and configuration of PI 700.

Resolving Performance Issues.

Applied SAP Support Packages.

Created clients and performed client copies as per business requirements.

Detect, track and resolve production incidents for databases, R/3 and applications.

Creating documentations related to various system administrations related activities to help team.

Documentation of all the procedures and involved in end user training

HCL Technologies Ltd.

Senior Consultant (EMEA/NA) August 2006 – March 2008

Client: Johnson & Johnson

Environment: R/3 4.7, ECC 6.0, BI 7.0, PI 7.0, SCM, EP 6.0, Solman 7.0, Oracle 9i, 10g, HP-UX Superdomes.

Provide technical guidance to team for on-going Basis and Database administration support for hugely complex SAP environments.

Successfully transitioned J&J US Project to offshore team for production support.

CRM 5.0 Integration with ECC 5.0 and configured SSO.

Heterogeneous & Homogeneous Dialog Instance Installations.

System Copies using Export & Import.

Resolving Performance Issues.

Applied SAP Support Packages and OSS Notes when available from SAP for relevant release and to resolve issues occurred in different systems.

Handled Security related issues on R/3 and EP 6.0

Kernel Upgrades.

Created clients and performed client copies as per business requirements.

Detect, track and resolve production incidents for databases, R/3 and applications.

Perform security and basis admin tasks for CRM Implementation project.

Performing transports and daily monitoring related activities.

Creating documentations related to various system administrations related activities to help team.

Help ITS team in resolving issues as and when required.

Documentation of all the procedures and involved in end user training

CSC India Pvt. Ltd., Noida February 2006 – August 2006

SAP Basis Consultant

Client: INVISTA & DUPONT

Environment: ECC 5.0, CRM, BW 3.5, Oracle 8.0/ DB2 AIX 5.0

Maintained entire landscape which includes (ECC5,CRM,XI3.0,BW3.5)

Perform monitoring IDOCS and processing failed IDOCS/messages in PI.

System refreshed in ECC/BW/CRM.

Administered PI(sxmb_admin/cache refreshes/message troubleshooting/monitoring etc)

Provide OSS related support to open System for SAP to login, Creating OSS users

Monitoring IDOCS and processing failed IDOCS

Performing oracle administration using BRTOOLS.

Performance tuning in SAP and database(St03,explain plan etc)

Analysis and Resolution of production printer issues

Applying SAP Notes as per request from Application Team

Performing Support pack upgrade

Resolving the spool related issues and handling the SAP profile parameter tuning.

Documentation of methodology and knowledge transfer to the customer

DynPro India Pvt. Ltd. (IBM India Global Services)

SAP Basis Consultant August 2005 – January 2006

Client: INTEL, Bangalore

Environment: SAP ECC5.0, BW 3.1, SM 4.0, SCM 4.1, Oracle 8i, SQL-Server 2000, Solaris 9i, Windows 2003

On-going Basis and Database administration support for hugely complex SAP environments with multi-Terabytes of data and several hundred concurrent users to multiple clients.

Detect, track and resolve production incidents for databases, R/3 and applications.

Executed standard system and SAP housekeeping jobs as part of support to implementation team.

Installation of SAP 4.6c, 4.7, SCM, ECC 5.0.

Upgrade from ECC 5. 0 to ECC 6.0.

Applied SAP Hot/ Support Packages when available from SAP for relevant release and assisted functional team with testing.

Created, modified and assigned user authorizations and profiles to user ids.

Done Performance tuning by adjusting various Profile parameters and buffer sizes

Performing Database Administration, Table space administration, adding data files, archive log, checking Oracle trace file and log file for troubleshooting.

Involved in Backup/ Restore and Recovery activity using Veritas backup.

Daily Monitoring activities like Analyzing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces, and Lock Entries.

System performance monitoring: All activities like system response time, processes, Operating system related issues, memory-CPU, and utilization monitoring.

Benchmarking, Integration, Consolidation, Day1 System Refreshes from Production System Database.

Checking backup policies where backup is not done correctly.

Defining New RFC Destinations.

Correction and Transport Management System.

Attending customer calls and providing timely solutions, which includes primarily Basis and Database level troubleshooting

Synergy Data Solutions Pvt Ltd.

SAP Basis Administrator October 2003 – July 2005

Environment: SAP R/3 4.7EE, BW 3.1, Oracle 8i, Solaris 9i, Windows 2003

Installed SAP ECC 5.0, BW 3.1 System on Oracle 10g with Solaris 9.

Performed post installation tasks like final installation checks, installing additional languages, setting up online documentation and scheduling SAP load generator.

Performed Client copies and copying user master records from one client to another.

Complete administration of system landscape and transport management

Created logon groups and performed load balancing between application servers.

Extensively worked with logon load balancing, configuring operation modes, CCMS, spool management, batch job management and SAPGUI setup

Configured SAP router for OSS messages to SAP.

Configured internet email and fax using SCOT.

Worked on providing authorization and user administration in ECC environment with the security team.

Scheduled jobs in the background to clean up spool requests, dumps, batch-input sessions and background job logs.

Applied the Support Packs, Add-ons for all the sap systems in the environment up to the required level through SPAM and SAINT

Performed Oracle Patches/Recovery/Backup/Restores

Provided 24/7 On-Call Support on a rotational basis and as needed

The Swajal Project (World Bank Funded)

MIS Consultant/ Database Administrator Sep 2001 – Sept 2003

Department of Drinking Water & Environmental Sanitation, Government of Uttaranchal, Dehradun

The Swajal Project (World Bank Funded) is an autonomous body of State Government working in the water, sanitation and environmental sector

Work Profile:

Directly handling the Installing and Configuration of Oracle 8i Server

Effectively handling the repair and maintenance of Hardware, Networking, Troubleshooting & Software Installation

Imparting computer training as per the requirement of Project Management Unit, DPMUs, Sector Professionals (Secretariat Employees, Jal Nigam & Jal Sansthan) on Oracle 7.3, 8.0, 8i, Developer 2000, Networking and Use of Office Software, Management Information Systems & Computers in the Sector.

Overall DBA responsibilities and trouble shoot problems when necessary on a 24x7 basis. Following activities are done:

Routine tasks

Create Tablespaces, add Datafile in the tablespace.

Create Role, grant Privileges to Role and assign to User.

Rebuild indexes in a time interval for better performance.

Designing & Managing Physical and logical Backup procedure.

Running the Database in Archive mode & Mirrored redo log for restoring the Current status of the Database at the time of Database crash.

Regular performance tuning (SQL/SGA) and optimization for large database operations.

Implement schema changes in instances and maintain those changes through strict configuration management

Specific task

Administer, create, install, patch and upgrade the various Oracle database(s) (Oracle7.3/ 8.0/8i/ 9i)

Recover Data file of Oracle Database using Backup & Archive file when a Disk Crash occurs in the System.

Create Database with optimal parameters as per application requirements.

Reducing disk I/O to equally divide data files to every disk

Achievements:

Independently set up the MIS Department for Swajal Project, which is responsible for database management, software development, generating reports as required by the department itself, World Bank, State Government of Uttaranchal

Contact this candidate