Sap Basis Lead/manager Hana Osdb Migration Resume
Responsibilities:
- Extensive experience in SAP NetWeaver Administration and Oracle Database Administration. Worked on the capacity of Sr. SAP BASIS/NetWeaver Specialist & SAP Team Lead. My expertise in installation, configuration, and administration with a wide range of experience ranging from Windows to HP - Unix Admin and Oracle/DB2 to SQL DBA and as a SAP Basis Administrator
- Strong Oracle DBA Experience. Worked on Oracle11g, 10g, 9i, 8i, and 7.3, SQL Server & DB2, OS( AIX, Sun Solaris, HP & Linux, and Windows NT/2K, 2008 ) on Cluster environment. Oracle experience includes installation, upgrade/migrate, Backup and Recover, Performance Tuning, Recovery, Disaster Recovery, Creation & maintenance of Standby Database. Proficient in Analysis, Design, Development and Testing of Oracle Projects.
- SAP OS/DB migrations / UNICODE conversions of multiple projects. These include migration ranging from R/3 4.6C
- Proficient MS SQL/Oracle Server installation, configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC and trouble shooting.
- Experience with installation and maintenance of new dimension products such as BW, CRM, SRM, APO, SolMan and Net Weaver components such as EP, XI/PI, CRM, SRM, SEM, APO, LiveCache and BI7 on Windows 2003 server, Linux, HP-UX and AIX environments.
- Upgraded AS/400 (DB2) 4.6C to ECC 6.0 on HP-UX (Ora) & BW 3.5 to BI 7.
- Experience in Solution Manager - Implementation, Service Desk, CTS+, Change Request Management (ChaRM) and Monitoring functions, Solution Manager Diagnostics(SMD), Business Process Monitoring, EWA, Security Service Optimization, End-to-End Root Cause Analysis.
- Experience in all aspects of BASIS Administration including Client copy, client export, spool administration, system backup, Disaster Recovery, System/database copy, System refresh & CTS+, patches, Kernel upgrades, support packages, Add-on, CUA, Workload Analysis, CCMS monitoring, Performance Tuning.
- Diagnostic Ability - Ability to go to the core of the problem.
- Willing to learn & adapt to new challenges. Have excellent communications skills & strong interpersonal skills, self-motivated, a quick learner & team player. Posse’s excellent work ethics team oriented with strong analytical & leadership qualities.
- Gained solid project management skills with effective combination of balancing multiple priorities and innovative strategies to continually meet and exceed project objectives
- Excellent verbal, written communication and interpersonal skills. Ability to work both in teams and individually, interact with functional teams to get optimal system performance.
- Involved in SAP Security Administration & Authorization including activity groups, profile generator and central user administration.
TECHNICAL SKILLS
Application: SAP R/3, ECC 5.0 and SAP ERP 6.0 including Enhancement Package, Solution Manager, SAP NetWeaver BW, SAP CRM, Enterprise Portal, SCM, SRM, SCM(APO) XI/PI, NWDI etc.)
Operating System: AIX, HP-UNIX, Sun, Linux, Windows NT/2K, 2003.
Platforms: HP, IBM, DEC, SUN, COMPAQ, INTEL, ALPHA, DELL & IBM Compatible PC-AT.
RDBMS: MS SQL Server 7/2000/2005, Oracle 8i, 9i & 10g, DB2 9.7
Tools: /Packages Oralce RMAN, SAPDBA, BRtool SQL*PLUS, SVRMGRL, ENTERPRISE MANAGER, Tivoli, & VERITAS, the Guard, Net Screen, SSH Client, RAID 5 & RAID 1, Maestro, VNC, PcAnywhere.
PROFESSIONAL EXPERIENCE
Confidential
SAP BASIS Lead/Manager HANA OSDB Migration
Responsibilities:
- Have good implementation experience, an understanding of how the technology can drive value, project Management skills and an ability to communicate technical issues in a non-technical manner.
- Lead and managed migration of Carve out system to time line to meet customers need.
- Responsible for providing architecture guidance, solution development and product deployment of company managed solutions (Primarily within HANA architecture), architecture, security, and HA/DR components.
- Partner with Enterprise Architecture, technical and operational teams to make recommendations on preferred solutions.
- Communicate and advocate adherence to defined application architecture strategy.
- Develop solution architectures and roadmaps in conjunction with business process partners and strategy teams.
- Lead technical integration efforts for enterprise technologies and other SAP products such as SAP HANA
- Deliver on activities associated with Sizing, Scoping, Client Landscape Strategy, High Availability, and Disaster Recovery.
- Expanded current skill sets to new areas such as SAP HANA, BW Powered by SAP HANA, BI client tools, Data Services and Business Objects platform
- Scrutinized design for Integration aspects associated with BW, BW Powered by SAP HANA
- Served as the focal point for integration issues associated with SAP HANA
- Provided direction on Integration standards and guidelines associated with SAP HANA
- Maintained focus of, and strive to meet both team and individual metrics, including utilization and company profitability
- Designed (and build) of SAP HANA landscape solutions including connectivity across the SAP landscape
- HANA Landscape design & hardware Sizing & SLT replication configuration
- HANA server, client installation & configuration & security administration
- BW system copy, upgrade, Unicode conversion and ABAP & JAVA stack split/drop
- Good noledge of HANA in Memory computing, Massive parallel processing and data modeling improvements.
- Have good implementation experience, an understanding of how the technology can drive value, project Management skills and an ability to communicate technical issues in a non-technical manner.
- Implemented BW on HANA and Data Modeled, designed reporting & solutions in Warehouse environment.
- Experience in ETL (Extract, Transform and Load) noledge of SAP and NON-SAP data by using tool and writing SQL scripts
- Hana implementation strategy and proof of concept road map.
- Installation and configuration of ECC 6.0 EPH4, EP 7.0, BI 7.0 EHP1, PI 7.1 EHP1, Solman 7.x EHP1, BIA 7.0, Redwood in central and distributed environment.
- Updating Enhancement Packages of ECC6.0 EHP4 to EHP6 and NW 7.0 EHP1 to EHP2 for ABAP, JAVA and ABAP+JAVA stacks.
- EWA and Patch update by SUM.
- Configuring printers, maintenance optimizer in the Solution Manager.
- Oracle 10.2 Installations, patch sets and applying oracle patches.
- Managing team of 6 members and providing career counseling and trainings.
- SAP OS/DB migrations / UNICODE conversions of multiple projects. These include migration ranging from R/3 4.6C to ECC.
- Did sizing and source/target system layout to do the migration of 500GB to 14TB systems
- Performed OS Migration of the Entire R3Landscape(DEV,QAS and Production) from AIX 5.3 and Linux (RHEL5.4)
- Migrated SQL Server 2005 to Oracle 10.2.0.4 in cluster environment
- Performed Kernel Upgrade and Oracle Client Upgrade
Confidential
SAP Basis Lead
Responsibilities:
- Performed Data center and OS migration from Solaris 10 to Suse Linux 11using advanced migration tools to minimize downtime.
- Performed OS migration using Distribution monitor by distributing load on app servers along with parallel export/import with combination of table splitter and package splitter and unsorted export
- Involved in SAP TDMS installation, configuration and administration
- Monitored and managed ABAP & Java stacks using NWDI, SDM, JSPM, Visual Administrator and Configtool and CCMS.
- Monitoring TemSe (Print), Output devices, Standard housekeeping jobs, Batch and interface, Server, OS and Network
- Live cache configuration, maintenance including complete and delta refresh of cache.
- TREX and SLD administration and working with solution manager
- Checked Hanging processes, Terminated Updates, Aged enqueue locks, Instance Memory quality, CPU utilization, Network availability checks
- Applied Support packages stacks, plug-in, kernel upgrade, notes
- Monitoring TemSe (Print), Output devices, Standard housekeeping jobs, Batch and interface, Server, OS and Network
- Server availability checks, Disk storage (file systems) space usage check
- OS system messages checks, Database, Critical tables growth, system messages checks, workload analysis, Tablespace growth and fragmentation analysis, Transaction/redo logs checks
- Storage & File system utilization (capacity planning)
- Perform Startup and Shutdown, OSS bug search and fix application, technical management, Workflow technical management, Data Archiving Technical management, Hours Critical Issue Management, Critical Issue Management,
- Stopped and started the SAP systems including CI, Application and DB servers.
- Configured Transport management systems and Transported in BI, ECC, PI and portal.
- Server availability checks, Disk storage (file systems) space usage check
- OS system messages checks, Database, Critical tables growth, system messages checks, workload analysis, Tablespace growth and fragmentation analysis, Transaction/redo logs checks
- Checked Hanging processes, Terminated Updates, Aged enqueue locks, Instance Memory quality, CPU utilization, Network availability checks
- Server availability checks, Disk storage (file systems) space usage check
- OS system messages checks, Database, Critical tables growth, system messages checks, workload analysis, Tablespace growth and fragmentation analysis, Transaction/redo logs checks
- Storage & File system utilization (capacity planning)
- Perform Startup and Shutdown, OSS bug search and fix application, technical management, Workflow technical management, Data Archiving Technical management, Hours Critical Issue Management, Critical Issue Management,
- Troubleshooting of system errors and ABAP short dumps.
- Responsible for Data center migration
- Performed ECC 6.0 EHP 4 upgrade, which is ECC 6.0 SPS 15 to EHP4 SPS 03
- Performed BI 7.0 EHP 2 upgrade to BI 7.02, which is BI 7.0 SPS 22 to BI 7.02 SPS 05
- Provided support for ABAP developers, handled ABAP dictionary inconsistencies.
- Daily activities on the system like Transports, User Administration, monitoring locks, monitoring background jobs, backup and printer and spool issues.
- System copy to refresh on DEV and QAS servers for testing various Implementations.
- Configured Transport Management System, including CTS+
- Performed SAP System daily Monitoring, performance monitoring and tuning
- Performed kernel upgrades and implemented ABAP patches and java patches
- Performed client copies, local client copy and client export/import on various systems.
- Responsible for daily checks, monitoring unsuccessful logons, monitoring inactive users and locking inactive users in production system.
- Performed Database Administration, Table space administration, adding data file, monitoring archive logs, trace files, and log files for trouble shooting.
- Installation, configuration, patch management, transport management, upgrade and system support of ECC5.0 with BI and NetWeaver 2004 with dual stacks. Configuration of Solution manager 7.o and Oracle 9.2.0.6 and 10.2.0.4 environments.
- Clustering for high availability
- Implemented and configured SolMan solution and created and tested the RFC connections.
- Worked in the implementation of CTS+ and Charm to able to manage the transports.
- Supported in managing transport through TMS and Manual from one system to other.
- Involved in the implementation of SCM
- Helped team member in the implementation of Enhancement Patches.
Environment: ECC 6.0, NetWeaver 2004s WAS7, CRM, EP, BI 7.0, XI/PI, TDMS, SolMan 7, Oracle 10g RAC, SQL Server, Sun Solaris, Sun(Unix), Windows 2003.
Confidential
SAP Basis lead
Responsibilities:
- Implement SAP GRC and configuration of different components: like Risk Analysis and Remediation (RAR), Compliant User Provisioning (CUP), Enterprise Confidential Management (ERM) and Super user Privilege Management (SPM).
- MSSQL clustering, both Active - Passive and Active - Active
- Troubleshot SAP system and provided daily monitoring and administration support.
- Integrate with and coordinate across multiple teams to determine requirements necessary for implementation
- Managing the project progress and halping the other Basis team members and Infrastructure team.
- Migration from oracle ERP/Unix to SAP, SQL server/Windows and SAP, Oracle/Linux
- Define Client and instance strategy from sizing for the growth to number of instance needed for different applications and implementation of new workflow and transport routes.
- Extensive experience in Change management (STMS), Kernel upgrade, Support Package, Hot patches, Plug-Ins and OSS Notes application using SPAM/JSPM/NWDI/SAINT/SNOTE, Spool Administration and Batch Jobs Administration, Security and Authorizations and implemented SSL.
- Migrated transport request and troubleshoot transport and administered transport request, created transport request (customized and workbench).
- Maintained User Roles, Maintain Users with Data dependent Authorizations
- Changed profile parameters depending upon the requirement.
- Installed and Configured ECC, CTS+ with PI, BW, MDM, Portal, Solman, SCM, CRM, and Vertex.
- Installed SAP Web Dispatchers as load balancers for each portal allowing for rolling maintenance of the systems without downtime and configured them as URL filters for different hostnames.
- Responsible for daily support and administration of all portal instances: resolving issues, performance, content migration and maintenance upgrades.
- Configured Enhanced CTS (CTS+) to allow for transports of non-abap content (java applications controlled by NWDI and portal content transports) through standard SAP transports. This allows for combination of Dynpro apps and Portal content into a single transport to circumvent manual steps into production.
- Configured Solution Manager and Solution Manager Diagnostics (SMD) for Root Cause Analysis.
- Resolved issues to allow Early Watch Alert reports to include additional information for Java systems (Garbage collection, Wily Introscope data and Portal Activity reporting.
- Implemented Wily Enterprise Manager 8.0 and configured SMD to create Wily Introscope Agents remotely from SMD.
- Worked on Solution Manager Maintenance Optimizer to download and apply SP stack on sand box and Production Landscape.
- Setup the Solution Manager System Monitoring, Service Desk, ChaRM, CTS+, Business Process Monitoring, optimization, root cause analysis, collaboration and issue management
- Applied SAP notes on different systems depending upon requirement, Created logical systems, RFC connections, http connections and TCP/IP connections to other systems.
- Maintain the Java stacks using Configuration tool, Visual Administrator, Log viewer, NetWeaver Administrator NWA, and Wily Introscope, and deployed JAVA Support Packages, Enhancement Packages and patches using JSPM/SDM.
Environment: ECC 6.0, NetWeaver 2004s WAS7, EP, BI 7.0, XI/PI, SolMan 7, Oracle, SQL Server, Sun Solaris, Sun(Unix), Windows 2003.
Confidential
SAP Basis / NetWeaver Admin
Responsibilities:
- Upgraded BW 3.5 to BI 7.0 and SQL query tuning and partitioning.
- Performance tuning recommendation for the BW Early Watch report and supporting BI and deploying BI Accelerator.
- Installed DNS and configured DNS wizard to configure DNS
- Configured TCP/IP to use DNS
- Used PU12 is used for transferring HR Employee Master Data and Payroll data tool to halp cut a lot of coding and testing costs for dynamic actions, menus, organizational model, and authorizations.
- Installed and configured ECC 6, NetWeaver 2004s and its components EP 7, XI/PI, BI and Business systems SRM and CRM, SCM.
- Configured Web dispatcher, SSO, SLD, SLD, UME, and at portal level used System Landscape editor, applied patch BI CONT, establish connectivity JCo, configured com services through Config tool, and did performance tuning for BW/BI system.
- Responsible for SRM 4.0 DB refresh (Pre and Post) dat include activating and deactivating CUA system, Java uninstall and later install for Unicode system update and configured SRM portal applying support packs, configured SSO, and perform smoke test for SRM with Live Auction.
- Installed and configured NWDI. Creating tracks, domain and SLD configuration and Setting up connection to back end systems via system objects to ECC 6.0, BI 7. 0.
- Weekly worked on the issues EWR, error analysis and follow up early watch suggestions.
- Troubleshooting at OS level, worked on java tools like Config tool and Visual Admin.
- Supported and configured SAP Best practices for Grants Management Public sector experience
- Did change request management as per company process for different systems ECC and CRM, XI, SRM BI, SCM and Portal.
- Responsible for SAP Database performance tuning like monitoring the table space, backing up the database, checking CPU utilization and volume space utilization and Monitoring Servers and Work processors overview, troubleshooting of java at OS level.
- Migrated transport request and troubleshoot transport and administered transport request (ABAP and Enterprise portal), created transport request (customized and workbench).
- Applied SAP notes on different systems depending upon requirement, Created logical systems, RFC connections, and TCP/IP connections to other systems.
- Work on Solution Manager Maintenance Optimizer to download and apply SP stack on sand box.
- Configured and opened OSS connection through SAP router dat includes SAP R/3 support and HTTP connect and WTS, and drive OSS messages & IMG hierarchy.
- Run cold backups using backup utility for all sap systems using NETAPPS.
- Increased Table space depending upon requirement by using BRTOOLS.
- Schedule Dbcheck jobs and other standard jobs.
- Changed profile parameters depend upon requirement and bounce the system.
- Transferred large volume of data for batch and inventory details from SAP ECC to Oracle using XMII by using data size ranges up to 2 million and the method of communication (BAPI/IDOC/Web Services) to provide the optimum performance
- Reset CRM JVM cache to avoid overflow, checking queues and applied SAP note to avoid Queue hold for long time. qRFC monitor, Inbound and outbound IDOC administration.
- Create and maintain documentation related to production batch jobs.
- Experience with EMC software and hardware products experience (NAS, SAN, FC).
Environment: ECC 6.0, NetWeaver 2004s WAS7, EP 7.0(ESS, MSS), BW/ BI 7.0, XI/PI, Solution Manager 4, SMO, SMD, Business suit products like SRM 4.0, TREX,CRM 5.0, SCM, APO, Virsa 5.1, Live cache, Oracle 10 G, MAXDB, HP-UX 11.23
Confidential
SAP Basis/NetWeaver Admin
Responsibilities:
- Blue printing of SAP landscape with client instance strategy and rollout planning.
- Did troubleshooting at OS level, worked on java tools like Config tool and Visual Admin.
- SAP migration strategy from diversified environment like Oracle to SQL server/window.
- Generated key for SAP systems, registered SAP systems and configured to EWA and CCMS for various SAP systems using Solution Manager.
- Created documents for the backup recovery, performance tuning, final production environment, Disaster recovery, solution manager configuration, unit testing and performance metrics.
- Performed Kernel patch upgrade, Applied Support packages for both ABAP and JAVA stacks, Applied OSS notes to resolve development/correction issues.
- Performed online and offline backups and monthly system cloning instead of backups, verifying backups and monitoring DBA operation logs.
- Create and maintain documentation related to production batch jobs.
- Helped generating sufficient rights and roles for Solution Manager and assign to user for the creation of RFC connections between systems to talk to each other.
- Done installation of SAP with Oracle/SQL on sandbox & dev environment on multiple Machines, applied patches, & activated is-media.
- Configured printers, created users, and assigned roles.
- Installed patches and activated Component (IS Media)
- Created documents like; Performance tuning, backup recovery, disaster recovery and many more.
Environment: ECC 6.0, NetWeaver 2004s WAS7, EP 7.0, BW, BI 7.0, XI/PI 3.0, CRM 4.0, SCM 4/APO, Solution Manager 4.0, Oracle, HP-UX, SQL Server Windows.
Confidential
SAP Basis / NetWeaver Admin
Responsibilities:
- Installed and upgraded SAP systems (Central Instances, Application Servers).
- Planned and executed client exports and imports as well as copies from DEV to QAS and finally to PRD system to full life cycle implementation.
- Generated key for SAP systems, registered SAP systems and configured to EWA and CCMS for various SAP systems using Solution Manager
- Worked with windows team, to install and configure DNS service
- Configured DNS for Internet Access in Windows Server 2003
- Installed and configured DHCP server with windows team.
- Configured Correction Transport System and Transport Management System in the ECC 6.0 landscape configured to Solution Manager.
- Have done logical and physical data modeling using ERWIN, and the files layout to create and aggregate data to be loaded into the SAP BW program. Checked dat the aggregation is done properly and efficiently. Checked space requirement and query for the memory optimization.
- Installed and configured ECC 6, NetWeaver 2004s and its components EP 7, XI/PI, BI 7.0.
- Generated key for SAP systems, registered SAP systems and configured to EWA and CCMS for various SAP systems using Solution Manager.
- Devised and documented procedure for backups of R/3 & EP from all regular day-to-day basis jobs
- Setup and refined CCMS thresholds and parameters for system performance and resources.
- Prepared comprehensive client-specific documentation regarding system maintenance and installation configuration.
- Applied SAP Hot/Support Packages and OSS Messages when available from SAP for relevant release and assisted implementation team with testing.
- Executed standard system & housekeeping jobs and Management of Users, Authorizations, and Profiles
- Defined and configured CTS pipeline and implemented CTS procedures.
- Defined, configured and maintained the new STMS environment in 3.x, 4.x and 6.x
Environment: ECC 6.0, TREX, E-Recruiting, Oracle 10G, HP-UX.
Confidential
SAP Basis /Net Weaver Admin
Responsibilities:
- Completed full life cycle the installation of ECC 6.0, from design to, configuration & implementation stages.
- Have done space management by using Oracle and SAP.
- Installation of Solution Manager 3.2 configuring and setting up for monitoring
- Generating Early Watch Alerts for all SAP systems from Solution Manager.
- Daily & Periodic backups for SAP PROD, SAP DEV & SAP QAS systems
- Troubleshooting and Monitoring Inbound and Outbound Load, Memory areas, Performance trace analysis/diagnosis
- Provided regular maintenance of SAP R/3 landscape including client copies, performance tuning, Transports Management, Apply Support Packs
- Provided Basis and security support to their SAP landscape 4.6C and as part of upgrade team upgraded SAP R/3 system to Enterprise release 4.7.
- RFC monitoring/diagnosing issues and table buffering.
- Involved in installation of ECC 5.0 and Net Weaver 2004, Solution Manager 3.2 and BW 3.5.
- Setting up alerts and configuring SAP performance parameters.
- Applied all support packs and performed Kernel upgrades
- Contribute to the documentation for the various tasks dat we perform for daily monitoring and support
- SAP Performance Tuning & System Workload distribution
- Configured output devices, spool management activities using, authorizations of spool services, and troubleshooting
- Build new system for adding new countries in R/3, BW, CRM and SRM and transport all the changes from Build DEV System to Build QUA System
- Helping as a backup Basis admin for kernel patches, transports, daily sys-admin etc.
- Responsible for SAP Startup/Shutdown, Maintenance, responsible for preparing disaster/recovery plan.
- Involved in daily activities on the system like Transports, User Administration, monitoring locks, monitoring background jobs, backup and printer and spool issues.
- Involved in system copy to refresh on DEV and QAS servers for testing various Implementations.
- Worked on transports for transporting change requests from development to QAS and security systems.
- Responsible for daily checks, monitoring unsuccessful logons, monitoring inactive users and locking inactive users in production system.
- Performed Database Administration, Table space administration, adding data file, monitoring archive logs, trace files, and log files for trouble shooting.
Environment:ECC 5.0, SRM 4.0, NW 04, BW 3.5, XI 2.0, EP 6.0, SCM/APO 4.1, CRM 4.0, Live Cache 7.2, Solution Manager 3.2, Oracle 9i, HP-UX, Windows 2003
Confidential
SAP Basis Consultant
Responsibilities:
- Resolved incoming Level 1 and Level 2 Basis messages to support Bramasol’s existing customer base through OSS for mid-sized companies. The support included addressing several kinds of different Basis and even functional problems on different platforms and databases.
- Logged on to customer’s systems and providing them remote consulting and support via OSS.
- Installed, configured and managed CTS.
- System administration as needed for internal functions including staff-allocated PCs and laptops as well as all servers and network equipment.
- As-needed participation in customer consulting projects with respect to Basis related requirements.
- Installed CRM and Workplace for demonstration purpose.
- Worked closely with functional consultants for SD, MM, PP, FICO basis problems.
- Setting up internal SAP system security roles and profiles using profile generator. Hence created and maintained users according to the company requirements.
- Helped sales staff in answering technical questions and providing hardware-sizing assistance.
- Maintained and developed documentation.
- Supported users with operating system and commands usage questions, such as login process, permissions, auditing, accounting, passwords, and users. Trouble shooting problem solution on servers for LVM (Logical Volume Manager), File systems, Hard disk, Booting problems. Dealt with various file system, disk management and LED-error problems up to extent of solving the problem.
- Created new databases and maintained existing databases. Responsible for 100 Gig of data.
- Set up two boxes and created two DB2/UDB on AIX, Oracle on Windows NT and the other on HP-UX.
- Served as the DBA for a team of 4 database developers dat supported the Oracle Financials.
- Involved in performance fine-tuning of the queries/reports using PL/SQL & SQL Plus.
- Helped team members in writing efficient stored procedures/ packages/ triggers and give solutions to their Problems in software development activities.
Environnent: Oracle 8i, Oracle V 8.0.5, SQL*Plus, PL/SQL, SQL Server 7, T-SQL, HP/Compaq
