Trevor Menezes

Built a SQL-Power BI and Excel portfolio 1. Designed 6 end-to-end analytics projects across domains (real estate, HR, air travel, retail, air ticketing). 2. Generated insights on pricing, workforce productivity, and customer demand, supporting stakeholder decisions. 3. Designed Excel-based dashboards for additional case studies, strengthening versatility in tools. 4. Currently expanding portfolio with advanced SQL/Power BI projects, progressing to mid-level analyst.

Project based work - 4 discrete projects, 3-4 months each 1. Delivered pro-bono strategic advice to early-stage European startups across energy, tech and sustainability. 2. Optimized a pricing strategy with a potential ARR uplift of over 40%, and proposed new product ideas. 3. Developed marketing strategies to enhance lead conversion on LinkedIn. 4. Conducted business analysis and recommended market entry strategies.

Enhanced the B2B transactional business process 1. Mapped the AS-IS process through stakeholder interviews, identified gaps, and proposed a TO-BE process with strategies to address them. 2. Created a Power BI dashboard design and built an Excel tool that increases operational efficiency and decision making. 3. Designed an inventory planning approach to reduce aging stock, projecting a 59.1% reduction. 4. Developed a logistics strategy optimizing delivery, projecting $5.4M cost savings yearly.

Created monthly sales dashboards using Excel and gained exposure to B2B marketing

1. Conducted market analysis in 9 EU markets. Recommended 3 priority countries with prospect leads in Zoho CRM as a market entry strategy. 2. Presented findings and strategic insights to C-suite executives.

Enhanced fixture capacity by 27.78%, improved factory inventory efficiency by 60% and used 5S framework to improve worker safety.