Dimitri

• Participated in interview rounds of two incoming interns of the IT department. Taught them how to use SQL to retrieve and analyze data, various excel shortcuts for them to gain in work efficiency, and how to operate and maintain the machine-learning powered corporate ticket assigner I developed
• Used Excel's Pivot Table, as well as regression analysis, to test the efficiency of marketing actions in increasing median sale transactions
• Automated and optimized time-consuming daily reporting of logistic flows (short shipment and pick analysis) of warehouse data to partner Bloomingdales with python and VBA macros
• Automated order and pick tickets data files reconciliation with python

• Wrote a python script to automatize corporate tickets assignment to employees, using Natural Language Processing technique and gradient-boosting Machine Learning algorithm XGBoost. Accuracy rate of 87% on test set, with "only" 850 tickets in the dataset so far
• Wrote SQL scripts to extract and analyze store data run through Oracle SQL Developer. Creation of reporting template for the finance and accounting departments to use and better understand costs and revenues repartition on a daily basis
• Enhanced efficiency with automation of stores sales data reconciliation and reporting process through macros using macros-recorder for less-demanding workflows. Self-taught myself VBA to write macros for more demanding workflows
• Designed new templates and automated daily emails distribution to more quickly identify and report points of failure of various applications, as well as bringing forward improvements and solutions

• Conducted deep market analysis of the competition to develop new competitive advantages through a new strategy
•Designed a competitor Microsoft Access relational database (competitors investors, competitors mergers and acquisitions, website monthly traffic, competitors online & social media presence, competitors customer engagement)
• Provided strategic advice regarding the company’s potential future issues
• Created an interactive segmentation dashboard with Tableau.
• Performed data mining, using association rule, to extract actionable insights from open source survey on mental health

Main missions: creating a schedule of cash flow in different currencies, analyzing certificates and international fiscal declarations, calculating the price and budgeting the integration of new products in different currencies

Skills developed: being meticulous with numbers, using excel in a corporate environment, and using English in a corporate environment. Ability to adapt myself to a whole new environment