SUMMARY

• Expertise in Data Provisioning tools like SLT Replication Server, Business Objects Data Services.
• Worked on loading data from ECC to HANA database using different transformations such as query, row generation, merge, pivot, lookup, table comparison etc. with Business Objects Data Services (BODS).
• Created global variables, parameters, custom functions and built - in functions to use them in query transform in BODS.
• Created Entity Relationship (ER) Diagrams and Data Mapping and worked on Normalized and De-normalized data.
• Worked extensively on Data Profiling, Data Integration and Data Quality in BODS.
• Worked on ABAP Include programs while creating transformations in SLT Replication Server.
• Created ABAP programs to make changes to data in ECC systems before loading to SAP HANA data base.
• Well versed with importing Meta data, initial load and replication of data in HANA Studio.
• Hands On experience in creation and maintenance of schemas, table definitions and tables imported to SAP HANA and loading flat file data to HANA directly.
• Hands on experience in SAP HANA Modeling using Attribute Views, Analytic Views, Calculation Views, Decision Tables, Stored Procedures and Table Functions.
• Well Versed with Parameters, Variables, Hierarchies, Advanced Properties and Performance analysis of the HANA Models.
• Expertise in SQL script (DDl &DML), Optimizing SQL Queries and Performance tuning.
• Created time based view for different granularities (day, month, quarter and year) and used them in analytic and calculation views.
• Created complex Calculation Views with Calculated columns (calculating running totals, Cumulative sum, finding missing values, sorting based on ranking etc.)
• Hands on experience in creating and maintaining Users and Roles and Analytic privileges for different roles (security).
• Developed customized Calculation Views for real time reports using SAP HANA Live content (i.e. The Virtual Data models) or developing from scratch.
• Worked on optimizing the information views for better performance.
• Expertise in the data flows and tables of the functional modules like SD, MM & FI.
• Worked on FI reports like AR, AP and GL.
• Good Knowledge on Smart Data Access (SDA), Smart Data Integration (SDI) and Smart Data Quality (SDQ).
• Well versed with Advanced Function Libraries (AFL) i.e., Business Function Libraries (BFL) and Predictive Analysis Libraries (PAL).
• Good Knowledge on Designing and Implementation of HANA Solutions.
• Well versed with SAP HANA EIM Services.
• Good Knowledge in SAP HANA Administration and Management of HANA Data Models.
• Good knowledge on creating Remote Data Sources to access the data from those sources via Smart Data Access by creating Virtual Data Tables and Dynamic Tiering.
• Experienced in SAP business Objects 4.x like Information Design Tool (IDT) and BI Launch Pad.
• Created semantic layer using IDT and published them for further use in reporting tools.
• Created BO Reports on top on BEx Queries using Business Intelligence Consumer Services (BICS) Connection.
• Created queries as per the reporting requirements using Web Intelligence tool for creating interactive reports.
• Created reports using Crystal Reports and live office.
• Worked on building engaging analytics using business KPI’s in Design Studio and Dashboards.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimension, Measure variables etc. to show accurate Results.
• Created various simple and complex reports using drill down, filters and alerts using Data Visualization tools.
• Created, managed & formatted standard, master/detail reports with Crosstabs and Vertical/ Horizontal Tables.
• Good knowledge on Lumira, Explorer, Analysis Office and Analysis OLAP.
• Extensively worked on creating and customizing ODS, Info Objects, DSOs, Info Cubes, Transformations, Multi providers, Info sets, Data Marts, Hybrid, 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, LISand non R/3 extraction)
• Performance (Aggregates, BW Stats, Partitioning), Production Support (Process Chains, info packagegroups)Front end Business Warehouse Components, Queries, KPIs, Calculated key Figures, restricted key Figures, Structures, Variables, RRI(Report to Report Interface).
• Worked on functional upgrade/Migration of BW 3.5 data flow to BW 7.0.
• Data extraction from BW content extractors and customer generated extractors, cross application specific extractors (generic extractors) and flat file.
• Maintenance & enhancements of data sources at SAP OLTP source system.
• Performance tuning, End to End BW Configurationsand Customizations from Extraction, Staging, Loading and Transport.
• Developed reports in front-end involving Calculated Key Figures, Restricted Key Figures, KPI’s, Structures, Variables, Conditions, Exceptions, Cell Editor and Formulas.
• Had created customized Workbooks.
• Had created web reports using Web Application Designer formatted reports using report designer.
• Had worked on Information Broadcasting for distribution of BI Data through different channels and in different formats.
• Had worked on integration of BW Reports to Enterprise Portal.

TECHNICAL SKILLS

HANA: 1.0 SPS 06 to SPS 11

SAP Business: Objects Data Services 3.2, 4.1, 4.2

SAP Landscape: Transformation Replication

SAP: Net weaver 7.0 and 7.1 ECC 6.0/ERP 6.0SAP BOBI 4.x

Information Design Tool: Business Explorer Query Designer and Analyzer

Crystal Reports: Web Intelligence, Dashboards

Design Studio: Explorer, Lumira, Analysis Office, Analysis OLAP

Tableau: 10.0SAP Business Warehouse BW 3.5, BI 7.0, BW 7.3, BW 7.4, BW 7.5

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, Pasadena, CA

SAP Native HANA Consultant

Environment: SAP HANA 1.0 SPS 09/11, SLT, SAP BODS 4.2(Business Objects Data services ETL Tool), SAP ECC 6.0, SAP SD, FI, SAP BOBI 4.x, Information Design Tool, Crystal Reports, Web Intelligence, Design Studio, SQL Server 2012, Oracle 10g and MS Office.

Responsibilities:

• Data provisioning fromSAPECC system toHANAusing SLT replication, Batch job In BODS 4.0 to replicate tables from SQL server toHANA.
• Executed Data Extraction, Transformation and Loading (ETL) usingSAPBODS 4.0 to import csv files intoSAPHANAtables.
• Worked extensively on data profiling, Data integration and data quality in SAP BODS.
• Created Entity Relationship (ER) diagrams and data map and worked on normalized and de-normalized data.
• Created ABAP include programs with IF-ELSE conditions and other data modifications like concatenate to columns or changing data types to match HANA data base, while loading data from ECC to HANA with SLT replication.
• Imported data through flat files intoSAPHANAand created schema and required tables.
• Created virtual tables in HANA Schemas by using Smart Data Access (SDA), remote data source creation.
• Used these virtual tables for creating Information views in HANA.
• Loaded data into table definitions, suspending data loads, resuming data loads using SLT Replication
• Creating information objects/Data models (packages, attribute views, analytic views, calculation views Graphical and SQL script based, Decision tables, Stored Procedures).
• 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.
• Involved in working with Information model content like parameters, variables, calculated attributes, restricted attributes and hierarchies.
• Developed reports using Complex SQL queries and Stored Procedures.
• Created SQL views as per requirement.
• Used HANA Live and created copies of the Query views and modified them according the requirement.
• MigratedHANAcontent from development, testing environment to Production environment using delivery units.
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Used Information design tool to create data foundations, Business Layer and publish connections and layers to theSAPBO repository.
• Involved in documenting the changes to the universe and reports functionality.
• Designed and developed Crystal Reports such as Parameterized Reports, Cross tab Reports based on base tables, views, involving Formulas, Sub Totals, Running Totals, and Sub Reports.
• Developed various types of Charts and Graphs like Bar Chart (Side by Side, Stacked), Line Graphs, Pie Charts, etc. by using Chart expert of Crystal Reports and Web intelligence.
• Designed Crystal reports for daily and monthly reports.

Confidential, Canton, MI

SAP Native HANA Consultant

Environment: SAP HANA 1.0 SPS 07, SLT, SAP BODS 4.1 (Business Objects Data services ETL Tool), SAP ECC 6.0, SAP SD, MM, FI, BOBI 4.0, crystal reports, Web intelligence, SQL Server 2012, Oracle 9i and MS Office.

Responsibilities

• Loaded data from ECC to HANA Data base using different transformations with Data Services.
• Imported table Meta data and data using HANA studio.
• Created ABAP programs to modify and filter the data while loading it to HANA data base via SAP landscape replication.
• 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.
• Created virtual tables in HANA Schemas by using Smart Data Access (SDA), remote data source creation.
• Used these virtual tables for creating Information views in HANA.
• Worked in transforming Business Requirements into detailed Technical Specifications and Data Models related to the requirements.
• Created multi-dimensional data models using Information models using HANA studio.
• Design and implementSAPHANAinfo 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 usingSAPHANAStudio.
• Used HANA Live and created copies of the Query views and modified them according the requirement.
• Created Analytic privileges based on dates and other complex filters using stored procedures as part of HANA security.
• Optimized the information views using explain and visualize plan to reduce the time taken for reporting.
• Design and Development of Business Objects 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 information gathering phase.

Confidential, Farmington hills, MI

SAP BW/BO & HANA Consultant

Environment: SAP HANA 1.0 SPS 07, SAP NetWeaver 7.1, SAP ECC 6.0, BI 7.0, BW 7.3 on RDBMS, BW 7.3 on HANA, SLT, SAP SD, MM, BOBJ 4.0, BEx Query Designer, SQL Server 2008 and MS Office.

Responsibilities

• Worked Extensively on Data Warehouse Workbench and customized Info Objects, Info Cubes, DSOs, Data sources and Multi Providers.
• Implemented SD Extraction from ECC using BW ETL process.
• Set up periodic Data loads from legacy system.
• Installing and creating BI/BW object Data models like info objects, DSOs and Info cubes.
• Creating and managing dataflow using Data Transfer Process (DTP), transformations and info packages.
• Involved with performance tuning of queries by compression and repartitioning of info cubes.
• Created aggregates for info cubes to improve query performance.
• Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from SAP ECC to SAP BI/BW.
• Created custom info objects, DSO, DTPs and info cubes on sales data.
• Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.
• Involved in the Transportation of BI/BW objects from Development to Quality and Production.
• Worked extensively on BEx Query Designer and Developed flexible queries using navigational attributes in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Imported table Meta data and data using HANA studio.
• Created ABAP include programs while loading data from ECC to HANA using SLT replication.
• Used SLT replication server to load real-time data form ECC to HANA.
• Created virtual tables in HANA Schemas by using Smart Data Access (SDA), remote data source creation.
• Created multi-dimensional data models using Information models using HANA studio.
• Design and implementSAPHANAinfo 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 usingSAPHANAStudio.

Confidential, Irving, TX

SAP BI Consultant

Environment: Sap NetWeaver 7.0, BI 7.0, BW 3.5, SAP ECC 6.0, SAP SD, BOXI 3.1, BEx Query Designer 3.5, SQL Server 2005, Oracle 8i.

Responsibilities

• 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.
• Activating and filling the Aggregates for better Performance.
• Developed BEx reports on Delivery, Billing, Inventory, Account Receivable.
• 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 flexible and direct update to load transaction and master data.

Confidential, Indianapolis, IN

SAP BI Consultant

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

Responsibilities

• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Working on process chains to automate the Deleting indexes in Info cubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involved in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Enhancing the existing reports as per the new requirement.
• Monitoring the daily loads to various data targets in the system.
• Monitoring the process chains on daily, weekly and monthly basis.
• Manual loading and rolling up the data into data targets.
• Maintaining the logs for each manual load.
• Creating aggregates to improve the query response.
• Performance tuning of queries using aggregates and indexing of Info cubes.