Candidates About

 

                                            Varun Khanna                                               

                       

Professional Summary:

 

With an extensive 13+ year’s background in information technology, with a diverse knowledge of various SAP R/3 system landscapes, proven experience in R/3 technical support, system administration, project management, training, and customer support. Known for professional quality of work, attention to detail, and participative leadership skills. Goal oriented self-starter with proven dedication towards providing timely, highly available ERP systems to a large customer base. An immediate positive contributor.

 

Technical Skills:

 

SAP Version                           :           SAP R/3 4.6 /4.7, ECC 5.0, 6.0, Web AS 6.x, mySAP ERP2005,                     

mySAP ERP 2004, BW 3.5, BI 7.0, CRM, APO, SCM, EBP , MDG 9.0,

Net weaver Enterprise Portal 7.0          /7.1/7.2/7.3/7/4/7.5, BODS 4.2, BOBJ 4.2

SAP Skills                                :           SAP R/3 Security, HR, FI, SD, CO, MM, PP, BW 3.5 & 7, CRM 7.0, SRM7.0,

SAP BASIS                             :           SAP R/3, BW, EP Server Installation & upgrades, Client Admin,

Spool, database Performance, Applying Patch-Support Packages (SPAM), Kernel Upgradation/Patches, Operation Mode, OSS, RFC, and ALE

SAP Security                           :           SAP R/3 Security User Admin.Role, Authorization, Transport    

Mngt.System, Tracing, User Auditing

SAP Enterprise Portal 7.0      :           Administration: iView’s/Roles/work sets /pages, EP 7.0, UME

                                                            System Definitions, Folders, User, Groups Transport Packages.

                                                            Security: Single Sign on (SSO) using logon tickets User mapping LDAP  

Operating System                   :           Unix (Solaris, 8, 9 IBM AIX, HP-UX) Linux (Red hat, SusE), 

Windows NT 2000/2003 Server

Oracle Tools                           :           Server Manager, Recovery manger (RMAN), Oracle Enterprise manager

 

Databases                               :           SAP DBA Oracle 7/8i/9i/10g/11g/12g, DB2 MS SQL Server7/2000/2005/2016,    

MS Access, FoxPro, HANA 1x SPS11, S4 HANA

Hardware                               :           HP 9000 family series L-Class, N-Class, RP series 2440, 3440,

4620, 5470, 4440, 7440, Superdomes, SUN fire V440, v480, V490, V120

 

Education: 

 

Bachelor Degree in Information Technology – Central Queensland University, Sydney, Australia          May 2003

     

Certifications:

 

• SAP Certified Technology Associate                                                                           Apr   2010
• Microsoft Certified Information Technology Professional (MCITP) – Australia                      May  2011
• Microsoft Certified Technology Specialist (MCTS)  - Australia                                               April 2011

·         Microsoft Certified Systems Administrator (MCSA) – USA                                               Sept  2006

·         ACT! Certified Technical Support Analyst – USA                                                             Jan   2005

 

Professional Experience:

 

Abbott – Chicago (IL), USA                                                                                                  Jan 2017 to Current

Sr. SAP Basis Lead Consultant

   Responsibilities:

·         Lead and Managed the Tech Team for the end to end deployment of multi-release SAP implementation program (Greenfield)

·         Support pack S4H 1511 upgrade and moving to 1709

·         BOBJ 4.1 with Tomcat 7.0 install on N+1 (break-fix) servers and upgrade from 4.1 to 4.2 with Tomcat from 7 to 8 on entire landscape

·         BOBJ 4.2 PROD DR cluster build with multiple nodes

·         BW upgrade from 720 EHP 02 SP13 to 750 SP 06

·         SRM upgrade (ABAP+Java) from 720 EHP 01 SP 10 to 740 EHP 03 SP 16

·         ECC and SRM new system builds and system copies using raw method

·         Preparing TFC for ECC and SRM landscape for SAP review

·         Installing GRC plug-ins and configuring iEnable connectors

·         Solution Manager upgrade from 7.1 to 7.2 NW 740 SP 14

·         Implemented ChaRM, established workflow with Email notifications and alerts, set up charm with dual clients along with setting up Work Center, Incident Management, Early Watch alerts & Monitoring

·         Implementation of MDG 9.0 on ECC 6 EHP 8 SP 7

·         BODS 4.2 with Tomcat 8.5 install including IS, IPS, DS and Platform Services

·         Connecting ECC and SRM systems to TREX and managing issues related to indexing

·         SLT replication in HANA and HANA system refresh using backup/restore method with rename schema

 

 

MillerCoors -  Milwaukee (WI), USA                                                                                               Dec 2014 to Dec 2016

Sr. SAP Basis Lead Consultant

   Responsibilities:

·         Acting as a technical lead for the client and liaising with external vendors such as IBM, HCL and IGATE to ensure smooth daily operations and successful completion of projects.

·         Production support of SAP Systems including ECC 6, NW 7.1/7.2/7.3, Solman 7.1, BI 7.0, SCM 7.0, PI 7.0, GRC 7.0 and GTS 5.1 on HP-UX and UNIX systems as well as Windows

·         Complete SAP HANA installation, including HANA DB, HANA Client, HANA Studio and various other HANA components on both HANA Platform edition as well as Enterprise edition

·         Integration of ECC with HANA Database using the SLT Replication Servers or services

·         Used HLM HANA Lifecycle Manager to Administrate, Integrate, update SAP HANA Components and worked on all Admin Tools for SAP HANA and performed SAP HANA Operations such as Table Administration, Periodic Manual Tasks & Transport Changes

·         Prepared Stable solution for SAP HANA Back Recovery, implemented System Replication and Storage Replication and worked on SAP HANA Scale Out and High Availability Scenarios

·         Implemented SAP HANA security including User Management, Roles, and Privileges

·         Experience in installing SAP FIORI Apps such as Ariba Mobile and SAP Hybris Cloud for customer

·         Installation & Configuration of NWBC 5.0 along with SAP Personas 2.0

·         Creating partner profiles for business interfaces between Legacy and Project Support Systems

·         Performed reconfiguration of SAP ECC and BW production centralized cluster configuration to distributed cluster configuration for High availability, stability and for improved database performance (Oracle 11g & Windows 2003 server).

·         HANA, BODS and BOBJ transports and migrations

·         Tax Accounting Software (Vertex) and MileMaker update with monthly patching.

·         System Refresh, EWA Alert configuration, DB (SQL & Oracle) maintenance, table re-orgs, index rebuilds, datafile space forecasting/calculation and management

·         Service Tools upgrade and Maintenance License renewal for ECC, BI and Solution Manager Systems

·         Kernel Upgrades and SPS Upgrades

·         Troubleshooting portal connectivity and links within portal to ensure no interruption to business

·         System optimization and Performance tuning of various SAP Systems.

 

 

Secure-24 -       Southfield (MI), USA                                                                                     July 2013 to Dec 2014

Sr. SAP Basis Consultant

   Responsibilities:

·         Capacity Planning including Projection for all systems (SAN + DB) of all clients.

·         SAP Database MSSQL 2008 (R2) monitoring and Performance Tuning.

·         Performed Client copy/refreshes and the System Copies.

·         Upgraded SPAM/SAINT from lever 32 to level 36.

·         Upgraded Support Package stack (ABAP+JAVA) from SP Level 18 to SP Level 24.

·         Experience installing and working with HANA Design Studio.

·         BOBJ Design Time Studio Installation (4.1) and patching including BODS transports.

·         Installation of BODS Business Objects Data Services 4.0/4.1/4.2 on Linux and windows platforms and performed post installation activities in BODS such as SAP HANA Client installation, creation of repositories, scheduling jobs and monitoring status and troubleshooting errors

·         Implemented ChaRM in Solution Manager 7.1

·         Liaise with third party vendors to solve the business critical issue on time.

·         Efficiently following the CR process to raise the SAP system changes and follow the SOX standard to maintain the SAP system changes.

·         SAP Disaster Recovery servers setup, configure and maintenance for the SAP ECC6 (IS-U), SAP CRM 2007 and SAP PI 7.0 systems with High Availability (MSCS) configuration on windows 2008 server and MS SQL 2005 database.

·         Worked with RMAN for back and recovery of Oracle Databases, along with working with BRTools and managing RAC systems on ASM and Grid Infrastructure and Data Guard

·         Setup of SAP HANA Peripheral Ecosystem which includes SAP HANA, SLT, BO, including monitoring and troubleshooting

·         Sizing of SAP systems using SAP QuickSizer and HP QuickSizer tools

·         Set up CHaRM including technical configuration of all necessary SolMan and Remote System components

 

 

Engenco -        Perth, Australia                                                                                              Aug 2012 – July 2013

Sr. SAP Basis Consultant

Responsibilities:

·         Data Center Migration planning and execution for entire SAP landscape.

·         Planning SAP ECC Systems Architecture Design and sizing for ESX Virtual Machines.

·         Working on SAP Infrastructure Architecture Server Optimization and Consolidation.

·         Service Tools upgrade and Maintenance License renewal for ECC, BI and Solution Manager Systems.

·         Aligning DB transaction logs backup frequency with Best Practices.

·         Configuring the systems with RFC and SAP Satellite systems for SM7.0

·         Installation of all the required Support Packages and Kernel Upgrade to Latest.

·         Configuration and monitoring of data loads into the BI system and optimizing MRP runs into ECC.

·         SAP Database MSSQL 2008 (R2) monitoring and Performance Tuning.

·         Re-designing SAP Security architecture to minimize risk around access to critical transactions and issues around segregation of duties.

·         Solution Manager 7.1 SPS7 installation along with integration with back-end systems including full configuration such as setting up alert monitoring, EWA’s, RCA, central monitoring, etc.

·         24X7 help desk Support critical Issue Resolution for Basis and Security and managing the process and team to deliver high quality support within SLAs using SM (Service Manager) and Internal Portal.

·         Setup and Configure Solution manager Early Watch Alerts, System Monitoring , Central system administration, Job scheduling management, Business process management, Charm and Maintenance optimizer

Vale -              Brisbane, Australia                                                                                         Feb 2012 – July 2012

SAP Security Consultant

Responsibilities:

·         Writing Business Roles and Security design approach documents

·         Conducting workshop to identify and understand business requirements

·         Maintaining roles and users for development landscape

·         Maintained Master switch to activate HR structural authorization

·         Designed roles and structural profiles for HR, Activated BADI for MSS role

·         Designed and built roles for context sensitive solution for HR, SD and FICO

·         Assigned PD profiles to positions using LSMW

·         Mapping Portal role to ABAP role for ABAP centric role assignment

·         Worked with BI consultant for synchronization of Structural authorization in BI for creating analysis authorizations

·         Building and testing Single, Composite and Derived Roles  in ERP,CRM, SRM, BI, PI, E - Recruitment and Portal

 

 

Accenture -     Queensland Rail, Australia                                                                            Feb 2011 – Dec 2011

SAP Basis Consultant

Responsibilities:

·         Actively participated in SAP Separation Project between QR and QRN

·         Solution Manager upgrade from 7.0 to 7.1 SPS 6

·         SAP Enhanced Monitoring setup on Windows VMware

·         Involved in EHP4 upgrade for R/3, SRM, CRM, SCM and EHP2 upgrade for BW systems. 

·         Post-upgrade activities and UAT validation Implemented EHP5 for ECC6 including activation of various new functions as per business requirements and customization of various repositories after upgrade.

·         Resolving FPN issues, BEx queries and Web Template issues post patching.

·         BPC installation and BOBJ patching (SP4) in QR environment

·         ITSM calls resolution, short dump analysis, managing lock entries, lock/unlock transaction codes, 

·         Displaying and monitoring of Database and Application servers, managing user sessions

·         Handling SAP security for non-prod systems including user access and delegation of roles and profiles and also setting up SNC on application servers

·         Liaising with SAP for issues related to SAP GUI 7.2 upgrade for silent installs published via advertised programs on users’ pc’s and also for HR pay-roll related issues

·         Resolving Solution Manager dumps by running SQL scripts manually and also executing SQL configuration for backend systems by generating sap_coll_user for each system

·         Setup SSO for logon with log-on certificates from the webgui in the WAS (java stack)

·         Carried out tuning of the ITS and successfully carried out troubleshooting of issues with the UME

·         System Refresh Activities, JAVA Schema Export & Import & maintaining system profile parameters     

 

 

Department of Education & Training   -       Sydney, Australia                                           Mar 2010 – Nov 2010

SAP Basis Consultant

Responsibilities:

·         Production support of entire SAP landscape.

·         Transports for BAU and project specific transports

·         Additional DI installs (including ABAP+Java stack) for current landscape.

·         Administration along with Early Watch Reports.

·         Wiley Introscope and Mercury Load Runner E2E analysis and troubleshooting

·         PI interface monitoring and generating of CEPS and PEPS files on a daily basis.

·         Resolving tickets logged by business users through Remedy.

·         Participating in Change Control and CAB meetings and providing input on a technical perspective.

·         Liaise with the infrastructure team in maintaining the local infrastructure – Hardware, Operating 

·         Systems, Database, NAS/SAN etc.

·         Facilitate changes throughout the system landscape and enforce Change Management processes and procedures.

·         QAS refresh and post refresh activities of an R/3 Enterprise System on Oracle 10.2 DB.

·         Redo log duplexing and implementation of remote server site for redo log storage to lessen exposure between recovery points.

·         Installation of BO (Business Objects) Edge Series 3.1 involving Crystal Reports 2008, Xcelcius Enterprise, SAP Integration Kit for BOE 3.1, BOE Client Tools and Live Office 2008.

·         Creation, storage and deletion of data using standard SAP archiving methods to reduce backup and restore times and improve performance bottlenecks.

 

IBM -              Sydney, Australia                                                                                           Nov 2009 – Mar 2010

SAP Basis/Security Consultant

Responsibilities:

·         Implementation of TDMS and data extraction from pre-production systems to non-production systems and getting the systems ready for UAT.

·         BAU transports along with STORM (project) transports into QA and PROD environments for ERP 6.0 as well as BI 7.0 systems.

·         Design, development & maintenance of security roles in ECC 6.0 / DMS / BI and Portals.

·         Familiar with RF Gun technology and worked on Georgia Telnet Server setting up SAP Console 640 and integrating the RF Guns with QAS & PRD systems.

·         Validated the SAP Systems (Solution Manager, ECC 6.0, BI 7.1,EP 7.0, XI7.0, SCM5.0,SRM5.0) of Dev. environment

·         Set up of Central User Administration CUA in multi system landscape

·         Worked with all functional team leads to prepare the systems ready for workshops

·         Configured SAP SNC router on DMZ Machine and successfully established connectivity with SAP

·         Client and end user Interaction for reported authorization issue for more than 40,000 users across the globe

·         Work on profile generator (PFCG) to create roles, composite, derived or global roles

·         Run and analyze trace for missing authorization and take corrective action

·         User and authorization Management like Creation of profiles, granting authorizations.

·         Designing and developing strategies to effectively test new role groups under Informal Integration Testing (IIT) and Formal Integration Testing (FIT)

·         SU24 maintenance for standard/custom transaction & creation of thousands of users for testing

·         BW security - Creation and maintenance of activity groups and custom authorization objects.

·         Creating BW security Authorizations using RSSM transaction

 

IBM -              Melbourne, Australia                                                                                     Oct 2008 – Jun 2009

SAP Portal Consultant

Responsibilities:

·         Implementation of Net Weaver 04 / EP 7.0 SR3 including Trex 7.1 using Rapid Installer 2.1

·         Planning and Installation of High Availability Production Portal with complex architecture including        HACMP configuration, SMD Configuration and Gateway Install.

·         Post installation tasks on EP 7.0 including upgrading the existing SPS 14 to SPS 17, incorporating ECM packages as well as Business Packages along with GRC compilation.

·         Integrating backend systems like ECC and BI to existing portal using SSO.

·         Workflow configuration, administration and troubleshooting.

·         TREX search engine configuration and integration.

·         Configuring Java parameters using Config Tools and other Sap Basis related activities such as patches, notes and upgrades using VA and SDM for portal server infrastructure

·         Went through full lifecycle implementation of SAP (OS, DB and Post Installation and Cluster Administration), system landscape (re)design, Instance design and optimization, Instance design and Load balancing.

·         Involved in Analysis, Design, Development and Testing of SAP Net Weaver Technologies.

·         Experience in taking online/offline Backups, performing system disaster recovery and system cloning.

·         Monitor application performance and recommend optimization efforts for SAP landscape.

·         Perform database monitoring, server tuning, and administration. Oversee backup/recovery       operations.

·         Troubleshoot SAP systems and providing daily monitoring and administration support.

·         Performed KT sessions for transition purposes for post go-live support

 

Australia Post    -                    Melbourne, Australia                                                             Jun 2008 – Oct 2008

SAP Basis Consultant

Responsibilities:

·         Worked on SAP Enterprise Foundation Project involving SAP EPR 6.0 Migration

·<s