Sap Platform Architect Resume
TX
SUMMARY
- SAP Platform Architect with over 15 years experience in SAP Basis Netweaver & HANA Administration for HEC - HANA Enterprise Cloud
- Worked in various competitive Domains such as Fashion, Retail, Pharmaceuticals, Utilities, Oil and Gas, Telecom clients comprising of very huge landscapes.
- Implemented landscape for SAP Simple Finance S/4 Suite on HANA, performed ECC to SFIN Upgrades, worked on all versions of S/4 1503 on prem, 1511, 1610, 1709, 1909, 2020, 2021 in HEC
- Performed Partner configuration for SAP Solution Manager, Resolve integration in Hana Enterprise Cloud environment, Solution Manager reporting, Technical monitoring as per SAP - HANA Enterprise Cloud R & R guidelines.
- SAP HANA - installation, administration, Backup/Restores, revision Upgrades, DB refresh, performance tuning, and system integration to legacy systems, HANA Security and HANA data provisioning
- SAP BASIS - Strong Knowledge and Hands on experience on Technical Planning, Design and build include Firewall and Network design, Ports details, prepare high level Build documents and perform Installations, Upgrades, Dual stacksplit of SAP Netweaver systems, Data center Migration from Onpremise to HEC environment
- SAP Security - Experienced in providing many proven SAP best practices solutions for common SAP security support issues, GRC, SOX, Role Redesign, or other challenges.
- Plan and execute the encryption scenarios for application, DB and OS layers
- Install, Configure, integrate, maintain, upgrade SAP applications such as ECC 6.0 on Ehp8/SFIN, BIA 7.20, PO Java 7.5, SNC, S/4 HANA 1611, Best practices, CRM, xMII, Netweaver 7.5, BI Java, BI 7.5, Convergent Charging 4.0, SAP TM, SRM, SCM, GRC 10, BPC, SAP Solution Manager 7.1/7.2, TREX, BIP 4.2, BODS 4.2, Lumira 1.31, Hybris, Mobility -FIORI suite, Business-One 9.2 on HANA.
- Expertise in Kernel upgrades, apply SNOTES, OSS messages, SPAM/SAINT, SUM, SSO, SSL for certificates, JAVA Security, SWPM,JSPM, CTS+ configuration, NWA
- Technically fluent in Operating System (Unix/Linux/HPUX, AIX/Windows), Database - HANA/Oracle/ DB2 / SQL Server/ ASE/ MaxDB) administration and troubleshoot.
- Performed Homogeneous system copies with systems based on Oracle, MS-SQL,DB2, HANA databases
- Performed DB upgrades such as Version upgrades, cumulative patches, Fix packs/patches
- Performed DBA tasks of Backup & recovery strategy, Database Refresh, Database DR Setup for Physical and Stand by nodes
- Worked in SAP HANA cluster, scale up and scale out scenarios for Confidential, HP appliances.
- Monitor, Manage & troubleshoot issues for SLES HANA& Accelerator cluster running on GPFS 3.5/4.1 with IBMX5/X6-Series servers, HS22/23 blades, HP C500/C600 servers, manage servers from AMM for Confidential &ILO for HP, apply Firmware’s for Confidential SAN - DS3524 as bugs fix, check battery & power supply, raise PMH/PMR calls to Confidential support, GPFS upgrades,.
TECHNICAL SKILLS
Applications: ECC 6.0 with Ehp7, BI 7.4, Netweaver 7.4/7.5, XMII,CRM, SNC,TM 9, SRM, SCM 7.1, PI/PO 7.4 Java, BIA 7.20, Solman 7.1 SP14/7.2, BPC, BIP 4.2, BODS 4.1 SP7, Lumira 1.31, Hybris, GRC 10, BPC, CC 4.1
Operating Systems: SUSE Linux 11.4, RHEL 6.1/6.5/ 7.0, AIX, WIN 2012R2
RDBMS: Oracle 11g, DB2 10.5, SQL Server 2012/2014, HANA DB Sp10/11/12, Max DB
Tool: / Utilities Nagios, Opsview, HP Control Center, BR Tools, HANA Studio, Toad, Remedy, Vantive, SMClient, XCAT, AMM, ILO, Confidential Director
Cluster Software: GPFS, MSCS
PROFESSIONAL EXPERIENCE
Confidential, TX
SAP Platform Architect
Responsibilities:
- Work with SAP HANA Enterprise cloud delivery team and internal Levi teams on all Project deliverables with project planning and execution of each of the tasks involved with various teams.
- Prepare tasks list, identify gaps, plan mitigation, risks involved working with all project teams,
- Perform tasks of design, implementation and integration of SAP applications with S4HANA 2021, FIORI - FES 6.0 for S4HANA 2021, CARAB 4.0 SP03, SLT 3.0 SP02, Web dispatcher and Solution Manager 7.2 systems.
- Perform Security tasks of ABAP & HANA DB with compliance to Levi standards.
- Work with HEC teams to perform BASIS Administration tasks for system Copies, upgrade from 1809 to 1909 and until 2021, Remote Client Copy issues with/without site tables, Disaster Recovery test, Change and Transport System, Patches, EWA - Workload Analysis, etc,.
- Configure Fiori using webdispatcher to backend systems using Levi - OKTA SSO tool, work with HEC teams on F5 load balancing setup.
- Validate FIORI post configurations such as system alias, service activations, troubleshoot app/tile configuration issues for backend systems connectivity, certificates, Single Sign-on and SSL issues
- Performed GRC post configurations for embedded S4 application and scripts deployment from HANA content, setup connectivity from GRC client, fix certificates and Single Sign-on
- Setup end to end configuration for web dispatcher as reverse proxy to backend SAP application and HANA DB, SAP Analytics Cloud to HANA DB, cloud connector configurations.
- Discuss and work for implementation of connectivity from 3rd party tools used on customer onpremise to cloud for GRC, AD autantications using LDAP for SSO to applications and SAML2 configurations, ITIM to GRC, Service now to Charm, Troubleshoot Charm connectivity issues, etc,.
- Track adhoc requests, incident reporting for technical and functional teams to present to management.
- Perform configurations of OnPrem connectivity to cloud systems (Network, Connection setup, security)
- Discuss with HEC teams on application, database performance and Network & other infrastructure issues.
- Analyze and recommendHA and DR architecture, existing setup of applications and connectivity.
- Prepare documentation for tasks performed, provide recommendations for other teams on POC tasks performed.
- Provide timely updates to business, application and Project management teams on deliverables to meet.
- Track daily for tasks assigned to offshore with progress made, identify reasoning for delay and take measures to mitigate.
Confidential, Dallas, TX
SAP Senior Basis Consultant
Responsibilities:
- Prepare tasks list, identify gaps, plan mitigation, risks involved working with all project teams,
- Track daily for tasks assigned to offshore with progress made, identify reasoning for delay and take measures to mitigate.
- Implemented S/4 1809 and support SAP systems in all landscapes.
- Perform tasks of design, implementation (including security) and support applications with S4HANA, ECC, CRM, PO, FIORI and Solution Manager + Multiple full cycle implementations.
- Implementation and deployment of the Central User Administration (CUA) application for the entire SAP landscape.
- Prepare SAP Security and SAP HANA Authorizations, Security Role design and implement the strategy and troubleshooting connection issues.
- Develop SAP role and design, role/profile Generation and assign authorization, profiles.
- Validate SAP security tools to debug security the development, test and production.
- Develop Security and User Provisioning Strategies in alignment with SAP Best Practices and the business requirement.
- Provide solutions and fix issues in compliance and security audits
- Provide solutions and fix issues related to Security vulnerabilities in PCI compliance for SAP systems.
- Perform with User Administration, User Reconciliation and Custom Authorization Checks.
- Perform tasks in SAP HANA administration, installation, configurations, backup, restore, tenant database creation/monitoring, DB tools and SAP HANA upgrades and HA/DR setup.
- Perform BASIS Administration tasks such as system refresh, upgrades, Client Copy, Client export, Spool administration, System backup, Disaster Recovery, System/database copy, Change and Transport System, Patches, Kernel upgrades, support packages, Add-on, Workload Analysis, CCMS monitoring, BRTOOLS on ASM, Performance Tuning and Troubleshooting.
- Validate FIORI architecture & landscape by defining user security roles and SAP HANA DB multi-tenancy environment
- Analyze system performance & security, database performance and establishes OSS andEarlyWatchconnections where appropriate.
- Provide ongoing operational support to clients + Provide specific content pieces as assigned for RFP response.
Confidential, Denver
Senior Lead Architect (Project planning/Management)
Responsibilities:
- As Senior SME in Basis, mentored SAP Basis consultants in Operations/Build for various customer accounts
- Co-ordinate with Onsite & offshore leads for all SAP Basis related tasks in SAP Cloud - HEC
- Involve in Technical landscape Design, Sizing, Planning, and Implementation of SAP HANA in single /multitenant DB modes for Netweaver products on RHEL 6.x/7.x, SUSE 11.3/4 for Platform Edition. 1.0 SPS10 / SP11 and SP12 in HANA Enterprise Cloud offerings for Iaas, Haas, Paas programs of SAP.
- Design and Build Solution manager Partner system, S/4 HANA with Mobility applications in HANA Enterprise Cloud landscape
- Engage and work closely with SAP America on all Design and build strategies of SAP systems for HEC customers
- Prepare tasks list, identify gaps, plan mitigation, risks involved working with all project teams,
- Track daily for tasks assigned to offshore with progress made, identify reasoning for delay and take measures to mitigate.
- Implemented landscape for SAP Simple Finance S/4 Suite on HANA, performed ECC to SFIN Upgrades, worked on all versions of implementing S/4 1503 on prem, 1511, 1610, 1709 until S/4 1809, 1811 in HEC
- Performed upgrades for ECC to Simple Finance S/4 on HANA, Fiori on HANA, BIP /BODS 4.x on ASE, deploy HANA live components, supporting Mobility applications in retail/pharma/manufacturing domains
- Perform partner system configurations with Resolve.sap.com as incident management system
- Extensively worked on issues with Network design with details of Ports for Firewall rules, Design documents for server/File systems layout, Build documents for RHEL/SUSE Linux server requirements
- Performed install, upgrades for almost all SAP components on Redhat Linux/ SUSE 11 SP3/4 supporting SAP America clients
- Performed Business suite migration from customer On premise to CTL- HEC
- Sizing, configuration, implementation, installation of HANA on Multi tenancy with encryptions for Data mart and SLT systems with volumes of Data in TB’s and PB’s
- Performed Backup configurations using Backint for SAP HANA Hot backup using Netbackup for HEC customers
- Performed Backup configurations for Sybase - ASE DB using cronjob scripts and troubleshoot in case of issues
- Worked on SAP BI Suite (Lumria, BOBJ, BODS, Fiori) administration and troubleshooting tasks.
- Install and configure SAP applications on HANA database with Data volume encryption, scale out and replication enabled
- Performed Multi-tenancy HANA DB installations, SDA connections to external DB’s, performed data provisioning SLT installs and performance troubleshooting issues with table loading, etc,.
- Configured Replication between SAP HANA - DR sites with Data Volume Encryption enabled and OS level encryption of files with 3rd party companies, configured scale out scenarios for SAP HANA systems
- Work closely with SAP America MDC consultants, Platinum consultants on all issues for applications of BODS, BIP, BOBJ, HANA Live components, SFIN, Convergent Charging 4.0/4.1, HANA encryption, ECC Ehp7, GRC, CRM, SRM, TM, SCM/SNC, S/4, SLT, BI 7.4/7.5, BPC, Mobility -Fiori, Lumira, SAP Router -Solman, Business One-HANA, PI/PO on Sybase ASE DB, HANA DB in Central/ Distributed type of installations.
Confidential, Parsippany, NJ
Senior SAP Basis Consultant
Responsibilities:
- Designed customer Business objects landscape based on technical requirements
- Checked valid software’s & its licenses in place to build the applications in landscape
- Performed tasks of Install, configure Lumira 1.27 on BOBJ 4.1 SP5
- Performed tasks of Install Design studio on BOBJ 4.1 SP5
- Performed SSL configuration for encrypted autanticated security of certificates
- Troubleshoot performance & configuration issues for BOBJ, BPC on HANA systems
- OSS management tasks, router connection issues, BODS job configurations, etc,
- Solution &EWA setup for satellite systems in Solution Manager
Confidential, IL
SAP HANA Technical Architect
Responsibilities:
- Designed customer SAP technical landscape based on case study with business and functional teams
- Checked valid software’s & its licenses in place to build the applications in landscape
- Provided road map of the deployment and projected infrastructure challenges
- Interacted with Hardware vendors and SAP AG to understand issues in latest product releases
- Installed Solution Manager 7.1 SP13 with MS SQL Server 2012 SP1 CU7 on Windows 2012 Server
- System Preparation & Basic configuration, SLD & LMDB setup for Managed System configuration in SOLMAN 7.1, CHARM configuration
- Client and System maintenance including Client copy & system copy
- Built EHP7 for ECC 6.0 on HANA including SFINANCIALS 1.0
- Installed & Configured SAP Router 7.42 for remote support of SAP
- SUM upgrade of DIMP component 600 to 617 sp08
- Upgrade of S/4 HANA on to revision 96of HANA Database on SUSE Linux 11.3
- SUM Upgrade to SFINANCIALS 2.0/Simple edition 1503 SP1505 and its components
- Installed & Configured SAP Web dispatcher on SAP Router server
- Installed & configured SAP Netweaver Gateway 2.0 on Netweaver AS ABAP 7.4 on Sybase
- Integration of NW 7.4 AS ABAP with FIORI Suite for backend ECC system and external applications.
- Expertise in Kernel upgrades, apply SNOTES, OSS messages, SPAM/SAINT, SUM, SSO and SSL for certificates, JAVA Security, SWPM,JSPM, CTS+ configuration, NWA
- Register SAP systems in service market place and applying licenses.
- Solution &EWA setup for satellite systems in Solution Manager
- Configured Printers using SPAD and troubleshoot issues in spool management.
Confidential
Account / Technical SME
Responsibilities:
- Managed off shore team resources, train them in GPFS, blade server’s management and assign them to respective customer accounts.
- Co-ordinate with Onsite leads on all maintenances for upgrades as Firmware, application upgrades, data center migrations from customer DC to Confidential cloud
- Managed team size of 10 SAP Basis consultants leading tasks for SAP BW Accelerator Infrastructure management
- Performed tasks of SAP HANA Administration, Monitoring, Backup and Restore, Performance monitoring.
- Designed and implemented Backup and Recovery strategies for HANA database
- Upgraded HANA Database & its components from SPS06 to SPS07 (ie Version Upgrade from 63 to 70), SPS07 to SPS08
- Applying Single Support pack or Stack using HANA Lifecycle Manager (HLM)
- Maintain and monitor SAP applications such as ECC 6.0 on Ehp7, BI with BIA 7.20, PI 7.3 Java, SRM, TM, SCM, XMII 12.2, EP, GRC 10, SRM, BPC 10.1on Netweaver, Solution Manager 7.1, TREX, BIP 4.1, BODS
- Installed BW 7.3 SP 6 on HANA, Install BPC and its new HANABPC 800 add-on
- Turn the add-on in transaction SPRO
- Check appset, appshell in BPC, OSoft Web shell monitoring, Server diagnostics, BI process chains, BW performance check between applications, etc,.
- Dual stack split of BW 7.1 system and upgrade to BW 7.3 SP05
- Repair inconsistencies using SAP standard reports to migrate to HANA in traditional heterogeneous system copy.
- Performed tasks of SNOTES, OSS messages SPAM/SAINT,SUM,SWPM,JSPM, CTS+ configuration, NWA
- SLD Configuration, Diagnostic agent’s installations, SSO, SPNEGO & SSL configuration in NWA and backend systems along with applying licenses in Java systems.
- SAP Solution Manager checks for EWA analysis, Technical monitoring of managed systems, etc,.
- Apply Java support packs using JSPM and adjust JAVA parameters using Config tool.
- Performed test data migration procedure using TDMS technique.
- Monitoring of Netweaver systems and check their performance when out of memory issues occur.
- Performed SARA for SAP archiving jobs by setting variants for different Objects obtained from business and monitor them.
- Performed Homogeneous system copies with systems based on Oracle, MS-SQL,DB2 databases
- Performed Oracle version upgrades from 10g to 11g such as 10.2.0.4 to 11.2.0.2, and 11.2.0.2 to 11.2.0.4 on AIX, HP UX
- Performed DBA tasks of space management, instance management, DB restore using Oracle BRTOOLS
- Manage periodic Database & Log Backup’s to tape
- Performed System refresh for ECC, BW, SCM, CRM on DB2 Databases
- Performed theOracle failover test scenario’s for the DR setup
- Hands on experience in HANA infrastructure management for Confidential X Series Hardware - X5/X6
- Hands on experience on managing GPFS 3.5 Cluster software for nodes in Master/Slave configuration for HANA appliance
- Hands on experience on Confidential SAN - 3524, power & battery checks for HANA appliance.
- Monitoring of HANA landscape with alert monitoring tools of Nagios - Opsview.
- Performed DB2 fix pack upgrade and revision upgrade on AIX
- Managing & monitoring of the infrastructure using Confidential Flex Managers, Opsview, AMM’s, etc,.
- Document process and plan;perform maintenance activities with extensive co-ordination.
- Follow SLA procedures for ticket resolution; document RCA when business critical severity issues occur in SAP systems.
Confidential
Account / Technical SME
Responsibilities:
- Mentored leading 10 off shore team resources handling various SAP customer accounts
- Co-ordinate with Onsite leads for on all SAP applications maintenances upgrades, stack upgrades for servers in Confidential cloud/DC’s
- Participate in daily/weekly client review meetings to ensure service delivery with zero tolerance in SLA and RCA for business critical issues.
- Provide end to end support for SAP systems in the landscape such as Install, Integration, Support, Enhancement and migration in ECC 6.0 on Ehp7, BI with BIA 7.20, PI 7.3 Java, SCM Ehp1, Live Cache using MaxDB, EP, SRM, CRM 7.0, GRC 10, BPC 10.1on Netweaver, Solution Manager 7.1
- Installed 7.3 SP 6 on HANA, Install BPC and its new HANABPC 800 add-on
- Turn the add-on in transaction SPRO
- Check appset, appshell in BPC, OSoft Web shell monitoring, Server diagnostics, BI process chains, BW performance check between applications, etc,.
- Performed tasks of ABAP /Portal transports and XI transports.
- Perform transport using STMS, CG3Z, TP and Portal transports and troubleshot on occurrence of errors
- Expertise in Kernel upgrades, apply SNOTES, OSS messages, SPAM/SAINT,SUM,SWPM,JSPM,NWA
- Performed several system copy and system refresh as clone activities using SAP LVM and traditional methods.
- Performed Homogeneous system copies with systems based on Oracle, MS-SQL
- Performed Oracle version upgrades from 10g to 11g such as 10.2.0.4 to 11.2.0.2 on AIX
- Performed DBA tasks of space management, instance management, DB restore using Oracle BRTOOLS
- Manage periodic Database & Log Backup’s to tape and troubleshoot for issues reported.
- Performed System refresh for ECC, BW, SCM, CRM, SRM, EP applications on Oracle Databases
- Configured, manage& test Oracle Database DR Setup for Physical and Stand by nodes as Data Guard
- Performed tasks of Oracle Database compression techniques in Oracle using BRSPACE
- Perform system load balancing and periodically review table partitioning based on range and Hash.
- Performed OS/DB, Hardware migrations using traditional methods from Oracle to DB2.
- Support most of the databases such as Oracle,DB2, SQL, HANA, Max DB used in SAP landscape.
- Document the process and procedures to be followed in the project
- Participate in high level meetings to identify the bottlenecks in applications and help customer understand the challenges and overcome them.
Confidential, CA
Senior SAP Basis Consultant
Responsibilities:
- Mentored leading 5 off shore team resources handling various SAP customer accounts
- Co-ordinate with Onsite leads for on all SAP applications Installations, upgrades and Quarterly /annual maintenances for customers infrastructure in Cloud / DC.
- Perform tasks of Technical Solutioning of SAP products and involved in complete landscape build of SAP environment
- Installed SAP Netweaver components such as ECC 6.0 on Ehp6, BW 7.3, PI 7.3 Java, TM, SRM, SCM with SNC, XMII 12.2 on Netweaver 7.3, BI 7.3 Java, EP, BPC10on Netweaver, Solution Manager 7.1, in a distributed environment with MS SQL database.
- TMS&CTS+ configurations for ABAP & JAVA transports in SAP landscape
- Performed tasks of SNOTES, OSS messages SPAM/SAINT,SUM,SWPM,JSPM, CTS+ configuration, NWA
- SLD Configuration, Diagnostic agent’s installations, SSO, SPNEGO & SSL configuration in NWA and backend systems along with applying licenses in Java systems.
- Performed tasks of ABAP /Portal transports and XI transports.
- Perform transport using STMS, CG3Z, tp and Portal transports and troubleshot on occurrence of errors
- Apply Java support packs using JSPM and adjust JAVA parameters using Config tool.
- Backend system integration of SAP applications along with applying licenses in Java systems.
- Basic preparation, Technical system configuration, Managed systems configuration of satellite systems in Solution Manager.
- Solution preparation &EWA setup for satellite systems in Solution Manager
- Apply Java support packs using JSPM and adjust JAVA parameters using Config tool.
- Configured Printers using SPAD and troubleshoot issues in spool management.
- Follow process and document procedures for business deliverables.
Confidential, TX
Senior SAP Basis Consultant
Responsibilities:
- Mentored leading 4 off shore team resources handling various SAP customer accounts
- Co-ordinate with Onsite leads for on all SAP applications Installations, upgrades and Quarterly maintenance for customer infrastructure in Cloud / DC.
- Performed tasks of requirement gathering for building the SAP 3 systems landscape
- Installed SAP Netweaver components such as ECC 6.0 on Ehp6, BW 7.3, PI 7.3, BPC 10, SRM, SCM 7.0, EP 7.3,and Solution Manager 7.1 with Oracle database
- Technical Layout & Design of DR Setup of Production servers
- TMS&CTS+ configurations for ABAP & JAVA transports in SAP landscape
- Performed tasks of ABAP /Portal transports and XI transports.
- Perform transport using STMS, CG3Z, tp and Portal transports and troubleshot on occurrence of errors
- Performed tasks of SNOTES, OSS messages SPAM/SAINT,SUM,SWPM,JSPM, CTS+ configuration, NWA
- SLD Configuration, Diagnostic agent’s installations, SSO configuration in NWA and backend systems along with applying licenses in Java systems.
- Apply Java support packs using JSPM and adjust JAVA parameters using Config tool.
- Backend system integration of Portal applications using JCO connections, Functional UI configurations in NWA
- Register SAP systems in service market place and applying licenses.
- Basic preparation, Technical system configuration, Managed systems configuration of satellite systems in Solution Manager.
- Solution &EWA setup for satellite systems in Solution Manager
- Configured Printers using SPAD and troubleshoot issues in spool management.
- Apply Java support packs using JSPM and adjust JAVA parameters using Config tool.
- Follow process and document procedures for business deliverables.
Confidential
Senior SAP Basis Consultant
Responsibilities:
- Mentored leading 3 off shore team resources handling various SAP customer accounts
- Co-ordinate with Onsite leads for all SAP applications Installations, upgrades and Quarterly maintenance for customer infrastructure in Cloud / DC.
- Installations of Netweaver components such as ECC 6.0, BI, ADS, SRM, PI 7.1, and SCM 7.01 along with Live Cache in distributed environments for DB2 database.
- Performed tasks of DB2 database fix pack upgrades for SAP applications
- Backend integration and configuration of SAP applications with Portal systems.
- TMS&CTS configurations for ABAP & JAVA transports in SAP landscape.
- Performed tasks of ABAP /Portal transports and XI transports.
- Perform transport using STMS, CG3Z, tp and Portal transports and troubleshot on occurrence of errors
- Configured Printers using SPAD and troubleshoot issues in spool management.
- Extensively performed system copies using backup/restore and export/import methods.
- Extensively worked on System refresh activities on DB2 databases for SAP applications
- Performed EHP2 to EHP6 upgrades on ECC, Oracle upgrade from 10g to 11g
- Performed tasks of Oracle Database compression techniques in Oracle using BRSPACE
- Satellite systems preparation using SMSY and DSWP in Solution Manager
- Setup EWA for solutions created as SAP systems
- Database performance monitoring using DBA Cockpit to identify re-org checks on tables, runstats, DB6CONV for compressions,etc,.as on when performance impacted.
- Monitor JAVA performance using Wily Interscope, check file systems, traces,etc,.
- Expertise in Kernel upgrades, apply SNOTES, raising OSS messages, components/stack upgrade using SPAM/SAINT
- Follow SLA procedures for ticket resolution; document RCA when business critical severity issues occur in SAP systems.
Confidential, NJ
SAP Basis Administrator
Responsibilities:
- Performed DBA Cockpit activities such as Backup’s, Re-org/Runstats on tables, and DB6CONV for compression as on when performance impacted.
- Client and System maintenance including Client refresh /system refresh, Client copy, Client export/import
- Performed SAP support packages/stacks for components upgrade, components upgrade using SPAM/SAINT
- Performed Homogeneous system copies with systems based on Oracle, DB2 databases
- Performed Oracle Upgrades from 10.2.0.2 to 10.2.0.4 and 10.2.0.4 to 11.2.0.2 on AIX/Linux.
- Performed Oracle Database Compression techniques
- Perform backup/restore activities during system refresh and upgrade activities.
- Performed tasks of ABAP and JAVA transports, XI transports
- Performed SARA for SAP archiving jobs by setting variants for different Objects and monitoring them.
- Proactively respond to tickets from various ticketing tools such Tidal, Netcool, HP Quality Center and follow norms of SLA and adhere to all ITIL processes and documentation
- Manage Huge BW Accelerator infrastructure such as Confidential Blade servers using AMM on SUSE Linux, DS3524 and GPFS for clustered monitoring of physical and standby blades for SAP BW Administration
Confidential, Atlanta
SAP Basis Administrator
Responsibilities:
- Installation and Configuration of SAP Applications such as ECC 6.0, Solman 7, EP7
- Expertise in Kernel upgrades, apply SNOTES, raising OSS messages, components/stack upgrade using SPAM/SAINT for all Netweaver ABAP/JAVA
- Monitor and troubleshoot database issues related space management, backup and recovery, performance issues.
- Perform weekly tablespace re-org activity on regular maintenance outage.
- Perform backup/restore activities during system refresh and upgrade activities.
- Proactively respond to tickets from various ticketing tools such HPSC, Outlook, Tidal, Net cool, Mercury Quality Center and follow norms of SLA and adhere to all ITIL processes and documentation
- Client and System maintenance including Clientrefresh / system refresh, Client copy, Client export and import
- Performed SAP support packages/stacks for components upgrade, components upgrade using SPAM/SAINT
- Perform transport using STMS, CG3Z, tp and Portal transports and troubleshot on occurrence of errors
- Java monitoring using jcmon, web dispatcher, wily interscope.
- Performed maintenance activity of bouncing java servers on HA servers for clearing memory issues
- Configured Printers using SPAD and troubleshoot issues in spool management.
- Performed SARAfor SAP archiving jobs by setting variants for different Objects and monitoring them.
- Password management on monthly basis of all super users across clients on all SAP applications.
- Monitor and Maintain the BI application Blade servers (TREXADMIN) and their profile parameters and bounce the blades when parameters changes are done.
- Manage Huge BW Accelerator infrastructure such as Confidential Blade servers using AMM on SUSE Linux, DS3524 and GPFS for clustered monitoring of physical and standby blades for SAP BW Administration
Confidential, NJ
SAP Basis Administrator
Responsibilities:
- Performed DBA Cockpit activities such as monitoring Backup’s, Runstats on tables, and re-org on tables.
- Client and System maintenance including Client refresh / system refresh, Client copy, Client export and import
- Perform backup/restore activities during system refresh of application on MS SQL databases.
- Performed SAP support packages/stacks for components upgrade, components upgrade using SPAM/SAINT
- Perform transport using STMS, CG3Z, tp and Portal transports and troubleshot on occurrence of errors
- Performed tasks of ABAP using STMS and Portal transports
- Proactively respond to tickets from various ticketing tools such Tidal, Netcool, HP Quality Center and follow norms of SLA and adhere to all ITIL processes and documentation
Confidential, NY
Database Engineer
Responsibilities:
- Monitoring alert logs, space issues in database, backup and recovery issues in case of failure for production, development databases and SAP application databases.
- Created database and Schema objects as per developer's requirement, managing Tablespace for optimum performance of databases for application running on .net
- Perform system refresh, client copy & refresh activities as on when required for testing environment to the development and functional teams
- Applied Opatch/DB2 fix packs as per requirement and troubleshoot issues
- Planned space management and memory management of databases
- Refreshed, cloned and migrated Databases for .net applications
- Monitor the database jobs such as re-orgs of high data volume tables.
- Performance Tuning of production & development databases by collecting stats pack reports
- Kept track and planned database issues and resolved them proactively along with the team
- Created Snapshot reports through Asp.net application code for poorly performing SQLs and tuned the multi search engine complex queries to the optimized time
- Provided Oracle Database Administration support 24x7 as per client's requirement and suggested coding standards to developers
Confidential
Database Administrator
Responsibilities:
- Identified, resolved and provided solutions to different kinds of database performance issues
- Checked archive logs, alert logs, space issues of tablespace, traditional backups and tape drive backups, SQL tuning and generating reports
- Used software’s like Core Ftp, Leach Ftp and VNC viewer to connect to remote desktops
- Synchronized data and controlled quality of database
- Used SQL*Loader to dump data and check data consistency on standby server
- Generated stats pack reports to identify bottlenecks
- Provided 24x7 on call support for Oracle database administration activities for the application
- Participated in various workshops/meetings in bringing Quality data into the application from various Sales tax forms
- Provided monthly reports to clients of pending bills to be received by the Dept. and sent challans to customers
