Shreya Bareja

Client: McKinsey & Company.

Project Title:

Firm Economics

Roles and Responsibilities:

• Designed and optimized financial data models, improving reporting efficiency, and ensuring accurate analytics for business stakeholders.
• Developed complex views in SAP Business Application Studio (BAS) to streamline data transformation and integration workflows.
• Leveraged SAP S/4HANA tables for precise data extraction, enabling reliable financial and operational reporting.
• Built interactive dashboards and reports in SAP Analytics Cloud (SAC), delivering actionable insights for decision-making.
• Implemented Git-based CI/CD pipelines to automate deployment and migration, reducing errors, and improving release efficiency.
• Acted as a trusted advisor for clients by providing thought leadership on best practices in data engineering, ensuring their systems were optimized for performance and scalability.
• Designed and optimized calculation views on financial models (client investment, billing, and receipts, WIP summary) to deliver collaborative reports that enhanced business visibility into revenue streams.
• Mentored and trained colleagues in SAP HANA data engineering best practices, enhancing team performance, and driving business value.

Client:- INTEL

Project Title:-

1. Supplier Collaboration

2. EDFIT (E Duty Free Item Tracking)

3. HANA to Azure Migration

Roles and Responsibilities:-

• Developed complex Graphical Calculation views and SQL Script Calculation views.
• Identified and acquired appropriate third-party solutions to integrate into development processes.
• Formulated strategies for application development framework creation and developmental processes.
• Spearheaded technical discussion roundtables to track progress and optimize future resource distribution.
• Analyzed and developed technical solutions to meet business requirements.
• Managed software development and support using formal specifications, data flow diagrams and other design techniques.
• Performed unit and comprehensive testing to drive functional and technical deliverables.
• Involved in creation of complex calculation, input parameters, variables, XS Odata.
• Worked on different ETL Tools ( SLT, BODS ) for fetching data from source to HANA environment.
• Created Autosys job for scheduling BODS.
• Gathering requirements from client; creation of mapping documents, Technical Design Documents and Functional Design Documents.
• Migration of HANA objects from development to production using HALM ( HANA Application Lifecycle Management ) and RevTrack.
• Developed HANA Column based tables and SQL Script Procedures, Loading data into table definitions, suspending data loads, resuming data loads.
• Worked on Calculated and Restricted Columns in Calculation views.
• Provided Hyper Care Support for production issues.
• Designed best practice documentation for development.
• Participated with clients in discussion meetings.
• Developed APIs for sharing data to another system using Apigee.
• Created views and Web API's on Denodo to share data across different sources.
• Worked on Azure Data Studio for creating pipelines to load data.
• Created Pipelines in Data Factory to load data in raw layer.
• Created Pipelines in Databricks to load data from raw to cumulative layer.

Project Title:-

Ericsson Telecommunication

Roles and Responsibilities:-

• Developed Attribute Views, Analytical Views and Graphical Calculation views and SQL Script Calculation views.
• Involved in creation of complex calculation views and procedures.
• Worked on different SAP HANA perspective, creation of tables/procedure using HDBDD table/procedure method.
• Created xsjs chrono jobs to automate stored procedure in Hana
• Created HANA modeling scenarios and activities such as setting up HANA environment – adding system, creating schemas and creation of USERs and ROLES, etc.
• Developed HANA Column based tables and SQL Script Procedures, Loading data into table definitions, suspending data loads, resuming data loads.
• Actively involved in KT to new team members and in maintaining of Knowledge corner of team which helps new joining team members.
• Using Filters for data restrictions and calculating columns for to get required data values.