KRISHNA NETTEM

SAP HANA BW BO CONSULTANT

Email: adlmo1@r.postjobfree.com

Mobile No: +1-484-***-****

SUMMARY:

Having 13 years of Industry experience with 10 plus years of experience (both backend and frontend) in SAP HANA BI (Business Intelligence)/BW (Business Warehouse)/BODS worked with various teams as a part of involvement in Techno/Functional Implementation and Support engagements.

Diverse industry experience such as Cable, Retail, Healthcare, Consumer Goods and Communication.

Experienced in SDLC models like Waterfall, V2V and Agile scrum methodology which includes on time delivery, Quality process and documenting Functional & Technical Specifications.

Expert in document requirements for data flow, technical analysis, reports, metadata, training, service levels, data quality, performance, and troubleshooting.

SAP BI/BW 5 full lifecycles implementations in multi-industry global deployments of SAP BW 3.5, 7.0, 7.3 and 7.5 on HANA 1.0, 2.0 with BO 4.1 & 4.2, AO, Lumira 2.0 & 2.1 Design studio 1.4 & 1.6.

Expertise in designing Native HANA Information data models in HANA studio like attribute views, analytical views, calculation views, creating variables, Input Parameters, hierarchies, currency conversion, Analytical Privileges, Decision tables, SQL scripting stored procedures, Table Functions, Restricted Columns, Calculated Columns, Flow Graphs, OData Services, SDA Integration (SDI), Performance tuning of HANA models.

Tuned performance of SAP BODS Data flows by implementing degree of parallelization, database pushdown optimization, and target database table bulk loading.

Expertise in data modeling using DDF, Decision Tables, Table Functions, Sidecar scenario, CDC views, Attribute View, Analytic View and Calculation View & Universes.

Expertise in Analysis, Design, Development, Implementation, Deployment, and maintenance of Business Intelligence applications.

Strong experience in Native HANA Modeling, Performance Tuning.

Experienced in creating scripted calculation views with HANA Table Functions and Stored procedures SQL Scripts to extract data from Database.

Experienced in implementing full cycle Business Intelligence solutions including Business Blueprinting, Design, Development, Unit Testing, and Integration Testing, Training Documentation, and end user training & Run Support projects.

Worked extensively on various Businesses Functional Areas like Retail, Retail, TPM, SD, FSCM, FI, COPA, I&W, SRM, and SNC Modules related to SAP HANA BW/BI Reports implementation.

Expertise in SAP Business Objects enterprise products (Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence Reporting, Info-View / BI Launch Pad, CMC, Design Studio, Lumira, AFO)

Experience in SAP ABAP customizations for SAP BW Standard Data-Source enhancements, Function module based Generic DataSource developments for complex data extractions, routines, user exits, BADI and AMDP.

Designed and developed queries for reporting using BEx Analyzer, Query Designer, Web Application Designer, Report Designer, Web I and Universe (Business Objects), Analysis for office.

Designed and built multiple dashboards using Design Studio /Lumira & Tableau.

A highly motivated, energetic, and professional team leader with excellent analytical, problem solving skills and ability to interact with individuals at all levels.

TECHNICAL SKILLS

SAP Tools SAP BW 3.5, BW 7.0, 7.3, 7.4 & 7.5 SAP BO 3.1, 4.0, 4.1,4.2, AO, SAP ABAP, SAP HANA 1.0 & 2.0, Solution Manager SAP BODS, PAK, IP, Design studio 1.4 & 1.6, SAP BODS 4.0 (SAP BODS/BODI 4.0/3.2/3.1), Lumira 2.0 & 2.1 and Tableau 8.2, 9.0.

ERP Integration Retail, HCM, SD/FSCM/New FI-GL, AP, AR/CO/COPA/SRM & SNC modules

Reporting Tools BEX Query Designer, WAD, Analyzer, Webi, IDT, UDT, AO, Design Studio, LUMIRA, Tableau, Qlik View, Power BI.

Client: Juniper Duration: 08/2019 – Till Date

Project Name: RAR Implementation

Responsibilities:

Designed Composite providers by combining the existing ADSO and HANA Calculation views for complex reporting in BO Reports for document highly visualized comprehensive dashboards.

Create complex views and reports on Performance Obligations and Deferral Revenue.

Enhanced existing data flows with RAR configuration to reconcile with RAR Contract.

Created detailed reports on Analysis for office to show Revenue Waterfall reports and POB detailed reports

Designed Dashboards on BBS and RTR using different Views for Revenue & Taxation Team.

Developed complex CDS Views for Sales Achievement to show different customers in Transaction data.

Created data flows to extract hierarchy from BW using BODS for other ERP systems.

Enhanced Data Source using AMDP and Function Modules to extract new fields related to RAR.

Created POS - Channel Revenue Automation reports accounting associated with distribution channel stocking activity is processing all activity through the POS deferred revenue/COGS GL account

Project Name: Display Duration: 01/2019 – 08/2019

Responsibilities:

Involved in daily discussion with Solution Architect/Business team to understand the functional specs and create technical specs accordingly.

Performed data modelling and developed various HANA VDMs in supply chain solution.

Designed and created various complex Native HANA information (Attribute views, Calculations Views) models with both graphical and SQL scripting, restricted columns, calculated columns, input parameters, variables for Tableau and Power BI reporting and dash boards.

Worked on currency conversions, unit conversions.

Migrated Native HANA content from development, testing environment to Production environment using HALM (CTS Export), Solution Manager and delivery units.

Worked on Extracting flat files in Hana with Import options

Trouble shooted / analyzed technical problems in the existing HANA VDMs using Plan Viz., SQL Analyzer and performance optimized by redesigning the VDMs using best practices.

Worked on the Analytical Privileges and assigned it to users for restricting the VDMs and data access.

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.

Prioritize the work and deliverables according to specified timeframes.

Created Stored Procedures, Table Functions using SQL scripting.

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.

Imported data through flat files into SAP HANA and created schema and required tables.

Used SLT replication server to load real-time data form ECC to HANA.

Worked on Data Provisioning using Data Services (BODS) by designing and develop ETL in BODS, created new Data Services jobs to meet project requirements.

Monitored the BODS jobs and pushed the data into HANA system.

Creating Jobs, Workflows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into target database.

Executed Data Extraction, Transformation and Loading (ETL) using SAP BODS 4.0 to import csv files into SAP HANA tables.

Client: COMCAST Duration: 06/2017 – 12/2018

Project Name: HR Dashboard

Responsibilities:

Created SAP BODS ETL jobs to merge disparate data sets into a centralized EDW.

Created Global variables to read the files from the shared location from the BODS Designer.

Extensive experience in creating SAP Lumira stories using multiple data sets including HANA analytical views

Created HANA Studio (Modeler, ABAP, BW perspective, Administration Console), SQL Functions and SQLScript Language, BODS, DATA Transformation and linking with BI.

Utilized SAP Business Objects Mobile 4.1,4.2 to configure categories for WebI, Dashboards and Lumira visualizations for IPad & Android devices.

Implemented BI Applications/Dashboards and Visualization solutions utilizing SAP Design Studio, SAP Lumira (Discovery/Designer).

Extracted data from SQL server using Smart Data Access and BODS from success factor extraction.

Helped the End Customers in effectively utilizing the Tableau environment by revising their live data source dashboard to extract based dashboards which had higher volume and non-real-time reporting needs.

Build / Enhanced dashboards by applying different formats like Heat map, Tree map, Cloud, Charlie’s chart, Funnel charts, Geographic chart etc., for better representation of data sets.

Building complex ETL Dataflows/jobs in SAP Business Objects Data Services 4.x implementing Source/Target CDC and Extracting SAP standard business extractors from SAPERP systems.

Working closely with Business Analysts in designing prototypes for the Design Studio Dashboards & Lumira to showcase the power and functionality of Geo Mapping & Analytics

Created Customer exit variable, SQL SCRIPT Table functions, Decision Table, Calculation views, ABAP expert routines, BADI’s and AMDP Classes for different score cards using Dashboard.

Client: SAP Labs Duration: 02/2017 – 06/2017

Project Name: CAR FP01

Responsibilities:

Create Complex FOX planning functions for Reporting requirements and planning requirements.

Realize Merchandise Planning Layouts based on SAP BW-IP (Integrated Planning) Knowledge with Planning Application Kit (PAK) for BW on HANA, SQL Script for Planning.

Create User Friendly Planning workbooks based on SAP Business Objects Analysis.

Create Business blueprint documents and Realization of SAP BW IP and Retail Planning processes as below Merchandise OTB budget Planning.

Worked in configuration of IP planning application i.e. creation of Aggregation Levels, Filters, Planning functions, planning sequences and web templates

Perform feasibility analysis and create Planning objects based on the requirement.

Optimization of Planning Functions and Planning Sequences in SAP HANA using SAP Planning Application Kit (SAP PAK).

Implemented and developed Microsoft Power BI analytics, reports, dashboards, and data visualizations. Extract, transform and load the Data by using various transformations

Optimize the existing custom planning functions Fox code for better performance and creation of planning reports using Analysis Office (AO).

Developed various queries using Text, Formula and Customer-exit variables for BEx Query Designer.

Extracted the data through BODS from SuccessFactors to HANA.

Creation of Macros in AO as per the client requirement in Analysis Office.

Extensively worked on development of mappings and worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, Validation, Pivot Etc.

Project Name: Armstrong Duration: 10/2015 – 01/2017

Client: Henkel (Sun Products)

Responsibilities:

Designed Advanced DSO, Composite providers, calculation views- graphical and SQL scripted stored procedures and consumed those models into Bex Query designer, Analysis office and BO WebI.

Worked on Stored procedures to create Calculation views and imported BW providers into HANA enterprise.

Conducted Design Briefing sessions with Off-Shore teams and oversaw the Development / Testing /Deployment of HANA models, BODS Dataflow and BO Reporting

Converted the existing BW Info Cubes into HANA Optimized Info Cubes and moved the Info Cubes extended star schema into HANA Analytical views by importing in SAP HANAStudio.

Developed the test scenarios/cases, specifically for the treasury accounting & month-end close, conducted/sign-off the Integration test with business users.

Created the HANA Optimized DSO, Info Cubes and Composite providers and involved in Unit, Integration testing and UAT.

Designed the corporate Dashboards by using dashboard manager.

Designed and implemented the Claim Item Rejection and Communication process to the distributor.

Worked on APD’s to extract inventory data from reports to match with Open Sales orders.

Skills Used: Bex, SAP BODS 4.0 (SAP BODS/BODI 4.0/3.2/3.1), Rally, Oracle 10.3.0, Windows, SAP ABAP, Tableau 9.0, SAP APO, SAP BW 3.5, 7.3, 7.4, SAP BO 4.2, BODS 4.2, Vistex, Qlik Sense 0.96/1.1/2.0/2.1, Qlik View 10/11, Power BI, Nielsen, SAP BW, SQL Server, Tera Data, SAP, Excel, CSV files, SAP HANA, SAP HCM, SAP ECC, SAP BO 4.2, Design Studio 1.4/1.6, Lumira 2.0/2.1

Project Name: ONE BI / VIPP LI Duration: 06/2010 – 10/2015

Title: Senior Consultant

Responsibilities:

Created Exported data to application server using Open hub.

Captured requirements, modeled, built, tested, implemented, and supported back-end SAP BW / ETL data flows to extract data from SAP ECC, SRM, and SCN systems to provide data to SAP analytical reports for Business Transformation project.

Enhanced the Data Source for adding new fields, according to requirement through Exit CMOD.

Created Transient providers and ADSOs depending upon the Reporting requirement.

Exploited all the advantages of LO Cockpit. (Delta, adding custom fields to Data source and used inversion, hide fields, selection fields.

Understanding and writing the Performance testing scenario documents.

Testing the system with high volume data and provide the performance numbers.

Created HANA Modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Worked on different variables type hierarchy node and Authorization Variables.

Developed Daily Flow which includes Info cube, DSO DTP, Transformation, IP, Remote Cube Creation and customizing, replicating Data source and Process Chain.

Worked on hierarchy node & Authorization Variables.

Created Composite providers with HANA published information models like calculation views and analytical views.

Worked on Integrated Planning for sales reports.

Worked change request and involved in the testing the developments in quality before go live.

Involved in Unit, Integration testing and UAT.

Used generic extraction (RSO2) to extract data from SAP ECC to BW.

Worked on Integrated Planning for sales reports.

Worked in Agile procedure for implementing & requirement gathering.

Maintaining customized tables in BI and APO systems.

Involvement in various APO settings as part of new plant addition.

Client: T-Mobile Duration: 02/2010 – 06/2010

Project Name: T-Mobile BW Migration

Title: Associate Consultant

Responsibilities:

Worked on Data flow migration. Involved in issues solving different issues in transformation like Start routine, return tables, formulas.

Involved in mapping of Info-source with the Data targets using transformations for master data lookup.

Involved in developing different type of DTP like Standard, Direct Access, and Error DTP.

As part of migration created new roles for publishing newly created Queries and Workbooks.

Worked on process chain changing as part of migration.

Expertise in solving issues related to Workbooks and Queries.

As part of front-end migration solved many issues related to formatting & Display.

Involved in designing the BEx workbooks by using the new design tools (Analysis Grid, Navigation Pane, Exceptions, Conditions, Command Buttons, Charts).

Involved in preparing Technical specs BEx Reports and BEx Analyzer.

Migrating/installing the Data-sources as per the migration planning with in scheduled down time.

Extracting Master & Transaction Data using Generic Data Sources from OLTP.

Contact this candidate