SAP Functional consultant. Anirban Dandapat

SAP BW/4 HANA, SAP BW Power by HANA Mumbai -India

Mobile No- +91-970*******

Email Id:

adcyo7@r.postjobfree.com

An accomplished technical professional and a technical consultant with a rich expertise in managing cross technical aspects of Business Ware House and Business Intelligence as well as ERP implementation in the IT industry.

Professional Summary

Over 6+ years of experience in SAP in which 2+ years of experience in SAP BW Powered by HANA & SAP BW/4 HANA, 3 Years in SAP Business information warehouse & 1 years as Business Intelligence Consultant.

Education

1.Master of Computer Application from Dr. BAMU in 2005.

2.B.Sc. (Computer Science) from Dr. BAMU in 2002.

SAP Experience (starting with latest)

●I have worked as a SAP BI Consultant in Tata technologies Ltd, Jamshedpur from Jan 2011 to Dec17

●I am in Joules to Watts, Mumbai from Mar 2019 to Jun’19.

Project Profile:

1.Client: Aricent Technologies (Holdings) Limited.

Duration: Mar 2019 to Jun 2019

Role: SAP BW Power by HANA & SAP BW/4 HANA Consultant

Migrate the SAP BW Power by HANA into SAP BW/4 HANA System in this migration project developed the Aricent SAP BW /4 HANA system.

2.Client: Tata Motors Finance Ltd & Tata Hitachi.

Duration: Jan 2015 to Dec2017

Role: SAP BW Power by HANA & SAP BW/4 HANA Consultant

Migrate the SAP BW System into SAP BW Power by HANA, in this migration project developed the Tata Motors Finance Ltd SAP BW Power By HANA system & Tata Hitachi SAP BW/4 HANA System.

3. Client: Tata Motors & Tata Motors Drive line Ltd.

Duration: Apr. 2011 to Dec. 2014

Role: SAP BW/BI Team Lead

I have implemented the Tata Motors NANO Plant (Sanand) also implemented Tata Motors Drive line ISR Sys.

4. Client: Tata Steel Corus Migration Project

Duration: Jan 2011 to Mar 2011

Role: SAP BW/BI consultant

Migrated the Query, Web Templates, Report to Report Interface (RRI) in this Migration project

Description:

Project 1.

Aricent Technologies (Holdings) Limited designs and develops communications software for the communications industry. It offers middleware, consumer and enterprise applications, network management, service provisioning, and billing mediation. The company serves equipment manufacturers, network management and protocols device manufacturers, and multimedia codecs service providers. Aricent Technologies (Holdings) Limited was formerly known as Kappa Investments Limited. The company was incorporated in 2006 and is based in Guru gram, India. Aricent Technologies (Holdings) Limited operates as a subsidiary of Aricent Inc.

Project 2.

Tata Motors Finance Limited, a non-banking financial company, engages in financing passenger cars and commercial vehicles manufactured by Tata Motors Limited in India. The company was founded in 1957 and is headquartered in Mumbai, India. Tata Motors Finance Limited is a subsidiary of Tata Motors Limited.

Tata Hitachi Construction Machinery Company private Limited, the Leader in Construction Equipment in India, enhances the operational performance of its customers, leading to improving their profitability and competitiveness by offering constructive solutions.

Tata Hitachi is subsidiary company of Hitachi Construction Machinery Co. Ltd., which holds 60% share, and Tata Motors Ltd holding the balance 40%.

Project 3.

Tata Motors is one of the largest Auto mobile companies in India. It is spread across the world. I am working in TML project from Jan’11 to Dec’14. I have worked in Tata motors warranty project from Apr’11 to Apr’12, during this project I had supported the Tata motors domestic & export system, also supported the Tata motors IB Accrual system & Tata motors Thailand System. I was in in Tata motors Application management (AM) team from Apr’11 to Apr’12 during this period, supported the end user & resolved their issue. After that I was in Tata motors Application Development (AD) team from May’12 to Dec’14. I have delivered all their requirement, implement the system for Tata Nano car of sanand plant & Implement the TML DL ISR project.

Project 4.

Tata Steel is one of the largest steel manufacturing company in India. This is the base company of Tata Group. It has so many branches across the world. Everyone knows about this company & strength of this company.

Responsibilities:

The activities that I have performed are as follows:

Project 1

●In this project I have migrated the SAP BW on HANA system to SAP BW /4 HANA system in HANA Data Base.

●I have used scope transfer process to convert the BW 7.3 & BW on HANA object into BW /4 HANA.

●Fetch the data from Non-SAP Data Source into BW /4 HANA System.

●Solved the NCHAR error for Non-SAP Data Source when fetched the data from SQL Data Base to HANA Data Base.

●Converted the APD process to BW /4 HANA using Scope Transfer Tool.

●I have done some pre-check activity into SAP BW on Hana System.

Project 2

●In this project I have migrated the SAP BW system in Oracle Data Base to SAP BW system in HANA Data Base.

●I have created some Open ODS View, Composite provider & Transient provider

●Designed the Open ODS views with characteristic Key field & Representative Key Fields.

●Created Open ODS views based on Master data, text & facts & used these Open ODS views for reporting purpose.

●Worked extensively on standard Logistics system Such as SD, MM, PP extractors. Installed relevant SAP business content.

●I have extracted the data from logistic systems such as SD, MM, PP system to SAP BW/ 4 Hana System.

●I have capture the Sale data from SD & production data from PP to calculate the warranty period of particular vehicle

●I have extracted the data from legacy system to BW HANA system.

●I have also generated BW HANA inventory Reports base on MM data.

●Retrieved the Production Data from SAP PP & Inventory data to develop the report

●Also capture the MM Data from SAP MM system to SAP BI System

●Captured the Warranty data based on sale date, production date & complaint reported date from logistic system SD & PP

●Capture the production data of Tata Hitachi heavy vehicle from SAP PP to BW system

●Using the MM data to analyse the daily stock of Material of Tata Hitachi Ltd

●I have develop the daily stock report for top management of Tata Hitachi using the MM data

●I have generated the CO-PA Data Source for Tata motors finance

●I have capture the FI data for Tata motors finance

●Used Navigational Attribute in Virtual Provider & open ODS view, publish report on top of Open ODS view& Virtual Provider

●Created Attribute view & developed some HANA Query on top of this Attribute View as per business requirements

●Imported the data from flat file into Hana data base table & partitioned those table (Hash, Range & Round Robin) to balance the load

●Created variables & used those variables in HANA Query and BEx query for Reporting.

●I have used Aggregation function in HANA Query as per business requirements

●Used Authorization variable, replacement path variable in HANA query

●Leveraged condition, selection & set offset for variable in HANA Query

●Created Transient Provider to capture HANA model in SAP BW underline HANA Data Base

●Compressed the data with Marker for non-cumulative cube in ADSO

●I have used some open ODS view association of fields of some other Open ODS views

●Used Table compression to capture the Delta records using BODS into HANA Data base Table.

●Populate some extra fields as per business requirement when I fetch data from oracle data base to HANA Data Base using BODS

●Used SLT to capture the real time data into HANA Data Base. Replicate the Meta Data table DD02T,DD02L& DD08L

●Convert Normal Cube to HANA optimise CUBE Using ABAP Program “RSDRI_CONVERT_CUBE_TO_INMEMORY” or using T’Code RSMIGRHANADB.

●Convert normal DSO to HANA optimise DSO Using ABAP program “RSDRI_RECONVERT_DATASTOREOBJECT".

●During this project I have used BODS & SLT to retrieve the data from Oracle Data Base to Hana Data Base.

●Extract the data from SAP BW Oracle data Base to HANA Data Base using open hub Destination & BODS.

●Convert the Multi provider to Composite provider and use the SAP BW query (based on oracle Data Base Multi provider) into SAP BW HANA System.

●Convert Multiprovider into SAP HANA Composite Provider Using ABAP Program “RSO_CONVERT_IPRO_TO_HCPR”.

●Create composite provider with UNION & Join

●Also created some Calculation View & Analytical View used these for Composite provider

●Create some HANA query base on composite provider.

●In Tata Hitachi system, I have developed Some Advanced DSO based On DSO & Info cube

●Create some query on top of Advanced DSO.

●I have used transformation to create the open ODS view

●Used LSA++ Architecture,Used ADSO in Data Acquisition layer to load the data from source system, In Propagation layer I have used ADSO (Corporate memory) load data from ADSO (Data Acquisition layer), create the composite provider in Data virtualization layer, delivered the report to business on top of Composite provider

●Create ADSO (Data Warehouse Layer - delta calculation) to capture the delta records, ADSO (Corporate Memory) with reporting capabilities by Using this ADSO I have published the report with hot & warm Data

●ADSO with Planning on cube-like & Planning on Direct Update

●Used ADSO with compression capabilities to store the COLD data

●Used ADSO as cube generate the HANA query on top of ADSO

●Leveraged the Corporate memory ADSO for data recovery purpose

●Generate report on top of ADSO corporate memory with reporting option

●Deleted the Change Log of Advanced DSO using “RSDSO_REMOVE_REQS_PC” & call the function module & used program “RSDSO_REMOVE_REQUEST_API”.

●Create the Advanced DSO based on Standard DSO & based on Write Optimise DSO

●In this system I have used ODP methodology to retrieve the data from Source system.

●Create process chain & data flow to load the data into Advanced DSO.

●Used Streaming process chain to capture the real time data (RDA) into ADSO (Corporate Memory) using ODP-SAPI & ODP-SLT connection.

●I have used PULL based & PUSH based option to triggering the streaming process chain

●Enabled ‘Z’ Data Source as ODP enable by using ABAP Program “RODPS_OS_EXPOSE” in SE38 & Checked it in ROOSATTR.

●I have developed some Corporate Memory (Advanced DSO) to Store the cold & Warm Data.

●Using SQL statement “SAPMIW”. “/BIC/AFIXX” in DBACOCKPIT offload the whole data of main memory of Corporate ADSO & also check the size of Main Memory.

●Generate the BEx report on top of Composite Provider for hot data.

●I have used the Corporate Memory DSO as a source of these composite Provider and generate the BEx Query & HANA Query to display the historical data & Real time data.

●Create Some Open ODS views, Transient provider, Calculation Views, Analytical Views and used to generate the Report.

●Create the Open ODS View Based On BW Data Source Direct Access, Data Base Table, Views, Virtual Table Using SAP HANA Smart Data Access.

●Leveraged Open ODS View with Info Object Assignment.

●I have also used the ODP enabled data source to capture the SD & Warranty Data into SAP BW Hana System.

●Checked the data retention using ODQMON t’code.

●Scheduled the job to delete the request in ODQMON under UNIT tab which is older than 31 days for memory utilization

●Scheduled the failed request in ODQMON using Read Extraction Request

●Leveraged MAP-CDC- operation or Map Operation to capture the change records into HANA System.

●Leveraged Open ODS view based on Transformation & Advanced DSO

●Transport Transient provider using RSLTIP,RSLTIPBASE,RSLTIPLOC,RSLTIPT and RSLTIPXREF

●I have used ABAP Data Flow to capture &handle high volume of data from R/3 Table to SAP HANA System using BODS

●Extract data from SAP BW system (Oracle DB) to SAP BW (HANA DB) using Open Hub destination in BODS

●Extract data from legacy system to HANA data Base Table using BODS

●Created Data Flow in Eclipse based modelling to load the data in ADSO.

●Leveraged the Data Flow I have loaded data from ECC to ADSO

●I have also design the system in SAP BW/4 HANA

●After completion of this project I have supported the HITACHI (BW HANA) System

●During this period I have faced some Data inconsistence ERROR for master Data.

●Handled the message no 327 for data type not supported in HANA System

●Used the Calculation Views to create the Composite Provider

●I have create some table and load the data into this table

●Leveraged HASH, RANGE & ROUND ROBIN partition

●When I extract the data from R/3 System to Sap HANA system faced some error to load the text data into HANA system

●Error occurred for the field name,sortail,stras of KNA1 table to overcome this error increased the field length

●Some time I faced the data type error

●Get some Junk Character errors when load data from ECC to SAP BW

Project 3

●I have connected the non-sap system with BW system to capture the Tata Motors credit Note data.

●Worked extensively on standard Logistics system Such as SD, MM, PP extractors.

Installed relevant SAP business content.

●Retrieved the Production Data from SAP PP & Inventory data for developing the report

●Also capture the MM Data from SAP MM system to SAP BI System

●Captured the Warranty data based on sale date, production date & complaint reported date from logistic system SD & PP

●Capture the production data of Tata Motors CAR, CVBU & MUV from SAP PP to BW system

●Using the MM data to analyse the daily stock of Material of Tata Motors Ltd

●I have develop the daily stock report for top management of Tata Motors using the MM data

●I have used this data to calculate the IPTV & EPV for particular Model of Vehicle

●I have extracted data from legacy system & IS-AUTO system using DB connect.

●I have generated the CO-PA data source for developing the cost centre related reports

●Developed ‘ALL’ plant option for Nano model

●Restricted the data in report as per plant location for different Plant Head

●Developed report for Quality user to analysis the data for various model using single report

●Connected IS-Auto System to capture the Small Car (NANO Model) warranty related Credit Note data in BW system.

●Linked the VCM (Non SAP) system & SAP BW system to capture the Warranty, Complain code change & Dealer Debit data for CVBU Domestic & Export.

●Automated the CAR & MUV system to store the Warranty related credit note data, complain code change data & Dealer rejection data from IS-Auto to BW system.

●Create some work book to analysis the complaint data for various model through using single Work Book (BW Report)

●Enhanced the data process logic for more than one plant (All Plant Option) for same model complaint analysis

●7x Graphs were not appearing with respect to 3.5 graph

●problem in Migration of Web templates due to Java script used for header in the template

●Key fig not appearing in Web template but appearing in the query

●Data not appearing in BI 7 but appearing in BW 3.x query

●Legend and data table are appearing together in BW 3x

●Exception becomes blank in BI 7x query although exception is shown in query designer

●Key figures appearing blank in 7x queries, containing CONDITIONs

●Exception in key fig. is not working. Result blank in 7x query

●In RSBBS no link present in RRI in3.x, but while in runtime, it shows RRI link to new template( ZMMW_C06_OZ_DNSTM)

●Key figure properties hidden in 3x is not shown in 7x

●Key fig values not visible in collapsed form in 7x query on web.

●Radio button/ dropdown in web templates

●Sometimes RRIs not working

●Report Title

●In 3x with exception if column value is blank it shows with color

●Exception in key fig. is not working. Result blank in 7x query

●Table structure present in 3.x queries

Project 4

●No output, having problem while selection of variable for range

●Exception and condition not appearing in BI 7 after migration

●Language problem- Dutch / English (queries not showing description)

●7x Graphs were not appearing with respect to 3.5 graph

●problem in Migration of Web templates due to Java script used for header in the template

●Key fig not appearing in Web template but appearing in the query

●Data not appearing in BI 7 but apearing in BW 3.x query

●Legend and data table are appearing together in BW 3x

●Exception becomes blank in BI 7x query although exception is shown in query designer

●Key figures appearing blank in 7x queries, containing CONDITIONs

●Exception in key fig. is not working. Result blank in 7x query

●In RSBBS no link present in RRI in3.x, but while in runtime, it shows RRI link to new template( ZMMW_C06_OZ_DNSTM)

●Key figure properties hidden in 3x is not shown in 7x

●Key fig values not visible in collapsed form in 7x query on web.

●Radio button/ dropdown in web templates

●Sometimes RRIs not working

●Report Title

●In 3x with exception if column value is blank it shows with color

●Exception in key fig. is not working. Result blank in 7x query

●Table structure present in 3.x queries

Expertise in software technologies:

ERP : SAP R/3. ECC 6.0

Data warehouse tools : SAP BW 3.5, SAP BW7.3, 7.4 and SAP BI 7.5, SAP BW

on HANA, SAP BW/4 HANA

Reporting Tools : SAP BEx, SAP Lumira & Tableau

Databases : Oracle 9i. HANA

Languages : SQL.

Passport Details:

Passport Number : K7628816

Place of Issue : Ranchi

Issued date : 7’th Nov 2012

Valid Date : 6’th Nov 2022

SAP BI and BW Expertise:

Involved in one complete life cycle implementation projects that include data modeling, data extraction, reporting, batch scheduling.

Extensively Worked on Creation of Data Transfer Process (D.T.P) & transformations in BI 7.3

●Involved in Creation of Data sources in E.C.C 6.0.And Extracted Data into SAP BI Environment.

●Extensively involved in Design and creating Processes Chains to automate the process of loading data into data targets.

●Worked in data modeling and BIW extended star schema models as per the business requirement.

●Extensively worked on administrative workbench for defining Info Objects, Info Cubes, Multi Cubes, ODS and Info Sets.

●Extracted SD, MM & production data (PP) to BW System.

●Expertise in scheduling and monitoring of data flow to info Cubes, ODS objects through process chains.

●Worked with extractors: Business content, LO Cockpit (SD, MM & PP) and COPA. Also customization of the extractors. Data extraction from Flat-Files, Activating Data Sources and Setting of V3 update, Deleting Set up Tables, Filling of Cluster Tables and Data Loading.

●Worked with Legacy System like VCM, oracle, UNIX system.

●Create the data source & DB connection on this system & fetch data on weekly basis.

●Worked extensively with BEx Analyzer, and Query Designer. Reports using calculated key figures, restricted key figures, Exception Aggregation, free characteristics, filters, structures, Conditions, Exceptions, Variables, Offset and Report to Report Interface.

Contact this candidate