D. RAMESH KUMAR Contact: +91-988*******
Bangalore India email: ac72zv@r.postjobfree.com
SAP HANA - BW4 HANA
Certified consultant
14+ years’ experience with SAP implementations, upgrade & support
PROFILE SUMMARY
Involved in all stages of Implementation, initial analysis, set-ups, testing, customization, documentation, roll-out and hyper
Proven success in 8 Implementations (5 outside India & 3 within India), 3 Upgrade projects & several support projects of SAP BW, BW4HANA, S4HANA, BODS, LUMIRA
Handled BW4 HANA, S/4, Native, Embedded Analytics using CDS views, and using Hana live to add vaue. Addressing hybrid, embedded and mixed scenarios
Possess high level consulting skills, involving understanding client’s business problem, architecting viable solutions and guiding the implementation of same within the client’s environment
Successfully worked in both managerial and architectural aspects; independently completed complex project tasks; identified key drivers of defined problems and proposed innovative solutions
Gained 5 years onsite experience across Europe (Germany, U.K., US, Netherlands, Czech Republic)
Big picture thinker, proactive & solution-oriented with analytical, decision making and problem-solving skills
KEY SKILLS
Functional Areas worked on:
Utilities & SCM
Supply chain management
Finance
HCM
Technical Skills:
BW4 HANA, S/4 Embedded Analytics, Native and BW on HANA, both on Side Car and Enterprise HANA using Data Services & SLT for Data
Experience in HANA Native Hana, CTS++ transports, HALM
BO webi, BO Dashboard, BO Administration, Analysis Authorization
Experienced in Embedded Analytics (building CDS views) and other Odata services
Experienced in Lumira, Analysis for OLAP sourcing data from HANA & Hadoop
Worked Composites, ADSO’s and Open DSO Views along with SDA focussing on mixed scenarios to reduce TCO
Worked on both Agile and waterfall adopting SAP best practices and fit scenario
Transport Management including forming of strategies, corrections, obtaining business, technical go–live sign-offs and their cut over plans
Worked on Predictive Analysis using Time series and Binning forecasting techniques
LSA ++ Architecture involving sourcing of data from heterogeneous landscape environments
Cutover planning, implementation of applying support packs, system refresh’s technical and business go-live
Supply Chain Management SME (Subject Matter Expert) in Demand Management, Inbound Monitor, Cost to serve
Worked extensively with FICO, HR, SRM and Supply Chain modules
CERTIFICATIONS
2012 year: SAP BW
2016 year: SAP HANA
2007 year: SAP BIW Net Weaver V
EDUCATION
2002 year: Masters in Business Administration (Marketing) from Andhra University
1999 year: Bachelor in commerce
IBM India pvt ltd Since Jun’2017-Till Date
BW4 HANA & BO Technical Architect
Client Shell
Responsibilities:
Managing BW4 HANA and Native HANA deliverables
Worked with Embedded Analytics on CDS views to address the business requirements which includes Cost to serve Lumira Dashboards with rolling and forecast scenarios
Worked with ODP ODQ to source data from SAP source systems
Worked with VDM’s to publish the same in Fiori apps – created Analytic tiles for business users
Designed mixed scenarios to consume data from S4 hana and BW4 hana without persisting the data
Worked on Plan data to homologize the data with Actuals and building what if analysis Dashboards
Extensively worked on HCM building HANA views for Available to work, Absentees, LSO and maternity scenarios
Worked on Cost to serve reporting using BW,Lumira Dashboards - sourcing from Shipping cost/GL,Purchasing and PCA
Sourced data using Data services from Non SAP and used them in our Analytics
Used SDA for building views from S4/HANA
Handling the projects by assuring Agile EDGE
Obtaining approvals from Client for the changes / Design document, FS
Tracking the development progress on a daily basis
Managing FUT, SIT & UAT
Handled HANA transports using CTS++ Charm transports for S/4 Hana and HALM for Native Hana through Solution Manager
Handled support incidents to deliver them in SLA
CGI Since Oct’2007- April’2017
BI BO & HANA Tech Lead and Solution Consultant in CGI
Current Role: Role: BI & Analytics Stream Lead
Responsibilities:
Managing end-to-end implementation, support & upgrade of SAP BI BO, HANA & Data Service Modules
Performing review of business process flow and mapping of business requirements (As-Is & To-Be Analysis)
Identifying gaps, converting business requirements into functional design documents & technical specifications, data migration and delivery
Worked on HANA Views, Optimizing Data loads with the use of SLT and minimizing HANA space
Preparing & maintaining business blueprint, functional specification and test scripts; contributing to the design, development, testing, troubleshooting and debugging of the solutions
Performing Unit Testing & System Integration Testing; testing various scenarios in development environments and tracking them till production; performing root cause analysis & resolution of defects
Selecting the most relevant tools/techniques to meet specific client requirements; understanding the benefits of using state-of-the-art methods and tools and their application on a particular engagement; contributing to continuous development of methods and tools
Ensuring strict adherence to project milestones, service level agreements, categorization schemas and rule policy
Acting as a point of technical escalation and resolution during the project lifecycle; identifying roadblocks and ensuring timely delivery of project
Leading a high-performing team of size 18; building & maintaining excellent rapport with team, improving team morale & promoting collaboration amongst team; delivering trainings for the team to help them tackle severity issues
Highlights:
Successfully acted as Tech Lead for a Stabilization project of client “PostNord”, involving migration of all objects to 7.3 SPO’s and re-designing of objects in 3.5 version
Appreciated by PostNord for delivering 1300 hours of work with minimal incidents and for numerous system refreshes, copies & cut over plans for both business & technical go-lives
Excellent track record of managing change requests and incidents for Haringey, UKPN, AKZO Noble Support project; received recognition from management and promotion as BI Architect for Logica India
Played a pivotal role in addressing a long pending issue of inconsistency between system landscape and obtaining sign-off from Solvay for implementation of the change
Received appreciation from:
oSAP and CGI, twice, for exceeding customer expectations
oOnsite Team from SAP America, in 2009 year, for accomplishing desired results in 1/3rd of the given time
oIT Director of Solvay for revamping the existing CVs to and providing solution to existing ETL process using BODS
Consistently contributed to the successful realization of client goals
Coordinated change management to interfacing systems such as ICH for upgrades and enhancements to ensure nil disruption to production time
Led engagements to analyse customer business processes, assess pain points and suggest areas of improvement using SAP solutions
Engaged with account teams and clients to identify opportunities for change; delivered detailed reports and presentations
Built communities of practice in collaboration with teams within the SAP ecosystem with the objective of sharing best practices and knowledge capital
Reduced defects by 34% and improved the Service Level Agreement (SLA) through defining best practices and department standards
Won:
oStar Award from United Utilities in 2015 year for delivering complex requirements on time
oGold Award for managing the entire Eon UK End-to-End Implementation project offshore; received appreciation from Head IT from E.on for the accuracy of the reports
o
ANNEXURE OF PROJECT DETAILS
Client: Solvay
Role: BI & Analytics Stream Lead
Period: 06’2015 – 04’17
Environment: SAP BW / BO / HANA
Source Systems: SAP ECC, SRM, NON SAP, ICH, FF
Client Profile: Solvay (headquartered in Brussels with around 27,000 employees in 58 countries) is a multi-specialty chemical company, committed to developing chemistry that addresses key societal challenges. Its products and solutions are used in planes, cars, smart and medical devices, batteries, in mineral and oil extraction, among many other applications promoting sustainability.
CGI transitioned Solvay’s present process from FR, Brazil. It also transitioned the BI Analytics stream and was successful in obtaining sign-off from Solvay. CGI has played a key role in S/4 HANA transformation of Solvay.
Responsibilities:
Worked on HANA Graphical and CDS Views,
Optimizing Data loads with the use of SLT and BODS
Worked on SAP SLT and Smart Data access (SDA) for S/4 Logistics application data
Converted existing reporting solution from ABAP to HANA by creating Calculated and CDS views
Migrated the existing scripted Calculation views to tabular functions
Created hybrid reports consuming both BW and HANA data
Resolved problem tickets to standardize the system to address recurring issues in data provisioning
Added value to the existing data flow by modifying / restructuring which resulted in saving significant provisioning time
Prepared POC for implementation of SPOs and got the same approved by the client
Used ADSOs and migrated data from DSO, CUBE & Hybrid providers
Steered migration from multi-providers/info sets to use composite providers
Worked on composite and ADSOs to migrate data from existing info providers but from Non- SAP data sources using smart data Integrator; worked on SLT replication and de-clustering scenarios
Devised strategy for usage of SLT (delta scenarios, master data updates and enhanced table updates)
Preparation of estimations for complex changes and obtained sign-off from Solvay
Client: PostNord
Role: BW BO Lead
Period: 04’12 - 05’15
Environment: SAP BW / BO / HANA / BODS
Client Profile: PostNord offered communications and logistics solutions to, from & within the Nordic region. CGI ensured mail delivery to private individuals and business in Sweden and Denmark Project.
Responsibilities:
Prepared blueprint; performed feasibility study; working with clients in the workshops to obtain Asis
Published webi reports for Sales Force Analysis using BW Bex reports as the data sources
Undertook BO administration such as user maintenance, roles and authentication/authorization
Developed data flows and workflows using BODS
Used SAP BW/ECC as source and HANA as target with SAP Data Services as the integrator
Built jobs in SAP BODS for ETL between Source and HANA
Created Attribute views, Analytical view and Calculated views as per the requirement needs
Made CV’s to use the SQL Engine for various functional areas by copying the standard SAP live content
Optimized the join conditions and used Cube CVs as required
Executed Data Extraction Transfer Loading using SAP Data Services 4.0 to import .csv files into SAP HANA tables
Used:
oTables involving hierarchies and resolved them using Hierarchy Flattening
oBODS for transformation and loading data from heterogeneous source systems i.e. files, BW to HANA
Developed POC basing on HANA S/4 and showcased the same to Client using COPA Data Model
Client: United Utilities End-to-End Implementation
Role: BI Analytics Consultant
Period: 03’10 - 04’12
Environment: SAP BW / BO
Location: U.K.
Client Profile: United Utilities is a leading Water & Utilities provider in UK and holds license to provide water & sewage services to around 7 Million people in North West England. These services are carefully regulated with the water regulator Ofwat. To show how they put their earnings to work, between 2010 to 2015 UU invested > £3 Billion to improve the water & wastewater infrastructure and the environment across the North West. UU relied on manual process for their HR, FI, SCM & SRM reporting that was consuming > 100 man-days of work every month. UU aimed to automate all the reporting using SAP BI and BO.
Responsibilities:
Delivered technical solutions for around 40 functional specs including HCM, SCM, SRM, BO, Authorizations, BO Administration, BO Promotion and Transition
Provided alternatives to many BW limitations
Successfully delivered the most of the objects 85 Bex reports, 58 Business Objects webi reports, 8 dashboards –(both management and operational level) and 12 Hana reports for HCM
Client: Eon UK End-to-End Implementation
Role: Analytics Tech Lead
Period: 04’09 - 02’10
Environment: SAP BW / BO
Client Profile: Eon is one of the UK’s leading Power and Gas companies generating electricity and retailing power & gas. It is part of the E.ON group and one of the world's largest investor-owned power and gas companies. It employed around 12,000 people in the UK and > 79,000 worldwide.
Responsibilities:
Prepared functional specs after conducting workshops with the client till the reports were live
Managed FS, TS, SIT, UAT, Authorizations and Transition
Developed:
o22+ reports out of which 16 were Webi reports on top of Bex queries
o6 Dashboards using Qaaws & Webi as data sources
Client: Welsh Water UK, Re-Implementation
Role: Support and Change Lead
Period: 11’08 - 04’09
Module: FI, HR, SD, MM, SRM, SIPS
Responsibilities:
Performed estimations; created several change requests by conducting workshops for understanding the actual requirement from the client
Used:
oComplex transformation logics to include both the transfer rule and update rule logic
oWrite Optimized DSO where ever applicable to improve the load performance
oBI Accelerator to optimize the query performance
Implemented Information Broadcasting for various workbooks and queries
Worked on:
oPS reports using numerous amount of customer exit variable to attain specific customer requirements from NATS
oComplicated Change Requests and provided solutions according to the client requirement
oBoth R/3 and BW copies from Production to Quality and provided the reconciliation document to the client
oBI transports while delivering the Change requests to the clients
Designed the Project Plan for system copies and executed them successfully
Resolved numerous amount of issues during system copies and even configured Idoc types for the source system to activate the same
Client: Haringey, UKPN, AKZO Noble - Support
Role: Tech Lead
Period: 10’07 - 11’08
Modules: FI, HR, SD, MM, CRM
Responsibilities:
Supported clients by fixing the problems while in the data loads
Completed the change requests on time and obtained sign-off from the customer
Led the BW team of 15 members; tracked quality of developments by the team members and helped them to resolve the tickets without escalations
Managed 20+ change requests and 200+ incidents
Client: Caterpillar Inc. - Implementation
Role: BW Developer
Period: 07’04 - 10’07
Environment: SAP BW
Client Profile: Caterpillar is a $40 Billion company which in initially into Earth moving Manufacturing and was now into whole range of Businesses to cater the Human needs.
Project Scope: This project was a new solution provided by SAP (Service Parts Management). SAP used both Ford & Caterpillar’s Process knowledge of over 100 years by joint venturing with both of them for building the legendary solution for Service Parts. SPM was implemented in CAT for a facility as a Ramp up Customer of SAP. This module as tested for the integrations between ICH, APO, SPP, CRM, SAP R/3 and EWM.
Responsibilities:
Involved in 2 important Business processes of SPM (Demand Management and Inbound Monitor)
Worked on data consistency between ICH, APO, SAP R/3, CRM systems before updating data in enterprise BW system
Worked on BW queries for Inbound monitor to check various discrepancies between to the order and the delivery
Worked on CRM extractor to source data to BW – the said data is used in APO for Demand forecasting using various models
Gained knowledge on Global ATP check while addressing data issues