PL

Prashant Lal

available

Last update: 03.01.2019

Native HANA and BW Architect

Company: Mr.
Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Native or Bilingual)

Skills

  • HANA & BI Solution Consultant with extensive IT and business expertise with over 18 years of experience, performed various roles as Architect, Team Lead, Project Manager, Delivery/Development Manager, and Techno-functional Consultant.
  • Extensive hands on experience of performance optimization for BW on HANA, ECC on HANA and Enterprise Native HANA solution. Experience of leading performance optimization for several platforms running on HANA.
  • Solid experience of setting the end to end authorization, security and roles for Native HANA .
  • Around 13+ years of hands on BI experience, out of which last 5.5 years of hands-on working HANA experience. Worked and participated on 30+ SAP projects covering various SAP logistics module, IS-U, IS-R, BW on HANA, B4HANA, S4HANA, Enterprise HANA, OData, Fiori/SAPUI5, CAR, POSDM on HANA, Business Object, Lumira, BPC, PI, SAS, Microsoft, & Teradata application. Led many projects and project streams as Consultant & technical lead, delivering multi-million-pound projects on time to budget.
  • Project implementation experience of “HANA Enterprise Cloud”, “HANA Cloud Platform” as a solution architect for e2e implementation of various applications running on HANA using the cloud, PAAS, IAAS on one of the IT transformation programme.
  • Experience of implementing Business Suite on HANA, upgrade and migration to HANA platform. Involved in the PoC for S4HANA with simple finance add-on. Deep technical hands-on experience on various offering of HANA: Modelling, data provisioning (using SLT, SDI, SDA), performance optimization including troubleshooting, multi temperature data, CDS view etc. (to name a few).
  • Experience of implementing authorization, security and roles for BW, Business Objects and HANA platform.
  • Solid experience of System Design & Architecture at the enterprise level (for SAP estate) including sizing for various technologies stack, like HANA, BW, BusinessObjects & Sybase (for Information lifecycle management).
  • Experience in BI strategies, architecture, standards, guidelines, policies and frameworks that support strategic business drivers for the Data and Information domain.
  • Experience of setting up a virtual BICC and owning it, for developing, maintaining BI portfolio approach and BI Strategy. Ensuring that information architecture and information management strategy creates a foundation for future investment in business intelligence and collaboration and enable information Insights & exploitation.
  • 5 years of R3 Techno-Functional experience worked on 13+ Implementation and Support projects as SAP ABAP consultant.
  • Experience in working in different domains:  FMCG, Retail, Pharmaceutical, Defense, Oil, IT Services & Products, Transport, Government Sectors, Utilities, Telecom and Banking.
  • Experience of leading large team (up to 75 consultants) as BI Delivery Manager. Excellent team leading, project management skill.
  • Experience in all aspects of BI design and delivery, including strategic use of Business Intelligence tools, KPI reporting, tactical reporting, global template design, deployment & roll out, performance tuning, BI-Integrated Planning solutions.

Project history

McKesson Germany (2017 Oct – 2018 Sep): Native HANA & BW Solution Consultant
  • Design & development of HANA and BW solutions with various BI consumption layers like Excelsius, Webi, A4O, Lumira & SAC. Ongoing performance optimization of Native HANA & BW Solutions. Working with business users to support testing and fixing defects.
  • Remodelling BW solutions like Composite Provider, aDSO, ODS view etc into Native HANA views/model & SQL for performance optimization.
  • Design and development of authorisation, security & roles for HANA and BW solution
Capgemini/S3Group Finland (2017 Aug – 2017 Oct): BW4HANA Consultant
  • Requirement gathering through workshops, preparation of technical specs, design & development of B4HANA/S4HANA solutions, embedded analytics using CDS views and Native HANA solutions.
KPMG UK/Germany (2017 Feb – 2017 Aug): BW, HANA & CAR Analytics Expert
  • Design and development of Retail BI Sales reporting suites as part of the global ERP roll out for a major pharmaceutical client. Technology stacks used are ECC, Native HANA, HANA Views, SLT, BW on HANA, Business Objects & CAR.  Sole responsibility of native HANA development and artefacts
  • Design and development of security & roles for HANA and BW solution.
  • Performance Optimization and Troubleshooting
. British American Tobacco London (2015 Nov – 2016 Dec): BW & HANA Solution Architect  
  • Responsible for defining the BI roadmap, licensing need, RFP write up & response validation, selection of technologies & toolset, Target Architecture for the Next Generation BI Programme initiative in the organisation.
  • Responsible for defining BI Strategy, Standards, Patterns & Architecture Guidelines on the HANA/BW/BO space – also covering integration with other tools/technologies.
  • Implementation of BW on HANA end to end data flow for their Finance and Operational processes with the help of standard SAP logistics and FI extractors, HANA view & analytics, Mixed case scenario for BW & HANA, IDE development, BO 4.2 upgrade, security.
  • Responsible for System Design & Architecture including sizing for various technologies stack, like HANA, BW, BusinessObjects & Sybase (for NLS and ILM)
  • Solution architect for the Information lifecycle management using BW NLS/ILM and Sybase IQ platform.
  • Solution architect for the upgrade and re-platforming of the BusinessObjects platform and introducing new tools like Lumira, Design Studio, BI Mobile, Analysis for Office, Webi etc.
  • HANA SME and go-to person for advisory within the organisation.

Capgemini UK (2013 Jan – 2015 Oct): Managing Consultant/HANA & BW SME
  • Technical lead for BW on HANA end to end data flow, HANA views, SLT, Business Objects, Hadoop integration deliverables.
  • Led the HANA Optimization for areas like LSA++, ABAP Optimization, Native HANA, Smart Data Access (SDA), code pushdown
  • Solution Architect with hands on experience for the applications built on HANA using ODATA, Fiori and HANA model.
  • Worked as Project manager/Lead architect on the “HANA Enterprise Cloud” programme responsible for the upgrade, migration & Optimization of Enterprise HANA, BW on HANA, SLT, implementation of HANA Mixed case scenarios, Dynamic Tiering for multi temperature data management, HANA Live, Business Object, POSDM on HANA, SAP PI, Enterprise Portal, BPC on HANA, CAR & S4 HANA PoC on to the SAP Managed cloud platform (HEC). As part of this project, I’ve delivered several value additions for the client on the back of strategic/migration value assessment.
  • Led the system architecture & design, creation of Architecture Design Documentation, Solution Design, including sizing of infrastructure along with SAP HEC team.
  • Part of the co-innovation team, and worked closely with the SAP product development team in Paulo Alto.
  • HANA Advisory on architectural roadmap including selection of technologies stack.
British Gas UK (2005 – 2012): SAP BI/HANA Delivery Lead
HCL/Axon (2000 – 2005): SAP Solution Architect

Local Availability

Only available in these countries: United Kingdom
Profileimage by Prashant Lal Native HANA and BW Architect from SWAR Native HANA and BW Architect
Register