Sap Basis Lead Resume
Lead SAP Lead Basis/Architect
Executive Summary
- 6 yrs. of SAP Lead Basis/Architect.
- 14 years of SAP Basis Experience includes 10 years of Oracle/Informix DBA & UNIX SA.
- Participated in 4 full life-cycle successful implementations of SAP.
- Performed various Upgrades for R/3[3.x 4.x, ECC 5.0 & ECC 6.0 & EHP4], BW/BI [1.2, 2.0, 3.5, 7.0 EHP1], SCM [Live Cache 7.5.0, SCM 5.0, 7.0], CRM [4.0, 5.0, 7.0], Solution Manager [3.1, 3.2, 4.0, 7.0 EHP2].
- Planning, execution and implementation of Net Weaver Components [PI7.3, 7.1, MDM7.0, Portals(7.0EHP1), BW (7.0 EHP1)], SEM (3.0), SAP Workplace 2.11, ITS Server (2.1, 6.20, Integrated ITS6.40), CRM (4.1. 5.0, 7.0) and SRM (Enterprise Buyers Professional 4.0 with Business Connector BBP), BO XI 3.1 SP4, BO 4.0.
- Involved in SAN implementation by coordinating with UNIX and Storage specialists in terms of database physical disk layout, FDDI private network between application and database servers, Central Instance and DB split for high performance for SAP systems with RAID 0+1 configuration. High-availability [Fail Over] implementation for all Production systems.
- Refresh Test, Training and Sandbox systems from Production for regular R/3 systems, as well as BW, SCM, CRM, XI etc. Having both ABAP and JAVA stack.
- Planning, install and implementing SM, CMS for Java, TMS for ABAP, CUA 6.40, SLD on dev and prod Server to access systems in different landscapes for Security, Transporting changes, monitoring systems. Set up TMS for sending transports from non-Unicode to Unicode.
SAP Technical Summary
Hardware & Operating Systems
IBM P595, LPARS, IBM RS/6000
HP-8440, 2620 (Super Dome, N-Class, V-Class, L-Class, K-Class), ProLiance.
SUN (M5000, E-3000, E-4500, E-6500, E10K, E25K)
Windows 2003 Server SP2.
Solaris (2.5.1, 2.6, 2.7, 2.8, Solaris9, Solaris10),
HP-UX (10.x, 11.x),
AIX (3.1, 3.2, 4.3, 5.3, 6.0).
SAN (Storage Area Network), High-Availability & Disaster Recovery
VERITAS Cluster Software, MC-Service Guard, IBM HACMP.Oracle & Informix Réplication Server, EMC SRDF. EMC Storage VMAX, DMX4 Series, CLARION, (3900, 3700, Time Finder, Power-Path, SRDF.), Seagate Xiotech.
System Tools
HP-Omni Back-II, VERITAS Net Backup, BMC (SQL-Backtrack, Patrol for Oracle/Informix, SAP R/3, Platinum (DB-Enterprise, DB-Desktop), Legato, Oracle (Enterprise Manager), Archipelago, AutoSys, Maestro (Background Jobs), Dazel (Printing), EDI Gentran, Taxware, FedEx, Vertex.
Professional Experience and Certifications
- PI 7.1 Technical Training from SAP.
- Net weaver Basis SAP Academy.
- Solution Manager 7.0
Project Experience
Client: Confidential
Projects: Multiple Projects [Technical Upgrade to ECC 6.0, Enhancement Pack 4, HA, DR]. PI 7.1, 7.3 , EP 7.0 7.0EHP1, 7.3 , Business Objects3.x. 4.0 , BIA, BW 7.0, 7.3, GTS, PPM 5.0, SCM 7.0.
Hardware Virtualization, Storage Migration from IBM to EMC, Hardware Migration from AIX to Red Hat Linux.
Role: SAP Basis Lead/Architect
Duration: Apr 2009 – Present
Environment:
SAP Systems: ERP 4.0, ECC 6.0, CRM 5.0 & 7.0, SRM 5.0, BI 7.0, Portal 7.0, PI 7.1, Solution Manager 7.1 EHP2, BO 3.1 SP3, BO 4.0
Production Servers for CI and DB: IBM P595 Series – LPARS, AIX 5.3, 6.0
Database Servers: DB2-UDB 9.0, 9.5 Oracle 10G, SQL Server 2008
Storage: IBM Storage RAID 5, EMC VMAX. DMX 4 – RAID 1+0, EMC Time Finder, Power Path.
Infrastructure Projects:
- Design, architect, deploy new SAP implementations, upgrades, migrations, conversions, Virtualization, Cloud computing etc.
- DataCenter Migration from Texas to VA[All Production ERP systems à SAP, PeopleSoft, Lawson, JDEdwards] and IL[All Non-production systems] which includes Optimization SAP on Cloud Infrastructure[Working sessions with SAP, VMware, EMC].
- Leveraging the EMC Storage Technology VMAX series, Tools à Networker, RM (Replication Manager), Intelligent Cloning for Dual Stack and Single Stack SAP Systems, EDL for Backup and Recovery.
- Implement and Deploy projects and production support for various complex SAP Landscapes for ECC, BI, CRM, SRM, Portal, PI, MDM, GTS, SCM and many Third party tools and Bolt-on’s.
- Hardware consolidation and OS/DB Migration from IBM/DB2 to Linux/Aix/Oracle.
Application Projects:
ECC 6.0 EHP5
- Upgraded ERP 2004 to ECC 6.0 EHP5 using Downtime minimized method. Includes all Bolt-on’s, Third Party Interfaces à Vertex, Tidal, Redwood, IXOS, IBUY, Solumina etc.
- Multiple implementations/releases for PI7.1. Technical Configuration of Integration Engine [BPE, Integration Server Engine, Adapter Engine]. Troubleshoot, EWR implementation for PI Landscape in terms of performance related to Queues, Adapter Framework etc. Upgrade of PI 7.1 to 7.1EHP1.
- Support for all the Landscapes ECC, CRM, SRM, BI [BO, BIA], EP, PI etc.
- Work on Issues, Planned Outages [Infrastructure related], Unplanned Outages. HA and DR setup.
- Time Keeping Projects, BO-BIA setup for BI Landscape, PI Interfaces to ECC, and CRM from non-sap using ABAP Proxy runtime, SOAP, File, IDOC adapters.
- Performance & Tuning following Early Watch Reports from SAP.
- Prepare, Plan, Installed Enhancement Pack 4 using Enhancement Pack Installer in ECC Landscape for FSCM.
- Data Center Consolidation, Hardware Migration from HP to IBM [AIX 6.0 à LPAR’s] on IBM P595 series.
- High Availability, Disaster Recovery setup for all Production systems.
PORTAL7.0, EHP1, 7.3 Upgrade
- Re-Sizing, Re-Architect Portal Landscape to accommodate 160,000 users with 8 Application servers and 32 server nodes using SAP JVM.
- Worked with SAP TCC à Technical Core Competence, Safeguarding Services TIC à Technical Integration Check, VTO à Volume Test Optimization to get better performance for multiple users and sessions.
- Strategize the External and Internal Portals with Federation concept incorporating enterprise wide SSO, SSL using SAML 2.0 features.
- Implement the Load balancing using both Hardware [DSS Switch], Software [Multiple Web Dispatchers to backend systems for ECC, CRM, BW, BO etc.], integrating with Site minder.
- Time Keeping, ESS/MSS [XSS], Business Packages for SRM, CRM, BO, PPM, GTS etc.
- JVM Switch from IBM JVM to SAP JVM for 64-bit architecture with Java Heap Sizes to 8gig.
- Web Dynpro application using JCo destinations to the backend systems.
- Mobile Blackberry applications implementations.
- Technical Upgrade from 7.0 à 7.0 EHP1 à 7.3.
- Applied lot of Portal OSS notes for Performance, Application and database related.
PI 7.1, 7.3
- Sizing, Design, Architect, Installation and Deployment of PI module.
- Re-sized, Re-architecture, Federated the PI landscape to support 450 Interfaces & 800 communication channels that includes à Third Party adapters [PeopleSoft, SeeBurger, and WindChill] and JDBC drivers for DB2, Oracle and M SQLServer.
- Install and Configure PI for Load balancing, Non-Central Adapter Engine, JMS on separate servers for optimal performance.
- Multiple implementations/releases for PI7.1. Upgrade PI 7.1 to 7.3 for new features, enhancements etc.
- Technical Configuration of Integration Engine [BPE, Integration Server Engine, Adapter Engine]. Troubleshoot, EWR implementation for PI Landscape in terms of performance related to Queues, Adapter Framework etc. Upgrade of PI 7.1 to 7.3 SPS3.
- Lot of troubleshooting issues with ABAP & JAVA Stack related adapters à IDOC, Abap Proxy, JDBC, JMS, RFC, SOAP, FILE, MAIL etc.
- Multiple go-lives of PI in phased out approach.
- Upgraded PI from PI 7.1 à PI 7.3 SPS2. Worked on lot of issues, troubleshoot Integration Engine, Adapter Engine, Third Party Adapters[PeopleSoft, Seeburger, Windchill etc.].
- Implemented Load Balancing using both Hardware[DSS Switch] and Software[Web Dispatcher].
- Application PI tuning in terms of IDOC packaging, Message Prioritization, Message Packaging,
- SSO & SSL configuration for the adapters and interfaces.
CRM 7.0
- Architect and Deploy CRM 7.0 implementing the Functional components IPC, E-Marketing, E-Service, Sales, Interaction Center.
- Install, configure CRM-ABAP and CRM-JAVA on separate hosts with Heterogeneous environment à Database on HP-UX and application on Red Hat Linux.
- Configure CRM-Middleware to integrate with backend ECC.
- Plan, setup and configure HA and DR.
- Performance and Tuning of CRM application.
BW, BIA and BO Integration with BI and Portals
- Plan, Architect, Install and Implement Five Complex Business Objects landscape [BO Enterprise Engine, Tomcat Server 5.5, SAP XI Integration Tool kit, SAP Java Connector]. BOD, BOQ and BOP. Data Federator 3.0, Data Integrator, Rich Clients [WebI, Desktop Intelligence, QaaWs, Xcelcius, Data Federator Designer, Universe Designer.
- Architect, design, Install, configure 5 BO landscapes [4 running on 3.1 SP3, 1 on 4.0]. Load balancing with Web Server Cluster [Apache], Web Application Server Cluster [Tomcat, NetWeaver], BO CMS cluster, Data Federator Cluster machines for achieving the optimal performance.
- Installed and Configured Java Connector 3.0.2 for SAP connectivity.
- Configured BO to import the users from BI and setting up Single Sign-on with Portals using SSL and encryption – SAP Cryptograph Library and SNC configuration to backend systems BI and ECC.
- Configured the BO to Enterprise Portals for Single Sign-on by importing the Business Packages into Portal and exporting the Portal PSE key certificate into BO.
- Installed & configured BIA Landscape with IBM Blade servers HS21 and DS4700 Storage for Dev, QA and PRD.
- Technical configuration of BIA system to BI. CheckBIA with Python scripts.
- Configured the TREX search engine settings and also TREXADMIN in BI.
- Identify the large Info cubes and Queries and do the performance improvement by using the BI Accelerator without using the aggregates, Multiproviders etc.
SCM 7.0
- Architect and Deploy SCM 7.0 implementing the Functional components AP0, EWM, ICH. EM, LiveCache.
- Sizing, System Landscape Design, Client Strategy, Connectivity etc.
- Integration with ECC, CRM, BW systems.
- Live Cache sizing à 250gig of Memory,
- Refreshes, Backup & Restore, Performance Tuning etc.
Client: Confidential
Project: Implementations, Upgrade and Migration Projects
Role: Basis Team Lead
Duration: Jun 2008 - Apr 2009
Environment:
SAP Systems: R/3 4.7, ECC 6.0, CRM 5 & 7.0, BW 3.1, EP 6.0, XI 3.0 & 7.0, Solution Manager 4.0 &7.0
Production Servers for CI and DB Servers: SUN M5000, Sun Fire E25K – 140Gig, 45cpu’s, Sun Fire E15K, Sun Fire V1280.
Database Servers: Oracle 9i/10G, SQL Server 2005 SP2
Storage: EMC DMX 4 – RAID 1+0 256Gg Cache.
Hardware Migration
- Planned, Architected and Implemented Hardware Migration from Homogeneous SUN Platform to SUN - Red Hat Linux Heterogeneous environment.
- Created a separate Migrated Landscape without disrupting the Break-Fix, Enhancement landscape.
- Interfaces, Bolt-on’s and Third party tools integration with both the landscapes.
- Regression, Integration & User Acceptance testing.
R/3 4.7 – ECC 6.0
- Plan, setup and architected the Archiving process for R/3 landscape [Retail and Warehouse Management Landscapes à 8 TB & 4 TB] in Production before upgrading. Identifying the Functional Archiving Objects and using IXOS to archive it on EMC Clarion bPox.
- Installed, configured, setup’s configured and builds the ECC Landscape which has Sandbox, Development, Testing, Quality, and Staging & Production.
- CUUC [Combined Upgrade and Unicode Process]. Upgraded R/3 4.7 set 110 to ERP 2004 [ECC 6.0, HCM, and LSO]. Involved in Planning, Architect, execute the whole upgrade process for the whole R/3 Landscape in terms of backend Storage upgrade EMC[Storage team], Hardware Re-sizing & OS Upgrade [UNIX team], Oracle Upgrade from 9.2.0.8 to 10g[10.2.0.2].
- Performance and Tuning of the ECC Landscape with respect to SAP buffers, Database buffers, OS, Network & Storage RAID 1+0 striping on the new EMC box.
- Plan, setup and configured Heterogeneous systems for ECC. CI and DB running on Solaris environment and application/dialog/load balancing servers on Redhat Linux environments.
- Interfaces upgrade to ECC, Connectivity to ECC landscape [Portals, BI, UC4, IXOS, Dazel, Web
- Methods, TIBCO third party bolt-on].
- ITS servers upgrade from standalone 6.20 t0 integrated ITS 7.0.
SAP TDMS – Refresh Client tool
- Info Shuttle, Gold Client and latest TDMS client copy tools from Production to Non-Production systems. Install, Setup and configure TDMS Server in Solution Manager for the sender and receiver systems.
- Followed the important OSS notes related to TDMS.
- Setup the Central and Control system on the TDMS server, Sender & Receiver systems. Run CNV_MBT_TDMS for setting up Projects, Sub-project and packages.
- Setup the RFC connections.
- Shell Creation for ERP, BW and CRM.
- Setup the non-production systems with only Customizing and Master Data.
- Delete all client-dependant data from the client in non-production system before data transfer.
- Used the Time-based approach in reduction process for the data transfer with consolidated important business transactions.
CRM 5.0 – CRM 7.0
- Design, Architect, Plan and implement CRM 5.0 Landscape.
- Co-ordinate with SAP safeguarding team for the Upgrade & Operations which includes Upgrade Evaluation, Planning, Realization, Final Preparation and Support.
- SAP Upgrade Going live Technical & Functional Upgrade check, Technical Performance Optimization and Volume Test Optimization checks.
- Install, configure, tune, support CRM system Landscape implementing Interaction Center using Web client, IPC, Sales, Service, Campaign Management, and Channel Management.
- Connectivity to XI/PI, R/3/ECC, BW/BI, Third Party tools interface with Web Methods, TIBCO, Business Objects, Tax ware etc.
- Setup and configure CRM Middleware component with ECC.
BW 3.1 – BI 7.0 PRD à 15 Terabytes
- Plan, setup and architected the Archiving process for BW Production system [15 Terabytes] in Production before upgrading. Identifying the BW Archiving Objects and using IXOS to archive it on EMC Clarion box.
- Planned and deleted all the unwanted and unused PSA tables, Aggregates, Multiproviders and InfoCubes in the BW system before upgrading the BW system.
- CUUC [Combined Upgrade and Unicode Process]. Upgraded BW 3.1 to BI 7.0 involved in Planning, Architect, execute the whole upgrade process for the whole BW Landscape in terms of backend Storage upgrade EMC[Storage team], Hardware Re-sizing & OS Upgrade [UNIX team], Oracle Upgrade from 9.2.0.8 to 10g[10.2.0.2].
- Installed, configured and build the BI 7.0 system landscape with Federated Portal, BI Accelerator, Pre-Calculation Server, BPS and IP [Integrated Planning].
- Extensive process of performance and tuning for BW and BI system in terms of Parallel Extraction, Loading and Querying process with respect to InfoCubes, Aggregates, Change Run, Roll up Aggregates, InfoCube Compression. Follow the recommendations of SAP OSS notes related to BW, Oracle, Solaris, and Network & EMC.
- BW/BI connectivity issues with Portals, R/3/ECC, CRM, and XI/PI.
- Logical Mappings for BW/BI to R/3/ECC using Logical systems, RFC Destinations, IDOC processing, Communication and Transformation Rules.
- Supporting both the Web and GUI users for BW/BI systems.
Portals 6.0 – Portals 7.0 PRD
- Migrated Portals 6.0 -> Portals 7.0 running on J2EE -> JDK 1.4.2 -> JVM & JRE.
- Upgraded the Load Balancer [Cisco Router (Hardware) & Web Dispatcher (Software)], Active Directory for the Portals applications supporting ESS/MSS, BI, and CRM etc.
- Tuning Portal Server for Hardware, Operating System, Java Virtual Machine, J2EE, Log Analyzer, Monitor Settings.
- Trouble shooting Portal applications for 40,000 users in Load balancing, JCO client, Active Directory, LDAP, ITS, Pages, I views, PCD, TREX issues.
- Worked on Planned and Unplanned outages for Portals.
- Synchronizing the user administration from Active Directory à UME à CUA.
- ITS integration for Portals to execute transactions remotely to the backend systems.
- Performance & Tuning Portals in terms of OS [Shared memory, TCP Stack Size, Kernel, CPU, JVM], Java Stack à Java Heap Size, Initial, Tenure and Permanent areas, HTTP compression, System and Application threads, Dispatcher, Server à Managers & Services, DBPool Service.
- Java I view’s Performance, Profiling and Testing/Evaluation. Tuning Browser, Server Proxy Cache settings.
- Using Java Stack tools [Config, Visual Administrator, and Telnet] to configure & tune J2EE parameters.
Solution Manager 4.0 -> 7.0
- Plan, Architect, Install and Configure Solution Manager 4.0/7.0 SP15 for DEV and PROD instances.
- Configure DEV à Non-Production Systems and PROD à Prod Systems.
- Configure ABAP & JAVA Stack monitoring using different CCMS agents and JARM using JMX API for third party tools for HP Open View to monitor the system landscapes.
- Configured Service Desk, Upgrade of SAP Solutions, Change Management [CHARM], Solution Monitoring, Delivery of SAP Services & End-To-End Diagnostics [SMD, CA Willy Introscope].
- Connection to OSS from Satellite Systems and downloads through Solution Manager.
Archiving R/3-ECC, BW-BI, CRM
- Plan and Strategize the Archiving Process for R/3-ECC, BW-BI and CRM modules using SAP tools SARA, SARI and SARJ.
- Integration of IXOS to Archiving Information System using Archive Link and using Clarion Storage for storing the archived objects data.
- Identify the Archiving Objects, Large Tables with Functional Teams for FICO, MM, SD, Idoc’s, HR, BW, CRM-BDoc’s etc.
- Configure and Customizing Archive Settings for WRITE, DELETE and READ Operations in SPRO [IMG] level with various different options for technical settings. Doing Pre and Post Processing for some of the archiving objects.
- Troubleshoot the Archiving process and defining the jobs for Write, Delete and Read using UC4 Background Scheduler.
- Parallel processing of DELETE operation during the purging/deleting data from the database.
Client: Confidential– Retail Industry
Project: Full Life Cycle Implementations [ECC 6.0, CRM 5.0, BI 7.0, PI 7.0, EP 7.0, Solution Manager 7.0], ERP – Ecommerce – Mainframe Integration.
Role: Infrastructure/Basis Lead/Manager
Duration: Mar 2007 – Jul 2008
Environment:
HP Super Dome, N-Class servers, Heterogeneous Hardware Environment with Unix/Windows. Oracle 10g, SQL Server. TIDAL, VTL – Virtual Tape Library for Backup and Recovery, HA, DR, BIA HP Appliance – Blade Servers.
- Involved in the Hardware platform Selection and Sizing process for all the modules based on the Functional feedback using SAP Quick Sizer.
- Lead six member Basis team working with DBA, Unix/NT, Network, Backup, Helpdesk teams.
- Implementing the SAP Best Practices for System Landscapes and deploying or incorporating the standards and procedures into the Landscape Definition and setup.
- Installing different types of Installations: Standalone, Distributed, High-Availability, Export & Import for SAP Landscapes: ECC, CRM, SCM, BI, PI, Portals, MDM technologies.
- Planning, Configuring, Implementing Landscape, Client, Transport, CUA, Backup & Recovery, High Availability & DR, Standard Operating Procedures etc. for all those SAP System Architecture Landscapes.
- SAP implementation, installation, and upgrade experience R/3 4.6c – ECC 6.0, BW 3.5 – BI 7.0, EP 5.0 – EP 7.0, APO 4.0 – SCM 5.0, CRM 4.0 – CRM 5.0, Basis 4.6D – Net weaver 7.0.
- ECC 6.0[FI/CO, SD, MM, PP, WM, HR], CRM 5.0, BI 7.0, EP 7.0, PI 7.0, Solution Manager 4.0, IS-Retail, FSCM [Finance Supply Chain Management], EHP2 [Enhancement Package 2].
- Work with SAP Net Weaver 2004 or higher, Solution Manager 3.2 or higher and J2EE/Java stack installation and administration.
- Research emerging technologies for Technical Infrastructure, Ensure SLAs are met.
- Establish, configure and manage all SAP client and server environments, including: development, test, training, sandbox, and production.
- Application Support - Complex problem analysis providing an advanced level of application and end user support.
- Performance monitoring and Tuning - Work across application, database and functional support areas using workload analysis and other predictive tools to tune system for optimal performance.
- Lead and executes all SAP installations, upgrades and patch applications. Develop and document standard processes for the same.
- Work with management and security team to assist in implementing and enforcing security policies. Creates and manages user and security profiles, ensuring application security policies and procedures are followed.
- Provide SAP BASIS training & Mentoring to Junior or less experienced Administrators.
- Planned, developed and implemented Data Encryption and Scrambling for FI module for very critical and sensitive data with restrictive user access.
Client: Confidential, Waukegan, IL
Project: Production Support of Current Landscapes and Projects – HR landscape. CRM, Portal Implementations.
Role: Basis Team Lead
Duration: Jul 2006 – Mar 2007
Environment:
SUN E25K, 4800, HP –Blade Servers, Linux Servers – SUSE.
SAP Landscape: R/3, BW 3.5, XI 3.0, SEM, CPCC, SCM 4.1, AII, HR, Solution Manager, CCMS
- Planning, Designing the SAP Landscape Architecture for the new dimensional My SAP.
- Defining the SAP Landscape in conjunction with the SAP Application teams for Sandbox, Development, Quality, Staging, Training, N+1 and Production systems.
- Implementing the SAP Best Practices for System Landscapes and deploying or incorporating the standards and procedures into the Landscape Definition and setup.
- As Team Lead, maintained a onshore and offshore team of 8 basis members covering 24/7.
- Planning, configuring and implementing Global Code migration to different SAP landscapes.
- Communicating with application teams, meetings, providing solutions for upcoming projects, system architecture documentation and technical documentation, mentoring junior administrators, providing technical support for 3rd party interfaces and integration to SAP R/3.
- Work with upper management in terms of (Un) planned outages, Resource allocations.
- Knowledge Transfer for offshore team in terms of Abbott procedures, policies and protocols.
- Defining SLA, Project scopes, timelines in coordination with management teams.
- Coordinating with other Infrastructure teams like Network, PC, Unix, DBA, tools.
- Assigning Basis/DAB related activities for load balancing to the offshore Basis team.
- X1 Upgraded to SP Stack19 having interface issues with Web Methods and Web Sphere.
- Solution Manager Upgrade from 3.2 to 4.0 and configuring and implementing Service Desk, TMS, IMG components.
- BW migration from SUN to HP using SAP Migration Tool Kit and then Upgrade it to BI 7.0.
- Involved in the planning phase of ECC 5.0 upgrade from SAP R/3 4.6C.
Client: Confidential Naperville, IL
Project: Production Support for 14 Landscapes and Business One New Initiative Projects which includes à R/3 à ECC 6.0, BI 7.0, SCM 4.1, EP 7.0, PI 7.0, Solution Manager 4.0.
Role: Senior Basis Admin
Duration: Jun 2003 - Jul 2006
Environment:
HP Super Dome, HP N-class, L-Class servers.
SAP Landscape: BW, XI 3.1, MDM 5.5, Portals 6.0, CRM 4.1, SCM 4.1
- All the responsibilities of Basis starting from Installations, Migrations, Upgrades, Trouble Shooting, Performance Tuning (OS, Database, R/3), Third Party Interfaces.
- Sizing the hardware, Installing, configuring and implementing CRM, SRM, PLM and SCM to interface with Net Weaver components like XI, MDM, Portals, and BW with base being WEBAS 6.40 kernel. Configuring SCM, CRM to XI and BW connectivity.
- Doing production refreshes for both ABAP+JAVA stacks to test and training systems using backup, restore and re-configuring Java stack and also using Jload to export and import the database schema’s for Abap and Java.
- Involved in building SCM, CRM, SRM, PLM, MDM landscapes which includes Sandbox, Dev, Test, Prod and Training systems.
- Involved in setting up policies and procedures of Sarbanes Oxley for all SAP and interfaces to SAP landscapes.
- Installation, Configuration and troubleshooting ITS [2.0, 6.20. 6.40] for different landscapes.
- Involved in setting up, configuring and implementation of High-Availability, Disaster Recovery for all SAP systems using HP Service Guard.
- Planning, Implementing and Going Live with Quote to Cash for 14 different countries on 7 system landscapes covering different modules and markets.
- Co-ordination and consolidation of moving data centers from Denver and Town and Country to Lisle for all SAP servers for 7 landscapes.
- Plan, Install and configure BW landscape Dev, Test, Production and Sandbox.
- Performance and monitoring of Query and Web performance, Extraction, Upload Monitoring (RSMO), Aggregates, Dimension and Fact tables. Running Sap_Infocube_Designs report to see Info Cube tables, no. of records and the ratio of dimension to fact tables.
- Developed, Tested and maintained a good Backup and Restore strategy, Production refreshes for the BW landscape using Split-mirror, Tape and File Systems backups.
- Designed and developed Transport Management strategy for the BW landscape.
- Involved in architecture of new Dimension products for the future implementation of NetWeaver Technical platform components MDM [5.5].
- Troubleshoot issues related to IDoc’s, XI connectivity and RFC connections and Repositories.
- Installing MDM Client components MDM Import Manager, Syndicate Manager, MDM Data Manager, MDM Connector.
- Installed, configured and implemented technical configuration set up for XI 3.0.
- Technical configuration of Integration Builder, Repository, Directory and Integration server.
- Installed, configured SLD, UME, Adapter Engine with IDOC, RFC and Standalone adaptors.
- Performance and Tuning of XI Java VM tuning, Application and Database level tunings.
- Installing, configuring SAP Enterprise Portals 5.0 which includes Portal Framework (Portal Runtime which has Unification Server, Connection Framework).
- Initial sizing of SAP Portal Landscape, Technical Infrastructure and develop High-Availability.
- Installed Knowledge Management components Content Management and TREX.
- Installation, configuration and implementation of J2EE Engine for a clustered Portal.
- Creating, configuring and administering iViews, PCD (Portal Content Directory).
- Performance and tuning of J2EE engine in terms of TCP/IP, Thread management, HTTP service compression, PCD Config. PRT Config. Using Config tool and related file properties.
- Sizing, Installation, configuration and implementation of SCM 4.1 APO, EM, ICH.
- Installed the technical components SCM Server 5.0, Web Communication Layer [EM], Live Cache 7.5.0, Optimizer Server 4.1, Internet Graphics Server 7.0, and XI Content for ICH, EM, Portal Content Business Package, BI_CONT, and SAP_BW 6.40.
- Configuration of APO 4.1 to Live Cache Kernel 7.5.0 and also using LCAPPS for ECC and CRM communication. Monitoring and performance tuning of APO server, Live Cache server.
- Technical installation, configuring and implementation of EM on a separate server.
- Installing, configuring, implementing SAP AII 4.0 for RFID bar-coding for Event Management.
- CRM technical components installation, configuration and of CRM-Channel Management, Field Applications, Service, Sales and Marketing.
- Technical configuration and set up for Interaction Center, Internet and Mobile Clients.
- Installing CRM Enterprise Server, Middleware and the adapters to enable communications for Mobile clients, Handhelds, Internet, Telephones and Email.
- Installing People-Centric CRM for the Portal connectivity, Business Productivity Package.
- Implementing Central Standalone servers for CUA, Solution Manager, SLD and TMS and CMS for different landscapes
Client: Pfizer Europe
Project: Conversion Project à Convert existing legacy systems running on AS/400 to SAP environment.
Role: Sr. Basis/Oracle DBA.
Duration: Jan 2002 – Jul 2003
Environment: HP 9000 servers, HP L-Class servers, Windows, Oracle, SQL Server.
- Planning and implementation of upgrades to R/3 system landscape from 3.1H to 4.6C.
- Solving Disk I/O problems by changing the EMC disk configuration from 36gig to 18gig drives.
- Identifying performance bottlenecks and implementing database reorgs, rebuilding indexes during planned outage for production systems.
- SAP R/3 Administration (SAP Kernel 4.6D, R/3 4.6C)
- Performance monitoring of production, test and development servers.
- Tuning R/3 buffers, database buffers and operating system shared memory parameters.
- Monitoring R/3 buffers, updates and system logs, background jobs, operation modes etc. Workload analysis, application modules like FI/CO, MM, PP, SD and monitoring.
- SAP BW Administration (BW 2.0A, 3.0A, 3.0B)
- Installation, configuration and implementation of BW system landscape.
- Connectivity or interfacing of SAP BW landscape to SAP core R/3 landscape.
- Performance, tuning of BW systems in terms of buffers, info cubes, aggregates etc.
- Optimizing data loads based on performance factors like loading master data first, loading data into ODS/PSA and then into Info cubes, Rebuild indexes on the facts tables, Update database statistics for query optimizer, Buffering of Number Range Objects, IDOC related parameters, load data in parallel.
- Upgrade of BW from 2.x to 3.x and 3.0A to 3.0B.
- Migration & Conversion from SAP to DataStream 7i (Asset Management, MM, Purchasing, Work Orders etc.).
- Web Server & Database Server Administration
- Planning, hardware sizing and capacity planning for dev test and prod landscape for SAP and DataStream ERP systems. Installing Oracle 8.1.7.1, Oracle 9i Apps. Server & Data stream 7i.
- Physical layout of dev, test and production databases for SAP and Datastream using Seagate Xiotech disk storage.
- Database performance tuning in regards to application, sql, buffers, table scans etc.
- Restoring, repairing, trouble-shooting database related problems.
- Storage management and monitoring critical table spaces like Oracle table spaces, Basis table spaces, application table spaces etc. for extent overflow, table space overflow and free space.
Client: Confidential
Project: SAP R/3 Administration, Upgrades From 3.1H to 3.1I & 3.1H to 4.0B, Unix to NT Migration.
Role: Sr. Basis Consultant.
Duration: Oct 2001 - Dec 2001
Environment: HP – 9000 Servers, Oracle 9i.
- Installing, configuring SAP Migration Toolkit to implement OS/DB migration from SUN to HP and HP to NT migration. DB migration from Oracle to SQL Sever.
- Physical layout of the database using EMC disk storage.
- Monitoring database for table spaces overflow, extent overflow, indexes etc. Adding data files for table spaces when insufficient space problem occurs.
- DB02, ST04 for monitoring database physical, logical, missing indexes, critical tables, buffers (database buffer cache, row cache, dictionary cache).
- Setting up backup schedule for several databases using HP- Omni Back.
- Storage management and monitoring critical table spaces like Oracle table spaces, Basis and application table spaces etc. for extent overflow, table space overflow and free space problems.
Client: Confidential
Project: Upgrades to 4.6B from 3.0/3.1, BW 2.0B, 3.0B, 64-bit, Homogeneous to Heterogeneous Hardware Migration.[Sun à Sun & hp].
Role: Sr. Basis Administrator
Duration: Sep 99 - Oct 01
Environment: E-10K, E-6500 servers, HP – 9000 Servers, EMC storage, Oracle 9i. My SAP, SCM, CRM, BI
- Installing ITS, Web-Studio, SEM (2.0), and APO, B2B Procurement components of My Sap.
- Installing E-gates and W-gates on different servers for load balancing.
- In the process of implementing E-commerce with sap components.
- Implemented ESS (For Euro Conversion) in different languages and applied OSS hot packages.
- Production system refreshes to staging, iteration, Y2K, and sandbox etc. and renaming SID.
- Tuned SAP R/3 and Database buffers, OS parameters, application modules, SQL and ABAP/4.
- Direct support for bolt-ons: Haht, Budget system, Dazel, Maestro (Tivoli Systems).
- ABAP data dictionary changes and modifications for different objects.
- Configuring and troubleshooting ALE/EDI/IDOC for Edi Gentran, Tax ware, TRAX etc.
BW & BW Upgrade (2.0B)
- Installing, configuring BW system and having BW extractors set up in R/3 to extract data from R/3 database. Performance analysis and tuning. Upgraded BW (1.2) to BW (2.0).
- Setting up communication between production SAP R/3 to BW Production and to Staging systems.
Data Base Administration INFORMIX/ORACLE (OLTP, DSS, Data warehouse)
- Backup, restore of production and several other database servers.
- Performance analysis and tuning parameters in terms of memory, disk, CPU, Network and other.
- Database physical disk layout on EMC. Design and implementation of oracle database security.
- Implemented Disaster recovery for the database servers, SAP production servers and non-erp database servers. Database design/modeling for data warehouse.
- Data extraction from SAP R/3 to non-SAP Oracle databases, data loading techniques for large data volume for other engineering, sales, management applications.
- Database tuning and tuning data extraction/transformation SQL scripts to improve performance.
- Used EMC, BMC and Oracle OEM/RMAN to setup backup/recovery of all SAP and Non-sap.
SUN To HP Migration
- Configured heterogeneous environment having HP - N class machines as application servers and SUN E-6500’s as Central Instance/Database Server.
- Configured bolt-on products (EDI Gentran, Taxware, Trax, Maestro etc.) on utility server on SUN servers and R/3 application servers running on HP.
UNIX Administration
- Physical design of the database, disk Layout in EMC and striping the critical dbspaces and table spaces data across the disks. Mounting Vx file systems for SAP, Database etc.
- Using Veritas to configure the volumes, plexes and sub-disks, mapping the links to the EMC drives. Using symcli commands for BCV’s backup, restore and refresh the database servers.
- NFS, NIS administration for SAP servers. UNIX printer system administration for SAP servers.
- Moving sap systems from one machine to another including host rename and database copy.
Client: Confidential
Project: Full Life Cycle Implementations for Union Carbide. Interface to Legacy [LSMW].
Role: Sr. Basis Consultant.
Duration: Sep 98 - Aug 99
Environment: IBM, HP Series. EMC Storage. Hitachi.. SAP R/3 Administration
- Advise customers on the system, networking, and hardware planning and sizing.
- Advise customers on R/3 system landscape implementations.
- Implemented SAP security and performance conventions.
- Installed SAP R/3 versions 3.0D, 3.1H, and 4.0B under UNIX and NT.
- Installed & configured LSMW (Legacy System Migration Workbench)
Upgrades to 4.0B, Database Administration, UNIX Administration
- Setting up the file systems layouts by creating Volume Groups, Logical Volumes, File systems, raw devices and swap space on the physical Volumes.
- Installed & configured HP- Omni Back II Knowledge modules for Oracle, SAP & UNIX
- Setup backup and restore of Oracle database and Monitoring database and applications.
Client: Confidential
Project: Sr. Oracle Database Administrator
Role: ORACLE/INFORMIX DATABASE ADMINISTRATOR
Duration: Feb 97–Aug 98
Environment: IBM and Windows servers.
Involved in the analysis, design and implementation of a client/server insurance policy and claims system. This system was designed to have a centralized database server (SMP) for different applications to extract data in a distributed & replication environment. Designed for high performance and high availability using RAID-5 for parallel processing activity queuing and policy issue system. Developed detailed project work plans and designs for all components of the system. Facilitated user workshops and design sessions to gather requirements. Designed the program level protocols, RPC’s and data packets & routers to communicate with AS/400 and VSAM data repositories and develop interfaces to existing legacy systems. Identified and resolved cross functional team design and technical issues and assisted in developing the system testing cycles and acceptance test standards. Implemented features to balance workloads, support organization based team structures in the application’s workflow modules, enable parallel processing of policies, messaging and policy level notes and interface with external vendor processing systems. Developed routines for automation of the migration process of the data from legacy system to UNIX/Oracle database and update data on a daily and weekly basis.
Client: Confidential
Project: Sr. Oracle/Informix Database Administrator.
Role: ORACLE/INFORMIX DATABASE ADMINISTRATOR
Duration: Jan 96 - Jan 97
Environment: SUN E-6500 servers, EMC storage.
Involved in design, development and implementation in some features for NNS( Next Network Switch) for AT&T which is a sophisticated communications technology project of worth 2 billion and total headcount of 600 people and man-hour of 8yrs. This system was designed to incorporate voice, video, data and Internet communications. This new switch is computerized with specially designed fully fault-tolerant tandem machines acting as switches and interacts with the existing 4ESS switch for switching communications. The switch operating system, the applications layers, presentation layers are developed using C++, JAVA and CORBA methodology and the switch data is stored in Oracle & Informix databases for different applications. The Operational Data Store is a transformed and cleansed operational data repository for operational reporting and serves as a source to the corporate wide data warehouse.
Client: Confidential
Project: Confidential
Role: ORACLE/INFORMIX DATABASE ADMINISTRATOR
Duration: Jul 95 - Dec 95
Environment: SUN, HP. SUN Storage.
Developed, modified and implemented Order Entry System of CSG for Motorola Inc. Modified database design and generate complex reports using 3GL for Cellular phones facility Data warehouse system.
Client: Confidential
Role: ORACLE/INFORMIX DATABASE ADMINISTRATOR
Duration: Jan 94 - Dec 94
Environment:
Involved in database design, development and implementation of a mission-critical OSPS Switching system for NTT (Nippon Telephone & Telegraph) Japan as a DBA. The system has a inventory 2.5 million calls per hour. This system was developed with 300 headcount and almost 3-4yrs. of project time. Its a true client-server architecture both hardware and software application development. Every call data coming through the 5ESS switches is stored in different SUN Sparc’s through TCP/IP and loaded into the database on the server end, at the client site there are operators who by clicking at different options in the GUI code (in MS C++) which communicates to the server code using EZ-RPC and finally extracts the aggregated data stored in the database for display and reporting purposes.
Client: Confidential
Project:
Role:
Duration: May 93 - Dec 94
Environment
Designed, developed, implemented Mortgage system for UCB Inc. which is a client-server system. Re-engineered the existing system developed in MUMPS in VAX/VMS to UNIX/Oracle environment. This system is a mission-critical, high-performance and availability in a distributed and replication environment with 300 users logged. Developed different parser’s to process the incoming customers information data, send data to CBI, TRW and TU for details though LU6.2 communicating to their legacy system, match/merge the data, generate credit reports and print it at the customers location. The whole cycle takes a minute to process.
Client: Confidential
Project:
Role:
Duration: Sep 92 - Mar 93
Environment
Designed, developed and implemented Position Evaluator for Chicago Board Of Options Exchange using INFORMIX-4GL Language (SE, ON-LINE Engines) and development tools ESQL/C, Quickstep, ISQL in IBM RISC/6000 machines running AIX (3.2) operating system.
Designed, Developed and Implemented Trade Entry System for the users (Runners, Operators, Floor Brokers etc.) of Chicago Board Of Options Exchange using Informix-4GL, ESQL/C.
Developed Nightly Batch Reports System for generating reports for every end-of-day transactions, Weekly and monthly transactions. Each report was generated by having driver functions and the option was given for the user to print the report, save to file, display on the terminal by having a menu commands.
Education/Certification
- Bachelors, Mechanical Engineering.
- Coursework completed toward MS, Computer Science.
- SAP Basis Admin. Certified, Business Warehouse 2.0B Certified.
- HP ITSM [ITIL] Certification Event, Capacity, Risk, Change, Storage, Performance etc.
- Chairman Award for Sarbanes Oxley Implementation Certification -> Lucent
Training
- SAP Net Weaver WEBAS SAP Partner Academy Training, SAP BW 1.2B, 2.0B
- SAP/R3 Basis: SAP50, MBC030, BC360, BC505, BC305, BC340, BC315, BC325.
- Oracle Database Administration (7.x, 8.x, 9.x), Informix DBA (6.0, 7.0).
- Unix Administration HP-UX (11.0, 11.23 64 Bit, IA64), Solaris (2.7, 2.8).
- EMC Oracle Tuning, VERITAS Oracle Tuning.