Sangey Lama

SAP Data & Analytics Developer with 4+ years of experience delivering end-to-end reporting, planning and data-integration solutions across SAP Analytics Cloud, SAP Datasphere, SAP BW, S/4HANA and SAP HANA Cloud. Experienced in developing ABAP CDS Views, designing SAC reporting and FP&A planning applications, and supporting enterprise data pipelines from S/4HANA through Datasphere and ADLS to Databricks and Power BI. Strong hands-on expertise in Replication Flows, full and delta extraction, Task Chains, financial and inventory modelling, data reconciliation, performance optimization and production issue resolution.

SAP Datasphere Engineer | ABAP CDS Developer at Celebal Technologies (2026-01 – Present)

• Supported an enterprise data pipeline moving data from SAP S/4HANA to SAP Datasphere through ABAP CDS Views, landing data in ADLS Gen2 through Replication Flows for downstream processing in Databricks and Power BI.
• Created and configured Replication Flows for S/4HANA transactional and master-data objects, using direct table extraction where supported and standard or custom ABAP CDS Views where required; configured CDS extraction as full load or delta load based on source-table characteristics and business requirements.
• Developed custom ABAP CDS Views for Inventory Balance & Movements and Inventory Stock Quantity & Valuation, covering unrestricted-use stock, quality-inspection stock, blocked stock, vendor consignment or subcontracting stock, goods in transit (GIT) and work in progress (WIP); validated outputs against stock-specific S/4HANA tables and standard transactions including MB52, MMBE, MB5T, MB5L and KKAO/KKAX.
• Created a new SAP Datasphere space by replicating the existing space architecture and deploying the required connections, tables, views, Replication Flows and Task Chains.
• Transported Datasphere objects across DEV, QA, PRE-PROD and PROD, validating deployments and maintaining object-count and configuration synchronization across tenants and corresponding spaces.
• Monitored and validated 450+ Replication Flows, including more than 250 full-load flows and 200 delta-load flows, consistently reconciling extracted row counts and investigating load failures and data variances.
• Created and maintained Task Chains to schedule all full-load Replication Flows, identifying unscheduled objects, correcting execution dependencies and improving operational coverage.
• Performed production and pre-production validation for Replication Flows, Task Chains and transported objects, ensuring that deployments remained synchronized across two spaces.
• Investigated CDC failures, stopped Replication Flow runs, delta inconsistencies, object deployment issues and space-table lock conflicts; documented root causes and remediation evidence for project stakeholders and SAP support.

SAP Analytics Cloud Developer at R.G. Technologies (2022-03 – 2026-01)

• Designed and delivered the Product Owner Dashboard (PODB) in SAP Analytics Cloud by integrating SAP BW and external data sources, providing business users with insights into sales performance, point-of-sale trends and gross margin.
• Built a custom SAC Stories landing page as a centralized analytics hub and developed interactive visualizations using thresholds, conditional formatting, input controls, linked analysis and dynamic KPI selection.
• Created Restricted Measures and Cross Calculations for YoY, MTD, WTD and YTD analysis, and developed Gross Margin reporting across product, region and customer dimensions.
• Designed analytical models using dimension tables, hierarchies and public dimensions, enabling governed and reusable master data for self-service reporting.
• Implemented Pareto (80/20) Analysis using JavaScript scripting, automated data loads through scheduled Import Jobs, reconciled SAC results with SAP BW BEx Queries, and enforced row-level access using users, teams and Data Access Controls.
• Designed and developed SAP Analytics Cloud FP&A models supporting Income Statement (P&L), Balance Sheet and Cash Flow planning, with defined dimensions, measures, versions and planning granularity.
• Created reusable public dimensions for GL Account, Company Code, Cost Center and Profit Center, including master-data properties and multiple account hierarchies for financial planning and reporting.
• Created the Financial Statement Version (FSV), Cost Center Groups and Profit Center Groups in SAP S/4HANA, identified the required standard CDS Views, and configured Import Jobs to load master data into SAC.
• Developed driver-based input templates to capture cost-center expenses, profit-center revenues and allocation percentages for budgeting, forecasting and allocation processes.
• Created Data Actions and Multi Actions for cross-model copy, allocations, version processing and sales-commission calculations using conditional business logic.
• Developed calculated account members and inverse formulas to support data entry on calculated values and formula-based financial statement nodes.
• Configured scheduled Import Jobs to load daily actuals from SAP S/4HANA and enabled currency conversion using client-managed exchange rates sourced through standard S/4HANA CDS Views.
• Developed SAC Stories for plan-versus-actual, forecast and variance analysis across account, company code, cost center and profit center levels.
• Optimized SAC models and Stories, resolved post-go-live issues, prepared Blueprint and Functional Specification Documents, and coordinated delivery through Agile Scrum boards and sprint-based tracking.

Bachelor of Technology in Information Technology – Jalpaiguri Government Engineering College (2018-08 – 2022-05)