Sayana Ganesh
Dallas,TX
Summary
Data Analytics Senior Consultant with around 14+ Years of experience in SAP BW4HANA, SAP BW, SAP Native HANA, Analysis for Office, SAC & SAC Planning, SAP Data Sphere, SAP S/4 HANA Embedded Analytics, and SAP BO. Worked on end-to-end life cycle implementations, Migration, and Support Engagements. Experience in building robust data warehouse & reporting solutions for various industry verticals like FMCG, pharmaceutical, manufacturing, conglomerate holding, marketing, and power utility. Built Models & reports in different functional modules of SAP application areas like P2P, RTR, OTC, Inventory, COPA, PM, AR, AP, FPSL, CO & GROUP Reporting. Strong Experience in Project management with Planning, coordination, Analytical & skills, for quick adaptability to technology and working environments. Proven ability to manage a team and work efficiently in both independent and team environments. Maintaining the queue – related to the system-generated tickets and customer-generated tickets. Managed BW and BOBJ teams and executed the transition of the project from Implementation to Production support team.
Overview
14
14
years of professional experience
Work History
Sr SAC, Data Sphere Consultant
HBR Analytics & BI Solutions, LLC
05.2025 - Current
- Integrated data from SAP S/4HANA, non-SAP systems into SAP Datasphere for unified reporting and analytics.
- Expertise to develop tables, graphical views, SQL views, and analytics models with Data Builder and use them with the SAC AO plugin to generate reports.
- Expertise to develop Fact Models, Consumption Models and Perspectives with Business builder.
- Creation of Replication Flow, Dataflow and Analytics Models in Data Builder
- Build the SAC AO reports on top of Analytical Models
- Developed Master data and Transaction data flows like Billing, Sales, Delivery, Finance, and Inventory.
- BI work effort estimation, documentation, managing deadlines, and coordination of project team and sub-team activities.
- Arranging cadence calls, Project status updates to management.
- Prepared Technical specifications.
- Involved in the complete development of HANA views on top of ECC tables.
- Created HANA views for Sales, Supply Chain, Manufacturing, and Finance functional areas.
- Utilized existing SAP HANA live solution for the new developments and reduced the redundancy.
- Involved in the creation of Analytical privileges, Currency conversions, and UOM unit of measure conversions.
- Coordinated and executed User Acceptance Testing (UAT), ensuring system functionality and data integrity, while facilitating business user testing and validation.
- Developing the Data flows from non-SAP system, like S3 Bucket, to Datasphere.
- Utilized SAP Data Sphere’s Data Flows and Replication Flows to integrate data from GCS for building unified data models
- Developing the Data flows from non-SAP systems, like S3 Bucket, to Datasphere.
- Delivered end-to-end analytics solutions using SAP Datasphere.
- Project #9
- Client: HBR Analytics & BI Solutions LLC / Warner bros
- Role: SAP Data Sphere & BW4HANA Consultant
- Duration: May’2025 – Present
SAP Data Sphere & BW4HANA Consultant
HBR Analytics & BI Solutions Ltd/Himalaya Wellness
01.2023 - 04.2025
- Implemented SAP Datasphere for seamless data integration and transformation, enhancing data quality and accuracy.
- Experience in developing a Planning & Analytical model in SAC. Consume HANA views, CDS Views & Flat Files for ETL.
- Experienced SAC as a planning tool, creating planning data models and working with categories actual, budget, planning, forecast, rolling forecast, predictive capabilities.
- Configure the connection between SAP HANA to SAC.
- Conducted workshops with business heads & SAP functional teams to define KPIs, to identify source logics, and develop project functional spec and technical spec documents
- Created custom CDS views in Plant Maintenance and built a dashboard in SAC.
- Worked with business heads & ERP development teams to define KPIs, to identify source logics, and develop project functional spec and technical spec documents.
- Responsible for solution architecture & project deliverables.
- Worked on KPIs related to Sales, Finance, Purchasing, Plant Maintenance, Success Factor, and Profitability analysis
- Working as a BW4 Solution Architect and responsible for distributing work and deliverables
- Conducted workshops with business heads & SAP functional teams to define KPIs, to identify source logics, and develop project functional spec and technical spec documents
- Worked on HANA modelling and built models in Finance GL line items, GL Totals, AR, AP, SD, and Inventory applications.
- Design, implement, and support data modelling solution in SAP BW4/HANA, requiring integration of data from SAP and non-SAP data sources, and support deployment of SAP application
- Created Calculation views for Query views, Reusable views, and Master data views
- Built different financial statements and created an Income statement, Balance sheet, Trial Balance, and cash flow reports
- Loaded HANA views data to ADSO to improve query performance
- Worked on Table functions to aggregate data by string /Characteristic.
- Worked on HANA modelling and Performance tuning. Fixed Memory allocation issues & long runtime issues in multiple models
- Worked on Complex scenarios and transposed data in transformations.
- Extensively worked on different routines and written custom transformation logics
- Extensively worked with user exit variables, unit/Currency conversions at the report level, and different BEX components
- Worked on Scalar Functions, Input parameters, and variables in HANA modelling
- Extensively worked on Analysis for office reports and have deep working experience on AFO features
- Worked with Basis & Security teams during the transportation of objects to QA & Production
- Extensively used the service now and Jira tools for Incident & Change requests.
- Worked SAC Planning import model and built the Head Count & Expenses planning input forms
- Project #8
- Client: HBR Analytics & BI Solutions Ltd/Himalaya Wellness
- Role: SAP Data Sphere & BW4HANA Consultant
- Duration: Jan’2023 – April’2025
Senior SAP BW on HANA Analytics Consultant
L&T Infotech /Johnson & Johnson
11.2021 - 01.2023
- Created TS/Test cases templates, migrated objects across the landscape
- Gathered the requirements from Business users during change requests
- Worked with Business content extractors for General Ledger, Accounts Payable & Accounts Receivables to extract data from SAP R/3.
- Involved in the Generic Extraction of Tables, Views, and Function Modules
- Built LO Cockpit, FI, and CO extraction for different data sources
- Created reports with different KPIs for Sales, Purchasing, and FICO data flow
- Creation of new objects and involvement in the transportation of the developed objects to the further system for testing purposes.
- Set up the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management for the SD Application.
- Involved in the Creation of Composite Providers, ADSO.
- Analysed the complex ABAP routines and documented the logic for the GCP tea
- Project #7
- Client: L&T Infotech /Johnson & Johnson
- Role: Senior SAP BW on HANA Analytics Consultant
- Duration: Nov’2021 – Jan’2023
Senior SAP BW on HANA Analytics Consultant
Capgemini /PETRONAS
05.2019 - 10.2021
- Experience in importing BW models, Info Cube, DSO in HANA as Analytical view, Calculation view.
- Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes.
- Worked extensively on composite providers, Advanced DSO, and Open ODS View.
- Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data, Calculation Views, and the various Attribute and Analytic Views for report consumption with time dimensions.
- Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data, Calculation Views, and the various Attribute and Analytic Views for report consumption with time dimensions.
- Extensively worked on the back-end data model to fetch SAP data and non-SAP data into SAP HANA tables.
- Involved in the creation of calculated attributes, measures, Restricted measures, Calculated columns, filters, and variables, satisfying reporting requirements using SAP HANA.
- Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data, and Calculation Views, and the various Attribute and Analytic Views for report consumption with time dimensions.
- Experience in extracting data from SAP R3/ECC, non-SAP systems, and flat files
- Designed and developed automated Process Chains to reduce manual intervention and was actively involved in data load monitoring
- Project #6
- Client: Capgemini /PETRONAS
- Role: Senior SAP BW on HANA Analytics Consultant
- Duration: May’2019 – Oct’2021
Senior SAP BW on HANA Consultant
Capgemini/HOLCIM Services
07.2017 - 05.2019
- Led SAP BW & BOBJ solutions for Carrier, North America & its joint venture with Midea China.
- Developed KPIs related to different functions: SD, MM, FI, COPA & LO
- Responsible for fixing business-critical, high-incidents, Monitoring Daily loads, and Scheduling Reports to Key user Groups
- Identified risk & process improvement required areas & Implemented alternative Datawarehouse solutions to ensure better performance and stability
- Involved in Migration strategy to migrate reports from BW on Oracle to BW on HANA
- Executed Weekly Status update calls with Project Sponsors & Other stakeholders
- Transitioned CMNA JV reports to Carrier SAP BW support Team.
- Project #5
- Client: Capgemini/HOLCIM Services
- Role: Senior SAP BW on HANA Consultant
- Duration: July’2017 – May’2019
SAP Senior BW Consultant
Wipro/Wal-Mart Global Technology
09.2016 - 06.2017
- Responsible for Data migration from Guidewire, Insurance ERP, to the Data Hub system using SAP Business Objects data services
- Conducted source logic discussions with Onsite Business Analysts and prepared technical documents
- Led the SAP data services offshore team
- Responsible for data services objects development, deployment & automating data loads
- Developed Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup, etc. in Data flows
- Created multiple data store configurations in Data Services local object library with different databases to create a unified data store.
- Developed models for policy center, billing centers, and claim center
- Project #4
- Client: Wipro/Wal-Mart Global Technology
- Role: SAP Senior BW Consultant
- Duration: Sep’2016 – Jun’2017
SAP BW Consultant
Accenture/Dow Chemicals
08.2014 - 01.2016
- Lead SAP BI Consultant, responsible for the successful delivery of reporting.
- Worked with business users to gather requirements, developing project functional spec and technical spec documents. Assigning work to team members for efficient and fast delivery of results.
- Working on reports related to FI-AA, FI-AR, FI-AP, FI-GL, MM, CO, and SD modules
- Worked on the project timeline & worked along with the team to deliver as per the timeline
- Worked on Transaction and master data source enhancements and developed generic data sources
- Installed & customized business content objects to meet report requirements.
- Worked extensively on Different routines to achieve complex transformations
- Worked on different BEX variables with processing types like customer exit, replacement path, and formula
- Created Cell definitions, conditions, formula collision, Restricted Key Figures, Calculated Key Figures, and Filters.
- Project #3
- Client: Accenture/Dow Chemicals
- Role: SAP BW Consultant
- Duration: Aug’2014 – Jan’2016
SAP BW Consultant
Accenture/JSW
11.2012 - 07.2014
- Working as a BW4 Solution Architect and responsible for distributing work and deliverables
- Conducted workshops with business heads & SAP functional teams to define KPIs, to identify source logics, and develop project functional spec and technical spec documents
- Design, implement, and support data modelling solution in SAP BW4/HANA, requiring integration of data from SAP and non-SAP data sources, and support deployment of SAP application
- Worked on HANA modelling and Performance tuning. Fixed Memory allocation issues & long runtime problems in multiple models
- Created Calculation views for Query views, Reusable views, and Master data views
- Designed Mixed modelling using ADSO & HANA models for complex scenarios.
- Built different financial statements and created an Income statement, Balance sheet, Trial Balance, and cash flow reports
- Worked on HANA modelling and built models in Finance GL line items, GL Totals, AR, AP, SD, and Inventory applications.
- Loaded HANA views data to ADSO to improve query performance
- Worked on Table functions to aggregate data by string /Characteristic.
- Extensively worked on different routines and written custom transformation logics
- Extensively worked with user exit variables, unit/Currency conversions at the report level, and different BEX components
- Worked on Scalar Functions, Input parameters, and variables in HANA modelling
- Extensively worked on Analysis for office reports and have deep working experience on AFO features
- Project #2
- Client: Accenture/JSW
- Role: SAP BW Consultant
- Duration: Nov’2012 – July’2014
SAP Consultant
Accenture/Coke BIG SI [Support]
11.2011 - 10.2012
- Daily monitoring of Process Chains and data Loads.
- Handling the issues on data loading and Extraction
- Worked extensively on creating BI objects and Extractors.
- Worked on generic extraction using Info set on the table, multiple tables to extract data from SAP
- Worked on performance tuning techniques to Improve Report performance
- Created Aggregates on frequently used characteristics like Material, Sold-to-party, fiscal year period, Business Area, Sales organization
- Maintaining Reconciliation to verify whether the data in SAP R3 and SAP BW are the same or not every month
- Experienced in working with Business Explorer (BEx) and publishing the reports enterprise portal
- Performed various tuning techniques (PSA deletion, aggregates, Compression, partitioning) to optimize the query performance
- Resolved different priority Remedies assigned without missing SLA.
- Project #1
- Client: Accenture/Coke BIG SI [Support]
- Role: SAP Consultant
- Duration: Nov’2011 – Oct’2012
Education
Mechanical Engg -
Dr. M.G.R. Educational And Research Institution
Chennai, India05-2007
Skills
- SAP SAC Planning:
- Experience in developing Planning & Analytical model in SAC Consume HANA views, CDS Views & Flat Files for ETL
- Configure the connection between SAP HANA to SAC
- Create calculation views (Virtual tables, base views, reuse views, reporting views)
- Extensive experience in data modeling and preparing datasets, merging, appending, hierarchies, custom calculations, formatting values, data wrangling, dimensions and measures
- Experience in creating stories canvas, grid, formulas, cross calculations, input controls, linked analysis
- Experienced SAC as a planning tool, creating planning data models and working with categories actual, budget, planning, forecast, rolling forecast, predictive capabilities
- Import and export data with in SAC and non-SAP
- Extraction of Data load to SAC from flat file and SAP HANA
- Familiarity with analytic applications and analytic designer, screen layout, and widgets
- Involved in the complete development of CDS Views, HANA views, SAC Dashboards, and AFO Reports
- Created custom CDS views in Plant Maintenance and built a dashboard in SAC
- Worked SAC Planning import model and built the Head Count & Expenses planning input forms
- Create formulas, calculated /Restricted measures, Cross-calculations for currency conversions etc
- Involved in the creation of Analytical privileges, Currency conversions, and UOM unit of measure conversions
- Created calculated columns, restricted columns, input parameters, Filters, and Variables
- SAP Data Sphere:
- Expertise in Data builder, Business builder, building the consumption model, prospects for reporting, and utilizing the same for Analysis for Office, SAC reporting
- Expertise in creating of Analytics Models, Replication Flow, and Transformation Flow in Data Builder
- Staging data in Data Builder, apply transformation logics according to business requirements
- Expertise creating of Business Entities and Fact Models for reporting
- Understand the business requirements, create consumption models, perspectives to feed the reporting in SAC, Business Object, and AFO etc
- Configure live connection / Import connection to consume SAP / Non-SAP source into SAC
- Extensively worked on Graphical & SQL HANA views in Datasphere
- Establish a connection between Snowflake to SAP Datasphere using a JDBC connection
- Extract Master data / Transactional data schemas from Snowflake to SAP Datasphere
- Knowledge in Data Access Control (DAC) and authorization scenarios in DataSphere
- Extract Snowflake tables, views, and models into SAP Datasphere and created Analytical models based on the business requirements
- Knowledge on experience on Cloud services like AWS, Azure
- Deep knowledge on CDC ,SDC types and table comparison
- Hana Modelling:
- Extensively worked on HANA Calculations views and built complex HANA Models using graphical & SQL scripts
- Expertise in designing reports based on business requirements while using SSRS, designing ETL loads to load data into the reporting database using SSIS and creating stored procedures and functions required to extract data for the load Profound knowledge of relations multi-dimensional and transactional databases
- Extensively worked on store procedures ,Table functions , Scalar Functions , Input parameters and variable in HANA modelling
- Extensively worked on HANA modelling and Performance tuning Fixed Memory allocation issues & long runtime issues in multiple models
- Extensively worked on SQL and built store procedures to materialize/Persist the snap shot data and to flatten the hierarchy data and for audit log
- Worked on YTD , MTD ,QTD and other trend analyses HANA models
- Experienced in optimizing HANA Views using PlanViz for Better Performance
- Experienced in developed HDB Tables , Roles files ,Table functions & Analytical Privileges
- BW4HANA
- Experienced BW/4HANA Cloud consultant seeking to leverage expertise in designing, implementing, and optimizing cloud-based data warehousing solutions to drive data-driven decision-making
- Results-oriented BW/4HANA Cloud architect with a proven track record in developing scalable and secure cloud data architectures, aiming to lead complex BW/4HANA Cloud implementations and migrations
- Expert in SAP BW/4HANA legacy systems with hands-on experience in transitioning data models to cloud environments Seeking a role in SAP Datasphere Cloud to lead cloud migration efforts, optimize Native HANA views, and modernize reporting using Analysis for Office
- Extracted data from SAP ECC, SAP S/4 HANA, non-SAP Applications and 3rd Party DB into SAP BW4/HANA
- Extensively worked on BW4HANA Objects and build mixed approached based models Consumed BW ADSO & HANA Models and built Composite providers & built queries
- Lead Implementation Projects in SAP BW 7X and BW4HANA, 2 Migration Projects, and multiple Production support assignments for major client Engagements
- Proficiency in SAP BW, including data modeling, data extraction, ODP Extraction, and transformation Strong knowledge of ABAP programming, SAP BEx Query Designer
- Experienced in developing HDB Tables, Role files, Table functions & Analytical Privileges
- Deep understanding of SAP HANA, SAP BW migration to SNOWFLAKE migration projects & involved in multiple project SNOWFLAKE POC Discussions
- Extensively worked on reporting solutions like BO WEBI, Analysis for Office, SAP Analytics for Cloud, and good product overall knowledge on Tableau & Qlik Sense
- Has good knowledge of SNOWFLAKE features, such as SNOW PIPE, TASK, Streaming, Dynamic data masking, Row level access policy, etc
- Extensively worked on Data providing solutions like SLT, BODS, SDI, and has good Knowledge on Informatica
- Deep knowledge of CDC, SDC types, and table comparison
- Experience in extracting data from SAP R3/ECC, S4H by Enhancing Std (SAPI, ODP framework) and Generic Data sources, non-SAP systems, and flat files
- Creating BW objects that include Info Objects, Data Sources, Info sources, Transformations, DTP, Info package, DSO, Info Cubes, Multi-providers, Info set, Open ODS, ADSOs, Composite Providers, Native Modelling with Views and ABAP code for customer exits and routines with sound knowledge on debugging
Timeline
Sr SAC, Data Sphere Consultant
HBR Analytics & BI Solutions, LLC
05.2025 - Current
SAP Data Sphere & BW4HANA Consultant
HBR Analytics & BI Solutions Ltd/Himalaya Wellness
01.2023 - 04.2025
Senior SAP BW on HANA Analytics Consultant
L&T Infotech /Johnson & Johnson
11.2021 - 01.2023
Senior SAP BW on HANA Analytics Consultant
Capgemini /PETRONAS
05.2019 - 10.2021
Senior SAP BW on HANA Consultant
Capgemini/HOLCIM Services
07.2017 - 05.2019
SAP Senior BW Consultant
Wipro/Wal-Mart Global Technology
09.2016 - 06.2017
SAP BW Consultant
Accenture/Dow Chemicals
08.2014 - 01.2016
SAP BW Consultant
Accenture/JSW
11.2012 - 07.2014
SAP Consultant
Accenture/Coke BIG SI [Support]
11.2011 - 10.2012
Mechanical Engg -
Dr. M.G.R. Educational And Research Institution