Narender Nelapatla Email: ade21g@r.postjobfree.com

SAP HANA Basis/Administrator Phone: 91-630-***-****

SUMMARY:

** **** ***** ********** ** IT and HANA Administration/SDI/BW-BI/SLT/S4 HANA, Business Objects.

Involved in Installation and upgrade SAP HANA system, Smart Data Integration, SAP HANA sizing for customer specific scenarios.

Worked on SUSE 11, WINDOWS administrate an SAP HANA system landscape

Involved in SAP HANA SPS07/SPS08/SPS09/SPS10/SPS11, Backup, SAP ERP, SAP BW, Solution Manager.

Database: SAP HANA, Oracle, Sql 2012, DB2,Sybase IQ,DB2

Involved in information models like Attribute views, Development, Administration BODS, SQL Scripts, Analytical views and Calculation views.

Developed HANA Information composer and trained non-technical user to access data easily for reporting.

Transformations have been applied in SLT to convert data and to fill additional columns of table.

Migrating HANA content from development, SAP Basis issues & Ticket Support resolution, Configuration changes, testing environment to Production environment using delivery units.

Good understanding of various components of SAP HANA, Root cause analysis, Capasity sizing review, Monitoring implementation. Performance issues, Net Work, Space analysis.

Overview working Knowledge of Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.

Having basic knowledge on SAP ABAP to enhance data sources and Customer exit variables in Bex reporting. Capable of writing programs and able to debug complex programs.

Capable of developing universe with measures and dimension objects, join conditions, LOV, Filters, Aliases, context and web intelligence reports.

Handling Business objects Administrative activities.

Expertise in SAP BW/BI, Data modeling, ETL and Reporting.

Worked on DSO’s, Transformations & DTP in BI 7.0

Actively and regularly involved in Load Monitoring of Daily, Monthly and Quarterly Data Loads using Process Chain.

Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, Update rules, Extractors, Info packages, Info object Catalogs, Data sources, Data Extraction, Business Content and Process Chains.

Managing data loads using Full Update and Delta Management.

Extensively involved in setting up the procedures for LO Cockpit Involved in Activating the Business Content Data Sources, Maintaining the Extract Structures. Worked extensively on application specific extractions as well as generic extractions.

Worked on Bex Reports providing insight of Business Intelligence for Formulas, Selections, Calculated Key Figure and Restricted Key Figure.

Expertise in handling tickets, monitoring and Production Support.

Hands-on experience in performance tuning.

Client: Deloitte

August 2019 – May 2020

SAP S4 HANA-SLT-BODS Admin

Worked on Sql Server, Oracle, HANA databases using SUSE 11, windows Operating systems. Worked on OS upgrades, HANA Support Pack SPS07/SPS08/SPS09/SPS10/SPS11 upgrades, Daily HANA Administration Check List, Smart Data Integration, Involved in HANA sizing with team and Customer specific scenarios, Range Partition, Backup and Recovery, Installation and upgrade scenarios.

Worked on S4 HANA Administration, SAP SLT Administration, SAP SLT Logging table issues.

Worked on SAP SLT Re-Replication Issues, HCI, Integration issues, Implementing Expert functions SAP S4 HANA enhancements, Validating the Global HANA, Regional HANA, SLT Triggers, Function Module, Access Plan, Replication Statistics etc.

Worked on SAP S4 HANA CDHDR and CDPOS Tables data and building the CDS view and creating the SAP BODS Jobs, Splitting the year wise Data and updating the Data into Data store tables.

Client: Caterpillar Inc

March 2018 – August 2018

SAP BW-HANA Admin

Extensively worked on SAP BW-BODS Administration, Performance Testing, SAP BODS Designer, Data dictionary, Lineage, SQL, PL/SQL, Workflows, Data Flows, Data Store and Formats.

Worked on BW-BI,HANA Administration, SAP Data Migration, SAP S4 HANA,SAP Data Quality, SAP Data Profiling, SAP Data Governance, Data Profiling and Data Quality tools.

Client: Briggs & Stratton

June 2017 – Feb 2018

SAP BW-HANA Admin

Involved in HANA Administration, Performed different kind of profiling like column profiling,address profiling, dependency profiling, redundancy profiling, uniqueness profiling on IS 4.2

Loaded source data for different countries one by one using Conditional Flows, Scripts and Global Variables.

Performed Mapping, Validations (Lookup, Mandatory, Format), Enrichments in AIO Jobs for Customer Master, Vendor Master, Material Master, PIR.

Client: Adobe, San Jose CA

August 2015 – Dec 2016

SAP HANA-BODS/BW Administration

Responsibilities:

Involved in HANA Security, Legacy systems, SAP SLT Data provisioning, SAP Native HANA Analytics Smart Data Integration, SQL, PL/SQL, SAP IBP, Central management console, SAP HANA SDA, SDI, SDQ, SLT Replication, Webi Reports, SAP MM, SAP PP, SAP SCM, ECC systems. involved in BOBJ Queries from ECC, XS JS, Java Script, SAP Landscape transformation, Python Script, SAP BO Crystal Reports, SQl Server, Smart Data Access, SAP HANA Cloud Platform, SAP Native HANA, BOBJ 4.2, SAP BW, SAP HCM, SAP Logistics, SAP HANA Analytics, SAP CRM, SAP FI, HANA Studio, HANA Security, SAP HANA Security, Tableau, Native HANA, HANA XSJS Scripts, Java Script, Fiori, VDM, Web Intelligence Reports, SAP Integrated Business Planning, Analysis Office, HR, Run time HANA, SAP Basis Admin, ABAP.

Involved in SAP CRM-Tableau Sales and Service module master data ad-hoc reports.

Worked on HANA-Tableau Sales order historical data reports and current year data reports.

Worked on Cost Center data validation with business rules, Web Services, Data Reconciliation. Worked on validating the Material Master Data derivation rules.

Implemented SAP Data Services with SAP ECC Logistics data, SAP ABAP Dataflow, IDOC Data validation, SQL Server, Source Systems configuration, Pre-Load Validation, SQL data validation, Unit Testing (UAT), PL/SQL, data loading, EIM, Involved in legacy systems and ECC systems data validation, Native HANA, Data validation, Web Intelligence (WEBI) reports, LSMW and ABAP.

Worked on cost center data validation with business rules, web services and data reconciliation.

Worked on validating the material master data derivation rules.

Designed ETL frameworks and best practices. Worked on data integration projects with SAP and knowledge of database tables and relationships in SAP.

Worked on SAP Tables and relationships, SAP functional knowledge, debugging, understand ABAP code. Integration experience with source code repositories, Job Server and access server configuration. Working knowledge and understanding relational data models

Experience in data quality module of data services. Used Match-Merge transform to perform customer address cleansing against USPS address directories.

Sound knowledge of various transforms of data services like query, validate, case, match, base data cleanse, table comparison and key generation transforms.

Loaded data into SAP using all methods of LSMW as Standard Batch/Direct input method.

Implemented data mapping strategy for loading data to different Data Marts and Data Warehouses. Analyzed the BW Data model and Business Objects Queries.

Executed data validation, migration rules and supporting to the business users.

Client: Nordyne, O'Fallon MO July 2014 – August 2015 SAP BODS/HANA Administrator Manufacturing Company

Involved in Implementation of Data Migration from Legacy systems to HANA ECC and involved in BOBJ Queries from BOBJ 4.2, SAP BPC, SAP HANA Security, HANA Administrator, Issue/Ticket Support resolution, SAP HANA Live, Virtual Data Model(VDM), HANA XS, Web API Development. Web Intelligence Reports, UNIX Shell Script, Startup Scripts, Shell commands, HANA Basis, Lumira, SQL Scripts, ABAP Programs, SAP SLT Replication, IDOCs, HANA Migration, User Security validation, Root cause analysis, Performance tuning, Capacity/Sizing review, XML data validation, Information Steward, BAPI function modules.

Load data into SAP HANA Database from Legacy systems data.

Designed data models in SAP HANA Studio (Attribute view, Analytic View and Calculation View, Analytic Privileges).

Worked on Functional Mapping specifications, worked on changed logic from the business, Data validation with business rules, Infocube Star Schema, HANA Calculation views, Monitoring Implementation, worked on validating the ECC table’s data.

Ensure quality of the deliverables from the team by conducting quality reviews.

Identifying the risks and preparing risk Management Plan. Worked on SAP HANA Data Provisioning and using (SLT). Involved in SAP ECC table data model and analysis.

Created SAP HANA data modelling using attribute Views, Analytic Views, and Calculation Views.

Involved in SAP HANA Administration including managing schemas, data model objects, and import/export content.

Extracting and loading large amounts of Data using SAP Business Objects Data Services.

Information Modeller Data Foundation and Business Layer with BO Universe Creation.

HANA Implementation for real time Stock Out and Sales Analysis.

Client: Forest Laboratories, NY, Commack Jan 2014 – Jun 2014 SAP BW/BO Administrator Manufacturing Company

Involved BW Redesign Project and Involved in BEx Queries, SAP Security, SQL Scripts, Shell Script String field processing, LSMW, Configuration, Business Objects reports.

Timely and accurate Status update of the work in hand to concerned person.

Preparing the end user training documents and ensuring the Quality of the deliverable products.

Expert in understanding of complete architecture (Data loading, Data modeling & Reporting)

Worked on SAP HANA data modeling using Attribute View, Star Schema.

Dashboards using IDT (Information design tool)

Involved in Setting up the BOBJ properties, Design Studio, Address verification, Information Steward, Filters on Workbooks and BEx Queries.

Worked on BW Data model old design and proposing the new design, IDOCs, Information Steward, XML data, Tomcat, Performance considerations.

Worked on data validation on BEx Queries and Business Objects Reports and moving the changes to Quality and production

Client: Limited Brands, Ohio, Columbus Sep 2013 – Jan 2014 SAP BODS-HANA/BO Administrator Manufacturing Company

Involved in SAP BODS, EIM, Configuration, HANA Migration, HANA Security Levels, SAP HANA Security, SQL Scripts, SAP HANA XS, VDM, LSMW, HANA Basis, SAP PLM Implementation and Custom Function modules for the Specification and Recipe management data.

Involved in Setting up the BEx properties, Query Designer, Analyzer, Workbooks and Structures. Restricted the characteristic values and Key figures.

Worked on Hierarchy Data, Web API Development, Function module Extract structures, HANA Live, HANA Attribute views, IDOCs, Calculation Views, XML Data, Data cleansing, Information Steward, Replication for the BODS trouble shooting jobs, Address verification, maintaining data sources.

Worked on BEx Queries, Variables, Data validation, Attribute values, Authorizations, default values.

Worked with Functional area of EHS and QM modules. Involved with Specification types, Specification categories, HANA Database sizing, Classes and Property tree data validation with NWBC transaction.

Worked on BODS Source Database and Target Database validations, checking the Central repository and Local repository Data store connections and transformations, sending the Files to respective destinations.

Built Info Cubes, DSO, Info Sets and Core Reporting Queries, Business Objects 4.0 development, Reporting Scenarios.

Involved in BW extraction, Custom Function modules, Data validation with Background user.

CLIENT: BEAUMONT, MICHIGAN, TROY Jul 2013 – Sep 2013 SAP BODS-BO ADMINISTRATOR HEALTHCARE INDUSTRY

Extensively worked on SAP BODS Designer Components- Projects, Jobs, Information Steward, Performance Testing, Workflows, Data Flows, Data Store and Formats.

Worked on Information Steward, LSMW, SQL Scripts,Data Profiling and Data Quality tools,

Good Knowledge in Data Warehouse Table analysis and Implementation.

Validated the BODS data with new versions of data changes from Development to Production.

Involved in initial & incremental Extraction and Loading of data into Data Warehouse using SAP BODI.

Created mappings using Merge Query, Case, Date Generation, Xml pipeline, Table comparison and Lookup..

Good knowledge on DBMS concepts like conceptual, Relational schema, Normalization, Demoralizations, Indexing methodology etc.

Developed highly complex WEBI reports using various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking, Controlling lov’s incorporating sound business logic.

Good knowledge in deployment, Tomcat, Web services, Java, Web sphere, unit testing and user acceptance testing thereby ensuring quality assurance

Having excellent communication skills and good team player with the ability to work in association with team members for successful implementation of projects.

CLIENT: GEORGIA PACIFIC, ATLANTA, GA Jun 2012 – Jun 2013 SAP BW/BODS/BO SENIOR CONSULTANT MANUFACTURING INDUSTRY

Responsibilities:

Worked as BODS Developer, Business Objects 4.0, SQL Scripts, Data Services, HANA Live, Data Integrator Functions, Technical and Functional Specifications, Performance Testing, Finance data validation, Sales territories, HANA XS, Web API Development, BEx Query Designer, BEx Analyzer, Conditions, Exceptions,HANA Modeling, Tomcat, MDM, Web Application Designer, Global Structures and Formulas.

Extensively worked on SAP BODS Designer Components- Projects, Jobs, Performance Testing, Workflows, Data Flows, Information Steward, XML,LSMW, Data Profiling, Address verification, Web services, Java, Data Quality, Data Stores.

Good Knowledge in Data Warehouse Implementation.

Involved in initial & incremental Extraction and Loading of data into Data Warehouse using SAP BODI.

Created complex mappings using Merge, Query, Case, Date Generation, Xml pipeline, Table comparison and Lookup..

Good knowledge on DBMS concepts like conceptual, Relational schema, Normalization, Demoralizations, Indexing methodology e.t.c

Good in writing complex SQL query on various RDBMS system.

Worked on Data Migration from SAP and non SAP Data to Target databases.

Custom development and adding the Navigational attributes to the Info Cubes and Multiprovider.

Involved in adding the New Master data Info Objects to the existing Aggregate Cubes and activated the aggregate Info Cubes.

Involved In Restricted Key Figures, Calculated Key Figures and Filters and Bex Variables and Imposing the Processing Options.

Worked on SCM, ABAP Custom development, Informatica,SQL Scripts,APO Demand Planning,Function modules, BADI, Vistex Bill backs, Agreements, Global Claim Requests Master data and Transaction data loads using Process Chains.

Designed & developed Sales Commission Reporting using the Vistex sales incentive module (/IRM/

LIS_RM_IPSIHDR,/IRM/LIS_RM_IPSIITM,/IRM/LIS_RM_IPSIKON)that is integrated with SD module.

Involved in SAP BW Development area and Front end reports Bex Reports, HANA, Building the BICS Connection ( Business Intelligence Consumer Services ) to BEx queries, Business Objects Explorer 4.0, IDT 4.0, Universe Designer Tool, Business Objects Analysis 4.0, Crystal Reports 4.0, Business Objects Dash board 4.0,Business Objects Mobile User 4.0 with respect to the business requirements.

Involved in Business Objects Information Design tool, Web Intelligence 4.0, Business Objects enterprise 4.0 developments.

Environment: ECC, COPA, SD, SCM, Vistex, Business Objects 4.0, ABAP.

CLIENT: NOVUS, ST. LOUIS MO Apr 2011 to May 2012

SAP BODS/BO ADMINISTRATOR MANUFACTURING INDUSTRY

Responsibilities:

Understanding the requirements and feasibility.

Extracted data from SAP ECC SYSTEM and loaded into target ORACLE database system.

Design, develop, test and implement Extraction, Informatica, SQL Scripts,Teradata, FI-CO Transformation and Loading (ETL) for SPECS data warehouse using Business Objects Data Services (BODS).

Create Projects, Batch Jobs and Real time Jobs, Workflows and Data flows using object library.

Configured Business Objects Data services 3.2 with some source system as R/3(ECC 4.5) and NON-SAP Data as source system.

Configured the Job Server and Access Server with Server Manager.

Extracted sample data from SAP ERP ECC 6.0 source system from Master Material Data tested by running the sample reports.

Configured the IDOC to Extract the Real Time Data By configured the Real Time client in SAP ECC side.

Created Distribution Model to send IDOC to Data Services.

Created a Real Time Job to extract the Data where Real Client provided from the source system.

After receiving the source data through online from SAP, I applied different transforms like

Data Integrator (Hierarchy Flattening, History Preserving, Pivot, Table Comparison) Data Quality (Data Cleanse, USA Regulatory Address cleanse).

Involved in SAP BODS installations and integration with sap systems.

Applied pushdown operations to minimize the time taken by the Job

Using BODI/BODS, created the project to extract the data from different systems and loaded into SAP BW/BI.

CLIENT: FPL, FLORIDA Jan 2011 – Apr 2011

SAP BODS/BO CONSULTANT ENERGY INDUSTRY

Responsibilities:

Understand the customer business and their needs scenarios and suggest them to go with the best solutions which are possible with sap bods.

Explain the benefits of rapid mart packages and suggest them to implement in their project and involved in installation of rapid mart.

Involved in documentation.

Involved in SAP BOBJ DATA SERVICES objects and functions like (creating project, Teradata, Dataflow, Workflow, queries, transformations, repositories and repository manager, SCD’s, time dimension implementation, functions like date function, SQL Scripts,pivot and reverse pivot, CDC’s, integration with sap systems, data assessment, try catch, multi user access in BODS hierarchy data handling and look up functions… ).

Involved in Rapid mart package XI3.x, rapid mart implementation and configuration, variables creation, file maintenance, creation of rfc connections and documentation.

Involved in Rapid Mart Custom field enable and enhancements, central repository customization, SCD’s customization.

CLIENT: ABBOTT LABS, IL Oct 2010 – Jan 2011

SAP BODS/BO CONSULTANT PHARMA INDUSTRY

Responsibilities:

Created Simple/complex Transformations in Dataflow using Data Integrator Designer.

Design and develop Data Integrator scripts for data transformation.

Extracted the data from Oracle 9i and Sybase, SQL Scripts,applied different transformations, cleansed and then loaded the data into Oracle 9i.

created Projects, JOBs, Workflows and complex Dataflow

Extracted the data from the client system through the FTP then using these flat file data source, created ETL to load into target system.

Created Projects, JOBs, Workflows and complex Data flows.

Co-coordinating with client to gather the new requirements and working with existing issues.

Understanding Various Universes.

Created monthly and daily basis reports using universe.

Design and Create the Universe with required classes and objects, modifications and maintenance of Universes on Oracle Database.

Created Dashboards for Top management using Xcelsius 2008 using Live Office and QAAWS by using various components.

Developed Xcelsius Dashboard on top of Webi report.

Developed what-if analysis dashboard to analyze how different decision effect.

CLIENT: KLA TENCOR, MILPITAS, CA Aug 2010 – Oct 2010

SAP BODS/BO CONSULTANT PROCESS CONTROL EXPERTISE

Responsibilities:

Involved as SAP BOBJ ETL Developer from Realization phase in End-to-End Data Warehouse implementation project.

Extracted data from SAP SYSTEM and loaded into ORACLE database system.

Configured Business Objects Data services 3.2 with source system as SAP ECC 6.5.

Configured the Job Server and Access Server with Tool called Server Manager.

Create complex transformations in dataflow.

Extensively used recovery mechanism.

Created a Real Time Job to extract the Data where Real Client provided from the source system.

After receiving the source data from SAP, applied different transforms in Data Integrator (Hierarchy Flattening, History Preserving, Pivot, Table Comparison).

After receiving source data I added some columns to target database table by using look up function(LOOKUP_EXT).

Enabled the MAP_CDC transform operator to capture the changes at source side.

Implemented different SCD TYPE 1 and SCD TYPE2 to load the current and historic data.

Created different variables i.e. global variables, local variables, parameter and substitution parameter those are created at different levels i.e. repository, job, workflow, dataflow etc.

Implemented the conditional operator to load either full load or delta load.

To increase the performance at project level we created embedded data flow (To reuse the objects and to debug the objects) and we enabled degree of parallelism at job level.

CLIENT: PEPSICO, PLANO, TX Nov 2009 – Jul 2010

SAP BODS/BO CONSULTANT CONSUMER FOOD PRODUCTS

Responsibilities:

Involved in SAP BW/BPS integration with HCM, Architect, Business Objects XI R3,Business Objects Solution Architect, Data Analyst, Data Services, Asset management, SCF (Supply Chain Finance), BU Finance, Sales Finance,SD, Performance Tuning, Project Systems, SD (OTC, QTC, ITC),Tax Planning, MRE (Management Reporting), BPS,CRM TPM (Trade Promotion),Open Hub, TFM, TCM AOP and Forecasting Planning Models, Analyzed the Data model and Data flow.

Created Planning Levels, Functions and Global Planning sequences for different Application areas.

Extensively used Calculations, Sorting, Rank, Drilldown, Drill through, Slice and Formatting, Changing Displays and Prompts while creating BO reports

Involved Performance Tuning, Control-M jobs to Schedule Global Planning Sequences and used UPC_BUNDLE_EXECUTE Program to execute the GPS’s in the process chain.

Worked on Production issues using SM 7 & Star Team Issues based on the priority of the Tickets.

Worked on Production Fire Fighter Id to Run the Business effectively and Involved in the Log Report.

Environment: SAP BI, Business Objects XI R3, SEM/BPS.

Client: Applied Materials, Santa Clara, CA Nov 2008 - Oct 2009

SAP BODS Consultant, ECC 6.0 Manufacturing Industry

Responsibilities:

Involved in SAP BI integration with FI Asset management, HCM, FICO, PP, PM, SRM, BCS, BPS, BPC, Supply chain management, Business Objects XI R3, Xcelsius, Data Integrator, PM, PP (BOMs, Workcenters, Routings), Service Analysis, Service Contracts, SD, ECC CO-PA, BODS, FI, SD, HR, Security design, CRM, Install Base, QM,, Tera data, SRM and PS modules, Analyzed the Data model and Data flow.

Consolidated data from both Booking and Revenue planning area for Opportunities into one Cube to create several reports as required by the client.

Worked on Customer Master Data BI Integration on CRM, Data Services, APO (SNC, EM) and ECC SD (OTC, QTC, ITC) modules.

Involved in preparing the Business Blue print for the solar business Operations.

Worked on SAP BI Integration with the Legacy data Base DB2.

Involved in FI Booking/ Billing/ Backlog, Cash flow Report, Milestone Payment Report.

Environment: SAP BI, Business Objects.

Client: Estee Lauder Aug 2008 to Nov 2008

SAP BW/BO Consultant Manufacturing Industry

Responsibilities:

Worked on SAP BI integration CO-PA, FI, Business Objects XI R2, FI Asset management, Supply Chain Management, CRM, SRM modules, Analyzed the Data model and query performance.

Involved in Shopping cart Data issues for end users using Uni center Remote control tool.

Worked on configuration testing using Mercury tool to track the defects and maintained the status.

Worked extensively with the major functionality of FI and SD (OTC, QTC, ITC), Data Services, Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.

Maintenance of master models such as various sales forecast models

Supported configuration and enhancement activities for supply chain activities especially in the areas of MRP, Master Data, Forecasting, Planned order and production order processing

Involved in SAP BI integration with SAS, DB2, SRM and ECC PS module.

Worked on WBS element for PS module.

Environment: SAP BI, Business Objects, CS, Install Base, PS.

Client: Nestle, Glendale, CA Dec 2006 – Jul 2008

SAP BW/BO Consultant Manufacturing Industry

Responsibilities-

Worked on BI integrated planning, Data Services, FI Asset management, Supply Chain Management, PM, MM, SRM, SD, BW/BPS Integration CRM TPM (Trade Promotion) and Consumer Campaign scenarios.

Worked on CRM Trade Standard Event Planning level YTEL0001, Free Goods event planning level YTEL0002 and Long Term event planning level YTEL0003.

Worked on CRM Consumer Activities for Cost Planning.

Worked on daily issues using Peregrine tool and data transferring from CRM to BW Transactional Info cubes.

Analyze BPS Budget Formulation with Top Down and Bottom up planning.

Worked on adding new key figures for Romania market Info cube YRO00002 at Planning Level and Planning Layout and maintained the properties for enhancement Layout, maintained Key figures in the CRM, BW relation table, transported the Layout from the Global Track.

Analyzed the business requirements for the planning profile and the planning profile group and maintained the CRM settings.

Environment: BW, BPS, PS, CRM TPM, Business Objects, Integration BW &CRM.

Certifications: C_HANAIMP141 Certification.

.

Contact this candidate