Nimisha Gandhi

SAP Data & Analytics leader with 20+ years of experience architecting and delivering enterprise data, analytics, and planning platforms on SAP Datasphere, SAP Analytics Cloud, BW/4HANA, native HANA, and S/4HANA. Combines hands-on solution architecture with delivery leadership, taking programs from discovery and blueprint through build, testing, cutover, and hypercare for global clients including Novartis, Unilever, Amtrak, and the United Nations. Known for turning complex business requirements into governed, trusted data that finance, supply chain, and sales leaders use to run the business.

Architected a greenfield SAP Datasphere platform that cut data duplication by 50% and reporting inconsistencies by 95%. Led 3 BW on HANA migrations for $2B-$10B clients at 99.99% accuracy, on time and within budget. Delivered SAC dashboards and planning models, BPC consolidation for 20 entities in 15 countries, and finance reporting on $5B of GL data, 80% faster.

Leads hands-on technical teams of up to 30 across countries, sets BI strategy and roadmaps, and reports to CXO stakeholders.

SAP Analytics Lead - Panzer Solutions LLC (IBM Implementation Partner)

(2024-04 - 2025-03)

SAP Datasphere greenfield, BW/4HANA analytics, and BW migration

• BI leadership
• Defined the BI strategy and analytics roadmap across Datasphere, SAC, and BW/4HANA, prioritizing use cases and allocating resources across modeling, integration, reporting, and testing workstreams.
• Led and managed an onshore/offshore team of BW, Datasphere, and SAC developers while staying hands-on in modeling and ABAP, owning work allocation, design reviews, and delivery against plan.
• Resolved conflicting KPI definitions across Finance, Sales, and Supply Chain by setting up one governed catalog of 70 KPIs with named business owners and executive sign-off, cutting reporting inconsistencies by 95%.
• Supported enterprise reporting across SAP and non-SAP sources for Finance, Sales, and Supply Chain leadership.
• Datasphere greenfield implementation
• Led end-to-end design of a greenfield SAP Datasphere platform, consolidating S/4HANA, BW/4HANA, and non-SAP sources into one semantic layer.
• Built Replication Flows with delta from S/4HANA CDS views, Transformation Flows, and Task Chains for daily orchestration.
• Modeled graphical and SQL views with Fact, Dimension, and Hierarchy semantics, exposed through Analytic Models with variables.
• Tuned performance with view persistency and partitioning, and managed transports across dev, QA, and production tenants.
• Designed a layered inbound, harmonized, and consumption architecture, sharing objects across Spaces instead of copying data.
• Set up the Datasphere Catalog for KPI definitions, data ownership, and lineage, supporting governance and impact analysis.
• Ran 10+ discovery workshops with 7 stakeholder groups, turning KPI requirements into models that cut data duplication by 50%.
• Implemented 3 Datasphere Spaces with row-level security and data quality monitoring, lifting adoption 60% and accuracy to 99.5%.
• Built 7 SAC stories and blueprinted 30 executive dashboards and 10 planning models, automating 50+ KPIs and saving 90 hours/month.
• Developed ABAP in Eclipse ADT: extraction-enabled CDS views with delta for Replication Flows, AMDP expert routines, and OO reconciliation utilities.
• Designed Datasphere models and SAC dashboards for end-to-end Order-to-Cash visibility on S/4HANA SD data.
• BW/4HANA analytics solutions
• Designed and implemented SAP BW/4HANA analytics solutions, modeling aDSOs, CompositeProviders, and Open ODS Views with BW queries (RKFs, CKFs, variables, hierarchies) feeding SAC dashboards for Finance, Sales, and Supply Chain.
• Built SAC dashboards on BW/4HANA live connections for Finance (P&L, balance sheet, cash flow, AR aging), Sales (bookings, billing, backlog), and Procurement (spend, PO cycle time, supplier performance).
• Delivered SAC dashboards for Inventory (stock value, days of cover) and Production (plan vs. actual, yield).
• Integrated S/4HANA embedded analytics with BW/4HANA, extracting delta-enabled CDS views via ODP into aDSOs for historical reporting and virtualizing real-time S/4HANA data through Open ODS Views and CompositeProviders, giving one consistent KPI layer.
• Built BW/4HANA process chains with alerting and applied Data Tiering Optimization to manage aDSO volumes.
• Implemented BW/4HANA analysis authorizations by company code and profit center, aligned with Datasphere DACs.
• Exposed BW/4HANA models as external HANA views and tuned Finance queries with RSRT and OLAP push-down.
• BW migration and cutover
• Migrated on-premise BW reporting to BW/4HANA, Datasphere, and SAC, including Finance reports on ACDOCA (trial balance, P&L by profit center, GL line items) and BW reports such as BEx sales, inventory, and procurement queries.
• Drove mock migrations, UAT, and automated reconciliation, defined freeze governance, led the ~30-hour cutover as go/no-go decision-maker, and ran 4 weeks of hypercare.

SAP BW/4HANA Lead - Neorchin Inc (TCS Implementation Partner)

(2021-07 - 2023-10)

• Led full-lifecycle BW/4HANA delivery and managed a team of 10 SAP developers (work allocation, design and code reviews, mentoring) while hands-on in CDS, HANA, and ABAP development.
• Led the BW on HANA to BW/4HANA migration using SAP Readiness Check and the Transfer Cockpit, moving data flows, queries, and security roles and reconciling results before cutover.
• Built S/4HANA Embedded Analytics for Record-to-Report on the Virtual Data Model, developing composite and consumption CDS views, analytical cubes and queries, and DCL access controls for 20+ finance partners, cutting report development time by 50%.
• Extended standard VDM views such as I_JournalEntryItem and I_GLAccountLineItem with custom associations and analytical queries consumed in Fiori analytical apps and SAC.
• Developed AMDP transformations, ABAP end routines, fiscal-period and YTD exit variables, and SD/FI DataSource enhancements.
• Built generic DataSources with delta, BAdIs, and enhancement spots, optimizing ABAP with hashed tables, parallel processing, and ABAP Unit tests.
• Designed 15 HANA models and 40 graphical calculation views (dimension, cube, star join) for MM and SD reporting on $200M.
• Built HANA calculation views on ACDOCA for GL, profit center, and margin reporting, with ledger filters, carryforward balances, and FS hierarchies.
• Developed HANA views for shipment manifests and returns, tracking shipped vs. returned quantities, return reasons, and transit times.
• Created SQL views and SQLScript table functions for reusable logic, consumed by calculation views and CompositeProviders.
• Optimized ETL from 12 source systems into BW/4HANA and published 200 HANA models to BW for 600 self-service users.
• Monitored SLT replication and BODS batch loads into BW/4HANA, resolving load failures with source teams.
• Gathered 50+ requirements with 15 finance stakeholders for 10 OTC, Finance, and P2P dashboards.

SAP Native HANA Analytics Lead & BW on HANA Migration Lead - Dice Technologies

(2020-01 - 2021-06)

• Led 3 end-to-end BW 7.5 on HANA migration programs for $2B-$10B clients, all milestones on time and within budget.
• Planned 12-18 month programs with 200-500 tasks across 5-10 workstreams, managing 20 risks and weekly reporting to 10 CXOs.
• Engineered a hybrid BW/4HANA and native HANA architecture for $5B of GL data, making close and reporting 80% faster for 200 users.
• Wrote SQLScript procedures for finance allocation and currency logic in the hybrid model, consumed by BW CompositeProviders.
• Supported SLT real-time replication of S/4HANA finance tables into HANA, including setup and monitoring.
• Integrated S/4HANA and sub-ledger finance data into BW/4HANA via SDA and SDI, published to BW Workspaces.
• Remediated custom ABAP for HANA, replacing row-by-row loops and nested SELECTs with set-based Open SQL.
• Led teams of 20-30 testing 500 reports, 50 planning applications, and 200 security roles to 99.99% migration accuracy.

SAP Analytics Cloud & BW on HANA Implementation Lead - Dice Technologies

(2018-02 - 2019-12)

• Led a greenfield SAP Analytics Cloud implementation with S/4HANA Cloud integration and executed the SAP BW 7.5 on HANA upgrade.
• Ran 20 solution demos and 15 knowledge-transfer workshops for 50 users, raising analytics competency 40% and cutting tickets 30%.
• Developed 5 BW on HANA proofs of concept across Finance, Sales, and Supply Chain that accelerated project approval.
• Managed ETL with SAP BODS (Data Services), loading multiple source systems into BW on HANA.

SAP BW & BPC Project Lead | Client: Novartis (Pharmaceut - Accenture - India and USA

(2010-07 - 2018-01)

BCom - Mithibai College, University of Mumbai, India (2003)