Sap SAC,Power BI,SAP BO

Harish Reddy Kancharla

Contact Number: 798-***-****

Email: *****.******@*****.***

mailto:***********@*****.***

Objective:

Seeking a career with a progressive organization where I can utilize my skills, knowledge and experience in a challenging role that allows for advancement and growth.

Profile Summary:

5.8 years of experience in information technology with strong emphasis in SAP Business Objects,

2.5 years in to SAP Analytics cloud, Hands on experience in PowerBI.

Worked in Needyin Technologies as SAP SAC developer.

Experience in connecting to live Universe and On-Premise universe and if unable to connect then there will be issue in Cloud connectivity, resolve the issue by contacting the support.

Experience in connecting live and on premise connection to SQL data base, excel sheets, and SAP universe & HANA Data sources.

Created Parent child Hierarchies in a dimension, Linked Analysis.

Created Analytical Models and Planning Models in SAC to forecast the data and analyze.

Created scripts for data actions, change of columns and rows in tables.

Applied Data security to models, Models privacy.

Created stories and dashboards, created smart discovery by selecting the measure and dimension values.

Integrated With SAP BW/HANA using SAP SAC Live connections and created Visualizations in SAC.

SAP BW/HANA queries can access directly and Live Model can be created in SAP Analytics cloud on specific BW Query.

Smart insights are used to know where and why exactly the revenue is high and from which state.

Smart insights are very useful for the client to know the detailed view of reports.

Added reference and variance lines to charts.

Created model by importing data from files, Created calculated columns,

Have Hands on experience in Digital dashboards.

Experience on SAP Analytics Cloud security concepts, Authorizations, roles, and collaborations.

Experience in working on VDT – Value Driver Tree, Advanced features in SAP Analytics Cloud like Predictive Analytics, Forecasting, Smart Discovery and Smart Predict.

Hands on experience on predictive scenarios like Classification, Regression and Time series.

Having good knowledge in SAP Native Hana Model creation, and views.

Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.

Experience in Designing/Developing Universes/Data-Model, Developing Ad-hoc Reports, Scheduling and processing of reports.

Excellent skills to develop reports using Web Intelligence Rich Client 4.2.

Created WebI Reports on BEX using BICS.

A good team player with excellent communication skills and has an ability to work in a team and individual environment.

Developed and maintained multiple Business Objects universes, Performed impact analysis on BO universe changes.

Having experience in Migration from 4.1 to 4.2 version.

Created groups and giving access to different users like full access, on demand access, read access.

Experience in upgrade management tool using Complete and incremental upgrade.

Experience on Power BI (Desktop and Service) with different data sources such as SQL Server using Live Connection as well as Importing data from Excel Sources.

Experience in Data preparation in Enter Data and shaping data in Edit Query like add column, split column, pivot column, unpivot column, changing data type, and Merge queries and Append queries.

Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, Data Conversion, Union All, and Merge Join.

Technical Skills:

BI Tools : SAP BO 4.0, 4.1,4.2 Web Intelligence, Information Design Tool, Lumira Designer tool, Crystal Reports, SAP Analytics cloud, SAP BODS, CMC.

Databases : Oracle, Sql Server, DB2, and MS Access.

Web Servers : Tomcat, Microsoft IIS

Operating Systems: Windows NT/7/8, windows servers 2008/2012

Educational Qualification:

B. Tech (IT) from J.N.T.U University in 2009

PG Diploma in Computing Level 7 from New Zealand 2011.

Project#5 :

Project: Vallourec

Role: SAC Developer.

Duration: Feb 1st 2019 – November.

Company: NeedyIn Technologies.

Gathering the requirements from the client and working accordingly.

Experience in connecting to live Universe and On-Premise universe and if unable to connect then there will be issue in Cloud connectivity, resolve the issue by contacting the support.

Experience in connecting SQL data base and excel sheets.

Successfully created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.

Successfully display story in Mobile SAC app using Responsive pages.

Implemented stories using different features of SAC.

Created Parent child Hierarchies in a dimension, Linked Analysis.

Created scripts for data actions, change of columns and rows in tables.

Importing the data from different data sources and transforming the data as per user requirements

then creating visualizations.

Used Trend Lines, Reference Lines and Forecasting to describe the data.

Used groups, hierarchies, sorting to create focused and effective visualizations

Developed custom report tool tips for different reports to showcase the multiple data points in one report.

Project #4

Project : New York Life Insurance

Organization : KPIT Technologies Ltd, Pune.

Role : SAC developer.

Environment : SAP Business Objects 4.0/4.1, 4.2 Information Design Tool, Web Intelligence, SAC

Duration : Jan 2017 to Jan 2019.

Role & Responsibilities:

Creating weekly and Monthly, Quarterly reports as per Business needs.

Created Radio Buttons in SAC using script functions and display the charts accordingly.

Exported the reports to PDF format.

Created Filters according to the requirement in Analytics cloud.

Created comparison charts, pie charts, Trend charts in SAC.

Created users and assigning security and roles to users.

Created stories, Analytical applications, stories, predictive scenarios.

Experience in connecting to Hana views using both Live and import connections in SAC.

Created Model on SAP Hana and done data wrangling, Transformations and created visualizations in sac on Hana database and shared with users.

Good knowledge in installing sap Analytics cloud and SAC Agent to connect on premise connections to Hana, UNV and other data sources.

Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.

Created monthly and summary reports in WEBI 4.1 for the different domains like Sales, Marketing and HR domains.

Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.

Design develop landing page, web enabled, and link to the Power BI serve

Responsible for migration of reports and universes from BO 3.1x to SAP BO 4.1 and fixes migration issues in webi reports.

Created WEBI reports and deployed them through BI Launch Pad with Universe as source.

Implemented Role Based Security as part of user level security in Power BI

Used Trend Lines, Reference Lines and Fore casting to describe the data

Used groups, hierarchies, sorting to create focused and effective visualizations

Developed custom report tool tips for different reports to showcase the multiple data points in one report.

Created Lumira Discovery Dashboards.

Project # 3

Project : Galaxy surfactants.

Organization : Covantech Solutions Pvt Ltd.

Role : BO Consultant.

Environment : SAP Business Objects 4.0/4.1, Information Design Tool, Web Intelligence, SAP Dashboards.

Duration : Dec 2015 – Sep 2016

Description : Galaxy Group, promoted by a team of professionals, has the main objective of making profits for growth by tapping opportunities in India and abroad, which challenge the professional competence of people in Galaxy, we provide maximum value to our customers, Galaxy shall make conscious efforts to look after the well being of its people, Galaxy shall endeavor to achieve excellence through professionalization of all areas of management

Role & Responsibilities:

Involved in interacting with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.

Universe design using the Information Designer tool which includes creation of Classes and Objects, Prompts, Filters and Setting up hierarchies etc at universe level as per design specification documents.

Defined Aliases and Contexts to resolve the join problem in the Universe.

Dynamic ranking Prompts implemented in all WebI reports in order to change the ranking in report depend on required field to apply Rank.

Prompts & Nested prompts to make the reports confined to a particular case as per the business Requirement.

Project # 2

Project : Jindal Steels.

Organization : Covantech Solutions Pvt Ltd, Hyderabad.

Role : Associate SAP BO Consultant

Environment : SAP Business Objects 4.0/4.1, Information Design Tool, Web Intelligence, SAP Dashboards,

Duration : Feb 2015 – Nov 2015

Description: Jindal Steel and Power products are energized by the buoyancy of innovation that enables the distinction of being a trailblazer. Customization is at the core of all our product development and our

Global technology excellence ensures the best in class offerings for the valued customers. The company's continuous growth and enhanced capabilities stand testimony of the ceaseless drive for excellence.

Role & Responsibilities:

Involved in Creating and maintaining Universes by using Universe Designer.

Created Classes and Objects in Universes, According to Functional specifications.

Created reports by taking data from different data source.

Involved in the modifying and Building of Universes, Classes and objects.

Created objects and defined them accordingly into measures, dimensions and detail.

Used joins concept by taking different tables from different data sources in the Universe.

Set up Universe level conditions to restrict data based on Functional specifications.

Involved in creating Aliases and contexts in Universe Designer.

Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down and Formulae’s.

Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.

Created Web-I reports as per the Functional specifications.

Used the formatting options like cross tab, sections, breaks, data sort.

Created reports with different charts, Prompt filters as per Functional specifications.

Published the reports and universes to live repository.

Created Report level conditions to restrict data, based on report requirements.

Used @select, @where, @variable, @prompt and @aggregated awareness functions in universe development.

Implemented Row & Object level security for different user groups as per the Functional Specifications.

Project # 1

Project : Dalmia Cements

Organization : Covantech Solutions Pvt Ltd Hyderabad.

Role : Associate SAP BO Consultant

Environment : SAP Business Objects 4.1/4.2, Information Design Tool, Web Intelligence, SAP Dashboards,

Duration : Nov 2013 – Jan 2015

Description : The Dalmia Group had established four cement plants in pre-independence years, two of

Which are affected by the partition and Independence, the two remaining plants operate as Dalmia cement and we have also made strategic investment in Orissa Cements Limited, Managed by a professional team, we have sustained the path to innovation and growth for Seven decades. DCBL prides itself on having been at the forefront of pioneering and introducing many new technologies, which exist today, which are followed by others in the Industry.

Responsibilities:

Requirement gathering and developed various reports as per the Business requirements.

created Contexts and Aliases for resolving Loops in the Universes to improve performance

Maintained and extended support for the universe created and for building Canned Reports

Created reports with different functionalities like Alerts, Sections, Sorting, Break, Filters, and Prompts.

Exported the Universes to the Repository to make resources available to the users.

Extensively used filters, conditions, list of values (LOV), calculations, etc.

Contact this candidate