About Shastri
English
Native or bilingual
French
Fluent
Dutch
Conversational
Italian
Conversational
Experience
- UNESCOLead Data AnalystPUBLIC SECTORFebruary 2025 - Today (1 year and 4 months)Paris, France-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 MicrosoftSQL Server, allowing compilation tasks for audits and reports to be automated, reducing time to publish by 60% (8 days faster on average).
- SuitsupplyAnalytics EngineerLOGISTICS AND SUPPLY CHAINOctober 2024 - January 2025 (3 months)Amsterdam, NetherlandsSubject 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.
- Instapro GroupSenior Data AnalystDIGITAL AND ITNovember 2023 - September 2024 (10 months)Amsterdam, Netherlands-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.
Recommendations
Be the first to recommend Shastri
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master in Supply Chain andPolitecnico di Milano2019Master in Supply Chain and
- Master of Business AdministrationHeriot-Watt University2013Master of Business Administration