SAP HANA/BW4HANA Architect
Sopra Steria
Skills
SAP Analytics Cloud, SAP Certified Development, based CV, Script based data modelling, writing, PL/SQL, SAP BW, AMDP and ABAP based, Routines, DTP's, BW Queries, ODP and framework, DTIS, Data Tiering, SAP BW Modeling, Data Extractions, Query Designer, debugging, Operating System, Windows, UNIX, Database, SAP HANA, SAP BW4HANA, SAP BW/BI, ABAP 4Hana, BW on HANA, CDS, oDATA, Programming, SAP ABAP, Front, SAP UI5, Bex Designer & Analyzer, SAP Lumira, SAP Design Studio, SAC, HANA, Data warehouse, ABAP, SQL, SAP, SAP BI, OLTP, SAP R/3, objects, BADIs, Rollup, Parallel Processing
Project history
01/2009
-
02/2022
Projects: Price Module, AutoStore
Client: Airbus
Team size: 4
Database: SAP HANA
Platform: Windows
About the project1: The main objective of this project built KPI's like Material, Plant, contract
information, Forecast recommendation in Procurement domain of Airbus. The Price module tool helps
the procurement officer to make the best procurement strategies based on provided contract
calculations.
Responsibilities:
1. Analyzing and understanding the BRD and creation of best suited design of the data models in
HANA.
2. Leading a 4-member team of heterogeneous technologies and acting as a single point of contact.
3. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
4. Creation of cutoff plan for the moving the objects from development phase to IT phase.
5. While creating the data models and during enhancement of the data models, have ensured that no
existing functionalities gets disrupted and at the same time all the enhanced requirements
applied properly.
6. Built SAC Reports - Models, Stories and Analytical Applications
Client: Airbus
Team size: 4
Database: SAP HANA
Platform: Windows
About the project1: The main objective of this project built KPI's like Material, Plant, contract
information, Forecast recommendation in Procurement domain of Airbus. The Price module tool helps
the procurement officer to make the best procurement strategies based on provided contract
calculations.
Responsibilities:
1. Analyzing and understanding the BRD and creation of best suited design of the data models in
HANA.
2. Leading a 4-member team of heterogeneous technologies and acting as a single point of contact.
3. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
4. Creation of cutoff plan for the moving the objects from development phase to IT phase.
5. While creating the data models and during enhancement of the data models, have ensured that no
existing functionalities gets disrupted and at the same time all the enhanced requirements
applied properly.
6. Built SAC Reports - Models, Stories and Analytical Applications
05/2001
-
01/2020
SAP HANA/BW4HANA Architect
Airbus/Roquette; Sopra Steria
Project: Roquette
Client: Roquette
Team size: 8
Database: SAP HANA
Platform: Windows
About the project: The main objective of this project built Symphony KPI's, cater business with
development of multiple flows like Sales & Distribution, COPA, COOM, Supply Chain Management and
Inventory management in BW4HANA leveraging the benefits of HANA and develop reports on every model
as part of BW queries and consume the same using Analysis for Office. The project is in Greenfield
mode.
Responsibilities:
1. Analyzing and understanding the BRD and creation of best suited design of the data models in
BW4HANA respecting LSA++ architecture.
2. Leading a 8-member team of heterogeneous technologies and acting as a single point of contact.
3. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
4. Creation of cutoff plan for the moving the objects from development phase to IT phase.
5. Since it is greenfield, started from scratch, lots of challenges & building a powerful
solution to the customer, to fulfil their needs with innovative ideas and leveraging HANA
capabilities
6. Built BW Reports
Client: Roquette
Team size: 8
Database: SAP HANA
Platform: Windows
About the project: The main objective of this project built Symphony KPI's, cater business with
development of multiple flows like Sales & Distribution, COPA, COOM, Supply Chain Management and
Inventory management in BW4HANA leveraging the benefits of HANA and develop reports on every model
as part of BW queries and consume the same using Analysis for Office. The project is in Greenfield
mode.
Responsibilities:
1. Analyzing and understanding the BRD and creation of best suited design of the data models in
BW4HANA respecting LSA++ architecture.
2. Leading a 8-member team of heterogeneous technologies and acting as a single point of contact.
3. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
4. Creation of cutoff plan for the moving the objects from development phase to IT phase.
5. Since it is greenfield, started from scratch, lots of challenges & building a powerful
solution to the customer, to fulfil their needs with innovative ideas and leveraging HANA
capabilities
6. Built BW Reports
04/2014
-
01/2016
SAP HANA/BI Consultant
Infosys
Through Infosys, I worked for Airbus from Feb 2016 to Jan 2020 and for Syngenta from April 2014 to
Jan 2016
Organization: Infosys
Job Role: SAP HANA/BI Consultant
Duration: April 03, 2014 to Jan 08, 2020
Project 1: BiMA (Buy In Make)
Client: Airbus, Toulouse
Team size: 5
Database: SAP HANA, SAP ABAP
Platform: Windows
About the project: The main objective of this project built a dashboard on SAP Design Studio
initially and later on SAC which helps to provide the KPI's about Bill of materials merge with
Stock Data, Procurement data, Finance data and Bim scope data to optimize Contract renegotiations,
ordering, material and labour cost and provide procurement strategy, Data warehouse Stock info,
Forecast recommendation in Procurement & other domains of Airbus. This tool helps the procurement,
Manufacturing Engineering, Stock, Plant Maintenance to make the best strategies based on various
recommendation calculated.
Responsibilities:
1. Analyzing and understanding the BRD and creation of best suited design of the data models in
HANA.
Also developed Report programs and Function Models in ABAP.
2. Written procedures in SAP HANA SQL which in turns consumed models for faster reporting.
3. Leading a 5-member team of heterogeneous technologies and acting as a single point of contact.
4. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
5. Creation of cutoff plan for the moving the objects from development phase to IT phase.
6. Responsible of creating analytical privileges to impose security on row level of data for the
information models.
7. Have been performing the bonus of maintaining the high quality of deliverables.
Project 2: BiMA Financials
Client: Airbus
Team size: 4
Database: SAP HANA
Platform: Windows
About the project: The main objective of this project is to provide HANA data models to the users
after applying all the business rules that can be consumed by the SAP Lumia to develop the
reports. Dashboard build which helps to provide KPI's like Material, Plant, Forecast
recommendation in Procurement domain of Airbus. KPI's gives critical information about
forecasting.
Responsibilities:
1. Analyzed and understand the BRD and used best practices to build the data models of SAP HANA.
2. Leading a 4-member team of heterogeneous technologies and acting as a single point of
contact.
3. Written procedures in SAP HANA SQL which in turns consumed models for faster reporting.
4. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
5. Created cutoff plan for the moving the objects from development phase to IT phase.
Job Role: SAP BI/BW Consultant
Project 3: LAS Pricing Scale Up, NACT Tower Control Project
Client: Syngenta
Team size: 6
Technology: SAP BW/BI, SAP ABAP
Platform: Windows
About the project: The main objective of LAS project is to build Bex report the pricing waterfall
components along with the details of the pricing conditions. Key figures should refer to billing
documents but also sales orders pending of billing document creation, and finance data (CO-PA
adjustments).
Control tower is a Sales and marketing initiative. It's a new way of doing business which pulls
together the right people and data. This tool will automate the process of sending data in fixed
format to McKinsey team for further processing.
Responsibilities:
1. Analyzing and understanding the BRD and using best practices to build the data models of SAP
BI.
2. Leading a 6-member team of heterogeneous technologies and acting as a single point of contact.
3. Expertise in OLTP extractions from SAP R/3 using SCM and Generic Extractions.
4. Worked on Modeling, Extraction, Transformation and Loading.
5. Worked on multiple end to end implementation BW projects
6. While creating the data models, have ensured that no existing functionalities gets disrupted
and at the same time all the enhanced requirements applied properly.
Jan 2016
Organization: Infosys
Job Role: SAP HANA/BI Consultant
Duration: April 03, 2014 to Jan 08, 2020
Project 1: BiMA (Buy In Make)
Client: Airbus, Toulouse
Team size: 5
Database: SAP HANA, SAP ABAP
Platform: Windows
About the project: The main objective of this project built a dashboard on SAP Design Studio
initially and later on SAC which helps to provide the KPI's about Bill of materials merge with
Stock Data, Procurement data, Finance data and Bim scope data to optimize Contract renegotiations,
ordering, material and labour cost and provide procurement strategy, Data warehouse Stock info,
Forecast recommendation in Procurement & other domains of Airbus. This tool helps the procurement,
Manufacturing Engineering, Stock, Plant Maintenance to make the best strategies based on various
recommendation calculated.
Responsibilities:
1. Analyzing and understanding the BRD and creation of best suited design of the data models in
HANA.
Also developed Report programs and Function Models in ABAP.
2. Written procedures in SAP HANA SQL which in turns consumed models for faster reporting.
3. Leading a 5-member team of heterogeneous technologies and acting as a single point of contact.
4. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
5. Creation of cutoff plan for the moving the objects from development phase to IT phase.
6. Responsible of creating analytical privileges to impose security on row level of data for the
information models.
7. Have been performing the bonus of maintaining the high quality of deliverables.
Project 2: BiMA Financials
Client: Airbus
Team size: 4
Database: SAP HANA
Platform: Windows
About the project: The main objective of this project is to provide HANA data models to the users
after applying all the business rules that can be consumed by the SAP Lumia to develop the
reports. Dashboard build which helps to provide KPI's like Material, Plant, Forecast
recommendation in Procurement domain of Airbus. KPI's gives critical information about
forecasting.
Responsibilities:
1. Analyzed and understand the BRD and used best practices to build the data models of SAP HANA.
2. Leading a 4-member team of heterogeneous technologies and acting as a single point of
contact.
3. Written procedures in SAP HANA SQL which in turns consumed models for faster reporting.
4. Providing solutions to all the critical problems (technical as well as non-technical)
pertaining to the project needs and guide the team to reach to the desired goals within a
defined timeline.
5. Created cutoff plan for the moving the objects from development phase to IT phase.
Job Role: SAP BI/BW Consultant
Project 3: LAS Pricing Scale Up, NACT Tower Control Project
Client: Syngenta
Team size: 6
Technology: SAP BW/BI, SAP ABAP
Platform: Windows
About the project: The main objective of LAS project is to build Bex report the pricing waterfall
components along with the details of the pricing conditions. Key figures should refer to billing
documents but also sales orders pending of billing document creation, and finance data (CO-PA
adjustments).
Control tower is a Sales and marketing initiative. It's a new way of doing business which pulls
together the right people and data. This tool will automate the process of sending data in fixed
format to McKinsey team for further processing.
Responsibilities:
1. Analyzing and understanding the BRD and using best practices to build the data models of SAP
BI.
2. Leading a 6-member team of heterogeneous technologies and acting as a single point of contact.
3. Expertise in OLTP extractions from SAP R/3 using SCM and Generic Extractions.
4. Worked on Modeling, Extraction, Transformation and Loading.
5. Worked on multiple end to end implementation BW projects
6. While creating the data models, have ensured that no existing functionalities gets disrupted
and at the same time all the enhanced requirements applied properly.
06/2013
-
03/2014
Systems Engineer
Tata Consultancy Services
Projects: JNJ Consumer ASPAC BW Support
Client: JnJ (Johnson and Johnson)
Technology: SAP BW/BI
Platform: Windows
About the project: Johnson & Johnson International (Singapore) Pte. Ltd. are the Shared Service
Center organizations supporting Procure-to-Pay end-to-end processes in the Asia Pacific region.
Plays a vital role in providing energy to millions of customers across Asia pacific in an efficient,
reliable manner. TCS has been providing consulting and Production support (Data Load Monitoring and
Ticket Resolving) solutions for JNJ ASPAC.
Responsibilities:
1. Worked on implementing Technical content to monitor the performance issues and fixing the
issues by developing various tuning techniques.
2. Worked on Enhancements and change Requests proposed by the clients.
3. Worked on RCA and troubleshooting the data errors that are occurred during data loads.
4. Worked with monitoring process chains and ensuring data availability for the reports.
5. Worked on setting up of Information Broadcasting to email reports to users and automated the
process by scheduling on periodic basis.
Client: JnJ (Johnson and Johnson)
Technology: SAP BW/BI
Platform: Windows
About the project: Johnson & Johnson International (Singapore) Pte. Ltd. are the Shared Service
Center organizations supporting Procure-to-Pay end-to-end processes in the Asia Pacific region.
Plays a vital role in providing energy to millions of customers across Asia pacific in an efficient,
reliable manner. TCS has been providing consulting and Production support (Data Load Monitoring and
Ticket Resolving) solutions for JNJ ASPAC.
Responsibilities:
1. Worked on implementing Technical content to monitor the performance issues and fixing the
issues by developing various tuning techniques.
2. Worked on Enhancements and change Requests proposed by the clients.
3. Worked on RCA and troubleshooting the data errors that are occurred during data loads.
4. Worked with monitoring process chains and ensuring data availability for the reports.
5. Worked on setting up of Information Broadcasting to email reports to users and automated the
process by scheduling on periodic basis.
12/2010
-
02/2013
Project Engineer
Through Wipro Ltd; Wipro Technologies
Projects: In season Settlement; SAP BW Support projects
Client: National Grid
Technology: SAP BW/BI
Platform: Windows
About the project: National Grid is an international electricity and Gas Company and one of the
largest investor-owned energy companies in the world, plays a vital role in providing energy to
millions of customers across Great Britain and the Northeast US in an efficient, reliable and safe
manner. Wipro has been providing consulting and Production support (Data Load Monitoring and
Ticket Resolving) solutions for National Grid.
Responsibilities:
1. Analyzing and understanding the BRD and using best practices to build the data models of SAP
BI.
2. Act as Onsite Anchor while supporting at Customer site National Grid UK.,
3. Expertise in OLTP extractions from SAP R/3 using SD and Generic Extractions.
4. Implemented the standard business content and customized info cubes to meet the requirements.
5. Worked with ABAP objects building BADIs, creating BADI implementing classes and user exits.
6. Worked on performance tuning techniques like Aggregates, Compression, Indexes and Rollup,
Parallel Processing.
7. Created cutoff plan for the moving the objects from development phase to IT phase.
8. While creating the data models, have ensured that no existing functionalities gets disrupted
and at the same time all the enhanced requirements applied properly.
9. All Support/Maintenance activities carried out, when in Support projects.
Client: National Grid
Technology: SAP BW/BI
Platform: Windows
About the project: National Grid is an international electricity and Gas Company and one of the
largest investor-owned energy companies in the world, plays a vital role in providing energy to
millions of customers across Great Britain and the Northeast US in an efficient, reliable and safe
manner. Wipro has been providing consulting and Production support (Data Load Monitoring and
Ticket Resolving) solutions for National Grid.
Responsibilities:
1. Analyzing and understanding the BRD and using best practices to build the data models of SAP
BI.
2. Act as Onsite Anchor while supporting at Customer site National Grid UK.,
3. Expertise in OLTP extractions from SAP R/3 using SD and Generic Extractions.
4. Implemented the standard business content and customized info cubes to meet the requirements.
5. Worked with ABAP objects building BADIs, creating BADI implementing classes and user exits.
6. Worked on performance tuning techniques like Aggregates, Compression, Indexes and Rollup,
Parallel Processing.
7. Created cutoff plan for the moving the objects from development phase to IT phase.
8. While creating the data models, have ensured that no existing functionalities gets disrupted
and at the same time all the enhanced requirements applied properly.
9. All Support/Maintenance activities carried out, when in Support projects.
Local Availability
Only available in these countries:
Belgium
