Ruchi Rai

Sales order data is being calculated based on invoices generated for different users and suppliers, and based on the data, the business makes decisions that can avoid operational impacts. As a part of this project, we are creating multiple tables and foundations, as well as consumption views, to assess sales-related data efficiently. We are enabling columns in ADB and Snowflake, by which businesses can follow up with the users.

Responsibilities:

• Collaborated with business analysts and data architects to gather requirements and translate them into technical specs.
• Pre-work for Boundary Apps (Inventory building).
• Created a solid data lineage document from the raw layer to the foundation layer.
• ROO mapping of BOBJ universe columns.
• BOBJ report testing: Security testing, and data validation.
• Lineage document creation for boundary apps' columns: backtracking in SAP HANA.
• Foundation and composition layer views' testing in ADF and Snowflake.

• To create tables and calculation views regarding substrate-level data from different sources, like Microsoft SQL Server and SAP ECC, in different layers as per business requirements. Data migration from Teradata to HANA, and Azure. The Intel Accelerated Office (IAO) readiness initiative completed the ITC3 integration testing cycle in M2, M4, and M7 ENVs. This includes defining detailed data specifications, developing components, executing integration tests, resolving identified issues, and final validation.

Responsibilities:

• EDW/HANA migration to Azure/Snowflake: Fit-gap analysis between EDW and HANA.
• Reverse engineering: backtracking of columns to get the OHD source details.
• Mapping document creation for EDW columns with their SAP ECC source column name.
• Creation of calculation views as per requirements.
• Analysis of the existing code in Teradata, and checking the feasibility in HANA.
• Migrating the existing Teradata code to HANA tables and calculation views.
• Ensured data integrity and performed root cause analysis on data quality issues.
• Developed complex Teradata SQL queries, views, and stored procedures to support reporting and analytics.