sap bi bw bo

ARUN KANCHA

Profile

A multi-faceted SAP Consultant over 10 years of techno-functional expertise in SAP with specialization in SAP NetWeaver BI / BW and BO Tools such as Webi, Dashboard designer, Crystal Reports, Data Services and SAP R/3.

SAP Certified BI/BW Professional

SAP Certified BO Professional

SAP Certified HANA Professional

Experienced in migration projects from BW 3.5 to 7X and 7.x to 7.4 with HANA.

Experienced in migration projects from PeopleSoft and Informatica.

Experienced in integration BO tools such as Data services, Webi, Crystal reports, Dashboard designer, Lumira with the existing BW landscape to deliver enterprise reporting solutions and SAP Business Objects Mobile.

Worked on Power designer for modelling.

Responsible for delivering multiple projects with budget ranging from 1 million to 5 million for different work streams such as OTC, PTP and FI etc.

Responsible for conducting BI Best Practices for Data Migration and Data quality.

Technical

Strong in all aspects of BI: BI data modeling, data staging and Activating & Enhancing standard Business Content, scheduling and process chains Partitioning & Compression, OLAP Cache, secondary Indices, Pre-calculations etc.

Upgrade Experience in SAP BW from 3.5 to BI 7.x and in depth knowledge of migrating data sources from BW 3.5 to BI 7.x and maintaining Transformations and DTPs.

Experience in migrating from different sources such as PeopleSoft and Informatica.

Proficient in Data Extraction from SAP R/3 (FI/CO, MM, SD, PM and QM), OTC, P2P, flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors.

Expertise in the front end business warehouse components like BEx analyzer, Query designer, Web Application Designer, Web Reports, WEBI, DashBoard Designer, Advanced Analysis for Office and Advanced Analysis for OLAP .

Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.

Experience in developing data models in HANA SP9, Created multiple schemas and table definitions and analytic views.

Expertise in HANA Modeling, Hadoop technologies and BusinessObjects report development.

Extensively used Calculations, Variables, Prompts, Sorted inputs, Drill down, slice and Dice, Alerts for creating Business objects reports.

Good exposure and knowledge of SAP modules such as FICO, CRM, HR, MM, PP, SD, IS-Retail, AFS.

Excellent in creating WEBI reports and Crystal reports and deploying them through Info view with BW universe as source and creating Inventory accuracy dash boards using Xcelsius.

Expertise in designing, developing and deploying using Information design Tool, web intelligence, desktop intelligence, info view, Lumira, CMC, Workbooks.

Extensive experience in creating reports with Charts (bar chart, Pie chart...etc), cross tabs and sub reports.

Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key businesses and enabled dynamic report linking by passing variables (prompts) between reports.

Worked with BW of Bank Analyzer.

Experience with Power Designer models.

Worked on Lumira 1.29, Fiori and Design Studio.

Strong experience with resolving performance issues in crystal reports and excellent with unit testing, system integration testing, and user acceptance testing at various levels.

Excellent team player with good logical reasoning ability, coordination and interpersonal skills.

Solid communication skills have always been an asset in completing business venture and projects with success.

SKILLS

Primary Skills: BI 7.4/7.3/7.0, BW 3.5/3.1c/3.0b, SAP R/3 ECC 6.0,5.0,4.7E/4.6C

Secondary Skills: FI/CO, Logistics (SD, MM, PP), OTC, P2P, CRM, SRM, QM, HR, SCM, COPA, MS Excel, VBA, Bank Analyzer, Power Designer,

Languages: ABAP/4, C, C++, PL/SQL, SQL, TSQL

Web Servers: IIS 5.0/6.0/7.0

Database: SQL Server 2000/2005, Oracle 8i/9i/10g/11g, MySQL, MS ACCESS.

Reporting Tools: BEx Analyzer, Crystal Reports, Xcelsius 2008, WEBI, Cognos, BO 4.1

Dashboards, Lumira 1.29, Tableau, MS-Excel.

PROFESSIONAL EXPERTISE

Client: BB&T Bank (Winston Salem, NC) Nov 2014 to Present

Role: Sr. BW/BO HANA Lead Consultant

Responsibilities:

As a BI specialist, involved in delivering multiple Business Analytic projects through the lifecycle capability management process which includes the research, define, design and implement phases.

Involved in numerous project define/design sessions and an expert in translating business requirements into technical specifications.

Involved in R1 and R2 release stabilization process to stabilize the Live SAP BI 7.3 system after the GO-LIVE. Involved in business meetings to resolve the business critical issues related to Bookings/Billings/Controlling.

Participated in requirement gathering workshops

In Release 3, lead the reporting team and involved in the architecture of building the Data Acquisition layer consisting of HANA Tables for Corporate Memory, Business transformation and conformance by BODS from Corporate memory to Transformed HANA and then creating the HANA TABLE/View for the Transformed HANA.

Finance and Risk Data Model was architected with Transformed HANA that will feed to BA (Bank Analyzer) where Banking Business rules will be applied in Processing and Methods layer and the final data is stored in RDL (Results Data Layer).

To report finance and risk data, used Power Designer to import BA SDL/RDL tables and design the HANA views. Also used to create HANA views into HANA Studio which will be the source of BOBJ reports.

Validated Model references, exporting of models and managing the modeling content.

Implemented LSA+++ Architecture and also worked with DXC (Direct Extractor Connection), SLT (System Landscape Configuration) and BODS (Business Objects Data Services)

Developed the package and schema structure in HANA Studio during the migration of legacy data, developed stored procedures and built analytic, calculation views.

Responsible for defining the package and schema layout in Native HANA. Migrated non-SAP data into HANA studio and developed analytic views for business users.

Gathered and analyzed the requirement to replace the ECC content in HANA using data provisioning.

Performed data and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA studio.

Worked on FI-GL, FI-AR and FI-SL, Regulatory and Fed Reports.

Using BW 7.4 created Hybrid Providers, Composite Providers and Semantically-Partitioned Objects (SPO’s) Objects.

Performed multiple development enhancements to the existing BW/BI systems, coordinate testing, and perform change management (Remedy)/training for BW Reporting and applications.

Prepared transportation plan for moving the BW objects across the landscape.

Extensively worked on the integrations and connections of BOBJ to different environments and systems.

Worked on IDT to create Universes on legacy systems to address the business requirements.

Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi-Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries (Union, Intersection, Minus).

Created complex webi reports with multiple queries, custom sql, using complex functions, merging dimensions at report level, drill down, drill up, drill across, complex filters.

Extensively used ETL tools like Informatica and BODS to process data from third party sources onto the enterprise BW layer.

Worked on Lumira 1.29 to address the adhoc reporting for the stake holders.

Worked closely with the basis team to identify and resolve issues that were identified during upgrades/enhancements in the global SAP BI landscape (Hana Studio, BOBJ, SAP BW).

Performed POC’s on various tools (Design Studio, Explorer, IDT, LUMIRA, FIORI) for other individual projects and moved to realization phase accordingly.

Involved in the on-going maintenance, break fix and providing post-production level support on the Propel R1 Release.

Actively involved in the UAT and SIT. Also part of the training to the end users.

Client: Honda Corporation (Torrance, CA and Tokyo, Japan) Jul 2013 to Nov 2014

Role: BW/BO HANA Consultant

Responsibilities:

GSP Project is the Global Standardization Project implemented in Honda Corporation to bring the entire business on SAP. As a part of the core team, worked very closely with the Business Users.

Involved in 2 Full Life cycle implementations.

Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models.

Being a Senior BI Consultant, responsible for the development, support & maintenance of SAP BI/BW version 7.3 connected to ECC 6.0 system with SAP FI, Logistics Modules and BPC 10.

Implemented LSA Architecture and maintained design consistency all over the system.

Extracted data for various data sources from Project Systems, Sales and Distribution, FI-AR, FI-AP, FI-GL, CO-PA data from R/3 to BI.

Responsible for analysis, design and development of SAP BW backend components and front end reports & dashboards.

Widely used some of the SAP BW 7.3 features, such as Semantic Partitioned Objects (SPO), Data Flows, Open Hub Destinations and Hybrid Providers. Implemented Dynamic partitioning in SPO using BADI.

Enhanced data sources using BADI.

PI/PO to extract legacy data.

Created Staging Cubes for both Finance and Project Systems in BI for BPC Data.

Automated the both Master and Transaction Data loads from BI to BPC by creating custom process chains for loading into BPC. Created a Delta DM package for Finance Transaction data into BPC.

Implemented BAPI for the BPC Retraction Process (Plan Data) to ECC.

Created BW interface for Business Objects Financial Consolidation (BOFC).

Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries (Union, Intersection, Minus).

Created complex webi reports with multiple queries, custom sql, using complex functions, merging dimensions at report level, drill down, drill up, drill across, complex filters.

Extensively worked on Design studio.

Created different Business Object reports by merging dimensions for the Universes on Relational DB Connection and BICS Connection.

Developed End User and Super User training manuals, job aids and presentations.

Active participated in the Work-Shops and Road Shows performed in all the Honda Plants all over the United States and Japan.

SAP HANA Developer Responsibilities

Conducted Workshops with General Managers and SME’s for requirement gathering

Created Proof of Concepts on SAP HANA Artifacts (Analytic and Calculation View) for the project

Client: Electric Power Research Institute (Palo Alto, CA) May 2012 to Jun 2013

Role: BW/BO HANA Consultant

Responsibilities:

Involved in the Full life cycle implementation, right from requirement gathering to Go-live.

Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models.

Assisted Client’s process teams for writing reports and performing Ad hoc Queries.

Involved in HANA integration and modeling.

Data Extraction from SAP FI, MM, SD, OTC, PP and HR of SAP R/3.

Worked with Info Cubes like Sales Overview, Delivery Services, purchase order and Info Sources like Sales Order and Delivery.

Worked on BPC Retraction and Staging Cubes.

Worked on BPC loads and Reports.

Created Classes, Dimension objects, Measure objects and Detail objects in the universe

Prepared different report layouts and blocks like Tables, Cross Tabs and Charts

Created and published various reports through Web Intelligence, Info view portal

Synchronized data from multiple data sources in Web Intelligence

Used various @functions i.e. @Select, @Prompt, @Where in the Designer for different report creation

Created dashboards using Xcelsius 2008.

Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries (Union, Intersection, Minus).

Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies. Used various functions such as @Aggregate aware, @prompt, @select, LOV’s, Index Awareness, Custom Hierarchies etc., in Designer.

Updated and maintained Universes based on changing user requirements and data source changes

Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports as per user requirements. Scheduled recurring daily, weekly and monthly reports.

Assigned privileges to users and user groups to access and work with universes and reports.

Designed and developed Dashboard to provide visibility, alignment and insight across the enterprise.

Client: Amgen (Thousand Oaks, CA) Apr 2011 to May 2012

Role: Sr. BW/BO Consultant

Responsibilities:

Full life cycle implementation, which involve Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.

Integrated BO with SAP ECC and SAP BI 7.3 to build Universes.

Used BICS connections to make Webi, Analysis for OLAP reports.

Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.

Developed Business Objects Universes with classes, objects and condition objects.

Hierarchies are implemented to support drill down reports.

Several complexes-cross tab reports and sub-reports are published using Crystal Reports.

Designed reporting templates with BEx Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition. Designed, developed, performed testing and implemented Crystal Reports, Webi, Xcelsius (Dashboards). Cross tab and Drill down options are enabled using Crystal Reports.

Xcelsius dashboards are created on top of crystal reports and live office. Webi Reports have been created deployed through Info View.

Trouble shooting and tuning of the reports.

Client: Nestle (MO, St. Louis) Feb 2010 to Mar 2011

Role: Senior SAP BW/BO Consultant

Responsibilities:

Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.

Customized Purchasing and Inventory cubes and developed custom objects for purchase requisitions and MRP data.

Report development on manufacturing modules like MM, OTC, PP, QM, IS-Retail and integration experience with FICO. Designed, developed and implemented Crystal Reports, Webi, Xcelsius (Dashboards).

Client: Prime Therapeutics, MN Nov 2008 to Dec 2009

Role: SAP BW BO Consultant

Responsibilities:

Involved in Production Support stages of the Full lifecycle Project implementation from Blue print to go-live.

Created multiple BEx Reports based on user requirements in sales, delivery, billing & customer analysis Reports. Created Web Intelligence reports using Business Objects WEBI.

Client: COACH Inc., NY Mar 2007 to Oct 2008

Role: SAP BW Consultant

Responsibilities:

Designed Physical and Logical data models and developed queries using filters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.

Worked on FICO, SD and AFS modules.

Created Cross-tab, Sub-reports and drill down reports using Crystal reporting tool.

Client: A.K.A. Turquoise Consulting LLC.(NJ) Mar 2006 to Jan 2007

Role: BW Consultant

Responsibilities:

Design and develop customized data extractors and associated Custom BW objects.

Involved in Production support activities supporting data extractions, data loading, and data verification for maintaining data consistency.

Client: Enercon India LTD, Daman, India Nov 2004 to Feb 2006

Role: SAP BW Analyst

Responsibilities:

Designed Physical and Logical data models, Created BW objects (InfoSources, InfoObjects, ODS Cubes, InfoSets, MultiProviders, Transfer/update rules and process chains).Created multiple queries for P/L and sales reporting.

Contact this candidate