Sanjeev Kumar

Mobile: +91-858*******

E-Mail: adn0j8@r.postjobfree.com

SAP HANA Certified / BW7.4 Certified/BPC /ABAP Consultant– 16 year Experience

CAREER OBJECTIVE

SAP/ implementation/Development Consultant.

EDUCATIONAL QUALIFICATIONS

B.E in Computer Science from Bhagwan Mahavir Institute of Technology under M.D.University with 68.6%.

SAP Certified Application Associate - SAP HANA (Edition 2015)

SAP Certified - Modeling and Data Management with SAP BW 7.4

BPC, Integrated Planning, ABAP

Best Performance Award from Wipro.

Best Performance Award from Saudi Aramco.

Project Implementation - 10 Major Implementation EOE, 1 Support.

WGL BW 7.4 / HANA Modelling Architect -Implementation

DPSG /Miller Coors Implementation/Support

AXA Group Switzerland BI Architect

Saudi Aramco Saudi Arabia BI Architect

HMEL Implementation

Crairn Energy India Ltd

Goodyear Australia /India

Jindal Stainless Steel Hisar

JOB EXPERIENCE– 16 yr ExpHANA with BW/HANA& ABAP Consultant.

WGL 5 yr presently working as a Sr. HANA / BW Architect in WGL .

AXA Sr . Lead Architect / Consultant (BW).

Saudi Armco BWSolution Architect.

Wipro BW and ABAP Technical Consultant.

Accenture ABAP Consultant on Jindal Stainless Steel Project.

NICSI DBA in Oracle / Unix Databases .

Modules – ISH: Healthcare, IS-Utilities, HR -modules, MM, FI,CO,Treasury Module,PP,SD.

Implementation – 10EOE, 1 Support .

BW-HANAExpertise:

BW Data Extraction, BW Business Content, BW Performance Tuning, BW Data Upload and Monitor, BW Authorisation, BW Data Upload and Monitor, Info Objects,, Info Cubes, ODS, Multiproviders, Info sets, Info Sources, Hierarchies, Transformations, Transfer &Update Rules, Info Packages, Data Transfer Process(DTP), HANA Modeling, Attribute,Analytical, Calculation View,Authorization,HANA Live

Webi, Crystal Reports, Dashboard with Xcelsius.

Specialize on Integrated Planning & Business Planning &Consolidation

BW-IP and PAK, Planning structures, ABAP Planning Modeler, Modelling, setting up and Testing planning functions, planning queries, Design Studio Web Application,

Modeling for Consolidation, Consolidation Logic, EPM add-in, IFRS Starter Kit, using Ownership Manager, Controls Monitor and Validating Data, Consolidation Business Process Flows, Using Consolidation Central, Reclassifying Data

ABAP/4 Proficiency -

Sap Notes Implementation, Reports, Sap scripts, Smartforms, Module Pool Programming, LSMW, BDC, User Exits, BADI, BAPI, and Workflow.

PROJECT – I

Project Name:

SAP BW/HANA/BPC Implementation

Client

Washington Gas

Role

Sr. Consultant BI-HANA

Duration

Jan-16 to Till Now

Contribution

SAP BW /HANA Architect - IS-U Utility

Version

BW 7.4

WGL is a diversified energy business that provides natural gas, electricity, green power, carbon reduction and energy services and natural gas exploration, production, and storage though its subsidiaries, including Washington Gas, Washington Energy Services, WGL Midstream, and Hampshire Gas..

Responsibilities:

Data Modelling and Designing the around 100 reports in BW 7.4 using Composite Provider.

Understanding the Functional Requirement Specification given by user and developing & designing Modelling related to the respective area

Installation of Business Content

Handling the Team and guiding them for using right SAP recommend modelling procedure,

BW objects Naming Conventions, Technical Specification, Unit Testing documents

Modelling on Planning Application - Integrated planning / BPC

Planning Applications

Worked on BW-IP and PAK,Setting up planning structures with the ABAP Planning Modeler

Modelling, setting up and Testing planning functions via Planning Sequences,Configuring input ready queries with the BEx Query Designer

Worked on planning queries, Locking of Transaction Data

Creating an Analysis Office Workbook for Planning

Creating Design Studio Web Application for Planning

Working with Characteristic Relationship concepts

Using Aggregation and Disaggregation in Planning Scenarios

Setting up Advanced Planning Functions like FOX, ABAP and SQL- Script

Introducing Inverse Formulas

Business Planning & Consolidation

Excel Interface of the EPM add-in,Implementing Consolidation Projects,Using the IFRS Starter Kit,Setting up the Environment and Master Data,Creating Models for Consolidation,

Creating Consolidation Logic

Importing Flat File and InfoCube Data,Configuring Balance Carry forward,Reclassifying Data

Using Consolidation Central,Setting up Journals,Translating Local Currency,

Reviewing Ownership Terms and Concepts,Using the Ownership Manager,Eliminating Ownership - Purchase Method

Equity and Proportional Methods,Matching Intercompany,Eliminating Intercompany AP AR,Setting up Intercompany (US) Elimination,Using the Controls Monitor and Validating Data

Creating Consolidation Business Process Flows

PROJECT – II

Project Name:

SAP BI/HANA Implementation

Client

Dr Pepper Snapple Group Inc ( HCL )

Role

Sr Consultant BI-HANA

Duration

Jun-13 to Dec-2015

Contribution

SAP BW /HANA Consultant

Version

BI 7.4

Dr Pepper Snapple Group Inc. (formerly Cadbury Schweppes Americas Beverages) is an American soft drink company, based in Plano, Texas.

Responsibilities:

Process Chains, Dataload Monitoring and Issue resolutions.

Working on Tickets and Work orders, New Enhancement on existing reports .

Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / BRD documents and working closely with Onsite team members for future developments in SAP BW/BI.

Writing ABAP routines like Lookup,start routines,End routine,Expert Routine, Transformation infoobject level routine, DTP Filter routines, Customer Exit Variable coding, and customizing data sources etc in the BI system

Performance Tuning

Responsible for performance and Tuning – Dataload performance and Report running performance

Remodelling the design for improvement of dataload and report performance

Managing the performance (related activities like aggregation, compression, indexing-BI accelerator,) and data load monitoring activities

Resolved highly critical and sensitive bugs ( Work orders ) in application raised by users in production environment .Tested it on QA system and delivered in production system on time

Delivered enhancements, tickets as per the customer requirements and completed the development within defined time frame with high quality deliverable and running performance. To ensure the deliverables those are assigned to me are within the scope and deployed defect free and also ensure zero customer complaints.

HANA Implementation

Interacted with Senior executive of client companies to define functional & technical specifications

Worked on Migration of SAP BW and/or SAP Business Suite Component on HANA

Developed Attribute View, Analytic View, and Calculation View as per the requirement of Reports. SAP HANA programming including SQL, SQL Script, Procedures and CE Script.

SAP HANA Security including User Management, Roles, and Privileges

Worked on join of the tables and have extensive understanding of differences between Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Text Join and referential Join when connecting tables

Created Variables and applied them as filters and also worked on various input parameters

Ability to work on currency conversion in analytical views.

Worked on SAP HANA Modelling, managing schemas, data model objects, import/export content and Data provisioning using SLT Replication server.

PROJECT - II

Project Name:

SAP BI Implementation plus Up gradation Project BI7 – BI7.3

Client

AXA Group Solution

Role

Sr Lead BI Technical Consultant

Duration

Apr-12 to June-13

Contribution

SAP BI BO Consultant with ABAP Lead

Version

BI 7.3 BO 4.O

AXA . is a French global insurance group headquartered in the 8th arrondissement of Paris. The AXA group of companies engage in life, health and other forms of insurance, as well as investment management. The group operates primarily in Western Europe, North America, the Asia Pacific region, and the Middle East.The AXA Group encompasses five operating business segments: Life & Savings, Property & Casualty, International Insurance (including reinsurance), Asset Management and Other Financial Services

Responsibilities:

Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / High Level design documents and working closely with Onsite team members for future developments in SAP BW/BI.

Responsible for new developments like creating / modifying BW 7.0/ BI 7.3 objects like InfoCubes / ODS / InfoSource / Info Objects / Data Sources / InfoSets / Queries / Bex Reports / Web Templates / Process chains etc.

Designing and Migration of Dataflow from BI 7.0 to BI 7.3 .

Writing ABAP routines like Lookup,start routines,End routine,Expert Routine, Transformation infoobject level routine, DTP Filter routines, Customer Exit Variable coding, and customizing data sources etc in the BI system

Performance Tuning

Responsible for performance and Tuning – Dataload performance and Report running performance

Remodelling the design for improvement of dataload and report performance

Managing the performance (related activities like aggregation, compression, indexing-BI accelerator,) and data load monitoring activities

Design & Datamodelling -

Extensive worked on developing the design of bi data modelling as per the requirement of reports .

Customer exit modularization – Analysis the system risk management and maintaining the proper transport reliability, worked on splitting the customer exit variable Z* to separate Classes and Function Modules, this activity make the system risk free .

KPI Report - Involve in development, design and delivery of KPI Report, Individual Employee Performance, monthly Issue receive and Issue resolved the report is used for AXA Management to check the individual contribution to project through various team .

Business Object -

Extensive work on designing the schema as the requirement, Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops,fan traps, chasm traps in Universes using Table aliases and contexts with OLAP and OLTP connection.

Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.

Performed unit testing, system integration testing, and user acceptance testing of Web Intelligence/Desktop Intelligence Reports at various levels.

Extensive experience in creating reports with Charts (bar chart, Pie chart…etc),Slice and Dice, drill down, drill by, drill through, cross tab and Master-Detail and Sub reports

PROJECT - III

Project Name:

SAP BI Healthcare Implementation ( BI 7.0 )

Client

Saudi Aramco

Role

Sr BI BO ABAP Techincal Consultant

Duration

Jan 10 to Feb-12

Contribution

SAP BI BO Consultant with ABAP ( Architect & Data Modeling )

Reporting, Activating Standard Report, Developing New Report as per user requirement .

Reports : ISH- Health Care

Developed Generic Delta extractor more than 130 .

Data Modeling and Architecture design of Healthcare project

Dev of BI reporting in Patient management,Clinical Services area Registration and Admission, Finance, Nursing, Emergency Medical Services, Scheduling.

Process Chain and Daily Dataload check in support.

Leading the development, configuration and support of reporting solutions, primarily using the SAP Business Information Warehouse (BI/BW) Application.

Working from functional/business requirements to design and develop data sources (installing standard data sources to enhance existing data sources and create custom data sources).

Development of Generic delta extractors

Working from functional/business requirements to design and develop BW objects (installation of standard objects, enhance existing objects and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, etc.

Documenting testing plans and complete Unit Testing of developed objects and reports.

Working with Quality Assurance business resources to complete System and Integration Testing.

Analyzing and communicate report development issues, including problems with data integrity, data design, and functional and technical software issues.

Delivering work within tight deadlines and consulting on business issues to offer lasting value to clients as part of ongoing engagements.

Bussiness Object

Worked extensively in leading, developing and implementing report solutions on Business Objects XI Release II, Crystal Reports Server XI, Crystal Enterprise 10/9/8.5, Web Intelligence XI, Desktop Intelligence, Business Objects Universe Designer, Crystal Reports Explorer.

Worked on designing dashboards against different data sources using XCelsius 2008

Integrated XCelsius into Crystal reports 2008 using XML, Excel and flash variables.

Expertise in designing Universe from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R2 SP3.

Installed and configured Business Objects XI Rel II on Win 2003 Server, Red Hat Linux.

Evaluated usage of Crystal XCelcius, Live Office for adhoc reporting.

Designed multi server architecture for Business Objects XI R2 Enterprise for more than 10000 concurrent users.

Involved in all phases of migration from Crystal Enterprise 10 to XI R2.

Involved in designing Universe and migrating existing adhoc ‘Crystal Reports Explorer 11’ to WebI

Involved in creating the SRS/BRS for ‘Master Reports Suite’ which included enhancements to existing adhoc product.

Currently leading team on multiple projects like Migration of Crystal 10 to Business Objects XI Release 2, Million Dollar Tracking System, Performance Shares ( Equity related project ).

Headed the team of Crystal Reports Developers, developed the reports as well as got them done by team on time for the releases.

Designed and documented the multi server architecture of Crystal Enterprise 9/10.

Configured and Standardized the APS Cluster environment in Crystal Enterprise.

PROJECT - IV

Project Name:

: SAP R/3 Implementation ECC 5

Client

HMEL ( A group of HP Company )

Role

Sr Technical Consultant ( BI/ABAP)

Duration

Jan 2009 – Sep-2009

Transferring the layer migrated data from sap R/3 using LO Cockpit, generic extractor, & Database tables.

Installing the relevant Business Content Objects & ensuring its effective usage.

Designing custom info object, characteristic and key figure, Involved in creation of info cube, ODS object and multi providers.

Establishing Transfer Rules, Update Rules, Transfer routines, writing Start Routine and Update routines.

Devising BEx Reports providing insight of business intelligence for business analysis, decision-making, using selections, calculated key figures, restricted key figure and using variables with user entry/default value as a part of information customer layer.

Innovating various types of queries on SD, MM cubes and generating reports using BEx analyzer.

Enhancing the data source according to the client’s requirement while extracting data from R/3.

Creating Info set to extract data from flat tables & info spokes to extract data from info cube to as per the clients requirement.

Executing the entire operations on AWB (RSA1).

Thoroughly analyzing the MDM & Extended Star Schema and configuring.

Creating standards Info Source for master data and transaction data for SD application and Activated: Taking the entire data from SAP R/3 and flat file into the SAP BW.

Extracting the transaction data from Locockpit, R/3 to BW, maintaining the extract structures sources & replicating the data Sources into BW.

Entrusted with the responsibility of customizing and activating the business content objects and loading the data into ODS Object and Info Cubes.

Using BW Scheduler to load data into Info Cube, and ODS to Monitor the status of the data loads: creating ODS update rules and info package to load data & installed Business Content.

Determining Aggregates to Improve system query performance

Handling the tickets of various complaints as per the priority.

PROJECT - V

Project Name:

: SAP R/3 Implementation ECC 5

Client

GOODYEAR, AUSTRIALIA/INDIA

Role

Sr Technical Consultant ( BI/ABAP)

Duration

Dec-2007 – Dec-2008

Contribution

BW : Primarily Cost planning was done manually by using Excel, and the planned data was loaded into the info cubes. To automate the planning process, Integrated planning (BI-IP) was implemented in the company. In this project Cost planning was based on material Cost management.

Role: SAP BI-IP Consultant (SAP BI 7.0) ; managed activities such as :

Meetings and workshops for gathering functional specifications and then created technical specifications based on the requirement.

Created Real-Time Info cube, aggregation levels, filters, planning functions and planning sequence that is required for planning application in IP.

For Characteristic relationships DSO has created with deviation. 0CALQUARTER data has been derived from 0FISCPER.

Developed several filters in planning modeller for the use in planning functions and queries.

Developed copy planning functions to copy data from different versions, FOX planning functions for addition, multiplication, subtraction, division calculations and Revaluation functions.

Written Customer exits for variables and ABAP Routines in transformations.

Created Transformations, Info packages, DTP (Data Transfer Process), Info cubes and DSO (Data Store Objects) and loaded data.

Developed Input-Ready Queries for planning by different level of users.

Created Restricted Key figures, formulas and Variables based on Characteristics, Customer-Exit and Text, different Web layouts for different users in WAD

Prepared Solution Document for the developed solution.

Created Reporting Authorizations and assigned to roles for different users

Published Queries in portal by creating Iviews.

SAP CIN Patches Implementation for upgrading the system .

Whole Technical Developments Reports, Smartforms, Sap scripts, BDC,LSMW .

I was involve in designing and development of following HR activies :

Development Reporting, Sap script, Smart Forms,Module pools programmig

Invoice printing - Commercial Invoice & Excise Invoice

Developed : General Excise Invoice,

Are1 Invoice,

Are3 Invoice,

Trading Invoice for different plant

FI Check printing- Development Check printing program for payment to vendor .

Uses Logical database 'PNP'(entered in program attributes) to retrieve various personnel data and download it to an excel / tab delimited file.

HR Report to list all logged changes in infotype data for an employee. Uses the PCL4 Audit Cluster.

PROJECT - VI

Project Name:

SAP R/3 Implementation ECC 5

Client

Jindal Stainless Ltd

Role

Technical Consultant ( BI/ABAP)

Duration

Nov-2006 – Nov-2007

Leading the development, configuration and support of reporting solutions, primarily using the SAP Business Information Warehouse (BI/BW) Application.

Working from functional/business requirements to design and develop data sources (installing standard data sources to enhance existing data sources and create custom data sources).

Working from functional/business requirements to design and develop BW objects (installation of standard objects, enhance existing objects and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, etc.

Documenting testing plans and complete Unit Testing of developed objects and reports.

Working with Quality Assurance business resources to complete System and Integration Testing.

Analyzing and communicate report development issues, including problems with data integrity, data design, and functional and technical software issues.

Delivering work within tight deadlines and consulting on business issues to offer lasting value to clients as part of ongoing engagements.

Dialog Program: -

Permanent Loan Register Application

Excise Register including zj1id/zj1iex

This application used in store department for issuing tool,and other material and getting back from them this application maintain data for issueing and deposit of goods

Planning Dashboard – This screen has been developed to display and allocate & de allocate the coils, Club & De club the Production order and display chemistry & History reports. Also updating various Tables through Transaction using BDC. Output screen contains two ALV container.

Production Confirmation – This screen has been developed for the confirmation of production orders, goods movement and entering the process parameters. This screen contains various process like Jointing,Annealing,Rolling,Skin Pass,Grinding,Slitting,Cut to Length, Voss Leveler. Also updating various Tables through Transaction using BDC. Output screen contains two ALV container.

Tool Management – This screen has been developed to maintain the status and history of the Punches and Die Plates that are used in Coil Blanking Line. Here we maintain the Punches and Die plates and their Grinding status and time.

BDC: BDC program to upload customer master data from legacy system to R/3 System.

BDC program to upload Purchase Order details from legacy system to R/3 System.

Scripts:

Made use of SAP Standard Report Program RSTXLDMC to upload TIFF (For logo) and display as Standard text.

Making Sap script for Material Discrepancy report using table MKPF, MSEG .

Making Sap script Vendor Payment Advice of FI module using table BKPF BSAD BSEG .

Sap script for Sale tax certificate of contractor –FORM-XIA using table RBKP .

LSMW :

Vendor Master Data updating from tcode FK02 –withtax holding Account

Updating the field of with tax type, withtaxcd, Restyle. Writing ABAP Code.

Customer Master updating from Tcode -XD02 updating customer

Sales organization, distribution channel,division, delivery priority, Shipping condition,delivery plant .

Enhancement:-

User-Exit ME23N making assignment type P-project for plant company code -JSLO

Customer enhancement (CONFPP05)we can update our own data once we have saved the confirmation(Function Exit EXIT_SAPLCORF_105).

Customer enhancement (MBCF0002) includes a function module that is called up when

we enter a goods movement for each item(Function Exit EXIT_SAPMM07M_001).

PROJECT - VI

Project Name:

Remote EDI System

Client

Atlas Cycle Industries Sonepat

Role

Junior Technical Consultant (BI/ABAP/Oracle)

Duration

Sept – 2004 to Oct-2006

Contribution

Description: The EDI System, the objective is to make whole organsation activities managing outgoing and incoming files. It's a project, which deals with versatile users starting from Vendors to the organsation having little knowledge about computer. The said project is divided into mainly two parts . Inhouse communication and Outdoor Communication EDI system connect organisation to Venders,partner and others through A computersize communication as they sends files,documents through this

system and taking their output at their own center, therefore EDI providing excellent movement of data between two partner.

The main objective of the project was to have a common IT system that supports an efficient purchasing process. The project was initiated due to inflexible legacy systems with more custom interfaces, non integrated processes and also due to proprietary data warehousing software that complicated data analytics with more custom built reports

S A P - ABAP/4 (4.6C) TRAINING

Attended SIX WEEKS of Practical Training at CENTRE FOR DEVELOPMENT OF ADVANCED COMPUTING, Noida (Dept of I.T., Ministry of Communications and I.T., Govt. of India).

IT-SKILLS

Languages : BI / ABAP/4 (4.6C),

: C, C++, and VB, VC++ (Window Programming)

RDBMS : Oracle (PL/SQL)/DBA.

Operating Systems : Windows -9X, XP, UNIX.

Personal Information:

Father’s Name : Sh.Gopal Krishan

Date of Birth : 05-12-1977

Sex : Male

Nationality : Indian

Martial Status : Married

Contact no : +91-858*******

Prefered Location : Anywhere, no preference

Passport No : Z2062133

Date:

Place: (SANJEEV KUMAR)

Contact this candidate