Born in Patti, Sicily, Rampulla initially had short stints with Sicilian amateur clubs, such as his local team Pattese; he later also played for Cesena, where he competed for a starting spot with fellow future Serie A goalkeepers Sebastiano Rossi and Alberto Fontana. After three seasons at Varese, Rampulla joined Cremonese in 1985 and became a protagonist in the club's rise to the Serie A league. On 23 February 1992, Rampulla was the first goalkeeper to score from open play in Serie A history, after he equalised the scoreline with a header at 1–1 away to Atalanta, from a free-kick by Alviero Chiorri in the last minute of play. However, that hard-earned point was not enough to save them from relegation at the end of the season. After the 1991–92 season finished in relegation for Cremonese, Rampulla moved to Juventus in 1992, where he enjoyed a highly successful 10-year spell at the club; he initially played as a starter, replacing Juventus's former legendary goalkeeper Stefano Tacconi, and subsequently as back-up goalkeeper for the remainder of his career, behind Angelo Peruzzi, Edwin van der Sar, and Gianluigi Buffon, and later as the reserve goalkeeper behind Andreas Isaksson and Fabian Carini, retiring from active football in 2002, following Juventus's Serie A title victory and Coppa Italia final defeat. Despite being predominantly a backup, he played matches in every competition for Juventus during almost every season of his Juventus career, in particular under Peruzzi during the mid 90s, when the latter was struggling with recurring injuries. During his time at the club, Rampulla won an UEFA Cup in 1993, a Coppa Italia in 1995, 4 Serie A titles, 2 Supercoppe Italiane, an UEFA Champions League, an UEFA Super Cup, an Intercontinental Cup, and an UEFA Intertoto Cup. His goal-scoring feat would be matched by fellow Italian keeper Massimo Taibi nine years later.
Nicknamed Big Ben, Rampulla was a large, solid and reliable shot-stopper, who stood out for his professionalism and longevity throughout his career. He was also known for his ability with the ball at his feet as a goalkeeper, and had initially always wanted to play as a forward in his youth, but his father insisted that he play in goal. Because of his skill on the ball and offensive instincts, Rampulla even took penalties on occasion, and he became the first goalkeeper ever to score a goal in Serie A, with a header off of a corner kick.
Coaching career
After his retirement, Rampulla accepted to stay at Juventus in the club's backroom staff, serving as goalkeeping coach for most of his time. He parted company with Juventus in October 2010. On 14 July 2011, he was introduced as new head coach of Serie D club Derthona. On 5 December 2011, he terminated his contract by mutual consent with the club. On 17 May 2012, Rampulla joined former Juventus manager Marcello Lippi at Chinese Super League side Guangzhou Evergrande and became the clubs's goalkeeping coach. On 2 June 2016, Rampulla became the president of Cremonese substituting Luigi Simoni who had covered the presidential role for two years. Rampulla resigned from this post on 20 October 2016 and on 22 October 2016, he was announced as goalkeeping coach of the Chinese national football team, under the management of Marcello Lippi.