Shastri Sookdeo

-Created and implemented procurement performance metrics (including KPI definition, data sourcing, presentation formats and publishing timelines), and tracking via dashboard creation (PowerBI) for on-demand visibility by teams, reducing presentation creation time by 33%

-Designed, created and tested a procurement database in Microsoft SQL server, which enabled tables to be created with inputs from disparate data sources (SAP, CSV inputs, internal tools), and then connected to dashboards created in PowerBI, allowing management and audit to have real time visibility over HQ and field procurement statistics (reducing information request response times by 20%)

-Recreated existing report methodologies to be based on SQL queries (T-SQL) in Microsoft

SQL Server, allowing compilation tasks for audits and reports to be automated, reducing time to publish by 60% (8 days faster on average).

Subject Matter: Logistics/ Supply Chain Operations

- Collaboration with Supply Chain analysts to define metrics on logistics performance, translating the strategic need into data reporting.

-Creation and development of data models in dbt, including documentation, by writing and optimizing SQL (BigQuery) queries.

-Creation of Explores and Views in Looker (LookML) to allow end users to be able to have the ability to create their own graphs/dashboards by having metrics, dates, filters pre-existing as selectable data points.

-Analyzed data patterns and consolidated marketing, CRM, ERP and financial data inputs to rationalize existing pricing model leading to better demand supply matching. Done through SQL queries to extract data from Amazon Redshift, with analysis in Google Sheets (exponential smoothing, regression analysis).

-Creation of Looker Dashboards and Reports to increase visibility on customer operations and financial operations metrics.