avatar

SAP BW on HANA/BW4HANA /HANA/ABAP/Lumira/BO - 14 years exp

Experience:
18 y
Experience:
18 y
Location:
69181 Leimen
Last update:
20.04.2021
Register to Contact Freelancer
Available
Onsite hourly: N/A
Remote hourly: N/A
English: Native
Open for all locations
SKILLS
Dinesh Deivasigamani                                                                                   
Solution Architect - SAP BW4HANA/ABAP                                                                                      
dineshsigamani@gmail.com
Mobile: +49 1521 4633 755
                            
Executive Summary
  • 14 years of professional experience
  • Certified in HANA SP 11
  • EU Blue Card Holder valid till March 2022.
Technology Years Level of expertise
SAP BW 12 yearsExpert
BI-ABAP    10 yearsExpert
BW on HANA 5 yearsExpert
BW4/HANA4 monthsPractitioner
Native HANA1 yearPractitioner
SQL scripting6 monthsLearner
BW Authorization4 yearsExpert
S4HANA4 monthsLearner
Lumira Designer2 yearsPractit
OLAP database Analytics User management ABAP User administration dataflow SQL business logic Scrum SAP SAP BI Eclipse Tableau SAP BW Object Oriented Launchpad Design Studio cloud Fiori Management Console HANA QlikView Agile reporting tools
01.02.2018 — Now
Satyam computers Pvt; Delivery Hero AG
07Software Engineer
About Client: Delivery Hero AG is the leading online food order company operates in 40+ countries and 150,000 restaurant partners. Role: Solution Architect & Business Analyst This is Green field BW4HANA implementation with S4HANA as source system. Financial reporting: Objective is to move reporting from Legacy system to the SAP BW4HANA Cost Center reporting: Purpose of this project is to design and implement Cost center reporting dashboards using Lumira designer. Profit/Loss Statement and Balance sheet(IFRS) Purpose of this project is to create Profit/Loss and Balance Sheet(IFRS) dashboards in SAP BW based on the data from S4HANA using ABAP CDS views. Dashboards are designed in Lumira Designer.
01.06.2015 — Now
Lennox India Technology
Delivery Hero AGFeb '18Till dateSenior SAP BW consultant
01.06.2015 — 31.01.2018
Lennox India Technology Center
Solution Architect
About Client: Lennox is leading provider of climate control products for the heating, ventilation, air conditioning (HVAC) and refrigeration markets in the US & other parts of the world. Role: Solution Architect Sales order HANA Optimization Purpose of this project is to convert the existing Sales Order dataflow into LSA++ HANA optimized objects - Advanced DSO, Composite provider. CRM HANA Optimization Purpose of this project is to convert the existing CRM dataflow into LSA++ HANA optimized objects - Advanced DSO, Composite provider. IBP on Cloud (Integrated Business Planning) Purpose of this project is to send actuals data from BW to IBP through HCI (Hana Cloud Integrator) for planning purposes and receive supply planning data from IBP to BW for reporting needs COPQ (Cost of Poor Quality) Purpose of this project is to enable a more efficient process for reporting on Cost of Poor Quality (COPQ) by developing an integrated holistic BI solution. COPQ consists of costs associated with Gratis, LSA and Warranty charges. MCR (Material Cost Reduction) Purpose of this project uses (IP) Integrated planning. Objective is to build workbook in Analysis for office showing the actual cost of the material for project start date till current fiscal period. Based on this cost is forecasted for next 12 months. This provides a platform helps in Vendor management negotiating terms with the Vendor on Material cost. CRM Enhancements & Billing changes (Aug '15 - Dec '15) Description: Objective is to enhancements the CRM datasources & Billing datasources with new fields & include those new fields to the reports. Create new reports and enhancement of existing reports
01.11.2014 — 28.02.2015
Lead consultant & Business analyst
About Client: Leading NL-based financial services group operates as co-operative organization whose businesses provide comprehensive range of banking and financial services in the Netherlands and overseas Role: Lead consultant & Business analyst Project Name: MI-RN maintenance Release Description: Client uses SAP BW as reporting tool. This project is maintenance release of the Management information reports Reporting tool : SAP BW 7.3 - Bex queries, WAD, Design Studio Duration: Apr '13 till Feb '15 Role: Lead consultant & Business analyst Project Name: BW on HANA migration Description: Objective of the project is migration of BW database from DB6 to HANA targeting BW 7.3 on HANA Duration: Jun '13 till Dec '13 Project Role: SAP BW team member Project Name: HR FTE correction - Integrated planning Description: Local banks employ specialists - Financial advisors, Legal advisors, Compliance consultants on contract. These consultants usually book the actual hours spent for each of the local banks. At times actual bookings are not accurate which leads to incorrect billing/cost calculations. To overcome this, an integrated planning application is designed empowering the local banks to make up the necessary corrections. Duration: Aug '13 till Dec '13 Project Role: Lead consultant Project Name: TCO - Clarity Project Description: Objective of the project is to reduce total cost of ownership (TCO) of Clarity system. First step is migration of the clarity reports to BW system and phasing out the old clarity reporting engine. Duration: Jan '13 - Sep '13 Project Role: Lead consultant & Business analyst Project Name: Implementation of HR BW in 7.3 Description: The HR BW reports are reimplemented in 7.3 and integrated with data from other sources. Now it is possible to report all the KPIs in one dashboard. As part of this 150 reports & 12 interfaces are migrated.
01.03.2012 — 30.06.2015
Cognizant Technology Solutions
Project Name: VAT in control Description: Client pays VAT to tax agency based on all incoming and outgoing payments, with different percentages depending on the types of payments. End result expected is "VAT is in control", preventing audits and risk of penalty's, and does not pay more than legally required"
01.03.2012 — 28.02.2013
Lead consultant
01.02.2011 — 29.02.2012
Cognizant Technology Solutions
Lead consultant
Project Name: Implementation of FI-CO reports from 3.5/7.0 to 7.3 Description: The FI-CO reports reimplemented in 7.3 and integrated with data from other sources. Duration: Mar '11 - Feb '12 Role: Lead consultant
01.01.2010 — 31.01.2011
Cognizant Technology Solutions
SAP BI consultant
Project Name: 2/3LO support Description: Objective is to provide 2/3LO support to the BW applications. Duration: Jan '10 - Feb '11 Project Role: SAP BI consultant
01.06.2008 — 31.12.2009
Cognizant Technology Solutions
Project Name: Development of BW reports Project Description: Objective is development of BW reports and publishes in the Enterprise portal.
01.06.2008 — 31.01.2010
PROJEKTHISTORIE
Team member
01.06.2007 — Now
Keane India Pvt
08Technical Leader
Green field implementation4 monthsPractitioner
Solution Architect
Green field implementation4 monthsPractitioner Brown field implementation3 yearsExpert LSA++ 4 yearsExpert Scrum & Agile, Jira5 yearsExpert Project Management Experience Level of Expertise Requirement gathering5 yearsExpert Project planning & execution3 yearsExpert Resource planning & co-ordination3 yearsExpert Onsite/Offshore4 yearsExpert UAT planning & co-ordination5 yearsExpert Preparation of Cutover activities5 yearsExpert Role: Solution Architect * Setting up the BW landscape - SBIW configuration * Creation - Background remote users SAP and Non-SAP source systems * Creation of RFC destination and Call back destination * Creation of Development package * Logical conversion of Source system * House keeping activities, performance management, Transport management * Definition of Implementation Strategy, process and object naming standards * Technical guidance on the selection of reporting tools * Analysis for Office * Lumira Designer * Analytics cloud * QlikView * Tableau * Implementation of reports in the Fiori Launchpad * Definition and Implemenation of Authorization framework * Central User table(ADSO) * Creation of CE variables and logical framework for authorization logic * Analysis Authorization objects based on Customer exit variables * User groups and authorization models * User management * Single roles * Composite roles * User creation * User-Role assigment * User management * BADI implementation * RSROA_VARIABLES_EXIT_BADI for CE variables * RSR_VARIABLE_F4_RESTRICT for F4 selection * Object Oriented ABAP * Implementation of Classes and methods for CE Variables * BO Central Management Console * Creation of OLAP connections * User administration: Creation & Maintenance of Users and groups User security, folder access, access levels Modeling * Mixed modelling - Infoobject and field based modeling * Design and development of Composite provider using BW modelling tools in Eclipse * Implementation of LSA++ architecture * Design and development of ADSOs * Infoobjects * Implementation of business logic in transformation(Start, field end and expert routines) in ABAP/AMDP scripts * Development of ABAP CDS views * Creation of ODP extractors - Full and Delta * Creating and Scheduling of process chains * Exposure to SLT * Development of Calculation views based on Composite providers, ADSOs and master data tables * Open ODS View Reporting * Creation of queries * Calculated Keyfigures, * Restricted Keyfigures, * Structures * Creation of variables * Characteristic, * Hierarchy * Formula * Text * Implementation of variable logic in istep = 0,1 and 2 * User training & Step-by-step documentation * Creation of templates in Lumira designer Extraction * Creation of ABAP CDS view * Development of datasources based on ABAP CDS view * Extract data from S4HANA using CDS view - Full and Delta
Cognizant Technology ServicesMay '08Jun '
15Principal Consultant - ERP

Description

SKILLS
Dinesh Deivasigamani                                                                                   
Solution Architect - SAP BW4HANA/ABAP                                                                                      
dineshsigamani@gmail.com
Mobile: +49 1521 4633 755
                            
Executive Summary
  • 14 years of professional experience
  • Certified in HANA SP 11
  • EU Blue Card Holder valid till March 2022.
Technology Years Level of expertise
SAP BW 12 yearsExpert
BI-ABAP    10 yearsExpert
BW on HANA 5 yearsExpert
BW4/HANA4 monthsPractitioner
Native HANA1 yearPractitioner
SQL scripting6 monthsLearner
BW Authorization4 yearsExpert
S4HANA4 monthsLearner
Lumira Designer2 yearsPractit

Main Skills

Other Skills

OLAP database Analytics User management ABAP User administration dataflow SQL business logic Scrum SAP SAP BI Eclipse Tableau SAP BW Object Oriented Launchpad Design Studio cloud Fiori Management Console HANA QlikView Agile reporting tools

Work & Experience

01.02.2018 — Now
Satyam computers Pvt; Delivery Hero AG
07Software Engineer
About Client: Delivery Hero AG is the leading online food order company operates in 40+ countries and 150,000 restaurant partners. Role: Solution Architect & Business Analyst This is Green field BW4HANA implementation with S4HANA as source system. Financial reporting: Objective is to move reporting from Legacy system to the SAP BW4HANA Cost Center reporting: Purpose of this project is to design and implement Cost center reporting dashboards using Lumira designer. Profit/Loss Statement and Balance sheet(IFRS) Purpose of this project is to create Profit/Loss and Balance Sheet(IFRS) dashboards in SAP BW based on the data from S4HANA using ABAP CDS views. Dashboards are designed in Lumira Designer.
01.06.2015 — Now
Lennox India Technology
Delivery Hero AGFeb '18Till dateSenior SAP BW consultant
01.06.2015 — 31.01.2018
Lennox India Technology Center
Solution Architect
About Client: Lennox is leading provider of climate control products for the heating, ventilation, air conditioning (HVAC) and refrigeration markets in the US & other parts of the world. Role: Solution Architect Sales order HANA Optimization Purpose of this project is to convert the existing Sales Order dataflow into LSA++ HANA optimized objects - Advanced DSO, Composite provider. CRM HANA Optimization Purpose of this project is to convert the existing CRM dataflow into LSA++ HANA optimized objects - Advanced DSO, Composite provider. IBP on Cloud (Integrated Business Planning) Purpose of this project is to send actuals data from BW to IBP through HCI (Hana Cloud Integrator) for planning purposes and receive supply planning data from IBP to BW for reporting needs COPQ (Cost of Poor Quality) Purpose of this project is to enable a more efficient process for reporting on Cost of Poor Quality (COPQ) by developing an integrated holistic BI solution. COPQ consists of costs associated with Gratis, LSA and Warranty charges. MCR (Material Cost Reduction) Purpose of this project uses (IP) Integrated planning. Objective is to build workbook in Analysis for office showing the actual cost of the material for project start date till current fiscal period. Based on this cost is forecasted for next 12 months. This provides a platform helps in Vendor management negotiating terms with the Vendor on Material cost. CRM Enhancements & Billing changes (Aug '15 - Dec '15) Description: Objective is to enhancements the CRM datasources & Billing datasources with new fields & include those new fields to the reports. Create new reports and enhancement of existing reports
01.11.2014 — 28.02.2015
Lead consultant & Business analyst
About Client: Leading NL-based financial services group operates as co-operative organization whose businesses provide comprehensive range of banking and financial services in the Netherlands and overseas Role: Lead consultant & Business analyst Project Name: MI-RN maintenance Release Description: Client uses SAP BW as reporting tool. This project is maintenance release of the Management information reports Reporting tool : SAP BW 7.3 - Bex queries, WAD, Design Studio Duration: Apr '13 till Feb '15 Role: Lead consultant & Business analyst Project Name: BW on HANA migration Description: Objective of the project is migration of BW database from DB6 to HANA targeting BW 7.3 on HANA Duration: Jun '13 till Dec '13 Project Role: SAP BW team member Project Name: HR FTE correction - Integrated planning Description: Local banks employ specialists - Financial advisors, Legal advisors, Compliance consultants on contract. These consultants usually book the actual hours spent for each of the local banks. At times actual bookings are not accurate which leads to incorrect billing/cost calculations. To overcome this, an integrated planning application is designed empowering the local banks to make up the necessary corrections. Duration: Aug '13 till Dec '13 Project Role: Lead consultant Project Name: TCO - Clarity Project Description: Objective of the project is to reduce total cost of ownership (TCO) of Clarity system. First step is migration of the clarity reports to BW system and phasing out the old clarity reporting engine. Duration: Jan '13 - Sep '13 Project Role: Lead consultant & Business analyst Project Name: Implementation of HR BW in 7.3 Description: The HR BW reports are reimplemented in 7.3 and integrated with data from other sources. Now it is possible to report all the KPIs in one dashboard. As part of this 150 reports & 12 interfaces are migrated.
01.03.2012 — 30.06.2015
Cognizant Technology Solutions
Project Name: VAT in control Description: Client pays VAT to tax agency based on all incoming and outgoing payments, with different percentages depending on the types of payments. End result expected is "VAT is in control", preventing audits and risk of penalty's, and does not pay more than legally required"
01.03.2012 — 28.02.2013
Lead consultant
01.02.2011 — 29.02.2012
Cognizant Technology Solutions
Lead consultant
Project Name: Implementation of FI-CO reports from 3.5/7.0 to 7.3 Description: The FI-CO reports reimplemented in 7.3 and integrated with data from other sources. Duration: Mar '11 - Feb '12 Role: Lead consultant
01.01.2010 — 31.01.2011
Cognizant Technology Solutions
SAP BI consultant
Project Name: 2/3LO support Description: Objective is to provide 2/3LO support to the BW applications. Duration: Jan '10 - Feb '11 Project Role: SAP BI consultant
01.06.2008 — 31.12.2009
Cognizant Technology Solutions
Project Name: Development of BW reports Project Description: Objective is development of BW reports and publishes in the Enterprise portal.
01.06.2008 — 31.01.2010
PROJEKTHISTORIE
Team member
01.06.2007 — Now
Keane India Pvt
08Technical Leader
Green field implementation4 monthsPractitioner
Solution Architect
Green field implementation4 monthsPractitioner Brown field implementation3 yearsExpert LSA++ 4 yearsExpert Scrum & Agile, Jira5 yearsExpert Project Management Experience Level of Expertise Requirement gathering5 yearsExpert Project planning & execution3 yearsExpert Resource planning & co-ordination3 yearsExpert Onsite/Offshore4 yearsExpert UAT planning & co-ordination5 yearsExpert Preparation of Cutover activities5 yearsExpert Role: Solution Architect * Setting up the BW landscape - SBIW configuration * Creation - Background remote users SAP and Non-SAP source systems * Creation of RFC destination and Call back destination * Creation of Development package * Logical conversion of Source system * House keeping activities, performance management, Transport management * Definition of Implementation Strategy, process and object naming standards * Technical guidance on the selection of reporting tools * Analysis for Office * Lumira Designer * Analytics cloud * QlikView * Tableau * Implementation of reports in the Fiori Launchpad * Definition and Implemenation of Authorization framework * Central User table(ADSO) * Creation of CE variables and logical framework for authorization logic * Analysis Authorization objects based on Customer exit variables * User groups and authorization models * User management * Single roles * Composite roles * User creation * User-Role assigment * User management * BADI implementation * RSROA_VARIABLES_EXIT_BADI for CE variables * RSR_VARIABLE_F4_RESTRICT for F4 selection * Object Oriented ABAP * Implementation of Classes and methods for CE Variables * BO Central Management Console * Creation of OLAP connections * User administration: Creation & Maintenance of Users and groups User security, folder access, access levels Modeling * Mixed modelling - Infoobject and field based modeling * Design and development of Composite provider using BW modelling tools in Eclipse * Implementation of LSA++ architecture * Design and development of ADSOs * Infoobjects * Implementation of business logic in transformation(Start, field end and expert routines) in ABAP/AMDP scripts * Development of ABAP CDS views * Creation of ODP extractors - Full and Delta * Creating and Scheduling of process chains * Exposure to SLT * Development of Calculation views based on Composite providers, ADSOs and master data tables * Open ODS View Reporting * Creation of queries * Calculated Keyfigures, * Restricted Keyfigures, * Structures * Creation of variables * Characteristic, * Hierarchy * Formula * Text * Implementation of variable logic in istep = 0,1 and 2 * User training & Step-by-step documentation * Creation of templates in Lumira designer Extraction * Creation of ABAP CDS view * Development of datasources based on ABAP CDS view * Extract data from S4HANA using CDS view - Full and Delta
Cognizant Technology ServicesMay '08Jun '
15Principal Consultant - ERP

Attachments