freelancer
Sanjeev K
0.0/5 (0 Feedback)
Member since 26/07/2021
Profile health 60%

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

Sanjeev Kumar

Mobile: + 91-8588835758

E-Mail: iasiitsanjeev@gmail.com

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

_________________________________________________________________________________________________

CAREER OBJECTIVE

SAP/ implementation/Development Consultant.

EDUCATIONAL QUALIFICATIONS

  • 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 8588835758

Prefered Location                    : Anywhere, no preference

Passport No                             : Z2062133

 

 

Date:

Place:                                                               (SANJEEV KUMAR)

0

Ongoing projects

0

Completed projects

0

Cancelled projects

0

Ongoing services

0

Completed services

0

Cancelled services

€0.00

Total earnings

* Click the button to send an offer

Send offer