Yeshwanth Gowd Sreerama Phone: +1-737-***-****

SAP BW4 HANA Developer Email: ad2psn@r.postjobfree.com Experience Summary

Total SAP experience of around 8 years in delivering SAP BI/BW, SAP Datasphere, SAP BW/4HANA, SAP HANA and SAC projects focused on Implementations, Upgrade, and Support & Maintenance for distinguished clients from various industry sectors.

Expertise in data loading to ADSOs, validating data between ECC base tables and BW/4HANA ADSOs, and conducting monthly reconciliations to ensure data accuracy.

Skilled in BEx query design, BEx Analyzer, and the development of flexible queries using Filters, Variables, Exceptions, Conditions, Restricted Key Figures, and Calculated Key Figures.

Experience in ABAP coding for Start, Field, and End Routines, coupled with strong debugging skills in BW modeling, ensuring robust system functionalities.

Experience in implementation of large-scale SAP HANA projects including, but not limited to SAP Business Warehouse (SAP BW) and SAP Enterprise Performance Managements projects (EPM) projects as well as end-to-end SAP BW Implementations.

Experience in creating information views (Attribute, Analytical and Calculation) and worked extensively in SAP HANA Data provisioning activities to provision the data from SAP & Non-SAP sources systems using BODS ETL Based & SLT Based replication methodologies.

Seamless integration of Tableau, Power BI, and SAP Analytics Cloud with SAP BI/BW & BW/4HANA systems, ensuring synchronized data management and analytics.

Proficient in SAP Datasphere, specializing in designing and implementing data models across acquisition, technical, and analytical layers using Data Builder. Extensive expertise in creating graphical views, developing transformation flows, scheduling, and designing process chains.

Proficiently design and develop visually compelling reports and dashboards in Power BI, while creating structured data models and optimizing raw data for reporting needs. Execute ETL processes, write efficient DAX queries, and build interactive, user-friendly dashboards to convey data insights.

Experience in designing complex Tableau dashboards for intuitive data visualization. Develop and optimize data models to facilitate efficient ETL processes, ensuring reliable Tableau visualizations.

Design, develop, and optimize high-performance databases, implement advanced T-SQL queries and stored procedures, lead database architecture initiatives, and provide technical expertise in troubleshooting, performance tuning, and scalability for MS SQL Server solutions.

Experience in architecture and designing of data models (Logical, Conceptual and Physical) and feeding the sub ledger data to Insurance Analyzer and General Ledger data to ECC systems.

Ensuring industry best practices for excellence in development, delivery and process improvement, global support solutions and global onsite-offshore delivery model are implemented.

Experience with Dynamic Data Tiring by keeping hot data in SAP HANA in-memory tables, and warm data in extended tables, highest value data remains in-memory, and cooler less-valuable data is saved to the extended storage by archiving data to NLS (Sybase servers).

Extensive experience in SAP Analytics Cloud, harnessing its advanced analytics tools for predictive modeling, collaborative planning, and augmented analytics. SKILLS

SAP BI/BW

SAP Datasphere

SAP HANA

SAP BW/4HANA

Power BI

SAP Analytics Cloud

Tableau

Test Process &

Management

SAP BODS

Software Testing

MS SQL Server

Azure Active Directory

PROFESSIONAL EXPERIENCE

Company: Aventis Systems Atlanta, GA, USA

Role: SAP BW4/HANA Developer March 2022 – February 2023

Involved in SAP BW modeling and design – ECC extraction, DSO, Master Data, Info provider modeling and design, Process Chain & Transports Experience.

Working on creating the transformation files and conversion files to load the actual data from BW to BPC.

Loading Transaction Data to SAP BPC Models, Dimensions using a Flat File, NW BI InfoCube using Standard Data manager Packages.

Working on integration of BI – BPC modules to support the data feeds from ECC to BW and then to BPC.

Had discussion with functional team and created business blue print and data flow diagrams.

Designed the Datawarehouse to support master data and transaction data to load from BW to BPC.

Creation of Models, Dimensions, Properties and maintaining members, Transformation file and conversion files.

Involved in Balance Sheet, Trial Balance and P&L Reporting by creating the Finance staging cube to support periodic values and YTD Values by providing the different flow types.

After completion of SAP BI configuration based on SAP BI as source creating Webi reports on top of BI queries and placing all this reports in corporate dashboard and presenting these dashboards through info view to the management.

Worked on converting the non-cumulative key figures to cumulative key figures model for the inventory management to improve the reporting performance.

Migration of the SAP BW objects in HANA optimized objects like DSO and Infocube

Experience with the SAP BW system on the top of SAP HANA data base, WEBi Reports on the top of HANA optimized models.

Responsible for stabilization of the BI system.

Worked on roles and authorizations in SAP BI.

Creation of queries based on business requirements.

Building the custom objects like DSOs, Cubes and multi providers according to the specification of the Functional documents.

Worked on Unit testing and maintain the Unit testing documents and Technical design specifications.

Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains.

Monitoring process chain and query performance.

Involved in Init set up for SD related data in R/3 side.

Experienced in Process chains creation, Created Process chains for Master data loading and transaction data loading.

Worked on system generated tickets and customer generated tickets as per the priorities.

Fixed the Data load errors and interacting with onsite people to speed up the error correction.

Created calculated, restricted, and currency conversion measures in SAP Datasphere.

Defined source, restricted, filter, and reference variables for composing analytical datasets in SAP Datasphere.

Configured appropriate authorization scenarios at the consumption model level for data security.

Worked on data loading to ADSO’s, info objects and composite providers in SAP BW/4HANA.

Worked extensively on data extraction from various source systems to SAP BW/4HANA.

Worked on designing SAP BW queries in SAP BW/4HANA.

Extracting, transforming, and loading (ETL) data from various sources into Power BI for analysis and reporting.

Company: EIM solutions India Pvt LTD., Bengaluru, India Role: SAP BW4/HANA Consultant November 2018 – December 2021

Hands on experience in SAP BW/HANA, HANA, BW, and Business Objects analytics technologies.

Worked on performance tuning of slow running reports by applying various performance tuning techniques.

Worked on gathering the requirements for the new reporting requirements for billing, device management and customer service departments.

Worked on new dashboards for the management reporting for the executive team.

Developed stories using different features of SAC like linked analysis, thresholds, webpage, tooltip, hyperlinking etc.,

sfully display a story in a Mobile SAC app using Responsive pages.

Experience in connecting various on-premises and cloud databases with SAC.

Manage User creation and created custom roles and assigned those custom roles to respective users.

Experience in data modelling like merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions, and Measures.

Worked on new dashboards for the management reporting for the executive team.

Worked on performance tuning of slow running reports by applying various performance tuning techniques.

Company: Virtusa Hyderabad, India

Role: SAP BW4HANA Consultant April 2016 – September 2018

Involved in OOTD activities.

Involved in archiving the ODS objects using SARA t-code.

Involved in monitoring of daily process chains, weekly chains and monthly chains.

Involved in production requests by loading customer requested flat files.

Involved in change requests by changing the existing data models like process chains and reports

Involved in solving the customer posted tickets with in the SLA’s.

Involved in maintaining the documents and excel files like MoM, way of working documents, query cook books, work instruction documents and status update sheets.

Involved in changing of existing data sources of SD and FI-CO (FICO) and involved in reloading of data.

As an offshore BI developer involved in development activities of the project.

Followed the SAP best practices by building the SAP recommended data modeling with LSA architecture to build on EDW with BW.

Maintained Data Sources, transformations and Info Packages for Data Targets in BI 7.0.

Created custom DSO's and cubes for the specific requirements of the client.

Involved in extraction of data by customizing predefined extract structures (LO Cockpit), generating Data Sources, Update mode as Queued delta and setting up of V3 Update and created generic data sources.

Involved in data source enhancements and activation of master data in ECC 6.0.

Experienced with extracting the data from SD, MM (Inventory), FI and CO (FICO).

Extensively involved in creation and maintenance of Update rules, transfer rules as per client requirements.

Created financial Multi cube to obtain the desired result.

Created queries by using Bex Query designer and used WAD to consume Bex Queries.

Extensively used Process Chains for master and transaction loads.

Created a Meta Chain for all the sub process chains for a smooth run.

Involved in Go live environment for 4 countries including the monitoring activities for the process chains. EDUCATION

Texas State University San Marcos, TX, USA

Master’s in computer science Spring 2022-Fall 2023 Ananta Lakshmi Institute of Technology and Sciences Anantapur, India Bachelor’s in computer science engineering August 2011 - December 2015 Related Course Work

C++ and Java Programming, OO design, Network analysis, Artificial Intelligence, Algorithm Design analysis, python programming, cyber security.

AWARDS & CERTIFICATIONS

• Microsoft Azure cloud Fundamentals certified.

• Google CDL certified.

• Best Performer Award, EIM Solutions.

• Received project start award in Virtusa for the best performance.

• Received an Applause Award in Virtusa in recognition of exemplary performance.

Contact this candidate