Sign in

SAP BW HANA Consultant

Arlington Heights, Illinois, 60005, United States
January 31, 2018

Contact this candidate

Sai Teja Vissamsetti Email:

SAP HANA Consultant Phone: +1 816-***-****

Professional Summary:

4+ years of IT experience in Development, Production Support for Business Applications in SAP HANA, SAP BW, SAP ABAP and DSiM.

Worked in BMW AG (Munich, Germany), Flowers Foods (Thomasville, GA) along with the clients in building their confidence in offshore.

Working experience on HANA modeling, BW, BW on HANA.

Extensively worked DSIM Data model, Data upload, Harmonization.

Good experience in writing SQL queries.

Good experience with the Data visualization tools such as Analysis for Office, Design studio, IDT.

Extensively worked on Functional (SD, Supply Chain Management, MM, PP and FI) modules.

Creating Information Models (Calculation Views, Analytical Views) as per the business requirements.

Involved in creating Calculation Views with SQL Script.

SAP BI 4.0 Reporting Tools connectivity with SAP HANA.

Involved in configuring Data Provisioning for SAP HANA DB through BODS, SLT and DXC.

Good knowledge on SAP BODS Load to SAP HANA – ODP Enabled, SAP DXC – Direct Extractor Connection, Data Sources.

Good knowledge on loading the data into SAP HANA using SLT.

Worked extensively on solving the production issues in the BW applications.

Worked on BO 4.1 tool on universe design as well as created reports in Webi.

Involved in Unit Testing, Functional Testing, UAT.

Experience in collaborating with the engineering teams and clients to specify and deliver customization requests, managing the production of client-facing written deliverables and helping develop the firm’s client service brand.

Extensively worked on defining the scope of a client engagement in statements of work and facilitating a smooth client on-boarding process.

Successfully delivered projects with Zero Defect Deliveries under strict delivery timelines.

Good experience in BASIS Security activities: User creations, Role creation, Role maintenance, maintain authorization projects... etc.


ITIL v3 Foundation Certification.

Professional Experience:

Project #2

Company : Sage Group

Client : Flowers Foods

Role : SAP BW/HANA Consultant

Duration : 09/2017 – Present

Flowers Foods is a producer and marketer of packaged bakery foods in the United States. The company operates 46 bakeries that produce breads, buns, rolls, snack cakes, pastries, and tortillas.

Interacting with Client for Gathering requirements for developing Customized reports.

Interacted with client team on requirement gathering /issue clarifications.

Interacted with functional team / Solution Architect for the technical design of the requirement.

Analyzed and corrected production problems as they occur in the SAP BW.

Extensively worked DSIM Data model, Data upload, Harmonization.

Worked on file processing like placing the daily IRI files automatically from DSIM server.

Ensuring data availability on time for DSIM Global Info providers.

Worked on data load failures for MD and Transactional data and finding root cause to provide permanent fix.

Extensively worked Harmonization issues.

Worked on Time Alignment, UPC splitting and TPM concepts/Scenarios.

Involved in Manual mapping of harmonization for Products and Locations.

Worked on Derivation instruction sets for Products and locations.

Maintained Data delivery agreements by using /DDF/DDAGR as per business requirement.

Define file and file sets as per Data delivery agreements.

Experience in SAP BW Data modeling of InfoCube, Multiprovider, Infoproviders, Composite Provider, DSO, Info Objects, Data source, Transformation & DTP and Process Chains.

Developing customized HANA information Models (Attribute, Analytical & Calculation views) for SD, FI, MM modules based on reports & Dashboards requirements.

Developed Calculation views using Input Parameters, Variables, filters, logical conditions, calculated columns, restricted columns, constants and reusable views.

Developed reports using Joins, Union, Projection, Aggregation and Rank scenarios.

Actively involved in rectification of load Failure errors like Master data loads, transactional loads by doing manual update, reconstruction and running the Info-packages manually.

Data loading was monitored, and failed data packets were analyzed and if possible manually edited in PSA and loaded into InfoCube.

Worked on validation of data, created queries and resolved data related problems.

Interacting with the batch team and basis team for any loads process chain delay schedules.

Project #1

Company : Achala IT Solutions (Official offshoring partner Sulzer AG)

Client : BMW

Roles : SAP BW/HANA Consultant

Duration : 04/2012 – 12/2015

BMW AG. is a German automobile, motorcycle and engine manufacturing company founded in 1916. It also owns and produces the Mini brand, and is the parent company of Rolls-Royce Motor Cars. BMW produces motorcycles under BMW Motorrad and Husqvarna brands. BMW is known for its performance and luxury vehicles, and is a global leader in premium car sales.

Creation of information model’s such as Attribute View, Analytical View, Calculation View using SQL queries and through Graphical interface.

Consuming the HANA models into Universe and providing the data for reporting through BO and Tableau.

Creating Info Objects, DSOs, Info Cubes (with efficient Star Schema), Multi Provider, Process Chains and Reports in BW for few applications.

Planning the enterprise level data scheduling and making the Reporting data available for end-users with agreed timeline.

Performing deep analysis into massive data sets to answer key business questions using SAP Analytics solutions and reporting them via various reporting tools such as SAP Business Intelligence and QlikView.

Migration of the reports from SAP BI Reporting solution from 3.X to 4.1 SP5.

Migration the workflows from 3.X to 7.0.

Creating Enhancements on ECC depending on the client requirement.

Worked in developing and enhancing of BO WebI Reports, SAP Netweaver Portal, Universe Designing and query designing.

Activation of the standard content of the SAP BW system as per the client requirement and thereby reducing the implementation time for reports.

Direct and Indirect Procurement Reporting: Worked as a Business Analyst in requirement gathering from Engineering teams and as a Techno-Functional Consultant designing and developing the Reporting Application, using SAP BW as back end and SAP Web Intelligence for Reporting.

Supporting the New vehicle development process Application which includes the extraction of the data from the design systems into SAP BI and reporting the status in Web Intelligence Reports.

Supporting of the Production Planning Application which includes SAP BI as the back end and Planning Cubes for live planning of the data.

Monitoring data uploads and identifying and resolving issues related to the upload of data.

Supporting the tracking of the New Requirement Implementation for an already developed vehicle.

Assisted in identifying and solving design flaws and issues.

Organized, participated, and conducted product demonstrations as well as other internal presentations to end users.

Helped the Project in generating more Technical development hours in enhancing the Data Warehousing System of the client and performance tuning.

Supporting of the Order to Delivery Quality Management Application which includes extraction of the data from SD, MM, SRM and WM systems into BI system and then reporting.

Developing the confidence of the client in handling the new developments in the applications and running the applications smoothly.

Creating confidence in the client in handling the critical BI systems in Offshore.

Involved in team setup and actively handled the Knowledge Transitions to the offshore.

Handling the SLAs and Key Metrics of all the applications across the BW Domain.

Worked closely with the client in scheduling the requirement gathering meetings with the Key Users and proposed reporting solutions that increased the productivity of business users which were accepted by business team and helped the Off-shore team in generating more work.

Full understanding of group wide Outsourcing (BMW Outsourcing Guidelines) & Offshoring policies and support functions in adhering to those policies.

Work with product management, technology management, and other constituents to research issues, and implement process improvements.

Full understanding of group wide Outsourcing (BMW Outsourcing Guidelines) & Offshoring policies and support functions in adhering to those policies.

Environment: SAP BW 7.3/4, HANA 1.0 SP5, SAP ECC 6.0, SAP BI 4.0, 4.1, SAP BODS 4.2, 4.0.

Education Summary:

University of Central Missouri, Missouri, USA GPA- 3.80/4.0

Master of Science, Computer Science

Jawaharlal Nehru Technological University, Hyderabad, India GPA- 3.5/4.0

Bachelor of Technology in Computer Science and Engineering

Technical Skills:

Data Warehousing: SAP Netweaver BI7.0, SAP HANA.


ETL: BODS, SLT, DXC, Informatica.

Reporting: SAP BO 4.0, IDT, WEBI

Programming Languages: C, C++, Java and SQL.

Web Technologies: HTML, XML, CSS, Web Services.

Operating Systems: Windows 8, Windows 7, Windows XP.

Tools: ITSM suite, Informatica, SAP BEX, QlikView.

Contact this candidate