VIJAYA BHASKARA REDDY ALLA

SAP BW/BI/BO/HANA Consultant

PH: 405-***-**** accmc5@r.postjobfree.com

SUMMARY

• Over 10 years of professional experience in design, development and implementation of business

applications which includes almost 7 years of SAP BW BI Net weaver 7.0/ BW 3.5 as Techno Functional

Consultant.

SAP Certified Application Associate SAP BI 7.0 /HANA 1.0 .

•

Involved 2 full life cycle implementation in SAP BW 3.5 / BI 7.0 projects for FI/CO, SD, and MM

•

modules in all phases like Gap analysis, Blue printing, Design specification, Realization, Testing,

Documentation and Production Support

Extensive experience in business processes across the following modules: FI/CO, MM, SD and

•

HR.

Excellent skills in System Analysis, Documentation and Designing the Technical Specifications of the

•

Processes

Hands on experience in Designing and Implementing Financial Reporting.

•

Experienced with strong Net weaver 2004’s Business Information components skills in Data Modeling

•

like Info objects, Info Providers, Info sources, Transformation routines, DTP, DSO, Start and End

Routines using Data Warehouse Workbench

Customized Standard Business Content Extractors and Enhanced Data Sources in various

•

applications using customer user exits

Proficient in Data Extraction from SAP R/3 (FI, MM, SD, and PS), flat files and BW using extraction

•

structures such as LIS, LO Cockpit, CO PA, FI and Generic Extractors

Expertise in SAP BW/BI components like Data source, User Exits, ETL activities like OLTP data

•

extraction, loading (Full/Delta Up Load), Scheduling, Monitoring, Process Chains, Remote Cubes,

Data Mart and Open Hub Service.

SAP HANA, BW HANA architecture, design and data modeling expertise.

•

Developed data models using SAP HANA studio and SAP BW powered by HANA.

•

Expert skills in Data Services/Data integrator in design, creation, and implementation of BODS/BODI

•

Jobs. Performed complex transforms in dataflow using data services.

Expertise in building Multi provider, Multi cubes and Info sets as per the query needs

•

Performance Tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of

•

Info Cubes and use of Statistics for the same

Expertise in Front End Business Warehouse Components like Query Development, Reporting agent,

•

Calculated and Restricted key figures, Structures, Variables, BEx Analyzer, Web Templates, WAD and

Web Reports

Developed web reports using the Web Application Designer, Enterprise portal and Web Application

•

server

Excellent Production Support Skills including Data loads, Reporting related Issues, Archiving,

•

Performance Issues, and Data Compression Activities

Recognized as a troubleshooter for difficult client engagements

•

Excellent skills in System Analysis, Documentation and Designing the Technical Specifications of the

•

Processes

Page 1 of 10

Proactive Team player with Excellent interactive and Communication skills; Interpersonal skills

•

Team player, capable of working independently.

•

Extensively involved in Unit and Performance and Load testing.

•

Extensive knowledge of Software Testing Life Cycle (STLC)

•

TECHNICAL SKILLS

: Windows 7.0/XP/2000/NT/9x, and HP UNIX.

O/S

: SAP BW 3.5, 3.1C, 3.0B, 2.1C, SAP BI 7.0, Business Objects

ETL Tools

Data services BODS 3.2/4.0, SAP HANA 1.0 SP4

: SAP ECC 6.0, R/3 4.6C/ 4.6B/ 4.5B

ERP

: VBA, Visual Basic 5.0/6.0

GUI Tools

: ABAP/4, DHTML, HTML, ASP, Java, SQL, PL/SQL, C++

Languages

: Oracle 8i/7.x, SQL Server 2000/7.x, Ms Access, MySQL.

RDBMS

: MS Office, MS Excel

Tools & Package

: Business Explorer, Web Application Designer,

Reporting Services

SSRS and Crystal Reports.

QUALIFICATION

Bachelor’s Degree in Computer Science and Engineering from Kuvempu University, India.

PROFESSIONAL EXPERIENCE

Client : HP, Dallas, TX Jan ’13 – Dec’13

Role : SAP BW/BI/BO/HANA Consultant (Compass – ESIT)

Environment : SAP BW/BI 3.5/7.0, SAP ECC 6.0, FI/CO, PO, SD,

BODS 4.0, B.O 4.0, ABAP/4, SAP HANA 1.0 SP4

HP is an American multinational information technology corporation. It provides products, technologies,

software, solutions and services to consumers, small and medium sized businesses (SMBs) and large

enterprises, including customers in the government, health and education sectors. It specializes in developing

and manufacturing computing, data storage, and networking hardware, designing software and delivering

services. Major product lines include personal computing devices, enterprise and industry standard servers,

related storage devices, networking products, software and a diverse range of printers and other imaging

products. HP markets its products to households, small to medium sized businesses and enterprises directly

as well as via online distribution, consumer electronics and office supply retailers, software partners and major

technology vendors. HP also has strong services and consulting business around its products and partner

products.

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.

• Extensively worked on Data design and Data modeling using Extended Star Schema.

Page 2 of 10

Understanding the business challenges and translating them into requirements and developed

•

Analytics and Reporting Queries according to Business Requirements.

•Architected Info Providers and data models in both standalone HANA environment and BW Powered by

HANA environment (Ramp up).

•Load/Replication of data into SAP HANA Environment using SLT and Business Objects Data services.

•Created Attribute, Analytic, and Calculation views. Used Analytic privileges to establish row level and column

level data security.

• Extensively Worked on SAP ECC Extraction of Financial data, CO PA, MM and Sales & Distribution

LO Cockpit.

•Used the standard LO cockpit extractor for sales order, delivery and billing and created generic data sources

to load data into the info provider.

• Customized extract structures in SAP R/3 by adding additional fields and co ordinate in developing the

corresponding user exits to populate those fields. Worked extensively with LO Cockpit to activate

required logistics data sources and good awareness of delta management.

Extensively worked on Reporting Requirements, Design & Implementation for GL, AP, AR & Profit

•

Center Accounting in FI

Strongly Developed various Workflows and Data flows where the data is extracted from the sources

•

including Oracle 11g, SQL Server 2008 and SAP ECC 6.0 then loaded into staging tables from staging

tables data loaded into relational tables and from Relational tables data .

Used BOBJ Data Services cleansing transformations for de duplication, house holding and address

•

parsing.

Used various transformations including Map Operation, Table Comparison, Row Generation, Query

•

History Generation, Key Generation, Pivot and Query.

•

Implemented the Source level CDC while loading data into SAP BI info objects and info cubes and

•

OSDs.

As a part of the production support, involved in the debugging and monitoring load failures, update

•

routines, transfer routines, process chains, scheduling data loads, solving the high priority tickets like

delta loads, planning ECC outage for filling up of setup tables.

Created and enhanced new and existing Analysis Process Designs (APD) to load the data in to direct

•

update DSO and further into Metrics using DTP’s.

Extensively worked on Query building, filtering, free Characteristics, RRI Jump queries, Restricted Key

•

Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.

Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports.

•

Conducted many training and Brown Bag sessions to help the end client understand the SAP BI

system and also to gather the requirements.

Planned the cut over activities before go live and performed the downtime activities.

•

Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and

•

multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI

•Used BI 4.0 to create WEBI and Crystal Reports against HANA data models.

Page 3 of 10

Client : GTECH, Providence, RI Sep ’11 – Nov’12

Role : SAP BW/BI Consultant

Environment : SAP BW/BI 3.5/7.0, SAP ECC 6.0, FI/CO, HR, LO

GTECH, the world leader in gaming technology, supplies end to end lottery services and lottery game content.

GTECH offer world class system design, delivery, and ongoing support operations; terminal installation and

maintenance; retailer training; marketing support; field service; hotline management; telecommunications

network installation, management and maintenance; and a diverse portfolio of games for each channel of

distribution. It has a major SAP Implementation known as OSG – One Simple GTECH. I was involved both in

development and Production support in BI

Responsibilities:

• Successfully implemented a full life cycle implementation including Gap Analysis, Blue Printing, Report

Design, Development and Off shore Co Ordination for the Process automation Division in GTECH

• Recognized as a troubleshooter for difficult client engagements

• Coordinated with offshore (HCL India) to develop Analytics and reporting queries and help understand

the business requirements. Successfully made the transformation for the Process Automation division to

move from the legacy system to BI reports

• Worked extensively with FI reports like, Pulling ECC Sets Hierarchies (GS03) into BI (using tcode BW07)

for the Income statement reports and balance sheet reports

Regular interaction with the functional core team (FI, HR, and LO) and end users to understand their

•

Reporting Requirements and creating function specifications . Also conducted many brown bags and

training sessions to help the end user understand the full functionality of SAP BI.

Created many complex and customized Invoice Duplication report (FI), Operating Cash Flow report (FI)

•

using Bex Query Designer etc…

As a part of Production support involved in Debugging and monitoring load failures, Delta loads,

•

Minimizing the Init load and setting the v3 jobs

Involved in monitoring the performance of the system which includes performing OLAP Cache,

•

Aggregates, Indexes, Archiving the non cumulative info cubes the etc…

Extensively worked on many Production high priority support tickets by working with the clients and

•

satisfying their needs. Also monitoring the Daily loads/Weekly loads into the BI system from different

source systems

Worked extensively on the new features of Bex Analyzer and Visual Composer, by publishing and

•

transporting the views in the Enterprise portal 6.0

Worked extensively on Data Modeling design like creating InfoObjects, InfoCubes, DSO, MultiProviders,

•

Info Sources, Infoset and also in ETL (Extraction, transformation and loading) activities like

Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc…

Developed many complex ABAP enhancement like User Exit Functions, ABAP enhancements in ECC BI

•

CMOD, Generic Extractions and also in BI data modelling like Start Routines and End Routines

Designed and created many process chains to automate the data load and data target administration.

•

Actively involved with Power Users to support User Acceptance Testing.

•

Working closely with SAP Configuration Team to create manual test scripts, scenarios, test data and test

•

conditions.

Page 4 of 10

Client : Delicato, Napa, CA Mar ’11 – Aug ’11

Role : SAP BI Consultant

Environment : SAP BI 7.0, SAP ECC 6.0, FI/CO, HR

Delicato Family Vineyards (DFV Wines) is a family owned winery with over 87 years of experience in California

winemaking and winegrowing. DFV Wines is one of the fastest growing wine companies in the industry with

wineries and vineyard interests in the Monterey, Lodi, Sonoma and Napa Valley. I was involved in Blue Printing

and Gap Analysis.

Responsibilities:

• Extensively involved in Gap Analysis in analyzing the legacy reports (for e.g. reports like Overhead,

Payroll etc…), Debugged and Prepared the Functional Specification and its Corresponding Technical

Specification

Involved in many training sessions to help and to make the end client understand the BI reports and its

•

features

Extensive experience in BI 7.0 Reporting in creating the queries and workbooks by analyzing the

•

functional specification

Created many Proof of Concepts to help understand the requirement with the Business and also to

•

analyze the performance issues in the design Concepts

Tested and Documented the Security levels of Analysis Authorization at Multi Provider level, Info Object

•

level and Hierarchy Node level (e.g. Cost Center, profit Center etc…)

Prototyped the Analysis Authorization security roles by creating Ad Hoc queries and workbooks and

•

presented to the Business

Regular interaction with the functional team and end users to understand their Reporting Requirements

•

and creating related informational document

Worked extensively on the new features of Netweaver BI 7.0 Reporting tool BEx Analyzer. Created

•

queries using BI Reporting variables (using Offset values) for ITD (Inception to date), YTD (Year to date)

and MTD (Month to date)

Documented the Bex Variables, Query and Workbook standards

•

Transported Queries and Workbooks with their respective Roles from Development to Quality System

•

Created and developed many Queries and workbooks using General Ledger and FS Version

•

hierarchies like Trial Balance, Overhead reports et.

Co ordinate with functional team members to identify the transactions for performance and load testing.

•

Involved in String, Integration, Security, Technical, Performance, Load and UAT Testing.

•

Client : Ericsson, Dallas, TX Aug ‘10 Feb ‘11

Role : SAP BW/BI Consultant

Environment : SAP ECC 6.0, SAP BW/BI 3.5/7.0, BEx Analyzer

Ericsson wants to upgrade its SAP Business Intelligence unit to the latest version in this case to BI 7.0, which is

part of the new Net Weaver platform. The main reason in doing this is that it makes the data in BW more

accessible so that reports can be made available to the top level management in a more convenient way. My

significant amount of time in the project is spent in doing the upgrade from 3.5 to SAP BW 7.0, all the usual BW

Page 5 of 10

work (extraction, transformation and loading). Apart from this I am also partly responsible for testing the quality

of logistics and finance related data after upgrade.

Responsibilities:

Tested Delta mechanism for LO extractors as of BI 7.0

•

Test iterations were done on various reports as a part of release activity.

•

Testing quality of data in cubes and other targets.

•

Worked with new Data Store Object types (DSO) and Open Hub Destinations.

•

Coordinating with SAP for solving different bugs.

•

Comparing the load timing for different loads as performance activities.

•

Created process chains as per user requirement.

•

Worked with BI Objects including transformations, DTP’s.

•

Edited the data sources to get the data from SRM to BW.

•

Written Update routines, Transfer routines, User Exits using ABAP.

•

Coordinating with basis people for applying patches.

•

Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.

•

Involved in repair loads for sales and finance areas.

•

Involved in maintenance and support activities for solving issues raised by users.

•

Client : NOVA Biosource, Houston, TX May ’09 – July ‘10

Role : SAP BI Consultant

Environment : SAP ECC 6.0, BI 7.0, BEx Analyzer, SCM APO

Nova’s proprietary technology has the ability to efficiently process over 25 different feedstock sources with no

refinery modification, including low cost feedstock. Nova’s technology replaces the inefficient batch process

with a continuous process that allows economies of scale. As a BW consultant the responsibilities were to

cater ready and efficient access of the customer service and maintenance order to SAP Business Information

Warehousing (BW).

Responsibilities:

As a part of implementation team, involved in gathering user requirements and data modeling using

•

ERM, Star Schema Concepts.

Installed relevant SAP business content (BCT).

•

Migrated the 3x data sources to BI 7.0.

•

Interacting with functional consultants and business experts for designing data models and data

•

sources.

Worked with BI Objects including transformations, DTP’s.

•

Worked with new Data Store Object types (DSO) and Open Hub Destinations.

•

Worked on different data sources under customer services and plant maintenance.

•

Written Update routines, Transfer routines, User Exits using ABAP.

•

Created different queries on FICA, Billing, Device management, Back Office area.

•

Used DSO to stage data before transferring DSO contents to Info Cube.

•

Page 6 of 10

Worked on activating the standard business content info cube Project systems and Investment

•

management.

Responsible for design, development and extraction of data from R/3 Source System and Flat Files to

•

the BW system and created various Info package to enable data transfer.

Extracted consolidated data from different SAP and non SAP systems as project required.

•

Edited Views to get the data from tables of SRM.

•

Extracted SD data to BW and passed on to APO DP

•

Developed extractors from SAP R/3 and APO

•

Worked on Gas emergency and Gas leak reports.

•

Worked on Meter reading and Meter testing reports.

•

Involved in different testing like string, FUT, UAT and Recursive.

•

Created Process Chains to automate the loading Process.

•

Client : NIBCO Inc, Elkhart, Indiana Feb ’08 – April ‘09

Role : SAP BI Consultant

Environment : SAP BI 7.0, SAP R/3 ECC 5.0, FI/CO

NIBCO INC. is a worldwide manufacturer of flow control products for residential, commercial construction,

industrial, and irrigation markets. Some of its major products are TOLCO pipe support systems, valves and

actuators etc.

Responsibilities:

Set up source systems to load both SAP/R3 and Non SAP Transaction data to BI

•

Worked on Standard Line item data source like 0FI_GL_4( General Ledger line item),

•

0FI_AR_4( Accounts receivable Line Item), 0FI_AP_4( Accounts Payable Line Item)

Used ABAP Routines (in ECC/ BI CMOD Start Routines, Update Routines) in Update rules and Transfer

•

Rules to update characteristics and Key Figures in the Info Cubes

Managed and monitored several data loadings, Debugged the errors to identify the bugs and suggested

•

several OSS notes for the errors encountered while loading the data

Extensively worked on ETL activities like designed InfoSources, activated Pre/Post transformation

•

rules, scripted extraction routines for master data, texts and hierarchies. Extensively involved in

transportation, developed queries using filters

Created process chains to automate the data load and data target administration

•

Published the Queries in Portal as iViews on their respective Folders

•

Involved with performance tuning of queries by maintaining BI index, Rollup and Change run of BI

•

accelerator, partition of info cubes and actively involved in maintenance of OLAP CACHE for specific

queries using the reporting agent and the transaction code RSRT

Extensively worked on query development and formatting techniques in both BEx and Web

•

Application Designer(WAD) of key BW reports and created Web Templates

Client : Smart Modular Technologies, Fremont, CA Jan ’07 – Dec ‘07

Role : SAP BW/BI Consultant

Environment : SAP BW 3.5, BI 7.0, SAP R/3 ECC 6.0, SD, MM, APO

Page 7 of 10

SMART Modular Technologies, is a leading independent designer, manufacturer and supplier of value added

subsystems to original equipment manufacturers by delivering memory modules, cards and I/O products. My

role is involved in reporting and maintaining BW objects in SD and MM

Responsibilities:

• Worked extensively on standard LO extractors. Installed relevant SAP business content. Used LO

structures for extracting sales order, delivery information. Logistics Cockpit configuration and

customization

• Worked on sales order info sources 2LIS_11_VAHDR, 2LIS_11_VAITM and also on sales delivery info

sources 2LIS_12_VCHDR and 2LIS_12_VCITM

• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors

• Enhanced new InfoObjects to be attached/mapped in InfoSources/Communication structures. Changed

transformation rules as per customer requirements (ABAP routines)

Designed, developed ETL, extracted BW Data to Non SAP System using Open Hub service

•

Maintained Process chains to automate and schedule the background performance tuning jobs of BW

•

query using Indices, aggregates, Compression, Achieving and Partition

Evaluated statistical performance on OLAP using BW Statistics

•

Rescheduled the failed request from the cube by deleting the requests in the Info Cubes. Analyzed Info

•

Cubes (via RSRV) created and maintained aggregates (RSDDV) to improve the performance

Generated reports based on reporting requirements on purchase order summary, purchase order

•

details, sales order summary, sales order details, invoice details and APO Planning reports

Created templates for web publishing using HTML and JavaScript and published the report using the

•

developed templates.

Factor Inc., Oklahoma, OK Mar ’04 to Dec ’06

Software Engineer

Environment: VB 6.0, Informix, .Net2.0, Crystal Reports 6.0, Windows 2000.

ExecuTrak is the leading petroleum marketing and C Store main office business information system available

in our industry today. New Client/Server technology puts your PCs to work.

More “user friendly” application environment, providing greater ease of use and facilitating more rapid learning

of new functions. Both the keyboard and the mouse functions are active, and data entry personnel as well as

casual users will find the system accommodating to operate, design, develop and maintain database (Oracle)

Management programs for petroleum marketer and store automation in Unix, Windows and distributed

computing environments using Oracle, VB 5.0/6.0, VC++, ODBC, COM/DCOM and Crystal Reports.

Account Payables (AP): AP Module manages all aspects of payable accounts and integrates with the Retail,

Wholesale, Fuel Management, and General Ledger modules to simplify the way customer post payable

invoices, make vendor payments, generate management reports, and maintain their payable accounts.

Accounts Receivable (AR): AR allows user to define customer classes, taxes, finance charges, terms, and

statement cycles. AR is fully integrated with Inventory, General Ledger, Fuel Management, Wholesale, Retail,

and Tax Control modules.

Automated Dunning and Track Collection Actions: The Automated Dunning module automates the way a

company collects on past due accounts by flagging customers according to your schedule and their customer

Page 8 of 10

type. The system generates the appropriate dunning letter and notifies the customer automatically via mail, fax,

or email. The second program, Track Collections Activity, is used to schedule and/or record actions taken by

collectors or the automated dunning program, on a case by case basis.

Consolidated Fuel Dispatch: Is an advanced module that offers you integrated order entry, dispatch

scheduling, and truck tracking functions. Print loading tickets and dispatch tickets as needed to dispatch fuel

for delivery to both customers and profit centers.

Fuel Management: Module tracks all information about a load of fuel from the point of purchase through

delivery to actual billing for the load. The system automatically maintains tax, cost, freight, and pricing

information, eliminating the need for the operator to make decisions during entry.

Advanced Financial: it provides you with several tools for monitoring and reporting your company's financial

activities.

Heating System: Provides you with a powerful and flexible tool for managing your LP gas and fuel oil

operations, it allows you to schedule deliveries and create heating system delivery tickets for customer.

Wholesale Inventory: Wholesale Inventory program incorporates all of the functions necessary for creating

and maintaining your inventory.

This program allows you to:

Service Management: Service & Maintenance module automates and simplifies your service and

maintenance operations for both customers and profit centers. Regardless of the type of service you provide,

the module's flexibility allows you to customize it to your specific needs.

This module makes it possible for you to:

General Ledger: Module allows you to customize your general ledger to meet the unique requirements. It

eliminating the need for you to print and store the various reports and journals.

Advanced C Store/Price Book: Module enables you to electronically receive, translate, and preview C store

item Price book data, then accept, alter, or delete the data before it is put into permanent tables within

ExecuTrak.

Retail Sales: Retail Sales Module allows you to create price books for C store merchandise and manages all

aspects of retail marketing. It integrates with the General Ledger, Fuel Management, Tax Control and Inventory

Control. System offers flexibility for entering shift reports.

Sales Order Entry: Sales Order Entry Module provides a quick and efficient method for recording customer

sales orders. System allows you to record a sales order, place items on backorder if necessary, and print

picking tickets to use when filling orders. System provides you with key information such as customer purchase

history, customer quantity on hand, and product pricing information.

Bank Reconciliation: Is the process of verifying that all bank transactions are recorded properly by you

and by the bank. Furthermore, the reconciliation process identifies which items (checks, EFTs,

deposits, etc.), have cleared the bank and which have not.

Payroll: Payroll module offers complete integration with the general ledger to simplify the payroll process and

ensure the accuracy of your payroll.

Role and Responsibilities:

• Performed the requirement analysis for the development of this application.

• Involved in Database Design and Implementation, GUI Design & Development

• Used the Stored Procedures to display the Product Details.

• Experienced in Data Driven web application using Data source support by ODBC.

Page 9 of 10

Wrote database Triggers, Procedures and Functions to maintain data.

•

Created Reports using Crystal Reports.

•

KamatLingapur Hotel, India. Jun'03 to Jan' 04

Programmer/Analyst

Environment: Visual Basic 5.0, Oracle 7.X, Windows NT, Crystal Reports 5.0

I was part of the team, which developed an Integrated Hotel Management System to centralize all functions of

various departments associated with the hotel. The departments associated with this three star Hotel are Front

Office, Food and Beverages, House Keeping, Minor Operations Department, Personnel Administration,

Accounts, Purchasing, Stores and Inventory and Maintenance. At Front Office the system effectively maintains

Guest Information, handles Reservation and Registration. Provides summary for all transactions by a guest at

different departments. Under Food and Beverages, the system links all the outlets like Restaurant, Banquet

Hall, Bar and Room Service with Kitchen and as well as with Front Office. The system supports by alerting the

housekeeping department and Operations Department about necessary amenities at the time of guest check

in, or handling complaints lodged by a guest. Personnel Administration module maintains complete information

of the employee, time entry, recruitment, salary payments, leaves, loans etc.

Role and Responsibilities:

• Effective use of VB (Active X Controls) made the software more user friendly and easy access to the

database.

• Generated complex reports that included Graphs and Charts, in Crystal Reports, using Stored

Procedures written at the back end for enhanced processing time.

• Wrote database Triggers, Procedures and Functions to maintain data.

• Involved in Database Design and Implementation, GUI Design & Development and Integration Testing.

• Designed most of the forms, which included all data entry dialogs.

• Created Reports using Crystal Reports.

• Implemented and trained the users.

Page 10 of 10

Contact this candidate