SUMMARY:

• Over 18 years of experience in IT industry, this includes over 8 years of extensive work as Database Administrator and 12 years experience in SAP implementations, OS/DB Migrations, Upgrades(Version / EHP), Unicode Conversions and virtualization.
• SAP OS/DB Migration Certified Consultant - 6 projects
• SAP Certified HANA 1.0/2.0 SP06 version 67 Technology consultant and Live Experience
• Installation & configuration of SAP BPC 10.0 powered by BW on HANA 1.0
• Three OS/DB Migration projects. Informix 9.4/HP-UX - UDB DB2 9.5, RHL5, Sun Solaris/Oracle - MS SQL 2005/Win 2003 and Wind/MSSQL - Oracle/RHL
• All Unicode conversion projects involves with OS/DB migration methods. which are almost 8 Unicode projects.
• 8 Version Upgrades and Unicode conversion experience includes R/3 4.6C, R/3 4.7, ECC 6.00, BI 3.5. BI7.01, solution manager 3.2, and Solution manager 7.00, 7.01 and SCM, SRM.CRM.
• 5 EHP 5 upgrades on ECC 6.0 and EHP1 on BI, CRM, SRM, Solution manager and SCM etc.
• Data Migration of large databases over 9 TB using Distribution Monitor.
• Trained & guided technical team member on BASIS Implementation, development and maintenance projects using 4.5B, 4.6 B, 4.6C, 4.7EE, ECC 5.0 and ECC 6.0,CRM,SRM and SCM and Netweaver components.
• SAP Basis (Oracle DB) and HANA
• Expertise in IS utilities and FDA regulated Pharmaceuticals, Aero space, Food Industries
• Worked as Database Administrator on UDB DB2 on 256 partitions database, Oracle 10g, MS SQL 2008 R2. MaxDB, etc
• Clustering, High Availability, Disaster Recovery, Networks, Firewalls, ports, VIP, RIP, Proxies, Data Centers. Starting from Front End UI to the rock bottom of Disk/SAN, I was involved in providing technical solutions and facilitating potential infrastructure related solutions. Disaster recovery setups for databases UDB DB2, Oracle and MS SQL Server 2008.
• SAP ERP R/3 4.7, ECC 5/6, Business Objects 4.0, Data Services,GTS, SCM/APO (4.0/7.x), BW/BI, BWA/BIA, EWM, EP Enterprise Portal, Solution Manager, WebAS 640, NetWeaver 7.x/7.0.x, 640 WebAS, TDMS, DMIS, SAP router, Proxies, Web Dispatcher, SMD, hostagent, CCMS agents/monitoring, Solution Manager 7.1, HANA 1.0 SP3, TREX, VIRSA, GRC, Biller Direct, MaxDB, Oracle 9i/10G/11G, DB2 UDB 8.x, DB2 MVS, MS SQL Server 2000, IDOC, ALE, SMICM, ICF, SAP Print, STMS, CTS+, SSO, OSS, SAP Performance, HANA 1.0,
• Worked on Unix flavors AIX, HP-Itanium, HP-Parisc, Sun Solaris, SUSE Linux and Redhat Linux and windows 2008 R2, Windows 2003.
• Excellent written/verbal communication skills, positive work attitude/self-starter organized and detail oriented.

RELEVANT PROFESSIONAL EXPERIENCE:

Confidential, Ft. Lauderdale, FL

SAP HANA SP05 & SP06 Administrator

Responsibilities:

• IBM provided Hardware with Installed and configured SAP HANA 1.0 SP6.
• HDB version Info: 1.00.56.377318
• Adjusting the Configuration of SAP HANA 1.0 .INI files.
• Installed HANA Client components
• Installed SAP Studio Repository - Version: 1.0.64
• Adding systems and database users to the HANA studio.
• Modifying the system configuration settings using *.Ini files.
• Setting the global allocation limit Parameters like:
• Analyze and configure Database resident memory, system resident memory and used memory.
• Sizing the memory, considering Global allocation limit, service allocation limit and effective allocation limit. monitoring of status and resource usage of all system components like name server,index server etc.
• Backup of Data and log files.
• Built a shell script to automate the Backup of all HANA servers.
• Build and configured the HANA Database user creation.
• Installation of SAP Netweaver 7.3 system with SLT components.
• Configuration between HANA and SLT System. (ODBC connection setup)
• Installed MS SQL Server bit Database.
• Installed SAP NW 7.02 EHP2 64bit UNICODE System.
• Installed DMIS: Special SP05 for HANA with LT Rep Server 7.20EXT Kernel.
• Install HANA client and Studio on SLT server.
• Install SAP HANA Client and configure client environment variable path
• Configuration of ODBC connection between SLT and HANA system
• Configure SAP HANA Studio and Start LOADING and REPLICATION for Tables.
• Setup RFC connection between SAP and SAP System
• Installation of Oracle Instant client on SLT server for connecting to Oracle database 10.0.2.0
• Use of LTR, IUUC SYNC MON, MWBMON, LTRC for Monitoring and administration of SLT Dash board.
• Create HANA Schema in SLT System, Defined Data Transfer jobs using Tcode LTR
• Taking backup/recovery using HANA Studio.
• Starting and Stopping HANA DB Appliance Services during maintenance activity. starting and stopping of database services (nameserver, indexserver, statistics server, xsengine)
• Monitoring HANA DB systems CPU %, Performance, Disk volumes (Data & Log) and
• Alerts using HANA STUDIO.
• Adding SAP HANA Systems, Creating Users using HANA Studio.
• Installed SAP HANA Permanent License key using HANA STUDIO.
• Performed Source system Initial Data Load and Replication activities using HANA Studio. modifying of Configuration files *.ini .
• Analysis of RS ORDER,RS STATUS, RS RELICATION COMPONENTS etc table during the replication and initial load process.
• Execute HANA transports using delivery Units and export and import.
• Create and implement HANA Security on Development, Quality servers and Production servers..
• Data provisioning using Data services to SAP HANA 1.0 / 2.0
• Install and configure Data Services 4.1 on MS SQL 2008.
• Configure CMS for Data services.
• Install & configure Data services for SAP HANA
• Creation of data sources, data stores and ODBC connections.
• Define RFC server Interface on Data services 4.1 for connecting BW 3.5 system. connection setup between Data services and SAP HANA using data services designer. configured ODBC connection from SAP and NON-SAP source systems (Relational)to target server SAP HANA.
• BI security on Central management console.
• Creation of Folders,Applications, Connections, Groups, Access levels etc.
• User administration.
• Integration of Organization Active Directory with BI authentication method.
• Install and configure SBOP 10.0 powered by BW on HANA
• BPC 10.0 Installation & configuration on HANA with Nwyeaver 7.3 EHP1.
• Install netweaver 7.30 Enhancement package 1 and SPS 09
• Import ADD-on using SAINT - BI CONt 747 with SPS 04.
• Install Add-IN POASBS using SAINT.
• Install Add-in EPM.
• Import Add-on CPMBPC and HANABPC using SAINT..
• Activate ICF services, /sap/EPM BPC, /SAP/poa
• Activate BI content in RSA1
• Configuring the ABAP Server component program - UJS ACTIVATE Content to create the Environment Shell.
• Enable Accelerator make Namespaces and software components changeable like /CPMB, /ICPMB, /B28, /POA and CPMBPC etc.
• Create a Service user for BPC background processing.

Confidential, Lansing, Michigan

Basis Lead, Security, OS/DB Migration Admin

Responsibilities:

• SAP 4.7 System analysis for database size, Basis package level and other components using SPAM.
• Solution manager NW 7.00 SP15 - Analysis for ST component level and Basis component level for generating the STACK file for Upgrade.
• Analysis of Current Hardware and software and Sizing for new Hardware &software for ECC 6.0 EHP6 component.
• Upgrade SAP source kernel with 620 ( SAP de-supported in 2005) to 6.40 and upgrading the source database MSSQL 2000 to MSSQL 2005 and then starting the upgrade on 4.7 system with basis package 69 and MSSQL 2005(minimum requirement) to SAP ERP 6.0 Including EHP 6 based on Netweaver 7.0 Including Enhancement package 2 on MSSQL 2008 (R2).
• Import basis packages from SAPKB00041 to SAP KB0069 and SPAM tool using spam.
• Removal of DB02 inconsistencies, Delete SMQ1 and SMQ2 entries and unused RFC connections.
• Upgrade of solution manager from Nw7.00 to Nw 7.01 support pack 23.
• Generate upgrade Stack .xml file.
• Follow sap notes 1064635 and Unicode note 928729 and de-support of kernel 620.
• Download all needed upgrade and installation software for SAP R/3 4.7 system upgrade and ECC6.0 EHP6 sps01 packages.
• Execute CU&UC of SAP R/3 4.7 system to ECC 6.00 EHP 6 sps01 with NW7.02.
• Install and configure MS SQL 2008 R2 server on Windows 2008 R2 (64-bit) for ECC 6.00 ehp6 system.
• Migrate (OS/DB Migration) the upgraded system to new hardware and new software for DEV/QAS and sand box setup and Install cluster setup for high availability of SAP ECC 6.00 system during trail upgrades for Go-Live preparations..
• Implement post-upgrade, post-Unicode and post-installation steps.
• Data validation and consistency checks.
• RFC & printer setup, updating sap profiles and operation modes etc.
• Install new sap router.
• Minor sap security issues & fixes.
• Install New solution manager 7.1 on MS SQL 2008 R2 server and windows 2008 R2.
• Implemented RUNSap methodology and ITIL methods inoder to accomplish the Solman 7.1 configuration. configure new solution manager with basis preparation,
• Configure system preparation and managed system configuration using solman admin user id.
• Configure Technical Monitoring for all staellite systems with modifed KPI files.
• Synchronize LMDB database with SMSY information.
• Uninstall and Install host diagnostics agents.
• Execute diagnostic agents for polling the data. configure new sap router and router table entries.
• Performed SAP Basis and security audit of the whole SAP landscape
• Install and config the New content manager server 6.40 with MaxDB 7.6.
• Install New content server and cache server 6.40.
• Install MaxDB database Instance.
• Create repository for Content server & cache server using OACO, OACT.
• Administration of content server using CSAdmin
• Size the data volumes and log volumes.
• Install New DBN Gui tool for administration of MaxDB follow note: 386714 install SQL studio 7.6 ..
• Setup SAP DMS for the company Supported SAP environment running ECC, MM, SD and FICO, SCM
• Configure new DMS repository with the assistance from Learning solutions group.
• Execute OAC1 to migrate all the documents to new repository on new MaxDB server 7.6.
• Setting parameter for handling larger size documents - maxAllowedContentLength:150000000
• Deleting repositories based on sap note BIE QMM, BIE NET,HME CONTENT,ED,A2 and B2
• Modify the IIS configuration file to accept the large files by settings file filter size over 105MB.
• Migrate the documents from old repository to new repository based on Document Types in chunks. validation checks. implement transports, patches, notes on ECC as well on Solution manager.
• Setup company backup and restore polices and business continuity plan
• Compare the present SAP setup with best practices and recommendations from SAP and fix the issues. Fixed all the issues reported in Early watch report
• Designed and implemented policies for SAP environment

Confidential, St.Paul, Minneapolis

SAP Certified OS/DB Migration Consultant

Responsibilities:

• This is a Migration project for a an Aearo system, Migration is done from source SAP 4.7 R/3 Enterprise Ext set 2.00 Kernel 6.40 and Basis SAPKB00052 on Hp-UX/Informix 9.4 to UDB Db2 9.5 FP 8 / Red Hat Linux 5.0 .
• Analysis of the problem of successful export of the source Database Informix 9.4 by Off-shore basis team..
• As SME, analyzed the source system at SAP level from TABARTS(DB09L), tablespaces and data files perspective.
• Resolved the root cause for problem in exporting by finding 56 table spaces created without assigning any TABARTS to them.
• Advised/Suggested to the Implementor/client either to assign those 56 tablespaces to a TABART or to delete from the system after through discussion with Technical & functional team.
• Elimination of unwanted tablespaces from the source system.
• Make sure the DB02 is consistant.
• Install, config and setup of SAP ECC 6.0 EHP5 on UDB DB2 database version 9.7 FP8 on RHL 5.0.
• Installed and configured distribution Monitor for the parelle export and import of 4TB data using table split and package split procedure using 4 application servers.
• Post installation and Migration steps.

Confidential

SAP Basis/Upgrade Lead

Responsibilities:

• Advisor/Lead for the SAP Landscape Upgrade project for ECC 6.0, BI 7.00, CRM,SRM, SCM/APO.
• EHP 5 upgrade on ECC6.0 with EHP4 with HP-Itanium for CI and AIX for database Oracle 10.2.0.5.0..
• Execution of INCV on large table before the upgrade downtime.
• Make sure to eliminate the db02 in consistencies.
• Clean of RFC's, SMQ1, SMQ2, printer configuration.
• Optimizing the system for minimum downtime.
• Making runtime objects consistant with database objects.
• EHP 1 Upgrade on CRM, SRM, SCM/APO
• This is an upgrade of CRM 700 to CRM 701 - Enhancement package 1 (Basically EHP1 Installation on top of CRM 7.0 - CRM 7.01,
• BI 7.00 level 0008 - BI 7.02 level 8 (EHP2 Installation).
• System copy of SAP Landscape.
• Modify the profiles and printer configurations. installing BI 4.0 and data services as part of the Hana Project worked with DBA’s and OS admins and Hana developers.
• SAP Business Objects BI Platform 4.0 Installation with SP02
• Installed on MS SQL Server bit Database.
• Created two databases (one is for CMS and another one for Audit).
• Installed SAP Business Objects BI Platform 4.0
• Setting up CMS, Audit database, Repositories and user account.
• Configured Tomcat port and Performed Post installations steps.
• Installed Explorer 4.0 with SP02;
• Installed BI Platform 4.0 and Explorer 4.0 FIX PACK FP07.
• Create users and Roles in CMS.
• Install SAP HANA Client and create ODBC connection
• SAP Data Services 4.0 Installations with SP02
• Installed Information platform Services (IPS)
• Installed Data Services on IPS
• Installed SP02 and Hostfix for Data Services
• Installed SAP HANA Client Tool and create ODBC connection.
• This was done in a team of system administrators(hardware vendor), DBA's.
• Ensure that the all the satellite systems are configured correctly in SMSY.
• Execute MOPz for creating the solution for Upgrade.
• Generate Update Stack.xml file for all the satellite systems..
• Uninstall and Install host diagnostics agents.
• Execute diagnostic agents for polling the data.

Confidential, Memphis, Tennessee

SAP OS/DB Migration Consultant

Responsibilities:

• As part of separation, Confidential migrated BI3.5 on Oracle/Sun Solaris to MS SQL 2008 R2 on Windows R2.
• Client was unable to export the data from source system with Oracle on Sun Solaris. because of in correct name (starts with ~) and left over tables from previous upgrade.
• OS/DB Migration of BI 3.5 with SP17 on oracle/sun Solaris to MS SQL 2008 R2.
• Fixing DB02 inconsistencies.
• Delete unnecessary and unassociated table spaces.
• Splitting of large tables using table splitter and package splitting with Distribution Monitor deployed on multiple application servers.
• Installation of BI 3.5 on windows server with MS SQL 2008 R2.
• Export from source system using Table splitter and package splitter procedures.
• Install & import into target server.
• Post installation and migration tasks.
• Executed disaster recovery drill and documented the whole process
• CU & UC Bi 3.5 to BI 7.00
• Installation and configuration of BOBJ and BPC 7.5 server
• Download BPC 7.5 server executable form Market place.
• Create 3 BPC users ahead of the time in BW system. configure connection to BW server(backend)
• Connect BPC server with CMC database server, where user management is done.
• Create users and their roles in Central management console.
• BPC Microsoft 7.0 with MS SQL 2008 in DB Server and Application Server.
• Install client on BPC server for connecting to BPC server. configure BPC users and their roles in BOBJ Central management console export & import of users & their roles.
• Ensure that the all the satellite systems are configured correctly in SMSY.
• Execute MOPz for creating the solution for Upgrade.
• Generate Update Stack.xml file for all the BW satellite system..
• Execute all solman adminstrator tasks

Confidential, New Jersey

SAP Basis Consultant

Responsibilities:

• Upgrade ECC 6.0 SR3 sp14 to ECC 6.0 EHP5 with NW 7.02
• Generate Upgrade stack file using solution manager 7.01 sp 23
• Download all the upgrade software and support packages.
• Sizing the upgrade directory and data files sizes for target system.
• System copy of the dev/qas system for upgrading.
• Elimination of db02 inconsistencies.
• Clean Inbound and outbound queues. clean RFC and printer connections.
• Execute upgrade with "High resource " i.e. downtime minimized. post upgrade steps.
• Worked in Confidential in New jersey for systems migrations, upgrades, patching etc.
• Installed and configured ECC 6.0, BPC 7.5, SRM 7.0, SRM 5.5, SCM,, PLM, PI etc
• Worked on SAP security in ABAP and Netweaver Portal
• Installed and configured Netweaver 701, Netweaver CE, NW 2004 and 2004S
• Executed SAP instance migration, consolidation and segregation.
• Developed business continuity plans, backup and did the system copies
• Client copies and refreshes for different databases including MAXDB, SQL 2005 and 2008, DB2 and Oracle
• Worked on SAP servers on SLES 11 and Red Hat enterprise
• Document disaster recovery procedures
• Worked on Solution manager 4.0
• Designed, Installed, Configured maintained and monitor ECC6.0, BI 7, SRM 5.5, EP 7, PI and DWM environment
• SRM Installation for Allison transmission.
• Sizing Hardware requirements for SRM 7.02
• Install and config SAP SRM 7.02 in a cluster setup.
• Install and config TREX - search and classification Engine - 7.1.
• Create RFC connection to TREX to SRM.
• Post installation takes for SRM as per Install document
• SSO creation from portal configure the system in solution manager using SMSY.
• Installation and Configuration of PLM 7.0
• Installation and Configuration of TREX
• Integration of PLM with TREX and DMS solution manager 7.0 SPS 21
• Ensure that the all the satellite systems are configured correctly in SMSY.
• Execute MOPz for creating the solution for Upgrade.
• Generate Update Stack.xml file for all the ECC 6.0 satellite system.
• Download Upgrade software for target ECC system version enhancement packges with support packages.
• Download the Installation software for ECC 6.0 with PLM .
• Execute all solman adminstrator tasks

Confidential

SAP OS/DB Migration Consultant

Responsibilities:

• Hardware Sizing requirements for Oracle 10.2.0.4 on RHL 5.5 - target system source system: Windows 2008 with SQL server 2005
• Analyze the version of migration tools i.e. R3load, R3ldctl, R3trans.
• Download the Installation software for SAP ECC 6.00 on Oracle 10.2.0.4
• Download the Migration tools for source and target.
• Clean DB02 inconsistencies with Technical team. identify the top 25 largest files.
• Empty the SMQ1 and SMQ2 entries.
• Make sure no update records exist.
• Execute SMIGRATE CREATE DDL
• Deploy Distribution monitor for parallel export and import.
• Update and modify the distribution monitor command proerties file. create Package splitter and table splitter files.
• Install MSSQL client on application server to connect to source system.
• Install Oracle client on application server to connect to target system.
• Execute Distribution monitor in preparation mode.
• Execute Distribution monitor in export mode on all 3 application servers one after the other.
• Execute Distribution monitor in Import mode on all 3 application servers one after the other.
• .Verify the export and import status files.
• Verify the .TSK files for export and import. verify and validate the row count for some tables.
• Verify the log files for each .TSK files.
• Execute post migration tasks.
• Install and setup all third party software vertex, IXOS and UC4 Scheduler for transports.
• Configure STMS, printers and RFC's
• Add the system into Solution manager using SMSY.
• Developed business continuity plans, backup and did the system copies
• Client copies and refreshes
• Disaster recovery setup of target system oracle in a team of system administrators and DBA..

Confidential, Jacksonville, Florida

SAP Basis Lead

Responsibilities:

• Combined upgrade and Unicode conversion of Netweaver 2004 CRM 4.0 to CRM 7.0
• Analyze the current system for OS version, Database version, basis components and third party bolt-ons
• Prepare the stage system for system copy of the source systems during the upgrade project..
• Generate stack file for upgrade.
• Download the software and create the file system for upgrade directory.
• Execute CU & UC procedure on CRM with single code page.
• Clean DB02 inconsistencies with Technical team. identify the top 25 largest files.
• Empty the SMQ1 and SMQ2 entries.
• Make sure no update records exist.
• Execute SMIGRATE CREATE DDL
• Execute OS/DB migration on new target server.
• Post Unicode steps. setup and install third party tools like Redwood, BSI tax factory etc.
• Support the ongoing project of BI 7.00 for day to day problems. support BOBJ, CMC for BPC 7.5 administration.
• Analyze the version of migration tools i.e. R3load, R3ldctl, R3trans. database administration tasks like data block checksums, looking for alerts in logs, backup/recovery upgrade Oracle 10.2.0.2 to 10.2.0.5.0 using MOPATCH on SP Bundle patch..
• SAP Landscape Upgrade project for SAP R/3 4.7 system on UDB DB2 9.5 on AIX 5.3.2 to ECC 6.00 EHP2 on same operating system.
• Execution of INCV on large table before the upgrade downtime.
• Make sure to eliminate the db02 in consistencies.
• Clean of RFC's, SMQ1, SMQ2, printer configuration.
• Execute SMIGRATE CREATE DDL
• Tuning the DBM and DB profile parameters.
• Setting log archive and primary and secondary logs.
• Optimizing the system for minimum downtime.
• Making runtime objects consistent with database objects.
• System copy of SAP Landscape.
• Modify the profiles and printer configurations.
• SAP Landscape CU&UC Upgrade project for SAP R/3 4.7 system on MS SQL 2005 on windows 2003 server to ECC 6.00 EHP4 on MS SQL Server 2008 R2.
• Execution of INCV on large table before the upgrade downtime.
• Make sure to eliminate the db02 in consistencies.
• Execute SMIGRATE CREATE DDL
• Optimizing the system for minimum downtime.
• Making runtime objects consistent with database objects.
• Empty the SMQ1 and SMQ2 entries.
• Make sure no update records exist.
• Execute SMIGRATE CREATE DDL
• Execute UMG ADD PREP STEP, UCCHECK, SPUMG etc unicode, steps.
• Deploy Distribution monitor for parallel export and import.
• Update and modify the distribution monitor command proerties file. create Package splitter and table splitter files.
• Install MSSQL client on application server to connect to source system with MS SQL 2005.
• Install MS SQL client on application server to connect to target system with MS SQL server 2008 R2.
• Execute Distribution monitor in preparation mode.
• Execute Distribution monitor in export mode on all 2 application servers one after the other.
• Execute Distribution monitor in Import mode on all 3 application servers one after the other.
• Verify the export and import status files.
• Verify the .TSK files for export and import. verify and validate the row count for some tables.
• Verify the log files for each .TSK files.
• Execute post migration tasks.
• Execute BW POST MIGRATION
• Install and setup all third party software vertex, IXOS and UC4 Scheduler for transports.
• Configure STMS, printers and RFC's
• Add the system into Solution manager using SMSY
• System copy of SAP Landscape.
• Modify the profiles and printer configurations.
• Install Versa fire fighter
• Install A new schema for BSI
• Establish RFC connection to BW
• Developed business continuity plans, backup and did the system copies, Client copies and refreshes.
• Developed procedures of client copies, support package updates, TMS and CCMS setup

Confidential

SAP Basis Administrator

Responsibilities:

• Operating system: Windows 2003
• Database: SQL Server 2005
• Installed and configured Enterprise portal 6.0 on SQL Server 2005.
• 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, Assigning UME Roles, SLD Data Supplier Service, http service etc.
• BI upgrade from 3.5 to BI 7.00
• Upgrade BI 3.5 on windows 2008 to Bi 7.00 sql server 2008 . download and create Upgrade directory.
• Execute upgrade on Bi 3.5 to Bi 7.00
• Connect all source systems.
• Include the system in solution manager 7.00 configure STMS and printer configuration.
• Implemented advanced alerts in system for monitoring purposes using CCMS. Advance planning of system using system growth statistics. Working on Oracle database monitoring/performance and tuning issues.
• Worked on installing and maintaining SAP solutions manager 7.0
• Worked on Portal knowledge management and maintaining collaboration rooms
• Well versed in Client copies (Local and remote) and setting up transports and automating the processes
• Setup the backup schedules for the whole enterprise and developed business continuity plans