Sap Basis Sql Server

VISHY KRISHNAMOORTHY IYER

*** ****** **** ******* ****, VA 23602 T: [757-***-****] Email: [********@*****.***] An accomplished IT Professional with 24 years of Experience in Various IT Field. Out of which 14+ years of SAP BASIS administration installation and about 11 years of Database Administration along with systems analysis and design, coding, help testers create testing scripts and help supporting database solutions to improve functionality. Exhibits excellent analytical and inter-personal skills to interact with end users and other team members. Proficient in an assortment of technologies and proven ability to implement technologies that decrease costs, increase performance and positively affect the bottom line. TECHNICAL SKILL

• Oracle RDBMS 7-19c

• SQL Server

• HP-UX

• Linux,Solaris,HPUX &

Windows

• SAP MDM

• Shell Scripting

• SAP AP R/3 4.7

• ECC6.0

• EP7.0

• Solution Manager 7.0-7.2

• Peoplesoft

• Various Java modules in SAP

• SAP MDM

• Oracle Enterprise Manager

• PL/SQL

• SAP BI

• TOAD

• SAP SCP

• SAP CLOUD Platform

PROFESSIONAL EXPERIENCE

Techtronic Industries Power Equipment Inc Anderson, South Carolina Sr SAP Basis Administrator/Architect May 2019 – Till Date. Techtronic Industries is a Power Equipment manufacturing with Sales in Home Depot and Walmart. It has more than 5000 employees located all over in United States.

Platform : Solaris, Sparc Servers, Oracle RDBMS 12c, 19c, Linux, VMWare SUSE Linux, SQL Server and AIX Worked on alerting of Linux, Solaris, SUSE Linux on Solution manager. Maintaining Solution Manager on HANA. Managing the backups HANA systems. Worked on moving the in house SAP to the cloud solutions (Initial Stages). Developed and worked with Developer on following Standard practice and writing standard practices. Worked on SAP upgrade from SAP ECC from EPH2 to EHP 4 and from EHP 4 to 8. Upgraded SAP BI/BW from 7.0 to 7.31 and 7.31 to 7.5. Apply support/Security packs as needed

Supported C4H and S4H for our Inhouse Project.

Worked on System Landscape Directory (SLD) used to connect system and transfer data. Used SAPCAR to extract data for files downloaded from SMP. In Depth SAP S4/HANA knowledge, backed with strong understanding of procedure and processes. Installed Vertex and connected with SAP.

Trained on AWS and AZURE. Took a class on AWS on AZURE. Migrated and Archived ECC to AWS.

Installing correction using SNOTE and upgrade using SPDD and SPAU. Trained and worked on HANA Installation.

SAP Migration/Archiving old data in ECC to cloud environment. SAP Project Management of upgrading SAP for EHP 4 to EHP 8 and SAP BW from 7.0 to 7.31 and 7.5. Archiving data for SAP ECC for more than 15 years from the system. Migrated the data from SAP to Archive system for space. Worked on the SAP Cloud in a SAAS environment. This was for E-commerce and Consumer portal environment. Administer and ensure that system service-level patches and backups are in place for all technical components related to the SAP solution.

Used Redwood to schedule Jobs.

Worked as a Team lead with team members in offshore and onshore. Provide operations support for SAP systems and technical infrastructure, including but not limited to transport administration and printer administration.

Performed Security analysis, design and implementation for various SAP Modules. Designed and implemented user access control and segregation of duties in Various SAP Modules Provided support for SAP Security role administration and governance processes. Developed and maintained SDAP Security policies, procedures and standards. Conducted SAP security training for end user and administrators. Collaborated with cross-functional teams to resolve SAP security-related issues. Performed SAP role maintenance and optimizations to ensure efficient access management. Contributed to the development and implementations of SAP security best practices. Installing and maintaining, SLT and ETL solution. Worked with the Solution teams on User and RFC connections. VISHY KRISHNAMOORTHY IYER

711 Casper Lane Newport News, VA 23602 T: [757-***-****] Email: [********@*****.***] Worked on Maintaining and customer support as needed for entire BI/BW/BODS/BOBJ/SLT and ETL solutions using Trigger based Replication

Upgrading Solution Manager from SP6 to SP10 and configuring EWA and System alerts. Completed Maintenance and tuned parameters for backing up HANA.s Troubleshooting issues in BASIS ECC and working with the Developer with the performance improvements. Upgraded Oracle on from various version to 12.2 on various systems and then upgraded it to 19.0 on Solaris and Linux. Upgraded SAP BW from SAP Netweaver 7.1 to 7.31.

Installed Netweaver systems and Sabrix application and did move sabrix system from Netweaver to JBOSS. Installed Netweaver systems and Taxware application. Maintained the Taxware system. Upgraded from ECC EHP4 to EPH8.s

Worked on Implementing LAMA on our environment but was not able to as the patches for LAMA environment was not available for Solaris at that time.

Installation and Configuration of LVM(LaMa) 2.1.

Configuring and Implementing Change Request Management (ChaRM) and TMS. Installed and implemented SAP Notes and during upgraded discarded the changes and accepted the changes from new package. Ferguson Enterprises Inc. Newport News, Virginia

Application Administrator/Lead SAP BASIS Administration December 2006- August 2018 Platform : Solaris, HP-UX, HP Superdome, Linux, Oracle (various Version), Oracle Appliance, VMWare, SQL Server and AIX Ferguson Enteprise is a Wholesaler/Retail in Plumbing, Lightening and other needs for the house with over 10000 employees located all over in United States.

Maintain, troubleshoot and worked with IBM Datastage environments, SOLR servers, Red Hat Datagrid, BPM and JON in various environments. Work with On call on a rotation basis and Maintenance weekend, F5 for the server Load balancing, installing and managing certificates, DBA’s bringing the average service time from 450ms to 70ms, and with Developers on issues with production issues. Deploy services in different environments and troubleshoot issues with the current production and nonproduction environments. Maintaining SAP XI, SAP GW and SAP ECC system. Conceptual Knowledge of SAP HANA. SAP MDM administration and helped developer with various day to day tasks. Maintaining patching ECC, XI and Solution Manager System 7.1.

Installed Redwood and moved all the jobs from SAP to Redwood. Knowledge on SAP MDG 7.0 SP02 Version.

Worked as a Team lead for more than 3 years.

Configured Data modeling, Process modeling, UI modeling for SAP MDG. knowledge of data quality tools like BODS. Administrator for ECC system and other modules like XI/PI, Solution Manager 7.1, SPM and BI application. Worked on various aspects of Security in ECC, IDM, PIPO, and PI modules.

Performed Security analysis, design and implementation for various SAP Modules. Designed and implemented user access control and segregation of duties in Various SAP Modules Provided support for SAP Security role administration and governance processes. Developed and maintained SDAP Security policies, procedures and standards. Assisted in SAP security audits and compliance assessments. Conducted SAP security training for end user and administrators. Collaborated with cross-functional teams to resolve SAP security-related issues. Performed SAP role maintenance and optimizations to ensure efficient access management. Contributed to the development and implementations of SAP security best practices. Used BRTOOLS extensively and supported various database aspects of projects, including monitoring and resizing Tablespace and managing backups. Staged environment in different modules and refreshed various systems from production to QA. Facilitated ECC system upgrades from Enhancement Pack 2 to 4 and fixed mixed issues using applicable SAP correction notes. Analyzed different logs and table locks and troubleshot connection to various API resources. Set up OSS connection as a fix and EWA Job on Solution manager, updated compliance weekly. Applied support packages and kernel update, SAP NOTES and performed client copy and client and related settings.

Handled printer setup and troubleshooting.

Extensive knowledge of SAP MDM Netweaver architecture. Helped the business in loading the large volume of data in SAP MDM and experienced in data handling in live project. Extensively co-ordinated on Testing of SAP MDM.

Installed Netweaver systems and Sabrix application and did move sabrix system from Netweaver to JBOSS. Upgraded the ECC system from EHP2 to EHP 4.

Monitored Java-based application using Wily Interscope. Installing and maintaining certificates on various ABAP and Java Systems. SAP Installation and Upgrade.

Conceptual knowledge of HANA and more than 12 year experience as Oracle DBA. Installed GRC on SAP Netweaver and configured various models with the help of Security Admins. Played a key role in rolling out the GRC 5.2 (Compliance Calibrator) to IT and Business. VISHY KRISHNAMOORTHY IYER

711 Casper Lane Newport News, VA 23602 T: [757-***-****] Email: [********@*****.***] Ferguson Enterprises Inc. Newport News, Virginia

Sr Oracle Database Administrator/SAP BASIS Admin/Peoplesoft Administrator March 2000 – December 2006 Ferguson Enteprise is a Wholesaler/Retail in Plumbing, Lightening and other needs for the house with over 10000 employees located all over in United States.

Platform : Solaris, HP-UX, HP Superdome, Linux, Sparc Servers, Oracle (various Version), Oracle Appliance, VMWare. Responsible for Datawarehouse database and actively involved in Development of the Datawarehouse with the size of 24 TB. Primary database administrator for the High Jump Database and was actively involved in the implementation and go-live of the project. Creating and supporting various databases and codes necessary for various projects. Helped in creating supporting RMAN script.

Worked and developed code using PL/SQL and maintaining the Datawarehouse. Working with the ETL team to develop SQL Loader scripts and Automating the loading of the ETL jobs. Responsible for the backup and restore of the databases. Upgraded the database to various version and applying security patches. Tuned various process which was taking a long time and got it works much faster. Performance tuning with various other application like Peoplesoft, Datastage etc. Prepared database performance adjustments, database security, and designing tables for service/application. Implemented improvements by working with system DBAs, and use trending analysis partnered with the development team working on identifying tuning opportunities to manage performance. Design database systems and make recommendations to improve the performance and efficiency of existing systems. Knowledge in installing and administering PeopleSoft Server elements like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker, SQL server, application and technical issues, configuring Workstations, Application Server, Process Scheduler, Tuxedo, Web Servers, PIA, Report Repository, Report Nodes for PeopleSoft applications. Apply updates, fixes, and tools patches and upgrading tools to higher versions.

PROJECTS

System Integration & Application Migration

Derived maximum benefit from information technology based on the current state of the art client/server technology blended with business operation & procedures suitable for the organization. Used Application System Integration for implementation of Enterprise Resource Planning systems.

• Re-engineered and simplified processes (for example - Bill Receivable with Excise Invoice of Dispatch System, Bill Payable with Purchase Order & Material Receipt, etc.).

• Generated delivery orders at corporate office were transferred to three other dispatching locations & excise invoices generated at three dispatching locations were also transferred to the corporate office and also booked into corporate F/A system using Oracle job scheduling & procedures.

• Developed the Integration of Office Automation (i.e. MS-Office) Package with user data in client or in Oracle Server.

• Generated application from various applications in different platforms (i.e. FoxPro, Clipper and Debase) and integrate into the final payroll which was in Oracle.

• The data for the same used to be loaded into Oracle via SQL Loader.

• Inquiry Processing & Order Acceptance.

• Captured and projected Customer Inquiry and Market Demand and Intelligence.

• Assist in the control and processing of the customer's Order Acceptance requirements to ensure prompt service to the customer.

• Excise system to distribute finished goods to customer satisfying various statutory requirements.

• Generate various MIS reports, enabling management to make strategic decisions. Also provide on-line capability to enter order details with product specification, delivery schedule, commercial terms, confirmation and subsequent release for production planning.

• Integrate system with production reporting, capacity planning, delivery order processing & dispatch.

• Financial Accounts: Satisfy organizational needs of this multi-profit center system and to migrate it from obsolescence

(IBM-1401 & AUTOCODER). The data validation & timely reporting are the main components. The smooth migration & parallel run was done with the help IBM-1401 simulator available in RSTS/E. This system consists of about 200 programs & various modules (like Sales, Purchase, General Accounts, Costing, Banking, and Finance).

• Online Accounts Receivable & Payable

• Payroll

• Delivery Order Processing & Multi-Point Distribution

• Material Management System

• Material Accounting

VISHY KRISHNAMOORTHY IYER

711 Casper Lane Newport News, VA 23602 T: [757-***-****] Email: [********@*****.***] Created and maintained snapshots between two geographically different locations (Mumbai and Tarapur) via satellite. Connected two databases using a database link on two servers located in the same premises. Created and tested a sample online replication option for the Dispatch System, which was a machine critical application. Used the @job function to program update of a few rows in a table at various locations.

Work Status

United States Citizen

Contact this candidate