Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Rajendra Gaware

Rajendra Gaware

Somerset,NJ

Summary

Rajendra Gaware is an SAP BW4/HANA/SAC Certified Consultant with 17+ years of SAP professional experience.

SAP BI experience includes extensive knowledge in BW modelling and reporting, technical developments, production support, system testing, documentation, and monitoring system.

Expertise in SAP HANA modelling (Calculation Views, SQL view, procedure etc.)

Have built many analytical solutions using BI reporting suite using Analysis office, WEBI and BEX analyzer

Vast experience in handling support projects, business critical close and SLA management and have good knowledge of Ticket Tracking Tool: Remedy, SAP solution manager and ClearQuest.

Have worked many upgrades and end of end implementation projects.

Good experience in SAP ABAP required for all BI modelling.

Knowledgeable in the usage of Application lifecycle management tool (HPQC) and Jira Xray for execution of test scripts and test documentation.

Experience in system monitoring, performance optimization, system testing and end user assistance

Self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

An effective communicator with excellent relationship management skills and strong analytical, problem solving & organizational abilities.

More than 11 years of direct client facing experience

Overview

17
17
years of professional experience
3
3
Certification

Work History

Senior SAP BW4/HANA Consultant

LTIMINDTREE
01.2020 - Current
  • Green field Implementation of Datahub BW/4HANA along with CFIN S4HANA which will pave way for advance planning and forecasting, reporting and analytics (Enterprise Performance Management)
  • The objective of SigniFi program is addressing hotspots like lack of harmonized data, disjointed technology & tools, non-standard processes
  • Gather requirements from business stakeholders
  • Analyze business and functional requirements to define target SAP BI/BW solution architecture
  • Prepare detailed implementation plan with timelines
  • Work closely with technical SME and provide technical leadership to team to complete deliverables
  • Develop required BW data flow for master data and hierarchies
  • Develop outbound interface for sending data to outbound planning system
  • Develop required reports using A4O and Webi
  • Develop HANA models for reporting layer
  • Implement various security tools
  • Perform per and post cutover activities for system build
  • Implement various SAP notes
  • Co-ordinate various testing cycles with business users
  • Follow all quality standards for deliverables.

SAP BI BW Consultant

LTI - Larsen & Toubro Infotech
02.2018 - 12.2019
  • Project ALIGN is initiative to implement a best-in-class automated solution to support Gross to Net (GTN) spending in US Commercial Pharmaceutical business
  • This solution will improve reporting capabilities, analytics, forecast accuracy, data integrity, and compliance
  • Develop required BW data source for Data Lake extraction
  • Data lake integration support
  • Provide SME support for local sales reporting application
  • Data validation and reconciliation between EDL and BW
  • Automatic scheduling of data extraction
  • Provide help during UAT.

Senior SAP BW Consultant

Larsen & Toubro Infotech
06.2017 - 12.2017
  • NA Pharm FP&A deployment need to Source Sales, COGS, material master and customer master data from LSR which need to use for future spend optimization reporting
  • Develop required BW data source for FDW extraction
  • Data flow development of Sales and standard GOGS data to FDW
  • Data profiling of existing GL, CCA and IO data
  • FDW integration support
  • Provide SME support for local sales reporting application
  • Data validation and reconciliation between BW and FDW
  • Automatic scheduling of data extraction
  • Develop standard cost interface from source system
  • Provide help during UAT.
  • Increased process automation, reducing manual efforts through the creation of advanced ABAP routines in transformations and DTPs
  • Improved data accuracy and consistency by implementing effective data extraction, transformation, and loading strategies from multiple sources.

Senior SAP Consultant

Larsen & Toubro Infotech
01.2017 - 05.2017
  • Migration of LYNX SAP Financial systems and BW system to Enterprise SDDC OPC (virtual/cloud) platform and migration of database to Oracle 12
  • Testing SAP Server migration to SDDC
  • Identify and remediate impact of SDDC migration
  • Conversion of Unix scripts to ABAP programs
  • Apply and test SAP notes as applicable
  • Manage and Lead Interface and functional testing for BW systems
  • Co-ordinate with other functional and technical team
  • Documentation results in HP-ALM
  • Verify and test all inbound and outbound interface connection
  • Prepare and execute cover plan.

Senior SAP Technical Consultant

Larsen & Toubro Infotech
07.2016 - 12.2016
  • Technical Upgrade the LYNX BW systems from 7.0 to 7.31
  • Prepare the Technical plan for SAP BW upgrade from 7.0 to 7.3
  • Manage and execute the testing for upgrade
  • Migrate 3.x report and workbook to 7.x
  • Migrate the old data flow to 7.x
  • Arrange the User acceptance testing from business users
  • Prepare and execute the cutover plan
  • Migrate customized web templates to standard templates.

Senior Implementation Consultant

Larsen & Toubro Infotech
01.2016 - 06.2016
  • Develop Intercompany price copy module for MDD division of Johnson & Johnson
  • ICP are being set every year for various MDD products and this interface will simplify the overall ICP setting process
  • Gathered business requirements and deliverables from SME
  • Prepare the Technical and functional design documents
  • Attend the change Advisory board meetings
  • Create technical design of ETL design and frontend interface
  • Create the BSP interface for uploading the strive data
  • Create the backend validation program to validate the data according to the business rules
  • Arrange the User acceptance testing from business users
  • Develop reporting interface and link it on portal.

Senior Software Engineer

Larsen & Toubro Infotech
02.2015 - 12.2015
  • Enhance local sales reporting application which hold all J&J pharma gross sales for US region
  • Develop new report and simplify the planning process in LSR application
  • Gathering business requirements and deliverables from business users of LSR application
  • Preparation of URS and Technical design documents
  • Development of the required objects (BI reports, BI objects, ABAP programs)
  • Arrange the User acceptance testing from business users
  • Preparation of system/UAT test protocol, System/UAT test scripts and Traceability matrix
  • Unit and system testing and documentation of same in quality center
  • Replace crystal reports with bex workbook
  • Simplify the SEM planning process – allow single file upload instead of per company
  • Develop automatic alert system for missing file from inbound interfaces
  • Replace mainframe inbound interface with secured file exchange MBOX interface
  • Handling the cutover and delivery of all objects.

SAP BW Consultant

Larsen & Toubro Infotech
02.2014 - 01.2015
  • Johnson & Johnson is the world's most comprehensive and broadly based manufacturer of health care products, as well as a provider of related services, for the consumer, pharmaceutical and medical devices and diagnostics markets
  • Prepare the Technical plan for SAP BW Server migration
  • Verify all interfaces connection after the server migration
  • Perform the scope testing
  • Arrange the User acceptance testing from business users
  • Develop and execute the cutover plan for upgrade
  • Work the basis and other team for remediation of upgrade issue
  • Apply and test SAP note as applicable
  • Develop transport stagey for dual maintenance.

SAP BW Consultant

Larsen & Toubro Infotech
02.2011 - 01.2014
  • Provide application development and support for Johnson & Johnson LYNX BW systems
  • Johnson & Johnson is the world's most comprehensive and broadly based manufacturer of health care products, as well as a provider of related services, for the consumer, pharmaceutical and medical devices and diagnostics markets
  • Provide level 3 support and general development activities
  • Investigate and resolve complex issues from L2
  • Communicate solution to L2
  • Open the tickets with Global Infrastructures Service Desk or SAP as when required
  • Manage issue resolution with different SAP groups
  • Develop and Deliver performance enhancement
  • Participate on infrastructure project (upgrade, failover, recovery, server migration)
  • Investigate and develop application fixes
  • Change management administration ( Solman and QC)
  • Code reviews for fixes
  • Deliver Enhancement / Projects
  • Provide the support for quarter close
  • Debug the issue for BPS raised during the planning cycles
  • Coordination with subject matter expert to gather the business requirement
  • Implementation and propose of several process improvements
  • Documentation of various problem solving methodologies and processes.

SAP BW Consultant

Larsen & Toubro Infotech
06.2007 - 01.2011
  • Support and development of Chevron's Business warehouse system
  • Chevron Corporation, USA is the world's fourth largest non-government energy company; Chevron is engaged in every aspect of the Oil and Gas industry, including Exploration, Production, Refining, Marketing and Transport; chemical manufacturing & sales; and power generation
  • Providing level 3 support and general developmental activities
  • Monitoring over 150 process chains on daily/weekly/monthly basis
  • Loading Master data and Transaction data as per requirement
  • Monitoring data loads from various source systems, analyzing errors in data loads and fixing them
  • Acting on customer generated tickets and resolving them within stipulated SLA
  • Raising tickets to resolution groups regarding performance of system and data loads
  • Modify the existing Reports & Creation of new Reports as per Client's requirement
  • Maintaining data reconciliations to verify data in SAP R/3 and SAP BI is same after data loads
  • Involved in support pack testing
  • Intimate onsite team about any possible redesign of process chains or/and it's triggering criteria and get their authorization
  • Notify respective markets about availability of reports or lack of it, and possible reasons for same
  • Checking daily time schedule for run and ensuring that jobs are finished within specified time frame
  • De-scheduling and scheduling of loads as part of weekend activity or on user requests
  • Enhancement of generic, standard data sources and creation of new data source as per business requirement
  • Performance management – Change log deletion, PSA deletion, Compression, partitioning and query performance improvement by aggregate creation, OLAP cache and BIA
  • Custom ABAP changes – transformation Code and User exit change, Data dictionary changes, SE38 program and function modules
  • Loading of data as per user requirement and preparation of reload plans for large historical data
  • Preparation and execution of production system outage plans
  • Creation of Info set, R3 queries, Open Hub, InfoSpoke and APD Process
  • Coordination with subject matter expert to gather business requirement
  • Implementation of process improvement
  • Documentation of various problem solving methodologies and processes
  • Support for BIA creation and troubleshooting problem in BIA.

Education

Bachelor of Engineering - Information Technology

Savitribai Phule Pune University
Pune India
08.2006

Skills

  • SAP BW4/HANA Advanced
  • SAC
  • SAP HANA Core
  • SAP Business Objects
  • SAP ABAP
  • SAP BW 3x / 70 Advanced

Certification

  • SAP Certified Associate – Data Analyst - SAP Analytics Cloud
  • SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA
  • SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 powered by SAP HANA
  • SAP Certified Application associate – Business Intelligence with Netweaver 7.0

Languages

English
Full Professional

Timeline

Senior SAP BW4/HANA Consultant

LTIMINDTREE
01.2020 - Current

SAP BI BW Consultant

LTI - Larsen & Toubro Infotech
02.2018 - 12.2019

Senior SAP BW Consultant

Larsen & Toubro Infotech
06.2017 - 12.2017

Senior SAP Consultant

Larsen & Toubro Infotech
01.2017 - 05.2017

Senior SAP Technical Consultant

Larsen & Toubro Infotech
07.2016 - 12.2016

Senior Implementation Consultant

Larsen & Toubro Infotech
01.2016 - 06.2016

Senior Software Engineer

Larsen & Toubro Infotech
02.2015 - 12.2015

SAP BW Consultant

Larsen & Toubro Infotech
02.2014 - 01.2015

SAP BW Consultant

Larsen & Toubro Infotech
02.2011 - 01.2014

SAP BW Consultant

Larsen & Toubro Infotech
06.2007 - 01.2011

Bachelor of Engineering - Information Technology

Savitribai Phule Pune University

Similar Profiles

CREATE PROFILE
Rajendra Gaware