Senior Consultant (SAP DATASHERE, BW4HANA, S/4HANA, EMBEDDED ANALYTICS, SNOWFLAKE, SAC, BODS, BPC 11.0, SAP ERP, Tableau) - Eviden (Syntel Canada Inc) - ON, Canada
(2025-01)
- Integrated data from SAP and non-SAP systems (e.g., SAP BW/4HANA, S/4HANA, SQL databases, and cloud sources) into Datasphere using Data Flows, Connections, and Replication Tasks.
- Developed custom classes and methods to validate S/4HANA records against Big Query data, leveraging replication flows and virtual tables within BW/4HANA schemas for both S/4HANA and Big Query tables.
- Built analytics layer on top of data builder. Exposing data by creating data fabric layer on top of models based on business builder.
- Experience in GCP Cloud based Queries and Cloud design.
- Leveraged the existing SAP BW application's integrated planning models and used optimized planning functions in SAP HANA.
- Experience in mixed models on HANA Calculation Views & BW objects like Advance DSO, Composite Providers, Open Hub, Open ODS Views, Info objects, Key Figures, LSA, LSA++, Hybrid Models, Extraction, loading and building a BW query.
- Created HANA Calculation views based on ADSO (Physical), SLT, SDA, and SDI (Smart Data Integration) Tables (Virtual).
- HANA Modeling like Calculation Views (Dimension, Cube, Star + Join), Procedures, Table Functions, Input Parameters, Variable.
Senior Consultant (SAP DATASHERE, BW4HANA, S/4HANA, EMBEDDED ANALYTICS, SNOWFLAKE, SAC, BODS, BPC 11.0, SAP ERP, Tableau) - Infosys Limited - Mississauga, ON, Canada
(2022-01 - 2025-01)
- Integrated data from SAP and non-SAP systems (e.g., SAP BW/4HANA, S/4HANA, SQL databases, and cloud sources) into Datasphere using Data Flows, Connections, and Replication Tasks.
- Designed end-to-end data architecture designing covering data acquisition, modeling, security, and consumption in Datasphere, SAC, and hybrid BW/4HANA landscapes presenting with Blue-Print Diagram Design document.
- Worked on space management & data source connection to spaces with space allocation.
- Created Entity Relationship models after joining Tables/Nodes, maintaining associations. Deployed/Created Data Models after data preparation.
- Developed custom classes and methods to validate S/4HANA records against Big Query data, leveraging replication flows and virtual tables within BW/4HANA schemas for both S/4HANA and Big Query tables.
- Built analytics layer on top of data builder. Exposing data by creating data fabric layer on top of models based on business builder.
- Experience in GCP Cloud based Queries and Cloud design.
- Designed and implemented data models in SAP Datasphere, including semantic layer modeling, views, and transformations to support enterprise reporting and analytics.
- Optimized data performance through partitioning, query tuning, and efficient modeling practices to ensure scalability and high availability.
- Collaborated with business stakeholders to translate reporting requirements into end-to-end data pipelines and dashboards.
- Ensured data governance, security, and access control by implementing spaces, roles, and authorizations in Datasphere.
- Migrated legacy data models from SAP BW/4HANA to SAP Datasphere, enabling cloud-based analytics with minimal downtime.
- Conducted performance tuning and validation of queries in SAC and Datasphere to deliver real-time insights.
- Managed Alerts after converting Attributes to Measures, for performing Calculations for Graphs/Charts, in Data Story Builder.
- Good experience in data flows, replication flows, transformation flows, task chains.
- Leveraged the existing SAP BW application's integrated planning models and used optimized planning functions in SAP HANA.
- Worked on Designing Embedded planning objects of Actual Sales, Budget and Forecast Values for the Sales Flash report, also performed aggregation, Planning Function for Revenue Planning based Profit Center and Cost Center to retrack back to Simple Finance for Sales.
- Experience in mixed models on HANA Calculation Views & BW objects like Advance DSO, Composite Providers, Open Hub, Open ODS Views, Info objects, Key Figures, LSA, LSA++, Hybrid Models, Extraction, loading and building a BW query.
- Created HANA Calculation views based on ADSO (Physical), SLT, SDA, and SDI (Smart Data Integration) Tables (Virtual).
- HANA Modeling like Calculation Views (Dimension, Cube, Star + Join), Procedures, Table Functions, Input Parameters, Variable.
- Developed and executed SAP Analytics Cloud solutions, enabling real-time data visualization and analysis for business stakeholders.
- Built embedded SAC queries, consuming data from S4HANA.
- Created fact models and consumption models for consumption in SAC dashboards.
- Worked with Input Filters / Linked Analysis, in Story Creation Built Semantic Layer on top of Data Model using Data Builder.
- Incorporated mixed modelling from BW/4HANA to SAP HANA, resulting in improved performance and reduced data latency.
- Designed and optimized data models in SAP BW/4HANA, enhancing data warehousing capabilities.
- Created the full data flow by creating Generic and Standard Data Sources from ECC, S/4HANA to replicate to BW4HANA using ODP/ODQ, CDS Views and SDI.
- Integrated SAP Embedded Analytics into core business processes, enabling data-driven decision-making.
- Created and maintained SAP CDS Views for efficient data retrieval and reporting.
- Collaborated with cross-functional teams to gather business requirements and translate them into SAP Technical solutions.
- Customized Data Sources are created based on CDS Views from S/4HANA system.
- Modeler on Hybrid Scenario of Composite Provider with ADSO, HANA Calculation Views to satisfying the Internal Models like MM, SD, Logistics and Financial data reports.
- Worked extensively on all the main modules of P2P, O2C, R2R, BPC and CA reports.
- Add ABAP, AMDP code in Start, End Routine, and Infoobjects by Infoobjects in Transformation, CMOD and Custom Exit.
- Created Consolidated data of Actual, Forecasting and Planning data in SAC as Model and Dashboard for Sales Flash Reports in SAC and Tableau.
- Developed SAP Analytics Cloud analytics solution involving data wrangling, multi model set up, story development, Story, Dashboard development and KPI's for multiple streams of reporting and business units and replicated same in Tableau.
- Conducted workshops and training sessions to educate end-users on SAP analytics tools and best practices.
Software Engineer (SAP HANA, BW4HANA, SAC, SAP ERP, SACP) - Maersk Global Service Limited - Bengaluru, KA, India
(2022-01 - 2022-12)
- Performed end-to-end Implementation for the GRC model - Creating Information Models like Dimension - Calculation Views to Master Data, (Cube& Star) - Calculation Views for fact tables & Star Schema modeling using Tables and ADSOs.
- Created Table Functions, Stored Procedures, and Decision Tables for complex logic and better performance.
- Supported the GRC team to create Privileges based on the user privileges like system client, and Landscape.
- Involved in Transportation support for moving delivery unit (DU) from Development to QA and Production system.
- Expertise in Open ODS View, Composite Providers, mixed BW vs HANA models, Info objects, Key Figures, LSA++, AMDP start and end routines, BW Data Flows, and BW Queries.
- Developed Data Source using CDS views and replicated to BW4HANA, replicated data source from ODP/ODQ.
- Worked on Performance tuning on HANA Models using Explain and Visualize plan.
- Connecting various on-premises and cloud databases with Analytics cloud.
- Experience in BEx Query Designer, SAP BO BI 4.2 and above, WebI, Analysis Office to run and validate BW query reports.
- Experienced in stories, Datasets, Modelling, blending data, formulas, cross calculations, input controls, and linked analysis.
- Well-versed in visualizations and their usage charts, tables, maps, filters, and Smart In Sights.
Advisory Consultant (SAP HANA, BW4HANA, BWonHANA, SAC, DWC, Tableau, SAP ERP) - IBM India Private Limited - Bengaluru, KA, India
(2017-01 - 2022-01)
- Worked on various end-to-end implementations in SAP HANA 2.0 SP4, BW4HANA, Mixed data modeling using BW on HANA Calculation View, Advance Modelling, and performance tuning using Explain & visualize plan.
- Experience in Calculated Measure and Restricted Measure in Aggregation Node to serve different granularity.
- Created Classic/SQL Analytics Privileges and roles based on country and region, based on system client ID, and Landscape.
- Involved in designing and developing Composite Providers, Advance DSOs, Cubes, and BW queries for various SAP models.
- Created Dynamic Join, Keep & Transparent Flag Filter according to business KPIs requirements.
- Created Technical specifications based on Functional Spec/ Business Requirement documents for HANA.
- Experience in BW Query design and pushing it to SAC live.
- Experience in BEx Query Designer, SAP BO BI 4.2 and above, WebI, Analysis Office to run and validate BW query reports.
- POC has been done in Data Warehouse Cloud (DWC) for the client.
