SUMMARY:

• Around 10 years of IT experience in SAP Implementation/support/Upgrade projects across multiple clients.
• Experience in SAP HANA, HANA Live, SAP BW on HANA, SAP BW 7.5/ 7.4/7.3/7.0/3.5 , SAP BODS 4.x, Tableau 2018.1, Business objects (BOBJ), Business intelligence (BI), Data warehousing, reporting and analysis. Analyzing business processes requirements, data modeling, configuration, testing, support, training, documentation and implementation of business applications allied to best industry practices and standards. Extensively worked on DB Migrations from classic BW to BW on HANA and BW/4HANA.
• Certified in C HANAIMP 11 Application Associate - SAP HANA 1.0 SPS 11.
• Functional Knowledge: SD, FICO & MM
• Expert level exposure to In-Memory Computing, Structure of SAP HANA studio, Configure Perspectives & Create Package, Enterprise HANA and BW on HANA.
• Solid understanding of SAP HANA Architecture, different deployment and integration options.
• Strong experience in Native HANA Modeling, Performance Tuning.
• Strong experience in SQL, stored procedures.
• Exposure to CDS Views.
• Knowledge in different ETL tools like SLT, BODS, SDA and SDI.
• Knowledge in different Reporting tools like Tableau, Web Intelligence and Lumira etc.
• Proven experience in HANA system architecture design, Implementation, Integration & Testing and post production support.
• Proven track record of interaction with client executives.
• Proven track record of collaborating with offshore team and leading them in reaching the Sprint goals.
• Creating Calculation Views of type Dimension/ Cube/ Cube with Star Join/ time Dimension/Script based.
• Creating the Attribute Views /Analytical View.
• BW on HANA, Migration to BW on HANA.
• Semantic Partition Objects, Composite Provider, Transient Provider, Advance DSO & Open ODS View.
• Converting DSO/Cube to In-Memory.
• Decision Tables, Creating a simple Calculation View of type SQL Script and procedures.
• Creating a Calculation View of type SQL Script using CE FUNCTIONs.
• SAP LT Replication Server (SLT)
• SAP Data Services (DS)
• SAP Smart Data Access (SDA)
• SAP Smart Data Integration (SDI)
• Tableau
• Lumira
• SAP Business Objects - Universe/IDT &Webi
• Analysis for Office / Analysis edition for OLAP
• Utilization and customizing HANA Live for Business.
• Utilization and customizing RDS on HANA Live for Business.
• Explain Plan
• Visualize Plan
• Tracing
• Partitioning
• Partitioning Tables
• Worked on S4 HANA Public cloud and On Premise environments.
• Expertise in SAP BW (Business Warehouse) and SAP Applications Integration with non-SAP systems.
• Extensively worked on creating and customizing ODS, Info Objects, DSOs, Info Cubes, Transformations, Multi providers, Info sets, Transient and composite Info Providers, DTPs, Process Chains and BEx Reporting.
• Expertise in Back end Business Warehouse Components Extractors (LO Cockpit, Generic Extraction with in BW System, LIS and non R/3 extraction).
• Performance (Aggregates, BW Stats, Partitioning), Production Support (Process Chains, info package groups) Front end Business Warehouse Components, Queries, KPIs, Calculated key Figures, restricted key Figures, Variables etc.
• Worked on functional upgrade/Migration of BW 3.x data flow to BW 7.x.
• Strong Analytics/Data warehouse knowledge using SAP Business Objects Data Services/ Data Integrator.
• Strong exposure in the integration of BODS with SAP modules and Non-SAP data sources.
• Strong exposure in using BODS as an external system for ETL between ECC, BI, HANA and Non SAP/Legacy Systems.
• Strong exposure on creating Jobs, Work Flows, Data Flows, ABAP Data Flows and Scripts using various Transforms and successfully loading data from multiple sources into a desired target.
• Experienced in SAP business Objects 4.x like Information Design Tool (IDT) and BI Launch Pad.
• Expertise in Universe creating using IDT, UDT. Used different data sources like Oracle, SQL Server, SAP BEx, SAP HANA, and SAP ECC.
• Good Exposure on Web Intelligence, Crystal report and Analysis for Office.
• Expert in using various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Experience using Tableau Desktop and Tableau Server.
• Developed data connections from various data source Tableau Desktop for reporting and dashboard development.
• Developed dashboards using charts box
• Created complex formulas and calculations within Tableau to meet the business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.

TECHINCAL SKILLS

• SAP HANA 1.0, SAP HANA2.0, SAP HANA Live, On-Premise VS Cloud
• SAP BW/4 HANA & SAP BW on HANA 7.5/7.4/7.32
• SAP BI/BW 7.4/7.3/7.0/3.5
• SAP Business Objects Data Services BODS 4.x
• SAP Business Objects BI 4.x & Design Studio
• Tableau 2018.1
• Lumira
• SQL Server 7.0, 2005, 2012, 2014
• Oracle 8i, 9i, 10g, 11g
• Operating System: Windows 10, 8, 7, XP, 98, 2000.
• Other Applications: Microsoft Office, Excel, Informatica 9.1, Software testing

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

SAP Native HANA and BW on HANA Senior Consultant

Environment: SAP HANA 1.0 SPS 12 / 2.0, SAP BW 7.5/7.4 on HANA, SLT, SDA, SAP BW/4 HANA, Oracle DB 12c, BOBJ, Tableau 2018.1, Anaplan.

Responsibilities:

• Responsible for multiple projects delivery within SAP HANA - Agile Scrum Development as SAP HANA Senior consultant for the following project
• GSA (Global Sales Analytics)
• Sales Booking
• Quote PVR (Price Variance)
• Product Consolidation
• Opportunity Pipeline
• Goals
• Forecast
• Involved in daily discussion with Solution Architect/Business team to understand the functional specs and create technical specs accordingly.
• Involved in Daily scrum Calls with the Scrum master to get the list of objects targeted for the upcoming release and worked with the offshore team to deliver them as planned.
• Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modeling.
• Creating information objects/Data models (packages, calculation views, Decision tables, Stored Procedures).
• Created HANA models using both physical tables and virtual tables.
• Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter and stored procedures upon the data models.
• Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to the business requirement.
• Created Calculated Measures and Restricted Measures in Aggregation node to serve different business requirements.
• Worked on performance tuning the HANA models using Explain plan and Visualize plan.
• Involved in design and development of Advanced DSOs and Composite providers.
• Worked on migrating the HANA objects from Development/Test environment to Production environment using Delivery Unit.
• Involved in Transportation support for moving Delivery Units (DU) from development/QA system to production system.
• Worked on publishing the data source in tableau after the security is applied to the HANA models.
• Once the data source is published in tableau checked the data consistency for the models in HANA and Tableau.
• Created complex calculations fields in tableau depending on the business requirement and used these fields in dashboards.
• Worked on creating Universe and exporting it to the semantic layer.
• Created filters, variables, prompts and calculations in the universe for KPIs.
• Data provisioning from SAP ECC system to HANA using SLT replication, to replicate tables from SQL server to HANA.
• Loaded data into table definitions, suspending data loads, resuming data loads using SLT Replication.

Confidential, Pasadena, CA

SAP Native HANA Developer & BW on HANA Senior Consultant

Environment: SAP HANA1.0 SPS 11, SAP BW 7.5/7.4 on HANA, SAP BW/4 HANA, BODS 4.x, BO-Analysis for Office, Tableau 10.x, SAP ECC 6.x/7.x, SAP UI/UI5.

Responsibilities:

• Responsible for multiple projects delivery within SAP HANA - Agile Analytics Service Line as SAP HANA Senior consultant for the following projects:
• Portals
• Supplier/Vendor Portal
• CCSA Portal
• GBS
• Order to Billing (OTC)
• Concur
• Expenses
• Understanding the functional specs and designing technical spec related to it.
• Creating information objects/Data models (packages, attribute views, analytic views, calculation views Graphical and SQL script based, Decision tables, Stored Procedures).
• Worked on Analytic privileges and assigning them to particular HANA models.
• Involved in working with Information model content like Input Parameters, variables, calculated columns, restricted columns and hierarchies.
• Worked on optimizing the information views for better performance.
• Created procedures and used them in table functions and calculation views.
• Developed reports using Complex SQL queries and Stored Procedures.
• Executed Data Extraction, Transformation and Loading (ETL) using SAP BODS 4.0 to import csv files into SAP HANA tables.
• Extracted the data through BODS from Oracle to HANA.
• Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into target database.
• Worked on transforms, Jobs, Workflows, Data flows, scripts etc. in Data Service to extract, cleanse and load into target Data Base.
• Imported data through flat files into SAP HANA and created schema and required tables.
• Used HANA Live and created copies of the Query views and modified them according the requirement.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Worked on Tableau report design and dashboard development.
• Worked on creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Exported the ad-hoc ready universes for making semantic layer available to the users.

Confidential

SAP Native HANA Developer and BW on HANA Consultant

Environment: SAP HANA 1.0, SAP BODS 4.x, SAP BW 7.4 on HANA, SAP ECC 6.0, SAP BI 4.x, PL/SQL & SAP ECC 6.x, Analysis for Office.

Responsibilities:

• Responsible for multiple projects delivery like GRC - Analytics, Duplicate Invoices within SAP HANA - Service Line as SAP HANA Senior Consultant.
• Worked in transforming Business Requirements into detailed Technical Specifications and Data Models related to the requirements.
• Involved in requirement gathering phase.
• Created multi-dimensional data models using Information models using HANA studio.
• Design and implement SAP HANA information models using Attribute Views, Analytic Views, Calculation Views, Stored Procedures, CE Functions and SQL script, carry out currency and UOM conversions.
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables and input parameters to satisfy reporting requirements using SAP HANA Studio.
• Created Analytic privileges based on dates and other complex filters using stored procedures as part of HANA security.
• Involved in design and development of Advanced DSOs and Composite providers.
• Involved in creation of Transformations and Data transfer process to load data from PSA to data targets.
• Optimized the information views using explain and visualize plan to reduce the time taken for reporting.
• Used SLT replication server to load real-time data form ECC to HANA.
• Loaded data from SQL server data base into HANA using SLT and BODS.
• Design and Development of Business Objects (BOBJ) Universes using Universe Designer Tool (UDT), which suits the standard, analytical and ad-hoc reporting requirements.
• Upgrading existing Universes to Business Objects 4.0.
• Involved in working on Public cloud and On Premise environments.

Confidential

SAP BW/BO & HANA Consultant

Environment: SAP BW 7.x, SAP BW on HANA, SAP HANA 1.x, SAP BI 4.x & SAP BODS 4.x & SAP ECC 5.x/6.x, SAP Lumira.

Responsibilities:

• Responsible for projects like SFDC and P&L as SAP HANA and BW Consultant.
• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Creating information objects/Data models (packages, attribute views, analytic views, calculation views Graphical and SQL script based, Decision tables, Stored Procedures).
• Involved in working with Information model content like Input Parameters, variables, calculated columns, restricted columns and hierarchies.
• Involved in design and development of info cubes, Data store objects and multi Providers and Info Sets.
• Involved in creation of Transformations and Data transfer process to load data from PSA to data targets.
• Worked on Enhancements (Data source enhancements and reporting).
• Involved in building Queries by using calculated and restricted key figures, Structures, Variables, Exceptions, Conditions, Cell Restrictions, RRI, Formula builder and Web Templates.
• Involved in transporting the BW objects from Development --> Quality --> Pre-Prod --> Production
• Involved in incident management team and resolve the tickets.
• Involved in Monitoring the Process Chains like daily, weekly and monthly loads.
• Monitoring of Process Chains and analyzing the reasons for frequent failures of Process Chains.
• Used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Collecting the load failure data and analyzing the load failures for frequency of load failures in loads and finding out permanent resolution.

Confidential

SAP BI Consultant

Environment: SAP BW 7.x & SAP ECC 5.x

Responsibilities:

• Involved in design and development of info cubes, Data store objects and multi Providers and Info Sets.
• Involved in creation of Transformations and Data transfer process to load data from PSA to data targets.
• Customized Data source, Info Cubes and Info Objects for accommodating the global data available across the organization. Used LO Cockpit, Generic, Flat File and DB extractions to retrieve SAP and Non-SAP data and company's legacy systems.
• Extended the BI content to add custom info objects. Modeled and created the end to end connectivity using Custom data sources, info sources and transformations which is a complete ETL.
• Worked on Data Load Performance Issues and Query Performance Issues.
• Involved in the Issues raised by the End-users.
• Involved in transporting BI Objects from Development System to Quality System and to Production.
• Developed Reports using BEx Analyzer/Browser, Workbooks to meet the business requirement.
• Performed filling up the aggregates to fill the summarized data from cubes to the aggregates, roll ups to fill the aggregates with the changed records and attribute change runs to realign the aggregates.
• Performed data load for transaction and master data using process chains and DTP/IP.

Confidential

BW Associate consultant

Environment: BI 7.0, BW 3.5, Oracle 8i.

Responsibilities:

• Daily monitoring of Process Chains and data Loads.
• Handling the issues on data loading, Extraction and end user issues on reporting.
• Worked on creating BI objects and Extractors.
• Worked on performance tuning techniques to Improve Report performance.
• Created Aggregates on frequently using characteristics like Material, Sold-to-party, fiscal year period, Business Area, Sales organization.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Used BEx to develop reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures.
• Resolved different priority Remedies assigned without missing SLA.