Rama Subba Reddy Chowla

 Engaged in crafting database models within the Business Application Studio.

 Mainly dealt with shipping data from multi-carrier sources to Implement enhancements to improve existing data models in SAP BAS.

 Played a significant role in optimizing resource-intensive queries on SAP HANA Cloud.

 Actively monitored the HANA Cloud buffer cache to identify and address resource intensive queries.

 Build and customize SAP Analytics Cloud applications to meet specific shipping analytics requirements.

 Create and maintain data models within SAC, incorporating data from different carriers for comprehensive analysis.

 Implement complex calculations and statistical models within SAC for predictive and prescriptive analytics. Based on tenant wise (Costco, UPS).

 Apply deep understanding of financial consolidation (S/4 Group Reporting, BPC) and controlling concepts to support the planning and budgeting needs of finance teams within the Carriers.

 Implement advanced visualizations, drill-down capabilities, and dynamic filters for interactive shipping dashboards.

 Having good knowledge in SAP datasphere.

 Developed CDS views in CDS CAP, using calculation views as data sources to feed data into SAP Analytics applications.

 Developed SAP Analytics cloud analytics solutions involving data wrangling, multi model set-up, model development, story development, KPI dashboards for multiple carriers.

 Developed complex advance formulas using data action process.

 Define and enforce advanced access controls within SAC, including role-based access and fine-grained permissions.

 Configured connection between multi carrier data sources to SAP Analytics cloud.

 Manage the complete SDLC, including requirements analysis, system design, customization/configuration, testing, data mapping/conversion, performance tuning, and creating end-user documentation based on the carriers.

 Utilized GIT HUB for tasks such as creating clone repositories, establishing branches, and facilitating seamless changes across systems.

 Utilized Visual Studio for creating and updating data tables using XML format, feeding data into calculation views in SAP BAS.

 Collaborated with cross-functional stakeholders to define requirements, elicit feedback, and implement enhancements in PostgreSQL database structures, fostering a data-driven decision-making environment.

 Developed CDS views in CDS CAP, using calculation views as data sources to feed data into UI5 applications.

 Working as BW/HANA Consultant to build new extractors and reports for Finance.

 Worked in Native HANA Modelling and then loaded to BW to improve performance and agile reporting.

 Having good exposure and functional knowledge on financial areas like Lending credit, credit risk reporting with respect car leasing.  Create various charts, graphs, and visualizations to effectively represent complex datasets.  Design and develop SAC planning models and stories tailored to the unique requirements of the shipping industry, enabling effective financial planning, controlling, and operational forecasting..  Worked with Business users for Self Service reporting including SAC reporting.  Implemented data security model using BW Analysis authorization and HANA Privileges.  Developed SAP Analytics cloud solutions involving in data wrangling, multi-mode setup, model development, story development, KPI dash boarding for multiple streams of reporting and business units.  Developed dimension set building (including calculated and restricted dimensions)  Worked on complex advanced formulas using data action process.  Developed and maintained dimension properties to be leveraged in calculations.

 Worked with HANA Memory Concepts to improve the overall performance.

 As part of any development with respect to ERDQ or country inputs we have to collect requirement’s from POC to fulfill the development as per the requirement gatherings.

 Execute SAC Planning and Business Planning and Consolidation (BPC) projects, ensuring alignment with corporate planning needs and maintaining high-quality project documentation.

 I am a certified SAP Analytics Cloud consultant with an expert knowledge of end to end solution delivery, integration, data modeling, reporting & Forecasting.

 Worked on CDD- Customer due diligence fetching data from 32 entities and exposing to Trillium for reporting purpose.

 Good knowledge and excellent understanding of Hana cloud (2.0/Cloud).

 Good understanding towards GIT based Hana automated deployment pipelines.

 After generating Business rules, I was responsible to create reports and dashboards using Power BI based on trillium data source.

 Implemented to display transactional data in Map component in SAC, having Reporting Entities as countries in the map.

 Involving in developing each entity data flow from old source systems to new sources S/4 HANA and local core leasing systems.  Worked on direct HANA SQL script to prepare the reporting data and same logic will use in table function to use in a calculation to automate the process for regular month end activities.

 Agile methodology following and I will be the part of design the models as per the new request’s.

 Extensive experience in data modelling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions and measures

 Role: SAP BW/BI Consultant

 Gathered user requirements, mapping against delivered SAP content, and translating into a coherent design document.

 Activated Business Content Info Objects, Info sources, data sources, DSOs, Info cubes, and multi-providers.

 Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and multi-Cubes, coding in start routines and end routines.

 AS part of GBI project we were implemented and created new flows for almost 32 source systems

 Worked with Informatica ETL team to get ETL specs to develop objects in SAP BW.

 Aligned with business spoc’s to get exact primary keys on all interfaces.

 Leading offshore team to complete development on time

 Creating data flow for each interface ODSO->ADSO (CM)->ADSO(EDW)->COMPOSITE PROVIDERS and Process chains.

 Involved in tuning the SQL queries by using performance tools.

 Interacting with business SMEs on daily track’s status on development objects

 Working on Corrections/Break fix and Enhancements.

 Changed the Info Cubes by adding new fields, depending on the User requirements.

 Developed the New Reports, performed the testing and given to End-Users

 Worked in various technical upgrade projects (Support pack upgrade, patch upgrade) and BO Upgrade (4.0 to 4.1).