EXPERIENCE SUMMARY:

• SAP Native HANA,S/4 Analytics and BW HANA Certified professional with related business experience in oil and gas, transportation, financial services, Telecom and Consumer goods industries.
• Having 14 years of experience in SAP data warehousing, Native HANA, BI analytics and S/4HANA embedded analytics.
• SAP HANA Native Development; Deployment of SAP HANA Sidecar with HANA live, SAP Landscape Transformation (SLT), SAP Smart data access, Smart data integration and quality, BO Data Services and HANA modeling views.
• SQL scripting; stored procedures, User defined functions (UDFs), Decision tables, sequences, database views and a complete SQL data ware house design with ETL.
• Smart Data Integration: Remote Source configuration, tasks configuration with flowGraphs and monitoring them in Admin Cockpit.
• XSA Development: Simple server side XSJS script for test suite applications. Migrating database objects from XS classic to XS Advanced. Also, new HDI container - based developments in Web IDE for HANA.
• S/4 HANA Embedded Analytics: Developing ABAP CDS views, AMDP and consuming these models in Business objects Suite.
• SAP BW on HANA migration; optimizing the BW system with HANA DB capabilities. Also developing mixed scenarios to combine the data from Native HANA and BW.
• Business objects analytics on HANA; Lumira for Data visualization, Design studio for dashboards. BO Webi for reporting and analysis. Advanced model design using SAP Analytics cloud.
• Published my experiences in XSA and Web IDE for HANA, S/4 Analytics in my Youtube channel to help developer community.

PROFESSIONAL EXPERIENCE

Confidential

SAP Environment

Responsibilities

• SQL Data warehouse: Extraction and transformation with smart data integration and SQL features to build the data warehouse.
• CDS artifacts: data persistency with Core data services objects, also building views with associations and annotations to have rich semantics.
• Data Provisioning: Using BODS ETL, also Smart Data integration Flow Graphs to transform the data.
• Smart Data Access/Smart Data Integration: Virtual tables on remote sources, Creating SDI Flowgraphs to transform the data in HANA which are Aggregation, Join, Match, Case, Table comparison etc.
• Monitoring of SDI tasks execution in the HANA Admin Cockpit.
• Modeling views: building calculation views, Graphical and User defined functions (Scripted), decision tables for data analytics.
• HANA Security: Designed the security model for Developer, Admin and Business user roles. Coded analytic privileges to secure data access on business specific roles.
• XS Advanced: HDI container developments using Web IDE for HANA, GitHub repository for source control and also prepared migration plan from XSC to XS Advanced models.
• XSJS or Node JS: developing business control logics and Quality validations in Java Script files written XS application server.
• Design Studio: Building dashboards with several Custom SDK components, Customized CSS and Java Script developments.
• SAP Analytics Cloud: setting the new reporting models in SAC, also testing out planning models in there.

Confidential

SAP Environment

Responsibilities

• SAP RAR: Processing IFRS relevant data into SAP RAR system using HANA and BODS ETL tools.
• HANA models: building Complex calculation views, SQL procedures to transform and harmonize the data from several source systems for operational reporting.
• BODS ETL, extract data from several source systems like Tera Data, Oracle into HANA.
• Life Cycle: Leveraged HALM tool to prepare the Native HANA transports to move repository objects.
• Error handling: Developed Complex Exception procedures and logging mechanisms.
• Optimize the Views: Performance optimization of Calculation views with PlanViz execution and trace.
• Data Load Support: Performing the manual updates to the data using SQL Console to correct errors.
• Custom Revenue Accounting Solution: Building an IFRS 15 solution in HANA to apply the accounting rules during data processing.
• SAP RAR developments: Configurations in RAR module for order and billing data processing for IFRS 15, BRF+ configurations and customer enhancements to derive the revenue recognition.
• BW on HANA objects: ADSO, Open ODS views and Composite providers for IFRS models.
• BW on HANA Queries: Advanced features of creating queries with HANA pushdown.

Confidential

SAP Environment

Responsibilities

• Native HANA modeling: information views development by leveraging HANA live Rapid deployment solution for ERP and CRM.
• Customization: Hierarchies design in Calculation views, SQL scripted views for complex data transformation logics for analytics.
• Data provisioning: BODS to get the non-SAP data into HANA DB, also transform with complex logics.
• Data provisioning: leveraged SDA and SDI to get real time data from other systems to native HANA DB.
• Configured several SDI adapters like oracle log reader, IBM DB2 log reader and ECC adapter to extract the data from respective systems.
• HANA Life cycle management: CTS+ transport configuration integrated with Solution manager.
• BW on HANA migration, BW database migration from MSSQL to HANA DB, performance optimization, HANA optimized BW objects development.
• BW modeling: Creation of ADSO, Open ODS view and Composite providers to better utilize the HANA performance features to reduce the data foot print.
• Mixed approaches to integrate the data from Native HANA DB and also BW on HANA objects
• Lumira, data exploration and visualization for financial dashboards.
• Analytics: Design Studio, building custom applications with complex Java Script and CSS scripts.
• Webi reports development, building universe on HANA information views, also leveraged HANA live connection in BO 4.2.
• Deployment of Lumira, Webi documents and Design Studio dashboards into Fiori Aps.
• Analytics: Qlikivew reports build connecting SAP systems, Legacy system and also HANA Database.

Confidential

SAP Environment

Responsibilities:

• Data base migration of Oracle to HANA, using DMO approach to combine the upgrade and migration in one process.
• Execution of Pre and Post Checklist activities for the upgrade, resolved all the errors during this.
• Native HANA models for the new data flows as a side car implementation.
• HDB objects for data persistency, SQL procedures to perform the Data querying requirements.
• Data replication into SAP HANA using SLT server
• BO Data services for batch job processing to get the data into HANA.
• Smart data access to access the tables virtually in HANA.
• OData Service NetWeaver gateway connectivity to interact with HANA Database and Confidential tool.

Confidential

SAP Environment

Responsibilities

• BW modeling: creation of BW objects according to data warehousing strategy of the project.
• Complex scenarios in ETL process, includes Hierarchy flattening for project system hierarchy reporting.
• BEx reports: Developed AFE reports, JV Trial Balance reports and GL trial balance reports and also several logistics reports.
• Royalty Accounting project with module pool programming in ABAP and created 18 User Interface screens with ALV grid.
• BW 7.3 upgrade in Talisman landscape, also upgraded BPC 7.5 to BPC 10 and BW 7.3 to 7.4 version as well.
• BO Universe creation using IDT to build models on non- SAP systems using ODBC connection.
• Dashboard designer developments for finance and SCM business summary results.
• BPC: Developed Evdre reports on BPC 7.5 for Operating expenses analysis also input schedules to provide forecast with manual entries. Also BPC 10 upgrade.
• Implemented budgeting and forecasting process for Husky vanilla sky SAP landscape.
• Integrated the new BPC environment with BPC consolidation.
• Designed the BW flow to fulfil the BPC reporting needs.