Patrick Lueg

Experience

• 

  Numerator

  Jun 2018 - Aug 2020

  Data Analyst

  • Utilized rules engine to scrape pricing data and created Excel reports to guide clients’ pricing strategies and MAP enforcement• Wrote VBA macros that reduced the data analyst team's weekly report generation time by 33%• Trained and mentored data analysts in India on the rules engine and VBA macros

• 

  Cushman & Wakefield

  Sept 2020 - Mar 2021

  Consulting Analyst

  • Developed and refined Smartsheet project plans and dashboards used to manage a $190M+ EBITDA cost transformation program• Worked with project owners to monitor and maintain the fidelity of their 60+ initiatives’ financial impact data• Assisted in creating PowerPoint decks for biweekly steering committee meetings

• 

  Citi

  Mar 2021 - now

  Project Senior Analyst

  • Wrote VBA macros to automate a survey tool for tracking newly-hired consultants’ onboarding experiences• Supported the onboarding of Smartsheet at Citi by completing the Cross Border Data Clearance and Privacy Impact Assessment• Served as Smartsheet subject matter expert and risk manager, troubleshot issues, and gave demos to potential users (including MDs)• Developed 20+ Smartsheet solutions for 15+ teams to more efficiently manage projects and tasks, track metrics and KPIs, and recruit• Managed 17 Smartsheet centers of excellence and created their onboarding documentation, training, and solution management toolkits• Built Tableau dashboards to track KPIs for the decommissioning of Smartsheet from Citi Show less