Anirban Kundu

• Gathering Business Insight and capturing Business Requirements to build the data model for Revenue/Volume Management and Equipment Identification Registration System
• Identification of KPIs pertaining to each data model
• Semantic Layer creation using SAP BI 4.3 Information Design Tool
• Data Visualization using SAP BI 4.3 and SAP Lumira Designer 2.4
• Business Dashboards using SAP BI 4.3 WebIntelligence

Tools and DB used:

• InBill
• SAP BI 4.3
• Oracle 19c
• My SQL 8

Client Name: John Lewis Partnership(JLP)

JLP is one of the Retail giants in Europe and based in London, UK. The project is about the reporting of Customer Orders spread across channels and fulfillments for John Lewis

• Customer Order Database design for reporting through Operational Data Store and JL DataWarehouse 
• Design of 2 Semantic Layers using SAP BI 4.2 Information Design Tool for Customer Order Database and Operational Data Store
• Design of Daily/Weekly/Trading Period Business Reports using SAP BI 4.2 WebIntelligence
• Incorporating Profit Protection data, thereby implementing data security at object level for reports

Tools and DB used:

• SAP BI 4.2
• Oracle

Client: John Lewis Partnership(JLP)

JLP is one of the Retail giants in Europe and based in London, UK. This project caters to all John Lewis Users who desire to view Business Reports in native/excel/pdf/mobile format.

• Complete end to end understanding of the John Lewis Retail Business.
• Major Business Processes included: Stock Sales Margin and Budget, Sales Transactions, Omni Channel Reporting, Customer Delivery Reporting, Rebates and Returns, Stock Loss and Write Offs
• Creation of the Datawarehousing solution, keeping in mind the Business Reporting/Analysis
• Designing of the DwH feeding from Mainframe and ERP source systems.
• Reporting Architecture design in SAP BI 4.2
• Creation of reports in BI 4.2 using Information Design Tool(IDT), Universe Design Tool(UDT), Web Intelligence Reporting and Design Studio (for Dashboards

Tools and DB used:

• Oracle
• SAP BI 4.2
• Infoburst 2.6

Barclays is one of the world’s Largest Banking Solution Provider. This project caters to the entire Western Europe Cards DataWarehouse. It involved the complete process for creation of the DataWarehouse including the Transaction Load for the DwH and the Statement Load for the DwH.

• Complete end to end understanding of the Credit Card Business, its significance in Barclays and the working knowledge in Barclaycard.
• Development and enhancement of the universe(s) through direct cordination with Business, ETL team and Stakeholders within Barclaycard.
• SAP BI Desktop Intelligence Business Reports and their delivery to users located in Western European countries like Portugal, Spain, Greece, Italy, Botswana and France.
• Complete maintenance and enhancements as and when required for the reporting Environment.