Candidates About

 

Kishor Panikar

SAP BW/BOBJ HANA Architect 

SAP Certified Solution Consultant SAP NW04 - BI                                                                           

SAP Certified mySAP.com (BW) Professional

 

Summary  

§  Total 19 yrs SAP experience with 2+ yrs in SAP R/3 Abap/4 development and 17 yrs in SAP BW/BI. 17 yrs of experience as Techno functional consultant in implementing SAP HANA, SAP BW ( BW 7.5,7.4,7.3, BI 7.0, BW 3.5), SAP BPC, SAP ABAP/4, SAP BOBJ, SAP BO (4.1, 4.0, XI3.1),  SAP BODS, HANA Live, SAP ECC and SAP Lumira projects.

§  Modeled different solutions based on side-car HANA approach, BW on HANA and native Hana Models including data provisioning using DXC, SLT and BODS.

§  Worked on SAP Native HANA, HANA (side-car scenario) & BW on HANA. Worked on design and development of BW on S/4 HANA (Month-end & Historical Data) S/4 HANA Modelling Good understanding of all aspects of integration with SLT and BO Data Services 4.0. Good knowledge on HANA Attribute, Analytical and Calculation View. Knowledge of HANA scripting and ability to merge both SAP and Non-SAP Data. 

§  Worked 6 full life cycle BW/BI implementations.

§  Experienced Sr.SAP BI Consultant & Architect who has successfully led project teams from 4- 15 resources from requirements gathering through to implementation and support. Lead and worked with teams on an Onsite-Offshore model.

§  Worked on SolMan 7.1 (Solution Manager) and ChaRM (Change Request Management) for all the CTS (Change & Transport systems) to move objects within environment.

§  Worked on integration between SAP Fiori/UI5 and SAP BI Business Objects and SAP Fiori/UI5 & NetWeaver Gateway Expertise.

§  Fiori/UI5 expertise: ECC HCM Apps, Logistics & MM Apps, System Landscape, Architecture, SSO, Security Set Up, Gateway configuration. Fiori Package Configuration on SAP Gateway & Backend ECC App Configuration   

§  Worked on 7 BI 7.0 Upgrade Technical and Functional Upgrade projects upgrading BW2.1C to BW 3.0(at Pratt and Whitney),2.1c to 3.5(SAP NetWeaver ‘04) (at Avid Technologies) and BW 3.1c to BI 7.0(SAP Netweaver 2004s R1 SP8 at IBM) and BW 3.1 to BI 7.0 NW2004s.

§  Extensively worked in SAP BW-CRM and reporting, data warehouse data analysis

§  SAP BW/BI: Expertise in DataModelling creating infoproviders, DSO(ODS), Multiproviders and Infosets. Extraction from COPA, FI, SD, MM, APO(SCM), SRM, CRM and FI-SL modules. Experience with Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP data extraction, loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.

§  BEx -Reporting - Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items and Web Reports. Also experience using Report Painter in R/3 creating sever FI/CO reports.

§  Training: Conducted training sessions for end-users for BOBJ WeBi (Web Intelligence) & BW reporting. Also, created training manuals for the super users and end-users.

§  Technical Proficiencies: SAP R/3 version 3.x/4.x, ECC 5.0/6.0, SEM 3.5/4.0, Netweaver 2004s, BW3.x, BI 7.0, BI 7.1, BW 7.3, BW 7.4 SAP HANA 1.0, BPS, IP, FI/CO (GL, AR, AP, AA, COPA, CCA, PCA, COPC) Oracle, ABAP/4, Windows 2000/NT/ME/98, UNIX, Linux, Microsoft Project Management tools, MS Word/ Excel/ PowerPoint.

§  Key Strengths: Highly focused and goal oriented with dynamic leadership and team-building abilities. Energetic and creative with a special talent for troubleshooting and resolving complex

technical problems and escalated issues. Exceptional organizational and analytical skills. Proven leadership attitude and Strong negotiation skills.

 

Education & Certifications

Bachelors in Engineering.

Certified in SAP BW 3.0B by SAP America.

 

Professional Experience

 

Industry: Building Materials,

Client: Pacific Coast Companies. Sacramento, CA

Jan ’17 till date

SAP BW/BOBJ HANA Architect

Environment: SAP R/3 ECC 6.0, SAP HANA1.0, Salesforce.com, SCM 7.0, BI 7.4, BI 4.0, BI 4.1, Analysis for Office, BODS, BO Design Studio 1.5.

 

·         Worked closely with stakeholders & users in the gathering and validation of requirements and ensuring that delivered solutions meet and exceed stakeholder expectations.

·         User requirement analysis and development for COPA, Logistics and FI reports and created LSA ++ dataflow. Responsible for analyzing the requirements and identifying the gaps.

• Involved in ETL Based replication to provision the data from ECC to HANA system through BODS
• Involved in providing solutions to the complex requirements using BW 7.3 Infoproviders (Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) for HANA Models and resolved HANA error’s like data type mismatch, numeric overflow, etc.
• Involved in identifying the area to improve the performance by utilization of HANA In-Memory computing feature, Column store, Calc Engine features.
• Involved in Optimizing the Design of the data flows in BW, HANA for the requirements.
• Involved in Planning of data load activities runbook preparation. Created  SQL, SQL Script, CE Functions.

·         Worked on Users requirement for development of BOBJ WebI (Web Intelligence & also Analysis for Office) reports and Variants for SAP as well as Non-SAP data sources.

·                     Collaborate with onsite/offshore team with respect to all ongoing customer deliverables.

·         Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical issues.

·         Evaluating existing standards and processes and recommending and implementing new standards and processes on a proactive basis.

·         Involved in building a set of Webi pricing reports and Dashboards for Management and Pricing team to do what if Analysis scenarios in Product Pricing.

 

Industry: Packaging & Container

Client: Dart Container Corp. Mason, MI

June ’15 – Dec ‘16

SAP BW/BOBJ, BW on HANA Architect

Environment: SAP R/3 ECC 6.0, SCM 7.0, SAP HANA 1.0, BI 7.3, BI 4.0, BI 4.1, SAP Fiori/UI5, Analytics for Office, Lumira, BO Design Studio 1.5.

 

HANA Phase I:

Included creation of Financial Close models from SAP and non-SAP data to create BOBJ reports using WEBI and Analysis for office. There was Real Time Data Provisioning via SLT from ECC to HANA and from ORACLE to HANA. Another component was to send GL summary data from HANA models to an external CPM system via Data Services. This was to achieve a 360 degree reporting.

 

HANA Phase II :

 

·         SAP BW upgrade and BW on HANA Migration 

·         Defined design standards and best practices of building models over HANA.

·         Successfully migrated 56 TB Oracle system to HANA using downtime-minimized approach.

·         Primary liaison with SAP during ramp-up, responsible for all OSS communications and resolutions. Involved in Pre and Post migration tasks for DMO. Performed pre-validation steps.

·         BW to HANA migration Readiness Check.

·         Checks of ETL ABAP code and fixed outstanding issues in all environments.

·         Gathered benchmark performance statistics for load and activations.

·         Performed pre-activity steps in all environments and Involved in HANA sizing.

• Assessment of current BW environment and provided over all environment and functional area specific data flow optimization guidelines.

·         Responsible for architecture, preparing system for BW on HANA upgrade including system prep and cleanup activities.

·         Involved in preparing the BW environment for Pre & Post Migration steps to HANA.

·         Conversion to SAP HANA-optimized DSOs and cubes (In memory cubes) after system migration. Migrated existing info providers to HANA optimized providers.

·         Involved in architect, design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), HANA Security, data provisioning thru SLT, Import, export and migration.

·         Assists in all phases of implementations as needed including analysis, migration, testing, and training/knowledge transfer to end-users, go-live assistance, and post implementation support.

·         Included a mix mode SAP HANA and SAP BW on HANA approach where there were standalone HANA models, HANA models exposed as Virtual Providers in SAP BW and finally classical BW on HANA models. The latter made use of in Memory Optimized DSOs exposed thru Multi-Providers and BEX Queries and use of in-memory optimized cubes when aggregating data with different granularity

·         Performance Optimization techniques, HANA Stored Procedure calls by Data Services

·         Developed HANA models and BODS flows for Phase II and Phase III.

·         Reports Developed in this Project :Customer Black log Summary  Report, Customer Touches , Billing Summary, Opportunity Summary , Sales summary, New Customer Mix / Growth, Expense Reports for QTD and YTD, P&L analytics on monthly, quarterly, year to date basis.

 

Industry: Consumer Goods

Client: Blount International Inc. Portland, OR

Feb ’15– May’ 15

SAP BW/BOBJ,BW on HANA Architect

Environment: SAP R/3 ECC 6.0, SAP CRM 7.0, SCM 7.0, BI 7.0, BI 7.3, HANA1.0, S/4 HANA, BI 4.0, BO Design Studio

 

• Phase 1 - Worked on BW BOBJ development specifically with Dashboard Reporting using the new BOBJ Design Studio, worked on and developed BOBJ Webi reports against SAP BW BeX queries.
• Gathering and analyzing dashboard requirements and development of Design Studio Dashboards based upon BW BeX queries as datasources. 
• Analysis of existing CRM reports on legacy systems and migrate/convert/recreate in the new Webi BOBJ environment. Participate in discussions to validate captured dashboard & BOBJ Webi requirements and develop functional/technical designs.

·         Phase 2 – Worked on the HANA and BW on HANA mixed models using Virtual providers.

·         Moved SAP BW specific models to a Hybrid BW on HANA.

·         Developed custom ABAP SLT for prepopulating data for performance optimization

·         Found workarounds to multiple Problems/Issues.

·                     Defined design standards and best practices for scalable and sustainable development.

·         Worked with IT leadership in defining the key success factors, scope & expectations, risk mitigation, cost-benefit and outlining roadmap to better leverage primary and secondary benefits.

·                     Actively collaborated with Basis, OS/DB teams in resolving migration and performance issues

·         Designed and developed Financial reports (Consolidated balance sheet Analysis, Consolidated income statement report, Monthly Comparison Balance sheet and Income statement Analysis, Expense Reports for QTD and YTD)

 

Industry: Chemicals.

Client: Chemtura Corp. Middlebury, CT

April ’14– Jan ‘15

SAP BI, BOBJ & HANA Architect

Environment: SAP R/3 ECC 6.0, Salesforce.com, SCM 7.0, HANA Live, SAP HANA 1.0 SP7, BI 7.0, BI 7.3, BOBJ 3.1, BI 4.1

 

·          SAP BW on HANA platform - Managed System Landscape preparation with Basis team.

·          SAP BW Technical upgrade: Conversion of data flows, datasources, queries, workbooks and security   objects from version 3.x to 7.x in BW DEV system and transported all through the landscape to BW Production environment.

·          SAP BW authorizations migration from 3.x to Analysis Authorizations.

·          Process Chains migration to include DTP flows.

·          Testing and validation of 7.x objects.

·          Process Chain monitoring and bug fixes after upgrade to 7.x.

·          Integration testing with SAP BO and Portal.

·          Plan and execute HANA pre-migration activities.

·          Collected statistics from Data loads and Reports Execution timings before migration to HANA.

·          Supported migration to SAP HANA via DMO option – SAP Notes implementation.

·          Plan and execute HANA post-migration activities.

·          Hierarchy objects dataflow/datasource migration from version 3x to 7x.

·          System Validation and Testing after migration.

·          Integration testing with SAP BO and portal after migration to HANA.

·          ABAP code upgrade after migration.

·          Experience in calculating Virtual characteristic using BADI

·          ABAP Routines optimization.

·          Data Cloning

·          Performance analysis by comparing pre and post migration runs time and presented to management.

·          System Cleanup : Deletion of unused objects from the BW DEV system and transported through the landscape.

·          Universe Layer removal : Replacement of SAP BO Web Intelligence reports created on top of BO Universes by creating Bex queries and consuming them to SAP BO Web Intelligence via BICS connection.  This empowers webi reports with SAP HANA in-memory database.

·          Final validations and system health check.

·          Go-Live : BW-HANA migration.

·          Analyzed and presented SAP BW Data Model re-architecture as per LSA++ concepts to leverage SAP HANA as the In-memory database.

 

Industry: Construction Equipment Mfrs.

Client: HILTI Corp. Tulsa, OK                                                                                                                       

Jan ’14 – April’14

SAP BI/BOBJ & HANA Architect

Environment: SAP R/3 ECC 6.0, SAP HANA 1.0 SP5, BI 7.3, BI 4.0

 

• Responsible for the design, performance and operations of the HANA Analytics environment.
• Worked on managing the project for upgrading SAP HANA from HANA 1.0 to 1.4 and upgrading of the Service packs.

·         Worked with SAP HANA Security team on managing schemas, data model objects, import/export content and SAP HANA Security including User Management, Roles, and Privilege.

·         Have good knowledge on SAP HANA modeling, Data Provision, Partitioning, Security and Reporting.

·         Involved in configuration of SLT Server, monitoring the data loads form ECC to SAP HANA DB

• Loaded ECC tables into target schema tables using SLT based table Data Provisioning and performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning.

·         Created Packages, Attribute Views, Analytical Views, Calculation Views, and modified the system generated joins

·         To validate SAP HANA Solution on various technical & business parameters including query performance, data compression, analytics on Business Objects reporting tools.

·         Created and managed Delivery Units to move across different environments

·         Configured/created ODBO connections (MS Excel) and JDBC connections (SAP Business Objects BI 4.0) for accessing the information models from SAP HANA for Analysis for Office (A-Office) reporting purpose.

Existing report on Accounts Payable takes close to 2 hrs to execute and save the report on the disk, due to an enormous data volume.

Validated SAP HANA Solution on various technical & business parameters including query performance, data compression, analytics on Business Objects reporting tools.

Business Scenario

·         Analyses of a critical ECC Finance report based on multiple tables.

·         Analyze the KPI’s of Debit and Credit.

·         Existing report takes close to 2 hours to execute (ABAP code logic ~3000 lines).

·         Data summarized at the Cost centre level.

·         Data detailed at General Ledger Line item level.

·         Base tables contain over 100 million records.

Solution Overview

·         Blueprint document preparation.

·         Replication of base tables in SAP HANA and data modeling, including cluster table.

·         Use of Analytical views/ Calculations views for performing look-ups.

·         Write SQL scripts, CE coding.

·         Summary report created in BO Explorer.

·         Detailed report in MS-Excel.

HANA Modelling

• Used SAP HANA Modelling to analyze a large volume of complex data to gain business insights into customer spending patterns, and to develop new market offers to expand existing customer base and in turn generating more revenue for the company.

·         Worked on Modelling approaches – using the Graphical Modeler where no SQL or SQL script knowledge required, Built-in Union, Join, Projection & Aggregation nodes provided, I used the (Script-Based Editor)

·         Created Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios

Key Success factors

·                     Execute the report ad-hoc at any time and for any period.

·                     Execution time reduced to a few minutes.

·                     Drill-down enabled reports.

·                     Access the information on mobile devices.

 

Industry: Financial Services.

Client: BB&T Bank. Greensboro, NC

Oct ‘13 – Jan ‘14

Sr. SAP HANA BOBJ Architect (ECC on HANA side CAR)

Environment: SAP R/3 ECC 6.0, BW 7.3 SP5, SAP HANA SP6 REV 61, SAP BOBJ 4.0 SP5

 

·         Worked on HANA side car implementation for FI module.

·         Architectured the strategy for implementing the SAP BOBJ tools –WEBI , Office Analysis,Design Studio

·         Worked with SAP BW (on HANA) integration with Design Studio.

·         Worked on SAP  BODS to load data from non-SAP into SAP HANA

·         Worked with several ETL features of BODS to accommodate the business requirements

·         Activated the standard Technical content and maintained Process Chains for statistics

·         Worked on product support for daily loads and query performance issues

·         Built  Financial consolidated, Unconsolidated reports  Interactive Analysis reports

using various features like variables,formulas,Hyperlinks,Multiple datasources in WEBI

·         Works on assignments in resolving problems and making choices, recommendations & decisions.

 

Industry: Consulting Services

Attune Consulting

June ‘13 – Sept ‘13

Sr. SAP BW/BOBJ Consultant

Environment: SAP R/3 ECC 6.0, IS-U –Retail, POSDM, BI 7.3, Business Objects 4.0

 

·          SAP BW-Retail development for Attune’s Retail client – Columbia Sports. Responsible for the Support, design, performance and operations of the BW Analysis & Reporting Business Intelligence (BI) environment.

·          Work & support extensively on all the BW SAP Retail areas POS Data Management, Merchandise Management, Merchandise & Assortment Planning (MAP), Store Controlling & Point of Sale (POS) for Attune’s retail client’s BW implementations.

·          Published Reports to BO 4.0 CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats. Created business users, folders and granted security access to the reports using CMC.

·          Performed data validation and testing KPIs on new reports. Resolved loops by creating aliases and contexts.

• Worked on developing & support the custom BW objects using BW LSA (Layered Scalable Architecture).

 

Industry: Paint & Chemical Manufacturing.

Client: RustOleum. Vernon Hills, IL

March ‘13 – June ‘13

SAP BW Lead Consultant                                                                                                                        

Environment: SAP R/3 ECC 6.0, BW 3.5, BI 7.3, Business Objects 4.0

·          Responsible for the design, performance and operations of the Manufacturing (Production Planning) Reporting & Analysis using SAP Business Intelligence (BI) environment.

·          Worked extensively on standard & enhanced the standard BW extractors for Production Planning - Material view from PP/PP-PI -2LIS_04_P_MATNR, Component View from PP-PP/PI - 2LIS_04_P_COMP extractor, Repetitive Manufacturing Material-2LIS_04_PEMATNR.

• Ensure the design, creation and sourcing of data for InfoProviders and InfoObjects (InfoCubes, DSO, Infosets & Multiproviders) to satisfy Reporting requirements.
• Develop and modify the Manufacturing Reporting & Analysis BI reports using WebI (Web Intelligence).
• Maintain and develop SAP ETL and BeX queries against SAP OLAP cubes (Infocube)
• Maintain and modify BW Queries & Cubes using BICS from BW to BOBJ.

 

Industry: Food Production.

Client: Dawn Foods Inc. Jackson, MI

SAP BW & SAP BW BOBJ Architect

June 12 –March 13

Environment: SAP R/3 ECC 6.0, BI 7.3, HCM, QlikView, Informatica, Or