SUMMARY:

• Motivated IT Professional recognized for troubleshooting, mentoring and being a committed team leader. Values opportunities to utilize technical expertise in order to improve IT processes, architect, design & setup ERP landscapes, and provide superior customer services. I have a total experience of 16+ years in the field of IT, and have worked for both SAP and ORACLE, and my industry experience spans Manufacturing, Construction, HI - Tech, BioTech and Retail Utilities. Following are some of my core areas of expertise:
• Establish a BI dual landscape for the client. Conducted multiple system refreshes for both ABAP and JAVA instances and implemented BI-Portal across the dual landscape. For the production BI system took part in HP clustering setup with HP engineers to test a successful failover for the client.
• Support provided to the BI technical team on a major data warehouse project. Besides creating the dual landscape, this required setting up multiple source connections to 3 source systems (including the current production BI system) and monitoring the extracts over a period of 4 weeks during which production data was migrated to efficiently designed cubes in the new production system. Working closely with the client managers and a BI implementation partner we were able to complete the project successfully on time and within budget.
• Completed upgrade on the ORACLE database from 10.2.0.2 to 10.2.0.4 for the dual BI landscapes.
• Upgrade the BI landscape with Enhancement Pack 1 for both ABAP and JAVA instances and Install BPC (Business Process Consolidation) Module for the client. Provide BASIS support to third party on BPC implementation.
• I completed a successful term as Project technical team lead & Senior BASIS resource for a complex multi-landscape SAP upgrade. Working with multiple vendors and project managers have managed GO-Live on SAP R/3 upgrade (46C to ECC 6.0) along with BW upgrade (30B to 7.0) and a Portal migration from EP6 to EP7. Some core pre-requisites had to be accomplished before the SAP upgrades like Database upgrade (Oracle 9.x to 10G) Bolt-On Application Upgrades and SOLARIS Upgrade (8.x to 10). The primary project started in Feb 2007 and was completed as of middle August 07. This was a very technically challenging project since three major SAP platforms were being upgraded to the Net-Weaver Technology.
• Responsible for both onshore and offshore infrastructure management for SAP landscapes through a team spread across 2 remote locations & one onshore.
• Production Support: Responsible as a BASIS Technical Manager to manage multiple production landscapes of SAP R/3, BW, Portals, SRM, XI, IS-U/CCS & CRM for the Client. Closely work with client on architecture review of SAP landscapes This involves managing a team of senior BASIS folks and working closely with the DBA and OS Team leads for achieving the target SLA’s with the client and keeping support tickets to the minimum.
• Process Improvement: I have setup a system maintenance process at the client site for periodic maintenance work which was adopted by other IT teams and is now followed by Client help-desk to announce downtimes and status reports on planned & unplanned activities. One of the critical processes improved was SAP Archiving. From 2 standard SAP CCS objects we went to 12 CCS objects and in a course of one year archived about 1.2 Tbyte of data.
• Mentoring: I have mentored my team at the offshore location for over two years to make them support the above complex landscape. This involved working closely with my counterpart team-leads & the junior BASIS, DBA, UNIX staff at the onshore and offshore locations. I have currently engaged my offshore teams to closely work with SAP support for implementations of the recommendations for GO-Lives and EWA reports for the multiple landscapes at the client site.
• Initiated and successfully completed multiple client sponsored charters. Infrastructure Monitoring Charter (Pilot setup of TIDAL software), Change Management Charter - Standardizing Enterprise Development and Change Management Process at the Client & SIM - Service Introduction Methodology for Infrastructure Projects Solution Manager Configuration

TECHNICAL SKILLS:

ERP/Databases: SAP ECC 6.0 R/3 V 4.6C, 4.5B, 4.0B, 3.1H, & 3.0C SAP Web - As 7.00, 6.40 & 6.20 Oracle 10g, 9i, 8.x, 7.x, 6.x INFORMIX 7.3Hardware: SUN 15K, R - 6800, E4500, R420 HP-K class servers IBM RS/6000 servers Compaq ProLiant

Tools: TIDAL software BMC PATROL / OPTISYSTEM for SAP Oracle OEM. EXCEED-NFS UNIX Shell Scripts LEGATO Backup Tools PRECISE for OracleEMC Symmetrix & DMX

Management: Tools for Managers. Effective Project Management. 2 day Management SeminarSAP: BC - 305, BC-310, BC-315. BC-325, BC-360, BC-505. BW-360 BW Performance & Administration. ITS-070, BC-346. ABAP-Objects.ORACLE: Oracle dB Administration (I & II) Oracle Performance Tuning Oracle Replication Oracle Developer Tools. SQL Server 2000 Working Knowledge of SQL Server Database

UNIX: Concepts and Internals

PROFESSIONAL EXPERIENCE:

SAP IT Architect

Confidential

Responsibilities:

• Mentored junior team members through personal, brown bag seminars & accurate documentation. As part of improving IT processes, successfully initiated and completed efficient Support Pack Implementation, SAP system refreshes, & Transport Automation.
• Been part of the Hiring Panel to interview qualified employees and consultants for various projects.
• Attended technical seminars, SAP Tech Ed, and have represented company at the Gartner North Americas- Best Practices group.
• Architect, Install and Configuration of SAP E-Recruitment (ERP 2004) server. Establish External Job board requirements, ALE data transfer between backend HR and R/3 systems.
• Coordinated upgrade of EBP 2.0 to SRM 4.0. with Vendor and Reliant Infrastructure teams. Core components upgraded from SAP 46D to WAS 640; along with installations of additional components like J2EE, IPC, XI 3.0, etc.
• Leading a cross effort within the BASIS team to establish competency for production support of new projects.
• Evaluating SAP NETWEAVER components like SAP Portals, & SAP XI to replace external non-SAP interfaces like Siebel, TIBCO, Mercator & Business Connector. Installed a Pilot XI V2.0 system for the EDI team to test interfaces.
• Completed a successful SAP IS-U/CCS 4.64 Upgrade on a R/3 46C Retail landscape. Activities after Upgrade are resolving SPAU (Repairs on SAP ABAP & Custom code), SPDD (ABAP Dictionary) & making Customer Interaction Screens & User Exits work with the new Retail functionality. Closely worked with the business and testing teams to prioritize & log upgrade issues and lead a team of developers to resolve these issues. Conducted an enhanced functionality review with the different teams and came up with a game plan for a proper time frame for the upgrade. The next step was to minimize the Upgrade time from an initial 40 hrs to less then 20 hrs. Utilized extensive DBA knowledge to pre-create large indexes before the real upgrade, and ultimately tested upgrade on a pre-production box with the time for upgrade down to 24 hrs.
• Work with multiple hardware & software vendors like EMC, VERITAS, SUN, & ORACLE to plan and execute migration of our Production SAP system (3.5 Terra-bytes) from an older EMC SYMMETRIX 8830 to a new EMC DMX-2000 frame.
• Submitted multiple sizing proposals for installation of a BW-SEM 3.1 instance on a BW 30b Instance.
• Completed Upgrading Commerce Path FAX Server to RIGHTFAX fax server in SAP 46C.
• Coordinating Oracle 9.i Upgrade on all SAP instances. The teams involved are the OS, DBA and BASIS.
• Architect the entire BW Corporate Landscape for a major Utility company. Re-sizing of existing production landscape (SUN-Fire R6800 servers) to accommodate hardware for a BW 3.0b environment, which includes a sandbox, development, test and Production box.
• Assisted in hardware sizing for installing SEM-BPS on Compaq DL-580 servers.
• Was involved in troubleshooting performance related issues during the Initial Extraction and Full Loads. Work closely with DBA’s and UNIX staff to come up with solutions to improve query run times and daily loads.
• Successfully installed and configured two productive BW 3.0B Instances on one host.
• Installation, connectivity and configuration of different BW systems, with IGS server for enhanced graphics.
• Issue resolution in various areas of BW Cube Activation, ETTL, Queries (WEB access for BEX) and BSP pages.
• Assisted in Setup of BW security roles for users and web-based queries.
• Daily support of BW transports (via STMS & Transport Connection), & performance on BW servers.
• Successfully activated and transported BW Statistics Multi-Cube and associated Queries for analyzing Info-Cubes.
• Helped setup SSL on Web Server 6.20 with Self for secure Logon to users coming in via the Internet for running WEB Queries (STRUST).
• Migration of a V7.1 DB2/OS390 SAP 4.6C landscape to SUN/Oracle 8.1.7 4.6C SAP (64 bit) landscape.
• Evaluation & sizing of hardware resources migrating from DB2/OS390 to Oracle/Solaris environment.
• Extensive testing of VERITAS Fail-over Cluster software with SAP 4.6C, Solaris 8.x, & Oracle 8.1.7
• Simplification of the SAP Bolt-On architecture for Corp. landscape.
• Migration & testing of various Interfaces (TAXWARE, BSI-60 etc) from AIX to Solaris. This involved modifying and rewriting old shell scripts based on the new architecture.
• Installation of SAP Application Servers on a SUN E10K, & SUN-R6800’s with Solaris & Oracle.
• Configuring E-mail connectivity to external systems using SAP Internet Mail Gateway.
• Configuring, & testing the external FAX server capabilities from SAP to Commerce Path FAX server.
• Upgrading and testing the SAP components of the new RIGHTFAX fax server.
• Troubleshooting of complex firewall issues between AIX and SUN hardware with firewall vendors.
• Trouble shooting performance issues & adjustment of SAP profiles in both AIX/DB2 and SUN/Oracle.
• Setting up & configuration of ALE for FI-CO between AIX/DB2 and SUN/Oracle 46C landscapes.
• Assisted EDI-Harbinger team for setting up connectivity and daily jobs with SAP R/3 Production server.
• Facilitate SAP Support to conduct a 3-phase Migration session after GO-Live. Based on the company’s specific needs the recommendations suggested by SAP were customized and & implemented in SAP production environment.
• Setup LOGON Load balancing across the SAP application servers.
• Distribution and tuning of the SAP spool service across the CI and application servers. This led to big improvements in the printing times on highly used production printers.
• Automate the Transport Process using STMS Mass Transport and Workflow methods. This involved setting up new Transport Groups using Extended Transport Control in SAP. The entire development team was given in 2 stages on Work Flow and Mass Transports. Based on the feedback Mass Transports was later turned on in the development-test-pre-production landscape. The Production landscape was set to an external workflow tool.
• Initiated and organize a weekly brown-bag lecture series for the Infrastructure teams. Invite local experts to talk about their areas of expertise i.e., BW Loads, EDI, Portals, Web Security etc. This effort has been appreciated by management and has been started in other groups as well.
• Set up a FILENET process for critical BASIS support documentation for both RETAIL and CORP landscapes including R/3, EBP and BW environments.
• Streamlined & documented the process of Homogeneous copy of SAP Oracle Database using R3 Tools (R3SETUP, & R3COPY).
• Implementing and documenting critical processes like SAP Kernel upgrade (64-bit), & Oracle Upgrade
• Leading effort for redistribution of SAP Data’s on the EMC frame, based on I/O Hot-Spots.
• Expert guidance given to DBA’s for spreading out fast growing tables in SAP to their own tablespaces.

Confidential, Austin TX

Technical Lead

Responsibilities:

• Sizing of new SUN hardware and installing a duplicate SAP 4.5b landscape at Austin, TX, setting up all the Bolt-On servers, and connectivity with SAPGUI to all local, national and international customers.
• Testing of the actual migration process, with timings and backup contingency plans.
• Adjustment of R/3, DB, & OS profiles, and complete restoration of Production data.
• Established a pro-active SAP system monitoring process with guidelines for reporting, end-user follow-up and documentation of severe errors. This resulted in greater end-user satisfaction as unscheduled downtimes were reduced, & severe SAP, dB bugs were caught and resolved before reaching the users, & developers.
• User Master Cleanup & User Termination Process. This involved working with all the functional teams to cleanup authorization objects assigned to different team members. Using PFCG all the roles were revisited and regenerated after assigning proper authorization objects.
• Implemented & documented a process for application of TAX master updates to the SAP system. This resulted in proper calculation of TAXES for the Co. on a regular basis, & saved the company many man-hours of manual work needed to correct tax errors from previous years.
• Improved SAP Support Patch (Hot packs and LCP’s) application process for Confidential . This involved rewriting the process documentation and working with the Functional Team Leads to optimize the process and establish a schedule with responsibilities and proper hand shake.
• Mentoring of team members from the UNIX, DBA & BASIS groups in multiple areas of SAP administration and trouble-shooting.
• Received positive user and developer feedback for quick turnaround on trouble ticket resolution by the SAP system administrator(s) team and provided excellent SAP system response during peak loads.
• Vendor evaluation of Performance monitoring tools for Confidential . The Vendors evaluated were OPTISYSTEMS (now BMC PATROL), ENVIVE, & TIVOLI. A matrix of cost v/s features v/s implementation time was presented to the CIO team for final consideration.

SAP Basis and Oracle DBA Consultant

Confidential - San Francisco, California

Responsibilities:

• Executed a successful GO-Live of SAP HR-Payroll system and established a post go-live support structure with documentation of various procedures for the BASIS / DBA staff.
• Hardware evaluation of different Vendors for establishing the SAP Landscape, & Backup Management software. The companies evaluated were DELL, SUN, HP and COMPAQ.
• Installed and configured the SAMBA products to work for the heterogeneous SAP landscape, in which Development was on NT/Oracle and QA and Production on HP-UNIX/Oracle. The landscape was distributed over two different locations with a dedicated T1 line between the Development and QA/Production.
• Lead an effort to establish daily backup, weekly reorgs; monthly client copies and system refresh schedules. The system backup(s) were automated using the native NT tape management software.
• Trained the IT staff which had no prior SAP experience in installation, daily-weekly-monthly production support procedures, & troubleshooting both SAP, and Oracle systems.
• Setup SAP Router connections to SAP Support, and established a process of applying OSS Notes, and Support packs to the SAP system.
• Upgraded the HP-UNIX to 64 bit and readjusted the SAP/Oracle parameters to work with a 64 bit OS.

SAP Basis and Oracle DBA Consultant

Confidential - San Jose, California

Responsibilities:

• Set up BACKINT for SAP servers with IBM’s ADSM backup management software.
• Upgrade of IBM ADSM backup server tool and IBM-3570 Tape library micro-code.
• Completed final SAP Production build using SAP utilities, R3INST & DBLOAD.
• Installed and configured the profile generator tool (PFCG) in SAP 3.1H and successfully created & implemented activity groups for users at Confidential .
• Set-up of CTS, Work-Bench Organizer and Client Copy procedures.
• Troubleshooting install of SAP HOT Packages in conjunction with IS - CRT’s.
• Testing and documenting procedures for Oracle reorganization using the SAPDBA tool.
• Set up SQL, & shell scripts for monitoring database free space, database alerts & performance.

Senior SAPDBA Administrator

Confidential - Santa Clara, CA

Responsibilities:

• Managed SAP and non-SAP home grown applications running on Oracle 7.1.6.
• Identifying performance problems on the SAP-Oracle production database. Tuning done using the BSTAT/ESTAT tool from Oracle and CCMS tool from SAP R/3.
• Improved performance by re-organizing SAP production data - reducing size from GB.
• Improved I/O access times by redistributing storage disks based on Load, Data, Index, & growth.
• Received excellence in DB management.
• Scripting for generating daily monitoring reports for all the Oracle databases at Confidential .

Technical Core Competence Oracle-BASIS Specialist

Confidential - Foster City, CA

Responsibilities:

• Averted major corruption of enterprise data for a large SAP customer.
• Key member of the Technical Core Competence team from Germany, which launched the Going Live tool. This tool is now offered as a service to all SAP customers worldwide.
• Analyzed various Going live sessions for key US customers. Feedback was used to improve the Going Live Tool.
• Compiled various Oracle sizing and configuration guidelines for the Early-watch Team.
• SQL level tracing of expensive SD transactions, analyzing SQL traces and identifying ABAP/4 programs causing high database fetch times.
• Setting up an in-house SAP R/3 (3.1E) IDES & Oracle (V7.2) system for the TCC group.

Senior Technical Support Analyst

Confidential - Redwood City, California

Responsibilities:

• Assisted customers to run their databases at the best performance levels, and avert database corruptions to Achieve superior customer satisfaction.
• Collaborated with the Oracle Kernel development teams to identify critical bugs in the database engine and provide test scenarios for testing bug fixes.

Technical Support Analyst

Confidential

Responsibilities:

• Improved customer satisfaction and assisted feedback development for Desktop Tools release to customers.
• Enabled front line support to assist panicked customers by collecting relevant problem information and passing it down to the correct team in Desktop support.
• Testing of BETA Oracle products on Desktop, i.e., NOVELL Networks, Windows NT 3.51, IBM OS2-Warp. Assisted the Oracle kernel development team with critical feedback for release of above products to customers.
• Implemented a local OS/2 LAN Network to support the Oracle Desktop Support bulletin board service. This was a production machine actively used by Oracle customers to download Oracle patches.