Data Analyst Lead Resume
SUMMARY:
- Performed HANA Migrations from Oracle, on ECC, PPM, and SRM landscapes with DMO.
- Performed HANA Homogenous system copy using SWPM tool.
- Performed HANA Revision upgrade and migration of HANA standalone Statics Server to built - in
- Index server service.
- Experience in performing HANA installation, configuration and Administration.
- Involved in HANA Administration and performance tuning by monitoring backups, CPU load, memory consumption, disk, log file and etc.
- Performed OSDB migration with database Oracle to Sybase ASE 15.7 and Operating system from AIX to Linux with SWPM.
- Lead in sizing, planning, testing and execution of Hardware Migration from IBM p740 to IBMp822 hardware for 6TB system.
- Experienced in SLT installation configuration, creating new schema and Administration.
- Knowledge in BOBJ Administration
- Experience in HANA DB using in reporting with Migration of Views, DU package
- Involved in the full cycle Implementation, Upgrade and Support of SAP R/3, ECC 5.0/6.0(EHP 4)/6.0 EHP5/6.0 EHP6, Solution Manager 7.1.
- Experience in Designing and building New System, System Copy, client copy and DB refresh using database backup/recovery and database import/export method.
- Experience in performing Installation, configuration and administration of Sybase database.
- Performed Sybase system refresh using restore-recovery method.
- Performed Sybase database patch upgrade.
- Having experience in using SUM tool for Applying Support Packs and upgrade.
- Involved in planning and implementing Upgrade from version SAP R/3 4.7 EE to version ECC 6.0.
- Configured Single Sign-on from Backend system to Portal system.
- Experienced in performing Oracle installation and Upgrade form oracle 10g (10.2.0.5) to 11g (11.2.0.3.0 ) and from oracle 11.2.0.3 to 11.2.0.4 on different Sap landscapes under AIX 6.1, AIX 7.1 and Solaris environment.
- Performed effective Load Balancing between multiple application server in SAP system through RFC, Logon group etc.
- Automated daily administrative activities like batch jobs, database monitoring, checking database growth and monitoring table spaces on the basis of alert generated solution manager and Tivoli.
- Experience in configuring and maintaining the transport management system (TMS)
- Involved in SAP Security with Creation Users, Roles, assigning roles using PFCG along
- With participating SAP auditing process and providing the supporting reports and documents.
- Responsible for day-to-day SAP basis administration and daily monitoring activities like analysing ABAP dumps, language installation, scheduling Background jobs update monitoring and alert monitors, system traces, lock entries, set alert threshold values and operation modes.
- Performed Table Reorganization in oracle 11g Online and Offline
- Worked on oracle database administration using BR*tools BRBACKUP, BRARCHIVE, BRRESTORE and BRRECOVERY.
- Expertise in OS administration, performing Kernel upgrades, Applying patches
- (Using SPAM/SAINT) to the system, Applying OSS Notes, Spool administration.
- Experience in oracle database analysis, performance tuning, and forecasting DB size and Storage requirement.
- Experience in using SAP applications on operating systems such as UNIX, AIX, Solaris, Linux, and Windows (2003, 2008) based servers.
- Experienced in installing enhancement packs (EHP), support packs/stacks OSS notes, patches and add-ons.
- Involved in scheduling backups, archives and restoring data when required and monitoring of processes, users, disk usage, hit ratio, buffer, swap memory, free table space and data consistency.
- Experience in setting up early watch reports, locating the critical issues and making necessary changes and applying support packages/stacks, oss note and add-ons.
- Spool administration like configuring printers and trouble-shooting, spool request, deleting old spool jobs and working with temse objects.
- Performance tuning such as monitoring the database, analyzing SAP memory management and analyzing SAP work processes.
- Performed java administration in Portal Applications using tools such as Visual Administrator, Config Tool, Net Weaver Administration and SLD.
- Comfortable working after-hours planned maintenance and24/7 on-callsupport model.
TECHNICAL SKILLS:
SAP Applications: ECC 6.0, EHP7, MDM & BW 7.0 EHP1, SAP PI 7.4 & NW 7.4, EHP1 and Solution Manger 7.0 EHP1 and 7.1, SRM 4.0, EP 7.4.BOBJ 4.1,BODS,SLT
Operating systems: Linux, AIX, Sun Solaris
Primary skill: SAP Net weaver Administration, OSDB Migration Installation, Upgrade, Migration and support.
Third Party Tools: Tax ware, VCOM, IXOS, etc.
Databases: SAP HANA, Sybase and Oracle
PROFESSIONAL EXPERIENCE:
Confidential
Data Analyst Lead
Responsibilities:
- Performing SLT installation configuration, creating new schema, creating customized tables field for the replication and Administration.
- Performing the BOBJ Administration including the user creation adding the roles and performance issues
- Performing HANA Administration
- HANA Administration & Using the HANA DB in reporting for Migration of Views, DU package.
Confidential
Programmer
Responsibilities:
- Creating roles, adding authorizations to users upon client requests.
- Background job maintenance, finding the reasons of failure and finding the appropriate solution to solve them and making sure
- SAP standard jobs running fine and operation modes maintenance and changing the profile parameters according to the requirement.
Confidential
Senior SAP Basis Consultant
Responsibilities:
- HANA installation, upgrade, configuration and Administration activities
- OSDB migration from Oracle to HANA with operating system AIX to Linux using DMO
- OSDB migration from Oracle to Sybase with operating system AIX to Linux using SWPM
- Performing Homogenous system copy for SAP HANA system using SWPM tool
- Responsible for Back-Recovery of the HANA Database through HANA studio
- Create and configure SLT (SAP landscape Transformation) in HANA.
- Performed installation and configuration of HANA Multitenant Database and converting the Single Container SAP HANA system to Multicontainer system.
- Performed HANA migration from SP11 to SP12
- Performed migration of HANA standalone Statics Server to the built in index server Statics Server service
- Performed HANA Revision upgrade
- Installation and configuration of Dynamic Tiering and Smart Data Streaming in SAP HANA systems
- Lead in sizing, planning and execution of Hardware migration of Muti TB SAP system from IBM p740 to IBM p822
- Installation and upgrade of the ECC 6.0, PI 7.4,Solution Manger, SRM etc.
- ECC 6.0 EHP 7 upgrade and Migration to HANA
- Performed Unicode conversion.
- Responsible for Installation, configuration and administration of Sybase database.
- Performed Sybase system refresh using restore-recovery method.
- Performed Sybase database patch upgrade.
- Involved in performing Oracle installation and Upgrade form oracle 10g (10.2.0.5) to 11g (11.2.0.3.0 ) and from oracle 11.2.0.3 to 11.2.0.4 on different Sap landscapes under AIX 6.1, AIX 7.1 and Solaris environment.
- Performing System copy, system refresh including all Pre and Post Activities within the given SLA
- Performance tuning of the SAP system through memory parameter tuning in
- Fixed intervals along with Oracle parameter tuning.
- Analyzing and forecasting DB size and growth with the intention of planning and ordering new/addition of SAN with Storage team
- Applying Support Pack and Add-on for SAP systems using SUM/SPAM/SAINT tool
- Analyzing and fixing the issue noticed by EWA alert and alert generated by Tivoli for the SAP and Database
- Responsible for day-to-day SAP basis administration and daily monitoring activities like analyzing ABAP dumps, language installation, scheduling Background jobs update
- Monitoring and alert monitors, system traces, lock entries, set alert threshold values and operation modes.
- Providing 24/7 Support for the production and handling high severity incident within the SLA with proper solution as and when require
Confidential
Senior SAP Basis Consultant
Responsibilities:
- OSDB Migration and Responsible for the preparation of approach as well as migration of existing SAP systems.
- Preparing estimation for the new systems required Hardware sizing and system Sizing aligning with functional/project team
- Heterogeneous system copy of SAP system using the database dump from the On-Premise landscape.
- Installation /Upgrade of the three system landscape of PPM, ECC & SRM.
- SAP Basis support for the issues with the end user testing before Go Live of the systems.
- Analyzing the DB and SAP dump, SAP and Database parameter tuning, analyzing the CPU and RAM usage and requirement
- Responsible for Oracle installation and Upgrade form oracle 10g(10.2.0.5) To 11g (11.2.0.3.0 ) and from oracle 11.2.0.3 to 11.2.0.4 on different Sap landscapes under AIX 6.1, AIX Configuration and Administration of third party tools like IXOS, VCOM and Tax ware etc.
- Responsible for day-to-day SAP basis administration and daily monitoring activities Like analyzing ABAP dumps, scheduling Background jobs update monitoring and alert monitors, system traces, lock entries, and set alert threshold values and operation modes.
- Language Installation/email configuration in the SAP systems
- Performed Table Reorganization in oracle 11g in online and offline
- Responsible for oracle database administration using BR*tools BRBACKUP, BRARCHIVE,
- Performing Mass Transports from OS level by writing scripts and through STMS during the monthly release and weekly release
- Responsible for Trouble shooting and Fixing the production issue reported by client through incident and email including Daily administrative activities such as alert, Monitoring, scheduling periodic jobs, background processing, R/3 buffer monitoring (CCMS), database monitoring and system logs
- Responsible for the database administration like backup, restore and recovery also collect and analyze all system monitoring data for recommendations and problem analysis.
- Defined and tested recovery scenarios, planned and executed database exports / imports and database copies to create new instances.
- Performed the post installation activities in DEV, QAS and PRD Systems in the System landscape.
- Configured SAP applications for RFC communications using sm59 and while integrating the managed systems in Solution Manager within the SMSY transaction.
- Responsible for the background job management, operation modes, SAP profile management, buffer management and transport management in SAP landscape and other areas in SAP basis administration
- Providing 24/7 Support for the production and handling high severity incident within the SLA with proper solution as and when require
Confidential
Senior Basis Administrator
Responsibilities:
- Responsible for scheduling client copies, scheduled outages of SAP servers, User management (Roles and Profiles) and Logon groups.
- Responsible for performing system copy and system refresh and Upgrades
- Performed the post installation activities in DEV, QAS and PRD Systems in the system landscape.
- Configured SAP applications for RFC communications using sm59 and while integrating the managed systems in Solution Manager within the SMSY transaction.
- Responsible for the background job management, operation modes, SAP
- Profile management, buffer management and transport management in SAP landscape and other areas in SAP basis administration.
- Monitoring the user ticket queue for production issues related to SAP security and user authorization problems using SU53 and system trace (ST01).
- Assign authorization groups to users.
- Analyze the user problems by using SU53, SUIM
- Database administration such as table space administration, adding data files if required using SAPDBA, reorganization of table spaces.
- Analyzing startup problems (Database R/3 and Additional instances).
- Created Clients defined Settings and performed client copies like Local and Remote client copy.
- Handling End-user related problems, Created Users and User groups. Providing Authorizations to the users using Activity Groups. Generated user related reports and submitted them to the management
- Responsible for database tuning and maintenance including planning and execution of system maintenance tasks, transportation of developments between environments.
- User maintenance, creating roles, adding authorizations to users upon client requests.
- Background job maintenance, finding the reasons of failure and finding the appropriate solution to solve them and making sure SAP standard jobs running fine and operation modes maintenance and changing the profile parameters according to the requirement.
- Involved in setting up the Transport Management System (TMS) and assist in troubleshooting the technical issues with transports.
Confidential
SAP Basis Consultant
Responsibilities:
- Configuring Transport System, Transporting requests from development system to the Quality Assurance, Production, and systems.
- Performed Installation and post installation activities in DEV, QAS and PRD Systems in the System Landscape
- Client creation, Client maintenance, User Administration, Creating single roles, composite roles, and Master and Derived roles.
- Configuring operation modes and profiles, working with BR tools for adding table spaces.
- Monitoring database by checking database performance, database locks and live cache monitoring.
- Monitoring system performance by checking load distribution and response times of the servers, availability of servers and work processes.
- Configuration system error log, ABAP/4 short dumps for problem analysis, executing reports for checking concurrent users working in the system, availability of the system and functioning of transport management system.
- Worked on the client's raised help desk tickets or cases. Over all following the client process, to solve the Global user problems.
- Background job maintenance, finding the reasons of failure and finding the appropriate solution to solve them and making sure SAP standard jobs running fine and operation modes maintenance and changing the profile parameters according to the requirement.
- Involved in setting up the Transport Management System (TMS) and assist in troubleshooting the technical issues with transports
- Monitoring and alert monitors, system traces, lock entries, set alert threshold values and operation modes.
Confidential
SAP Basis Consultant
Responsibilities:
- Monitoring and analyzing the system performance by checking load distribution and response times of the servers, availability of servers and work processes.
- Analyzing and checking database performance, database locks and live cache monitoring
- Fixing the system error log, ABAP/4 short dumps for problem analysis, executing reports for checking concurrent users working in the system, availability of the system and functioning of transport management system.
- Responsible for Trouble shooting and Fixing the production issue reported by client through incident and email including Daily administrative activities such as alert monitoring, scheduling periodic jobs, background processing, R/3 buffer monitoring (CCMS), database monitoring and system logs
- Responsible for the database administration like backup, restore and recovery also collect and analyze all system monitoring data for recommendations and problem analysis.
- Created Clients defined Settings and performed client copies like Local and Remote client copy.
- Responsible for database tuning and maintenance including planning and execution of system maintenance tasks, transportation of developments between environments.
- User maintenance, creating roles, adding authorizations to users upon client requests.
- Background job maintenance, finding the reasons of failure and finding the appropriate solution to solve them and making sure SAP standard jobs running fine and operation modes maintenance and changing the profile parameters according to the requirement.
Confidential
Software Consultant
Responsibilities:
- Creating the new system based on the requirement and making new enhancement to the existing system.
- Monitoring and analyzing the system performance by checking load distribution and response times of the servers, availability.
- Analyzing and checking database performance, database locks and live cache monitoring
- Fixing the system error log, ABAP/4 short dumps for problem analysis, executing reports for checking concurrent users working in the system, availability of the system and functioning of transport management system.
Confidential
Programmer
Responsibilities:
- Developing a web pages with using the programing language Java, JSP.
- Analyzing and checking Programing code and fixing the errors on the code.
- Fixing the system error log, for problem analysis, executing reports for checking concurrent users working in the system, availability of the system and functioning.
