Resume

Sign in

Data Project

Location:
Hyderabad, Telangana, India
Posted:
May 25, 2018

Contact this candidate

Resume:

SAP Functional consultant. Anirban Dandapat

BW (*.5) & BI (7.3), SAP Lumira Consultant Kolkata -India

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

Email Id:

ac5ma1@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 10 years of experience in SAP in which 3 years of experience in SAP Business information warehouse & 7 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 am working as a SAP BI Consultant in Tata technologies Ltd, Jamshedpur from April 2010

Worked as a SAP BI Consultant in ConAgra Food, Pune for one & half year through my company Axiom Tech solutions.

I was in Axiom Tech solutions from May 2006 to March 2010.

Project Profile:

1. Client: Tata Motors & Tata Motors Drive line Ltd & Tata Hitachi.

Duration : July 2010 to Till Date

Role : SAP BW/BI Team Lead

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

2. Client : Tata Steel Corus Migration Project

Duration : April 2010 to June 2010

Role : SAP BW/BI consultant

I migrate Query, Web Templates, Report to Report Intrface (RRI) in this Migration project

3. Client : ConAgra Foods (Implementation & support project).

Duration : Sep 2008 to Mar 2010.

Role : SAP-BW Consultant.

Description:

Project 1. 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 Jul’10 to till date & implement the TML DL ISR project from Dec’16 to Apr’17. I have worked in Tata motors warranty project from Jul’10 to Apr’12, during this project I had supported the Tata motors domestic & export system, implement the system for Tata nano car of sanand plant also supported the Tata motors IB Accrual system & Tata motors Thailand. I was in in Tata motors Application management (AM) team from Apr’12 to Jun’14 during this period, supported the end user & resolved their issue. After that I was in Tata motors Application Development (AD) team from Jul’14 to Nov’16. I have delivered all their requirement. Implement the TML DL ISR project from Dec’16 to Apr’17 & support up to Aug17.

Also support the Tata Hitachi system from Sep’17 to till date.

Project 2. 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. Every one knows about this company & strength of this company.

Project 3. ConAgra Foods is one of the largest packaged foods company in North America with major presence in retail outlets, foodservice and restaurants, and in ingredients. ConAgra Foods has Consumer Foods, Commercial Products, and International markets more than 40 brands in retail channels outside the United States. ConAgra foods products are found in more than 100 countries.

Responsibilities:

The activities that need to be performed are as follows:

Project 1

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

Captured the Warranty data based on sale date & complaint reported date

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 2

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

Project 3

Involved in developing the Functional reporting requirements of reports and also converting the Functional spaces into Technical Spaces.

Worked extensively on standard SD extractors. Installed relevant SAP business content.

As part of Information Consumer Layer designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path in BW 3.5

Involved in the Performance Tuning of Info Cubes and Query reporting

Designed, developed and modified Info objects, ODS objects and Info-Cubes.

Involved in improving the process by taking initiatives to improve the System performance, which involves Maintaining DB Statistics, Analyzing the Utilization OLAP Statistics and taking the effective decisions to improve the query.

Extensively worked on Web Reporting involving converting Workbooks into web Template and publishing the web reports as Views.

Extraction of Data on Daily/weekly/Monthly basis from various R/3 and Non R/3 system to BW system.

Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50

Monitoring of data loading through process chains and Infopackage groups

Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.

Monitoring of Infopackages and analyzing the reasons for frequent failures of Infopackages

Resolved Customer reported tickets through email and phone.

Expertise in software technologies:

ERP : SAP R/3.

Data warehouse tools : SAP BW 3.5 and SAP BI 7.3, SAP Lumira

&Tableau

Databases : Oracle 9i.

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 & production data 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 and COPA. Also customization of the extractors. Data extraction from Flat-Files, Activating DataSources and Setting of V3 update, Deleting SetUp Tables, Filling of Cluster Tables and Data Loading.

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