James Grayson Email & Phone Number

- Responsible for enabling a predictable and frictionless purchasing experience for STEMCELL’s customers by ensuring ~4 million pieces of pricing related data are accurately reflected on numerous sales channels, including SalesForce, our website, and customer facing price lists- Team had no previous coding experience and have together learned and become proficient in both Python and SQL (in Snowflake), then become the heaviest business users of both languages, and applied those learnings to transition out of spreadsheets and automate each processes we touch. This has been a great opportunity for a remote team to work together, problem solve, and bond, has improved the speed at which we acquire and communicate data, and has reduced mistakes associated with manual data creation and entry. In 2023 our team of four automated projects that required ~5,000 hours of person time per year, including scraping competitor pricing data, generating price lists with customer specific pricing, and the creating rules to check for and alert when incongruent data exists in SAP- Collaborated with colleagues in IS and consulted >60 stakeholders across >20 business teams to redesign the pricing data structure in SAP. The new design delivered all existing pricing functionality while reducing the pricing data architecture by >90%. The go live was frictionless, and the company now has a scalable platform that can support complex business needs as the company continues to grow, and has reduced the rate of pricing data errors by more than an order of magnitude

- Responsible for setting and reviewing the pricing strategy of >3,000 products in global markets- Automated the collection and cleanup of competitor product information and pricing data, saving over two years worth of employee time by FY24, and reducing the time required to analyse the competitive position of our products and provide updated information to Product Managers and the Sales team- Developed tools to collate and combine data from numerous databases to model the financial impact of potential price changes, which have enabled substantially faster and more informed decision making, and generated increased revenues- Identified a gap in formal training for Google Sheets, STEMCELL’s primary spreadsheet program, and developed and deliver a training session to address this gap, improving data analysis within the company

- Managed and led a team to complete a complex technical project for Google- Liased with key stakeholders to set project goals and KPIs, and presented progress reports to Google's key personnel- Reviewed, delegated, and re-assigned project tasks as required, and scheduled cross-training to minimize delays- Authored final project report including key findings, enhancing client’s knowledge of topic and helping generate a further round of funding

Vancouver, Bc

- Supervised, trained, and mentored graduate students, accelerating their research- Provided subject matter expertise and technical knowledge to peers and senior colleagues, increasing the significance of their findings

- Led three research projects that increased knowledge of the Earth's atmosphere- Collaborated with external colleagues, including working at Harvard and Leipzig Universities- Published author of eleven papers, presented findings to experts at international conferences- Chaired an interdisciplinary Journal Club that included colleagues from ten UBC departments- Developed, analyzed, and drew logical conclusions from large numerical datasets

Sandwich, United Kingdom

- Designed and performed research related that improved internal Quality Assurance processes- Authored internal project reports, and presented recommendations to senior management- Implemented recommendations, expediting drug development and reducing research costs

Management Of Technology Mba

Doctor Of Philosophy (Ph.D.), Chemistry

- Work performed with Prof. Allan Bertram

Mchem, Chemistry, First Class Honours

- Undergraduate Masters program with a year working in Industry. - Studied modules in managerial economics and clean technology alongside.