PREM CHOUDAVARAPU

(SAP BASIS and HANA Administrator)

adqtpb@r.postjobfree.com

Mobile: 216-***-****

More than 12 years of experience in SAP and 6+ years in SAP BASIS and HANA Administration.

Experienced IT professional over 15+ years in SAP and non-SAP systems.

Worked as a Developer, Lead Application Developer and Scrum Master in Product development and Integration projects.

Excels at completing projects that meet corporate goals and expectations, improving productivity and workflow and enhancing maintaining critical business processes.

Well versed in leading projects through SDLC (Waterfall/Agile), Onsite/Offshore resources and working with business and cross functional teams.

Offers exceptional technical, problem solving and system engineering skills.

Strong Technical expertise in the area of Web Application development, Databases, SAP, Mainframe and other application software.

EDUCATION:

Management Information Systems and Computer Applications (MISCA).

TECHNICAL SKILLS:

ERP: SAP S4/HANA, SAP ECC, Net Weaver and Mainframe

ETL: SAP BW/BI, Informatica

Operating Systems: Windows, UNIX and LINUX

Languages: HTML, JAVA, JavaScript, ABAP/4, PERL, C, PL/SQL and COBOL.

Database: SAP HANA, Oracle, MS-Access, DB2 and SQL Server.

Cloud Technologies: AWS (Amazon Web Services)

PROFESSIONAL EXPERIENCE:

Employer: Infosys Limited February 2022 – Current

Position: Lead Consultant

Performing Daily system health check

Configure and Troubleshoot Paymatrix connections which is used for credit card processing

Support ShipERP add-on which is used to communicate with delivery carriers

Support Winshuttle and GIB Plugin issues which are used for Master data upload and Material Management processing

Planning the Cloud implementation for S/4 System

Setting up the AWS infrastructure in Regions and Availability zones

Setting up SAP S4 and ECC systems DR in AWS Cloud

Setting up Direct Connect between OnPrem to AWS connection

Worked with CloudEndure to migrate/replicate data between OnPrem to AWS

Used Homogeneous Migration methodology to migrate from OnPrem to AWS

Maintenance of CloudEndure user console and troubleshooting the issues during the initial and continued replication process setup

Environment: Linux, SAP Solution Manager, SAP ECC 6.0, SAP S4/HANA, ServiceNow

Client: HILTI December 2020 – January 2022

Role: Offshore Lead coordinator to support SAP BASIS team

Worked as SAP BASIS and HANA lead administrator

Being a key role in COE team, conducted seminars to business users to provide the benefits of S4 / HANA and Solution Manager.

Train the Junior and Senior associates in technical aspects of SAP BASIS and HANA Administration.

Mentor the team in handling L1/L2/L3 support and provide top of level service to the clients.

Part of Greenfield implementation project to support client.

Lead MS team to support the critical applications (like: Printers, Calendars, Batch jobs)

Set up the scheduling the jobs and do maintenance as needed using Automic tool.

Set up the printers and trouble shooting in SAP and Printaurus software.

Support provided on Service tickets maintenance using ServiceNow tool.

Actively participated in Weekly and Monthly maintenance of the systems

Set up SAP Calendars and maintaining the changes as per the need.

Approving and rejecting the SAP transports.

Used SAP LAMA (Landscape Manager) during the maintenance of the systems

Opened SAP Connections and setup the OSS Users to support SAP tickets

Environment: Linux, SAP Solution Manager, SAP ECC, SAP LAMA, SAP S4/HANA, Automic, ServiceNow, PrinTaurus

Client: Sony Electronics March 2016 – December 2020

Role: SAP BASIS and HANA Administrator

Tuning the SUSE Linux using “saptune” before installation of HANA systems.

Well versed with HANA 1.0 and 2.0 Installations.

Installing HANA Studio and configuring the SYSTEM and Tenant Databases for Administration.

Applying HANA License.

Performing Backup and Recovery of HANA Databases.

Involved in HANA Green field and Brown field (HANA Migration) implementation.

Performing HANA Database Administration, Troubleshooting, Monitoring and Performance Tuning.

Supporting user maintenance in HANA Studio by means of creating users and updating privileges as needed.

Creating system health check report periodically.

Applying SAP license as needed.

Helping project team by moving the transport request across systems.

Involving in production roll-out to administer Basis tasks including Transport requests movement and resolving the issues immediately as they arise.

Creating Background jobs as per project team needs.

Applying in SNOTE, Support Pack and Kernel upgrades.

Creating users and unlocking, setting the passwords as needed.

Supporting System Copy and Database Refresh activities.

Maintaining Profile Parameters and restarting the system.

Analyzing and resolving SM21 system dumps and job abends in SM37 screens.

Taking care of all Support Packages and Kernel Upgrades across the landscape.

Taking care of Transport request to respective systems with proper approvals.

Performing Client Administration including Client Creation, Local client copies, Client export and import, Locking and unlocking the clients.

Performing User Administration: User’s creation, deletion, assigning roles, locking and unlocking users etc.

Performing Transportation related activities including creating domain controller, change request creation, releasing them and importing transport requests.

Definition of Logon groups and Load balancing

Performing daily check list of activities related to Monitoring and Maintenance of SAP system.

Starting and stopping of ABAP and Java applications

Performing Client Refresh quarterly including both pre and post refresh activities

Handled incidents using Track IT ticketing tool.

As part of the team, helped to resolve daily operational issues in system health check

Analyzing short dumps and system logs

SAP HANA knowledge in Installation and Administration from HANA Studio

Performing Backups and Restore on HANA Database.

Performing Data base Administration by means of Performance monitoring, checking the space availability and performing backup and restore.

Scheduling Database backups from HANA Database studio

Performed Backups using DB13 and other DB Activities using BRTOOLS.

Environment: Linux, SAP ECC, SAP Solution Manager, SAP S4/HANA, ServiceNow, ControlM

Employer: ADP, Los Angeles, California December 2008 – October 2015

Position: Lead Application Developer and Scrum Master

Worked as a Scrum Master for multiple teams and balanced the management expectations with the team needs to deliver the product as needed to Product Owners.

Closely worked with Workday management to deliver the payroll product integrated across multiple countries as per country specific rules.

Worked with Automation teams to automate the processes in parallel to the development which helped in regression and integration testing.

Helped the scrum team member in resolving any issues in respect to functional or technical by reaching out or escalating as needed to get the things done.

As a Technical Lead I was supported multiple testing project teams in the areas of SAP, BI, Mainframe and open systems (Web portals).

Supported offsite quality testing team and technical members mentoring on the new enhancements and helping to resolve the issues.

Maintained FTS (SAP) and BW EOD jobs in multiple systems in multiple landscapes.

Setup Jobs as needed for the Project & SR testing and synch the jobs in other environments once the SR/Project is released to Production.

Support provided to multiple teams in respect to Job abends/manual configuration.

Maintain Mainframe regions to support nonproduction data in regards to jobs setup and JCL changes as per QA need and synch the same in other regions.

Performed data Archiving in SAP Regions and Purge in Mainframe regions.

Provided ChangeMan support for Mainframe packages.

Configured and supported Open Systems (Java & Web based) interfaces to SAP regions in respect to file transfer and triggering the events.

Setup and maintained Control-M Enterprise to control the events between SAP and Open Systems.

Worked with Basis & DBA’s on abends related to space and table issues.

Worked with Production support teams in better understanding the process flows and maintaining the same across QA regions.

Created and mentored the QA teams on the enhanced process flows to simulate the production setup.

Managed offshore support team for Project & SR testing.

Mentored offshore team to the latest updates related to project status, abends and issues.

Worked with JCL to override the jobs as per QA specific need.

Reviewed SAP Transport Ripples across the landscapes and worked with Change management team on fixing them.

Supported the Functional groups in fixing the hot production issues, related to SOP File processing, Payment run errors for Invoice creation and printing etc.

Actively involved in installing and configuring the Informatica to implement Data subset and masking module.

Lead the Informatica implementation to subset the data from Mainframe and DB2 sources and created and applied the masking rules on the sensitive data.

Environment: SAP BI 7.0b, SAP 4.6c, DB2, Mainframe, COBOL, TSO, Informatica, UNIX, Control-M and ChangeMan.

Client: Sony Electronics, NJ and San Diego, CA. July 2004 – December 2008

Position: SAP BW Consultant (SD, MM, FI, CO)

APO Factory Week change & BI Functional Upgrade August 2007 – Dec 2008

Business (Planning & Commitment) has a request to change the Factory week definition starting with Monday-Sunday (Previously Saturday to Sunday).

Actively involved in identifying the Functional Area / Objects which require changes.

Involved in the group meetings to discuss the functional change need to be made to reflect the Planning business change and reporting.

Updated the required functional & technical documents for the change.

Involved in testing the changes across the landscape.

Did POC for 3.x reports migration to BI and identified the issues to be resolved during such process.

Sony Custom Security was tested for 3.x converted reports in BI.

Did POC for converting Sony Custom Security into BI Security analysis model.

Actively participated in changing the data model from 3.x to BI. Developed DTP’s, Transformations, DSO, PSA and actively involved in resolving the issues during the conversion.

As part of Black Box Decommission (Legacy final elimination) identified all the places especially outbound programs which send OMS converted data to downstream legacy systems and actively worked in replacing the code/logic to use the OMS.

Actively involved to help the POC for BIA (BI Accelerator) to increase the fire power for reporting.

BW Technical Upgrade to BI and Black Box Elimination Aug 2006 – Aug 2007

Developed the Visio Flow documents for the existing data model (consist of Legacy and Current Business cubes) for all application areas.

Conducted the meetings to mentor the documents among the team.

Actively involved in identifying and eliminating the Legacy Master & Transaction data which will become Obsolete.

Developed the Model to convert the load the Legacy data into Current Business format.

Consolidated the Legacy Oracle Inventories into OMS (Current R/3) Inventories.

Developed the Master Data model to Consolidate Oracle relevant Products/Materials into SAP Material MD object.

Developed ABAP interface to read/filter/validate Oracle MD from Legacy STN Master Data to generate flat files which be loaded into Material Master Data.

Developed interface/FM for Master data validation/look-up to verify the existence of Material/Products in Legacy vs SAP.

Developed ABAP interface to clean-up Forecast Product MD which comes from Tokyo to consolidate into existing Product Master Data for reporting the Forecast data for these materials.

Actively involved with APO team in bringing the Inventory Days of Supply data.

Actively involved in testing the BI objects after the technical upgrade to BI.

Actively involved in moving the CTS to Production during the cut-over.

Performed data reloads in logistics areas as per the requirement because of introducing the changes in the project.

Developed the simulations of BI new functionalities like DTP, Portal reporting, Query Migrations and created Position documents which reviewed with the team.

MyPlanIT Implementation April 2006 – August 2006

Worked as a lead and managed multiple resources at onsite and offsite locations.

MyPlanIT is a 3rd party Planning tool used for Procurement Planning at Sony.

Worked with the Planning team in identifying their requirement to provide data for their planning.

Discussed and Business logic/transformation required before sending the data to their server.

Developed complex ABAP programs simulating the listcube functionality and applying the business logic to send Orders, Procurements, COPA, Inventory, Receipts/Payments, Forecast & Master Data.

Developed the System scripts for the end users and planning team to validate the data between BW source and planning tool.

Performed System and Integration testing with Planning group to validate the data against the planning buckets.

Developed Process Chains to automate the outbound extracts.

Actively involved in Production Support activities and doing the Knowledge Transfer to production support team.

SOAR Implementation (Sales Order Account Receivables) July 2004 – April 2006

BW All hands Consultant in SOAR (Sales Order Accounts Receivables) Project.

Extensively working with the ABAP in converting the GPSPSI reports to generate as Batch jobs (Simulating the Listcube functionality).

Helping Production Support team for their data restatement loads.

Developed complex queries in SD, MM, FI, and CO functional areas, and also developed relative Workbooks and WAS.

Actively involved in Production Support for any query or objects enhancements and also replicating the same in Production Sync activities as part of BT (Business Transformation) project.

Involved in Building and Executing the Scripts (Integration, Performance, E2E) in different phases of the project in FI, SD, CO, MM areas.

Closely worked with the Business to understand the new reporting requirements and also to improve the existing reporting analysis and performance.

Closely worked with the APO team in bringing the Order Forecast details into BW and developing the Queries as per the user requirements (Ex: Combined report for Forecast, Commitment and Orders)

Worked in integrating Sales History data with COPA (Customized) and generating reports including WEB.

Developed Process chains for Master & Transaction data loads to automate the Batch process triggered by Control M.

Extensively with AR in bringing Aging data (Customized) and developing reports on Multi provider.

Developed VB scripts and embedded them into Workbook on specific requirements (Customized Printing, Setting the Reporting data to the date of report refresh rather than reporting print date).

Involved in AR developments to satisfy complex reporting requirements, like to consolidate Disputes, Chargeback and Credit memo details in one single report.

Actively participated in setting and testing the security as part of SOAR project.

Involved in different phases of testing, (Integration Test, System Test, Performance and Volume testing)

Extensively worked on SAP Solution Manager Tool in raising the error tickets and documenting the Technical and Functional documents.

Environment: SAP BW 3.0b, SAP 4.6c, DB2, ABAP/4, SD, MM, FI, COPA and MM, Control M

Client: SC Johnson, Racine, WI April 2004 – July 2004

(Genesis10 & Adecco Technologies)

Position: SAP BW Consultant (SD, MM & EBP)

Implemented & Supported BBP (EBP) Standard/Custom ODS and Cubes.

Enhanced EBP Data sources wherever Business Content was missing.

Worked on extraction and loading issues

Analyzed performance issues, documented the proposals and implemented the solutions.

Helped super users in reporting problems (Authentication, extraction or bad data etc)

Extensively worked on Transports using Rev-Trac.

Developed Custom Tables, Programs and Function Modules to Automate the process of identifying the Data classes which needs to be taken care before doing the extraction.

Automated Programs and Batch schedules.

Worked on OSS for searching and opening the tickets.

Used BEx to create Reports and analyzing the problems.

Environment: SAP BW 3.1 and 7.0, SAP 4.6c, DB2, ABAP/4, SD, MM, EBP, Rev-Trac,

Client: Avaya Communications, Denver, CO June 2003 – April 2004

(IBM Global Services & VOLT Technologies)

Position: SAP BW Tech-Functional Consultant

Gathered the User reporting requirements by means of existing reports which are generated in R/3 and conducting sessions with domestic and international users using Web-ex and Net meetings.

Made analysis on the reports for DP (Demand Planning), RL (Reverse Logistics), OM (Order Management) and Quality Streams.

Performed GAP Analysis by comparing the SAP Business Content with the user requirements and documented the results.

Based on the GAP analysis approvals, satisfied the GAP results by enhancing the Master / Transactional data sources in Source system and mapped to the standard/custom objects in BW.

Enhanced the R/3 sources in 3.x version (Domestic box) and updated the Cockpit in 4.x version (International box) where ever applicable.

Prepared Technical and Functional documents to have Client signoff for the development.

Designed the Data Model for the Cubes by identifying the related Dimensions to have good performance at Data Extraction level as well as Reporting level.

Developed the Data Targets (Cubes / ODS) to satisfy the reports by creating the Info objects, Mapping the Transfer Rules.

Transfer / Update routines being developed and used where ever required.

Since most the sources are related to Logistics (SD, MM and Inventories), prepared project plan and implementation strategies to Setup LIS environments for S26xxx tables and LO 2LIS structures.

Unit tested the objects before raising the transports and participated in String/Integration Testing with the other teams.

Solved the problems that have seen in testing by raising the OSS notes and finding the existing OSS fixes.

Conducted sessions with the users to validate the data for Signoff by creating testing queries.

Actively participated in assigning the reporting authorizations for the users (Local & Super users).

Developed RRI (Report to Report Interfaces) to jump from Summarized data to detailed data.

Helped Developers by means of documents and demos.

Created Process Chains to automate the extractions.

Worked with Autosys (3rd party scheduler tool) to automate the process chains.

Properly tracking the Transports with the help of PPR (Production Problem Report) and TPR’s (Test Problem Reports).

Closely worked with the Basis team to have required space for Go-live and worked to improve the performance at the time of ETL and have created index in R/3 tables where ever necessary.

Environment: SAP BW 2.0b/3.0b, SAP R/3 4.6c, Oracle, Windows NT, ABAP/4, FI, CO, SD, PM

Client: Avaya Communications, Somerset, NJ Dec 2002 – June 2003

(IBM Global Services)

Position: SAP BW Consultant for AMS (Application Maintenance Services)

Involved in discussing and analyzing the user requirements with the Business Partners.

Developed custom ODS for Equipment’s and Contracts, Basic cube to group them and Multi cube for analyzing the Contracts and Equipment’s on Sold To, Functional Location and Solution Element level as part of Plant Maintenance module.

Developed demo queries to see whether the reports are up to end users perspective or not.

Developed RRI (Report to Report Interface) reports between the Equipment, Contract detailed ODS data and the summarized Services cube data.

Extensively worked on Transporting and fixing the problems that rose while moving the objects from Development to Testing and to Production.

Made estimations and loaded the required Master and Transaction data from R/3 into Production box.

Involved in loading the data from Non-R/3 systems like Informatica.

Good work around knowledge in Maestro database.

Involved in On Call supporting for Production daily data loads for Financial Cubes like Expenses, Segment, Channel, Products and IOMR.

Involved in System upgrade to BW 3.0B.

Involved in designing the Project plan and setting up the system landscape for BW Upgrade.

Properly documented the Upgrade process along with the implemented OSS corrections and the answers to the problems.

Extensively worked with SAP Developers (SAP AG) by opening the OSS notes and doing follow ups to resolve the problems related to Data loads, transports and Alpha Conversion problems in system upgrade.

Extensively used ABAP in analyzing, writing and modifying the custom extracts, transfer and update rules.

Always helped co-developers in helping and solving the problems on the way.

Actively conducted the meetings to discuss the project status and for resource requirements.

Good knowledge in Autosys to schedule the batch jobs.

Environment: SAP BW 2.0b/3.0b, SAP R/3 4.6c, Oracle, Windows NT, ABAP/4, FI, CO, SD, PM

Client: Sempra Energy, San Diego, CA August 2002 – Nov 2002

Position: SAP BW-SEM Consultant

Made detailed data warehousing and reporting analysis for Sempra SM (Supply Management).

Organized BW 3.0 and SEM (BPS and CPM) workshops to the internal IT people and end users to get the awareness of the functionalities.

Created Questionnaires to gather the user requirements in BW and SEM (BPS and CPM).

Interacted with Cost Center Managers and made a detailed discussion between the Pillar and the BPS Planning Analysis in Cost Center planning and expenses planning.

Implemented ASAP Methodology for the Project Plan.

Developed OLAP evaluation Matrixes between BW, Cognos and Business Objects for the IT group in selecting the better OLAP and reporting tool.

Developed Strategic reporting and evaluation Matrix between SEM and Hyperion Products.

Developed BW Demo system with Dashboards, exceptions and web reporting functionalities.

Environment: SAP BW 2.0b/2.1c/3.0b, SEM 3.X, SAP R/3 4.6c, SQL Server 7.0, Windows NT, ABAP/4, FI, CO, SD

Client: McGraw-Hill/Dushkin, Guilford, CT January 2001 – July 2002

Position: Portal Development/Software Engineer

Developed and support provided to gradesummit.com portal.

Worked with user authentication using Session Cookie and .htaccess.

Developed and setup Cron process jobs which are developed in Perl and used to transfer the data between the different RDBMS and clean up the database regularly.

Developed Perl modules including generic Error and Authentication modules.

Extensively used Perl DBI module to develop database objects in Java and Perl using SQL Joints.

Simulated .htaccess (Apache Authentication) mechanism using Perl and PHP.

Developed database procedures (Oracle PL/SQL).

Involved in normalizing the database and developing the flowcharts.

Developed registration process using JSP Pages.

Environment: Linux, Windows NT, Putty, Apache, Mod Perl (DBI, CGI, Encrypt), HTML, JavaScript and Oracle 8i.

Client: Starbase Corporation, Alexandria, VA August 2000 – December 2001

(www.worldweb.net)

Position: Web Development/Software Engineer

Extensively worked on Client customer software (Expressroom) to develop client portals using Content Management technology.

Involved in developing Content Management system for Washington Post (www.postconnections.com), Wallstreet Club (www.rukeyser.com) and for Nascar (www.sceneplus.com).

Developed Servlets as CGI Gateways in Content Management Environment.

Developed Java Components as part of External Applications.

Developed and deployed Entity Business objects on Weblogic.

Developed EJB Components for managing dynamic stock quotes.

Installed and implemented Ad Juggler on Client portal for the hit counts.

Developed Perl Objects (fpl) using DBI and Perl Encryptions.

Developed feed scripts (windows script files) which gets data from different sites and updates and maintains the database.

Developed and setup chron jobs on Windows NT and Unix environments, which mostly involves in database updates, imports and exports.

Participated in modifying and converting the xml assets using the IBM xml4j and xslt.

Environment: Sun Solaris, Win NT, MS 2000 Application Server, Secure CRT, IBM Visual Age for Java, JBuilder, Ad Juggler, ColdFusion, Apache, JRun, HTML, JavaScript, OO Perl, PHP, Java, Weblogic 5.1, J2EE, JSP, Sybase, XML4J, MySql, SQL Server and Expressroom Tools.

Client: MSys Inc., Cary, NC March 2000 – July 2000

Position: Portal Development/Software Engineer

Developed web pages using HTML and JavaScript functions.

Developed Java Applets.

Developed Perl coding for CGI interface.

Developed and published web sites using HTML Frames, forms, tables and style sheets.

Developed Perl script for server side programming.

Developed Java applets to make button like interfaces, image processing and to interact with Java Beans.

Environment: HTML/DHTML, JavaScript, CGI/Perl, Unix and EJB.

Contact this candidate