Rohan Jain

Dynamic SAP/Snowflake Solution Architect with a proven track record, specializing in data solutions and analytics. Expert in SAP Analytics transformation and modernization using modern SAP & non SAP stack, leading teams to deliver impactful results. Strong problem-solving skills and a commitment to continuous improvement drive successful project outcomes in complex environments.

• Microsoft Certified: Azure Fundamentals
• SAP Certified Associate – Data Engineer – Data Fabric
• Alation Data Governance Advocate
• SAP Certified Professional - Solution Architect - SAP BTP
• Snowflake: SnowPro Core Certified
• Alteryx Foundational – Micro Credential
• Microsoft Certified : AI Fundamentals
• PCEP – Certified Entry Level Python Programmer
• Certified Application Associate – SAP HANA 2.0
• Certified SAFE 6 Agilist/POPM.
• Scrum Alliance : Certified Scrum Product Owner ( CSPO)
• SAP BTP – Backend CAPM Developer
• Tableau Desktop Specialist
• JSE – Certified Entry Level Javascript Programmer

• Created HANA Models, Stored Procedures using Classical and Cloud HANA.
• Worked on Functions, Procedures, SQL Script and designed Side by Side Extension application in BTP.
• Created HANA DB triggers, constraints for Data models validations.
• Created Hybrid Models and Side car HANA models.
• Worked on CDS for CAPM Framework for SAP BTP.

• SnowPro Core Certified.
• Fed data from AZURE Services to Snowflake for Power Bi Consumption
• Created Data pipelines from SAP following Medallion Architecture.
• Experience of Migrating SAP BW to Snowflake while performing Reverse Engineering of BW systems, Designing DS Jobs , Creating Data Models, Propagating Data to Analytical Views.
• Worked on Data transformation using DBT while maintaining version control with Azure Devops
• Used SNP Glue for Data Ingestion from SAP to Snowflake and designed Data model following Medallion Architecture.
• Replicated SAP T codes like KSB1, ME2K, VA05 in Snowflake using Dynamic Tables.
• Created models for SAP data using DBSCHEMA

• Created Workflows for ODP Extractors for Data Ingestion for Data Lake Project.
• Replicated SAP Tables from HANA thru ADF and created Delta Scenario using CDHDR for MDM DB2 Data Base Consumption
• Part of the Development Team for Replication of BI Reports in AZURE Analytics Services.
• Used Data ingested from BODS into Infosteward to set up Data Quality Scorecards.
• Created lineage

• Created Power BI Reports for Scraps Reporting for QM Team.
• Created Data Sets and refreshed them for better performance optimization.
• Created Power BI Dashboard to monitor System Usability.

• Architected solutions and Road map for BW to Snowflake Migration.
• Designed solutions using BODS, ADF and Snowflake.
• Worked with ETL tools like SNP Glue for Data replication from SAP to Snowflake.
• Designed Data Models and provided guidance in implementation using DBT.

• Created Demo Dashboards using SAC & Datasphere Feed for Sales.
• Created Analytical Data sets, Dimensions, Fact Models, Consumption Models using Data Builder, Business Builder in Datasphere and utilized the data in SAC to Create Choropleth Geo Spatial Sales Analysis Stories.
• Converted BW Objects using Shell Conversion for BW Bridge
• Replicated BW Analysis Authorization Objects in Datasphere
• Implemented BTP Data extractors for ARIBA and Successfactors for SAC Dashboards.

• BEx reports (Query building, query Properties, variable creation, currency translation creation, exception display, Conditions, Calculated KF, Formula KF etc), performance optimization.
• Designed Dataflows using Hybrid Modelling with HANA.
• Activation and Installation of Business Content data sources in R/3 for SD, MM, Finance, Purchasing etc.
• Worked on 7.4 BWonHANA , BW4HANA 2.0

• Strong experience in designing the BPC planning and consolidation model, Controls, Journals, Environment, Dimension.
• Created complex Planning sequence and used IP standard planning functions and Fox formula.
• Worked on the Capex and Opex scenario to deliver in SAP BPC
• Experience on developing solution for the cashflow planning and P&L planning to derive Balance sheet planning. Hands-on BPC experience on Planning design and configuration (reports, input schedules, script logic, badi customization, allocations, distributions, trending, etc)

• Created ABAP CDS Views, Analytical Queries and used them in Multidimensional Reports in Fiori Launchpad.
• Designed Virtual Data Model Architecture and Template for Reuse.
• Exposed CDS Views to Enterprise SAC for Reporting.

• Worked in Nearshore environment from Montevideo, Uruguay for 1.5 years.
• Worked for Building Construction Material Company in Tennessee, US for 1.5 Years.
• Visited Manufacturing Plants in Germany to Understand Business and BI Requirements.
• Presented Sales Pitch for Data & Analytics at Client Premises in Netherlands for RFP.

• Worked with Clients from FMCG, Oil n Gas, Manufacturing, Automotive, Chemicals.
• Exposure of working in IT as well as Automotive Industry.