SUMMARY:

• SAP Certified Senior consultant having 11+ years of experience working on SAP HANA / BWonHANA/ BW / BO/ BPC and Tableau technologies.
• Experienced in 5 full lifecycle implementations for different modules in SAP BI.
• 3 years of experience working on new Tableau Software - Reporting tool for Visualizations.
• 5+ years of exceptional experience working on SAP BOBJ 4.1, 3.x, Tools - Web Intelligence, Design Studio, Crystal Reports, Analysis for Office, Excel and Lumira.
• 3 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: Sales Contract Analysis, 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, Columbus, Ohio

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 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, Query designer, Bex Analyzer.

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.

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.

SAP HANA BI Analytics Developer/Architect Health Care Domain

Responsibilities:

• Worked as an architect role on advising and assisting in data modeling from legacy systems like Epic and Hyper wave.
• Creating the dashboards for patient survey in hospital management using design studio.
• Worked on creating universes and HANA views (Attribute views, Analytic views and Calculation views) and populating the data for Health Care Industry.
• Designed Logical Data Model and database objects and developed Semantics Layers with UDT/IDT, Dashboards and Reports.
• Created data visualizations and Dashboards using SAP Design Studio for the health care industry by using dimension filters, CSS styles, scripts and methods.
• Creating patient detail reports using Web Intelligence in the front end.
• Creating different visualizations by using charts and graphs for healthcare industry.
• Creating models in the backend for Hospitality billing.
• Created roles and assigned them to users of HANA.
• Stored data in columnar and row store in Database.
• Creation of multiple Graphical Calculation Views including Projections, Joins and Unions
• Worked on various data models according to the requirement
• Involved in the data provisioning tools SLT and Data Services for Hospital Industry.
• Prepared various Testing Technical Documents, and User requirements.
• Created Procedures to populate in Tables using Analytical and Calculated views.
• Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies.
• Developed workbooks with various functionalities and deployed them on Tableau server.

Environment: SAP HANA, WEBI, Design Studio, IDT, Crystal, Data Services, Epic, Hyper wave, Tableau Desktop 8, Tableau Server v8/v7.

SAP HANA BW BO Consultant/Lead

Responsibilities:

• Develop HANA Models to Validate the Master Data and Transaction data Tables with multiple Analytical View, Attribute View, Calculation View, Restricted Measures and Calculated Measures.
• Created analytic and complex calculation views using SAP HANA modeler.
• Involved in Load testing of various calculation views with HANA BASIS DBA Team.
• Experience in SAP HANA Data provisioning using SAP LT replication server (SLT) and data server.
• Worked on SAP HANA Data provisioning, Delivery Units and Schema Mapping.
• Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system-generating joins.
• Information Modeling in SAP HANA and Report Generation in BOBI 4.0 for Sales and Distribution module towards Comparative Analysis for Actual Sales and Planned Sales.
• Data Replication using BODS 4.0
• Execute migration from traditional DWH to HANA.
• Experience implementing Rapid deployment solutions and modify HANA models.
• Information Model Designing using HANA Studio.
• Creation of multiple Graphical Calculation Views including Projections, Joins and Unions
• Used SAP HANA XS engine for administration activities.
• Worked on Catalog schemas with System Tables, Content Packages and Roles in the Security Folder.
• Worked On SAP HANA Data Provisioning, Delivery Units and Schema Mapping.
• Review and QA deliverables of the team.
• Involved in BW system administration tasks.
• Experience in Creating and executing Data Service Job in SAP BODS to populate HANA.
• Created multiple Universes for ad-hoc and canned reports based on the relational data model that will replace the existing Stored Procedures as the data sources.
• Worked on transports to different environments till production.
• Designed SPO DSOs based on Fiscal Year and included the SPOs in the Multi Provider.
• Worked on Installing the Business Content.

Environment: SAP HANA 1.0, SAP ECC 6.0, BI 7.4, HANA, ABAP, BPC, JOB PILOT, WEBI, Design Studio, OLAP, BEx, BO, Tableau Desktop 7, Tableau Server 7. \

Sr. SAP BW/BI/BO Consultant

Responsibilities:

• Worked on business requirements gathering and gap analysis to identify gaps that existed from standard business content.
• Worked on installing and configuring various master data, transaction and hierarchy related data sources and replicated them in BW.
• Installed business content and worked on FI data sources 0FI GL 14, 3FI GL 0L TT, 3FI GL DL TT and 3FI GL SL TT.
• Developed several customized Info Objects, Info Cubes, SPO’s, DSO and Multi Provider according to specifications provided by the client.
• Involved in creating SPO partitions for all the reporting years and included SPO’s on top of Multiprovider for reporting.
• Involved in SAP data modeling by new HANA models and data analysis by building standard and custom BW solutions such as Info Cube design and creating custom semantically partitioned objects (based on Info Cube and DSO), DSO’s and Info Objects.
• Involved in creating balance sheet and income statement flows for reporting purposes.
• Involved in creating canned and adhoc reports using BEx query designer and connected the queries with Webi using BICS connectivity.
• Involved in data loading, job monitoring and created process chains for automating the process.
• Worked on various inbound /out bound interfaces from ETL and Informatica and to third party via open hubs.
• Created various financial reports related to General Ledger and had given the data to the BPC.
• Utilized all the performance tuning methods that helped queries to run fast for business.
• Collected all the developed objects and released the TR’s.
• Created queries using BEx and then generated universes and reports using Webi.
• Enhanced FI-GL data sources and populated the data from them.

Environment: SAP ECC 6.0, BI 7.3, HANA, ABAP, BPC, ETL, HPQC, WEBI, BEx, BO.

SAP BI BO HANA Analyst

Food and Beverages

Responsibilities:

• Extracted master data/transactional data into BI landscape (data from both SAP R/3 and external source systems) with custom extractors, modifications, enhancement of business content extractors, generic extractors, transports and process chains.
• Developed several standard and customized master data Info Objects/texts, Info Cubes, DSO and Multi Provider according to specifications provided by the clients.
• Performed LO-Cockpit extraction to extract the header and line item data from SD module (Sales Order, delivery and billing (2LIS 11 VAHDR/VAITM, 2LIS 12 VCHDR/VCITM and 2LIS 13 VDHDR/VDITM).
• Created multiple Universes for ad-hoc and canned reports based on the relational data model that will replace the existing Stored Procedures as the data sources.
• Developed SQL and PL/SQL scripts to implement business logics of database through Stored Procedures.
• Involved in creating the Graphical Calculation Views by including the analytic views using Unions, Projections and Joins based on the business logic.
• Utilized Web Intelligence for web based query and reporting.
• Created BI reports on Business Objects tools including Web Intelligence, Desktop Intelligence, Crystal Reports and saw to the performance issues on both of them.
• Uploaded vendor master data from MM in SAP as OLTP source and worked with different tables data ECC in SAP project system as well.
• Understanding the existing SAP BW Models and documenting the business flows in SAP HANA.
• Worked on assigning Analytic Privileges to Views in HANA.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio.
• Customized Multi Provider and added necessary object from different DSO’s and Cubes according to client requirement for generating reports.
• Involved in migration from BW 7.0 to BI 7.3 (NW 2004s) With HANA.
• Used REMEDY Tool for the Production Support issues like Incident management and BI batch tickets.

Environment: SAP ECC 6.0, SAP BI.7.0, HANA, REMEDY, ABAP, KRONOS, BEx Designer, BEx Analyzer, SAP ECC 6.0, WEBI.

SAP BW Consultant

Responsibilities:

• Developed several customized Info Objects, Info Cubes, DSO and Multi Provider according to specifications provided by the client.
• Running the Process Chains to fetch Data and Emptying the RSA7.
• Resolved many issues around the Upgrade. Created OSS messages for Upgrade issue.
• Conducted the User Training on the New BEx Features.
• Worked closely with the Corporate Consultants in providing Functional Specifications to enhance the current and develop new ODS and Info Cubes.
• Defined Custom Cubes and Multi Providers for the business scenarios along with aggregates.
• Enhanced standard data sources and replicated into BW system.
• Designed custom ODS, CUBES, and created operation and strategic reports in Personnel Management.
• Developed several customized Info Objects, Info Cubes, DSO and Multi Provider according to specifications provided by the client.
• Involved in data loading, job monitoring and created process chains for automating the process.
• Installed business content.
• Worked on different update modes for uploading the data from SAP R/3 to BW.
• Configured data sources in R/3 by using LO Cockpit (LBWE) and initialized the setup tables
• Created Process Chains to automate the data load and data target administration and monitored the processes.

Environment: SAP BW 3.5, SAP R/3 4.6, BW 3.5, BEx Designer, BEx Analyzer.