SAP Certified BW/BI/HANA consultant

A N I NDYA BOSE

SAP Certified HANA/BW

Consultant

an *****.******@*****.***

267-***-****, Phi l adelphi a, PA

S UM MARY

SAP BW/BI/HANA Consultant with a combination of experience in SAP BW, SAP HANA, SAP ABAP

(BW related), SAP BASIS, and excellent communication skill. Experience includes 7.3 years in

B I/BW, 3 years in SAP BW-ABAP, 2 migrations from SAP BW to SAP BW on HANA, 3 full life-cycle

BW Implementations, 1 Upgrade from 3.x to 7.x, and 1.5 years in modelling of information views in

SAP HANA.

SAP SKI L LS SET

BW Data A BAP

Warehouse BI D evelopmen

D esign R eporting t

Start, End

Requirement BEx Query and Field

• s Workshops • Designer • Routine

• Data • BEX • DataSource

Modelling in A nalyzer E nhancement

P artners & Affiliates:

1880 JFK Blvd. 15th F loor, Philadelphia, PA 19103 Web: http://www.datacoresystems.com F ax: 215-***-****

Obj100

BW 7.x

Performance BO Web Expert

• Optimization • I ntelligence • Routine

Migration to Query

BW on Performance FM Based

• H ANA • T uning • E xtractor

Implementat

ion of SAP View Based

• BW • E xtractor

B I Development SAP Modules SAP HANA

Custom Att ribute

• Cube/DSO • SD • V iews

Transformat Analytic

• ions/DTPs • FI • V iews

Start/End/Ex

pert Calculation

• Routines • FI/CO • V iew

Aggregate SQL

• creation • HR • scripting

Report to SLT

Report T ransformat

• I nterface • Vistex • ion

Process SLT Data

• Chains • Inventory • F iltering

CERT I F ICAT IO N

•

• SAP Certified Application Associate (Edition 2013) - SAP HANA

Certificate ID: 001*******

T RA I N I NG ATTE N DE D

SAP Academy T raining

• HA300 and HA100

Page 2 of 7

• SAP BI ( TBW10,TBW20,TBW42_1, TBW42_2)

• SAP BW Administration ( BW 360)

Other T rainings

• Email, Conference and Meeting Skill

• Communicating Effectively in Global Environment

E DUCAT ION

• Master of Technology – I ndian I nstitute of Technology, K ha ragpu r (2005-2007)

• Bachelor of Engineering – B engal Engineering and Science University, H ow rah (2001-

2005)

PROFESSIONAL EXPER I E NCE

Lexmark I n te rnational, Lexington, KY

F eb. 2013 – P resent

Architecture and Strategy Professional (Lexmark I nternat iona l I nd i a)

Description: SAP ECC system is implemented in the areas of Finance and Controlling, Financial

supply chain management, Sales and distribution, Material management, Production planning, APO

and SRM. SAP BI system aspires to consolidate and integrate data posted in the t ransactional SAP ECC

system, MDM, CRM, and SCM to provide insightful reports which will support decision making and

d rive efficacy in business operations at Lexmark.

Responsibilities:

Migration of SAP BW system to SAP BW on HANA DB

Redesign of current Layered Scalable Architecture (LSA) for BW on HANA

Reviewing changes done by vendors

Integration of new modules ( VISTEX, Deals Management) with SAP BW

Page 3 of 7

Creation of BI 4.0 Web Intelligence Report

Developing SAP HANA Information View (Calculation View, Analytic view)

Real –time Data replication via SLT

Transforming and filtering data via SLT (IUUC_REPL_CONTENT)

SQL scripting

Creation of Calculation views, Att ribute views and Analytic Views

Medtronic, M inneapolis, M N A ug.

2012 – Feb. 2013

Package Solution Consultant SAP BW ( IBM I nd i a Pvt. Ltd)

Description: Medtronic (NYSE: MDT) is the global leader in medical technology - alleviating pain,

restoring health and extending life for millions of people around the world. Medtronic has chosen SAP

BW as their analytical tool.

R esponsibilities:

Developing and t ransporting BW specific Objects for HANA

Loading and testing of BW on HANA

Creation and Migration of HANA Optimized InfoCubes, DSOs

C areStream Health, Rochester, NY M ay

2012 – Aug. 2012

SAP BW P roject Lead (W IPRO Technologies)

Description: CSH, formerly Eastman Kodak Company's Health Group, is an independent subsidiary of

Onex Corporation, Toronto, Canada. CareStream Health has embarked on a major upgrade for their

E nterprise IT landscape on the following towers as part of the overall SAP Transformation program.

W ipro helped CareStream team to ensure a smooth upgrade/Transition.

_ SAP BW 3.1 to SAP BI 7.0 Upgrade and Merger

_ SAP R/3 4.7 to SAP ECC 6.0 Technical Upgrade

_ Data stage ETL to BODS Migration

Responsibilities:

Leading SAP BW team

Creation of BW 7.x Process Chain from InfoPackage Group

Managing conversion of BW 3.1 queries and workbook to BI 7.0

Creation of new queries as per customer requirement

Tuning performance of queries after upgrade

Resolution of missing Mappings for Jump Queries ( RRI)

Page 4 of 7

Adjusting Data Model for better loading and reporting performance ( dimension redesign)

L exmark I n te rnational, Lexington, KY, A ug.

2010 – May 2012

SAP BW Tech Lead (W IPRO Technologies)

Responsibilities:

Worked as technical lead of both Implementation and support team (AMS) team

Implementation of new f lows in SAP BW

Working on defects and post-Go-Live issues.

Help solving regular critical tickets as well as issues related to new developments

Providing recommendations for system performance tuning

Interaction with Key business users and managers

Monthly reconciliation of CO-PA, FI, SD, MM data

I mplementation of BWA NetWeaver Accelerator 7.20

Upgrade of BW 7.01 to BW 7.3 and testing

Grooming/Training new team members

Writing technical specification document

Played role of onsite coordinator

British Pet roleum North Sea, UK M a rch

2010 – July 2010

SAP BW Developer ( IBM I ndi a Pvt. Ltd)

Description: T his was an End to End implementation project for FI and Sales & Tariffs reporting. Key

objective was development of BW data model to support reporting requirement of BP’s Exploration and

P roduction unit in North Sea.

R esponsibilities:

Requirement gathering from business group

Propose and recommend roadmap for implementation of the SAP BW solution with demo

and examples

Gap analysis of the requirements

Creation of BW data model from custom ABAP report

Designing query for AP/AR bucket scenario

Page 5 of 7

Enhancement of standard DataSource

Designing Function Module Based Extractors

Dimension Designing of InfoCubes

Coding for complex calculation via Start, End and Field Routines in t ransformation

Customer Exit for variables

Creation of BW hierarchy flat file from customer provided hierarchy data

Design for queries and Data Model needed to cater the high priority requirements

Creation of Process Chains for automation of Data Load

Envi ronment: SAP BI 7.0, SAP ECC 6.0, Oracle 10g, and Solaris.

British Pet roleum Group BW, U K Sept.

2007 – Aug. 2009

SAP BW Administrator ( IBM I ndi a Pvt. Ltd)

•

• Description: BP Group BW initiative covers the support, enhancements, and upgrade services of

d ifferent Business Intelligence applications across the different phases of oil exploration, refining,

marketing and retail operations. We were responsible to manage seven BW systems.

•

Responsibilities:

P rocess chain monitoring and tuning the data load performance

Daily System monitoring and daily issue solving

New System building and System refresh (homogeneous database copy)

Maintaining connection with Informatica power centre

Database Administration and performance tuning

Kernel and Support Pack Upgrade in different BW Versions.

I mplementing and enhancement of SOX/SOD (Sarbanes-Oxley Act) evidences and

p roviding SOX t raining to other team members

Managing daily t ransport and monthly release

Implementation of SAP Notes correction

BWA ( Business Warehouse Accelerator) blade server monitoring

Page 6 of 7

Maintaining and restoring source system connection with other systems

Database Reorganization ( Oracle)

Writing A BAP codes to automate error correction in process chain

Creation of aggregates to enhance query performance

Database Migration ( Oracle 9i to Oracle 10g)

• Envi ronment : SAB BW 3.5, SAP B I 7.0, SAP B IA 7.0, O racle 9i, Oracle 10g, Window Sever

2003, Solaris, Informatica, SAP ECC 6.0

•

L inkedIn Profile: h ttp://goo.gl/Fjzqfz

SCN Profile: h ttp://goo.gl/JThOA2

Page 7 of 7

Contact this candidate