We provide IT Staff Augmentation Services!

Sr. Sap Bwonhana Hana Bo Tableau Consultant Resume

SUMMARY

  • SAP Certified Senior consultant having 11+ years of experience working on SAP HANA / BWonHANA/ BW / BOBJ/ BPC and Tableau technologies.
  • Experienced in 5 full lifecycle implementations for different modules in SAP Business Warehouse/ Business Intelligence.
  • 3 years of experience working on new Tableau Software - Reporting tool for Visualizations.
  • 5+ years of exceptional experience working on SAP BOBJ 4.2, 4.1, 3.x, Tools - Web Intelligence, Design Studio, Crystal Reports, Analysis for Office, Excel and Lumira.
  • 2+ years of extensive experience working on SAP native HANA modeling (Attribute views, Analytic views and Calculation views) data profiling and security administration in HANA studio.
  • Worked on assigning Analytical privileges on different schemas for the business requirement and exposure to Procedures, decision tables and calculated columns.
  • Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SDA, SLT, BODS (ETL Extraction), DXC and Flat files.
  • Hands-on experience with SQL scripts like stored procedures and well versed with BW on HANA working functionalities.
  • Solid experience working on the Information Design Tool and the Central Management Console in Business Objects platform.
  • Solid experience working on SAP BI 7.4 on HANA platform and BW 7.5 powered by HANA.
  • Interacted with Clients to understand the business processes (functional and technical) across various SAP functional areas like SAP (SD): Sales Order, Delivery and Billing, SAP (MM) Material Management: Purchasing, Procurement and Inventory, SAP FI-CO (General Ledger, Accounts Payable and Accounts Receivable), SAP PP: Production Planning (Manufacturing), SAP PM: Plant Maintenance, SAP CRM: Customer Relationship Management, SAP IS-U and SAP PS: Project Systems.
  • Experienced with ABAP models (Routines, Function modules, customer exits) in BI/BW.
  • Experienced in BPC integration with BI/BW.
  • Modeling: Experienced with creation and maintenance of Data Sources, Info Packages, Info Objects, DSO’s, DTP’s, Info Cubes, SPO’s, Multi Providers, Open Hub, APD’s and Composite Providers.
  • Extraction: Proficient in data extraction from SAP ECC, flat files and BW using extractors such as LO Cockpit, CO-PA, FI, Generic Extractors and legacy systems.
  • BEx Reporting: Experienced in BEx Designer, Analyzer, Variables, Conditions, Exceptions, Formulas, Calculated and Restricted key figures, Structures and Filters.
  • Performance tuning: Involved in the evaluation of statistical performance, data load improvisation and query performance using compression, pruning, aggregates and partitioning techniques, BWA and BI accelerator for index maintenance.
  • Migration projects: Involved in migration from BW 3.1c to BI 7.0 (NW 2004s) and from BW 7.0 to BI 7.3 (NW 2004s) and BI 7.4 powered by HANA.
  • Production Support: Experienced with REMEDY, ALM and HPQC tools for Incident management, defect resolutions and ticketing issues.
  • Integrated Planning: Aggregation levels, Filters, Planning functions and planning sequences in Integrated Planning.
  • Created Web Intelligence Report and Analysis for OLAP reports on the BEx Queries using BICS connectivity.
  • Excellent analytical skills, proficient in analyzing data, solid domain knowledge of Health Care, Finance, Food and Beverages, Supply Chain, Consumer Products, Consumer Goods and Sales environments and with a strong Manufacturing background.

TECHNICAL SKILLS

Data Warehouse: SAP BI 7.4/7.5 on HANA, BI 7.3, BI 7.0, BW 3.5, HANA SPS 09/10/11/12.

ERP Integration: SAP R/3 4.7, ECC 6.0 - SD, MM, FI, PP, PM and PS modules.

BI Reporting Tools: SAP BEx, WEBI, Crystal, Design Studio, Analysis for Office, Tableau and Lumira.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BWonHANA HANA BO Tableau Consultant

Responsibilities:

  • Actively involved in leading prototyping and design sessions, workshops with the business.
  • Creating the Advanced DSO and Composite Providers for data consolidation.
  • Creating the BW models in the backend and importing the models to HANA.
  • Worked on designing the native HANA Information view models like Attribute views, Analytic Views and Calculation views.
  • Worked on BWonHANA eclipse based models for the consumer database project.
  • Provided expert technical assistance with training, design and architecture tasks, and daily oversight of system processes and performance.
  • Worked on the data modeling and building complex calculations in HANA models.
  • Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures.
  • Involved in writing complex ABAP routines and formulas for the data transformations.
  • Involved in moving transports from source to target using life cycle management LCM.
  • Working on creating Tableau dashboards on HANA information models.
  • Involved in publishing the Tableau dashboards to the Tableau server and training users to access the dashboards via IPad and mobile devices.
  • Involved in creating complex calculations in Tableau and building visualizations by using different types of charts.

Environment: SAP BWonHANA, SAP BW/BI 7.3, 7.4, 7.5 on HANA, HANA studio, Tableau 10.1.3, Web Intelligence, Analysis for Office 2.1, 2.3.2, 2.4, BPC, ABAP, Query designer, Bex Analyzer.

Confidential

Sr. SAP HANA BW BO Tableau Consultant

Responsibilities:

  • Participated in all phases of application development including requirement gathering, functional specifications, design, development, testing, deployment and support.
  • Actively involved in leading prototyping and design sessions, workshops with the business.
  • Creating the function module based extractors in ECC and replicating the data into BW.
  • Creating the BW models in the backend and importing the models to HANA.
  • Worked on designing the native HANA Information view models like Attribute views, Analytic Views and Calculation views.
  • Provided expert technical assistance with training, design and architecture tasks, and daily oversight of system processes and performance.
  • Involved in technical discussions with the team and the business as per requirements.
  • Worked on the data modeling and building complex calculations in HANA models.
  • Created native HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
  • Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures.
  • Monitoring the replication process using native SAP HANA studio and SAP LT replication server for transactional Integrity.
  • Involved in moving transports from source to target using life cycle management LCM.
  • Working on creating Tableau dashboards on HANA information models.
  • Involved in publishing the Tableau dashboards to the Tableau server and training users to access the dashboards via Ipad and mobile devices.
  • Involved in creating complex calculations in Tableau and building visualizations by using different types of charts.

Environment: SAP HANA 2.0/1.0 SAP HANA SPS09/10/11/12, SAP BW/4HANA, SAP BW/BI 7.3, 7.4, 7.5 on HANA, Tableau 10.1.3, Web Intelligence, Analysis for Office 2.1, 2.3.2, 2.4, BPC, Query designer, BEx Analyzer.

Confidential

SAP HANA BI BO Tableau Consultant

Responsibilities:

  • Worked on redesign on SAP migration of Hyperion project to enable self-servicing report to end users.
  • Provided expert technical assistance with training, design and architecture tasks, and daily oversight of system processes and performance.
  • Involved in discussions with the functional and technical teams and the gathered the business requirements for the scope of the project.
  • Worked on financial data for GL, Non-GL, Profitability calcs, internal ratios, plan and forecast data.
  • Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
  • Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures.
  • Monitoring the replication process using SAP native HANA studio and SAP LT replication server for transactional Integrity.
  • Created native SAP HANA Information Models using Attribute, Analytic and Calculated Views.
  • Replicated data using SLT and BODS and created models as per business requirement.
  • Expertise on data flows, query transforms, case transforms and replication jobs in SAP BODS and imported BW objects in native HANA studio.
  • Involved in creating different objects for the modeling which includes DSO, Cube, SPO and Multi Provider.
  • Worked on various inbound and outbound data feeds from Hyperion interfaces.
  • Worked on leveraging the existing models for the balance sheet and Income statement flows.
  • Developed performance improvement measures like pruning, aggregates, indexes and partitioning.
  • Involved in writing the start routines, end routines, expert routines and field routines as per the business logic.
  • Involved in creating end to end flow for analysis authorizations for BW objects for security purposes.
  • Involved in the Data source enhancements for the Business content extractors 0FI GL 14.
  • Worked on 0FI GL 60, 0FI GL 14 and other generated financial extractors.
  • Involved in data loading and mirror data validations from source to target.
  • Involved in creating SIT scripts for the quality and staging environments.
  • Involved in creating various BEx queries for the financial needs and used Analysis for excel as a reporting tool for the end users.
  • Involved in creating EPM self-service input templates for the financial needs.
  • Involved in creating various WEBI reports for the community banking financial purposes.
  • Involved in creating dashboard visualizations using Design studio and Lumira.
  • Involved in creating trending visual story boards using Lumira.
  • Worked on Charm process for moving the transports from Development system till production environments.

Environment: SAP HANA SPS09/10, SAP BW/BI 7.3, 7.4 on HANA, WEBI, Analysis Office for Excel, BPC, BEx, Analyzer, Tableau 8.x, 9.x, Lumira, Design studio and EPM.

Hire Now