SAP HANA Certified Consultant

Veerabhadra Rao

Visa Status: US Citizen

PROFESSIONAL PROFILE:

A SAP BW/SAP BW on HANA Consultant with blend of Technical and Managerial expertise having 14+ years’ US experience in SAP Net Weaver practice including testing. Implemented hands on BI and HANA solutions in several cross functional areas including Sales and Distribution, Materials Management and Finance. Mentored and lead SAP teams as a Practice Manager, Project Manager, Engagement Manager, Senior Developer and Solution Architect for complex global implementations. Experience included but not limited to requirements gathering, planning, architecting, design to deployment end to end, post go live activities and using the Design Studio to create mobile friendly reports. Industry experience range from Manufacturing, Health Care, Automobile, Semiconductors, Software, Biotechnology and Drugs, Beverages, Food Processing, Bank and Utilities.

SUMMARY:

14 Years’ Experience in SAP BW/BI with 3 Full life Cycle Implementations.

2 Years’ Experience on SAP HANA.

2 Years in SAP Business Objects (SAP BO 3.1, 4.0).

1 Year Experience in SAP BODS and SLT.

CERTIFICATIONS:

Certified in SAP ASAP

Certified in SAP HANA

ERP Packages:

SAP ECC 6.0, R/3 4.6

Expertise:

Requirement Gathering, Fit gap analysis, Configuration, Business Process Implementation, Data Extraction from SAP and non - SAP sources, Modelling and developing BW objects, Performance tuning of data loads, BI Security, Transport Management, BW operations like Process Chains, scheduling, monitoring etc. Problem solving skills, Off Shore and On Shore support, HANA Architecture.

SAP Modules

BW, HANA, BO, BODS Data Services, SLT, SQL (For HANA)

Modules

SD,FI,CO,PP,MM

Skills:

SAP BI-BW –1.2 B to 3.5, 7.0, 7.3,7.4,7.5 (on HANA)

SAP BO – 3.1,4.0

SAP ECC – 4.0B to 6.0

SAP BODS – 4.0, 4.1

SAP HANA – 1.0 SP1-SP9

SAP Netweaver --2004S

Languages Known

English – Read/Write/Speak

PROFESSIONAL EXPERIENCE:

Organization

Designation

Duration

IFB-BB&T, Winston Salem, North Carolina

SAP BW/HANA Architect

Nov.2013 – May 2014

IBM- BB&T, Winston Salem, North Carolina

Sr. Functional Analyst and BW/HANA Manager

May 2013 –Sep. 2013

IBM-Blue Harmony, Raleigh, North Carolina

Functional Lead

April 2012 – April 2013

IBM-General Motors, Detroit, Michigan

Strategy Developer

Jan 2011 – Nov 2011

IBM-Ebay, San Jose, California

Lead Interfaces

Oct.2010 – Dec 2010

IBM-Cardinal Health, Dublin, Ohio

Functional Lead

Sept.2009 – Oct. 2010

IBM- Applied Material, Sunnyvale, CA

Technical Lead

March 2009 – Aug 2009

IBM- Panasonic Corporation of North America, Secaucus, NJ

BI Team Lead

Nov.2008-Feb. 2009

IBM-Brock, Houston, Texas

Team Lead

May 2008- Oct. 2008

IBM- Raytheon Systems, Tucson, Arizona

Team Lead

March 2007 – March 2008

Accenture- Pacific Gas And Electric (PG&E)

BI Project Manager

Aug.2006 – Oct.2006

Accenture- Boston Scientific, Boston, Massachusetts

BI Project Manager

Sept.2005 – June 2006

Accenture- SAP Waldorf, Germany

Project Manager

Aug.2005 – Aug.2005

CSC – Skyy Spirts, San Francisco, CA

BW Principal Consultant

Oct. 2004 – Jan. 2004

CSC -- Rich Products, Buffalo, New York State

BW Lead Architect

Sept. 2003 – Oct.2003

QWEST – End Wave, Sunnyvale, CA

SAP Project Manager

2002

QWEST -- Mitsubishi Silicon, Portland, Oregon

Sr. BW Consultant

2002

QWEST – Redback, San Jose, CA

DW Expert Consultant (ERP)

2001

QWEST -- Symbol Technologies, Long Island, New York

BW Lead Architect cum Project Manager

2001

QWEST- Business Objects, San Jose, CA

BW Developer

1998

EDUCATION:

Bachelors in Mechanical Engineering

Master of Business Administration (MBA)

PROJECTS

Client: BB&T, Winston Salem, NC

Role: SAP HANA Architect

Duration: Nov.2013 to May.2014

Activities:

Built the HANA architecture with Data Acquisition layer consisting of Corporate Memory, Business transformation, 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.

HANA views were created in HANA Studio which was the source of BOBJ reports.

The BOBJ Reports were created from Self Service Tools like Analysis For OLAP, for adhoc reporting WEBI was used, Visualization tools like Design Studio, Lumira (self-service tool also) and also “what if analysis” BO Dashboards was used . ODBC (open data base connectivity) was used to enable applications like Design Studio to access data from HANA via the SQL and JDBC for Lumira.

Created mobile friendly Design Studio reports which runs on HTML5 run time and the release was 1.4.

The basis for this Solution Architecture is the LSA++ and also worked with SLT (System Landscape Configuration).

Client: IBM - BB&T, Winston Salem, NC

Role: Sr. Functional Analyst and BW/ HANA MANAGER

Duration: May.2013 to Sept.2013

Activities:

Legacy Regulatory Reports like Call Reports, FRY9C, FRY14Q, Internal Reports like EMP (Executive Management Package), Market Risk, Liquidity and Capital Committee (MRLCC) were decomposed and came up with calculations that include formulas etc.

Conducted workshops to understand the Processes and then after the approval of final KPIs which is in line with the User Industry.

Walk through with the user community to get the final approval for the specifications and also presenting the business value of the reports to the users.

The decomposition also includes in identifying the Attribute and Measures, Hierarchies and defining the Metadata Import process.

Worked on Creating Information Models that include Attribute View, Analytical Views, and Calculated Views including the application of analytic privileges and also validating those models.

Created HANA modeling scenarios and activities such as adding a system, activating impacted objects, creating schemas, packages and content models, attributes and measures, hierarchies and creation of constant columns.

Loading data into table definitions, suspending data loads, resuming data loads, validating data in the reports vs ECC, report layout validations also includes Report Unit testing, integration and system testing.

Analyzed the performance of the Query/Models using Explain Plan and Visualization Plan. Identifying the maximum number of records in a Table and also the partitions per table to improve the query performance.

Also created the BOBJ/BEx regulatory, management and operational financial reports in conformance with the financial services industry best practices.

Client: IBM – Blue Harmony, Raleigh, North Carolina

Role: Functional Lead

Duration: April 2012 to April 2013

Activities:

Analyze the Process flow for Sales Quotation, Standard Order, Shipping, Delivery, Picking, Posting goods issue, Billing and Payment to Customer. Order and Contract Management include the Track and Manage Enquires, Quotations, Order generation and Processing, Billing cycle management process and to manage the process like Order To Cash process seamlessly across all channels and functions.

Step by step coordination with process team for Gap analysis.

Wrote Report Definition Document (RDD), Technical Design Document (TDD) for reports and interfaces.

Technical mentoring to offshore team for developing SAP BI flow objects like Datasource, Transformation, Infoproviders, Open Hub etc,

Created and monitored Cut-over and MTP (Move to Production) activities, Analysis of defects, Estimation of CRs (Change Request) in Clearquest.

Hands on experience in testing of data and performance tuning.

Creating and executing test cases that include testing of Data load and Query performance

Reports that were tested are from Billing, General Ledger, Accounts Payable, Accounts Receivables etc. System Integration of changing the document (say PO number) loading the data to check the delta and test end to end.

Client: IBM – General Motors, Detroit, Michigan

Role: Strategy Developer and Application Developer

Duration: Jan.2011 to Nov.2011

Activities

Created detailed deployment and implementation strategy for SAP BI

Worked on the One Purchase System Blueprint and the BI system to deploy a single global purchasing system based on the SAP procurement suite, to procure all indirect materials and services.

Worked on the BOBJ tools like WEBI, BI Launch Pad, Business Objects Dashboards, Analysis for OLAP, and Analysis for Office etc.

Worked closely with Senior Executives for gathering the business requirements and prepare technical design/specifications

Created complex Master/Detail, cross tab reports with different data providers using universe and free-hand SQL and implemented various functionalities like Breaks, variables.

Created various Templates and Reports using functionality of Business Objects like query prompts, Slice & Dice, Breaks, Filters, etc.

Involved in Unit testing, Tuning and Performance of reports and created test cases and created documentation for all reports

Client: IBM – EBay, San Jose, CA

Role: Lead Interfaces

Duration: Oct.2010 to Dec. 2010

Activities

Designed Interfaces in the Finance Transformation project that involves making eBay IFRS (International Financial Reporting Standards) compliant

Includes Interface (inbound and Outbound) for the BI solution, Data extract and transformation.

Client: IBM – Cardinal Health, Dublin, OH

Role: Functional Lead

Duration: Sept.2009 to Oct.2010

Activities

Collecting the Client reporting requirements and further break them down into the Table/Fields/Standard Extractors /Hierarchy/Master Data etc.,

Created the ADD (Analytical Design Document) and RDD (Report Design Document) requirements.

Provide technical expertise in BI as to how best to meet business requirements and also meet them by configuring them into the system.

Coordinating with the Business and IT to get the best out of the Industry standard KPIs, SCOR and the SAP KPIs by holding different workshops and walk through the final KPIs.

The business processes implemented was Order to Cash cycle in SD is from Inquiry, Quotation, Order, Delivery, Post goods issue, Invoice and Accounting.

Testing of reports include end to end and checking the navigational attributes, drill down, filters in the output, cell calculations, exceptions and conditions.

The testing also includes the accessing the report and the variable screen and writing the test cases.

Client: IBM – Applied Materials, Sunnyvale, CA

Role: Technical Lead

Duration: March 2009 to August 2009

Activities

Supported the “post Go Live environment” and managed the day to day complex and operational issues emerging from the operations.

Simplified and accelerated the entire business process cycle, delivered the orders in time to improve the customer satisfaction, speeding up the revenue cycle, cost savings etc

Testing at the Backend source and BW reporting that includes the extractor data getting loaded into the PSA, also loading the data from PSA to DSO or Cube to check for the transformation and logic to work.

Created interactive Dashboards for different KPIs by using BO Dashboards (Xcelsius).

Worked SAP Business Objects 4.0 SP4, Universe Design Tool, Information Design Tool, BI Launch Pad.

Client: IBM – Panasonic Corporation of North America, Secaucus, NJ

Role: BI Team Lead

Duration: Nov. 2008 to Feb. 2009

Activities

Resolved several unresolved – lingering post go live issues to the complete satisfaction of the client. This turned the Project profitable.

Client: IBM – Brock, Houston, Texas

Role: BI Team Lead

Duration: May. 2008 to Oct. 2009

Activities:

Implemented the BI Express Solution having modules FI (GL, AR and AP), Consolidation, HR (Time Management, Pay Roll, Personnel Administration, Cross application Time Sheet and Organizational Management) and SM (Service Management) Modules.

This was a on- shore and off - shore project with Developers reporting from the 2 offices.

Client: IBM – Raytheon Systems, Tucson, Arizona

Role: Team Lead

Duration: March 2007 to March 2008

Activities:

Enhanced the BW performance and transferred the knowledge to the client personnel.

Innovative approaches were adapted to resolve issues for some of the deliverables like the introduction of write optimized data store objects for reducing the batch window.

Client: Accenture

Role: Project Manager

Duration: June 2005 to Nov. 2006

Project– Boston Scientific, Boston, Massachusetts

Activities

Supported the Field Action Reporting System (FARS) system used for research and execution of recalls when a potential issue has been identified.

Provided a robust solution to the client through all phases of the lifecycle including strategy, project planning, blueprinting, development, testing, cutover, support and governance models

Project– Pacific Gas and Electric (PG&E), San Francisco, CA

Activities

Transformed the PGE business processes into a industry leading performance based critical scorecard metrics and KPIs within SAP BI to drive the change.

Developed conceptual architecture by defining the project level architecture standards, identifying the work stream integration points, high level relationship between data sources, infoproviders and reports

Project– SAP Waldorf, Germany

Activities

Managed 5 Accenture Analysts, from different countries, in testing the SAP pre-configured business content for their new SAP Analytics product.

Client: Computer Sciences Corporation, USA

Role: BW Principal Consultant

Duration: Sept.2003 to Jan.2004

Project– Sky Spirts, San Francisco, CA

Activities:

BW Lead Architect for User requirements gathering, Business Blueprint, Realization, Testing & Cutover Phases.

Did the Phase Reporting Strategy, Data model designs, Data mapping, Extraction logic, Report playbacks, Test Scripts and Cutover.

Project– Real Foods, Buffalo, New York State

Activities:

As a SME provided vision, strategy & implementation expertise to successfully deliver the project within the estimated timelines.

Performed BW Audit of the existing design.

Client: Qwest Cyber Solutions, Denver, CO

Role: BW Practice Manager

Duration: Aug.1998 to Sept. 2002

Managed 20 BI consultants as a Practice Manager and was responsible for closing many key BW/SAP orders like End Wave, Symbol Technologies, SSM Health Care, Business Objects, Cognos etc.

In this role I was responsible for scoping the SAP Projects, creating the Sales Proposals, generating the Prizing wizards.

Developed and implemented the Application and Integration Fabric Layers for SAP Standard Operating Environment etc.

Project– End Wave (Radio Subsystems Manufacturing Company), Sunnyvale, CA

Activities:

As a Project Manager created a new instance of their TRW server with the associated configuration and the processes, and provide enhanced functionality in MM, SD, PP. FI and PS functional areas

Project– Mitsubishi Silicon (Semi-Conductor Company) Portland, Oregon

Activities:

As a Sr. BW consultant and as Subject Matter Expert my focus was on hardware and system administration requirements.

Provided all the software and hardware estimates required

I was Go to person on the BW Team for BW/BASIS requirements.

Project– Redback (Communications Company) San Jose, CA

Activities:

As a Practice Lead and DW Expert consultant performed technical evaluation of various DW tools

Created the Capability Maturity Model for the proposed client data warehouse and built a detailed report for the Executive Dashboard

Generated operational performance metrics.

Project– Symbol Technologies, Long Island, New York

Activities:

Project Manager and BW lead architect: with a team of 6 resources implemented BW reporting system in the functional areas of Purchasing, Inventory Control, Quality and Sales.

Used ASAP implementation methodology extensively

.

Project– Business Objects (Software unit) Ottawa, Canada and USA

Activities:

Project Manager: Developed SAP BW LO Cockpit & Generic Datasources extensively.

Created Update Rules and routines including delta functionality using ODS, External Hierarchies, Complex Currency requirements

EDUCTION

Indian Institute of Management (among the world’s premier Management Institutes) Bangalore, India

Master of Business Administration (MBA)

Osmania University Hyderabad, India

Bachelor of Technology (Mechanical Engineering)

Contact this candidate