SUMMARY:

• Senior Technical Architect (Basis/Security/VIRSA/SAP GRC10/Solution Manager(Trained)/Senior Oracle DBA for over 16 years of IT /Senior Mgmt in the design, deploy & administration of high - performance computing environments, databases and business critical ERP/DB applications.
• 3+ years SAP HANA (Vanilla Install, Uninstall, Register, Unregister, Re-name, Patching, Apply License, Client install, Studio Install, Lumira Install & Post-Install steps).(SPS00-SPS10)(LVMDB, hdblcm, hdblcmgui, hdblcmweb tools.
• Hana Patching(Down Load patch, System backup, Update patch Rev 62,72,82,92,94,96,Client update, Update ODBC files) using hdbupd tool.
• Multi-tenant Container(Install,Configuration,Disable Import,Export & Disable backups from tenant database,Enable/configure cross-data acess,Add/Delete additional Services,Configure web-dispatcher service,Configure/Restrict CPU,Memory to Tenant Databases,Start/stop tenant database,Drop Tenant database,cross db authorization) etc.,.
• Dynamic Tearing (Install ESS server using hdblcm,Config,Extended service,Extended storage,Extended tables,Segregation of Hot,Warm,Cold data)(Dbspaces-ES SYSTEM/ES TEMP/ES USER/ES DELTA).
• Smart Data Streaming(Install Plug-ins,Config,Data Sources,Streaming Projects,Adapters(managed,Un-managed,Replication Server Adopters, Data Destination,SDK Kit).
• Hana Patching (DMIS patching in Source system,LTR server, Co-ordinating with OS Patching,Hardware patching with Hardware vendors).
• Hana Replication Set-up sap and non-sap systems(DBCON entry,Database Triggers,Separate Tablespace creation,Configuration Naming, RFC set-up, create an RFC connection,Assign source & target systems, Transfer settings, Initial load of metadata tables DD02L, DD02T and DD08L, Load, Replicate, Stop Replication, Suspend, and Resume options).
• Hana Replication (Real-time, Schedule by time or interval method)(DMIS add-on install,LTR,BODS,Flat files,DXO,Smart Data access)
• Hana Migration Experience(Classical 2 step method,SUM with DMO option) from Net-weaver(BW clean-up, Upgrade BW 7.3 or higher, Dual Stack Split, Java stack Removal,ASU tool box,Upgrade with Near zero down-time).
• Hana Migration of NW BW, Business Suite(ERP,CRM,SCM,BPC),Pre-migration Tasks(ERP EHP7,CRM EHP3,SCM EHP3,Dual Stack Split,Java Instance removal,Java cleanup,Export dump,Import dump,Post install steps)BPC Migration-HANABPC,UJBR,BPC HANA MIGRATE FROM 10,SPRO to Enable Accelerator).
• Hana Sizing Design, Scale-up & Scale-out concepts (Upto 4 nodes).
• Hana Backup & Recovery set-up(Full,Incremental,Differential) & testing methodologies(SPS10)
• Hana HA(Host Auto-failover),System Replication(Enable,Register secondary system,Perform take over,performance optimized,Cost-optimized),DR setup(Storage Replication,SR).
• Hana Security(Authentication/Single Sign on, Authorization, Identity Store, Encryption,Audit Logging-sys log)
• Hana Security(BW on HANA Security Unification)(New user creation, creation of Roles, Assign Privileges directly to users, Assign privileges to roles, Assign roles to users,deletion of users,Lock & un-lock user accounts) & Hana Auditing.
• Hana Security (User name/password, SAML,Sap logon tickets,sso,Kerberos,IDM,BOE authentication mechanism,) using Hana Studio/hdbsql tools.
• Expert in Hana Performance monitoring/Tuning(Delta Merge,CPU,IO,Memory,Sql Tuning,Top Performance Sql Tracing)etc.,
• Hana Monitor (Start/stop,Day-to-day, Trace monitoring, Alert configuration, Email notify, Auto-restart,Sybase).
• Hana Parameter settings (Configuration Setting, Performance monitoring).
• Sap hana SP100 SDA set-up wih Apache Hadoop/Hartonworks/Hadoop Cluster(Ambari).
• SAP Basis/Security/VIRSA/SAP GRC10/Solution Manager/Transport/Wily Introscope for 8+ Years & Senior Oracle dba /Sql Server/DB2/MaxDB/Live cache for 15+ Years.
• ECC 6 install, EHP2/4/6/7 upgrade, performance tuning.
• Handling around 75 Consultants in current role.
• BOBJ(4.0),Patching,BODS(4.1),Configuration of Data services(DS)
• Sound knowledge Oracle 12c/11g Upgrade/Data Guard/RAC/ASM/Golden Gate.BI à BO & BI Accelerator
• Planned, Installed configured & implemented Business Objects XI 3.1, SAP Integration Toolkit for BI.
• Installed and configured LCM Life Cycle Manager for BO to have Version and Transport Management of objects in Windows integrating with BO installed under UNIX environment.
• Planned, Installed, Configured and Implemented Business Intelligence Accelerator TREX Engine for faster performance of BI queries accessing Info Cubes data on IBM Blade Appliance with SUSE Linux OS.
• Performance& Tuning of BIA by SAP OSS notes recommendations.
• Planning, configuring Backups & Restore, High Availability for BIA Blade Rack system with “GPFS” file system setup. Tested and simulate scenarios for BI - BIA integration.
• Applying patches or revisions to BIA, changing some of the OS shared memory parameters, Index Server, RFC servers Load Balancing .
• Setup and configure Alert and Monitor infrastructure for BIA.
• Integration of BO à BI à BIA.
• Configure Business Objects for High Availability in setting up the Apache Cluster, Tomcat Cluster and BO CMS Cluster implementing the in-session memory replication if any of the user sessions fails for Webi and Crystal Reports.
• Installed Configured and deployed BO Data Integrator, Data Federator, Data Manipulator and Citrix Rich Clients Xcelcius, Crystal Designer etc.XI 3.0 - PI 7.0
• Hardware sizing based Message Types/Sizes/XSLT mappings, JVM etc.
• Plan, Design, Architect and Configured XI Upgrade from 3.0 à PI 7.0 with Net weaver 2004s Dual Stack.
• Involved with Technical team to support in configuration of Integration Repository, Directory using Integration Builder tools for creating Scenarios, Processes, Mappings, Routing Rules, and Message Types etc.
• Support the configuration of Directory for Sender & Receiver determination rules, Interface rules etc.
• Configuring the Runtime Central Monitoring, Integration server Business Process, Integration and Central Adapter Engines à File, SOAP, JMS, Idoc’s, RFC, XI protocols. Adapter Framework using JCA.
• Configuration of Integration Server of XI to BizTalk HUB Web Services for E-commerce and Mainframe applications using SOAP, RFC, IDOC adapters.
• Upgraded to Unicode WebAs platform.
• Integrated with UME Portals& CMS for transports.
• Configured XI to Solution Manager as a Central Monitoring Infrastructure.
• Performance and tune XI Configuration and Tuning, JAVA VM, Database & Application tuning parameters using SAP related OSS notes.
• Load balancing for HTTP, RFC. Using SXMB ADM for tuning EO Inbound & Outbound parallel processing, Queues, and Performance Measurement etc.
• Good understanding of Oracle RAC
• Exposure in working on Service Ticketing System for support
• Good understanding Oracle Performance tuning tools like AWR/ADDM.
• Good understanding of Oracle VPD
• Installing and configuring Oracle Grid Control.
• SRM 7.0/5.0/4.0 install, upgrade & tuned the systems.
• BI 7.0 EHP1 installed on (abap+java) stacks and tuned the systems.
• CRM 7.0 EHP1 installed, Upgrade from 4.0 to 7.0 and tuned the systems.
• Solman 7.0 install/upgrade from 4.0 to 7.0, MOPZ setup, ccms monitoring.
• Portal 7.0 installs, tuning & configuration.
• PI 7.1/XI install (java+abap stack) along with SLD configuration.
• Specialist in SCM/Livecache/Optimizer installs,upgrades,support pack upgrades, tuning for SCM 5.0 & SCM 7.0
• Created SOP for change control process mgmt.
• Install & configured systems for NW 7.1 PI, SOLMAN 7.0 EHP1, BI 7.0 EHP4, ECC 6.0 EHP1, CRM 7.0 EHP4,EWM 7.1, SCM 7.1, Livecache 7.0, Optimizer 7.0,TREX 7.1, EP 7.1, EP Federated,SAP Hana/SAP GRC10 systems.
• E2E100 RCA, workload analysis, change diagnostics, end-to-end trace, exception, application &data inconsistency analysis & EWA alert setup.
• Helped in sap testing with Mercury load runner tool.
• Expert in setting up HACMP test scenarios & tested from Sand boxes, Dev & pre-prod and finally in Prod for clustered systems.
• Reduced Oracle DB backup times from 14 hrs to 3.0 hours.
• Reduced Oracle11g db size 18 TB to 5.5 TB using SAP archiving/Oracle11g Table/Index/LOB compression techniques and saved 700K-800K(Disk savings) and improved system performance by 400%.
• Worked in Sap security/Transports/VIRSA/SAP GRC10 tools.
• User Account Management & Overall User Role mgmt.
• Established Program Application Security processes and procedures.
• Migrated Vertex from 3.1 to 3.4 for new OMEGA project.
• Knowledge of SAP Boltons - Vertex, IXOS,BSI TAX,Vendavo.
• Automated Multi DB backup reports/DB Health check Reports/Space mgmt reports for Tablespace/Object level.
• Automated monthly vertex tax updates in multiple environments.
• Monitors clarify tickets related to SAP Application Security.
• Create and Manage SAP Security transports.
• Maintain Role / Plant /Position matrix/SOD violations.
• Implemented several new projects & Installed SAP/oracle DB.
• Reduced DB Tables/Index reorg time 10+ hours to less than 1hr & implemented fully on-line DB reorg methodology(10g,11g specific)
• Implemented proactive DB space alerts and proven for Zero failures.
• Proactive DB monitor/methodologies to improve client satisfaction.
• DB tablespace growth/table/index growth monitor to avoid any DB failures.
• Helped and trained several junior basis persons from on-site/off-shore by mentoring & creating several proactive documents.
• Implemented sap system refresh from PROD to TEST regular basis.
• Involved Transport mgmt & change management meetings regularly.
• Recognized for leadership in project planning, scheduling, prioritization, emergency response, contingency and risk planning.
• Proven track record of success in developing and deploying system solutions to improve IT and business operations efficiencies. Successfully setup and deployed global SAP ERP without business disruptions resulting in significant IT cost savings.
• Outstanding interpersonal skills to work and communicate at all levels of an organization and capable of building and mentoring highly technical teams.
• Broad knowledge of high-performance, high availability ERP/DB environments and integration of SAP/BI/SCM products into complex environments using enterprise, open-source and home-grown applications.

TECHNICAL SKILLS:

Technologies: SAP (ABAP/JAVA stack), R/3 4.x, ECC 6.0, BI 7.0, Sol man(Solution Manager 4.0), GRC(Governance, Risk and Compliance 7.0), IBM AIX5.X, IBM P-Series servers, IBM DS Storage, TSM ( Tivoli Storage Manager 5.x), Java, HP-Superdomes, Sun(E10K),Tru-64 alpha servers, j2EE, OEM ( 9/10 ), Oracle 9i/10g/11g/12C and MS SQL Server 2000/2005.

PM Tools: MS-Project/Visio/SharePoint/MS-Office suite (Excel, Word, PowerPoint, Access).

PROFESSIONAL EXPERIENCE:

SENIOR SAP(ERP) TECHNICAL ARCHITECT

Confidential

Responsibilities:

• Accountable business critical ERP (Sap Hana(SPS03-09),SAP R/3, DB), BOBJ(4.0)BI (SAP BI,BIA,Portal & SCM,)PI(7.0) & Integration systems (solman, &GRC), databases and in-house applications & third party applications like Redwood, Redwood CTS,vertex,ADS.
• Provides technical leadership and architectural guidance for system and technology upgrades both at primary and disaster recovery mirror sites.
• Provide back up support for HP-UX, IBM AIX and Oracle database administration.

Confidential, MARLBORO, MA

Senior SAP/DB Consultant (SAP BASIS/ORACLE DB/SQL SERVER)

Responsibilities:

• Accountable for several business critical ERP (SAP R/3, DB), BI (SAP BI, Portal & SCM) and Integration systems (SAP Solman, &GRC), databases and in-house applications.
• Provides technical leadership and architectural guidance for system and technology upgrades both at primary and disaster recovery mirror sites.
• Provide back up support for HP-UX, IBM AIX and Oracle database administration.

Confidential, DUBLIN, OH

Senior ERP(SAP)Administrator/Senior Oracle DBA

Responsibilities:

• Accountable for several business critical ERP (SAP R/3, DB), BI (SAP BI, Portal & SCM) and Integration systems (SAP Solman, &GRC), databases and in-house applications.
• Provides technical leadership and architectural guidance for system and technology upgrades both at primary and disaster recovery mirror sites.
• Provide back up support for TRU-64/HP-UX, IBM AIX and Oracle database administration.

Confidential, Columbus, OH.

Senior SAP BASIS Consultant/Senior Oracle DBA Consultant

Responsibilities:

• Perform daily system monitoring,/tuning/troubleshooting ensure optimum system performance/minimal system downtime of SAP system landscape.
• Review of early watch reports on weekly basis and implemented the changes required at OS, database and basis level.
• Installation of SAP support packages, kernel patches and add-on patches for the complete SAP landscape.
• Configured early watch reporting in all the SAP systems.
• Setup transport routes and transport management system for both ECC and BI landscape.
• Performed multiple system refresh/client copies for R/3 and ECC landscape.
• Upgraded from Oracle 9i à10G, 10g à11g from dev, qa & Prod databases.
• Implemented Oracle GRID control solutions for oracle 10g.
• Modified Oracle memory parameters to improve the overall DB health.
• DB Reorganization done to shrink the DB size by 400 GB.
• Improved SAP environment by implementing sap memory adjustment.
• Provided SAP development/customizations by indexes creation.
• Worked closely with SAP product development and support teams in bug fixes and enhancement by ABAP development team.
• Worked with SAP on Oracle 9i,10G, 11g in True-64/Solaris/AIX/HP-UX/Linux/Windows and windows environments too.

Confidential, COLUMBUS, OH

Senior SAP Basis/Senior Oracle DB Consultant

Responsibilities:

• Perform daily system monitoring, tuning and troubleshooting to ensure optimum system performance and minimal system downtime of the SAP system landscape.
• Review of early watch reports on weekly basis and implemented the changes required at OS, database and basis level.
• Installation of SAP support packages, kernel patches and add-on patches for the complete SAP landscape.
• Helped in sap testing with Mercury load runner tool.
• Upgrade several databases Oracle 9i to 10g from Dev, QA to prod Systems.
• Configured early watch reporting in all the SAP systems.
• Setup transport management system for both ECC and BI landscape.
• Performed system refresh and client copies for R/3 and ECC landscape.
• Implemented Rman backup strategies for Oracle databases
• Improved backup timings by tuning the Rman/DB parameters..
• Helped for solving the dev problems by tuning the SQL queries.
• Improved the overall client satisfaction by tuning the oracle memory parameters.

Confidential

Senior BASIS /Security/Transports/Senior Oracle DB Consultant

Responsibilities:

• Presented senior management for sap/oracle db tuning methodologies.
• Implemented SAP security methodologies’ and transport management too.
• Implemented SAP OSS notes to improve the sap and DB health in overall.
• Worked multiple projects with SAP on Oracle/SQL server systems.
• Helped in sap testing with Mercury load runner tool.
• Migrated/Upgraded several DB from Oracle 8i to Oracle 9i,10g databases.
• Improved DB performance by adjusting the oracle memory parameters.
• Implemented several proactive oracle DB space/extent mgmt methodologies.
• Implemented incremental backup methodologies to reduce the DB contention and overall improvement in the environment.

Confidential

SENIOR ORACLE DBA/Oracle Financials APP DBA

Responsibilities:

• Configured Oracle Tuning methodology for both 8i and 9I databases.
• Upgraded several databases from Oracle 8i to Oracle 9i.
• Implemented Oracle Enterprise Manager (OEM) to monitor the databases and configured the alerts for various database activities including backups.
• Implemented Oracle Data broker to monitor standby databases from OEM and configured alerts for the archive log ship delay.
• Regular DB refresh from PROD to TEST systems for supporting dev activities.
• Implemented Oracle database backups to run from standby databases using Oracle RMAN tool.
• Worked as Oracle Financials APP DBA in JURONG TOWN CORPORATION.