Venkata Sandeep Marella
Hyderabad
Summary
Innovative Data Engineer with over 5 years of experience in ETL processes, data modeling, cloud integration, and SAP BTP CAPM development, SAP HANA development, ABAP CDS views, OData services, SAP Fiori Elements, and RAP (ABAP RESTful Application Programming Model). Engineered scalable data pipelines and enhanced database performance, resulting in substantial advancements in data retrieval and security compliance. Hands-on experience building RAP-based transactional applications with behavior definitions, draft handling, and OData V4 service exposure, alongside developing Fiori Elements apps driven by CDS annotations for seamless, configuration-based user interfaces.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
Aarini Technologies Private Limited
Hyderabad
09.2023 - Current
- Designed and developed ETL processes to effectively load enterprise data into Data Warehouse.
- Created stored procedures to automate periodic tasks in SQL Server.
- Optimized SQL queries and database schemas, enhancing data retrieval performance.
- Developed data pipelines to streamline processing workflows.
- Documented technical specifications and data models for reference.
- Analyzed user requirements to inform ETL process design.
- Implemented ETL processes, ensuring efficient extraction, transformation, and loading of data.
- Improved query performance by optimizing existing queries through index creation.
- Developed enterprise-grade, multi-service CAP applications with Node.js/Java, implementing complex business logic across financial validation, document processing, and master data management domains.
- Built scalable OData V4 services with custom handlers, annotations, and event-driven patterns, serving high-volume production environments.
- Designed comprehensive CAP solutions from CDS data modeling through deployment on SAP BTP, integrating seamlessly with SAP HANA Cloud, and external REST APIs.
- Configured XSUAA service instances on SAP BTP Cloud Foundry for securing CAP/BTP applications using the OAuth 2.0 authorization framework.
- Defined xs-security. with scopes, role templates, and role collections to implement fine-grained, role-based access control.
- Bound XSUAA service to CAP applications, and managed JWT token validation for authenticating incoming API requests.
- Worked with the destination service and XSUAA to configure principal propagation and technical user-based connectivity to on-premise SAP systems.
- Implemented scopes and attributes in XSUAA to restrict data visibility per user role, such as company code and plant-level filtering.
- Troubleshot 401/403 authentication errors caused by missing role assignments, token expiry, or incorrect client credentials in service binding.
- Used BTP Cockpit to assign role collections to users and groups and managed trust configuration with Identity Provider
- Familiar with client credentials flow for service-to-service, and authorization code flow for user-facing apps in XSUAA-secured environments.
- Developed production-grade CDS views with advanced annotations for Fiori applications, creating analytical and transactional data models consumed across enterprise reporting solutions.
- Designed complex CDS view hierarchies with associations, compositions, and virtual elements, implementing reusable data models for the financial, sales, and logistics domains.
- Built parameterized CDS views with input parameters and calculated fields, delivering optimized data retrieval for high-performance analytical applications.
- Implemented authorization controls and access restrictions within CDS views using DCL (Data Control Language), ensuring role-based data security compliance.
- Created metadata extensions and annotation files for UI-focused CDS views, separating data logic from the presentation layer for maintainable enterprise applications.
- Automated CDS view deployment and data extraction processes, developing custom ABAP programs for bulk data download, and backup operations across multiple views.
- Developed and extended SAP Fiori Elements applications using OData V2/V4 services, with CDS annotations covering UI, selection fields, line items, and facets.
- Configured Fiori Launchpad tile setup, including target mappings, semantic objects, and intent-based navigation.
- Annotated CDS views with UI.lineItem, UI.selectionField, UI.fieldGroup, and UI.facet to drive List Report and Object Page layouts without custom UI code.
- Consumed OData services via SAP Gateway and CDS-based services to power Fiori apps for end users.
- Worked on value help, filters, and sorting configurations through CDS annotations, and metadata extensions.
- Registered Fiori apps in SICF, and managed BSP application deployment on SAP ABAP systems.
- Familiar with SAP Fiori design guidelines across transactional, analytical, and fact sheet app patterns.
- Debugged Fiori app issues related to OData response format, missing associations, and annotation visibility on the UI.
- Built RAP-based business objects using behavior definition, with managed and unmanaged implementation scenarios.
- Developed CDS root views with compositions as the foundation for RAP business objects, supporting header-item hierarchies.
- Implemented behavior implementation classes for standard operations, including create, update, and delete, along with custom actions, validations, and determinations.
- Defined draft handling in RAP to support save and discard workflows for transactional Fiori apps.
- Exposed RAP business objects as OData V4 services using Service Definition and Service Binding for UI and API binding types.
- I wrote validations for field-level checks before saving and determinations for auto-populating fields on field change within behavior implementation classes.
- Used EML (Entity Manipulation Language) for ABAP-side RAP entity operations within business logic.
- Familiar with the RAP BO projection layer to expose a consumer-specific view of the business object, with field restrictions and aliases.
- Worked within S/4HANA on-premise and BTP ABAP environment for RAP object development and testing via ADT in Eclipse.
- Engineered automated data pipeline architecture leveraging GCS for large-scale raw and processed data storage, implementing intelligent lifecycle policies, and storage class optimization.
- Designed a multi-tier bucket strategy with versioning, retention policies, and cross-region replication, ensuring enterprise-grade data durability and disaster recovery capabilities.
- Integrated GCS with BigQuery, Cloud Functions, and Dataflow for real-time data ingestion from multiple source systems, including SAP, databases, and streaming platforms.
- Implemented secure data access patterns using IAM policies, service accounts, and signed URLs, enabling compliant data sharing across teams, and external partners.
- Orchestrated enterprise-scale ETL/ELT pipelines in Azure Data Factory, integrating diverse data sources, including SAP systems, SQL databases, REST APIs, and file-based systems.
- Developed custom activities using Azure Functions and Databricks notebooks for complex transformations requiring advanced business logic and ML integration.
- Engineered scalable ETL pipelines with Bronze, Silver, and Gold data layers, ensuring data quality, lineage tracking, and governed analytics-ready datasets.
- Built and deployed machine learning models using MLflow for experiment tracking, model registry, and automated retraining pipelines, serving business-critical predictions.
- Optimized Spark jobs through advanced techniques, including partitioning strategies, broadcast joins, caching, and adaptive query execution, for maximum performance.
- Implemented Unity Catalog for centralized governance, data discovery, and fine-grained access control across multiple workspaces and cloud storage accounts.
- Designed and executed complex ETL workflows in SAP BODS, extracting data from heterogeneous sources, including SAP ECC, HANA, Oracle databases, flat files, and web services, into centralized data warehouse environments.
- Developed automated batch job schedules with error handling, recovery mechanisms, and email notifications, ensuring reliable data loads, and maintaining data integrity across enterprise systems.
- Built reusable data transformation logic using BODS data flows, query transforms, and validation rules for data cleansing, standardization, and business rule implementation across multiple data integration projects.
SAP Hana Developer
Pythian India Private Limited
Hyderabad
03.2022 - 08.2023
- Developed sophisticated calculation views in SAP HANA Cloud, optimizing complex queries on large-scale financial and operational datasets.
- Designed advanced SQLScript procedures and functions for real-time analytics, data transformations, and business rule implementations within the HANA in-memory database.
- Developed parameterized procedures with table types, output parameters, and dynamic SQL for flexible data transformations, calculations, and multi-step analytical processing workflows.
- Built HDI (HANA Deployment Infrastructure) container-based solutions with version-controlled artifacts, enabling automated CI/CD deployments across multi-tenant cloud environments.
- Leveraged HANA's native capabilities, including spatial processing, predictive analytics, and graph processing, for advanced analytical use cases supporting executive decision-making.
- Created table functions, scalar functions, and anonymous blocks for complex data processing scenarios requiring maximum performance optimization.
- Developed comprehensive CDS data models with entities, associations, and compositions, defining complex data structures for multi-entity business applications, with relationship management using SAP CAPM.
- Implemented CDS annotations for OData capabilities, including @readonly, @insertonly, draft enablement, and value helps, creating fully functional CRUD operations with minimal custom code.
- Designed reusable CDS aspects and projections for cross-cutting concerns, like managed fields, temporal data, and currency handling, across multiple service layers.
- Built production-ready OData V4 services, exposing CDS entities with custom handlers for CREATE, READ, UPDATE, and DELETE operations, implementing complex business validation logic.
- Developed advanced OData features, including deep insert operations, batch processing, delta queries, and server-side pagination for optimal data transfer and client performance.
- Implemented custom service handlers in Node.js for complex business scenarios, including approval workflows, document generation, and integration with external REST APIs.
- Created service-level authorization annotations and custom authorization handlers, enforcing role-based access control, and instance-based security restrictions.
- Configured and administered the SAP Cloud Connector for secure hybrid connectivity, establishing encrypted tunnels between on-premise SAP systems and cloud applications on BTP.
- Created and managed diverse destination types, including HTTP, RFC, and mail destinations, across BTP subaccounts, enabling seamless integration with SAP and non-SAP backend systems.
- Configured authentication mechanisms in destinations, including OAuth2, Basic Authentication, Principal Propagation, and certificate-based authentication, for secure service consumption.
- Implemented destination service instances with instance-level and subaccount-level destinations, establishing reusable connection configurations for multi-application consumption.
- Designed destination hierarchies with environment-specific configurations, enabling seamless application promotion across development, test, and production landscapes.
- Configured and managed XSUAA (Extended Services for User Account and Authentication) service instances for multi-tenant applications, implementing role-based access control, and OAuth2 flows.
- Designed role collections, roles, and role templates with granular scopes and attributes, establishing fine-grained authorization models for cloud applications.
- Integrated XSUAA with identity providers, including SAP ID Service, Azure AD, and custom SAML IdPs, enabling single sign-on and federated user management.
- Managed application security descriptors (xs-security.) and role assignments, synchronizing authorization models across application updates, and user provisioning workflows.
- Implemented trust configurations and OAuth2 client credentials for service-to-service communication, securing API access between microservices and external consumers.
BI Consultant
Thinklokal
Hyderabad
10.2020 - 02.2022
- Migrated legacy XS Classic applications to XS Advanced architecture, transforming monolithic server-side JavaScript applications into microservices-based MTA (Multi-Target Application) deployments.
- Converted XS Classic repository-based artifacts to XSA file-system structure with HDI containers, redesigning authentication flows from .xsaccess to application router, and UAA configurations.
- Refactored XS Classic XSJS services to XSA Node.js modules, modernizing the service layer with Express.js routing and contemporary JavaScript patterns for enhanced maintainability.
- Redesigned XS Classic SQL connection models to leverage HDI container-based access patterns, with service bindings, eliminating hardcoded credentials, and improving security posture.
- Architected HDI (HANA Deployment Infrastructure) containers for multi-tenant cloud applications, implementing isolated database artifacts with automated deployment and version control integration.
- Developed comprehensive HDI artifacts, including CDS views, calculation views, stored procedures, table functions, and synonyms, with proper role-based access control configurations.
- Built granular HDI roles for object privileges, analytic privileges, and application privileges, establishing secure access patterns across container boundaries and service consumers.
- Created cross-container access patterns using synonyms and granted roles, facilitating secure data sharing between isolated HDI containers, while maintaining tenant separation.
- Led end-to-end migration of SAP HANA databases from the Neo environment to HANA Cloud, replatforming database artifacts, application services, and security configurations.
- Converted Neo-based XS Classic applications to Cloud Foundry-native XSA applications with HDI containers, modernizing deployment architecture to leverage HANA Cloud capabilities.
- Migrated database schemas, calculation views, and stored procedures from Neo tenant databases to HANA Cloud HDI containers, ensuring zero data loss, and minimal downtime.
- Redesigned authentication and connectivity patterns from Neo destinations to Cloud Foundry service bindings, updating application configurations for HANA Cloud integration.
- Validated and optimized migrated database objects for HANA Cloud performance characteristics, leveraging cloud-native features like automatic statistics collection, and workload management.
- Executed a large-scale on-premise SAP HANA to HANA Cloud migration, moving multi-terabyte databases with critical business data while maintaining production system availability.
- Designed a hybrid connectivity architecture using Cloud Connector and VPN tunnels, enabling secure communication between on-premise systems and cloud-hosted HANA databases.
- Migrated calculation views, analytic privileges, and HANA native artifacts from on-premise systems to cloud HDI containers, adapting for cloud platform capabilities and restrictions.
- Implemented data replication strategies using SAP Replication Server, SLT (SAP Landscape Transformation), and native HANA replication technologies for seamless cutover execution.
Education
Bachelor Of Technology (BTech) - Mechanical Engineering
JNTUK-UCEV
Vizianagaram04-2019
Skills
- ETL development
- OData services (S/4 HANA, SAP BTP)
- Cloud integration
- Data modeling
- Data security
- Azure Data Factory
- ABAP CDS views
- SAP BTP CAPM development
- SAP HANA Cloud development
- Google BigQuery
- Google Cloud Storage
- Azure Databricks
- SQL and databases
- Database administration
- JavaScript
- Data migration
- SAP BODS
- SAP Fiori
- RAP
Languages
English
Proficient (C2)
C2
Telugu
Proficient (C2)
C2
Hindi
Intermediate (B1)
B1
Certification
Databricks Certified Data Engineer Associate
Timeline
Data Engineer
Aarini Technologies Private Limited
09.2023 - Current
SAP Hana Developer
Pythian India Private Limited
03.2022 - 08.2023
BI Consultant
Thinklokal
10.2020 - 02.2022
Bachelor Of Technology (BTech) - Mechanical Engineering
JNTUK-UCEV