- Updated existing documentation and created over 10 new Excel files detailing major functionalities of the company’s programme, providing the underlying logic to assist developers, testers, and upper management in making informed decisions- Organised and led multiple walkthrough sessions for relevant stakeholders on major functionalities to facilitate the ongoing transition of the programme to SaaS- Led 2 client meetings for a redress client project involving a major British bank and one of the “Big Four” accounting firms; updated the Project Control Group Excel file and distributed it to relevant internal and external stakeholders- Resolved assigned issues, enhancements, and bugs on DevOps by analysing each problem, updating relevant documentation as needed, and assigning the tasks back to the relevant stakeholders- Utilised SQL to write queries to organise and analyse data, to identify inconsistencies within the database, and to recommend potential solutions to resolve these inconsistencies

Project #3: Evolution of oil and gas production over the last 3 decades: the case of Malaysia, Philippines, Vietnam - Conducted research to identify the quantity of oil and gas production in the last 30 years for Malaysia, Philippines, Vietnam - Cleaned and analysed the data- Performed fundamental analysis and communicated found insights- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Project #2: Fish captures in the last 15 years: the case of Vietnam, Philippines, Malaysia, and Indonesia- Conducted research to find the quantity and source of fish captures for Vietnam, Philippines, Malaysia, and Indonesia- Created various Excel models to understand the evolution of fish captures, region and ocean of captures, type of fish- Performed fundamental analysis and communicated found insights(Part Time Research Assistant for a PhD student writing a thesis in the field of International Relations/National Security Studies)

Project: KiwiHarvestProject Scope: creating sustainable recurring revenue sources to reduce KiwiHarvest’s dependence on grants, donations and philanthropic support- Conducted in-depth research on the three industries used for one of the final two recommendations based on the following criteria: market size and growth, market segmentation, market entry barriers, distribution channels, pricing and profitability, risks- Developed a financial Excel model which provides revenue and revenue forecast based on two assumptions: quantity sold per company type per industry and expected market share in the first year- In charge of the final presentation’s structure and layout for one of the final two recommendations

Project: DPD (part of DPD Team 2)Scope of the project: formulating DPD’s new booking-in system- Conducted research and presented findings of Microsoft Power Automate as a potential solution to manual input to the DPD team- Elaborated on the structure of the final PowerPoint presentation- Collaborated on the design of the slides for the final client presentation

- Delivered a 1-hour presentation on "Market Sizing" to 40 students- Designed and created PowerPoint slides for club sessions- Researched and wrote the market section of the case study used for the London Consulting Summit’s Case Competition

Project: Doughlicious (part of Doughlicious Team 1)Scope of the project: find alternative 3PL (third-party logistics) companies- Conducted research on potential alternative 3PL companies based on 3 criteria: technical, quantitative, qualitative- Collaborated on the final Excel deliverable, which incorporated a ranking of various 3PL alternatives- Contributed to the final design layout of the final report and wrote the analysis and conclusion for half of the 3PL alternatives (50% of companies presented)

Project #1: Weapon deliveries to Vietnam, Malaysia, Indonesia, and the Philippines- Conducted research to find the quantity and source of weapons delivered to Vietnam, Malaysia, Indonesia, and the Philippines- Made an Excel model around the following criteria: (a) supplier, (b) quantity, (c) designation, (d) description, (e) date of order, (f) date of delivery, (g) delivered, (h) comments- Performed basic analysis and communicated found insights(Part Time Research Assistant for a PhD student writing a thesis in the field of International Relations/National Security Studies)

- Contributed to the mapping of the entire supply chain of the Australian agriculture sector which allowed the client to assess the supply chain’s resilience & vulnerability and the client’s ability to predict, withstand, and respond to possible disturbances- Elaborated an analytics use case excel deliverable and provided recommendations that allowed the client to choose which actions to implement based on impact (low, medium, high) and time (short, medium, and long term) in 3 key areas: Planning, Supply Chain, Marketing Sales & Service; main consultant in charge of the project and solely developed the final deliverable- Formulated and executed a data dictionary which allowed the client to catalogue and communicate the structure and content of data and to provide meaningful descriptions for named data objects; 12 total unique entities & 179 total unique attributes- Built a forecast model in Excel (exponential smoothing method) using new and returning visitors data as model assumptions which allowed the client to obtain revenue predictions for the next 2 years; provided the pros and cons of the model and explained the logic behind the assumptions- Designed and implemented an Excel model for social media posting which automated the process and allowed consultants to gain in time and in consistency - Collaborated with an associate consultant on the creation of the “Social Media Storyline” for the upcoming months and presented the team’s proposal to the co-founder & director of Kanvic Consulting

- Translated the website and the official app: French > English- Rendered the meta title and meta description SEO friendly- Fixed the "page not found" web pages with the developer(Recommendation letter available on request)

- Wrote a 100-page eBook: "Optimiser la gestion de son Airbnb" - 1 000 views on LinkedIn and Facebook; 30 downloads on the official website- Wrote and posted 20 articles (1 per week) and 1 post (per article) on LinkedIn and Facebook - 900 views in total on Medium; over 400 minutes of total read time; 20 total posts on LinkedIn and Facebook- Contacted 23 blogs to promote PassPass - 35% positive answers for a collaboration- Created the FAQ page in collaboration with the head developer - 23 total questions and answers; additionally, created the newsletter and the layout of the emails - 10 emails collected- Conducted a market research - Xerfi: Les marchés de la conciergerie à l'horizon 2022 - provided data and recommendations for the company- Worked with the team's head developer on the software; provided recommendations; reported different bugs

- Wrote the description, short description, meta title, and meta description for each of the 453 stock items and their variations (colour variations); repaired and rendered URLs SEO friendly- Made an Excel layout which enabled the upper-floor sellers to gain in efficiency; the Excel allowed for a quick inspection of whether or not an item was in stock in a specific size. Roughly 90 Excel sheets were made and printed- Elaborated, executed and posted weekly Instagram posts complete with descriptions, tags and shoppable Instagram - 22 total pictures, 2 videos, and performed basic Photoshop touch-ups such as colour or texture correction and brightness modifications- Participated in the yearly "stocktake" day; scanned SKUs of different stock items and uploaded them on the computer once 100 scans were reached; for missing labels made a blank label with the following: SKU, name, colour, size and composition- Changed the structure of the online shop through Magento 2; weekly changes included: the banner (1800x750 pixels) and the squares (880x1000 pixels); updated the Instagram feed at the bottom of the website; updated the text on the website every week- Wrote a "care guide" (based on material: wool, linen, cotton, silk...) and made the size chart for each type of product (through the platform Magento 2) ranging from trousers to sweaters. Each type of garment (sweaters, trousers, cardigans...) was measured and entered in Excel, then on the official website- Assisted the Anderson & Sheppard Bespoke shop when needed. Main tasks included contributing to the creation of a word layout that would keep track of the stock. Additionally, I took pictures for Instagram posts- Assisted the upper floor when needed. Printed and placed labels on new items and assisted with orders (mainly through UPS). Prepared and packed required items for online retailers such as Mr Porter and delivered orders personally when needed