We provide IT Staff Augmentation Services!

Sap Hana/ms Bi Consultant Resume

Houston, TexaS

SUMMARY

  • 11 Years of experience in IT where involved in building data ware house on SAP HANA SP10, SAP BI 7.5, SAP BO 4.2 (Webi) SAP ABAP SAP ECC 6.0, SAP BW/4 HANA, SAP S/4 HANA and used all the advanced ETL functions of SAP BODS 4.2 and also well versed with the process of ETL functions using Informatica.
  • Using data provisioning techniques SDA merged the data from BW into native HANA data models and created Calculation Views and reported to front end
  • Used Smart Data Access SDI to create Replication tasks and Flow graphs - Batch and Real time data flows to pull the data from Sales force using Web IDE.
  • Excellent expertise in SAP HANA, SAP BW 3.5, SAP BI/BW 7.5,BW/4 HANA, BOBJ 4.x.and Tableau 10, Power BI.
  • Created HANA Information models which are used to create multiple views of transactional data that can be used for analytical purposes
  • Created the detail Calculation views and detail Query views by using the HANA Live content.
  • Experienced in SAP HANA implementation, and good knowledge on SAP System Landscape transformation (SLT), DXC, SAPHANA data modeling using Attribute View, Analytic View and Calculation Views.
  • Customized the HANA Live content as per the report requirement.
  • Extensively worked on BW on HANA in creating Advanced DSO, Open ODS views, Composite providers and using them in HANA studio to create Calculation views/Hybrid models.
  • Good knowledge inn Tableau in creating Dashboards and Stories and published them to Server.
  • Created Power BI dashboards for MS PPM tool requirement by using the data connections of OData feed.
  • Handled Currency Translations in HANA calculated columns.
  • Extensive experience in Requirement Gathering, technical integration and development across various SAP modules, unit/system testing of business processes, performing data loads.
  • Extensively worked on SAP R/3 LO-Cockpit CO-PA, Generic Extraction and different modules like SD, MM, FI, GTS, CRM (Quotes, Orders, Opportunities, POS, and Channel Inventory), and Asset Accounting, RAR(Revenue Account Recognition).
  • Undergone complete life cycle Implementation of BW 7.x which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Process chain Scheduling, Monitoring, LO-Cockpit, Info-cubes, Multi-Cubes, SPOs, DSO objects, Info Packages, Transformations and DTPs, BEx- Analyzer and BEx Query Designer, Transports.
  • Extensively utilized business intelligence reporting tools such as Business Objects, Web Intelligence.
  • Good knowledge in Tableau admin related activities like setting up of security, creating users, creating projects, Monitoring User activities etc.
  • Good knowledge in Creating tables and views through SQL and SQL Script for creating Stored procedures, triggers, in HANA database.
  • Well versed in Information Design Studio for creating Universe and consuming them in BO to generate the reports.
  • Strong Knowledge in CMC, Crystal Reports, Analysis Office.
  • Involved in developing SAP ABAP (BI) objects like stat routines, End routine, Expert routine, field routine, Function Modules for Data source enhancements and for designing generic extractors as per business logic with functional.
  • Good Knowledge on ticketing tools like HP Quality Center (HPQC), Service Now etc.
  • Worked on creating roles, users, Authorization objects, capture objects releasing objects, providing Missing authorizations and unlocking the users, expertise on troubleshooting the transport logs .
  • Transported HANA models using CTS & Delivery unit models.
  • Involved in Preparation of Documentation, End User Training & Support .

TECHNICAL SKILLS

  • SAP HANA SPS10 BI 7.5 BW/4 HANA SAP BO 4.2 Webi, Design Studio, SAP BODS 4.2 Microsoft Azure data lake ADF Snowflake 3.X SAC
  • AWS S3, Python and Snowflake, EC2, Fusion MFT, Snowflake data warehouse
  • SAP ABAP SAP ECC 6.0 SAP CRM 7.0 SSIS SSRS SSAS
  • Tableau 9.1.1,IDT, HANA Studio, Power BI, Analysis for Office, Qlik View, Qlik Sense
  • SSMS, SSIS, SSRS and SSAS , AWS using S3, Redshift, Lambda, Step Functions, Glue SAP HCI

PROFESSIONAL EXPERIENCE

Confidential, Houston,Texas

SAP HANA/MS BI Consultant

Responsibilities:

  • Very good expertise in native Stored procedures to Insert, Delete and Update data to the tables.
  • Used Table functions as per the business requirement to get data from multiple source system wise schema tables and merged them into single source based on the IFRS standard revenue rules.
  • Worked on consuming Table functions in Calculation views and created mixed models.
  • Using data provisioning techniques SDA merged the data from BW into native HANA data models and created Calculation Views and reported to front end reporting tools like Webi and Tableau.
  • SAP HCI HANA Cloud Integration.
  • Using data provisioning techniques SDA merged the data from BW into native HANA data models and created Calculation Views and reported to front end
  • Microsoft - Azure data factory- Creating Pipelines, Linked Services, Data sets, Data flows to fetch data from Web services, On prem - SQL databases, Blob Storage, Azure SQL Data bases and reporting through Power BI, Tableau.
  • Used Smart Data Access SDI to create Replication tasks and Flow graphs - Batch and Real time data flows to pull the data from Sales force using Web IDE.
  • Passed multi-value input parameters from Calculation Views to Table Functions.
  • Worked on SAC.
  • Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
  • Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.
  • Hands on experience in QlikView advanced features like Alternate States and Direct Discovery.
  • Experience on QlikView Scripting, Set analysis and Section Access.
  • Scheduled the jobs and distributed to end users from QMC.
  • Experience in database programming, SQL, Tables, Views, Indexes, Joins, and Sub - Queries.
  • Trained end users to develop and use QlikView and QlikSense applications.
  • QlikView, QlikSense
  • Supplied data to OneStream using SAP HANA Calculation views for P&L, Balance sheet.
  • Used Dynamic SQL to meet the business requirements.
  • Experience in Native HANA
  • Good expertise in SQL based modelling in BW on HANA
  • Experience in working with customer facing roles and handling requirements gathering.
  • Design applications to deal with real time reporting requirements using SDI and SDA and creating native Hana models and creating Webi/AO & Tableau reports.
  • Created ABAP Core Data Services (CDS) by using different kind of Analytics annotations, Analytics Details Annotations, Consumption Analytics, OData Annotations,
  • UI Annotations to meet the live reporting requirements.
  • Created Stored procedure to meet IFRS requirements and included the stored procedures in AMPD and scheduled them through process chain on a regular intervals.
  • For MDG requirements installed the HANA live content for Materials, Workflow and Change Requests, Business partners and Equipment
  • Have used ODP info providers as backend objects and used AO as front to pull these ODP providers and report on them.
  • Installed the HANA live content for MDG which includes Query views, Reusable views and Search views.
  • Worked on creating Qlik view reports
  • Modified HANA live content to meet the business requirements and reported on Power BI.
  • Designed and implemented SAP HANA data modeling using Calculation Views, SDA.
  • Provisioning data from Different source systems into HANA box using various provisioning techniques like SDA, ODP.
  • Worked on SAP RAR, STO - Plant shut down turn around modules and implementation the solution by using SAP HANA calculation views and ODP extractors.
  • Worked on enabling the HANA live content for SAP MDG system.
  • Worked on Sap HANA Tables to reflect Exchange live rates application
  • H ands-on in designing solutions using SAP HANA, experience in replication scenarios on SAP landscape transformation (SLT)
  • Performance management within a SAP HANA landscape
  • Created Power BI dashboards for MS PPM team.
  • Developed reports using Webi, Analysis for office .
  • Using HANA Studio BW modeling tools to create Advanced DSO,O pen ODS views, Composite Providers to create BEx queries, Webi reports.
  • Enhancements to the existing reports in BI/BO by using Webi.
  • Worked with Security team for folder level and access level user security in BOBJ environments and the assignment of roles to Windows AD groups.
  • Worked on SAP BOBJ folder security by enabling the access levels for the folder structure defined.
  • Involved in writing ABAP code for data lookups as well created BADIs for the data source enhancements.
  • Worked on creating reports related to TPM, MTD reports by replicating relevant tables through SDI and creating Calc views on top of them and creating Analytical Privileges and adding the Column views to the Analytical Privileges and Roles.
  • Good expertise on Integration between different systems and reporting in a single report
  • Worked on the Visualization plan to see the performance risks for a given HANA calculation view.
  • Good knowledge on SAP SAC - SAP Analytics Cloud for planning, SAP Analytics Hub combining data from AO Reports, SAP BOBJ reports, Tableau, Power BI by grouping them into specific business departments.
  • Worked on BW/4 HANA, SLT, Native HANA ABAP CDS Views, XS server, AMDP, Stored procedures, SDI, Replication tasks, Flow graphs, SAP Security - Users, Roles, Privileges, Information Design Tool - Creation of Data Foundation, Universe for HANA reporting.
  • Created Pipelines, Datasets, Data flows, Linked Services in Azure Data Factory.

Environment: s: SAP HANA Studio BI 7.5 SAP BW/4 HANA SAP S/4 HANA BOBJ 4.2, Tableau, Power BI,SAP CPM, SOLMAN and ABAP, Analysis for office, SAP SAC, Microsoft Azure data lake, ADF.

Confidential, Warsaw, Indiana

SAP HANA Consultant

Responsibilities:

  • Used Dynamic SQL to meet the business requirements.
  • Experience in Native HANA
  • Good expertised in SQL based modelling in BW on HANA
  • Experience in working with customer facing roles and handling requirements gathering.
  • Design applications to deal with real time reporting requirements using SDI and SDA and creating native hana models and creating Webi/AO & Tableau reports.Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
  • Provisioning data from Different source systems into HANA box using various provisioning techniques.
  • Good knowledge in SQL Scripts in Calculation views
  • Very well versed with issues during transport management of HANA views like Predecessor issue and transport dependencies.
  • Involved in Converted FSD into TDS.
  • Sap HANA Tables to reflect Exchange live rates application
  • Well versed in Replication using SLT to extract real time data into SAP HANA tables
  • Reporting, Accessing Analytical and Calculation views from EXCEL through AO.
  • Worked on transporting HANA views/Delivery units/Packages/Change list IDs by using HALM tool.
  • Very well versed with issues during transport management of HANA views like Predecessor issue and transport dependencies.
  • Involved in SAP HANA Security including User Management, Roles, and Privileges
  • Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
  • Created Stories, Dashboards using Tableau.
  • Developed reports using Webi, AO.
  • Worked on SSMS, SSIS, SSRS and SSAS .
  • Creating Calculated views, Analytical views and Attribute views and using BO 4.2 as the platform created the Webi reports by using Calculated views created in HANA Studio.
  • Using HANA Studio modeled the Advanced DSO and Open ODS views as per business requirements and including them in the composite providers to create BEx queries and Webi reports.
  • Enhancements to the existing reports in BI/BO by using Webi.
  • Created end-to-end data pipelines using AWS S3, Python and Snowflake. Implemented Installed base and POS analytics in Snowflake Data lake.
  • Worked on Enterprise data platform (Data lake project) by implementing data-pipelines and built the data models in above business areas using AWS S3, EC2, Fusion MFT, Python and Snowflake data warehouse.
  • Involved in writing ABAP code for data lookups as well created BADIs for the data source enhancements.
  • Built data sources on tables extracted through Informatica from 14 legacy systems and built the Open ODS and Advanced DSO and utilized the advanced DSO active data tables to build the Calculated views and on top of calculated views created BO 4.2 Webi reports and also created Tableau Dashboards and Stories.
  • Handling Requirements, design, build and testing of the product.
  • Involved in requirement discussions and documenting.
  • Involved in Creating HANA Information models using SAP HANA LIVE Re-use views.
  • Creating universe as per the report requirement using IDT.
  • Co-ordinate and developed Webi Reports and Dashboards.
  • BODS- Rapid deployment solution RDS.
  • Promoting the Webi Reports and Dashboards from Development to QA and then to Production environments.
  • Looking after any customized change in the existing package as per the user requirement.
  • Created users, user groups and involved in User Administration in BO 4.2 using CMC.
  • Preparation of project status reports and updating the project status to the clients andproject management at regular intervals
  • Replication using Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0.
  • SAP HANA Data Provisioning and using SAP LT Replication Server (SLT), BODS
  • Developing SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
  • Good expertise on Integration between different systems and reporting in a single report

Environment: s: SAP HANA Studio BI 7.4 BO 4.2, Tableau and ABAP

Confidential, Sunnyvale, CA

SAP HANA Consultant

Responsibilities:

  • Worked on BW powered by HANA where used Calculation views(Dimension, Cube, Star Joins), Analytical Views, Attribute views, Created schemas, projects, Calculated columns, Input parameters, Joins, Unions, Aggregation, Projections and other basic functionalities of SAP HANA studio when and where required.
  • Used SLT to extract real time data for COPA module from ECC and Point of Sales (Channel management) from CRM.
  • Used BODS to fed data from BW on HANA to Hyperion and also extracted leads data from SFDC to HANA.
  • Created BADIs for data source enhancements and also used ABAP for start routines, end routines etc.
  • Used SAP BO - WebI and Design Studio as front end tool to create cross functional reports.
  • Created some basic Tableau dashboards based on excels files generated from Webi reports.
  • Developed BOBJ Webi reports for functional areas like COPA, Asset Accounting, GL, ECCS, POS (Channel management), GTS, CRM - Quotes, Orders, Opportunities etc.
  • Used HANA views in generating reports in SAP Business objects Analysis edition for Microsoft office aswell as for OLAP.
  • Trained end users to use the newly created reports on Webi.
  • Worked on 3 OTC(SD) module BW implementation where worked on different LO extractors related to Sales orders, Billing, Deliveries including GTS related attributes like license numbers etc.
  • Created BW modules joining all the
  • Well versed with LO cockpit data loads procedure i.e. filling setup tables, clearing setup tables, Direct delta, Queued delta, setting up of V3 jobs.
  • Well versed with delta mechanism in SD extractors.
  • Well versed with LO data source enhancements by using BADI’s as well CMOD.
  • Data reconciliation with ECC source tables for SD - Orders, Deliveries, Billing etc.

Environment: s: SAP HANA Studio BI 7.4 SAP BO 4.2 Webi, SAP ABAP SAP ECC 6.0 SAP CRM 7.0 SAP BODS 4.2

Hire Now