Sourav Saha

#1 - Asset Information Factory

Tools: Power BI, Azure Analysis Services, Databricks, Azure Data Factory, Azure SQL Database, Python, Scala

Project Description:

Asset Information Factory is Shell's Data Inventory which stores all information about Production, Cost, Sales etc. related to Upstream business for all assets under Shell. The data repository is built on Azure technology which is more real time for end users. This information is used by Shell to produce and maintain it's business.

Role and Responsibilities:

• I am leading Data Engineering team to process the data and store them using Databricks and ADF to SQL server and then create reports on it using Power BI.

• I am also developing automated ADF pipelines to sync between SQL server and Azure Analysis Server for users who use Azure Analysis Server for DIY work.

• I am developing Global Report in Shell named Action Tracker which tracks the actions of all personnel in Shell and their due dates to centralize the process of actions and its closure to avoid any issues or loss.

#1 - Upstream Analytics – Global Logistics

Tools: Spotfire 7.12, SAP HANA, Oracle DB, Python

Project Description:

GLOG (Global Logistics) project under Shell Upstream Analytics is the Analysis Report application where Shell analyses the usage of their Vehicles for transportation of Oil, Freight and Persons over the World. This application helps them to minimize the logistics cost and maximize the utilization to get profits increase. It uses SAP HANA and Oracle database for their data storage and Spotfire 7.12 and Python for development of Analytics Report.

Role and Responsibilities:

• Worked as Developer and Data analytic for the report development.
• Involved in requirement analysis and providing solutions to the stakeholders of Shell.
• Responsible for Report migration and testing in several environments.
• Providing several analytics ideas to end users for better utilization of data and better visualization of data.

#2 - Upstream Analytics – Land Transport

Tools: Spotfire 7.12, SAP HANA, Oracle DB, Python

Project Description:

LT (Land Transport) project under Shell Upstream Analytics is the Analysis Report application to display the land communication for Shell Oil Company all over the world. The logistics performance is tracked using this tool. It is used to show the performance and to forecast about the vehicles usage and other resource usage. It uses SAP HANA and Oracle database for their data storage and Spotfire 7.12 and Python scripts for development of Analytics Reports.

Role and Responsibilities:

• Worked as Developer and Data analytic for the report development.
• Involved in requirement analysis and providing solutions to the stakeholders of Shell.
• Responsible for Report migration and testing in several environments.
• Providing several analytics ideas to end users for better utilization of data and better visualization of data.

#3 - Upstream Analytics – Manage Supply Chain

Tools: Spotfire 7.12, Tableau, SAP HANA, Alteryx, Python

Project Description:

MSC Tactical Solution project under Shell Upstream Analytics is the Analysis Report application to display the performance of Shell for managing its Supply and Contract. It gives value to the company by providing fine insights about its payment performance, Contract Management and Service Management. It uses SAP HANA for their data storage, Alteryx and Python for ETL and Spotfire 7.12 and Ironpython scripts for development of Analytics Reports.

Role and Responsibilities:

• Worked as the sole Developer and Data analytic for the report development.
• Involved in requirement analysis and providing ETL and Reporting solutions to the stakeholders of Shell.
• Responsible for ETL development, Report migration and testing in several environments.
• Providing several analytics ideas to end users for better utilization of data and better visualization of data.

#1 - Data Quality & Accuracy (DQA) Tool

Tools: PL/SQL, Informatica, Spotfire, Unix.

Project Description:

DQA (Data Quality & Accuracy) is the tool which provides real time view of the data loaded in backend of P&G point of sales database. It is using PL/SQL procedures to fetch the real time information of data loading in the database. It stores the files loading information in database and provides the information about the SLA adherence of the data loading. This helps the operations team to achieve a good score and provides a clear view to the user about the end to end data loading process. It checks both timeliness and accuracy factor and provides clear idea to the user.

Role and Responsibilities:

• The backend coding is developed by using PL/SQL procedures. The incoming file loading process is implemented through Informatica 9.1.0.
• The Frontend visual part is developed using Spotfire. It provides all reports required to the team for their analysis.
• Implementation of several jobs are done using Unix.

#2 - FastMart Reporting Application

Tools: Vertica, Spotfire and Unix.

Project Description:

FastMart application is the frontend reporting application for reporting the point of sales data of Procter & Gamble. It is using Vertica as backend database and from this database data is fetched in Spotfire web tool for reporting purpose. We are implementing developed solutions for this tool.

Role and Responsibilities:

• We are implementing several UNIX scripts for fetching the data from Oracle to Vertica Database.
• We are creating reports in Spotfire tool for getting the reports ready as per client requirement and the backend database is Vertica.
• We are also providing Dynamic Reports for several processing and data statistics validation of the system to the operation team.