Vijaymohan Velpula

• Proficiently handled Production Support Incidents, Minor/Major enhancements, and troubleshoot data loading issues in BW support projects. • Utilized LSA++ architecture to create new Advanced DataStore Objects (ADSOs) and Composite Providers, optimizing data warehousing capabilities. • Implemented Housekeeping activities to enhance data load performance and maintain a streamlined data ecosystem. • Driven data granularity by creating and assigning multiple Unit of Measures based on BUOM to key figures. • Stayed ahead of financial reporting requirements by updating Exchange rates for the new fiscal year. • Innovatively developed Sales area Comments data flow using Embedded BPC, enabling real-time data processing. • Enhanced the BW Model's End routine for seamless reflection in BPC reporting. • Improved Master Data flow in BW Model by incorporating additional fields and expanding PL&BS reporting capabilities. • Demonstrated expertise in developing S4HANA-ABAP CDS Views to support BW/Fiori APP Reports and ETL process Extractors. • Leveraged SAP-provided CDS Views for Embedded Analytics to maximize S4HANA design potential. • Deployed SAP ODATA BEx Query for Fiori Apps, providing intuitive data access for end-users. • Seamlessly integrated BW backend flow with BO/Lumira Dashboard, creating a powerful frontend reporting tool. • Utilized SAP Analytics Cloud (SAC) for secure user authorization and development. • Driven revenue and material planning using Embedded Models, Real-time cubes, Aggregation levels, and Input-ready queries. • Created Attribute, Analytical, and Calculations Views with table functions for comprehensive data exploration. • Accessed Analytical and Calculations Views using Analysis for Office/BOBJ, facilitating data-driven insights. • Possessed extensive experience in Information Modelling, Data Provisioning Techniques, and Data Replication Techniques. • Implemented design approaches like LSA++ and Hybrid/Mixed Models for adaptable data architectures.

• Led the remote conversion effort from BW on HANA 7.5 to BW4HANA, ensuring a smooth transition to the upgraded platform. • Built comprehensive data models in HANA Studio for various objects such as Advanced DataStore Objects (ADSO) and Composite Providers, while also preparing technical specifications for data mappings and business rules. • Collaborated closely with business users in report design workshops, using mock-ups and prototypes to gather requirements effectively. • Developed new data flows in BW4HANA, IBP (Planning), and Inventory Management, implementing them in the LSA++ architecture layer for enhanced performance. • Leveraged Calculation Views in HANA for Sales order process modeling, seamlessly integrated with Composite Providers. • Successfully implemented new data flows for IBP applications in a new BW4HANA implementation project. • Conducted technical feasibility analysis, designed data models, and deployed BI reporting solutions to meet project requirements. • Activated and installed Business Contents for ADSO, Composite Providers, transformations, and BW standard queries to optimize data utilization. • Configured data flows, transformations, and Data Transfer Process (DTP) for smooth data loading from the S4 system. • Facilitated transport creation and collaborated with the cutover team to ensure a seamless sequence of object transports.

• Improved BPC Consolidation data flow in BW, resolving data load issues and ensuring smooth data processing. • Led the development and data warehousing architecture management for BW4HANA/BPC system, seamlessly integrating all components within the BW solution. • Expertly resolved BPC Data Packages and load issues by implementing effective Process chains. • Configured Models, Dimensions, members, and properties, optimizing data organization and retrieval. • Implemented Conversion and transformation rules for efficient data upload and processing. • Demonstrated extensive expertise in SAP BPC/BW-IP modeling, reporting, and administration, ensuring the successful execution of projects.

• Spearheaded the design and implementation of SAP HANA Modeling, utilizing Attributes, Analytic views, and Calculation Views to build robust data structures. • Demonstrated expertise in handling Dynamic and Static Privileges, ensuring secure data access and management. • Configured and executed table replication using SLT for seamless data synchronization between SAP-ECC and HANA. • Revamped the Plant Maintenance (PM) data flow and engineered numerous high-impact reports, optimizing data insights. • Architected the SAP BW on HANA Composite Provider as a powerful semantic layer, leveraging BW on HANA Modeling tools in HANA Studio. • Leveraged SAP HANA Analytic Views to enhance standard DSOs' capabilities and integrated them into Calculation Views for advanced analysis. • Conducted Data Modeling, crafting Analytical Views for Transactional Data, Attribute Views for Master Data, and Calculation Views as the final comprehensive model in HANA Studio. • Delivered a unified and harmonized reporting solution through the implementation of advanced SAP HANA modeling techniques. • Successfully executed BW on HANA mixed scenarios, showcasing versatility in handling complex reporting requirements. • Created a wide range of Attribute Views, Analytical Views, and Calculation Views catering to diverse BO reporting needs. • Developed SAP BO Analysis for Office reports, enabling analytical reporting with intuitive visualizations.