Kamesh Kotikelapudi,

SAP BW/BI Consultant,

HANA Certified Associate. Phone:

609-***-****,

(New

Jersey, USA)

Professional Summary:

An SAP certified professional having over 8+ years of work experience, specialized in

analysis of Data Warehousing and Business Intelligence.

Experience working with cross-national teams at enterprise level development, implementation and

support projects.

Extensive experience on full life cycle implementations using ASAP and AGILE methodologies.

Experienced in managing and executing projects based on Onsite-Offshore Model.

Worked on projects from blueprint stage until go-live and stabilization. Responsibilities include

analyzing business requirements, reviewing functional specifications, performing gap analysis,

mapping business requirements to high and low level design documents, technical specifications,

development of backend and front-end objects, conducting all phases of testing, producing user

training manual.

Extensive experience in developing data models according to BW LSA and HANA LSA++

architecture.

Extensive work experience in Business content installation, Modeling, Extraction and Reporting

areas of BW.

Experienced in Multidimensional Modeling using MultiProvider(s), InfoCube(s), DSO(s) and

VirtualCube(s) along with advanced modeling features like composite providers,open ODS views,

and Advanced DSOs.

Experienced in BW ABAP in creating Generic DataSource based on Function Module, Start

Routines, End Routines, User exit for variable processing etc.

Experienced in Application Specific Extractions like Logistics, COPA, FI and CRM.

Experienced in fine tuning the BW load and report performance using optimized code, Aggregates,

Indexes, Partitioning and Compression techniques.

Experience working on Integrated Planning and input ready queries (Manual and Automated

planning).

Expertise in handling transport management of BW objects across landscape.

Experienced in linking Bex reports to BI (iViews) and CRM User interface screen.

Expertise in developing reports using BI tools (BEx Query Designer, BEx Analyzer and BEx Web

Application Designer WAD).

Experience in handling Proof Of Concepts to check the design and integration feasibility.

Experience in the realm of Business Objects software with specialization in Dashboards, Design

Studio, Web Intelligence reports.

Experienced in configuring BI client tools to communicate with the platform.

Experienced in migrating BO reports from BO 3.x to BI 4.x.

Experienced in handling post migration alignments, adjustments and stabilization of reports.

Experience in handling and executing Proof Of Concepts(SAP HANA, SAP BO and TABLEU).

Experience creating Attribute view, Analytical view and Calculation views in SAP HANA Studio.

Knowledge on SAP HANA data provisioning options i.e. SLT (System Landscape Transformation).

Experience in creating Adhoc reports using Business Objects Web Intelligence tools.

Ability to work on own initiative or as part of a team, backed by excellent organizational and

communication skills along with the capability to solve problems as they arise.

Knowledge on importing BW roles to BI system via CMC.

Knowledge in creating users and assign privileges to access BI reports.

Knowledge on SAP Business Planning and Consolidation.

Certifications:

SAP Certified Application Associate - SAP HANA modeler.

Certification: C_HANAIMP151 SP9.

S-User: S0016391140

Technical Skills:

Primary Skill Business Warehousing (SAP BW) & BW Powered by HANA

Programming Languages BW-ABAP

Versions SAP BW 3.x/7.x

Reporting Tools BEx Query Designer, BEx Web Application Designer (WAD).

HANA studio to design views.

Source systems ECC 6.0, R/3, CRM 7.0, APO.

Planning SAP BW-IP.

Knowledge on SAP BPC and PAK

Primary Skill SAP Business Objects Business Intelligence a.k.a BO, BOBJ,BI

Tools Dashboards a.k.a Xcelsius, Design Studio, Web Intelligence, Analysis for OLAP,

Crystal reports Data Services.

Source systems ECC 6.0, R/3, SAP BW

Education:

Graduated in Electronics and Communication Engineering from JNTU Jawaharlal Nehru

Technological University in 2008.

Work experience

Working for Sunray Informatics from May 2015 to till date.

Worked for Robert Bosch Engineering and Business Solutions Limited from March 2013 to May

2015.

Worked for Altimetrik as software engineer from October 2010 to March 2013.

Worked for Sunray Informatics as a software developer from May 2008 to September 2010.

Professional Experience:

Employer: Sunray Informatics (NJ, USA)

May 15-Present

Role: BW/BI Consultant

Environment: SAP BW 7.3, ECC 6.0, BI 4.1

As a BW/BI Consultant, responsible to gather and analyze the end-user business requirements along

with supporting BW and BI team with daily activities.

Analyze Functional design document and create Technical Design Document (TDD),create and

updation of Report Design Documents (RDD) as per the part of development activities.

Responsible for modeling and reporting of BW objects in LSA model with naming convections and

best practices.

Developed data models in the area of CRM Sales and developed reports on ABC analysis, Activity

reporting, I Base(s), leads and opportunity management.

Developed Input ready queries with planning functions for Sales Target System planning template.

Used BW WAD as the reporting tool to incorporate the planning template using standard and custom

ABAP functionalities to realize customer requirement on automated planning.

As a part of STS template, created aggregation levels filters, planning functions and planning

sequences to enable automated planning.

Developed business logics in the transformation layers via ABAP routines and formulas.

Worked closely with User department during testing phases.

Developed Web Intelligence reports on BEx queries facilitating Ad-hoc reports as per RDD.

Created Dashboards by using Design Studio using BEx Queries as a source.

Coordinated with offshore team on developments and made sure the deliverables are met.

Migrated Web Intelligence, Crystal reports from BO 3.x to BI 4.1.

Using Information Design Tool (IDT) and Upgrade Management Tool (UMT) migrated reports and

universes from Xi3.1 into SAP BI4.x .

Handling post migration issues with report design alignments, corrections and calculation errors.

BW on HANA:

Analyzing the business requirements and mapping with technical design document to realize the

reporting requirements.

Installed HANA optimized business content Data flows in the area of logistics.

Created Advanced DSOs and Open ODS views utilizing the power of HANA.

Critical FI reports like Balance sheet, Cash flow, Budget vs Actual and profit and loss and expense

reports were developed.

Reporting structures were developed accordingly using the BEx queries which were later consumed

in SAP BO.

SAP BO reports were created using Dashboards, Web Intelligence and design studio tools in

accordance with the report visualization type.

Process chains were created accordingly to automate the load process.

Employer: Robert Bosch GMBH (Stuttgart, Germany) Mar13-May15.

Role: BW/BI Consultant

Environment: SAP BW 7.0, 7.3, ECC 6.0, BI 4.0, CRM 7.0

Worked in BW/BI projects across the organization at various levels playing duel role as BW and BI

consultant.

Involved in gathering & analysis of business requirements.

Analyze Functional design document and create/update of Technical Design Documents after gap

analysis.

Create/update of Report Design Document as per agreed deliverables.

Responsible to coordinate with colleagues in Germany, China and India to develop the data models

according to the requirements/ specifications.

Conducting Jour fixe meetings to coordinate with different parties involved in the project

development.

Involved in installing and activation of Standard BI Content as per the requirements.

Enhanced the data sources with required fields to fulfill the reporting needs.

Responsible for modeling the BW objects in LSA model with naming standard Bosch naming

convections.

Creating generic data sources based on requirements to fulfill gaps with the standard business

content objects provided by SAP.

Implementing business logics in the transformation layers via ABAP routines.

Collected the developments into different transport requests based on the object category and

reporting area to ease the transport management.

Used Exits to populate default values and values based filling of BEx variables.

Input ready queries were created facilitating sales planning by using BW Integrated Planning.

Aggregates, planning functions and planning sequences were created as a part of the sales template.

ABAP logic was used to calculate custom business columns via planning interface.

Created APDs to push data from BW to CRM system Retraction.

Integrated BW reports to CRM portal.

Integrated BW report into BI Portal for Business users.

Created 20+ reports on CRM Activities, Opportunities, Business partner and I-Base reporting areas.

Worked closely with Business Users/End Users for SIT, UAT, regression testing, defect management

and support documentation.

Used HP ALM tool to manage requirements, test cases, test plan, defects, reports,

Create process chains as a part of daily/ monthly / quarterly data loads.

Ensure that the deliverables are delivered on time to the customer as agreed with the timeframes to

ensure that the work will be completed on time.

Stabilizing system after go live and preparing document at every stage of project for future reference

and re usability.

Responsible for creation of dashboards and Web Intelligence reports as requirements by consuming

BICS connection

Organizing handover meetings with the offshore support team for project handovers.

Involvement Design of Proof of Concepts (POC) for the new implementations.

Migrated Crystal, and Dashboards from BO 3.x to BI 4.1.

Using Information Design Tool (IDT) and Upgrade Management Tool (UMT) migrated reports and

universes from Xi3.1 into SAP BI4.0.

Converted reports into SAP Crystal Reports for Enterprise.

Handling post migration issues with report design alignments and errors.

Used BICS connections for WEBI reports on BEx queries.

Project: RANE BOBJ 4.0 Implementation

Nov12-Mar13.

Employer: Altimetrik.

Role: BW/BI Consultant

Environment: SAP BW 7.1, ECC 6.0, BI 4.0

Coordinated with the basis team and involved in installation and configuration of Business objects

Business Intelligence 4.0 server on Windows Operating System.

Configured the post installation activities like Enabling Authentication, Roles and user imports and

single sign on etc.

Coordinated with the client network team to resolve firewall restrictions in client server

communication.

Participated in solution meetings to analyze the KPI requirements and to provide the feasibility study

for the implementation of the crucial requirements of the client through business objects and

Dashboards.

Developed BW reports through BEx Query designer as per the requirement for BI reports.

Developed Web Intelligence reporting using BICS connections on BEx without creating Universe.

Designed and Developed Web I Reports using the features like Breaks, Sorts, Alerts and Ranking to

ease readability in Business Objects reports .

Used formulas in the Web Intelligence designer to achieve the logic of reports.

Integrated dashboards with Live Office, QAAWS, and BICS connectivity.

Project: HOLCIM - BOBJ 4.0 Implementation Jun12-

Oct12

Employer: Altimetrik .

Role: BW /BI Developer

Environment: SAP BW 7.0, ECC 6.0, BO4.0

Involved in installation and configuration of BO Client tools across all development systems.

Analyze business requirements, needs and objectives and map them to BI, solutions and products

that are being implemented.

Develop necessary Functional /Tech specifications and modifications to meet requirements, needs

and objectives.

Developing BEx queries over different InfoCube(s) and MultiProvider(s) as per the BO

requirements.

Creating OLAP Connections via Central Management Console(CMC) and Information designer tool

Developed Web Intelligence reporting using BICS connections on top BEx without creating

Universe.

Designed and Developed WebI Reports using the features like Charts, Cross-Tabs, Drill Down to

analyze the data.

Used formulas in the Web Intelligence designer to achieve the logic of reports.

Apply Breaks, Sorts, Alerts and Ranking to ease readability in Business Objects reports.

Manually defined the relationship between objects from different universes by manually merging the

dimensions to synchronize the data they retrieve.

Gave prompts, grouped the data and set filters in WebI reports.

Writing Unit Test Cases and validating the data.

Integrated dashboards with Live Office, QAAWS, and BIWS connectivity.

Developing Dashboards and WebI reports by using Open document syntaxes.

Project: Watson - BW maintenance and Support Jul11-

May12.

Employer: Altimetrik

Role: BI Developer

Environment: SAP BW 3.X, BW7.0, ECC 6.0

Responsible to deliver high quality solutions in BI to clients varying business requirements.

Developed reports like Material Inventory, Material Days Supply, Material Coverage, Direct and In

Direct MIS reports.

Created a work book on In Direct MIS and broadcasted the same using Generic functional module.

The same is included in the process chain and scheduled to broadcast on 1st of every month.

Enhanced COPA and Logistics data sources with new fields according to the business requirement

and changed the data target structures accordingly.

Daily data load monitoring: Data load process is monitor to check for errors and corrective action is

taken as one occurs.

Extensively Worked on Maintaining of Info Cubes, DSO Objects, Data sources, Transformations,

DTP, and Info Objects.

Worked on Reporting with Formulas, Restricted Key figure, Calculated Key figures, Variables,

Conditions etc.

Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to improve the

query performance.

Involved in transporting the objects within the Landscape using Transport Management System.

Enhanced the existing reports according to the new business logic and requirements.

Creation of process chains depending upon the modeling structure and timely scheduling the same.

Worked with administrative team a part of BW upgrade activity from BW 7.0 to BW 7.2.

Migrated BW objects from 3.x flow to 7.x as preparation for BW 7.3 upgrade.

Enhanced the existing process chains with new objects after migration.

Developed event based process chain that will run after successful completion of a job in ECC.

Handling the support tickets and resolving them within the SLA period.

Maintaining Work History for all the tickets until closed.

Project: Kengen - BO Implementation

Employer: Altimetrik

Oct10-Apr11.

Role: BO Xcelsius Developer.

Environment: ECC 6.0, BOXI 3.x

Interacted with Business Support Analysts and Business Users in gathering the requirements for the

Report Request.

Co-coordinating with onsite counterpart for status updates on daily-basis and raising clarification on

requirements.

Integrated Xcelsius with ECC through crystal reports

Created crystal reports on ABAP Infoset queries in ECC

Publishing and scheduling crystal reports.

Responsible for creating a Dashboard with graphical pie charts and other components to analyze the

business efficiently with Xcelsius tool.

Created dashboards by using Open document syntax to drill down to more detailed crystal reports

from dashboard.

Extensively used dynamic visibility and integrated multiple dashboards in to a single cockpit

dashboard.

Writing Unit Test Cases and validating the data

Emplyer: Sunray Informatics May08-

Sep10.

Role: BW Developer

Environment: ECC 6.0 BW 3.x / BW 7.0

Trained on BW and BI tools.

Responsible to check Data load processes i.e. Process chains were monitored to check for errors and

implement corrective measures to handle any such the errors.

Enabling BEx reports with additional navigational attributes requested by the user department.

Enhance/ create process chains to automate the load process for the newly developed data models as

per the change request.

Created Info Objects and InfoProviders as per the Technical specification.

Activated Business content DataSource(s), InfoObject(s), cube(s) and MultiProvider(s).

Collecting transportable objects into multiple transport requests.

Created Process chains for Master data and Transaction data loads to automate the data loading.

These process chains were scheduled for periodic loads.

Created report objects like calculated keyfigures, restricted keyfigures and variables.

Handling the support tickets and resolving them within the SLA period.

Maintaining Work History for all the tickets until closed.

Contact this candidate