We provide IT Staff Augmentation Services!

Sap Hana Bi/bw Lead Consultant Resume

SUMMARY

  • Having 14 years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals such as telecom, manufacturing and pharmaceuticals.
  • Implemented Three full life cycle implementations for different modules (FI/CO, SD, MM, PP, CRM, HR, SRM, PM, EWM, TM, BPC and Point of sales data management - SAP CAR in SAP BI/BW & SAP HANA in all phases like Gap analysis, Blue-printing, design specification, development, performance tuning, testing, documentation, maintenance, training, Security authorizations and trouble-shooting.
  • Proficient in all phases of SDLC - Planning, Analysis, Design, Implementation, including development of Integration Test plan, Production Cut over documentation and Post Go-Live Support.
  • Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA and BW/4HANA Landscapes based on HANA ASAP Methodology.
  • Expertise in gathering and understanding the business requirements and translate them into Technical Requirements.
  • Effectively involved in all phases of project planning activities. Expertise in Providing the estimates and time lines for the requirements.
  • Outstanding ability to gather and translate complex user requirements into practical, cost-effective software solutions on time.
  • Expert in SAP Business intelligence modules (SAP BW, SAP BW on HANA, SAP BW/4HANA, SAP HANA, SAP BPC and SAP BO).
  • Experience in Replicating the tables using SLT.
  • Experience in creating flow graphs to extract, transform data using case, union, aggregation transforms in SDI.
  • Expertise in IS-Retail, POSDM of SAP CAR (Customer Activity Repository).
  • SAP HANA certified associate professional and Certified Power BI Professional.
  • Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Scalar functions and Analytical Privileges.
  • Upgrade Experience (SAP BW 7.3 to SAP BW 7.4, BI 7.0 to BW/BI 7.3 and BW 3.5 to BI 7.0)
  • Expertise in ETL activities like Data Extraction, Data Modeling, and Loading (Full/Delta upload).
  • Excellent experience in activating & enhancing the standard Data sources with structural changes & User Exits with ABAP coding, Extracted Data from Flat files & DB Connect, web service source systems for legacy data.
  • Expertise in front-end Business Warehouse components (Analysis for Office, BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries and Web application designer.
  • Worked on Business Objects (BO 4.0 & 4.1) using directly on Bex Queries and Cubes by BICS Connection. Experience using Universe Designer, IDT, Web Intelligence and BW OLAP Universes.
  • Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using Query Pruning, Join Pruning, Union Pruning, compression, aggregates, partitioning techniques and OLAP cache.

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA BI/BW Lead Consultant

Environment: SAP HANA, SAP ECC, SAP BW/4HANA, SAP BODS & Power BI.

Responsibilities:

  • Joining in meetings and attending the calls with different business teams to collect requirements (Developments & Reporting) and sent MOM details to respective departments.
  • Analyzed and understand the Business requirement specification documents given by various business teams.
  • Prepared a Solution Requirement document and Technical Specification document and HANA-Power BI document for HANA and Power BI Dashboard developments.
  • Design SAP HANA data models information Views for Power BI consumption with different dimensions and fact tables
  • Created Technical specifications and EDP framework modeling documents for HANA.
  • HANA information model design and build which includes Package, Table creation, Calculation dimension view, calculated view with cube functionality and Schemas.
  • Created Stored procedures for EDP & KPI framework HANA tables.
  • Working on performance tuning activities like Join pruning, union pruning, Table partitioning.
  • Access performance of calculation views where ever it is taking time taking using plan viz and trying to optimize it.
  • Extracting data from SAP ECC to SAP BW using extractors and creating ADSO’s, composite providers in SAP BW.
  • New data flows created using Layered Scalable Architecture++ (LSA++).
  • Design and developed composite providers and Advanced DSO’S.
  • Created Data sources over HANA views to create Power BI dashboards.
  • Created Dashboards in Power BI for AR Metric summary overview & AR Metric Details.
  • Involved in complete end to end testing for all the developed objects & reports and documenting test plans.

Confidential

SAP HANA BI/BW Lead Consultant

Environment: SAP HANA, SAP ECC 6.0, SAP BW/4HANA, SAP BODS & Power BI.

Responsibilities:

  • Involved in project meetings with different business teams to collect requirements (Developments & Reporting) and sent Minutes of Meeting details to respective teams.
  • Analyzed and understand the Business requirement specification documents given by various business teams.
  • Prepared a Solution Requirement document and Technical Specification document and HANA-Power BI document for HANA and Power BI Dashboard developments.
  • Design SAP HANA data models information Views for Power BI consumption with different dimensions and fact tables
  • Created Technical specifications and EDP framework modeling documents for HANA.
  • HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View, CDS views and Schemas.
  • Created Stored procedures for EDP & KPI framework HANA tables.
  • New data flows created using Layered Scalable Architecture++ (LSA++).
  • Expertise in data replication using SLT for real time data.
  • Created Deviation tables in SAP HANA using SLT.
  • Skipped the deleted records from source using include program in SLT.
  • Resolving issues in SLT like duplicate key, Blocked status and Trigger issues while real time data replication in SLT.
  • Created Flow Graphs for data extraction using case & join transforms in SDI
  • Rolled up the measure using Aggregate transform in SDI.
  • Created composite providers and Advanced DSO’S.
  • Creating Reports on top of Composite providers.
  • Created Data sources over HANA views to create Power BI dashboards.
  • Created Dashboards in Power BI for QRC Score card & QRC KPI Details.
  • Involved in complete end to end testing for all the developed objects & reports and documenting test plans.
  • Improved the data quality by using Data harmonization.

Confidential

SAP HANA BI/BW Lead Consultant

Environment: SAP HANA, SAP ECC, SAP BODS, Analysis for Office & SAP SAC.

Responsibilities:

  • Joining in meetings and attending the calls with different business teams to collect requirements (Developments & Reporting) and sent MOM details to respective departments.
  • Analyzed and understand the Business requirement specification documents s given by various business teams.
  • Design SAP HANA data model information Views for report consumption with time dimensions.
  • Prepared a Solution Requirement document and Technical Specification document and HANA-Tableau Interface document for HANA and Tableau Dashboard developments.
  • Created Technical specifications and EDP framework modeling documents for HANA.
  • Expertise in replicating ECC tables (VBAK, VBAP, KNA1, BSAK, BSAD, BSIK & BSAD) tables using SLT.
  • Add a field for a table in SLT using LTRS as per the requirement.
  • Resolving the replicating issues in SLT like duplicate key, missing triggers and table blocked status issues.
  • HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View, CDS views and Schemas.
  • Created Flow graphs using union transform to combine similar data sets using SDI.
  • Created a virtual table using SDA for master data from SAP HANA S/4 system.
  • Created Script based Calculation views to suffice the requirement.
  • Created procedures for Procedures,
  • Created Stored procedures for EDP & KPI framework HANA tables.
  • Created Data sources over HANA views to create Tableau dashboards.
  • Created Dashboards in Tableau for AR, Sales, Backlogs & Operations.

Hire Now