Alcatel-Lucent Entreprise

Results

• A decreased lead time of worldwide partners accreditation process for Alcatel-Lucent
• All manual operations went securitized thanks to a digital macro, allowing a zero mistake processing
• The operation could be executed twice a year instead of once, resulting in better advice sent to partners & more business done
• Global saving of 42K€ per year (= consulting day pricing x 7 weeks x twice a year)

Context

• Worldwide accreditation operations used to be led once a year and took 7 weeks for a single person to perform them and send results to the partners
• The process was done thanks to an Excel sheet, resulting in many potential mistakes (related to manual arbitrages)

Solutions deployed

• Designed and wrote a VBA (Visual Basic) macro under Excel
• Accredited new process into production within the company in 2 months time