Data Sap

Nageswararao Charukuri

**************@*****.***

Phone: 304-***-****

Sr.SAP BW/BI/HANA Consultant

PROFESSIONAL SUMMARY

12+ Years of experience in SAP BW/BI/HANA Technologies.

8+years of experience on SAP BW/BI/ABAP Data flows in functional areas like FI(AP,AR,GL),CO,COPA,SD,MM(Inventory/purchasing),PP,QM,PLM,SCM,WM,CRM,BPC,APO&HR module with rich experience in Dimensional Modeling, Data Warehousing concepts and methodologies.

3+ years of experience on reporting tools on SAP Business objects suite using BI launch pad, IDT, WebI, Analysis for Office, Design Studio, Lumira, Business Explorer.

3+ years of experience on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes with migration of BW on Oracle to BW7.5 on HANA.

Strong analytical, problem solving and multi-tasking skills, good communication and interpersonal and organizational skills. Strong experience on agile process.

Working experience in Native HANA with best usage of SLT & BODS and SQL script.

Involved in 2 end-to-end SAP HANA projects involving SAP BODS ETL for data migration/integration from SAP and non-SAP source systems into SAP HANA in SAP BW on HANA, Stand-alone HANA and SAP HANA Sidecar scenarios in SAP Landscape environment

Experience and expert skills in HANA Data Provisioning from SAP ECC, Vistex and non-SAP source systems, flat files into SAP HANA database/other RDBMS solutions using SAP BW ETL, SAP HANA SLT and HANA remote sources and customize BW System.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Involved in Development of WebI Reports and enhancing/modifying existing reports by creating new Formulas, Filters and Charts like Pie charts, Bar Charts & Element Linking, Document Linking etc. as per the client requirements.

Developed WebI Reports As per the requirement bring the same layout with same level of sort’s breaks, sections and variables in WebI 4.X.

Developed Universe using IDT (Information Design Tool) on different types of data sources.

Extensively worked on Business Information Warehouse Info Cubes, DSO's, Info Objects, Info Sources, Multi providers, Data Sources, Transfer Structures, Transfer rules, Update rules, Transformations, DTP's.

Experience in extracting data from SAP R/3 using LO Cockpit, FI-GL, CO- CCA and generic extractors (View, FM, and Info set Query).

Extensively involved in creation of BEx Reports. Worked on Calculated Key Figures Restricted Key Figures, Free Characteristics, Filters and Customer Exists.

ABAP (Related to BW) – Expertise in ABAP programming for writing the User exits using CMOD and in writing the start routine, end routine, expert routine and info object routines, and creating Function modules for Generic extractions,BADI.

Created Universes using IDT on HANA database by using multiple views.

Prepared the plan for cutover activities and ensured successful go live in the given time frame.

Design and development pertaining to change request and design change in the various functional areas.

Having good experience with ER (Entity - Relationship) and dimensional data modeling as well as OLAP. Designed HANA views using SQL scripts.

Worked with LSA and LSA++ Methodology.

Worked explicitly with SAP HANA Live for extracting the SAP R/3 data to BW by creating the HANA views (calculation views) and connecting open ODS view in SAP BW.

Experienced working on Advanced DSO, Composite provider, Open ODS view and Info objects.

Experienced working on HANA Enterprise Modeling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.

Experienced working on: HANA Optimized InfoCubes,Composite providers,Advanced DSO, Open ODS views nd Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA.

Worked on Reports scheduling and publications experience with Info view/CMC

Troubleshooting various ad-hoc issues raised by users for Data and performance issues.

Assisted users in creating Ad-hoc reports and interacted with them for reporting requirements.

EDUCATION

Master of Business Administration from Osmania University in 2004.

Bachelor’s degree in Computer Science from Kakatiya University in 2001.

TECHNICAL SKILLS

Programming Languages

C, C++,ABAP/4,Javascript,CSS,HTML5

Operating Systems

Windows NT 4.0/XP/2000/98, UNIX, Linux ES 5/4, OS/390

RDBMS

SQL

Reporting tools.

Business Objects– Webi4.0,Webi4.1,Dashboards,SAP Design Studio, Lumira, crystal reports, BEX,Microstrategy,Tableau.

SAP environment

SAP HANA 1.0 (SP9), SAP ECC 4.7,5.0,6.0, SAP BW/BI 7.x, SAP BOBJ 4.x, SAP BODS 4.x, HANA Studio, HANA LCM, SAP Solution Manager, ABAP

PROFESSIONAL EXPERIENCE

WBG, Washington,DC July 17 to till date

Sr SAP BW/BPC/HANA Consultant

Responsibilities:

Worked in a New General Ledger project where converting the classic GL models to New GL models by leveraging the new functionalities.

Used Standard and generic extractors for New GL data source like 0FI_GL_14(for GL line items and 0FI_GL_10 for Totals.

Worked in importing SAP BW Models in SAP HANA views, Converting the Standard Info Cube into HANA optimized Info cube,Multiproviders to Composite providers, DSO and Infocubes to Advanced DSO’s, Created Open ODS views and publishing existing models to HANA views for reporting purpose.

Worked in Development of EPM input forms and reports for SAP BPC in Initiative planning, revenue and expense and Capital investment models .

Worked in various enhancement of BPC as per the requirement of Financial policies.

Used extensively the Analysis office for reporting for various reports by using Bex and epm reports.

Develop ETL Jobs with very heavy transformations for data acquisition from SAP ECC and Non SAP systems.

HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.

Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio

Environment: SAP HANA 1.0 SP11, BW 7.4 SP11, Microsoft Analysis office 2.6, SAP BPC.

PSA (Peugeot Citroen Automobiles), New Jersey Sep 16 to June 17.

Sr SAP BW/BI/HANA Consultant

Responsibilities:

Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.

Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.

Assisted SAP Basis team in installing HANA 1.0 and solely integrated it with Business Objects 4.0 and BODS4.0.

Experienced in importing SAP BW Models in SAP HANA, Converting the Standard Info Cube into HANA optimized Info cube.

Defined Data Stores to allow BO Data Services to connect to the source or target database.

Developed ETL jobs to move data from multiple sources to Enterprise Data Warehouse

Integrated BOBJ 4.0 and BODS 4.2 with SAP HANA1.0.

Created Technical specifications and standard modeling documents for HANA.

Design and integrated exiting BODS and SAP SLT with HANA.

Develop ETL Jobs with very heavy transformations for data acquisition from SAP ECC and Non SAP systems.

Data Load via SAP BW extractors DXC to HANA from Legacy BW.

HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.

Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio

Created HANA database users, role, analytical privileges for data and data model security.

Build SAP FI, SD data to build information model for user consumption Attribute View, Analytical View, calculation View.

Worked on procedures and script based calculation view.

Worked in SD, PM, MM and FICO modules.

Create printable reports for actual verses plan data using Crystal Reports for Production, Sales and Revenue.

Integrated Microsoft Office to HANA reporting build scale out HANA design for growth and performance boost and disaster recovery.

Developed testing scripts and performed UAT on SAP net weaver portal using Test ID's for developers, super users, and end users.

Working with SAP BI and BOBJ Business users, Project managers, and involved in requirement gathering, analysis and creation of best practice architecture.

Created SAP Business Objects SAP BW 7.3 Roadmap document, functional and technical specifications for seamless integration and reporting.

Worked with SAP BO, BI, Basis, and R/3 teams and involved in providing integrated solutions.

Management, Folder management in Central Management Console CMC.

Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data sources.

Designed BICS connection in BI 4.0 - on top of SAP BEX queries, enabled OLE DB for OLAP.

Environment: SAP HANA 1.0 SP8, BW 7.5 SP7, Microsoft Analysis office 2.1, SAP BO 4.1 SP6, SAP BODS 4.2 SP1.

LIMITED BRANDS INC. Bangalore, India Aug’14 to Aug’16

Sr SAP BW/BI/HANA Consultant

Responsibilities:

Determines the size and scope for a suitable data solution in BW/BI/HANA projects based on the identified business requirements.

Provides guidance and advice to Sales Executives, Pre-sales and Solution Architect resources on the data approach in BI/BI/HANA projects.

Involved in Setting up SAP SLT/BODS/ Server to replicate data from Source system to HANA Studio.

Involved BW migrating to HANA.

Replicated Table Structures and data from source system to HANA Studio using SLT server for FI-GL reports as part of HANA implementation.

Implemented complex HANA models for various CRM reporting requirements using HANA sidecar implementations.

Worked closely with functional and business team on implementing the first HANA data models to improve critical reports performance.

Created complex Calculation views by using SQL script and Graphical Interface.

Created BO- webi reports directly on calculation views of SAP HANA.

Worked on SAP HANA Security including user management, roles (SQL roles and Repository roles) and privileges. Created and modified packages for the roles and transported to corresponding systems.

Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC.

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

Replication of the selected tables of SD, MM from ECC to SAP HANA. Performed transformations during the replication process and BODS.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Migrating standard Infocubes to In memory optimized Infocubes using migration Tool.

Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.

Importing the BW Models in to HANA using HANA Studio.

Consuming the HANA Models in BW by creating the Transient Providers

Doing the trace for no authorization issues in SAP HANA.

Worked extensively with SQL scripting using calculation views and attribute views.

Completely design the SFC and sales marketing reports as a BI Architect.

Works with project managers, offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.

Leverages knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.

Prepared project deadlines for BI/BI/HANA reports objects and updating daily with status.

Prepared technical design and developed the BEX queries and BO – webi reports for FRESCO and PLM reports.

Worked on Transformation routines and field level routines as per the requirement.

Worked on kanban approach methodology in a complete agile process.

Develops a collaborative working relationship with clients.

Provided knowledge transfer to the users and given training on how to use the BI/BO/HANA application step by step.

Developed webi reports and dashboards from SAP and non - SAP data source (ex: oracle).

Involved in the Creation of Dashboards with the dynamic visibility of the components according to user requirements.

Commonly used Components Line chart, column chart,pie chart, score card, combo box, bar chart, Stacked bar chart, Image component, Rectangle, Label,, Radio Button, Query Prompt Selector, Query Refresh button.

Technically designed and created the cubes, multi providers, DSO’s and Transformation’s by doing mapping between CRM and BW systems.

Connected the CRM and BW through CRM adapter via push mechanism.

Evaluated statistical performance using BW Statistics for optimization. Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.

Involved in data source enhancements for agreement, claims and business Partner using CMOD.

Tested all query performance using RSRT debug mode and executed.

Worked on writing baseline configuration, unit test, string test and integration testing scripts and uploading and executing in SAP Solution manager & HPQC.

Created the process chains and defined the strategy for automating the daily loads and monthly loads as well as yearly loads.

Suggested SCI (code inspector) tool for code reviewing in SAP BI routines to follow code guide lines as per SAP.

Involved in performance ratings and reviews to the team members.

Environment: SAP BW7.3/4 BO XI 4.x, SAP HANA 1.0, Crystal Reports, Tableau, SAP BW 7.x, BEx designer, Analyzer, WAD, Oracle, SQL SERVER, Windows, Linux

Estee lauder, Bangalore, India(IBM). Sep 2013 to Aug 2014

SAP BW/HANA Consultant

Responsibilities:

Worked on SAP HANA implementation, SAP System Landscape transformation (SLT), BODS, SAP HANA data modeling using Attribute View, Analytic View and Calculation Views in Sidecar implementation.

Consumed SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.

Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio

Undergone complete life cycle Implementation of BW 7.x which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO-Cockpit, Info-cubes, Multi-Cubes, SPOs, DSO objects, Info Packages, Transformations and DTPs,BEx- Analyzer and BEx Query.

Extensively worked on SAP R/3 LO-Cockpit CO-PA, Generic Extraction and different modules like SD, MM and FI.

Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).

Developed flexible queries using filters, navigational attributes, variables, Cell Editor in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.

Created the Process Chains to automate the data load and data target administration and monitored the processes.

Comprehensive knowledge using SAP ASAP methodologies in Business Information Warehouse.

Involved in creation of Info cubes, DSO’s and Multi Providers.

Involved in Performance Issues like Creation of aggregates, Partitioning and compressed the Info cube to improve the query performance

Extensively used BEX Analyzer, Created queries by using filters, Variables, Calculated key figures, restricted key figures, Conditions and Exceptions according to end users requirement.

Created of WebI reports using Bex OLAP connection (BICS connection)

Created reports and dashboards for mobile devices like iPad, iPhone and Android

Merged of Non-SAP and SAP objects at report level

SSO authentication set up for SAP and LDAP

Installed of SAP BODS server XI 4.0 (Unix), IPS, and Data Services Designer

Repository created with different databases Oracle and My SQL

Registration of repositories (Local, Central and profiler)

CMS configuration in Data Services using DS Management Console

Creation and configuration of Job Servers and Registration of Data Services in SAP systems, RFC destination

User security management, Scheduling and execution of jobs

Migrated of projects between local and central repositories

Created Data stores, Infocube, Multiproviders in SAP BW as source and SAP BW as target

Created Flat File Format load the data into PSA

Loaded the data in SAP BW from Oracle DB and Flat File

Environment: SAP BW 7.X, BO XI 4.0, SAP BODS 4.0, SAP BW 7.3, 7.4, MySQL, Oracle9i, SQL SERVER, Lumira. HANA

LIMITED BRANDS INC, Bangalore, India(IBM). Aug’10 to Aug’13

Senior BW/BO/HANA Consultant

Responsibilities:

Gathering all the requirements by discussing with Business User and design requirements gathering document.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

POC for steady state for SAP BI system.

Migrated BW into HANA in a Sidecar Implementation

Prepared the Control M schedule for the processing for all Data loads along with scheduling of BO reports.

Developed new custom data sources using data source view. Involved in LO Extraction to extract the data from source systems. Worked on the Enhancement of data source for Lo-Cockpit Extraction

Involved in creation of Info cubes, DSO’s and Multi Providers.

Worked on Transformation routines and field level routines as per the requirement.

Involved in Performance Issues like Creation of aggregates, Partitioning and compressed the Info cube to improve the query performance

Extensively used Web Intelligence, crystal reports, analysis for office, Lumira, BEX Analyzer, Created queries by using filters, Variables, Calculated key figures, restricted key figures, Conditions and Exceptions according to end users requirement.

Worked on BO universe by using UDT, IDT tools.

Created open hub to extract data from Info cube to flat file as per the clients requirement.

Creation of reports & dashboards in Tableau for OLTP & OLAP sources

Published Workbooks by creating user filters so that only appropriate teams can view it

Demonstrated proficiency in analytics, trending, statistical analyses, interpretation of data and produce powerful visuals that present information in a meaningful and insightful

Performance Optimization of dashboards and reports

Preparation Test Case document, BRD and Technical design documents

Acted as go-to person for the team for technical concerns and trained end users on Adhoc reporting techniques

Tracking the project progress and working towards meeting the project specific deadlines consistently

Environment: SAP BW3.5, SAP BW 7.x, BEx designer, Analyzer, WAD, Oracle, SQL SERVER, Windows, Linux, BO3.X, 4.0,

Arla foods, Stockholm, Sweden Sep 2008 to July 2010

SAP BW Lead Consultant

Responsibilities:

Offshore Point of Contact for SAP BI Application for CNOSE sales project.

Analyzing and preparing the Business process, GAP documents and Functional and Technical Specifications. Involved in all the phases of ASAP methodologies.

Identified Data modeling techniques, designed Info cubes, DSO’S, Info objects, Info set and Multi providers as per the business requirement.

Developed the forecasting and planning reports by implementing planning techniques to forecast the production and sales.

Extract the data from SAP ECC from SD, APO, MM, FI/CO,PS systems by using business content and generic data sources.

Tracing problem to ECC and resolution, setting multiple source systems including flat files.

Written Start Routine and end routine at Transformation level.

Thoroughly testing the Data loads and reporting execution time in Testing phase.

Prepared Impact Analysis document

Environment: SAP R/3 Release ECC6.00, SAP BI7, SEM4.7, FI-GL, Windows NT, BEX Analyzer.

P&G, India May 2005 to Aug 2008

BW Consultant

Responsibilities:

Developed new custom data sources apart from using the business content data sources and involved in LO Extraction to extract the data from SAP R/3.

Involved in creation of Info objects, Info cubes, ODS, DSO’s and Multi providers, Info sets.

Involved in optimizing the system performance by using aggregates, indices, partition and compression techniques.

Extensively used BEX Analyzer, Created queries by using filters, Variables, Calculated key figures, restricted key figures, Conditions and Exceptions according to end users requirement.

Identified the GAP’s from existing system with detailed analysis and bridge the GAP with solution.

Offshore Point of contact for SAP BW under BI team.

Worked closely with business users and resolved the data, report issues within SLA.

System support for the Financial Reporting, APO and Order visibility users.

Responsible for All BW data loads which provides data to the BW Reports and to external system targets

Environment: SAP BW3.5 & 7.0, SAP 4.7, HP service center.

Contact this candidate