SUMMARY

• Having 12+ 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, BPC and Point of sales data management - SAP Retail 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.
• Performed Requirement gathering, GAP Analysis and can translate Business Requirements into clear and concise System Requirements, Functional Specifications, and Technical Designs.
• 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).
• Expertise in SAP CAR (Customer Activity Repository).
• SAP HANA certified associate professional.
• 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, Xcelsius 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 Lead Consultant

Environment: SAP HANA, SAP ECC 6.0, 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 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 and Schemas.
• Created Stored procedures for EDP & KPI framework HANA tables.
• Involved in In-place conversion of existing SAP BW system into SAP BW/4HANA system.
• New data flows created using Layered Scalable Architecture++ (LSA++).
• 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 Lead Consultant

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

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.
• HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.
• 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.

Confidential

SAP HANA BW/BI Lead Consultant

Environment: SAP HANA, SAP BW7.4, SAP ECC 6.0, SAP PI, SAP BODS, TIBCOPOS, Analysis for Office & SAP BO 4.1

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 HLSD, Business requirement documents s given by various business teams.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• New data flows created using Layered Scalable Architecture++ (LSA++).
• Created composite providers, Open ODS view, Advanced DSO’S.
• Created Composite provider on top of Advanced DSO’s and HANA views.
• HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.
• Performed various data load activities in HANA Studio by using SLT Data Provisioning Technique, to replicate Finance related ECC tables for real time data automation.
• Design SAP HANA data model information Views for report consumption with time dimensions.
• Prepared a Functional specification document and Technical Specification document and HANA-BO Interface document for HANA and BO developments
• Created Technical specifications and standard modeling documents for HANA.
• Designed and Developed HANA information views required for reporting I.e. Attribute views, Analytical views, & Calculation views using native HANA modelling by accessing BW tables (Web orders, Retail & Business partner, service contracts, sales codes).
• Developed SQL scripts in Calculation Views.
• Created Reports on top of Infor providers using Analysis for Office.
• Created Relational Connections through JDBC drivers using IDT to connect to SAP HANA DB and therefore to access it's HANA views for BO reporting
• Monitoring SAP OSS message on regular basis and doing the follow up with SAP if required taking maximum attention
• Created Universes over HANA views to create WEBI documents.
• 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.