Long Lu

Experience

• 

  Just Cubbies

  Jul 2015 - Mar 2020

  Assistant Manager

  • Providing administrative support, managing employees and catering to customers, alleviating management’s workload. • Training and supervising multiple new employees on learning basic construction skills, workshop/office procedures and customer services, providing the workplace with experienced employees whilst increasing workflow. • Organising numerous amounts of pricing quotes, payments, deliveries and installations, to ensure that everything is organised and that the clients are pleased. Show less

• 

  Suste

  Feb 2020 - Oct 2020

  Web Developer

  • Researched and integrated multiple platforms such as Webflow, Google Forms/Sheets/Firebase/Analytics, SendPulse and Zapier to build a fully autonomous service that helped customers eat healthy and live more sustainably.• Collaborated with designers to develop the UI and built in using Webflow to allow for simple editing by the team.• Designed and developed a database using google forms to calculate a customer’s carbon footprint.• Connected Google Forms to Google sheets to store user information, automating carbon emission calculations, delivering efficiency, and generating statistical models. Show less

• 

  Chop Chop London LTD

  May 2020 - Sept 2020

  Web Developer

  • Generated website using WordPress, while collaborating with the CEO and development team; discussing customer needs, website functionalities, making an easy-flowing UX.• Designed and implemented ecommerce through Shopify, modifying HTML and CSS code of generic themes and coherently integrating with existing website, allowing ease for the customer experience.

• 

  CDP

  Nov 2020 - Mar 2022

  Data Analyst

  • Developed Centralised Insights Dashboard through Power BI to assist cities in gathering resources, helping to achieve greater benchmarks, and generating statistical insights.• Collaborated alongside internal team and key partner to CDP, Global Covenant of Mayors to audit and validate carbon emission from cities, aiming to limit global warming to well below 2 degrees.• Solo managed entire project pipeline using multiple technologies and platforms; R scripts, SQL, GitHub, Excel, Google Sheets, CRM, ODP, APIs, and pushing development through different production stages.• Automated 74% of questionnaire responses for the assessing team, reducing 75% of the validation effort. • Saved CDP, £180,000 per year through alleviating manual validation and reducing validation time, allowing to achieve deadlines.• Engaged with senior management and stakeholders, presenting development changes and updates to tool, managing milestones. Show less

• 

  Pangolin Associates Pty Ltd

  May 2022 - Aug 2024

  Sustainability Systems Developer

  • Collaborated with a key partner in building a centralised database via Azure to store historical and ongoing data to run insights and benchmarking, progressing the companies technology in navigating through data.• Built PowerBI dashboard that comprehensibly displayed carbon emissions trajectories and possibilities, saving 2-3 weeks of back and forth between consultants and clients ($1000-$2500 per client).• Developed Python GUI to allow internal staff to interact with the database, allowing for data upload, updates, and extracts, alleviating manual data collection from tech team.• Collated historical data saved in individual Excel files into a single dataset via R scripts, manipulating and cleaning data ready to be uploaded into the database, reducing manual search time.• Built visualisation Dashboard indicating employee statistics (workload, client list, etc…) extracting data from Jira (Project management software) to Excel, allowing equal distribution of workload across team. Show less

• 

  SafeDriver Group

  Feb 2025 - now

  Data Engineer/Analyst

  • Collect and consolidate data from multiple sources (Excel, Google Sheets, APIs) into a structured BigQuery database, reducing manual data handling, saving time and minimising errors.• Design and optimise ETL processes in Google Cloud to improve data accuracy, reduce manual effort, and enhance operational efficiency.• Build interactive dashboards to track performance metrics and financial reports, enabling data-driven decision-making.• Enhance BigQuery processing efficiency to handle large datasets, reducing costs and improving reporting speed.• Work with various teams to understand data needs, improve governance, and provide valuable business insights. Show less