BHUMIN SHAH

SAP HANA BOBJ CONSULTANT

Mobile : 009*-***-**-*** 97

Email : acy2xd@r.postjobfree.com

OBJECTIVE:

Highly motivated and technically competent computer studies International graduate, with strong interpersonal skills, seeking challenging and responsible position in SAP HANA, SAP Business Objects & Tableau. Quick to learn new systems, able to train and supervise others and confident when working individually or as a member of a team. Excellent client-facing skills, Communication skills, Interpersonal skills, Presentation Skills, Project Management skills and great team player.

PROFESSIONAL SUMMARY:

Having 5+ Years of total IT Experience with 4.5 years of experience in SAP BOBJ, SAP HANA & TABLEAU.

Had successfully finished 3 months training in SAP BI - BO in 2011 from London, United Kingdom.

Having experience in preparing project related documents like Detailed Design, High Level Design, Test Cases Document, technical design documentation.

Experience in Creation of Views (Attribute, Analytical, and Calculation) as per the business requirement, Build of SQL stored procedures and Creation of Technical Design Documents.

Experience in replicating the data from SAP / Non SAP sources to SAP HANA using SAP Landscape Transformation (SLT), Business Objects Data Services (BODS) and DXC.

Involved in Installation and Configuration of component of SAP HANA Studio, responsible for creating Restricted Measures, Calculated Measures & Calculated Attributes also involved in creating users/roles and assign privileges to that particular user/roles.

Worked as HANA SQL Developer and tester & Created HANA DB Scripts.

Good knowledge on different engine getting used in SAP HANA like Join Engine, Calculation Engine and SQL Engine.

Strong technical skills in universe designing and report generation using BO client tools like Web Intelligent, Dashboard.

Created complicated reports including graphical reports, formula base and well-formatted reports according user requirements in Business Objects and in Tableau.

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

Created design & development of IN-STORE INTELLIGENCE dashboards that helped Retailers & brands to increase sales and overall performance.

Good Knowledge about dimensional model (Star Schema and Snowflake Schema).

Got opportunity to work on other reporting tool like SSRS, SAP Lumira and SAP BO Design Studio.

Developed new reports and enhanced the existing reports as per the client requirements in BOBJ and Tableau.

Had given presentation on various Business Objects reporting tool and on Tableau.

SUMMARY OF TECHNICAL SKILLS:

BI Tools

SAP HANA Modelling Studio, SAP Business Objects 4.1/4.0/XIR3.1 (IDT, CMC, CCM, Dashboards, Web Intelligence, Crystal Reports, Design Studio, Live Office, BI Workspace), SAP Lumira, Tableau, SSRS.

ETL Tools

SAP BODS (Data services), BODI (Data Integrator), Talend.

Data Bases

SAP HANA, Amazon Redshift, Oracle 10g/11g, MS SQL Server 2012 & 2013, Teradata.

EDUCTIONAL QUALIFICATIONS:

Bachelor in Computer Systems and Networks from London South Bank University, London, United Kingdom in 2009.

Diploma in Computer Engineer from R.C. Technical Institute, Ahmadabad, India in 2007

CAREER PROFILE:

Employer

Role

From

To

Nexgen Technology Service Pvt. Ltd.

Bangalore, India

(subsidiary of Nexvisionix)

www.nexvisionix.com

SAP HANA, BOBJ & Tableau Developer.

Apr 2013

Continue

Mindcraft Software, Mumbai, India.

BOBJ Consultant

Oct 2012

Apr 2013

Marshgate Builder, Gillingham, UK.

Network Engineer

Jun 2011

Dec 2011

PROJECT EXPERIENCE:

PROJECT : 1 Feb 2016 – Till Date

Client

Gymboree, US.

Environment

Tableau, Business Objects XI R4.1, SAP HANA, Amazon Redshift, Web Intelligence, Universe Designer (IDT), CMC, Windows Server 2008.

Roles & Responsibilities:

Responsible for Designing tables, data loads in SAP HANA and created information models like Attribute view, Analytical view and Calculation view.

Experience in created measure using various aggregation types available like Min, Max, and Sum.

For calculations view, worked on different scenario with dimension, cube and cube with start join.

Was responsible for creating HANA DB scripts, created close to 20 stored Procedures on HANA SQL.

Good exposure in data provisioning using BODS and SDA

Configured Sap Landscape Transformation (SLT) server.

Extracting data from ECC tables into HANA DB via SLT

Involved in planning, Requirement gathering, design, development, Testing and maintenance of SAP HANA environment.

Used @aggregate aware functions in the universe to improve the performance of the query by cutting down on the size of the result set at the data provider level.

Used Derived tables as per the requirement in the Universe.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created data source with in-built calculation on tableau desktop and publish that data source on tableau server, so client can create reports directly from server as they have not installed tableau desktop.

Extensive knowledge in using Calculations, LOD’s and Parameters.

Proven knowledge of working with various Tableau Desktop functionalities & capabilities (Filters, Hierarchies, Sorting, Sets, Parameters, Custom Groups, Creating Story, Mapping, etc.).

Create a measure catalogue for client understanding about reports.

Having good exposure in Amazon Redshift database on creating tables, import data into tables from AWS (Amazon web service S3) and creating aggregate views/tables.

Created few tableau reports with Amazon redshift as a database.

PROJECT : 2 Feb 2015 – Dec 2016

Client

BCBG, US.

Environment

Business Objects XI R4.1,Tableau, SSRS, SAP HANA, Amazon Redshift,Web Intelligence, Universe Designer(IDT), CMC, Windows Server 2008 & Business Objects Mobile Platform.

Roles & Responsibilities:

Worked as HANA SQL Developer and tester, also involved in Unit testing and analyzing issues.

Was involved in Business Warehouse and data model design.

Replicated the data from non-SAP system and loaded into SAP HANA using SLT tool and BODS as an ETL tool.

Extracting and loading large amounts of Data using SAP Business Objects Data Services

Involved in preparation of design documents as per the requirements.

Extensive Experience in setting up environment for BOXI, setup for the project that involves creating the groups in CMC, adding users, mapping the row level and object level securities and assigning rights and permissions for various features, objects and users.

Used various reporting functionalities like drill, filters, alerters, formulas, variables, combine queries, ranking, merging, slice and dice, sections, query Panel, report panel, Formatting etc.

Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau.

Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS).

PROJECT: 3 Sep 2014 – Jan 2016

Client

In Store Intelligence (Company’s Product).

Environment

Business Objects XI R4.1, SAP Lumira, Tableau, SAP HANA, Web Intelligence, Dashboards, Universe Designer(IDT), CMC, Windows Server 2008,SAP Business Objects Mobile Platform.

Roles & Responsibilities:

Frequently interacting with Business team for new requirements of reports.

Created same data model from existing data model with sql scripts (including schema, tables, data load.

Attribute views. Analytical views and Calculation views) for POC purpose.

Good in environment setup, package installation, Service pack installation and configuring all components of Business Objects 4.1, SAP HANA Studio and Tableau Desktop and Server.

Loading data into SAP HANA using Flat File and SAP BO Data Services

Created calculated measures, calculated attributes, measures with currency conversion and filters as per the requirement in hana.

Created different type of visualization and stories in SAP Lumira and publishing stories in Lumira sever, Cloud and in BI Launchpad.

Created all calculations at HANA level and created data-set in Lumira and publishing in Lumira server/Cloud, so end- user can easily create report from server/cloud with drag and drop functionality.

Used Custom SQL to bring the functionality of ‘ALL’ in reusable prompts.

Linked Parent and Child report using Opendoc syntax in WEBI Report as per user requirements.

Implemented most advanced Mobile reports features in reporting for BOBJ.

Created complex report like Merchandising Effectiveness Game Plan Dashboard in BOBJ and in Tableau.

Good Exposure in creating solution driven views and dashboards by developing different chart types including Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Tree Maps, Heat Maps, Area Charts, Bullet Graphs in Tableau Desktop.

Implemented Tableau mobile dashboards via Tableau mobile application.

Experience creating joins, joins with custom SQL & blending data from different data sources using Tableau Desktop.

PROJECT : 4 Apr 2013 – Dec 2014

Client

Charlotte Russe, US

Environment

Business Objects XI R4.1, SAP HANA, Web Intelligence, Crystal Reports, Dashboards, Universe Designer (IDT), CMC, Windows Server 2008.

Roles & Responsibilities:

Worked with the seniors in setting up the security & scheduling which is done manually in the central management console and publishing wizard.

Created reports by using the multiple data providers and used prompts to make the reports more interactive for users.

Designed and developed Daily Sales and Hindsight Daily Sales Dashboard Reports by using Dashboard 4.0.

Created Hierarchy for the LOV and used cascading LOV in Web intelligence and also created Reusable LOV, Reusable filters.

Used different business objects @functions like @select, @where, @prompt.

Used customized LOV’s in Universes for quicker performance of reports.

Scheduled the WEB Intelligence Reports to BO user inbox and send copies to the external user’s mail box in MS Excel/PDF formats.

Was responsible for Migration of reports and universes between various environments like DEV, UAT and PROD.

Created Variables and applied them as filters and also worked on various input parameters.

Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Created Ranked reports and applied text Alerter to highlight trends and exceptions based on conditions.

Aware of Universe problem in Fan, Chasm incident.

Created BO universe using IDT on final HANA based Calculation view, modifying Data foundation and Business layer.

PROJECT: 5 Oct 2012 – Apr 2013

Client

Birla Sun Life Mutual Fund, India.

Environment

Business Objects XI 3.1 & 4.0, CMC, SAP BO Integration kit, Web Intelligence reports, Xcelcius, Crystal Reports, Teradata, Import Wizard, and Windows Server 2008.

Roles & Responsibilities:

Developing Business Objects Reports and modifications required for report development.

Deploy the Universe and Reports from development to Testing Environment by Creating LCMBIAR file.

Developed Web intelligence Reports by using multi data provider and Customized Query.

Developed various graphical representation reports such as Bar charts Pie Charts.

Generated report in webi and applied edit report enhancements such as breaks, alerts, track, folding and ranking for client requirement.

Involved in SAP BOBI Testing and UAT Testing in pre-Production Environment for Universe, Webi, and Dashboards.

Defined Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universe.

Worked on generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.

Migrate some reports and dashboards from BO XI 3.1 to BO 4.0.

Contact this candidate