Sofia Barrera Email & Phone Number

Skokie, Il

• Created and Maintain Cisco Renewal Forecasting for the Maintenance group; establish weekly senior management calls and tracking reports with Cisco PMC data. Generated $4.5M in rebates in 4 years of implementation. Analyze data and find case exceptions when needed.• Strategize on pricing and vendor programs with Solution Architects, Account Managers and Maintenance Specialists for maintenance solutions and customer meetings• Create complex pricing scenarios and matrixes for customer RFP’s• Oversee $500K+ deals; offer solutions when needed; from creation to completion• Chart, document and implement new network offerings; NES, PSS, Total Care and Combined Services• Develop clear and detailed process maps, work flows, and business requirements• Work with Cisco SAM’s and the Cisco Channel Manager on overall business growth and current opportunities • Provide training on Cisco CSCC; MS Excel and MS Access

Skokie, Il

• Implementation of ESW/UCSS procedure and process on Maintenance and Point of Sale departments.• Point of Reference and contact for Cisco Renewals in new system implementation• Train and supervise a team of 3• Track networking deals for quarterly close • Gathered and organized information on problems and process within the vendor line inside department

Skokie, Il

• Create quotes (pricing), generate proposals and purchase maintenance• Research and trouble shoot issues pertaining to Cisco related maintenance and Point of Sale• Maintain contract Maintenance in SCC (Cisco)

Chicago, Il

• Oversee and coordinate incoming spreadsheet requests within a 4-person team in order to meet a realistic time line for customer needs• Scrub, match, and package Excel spreadsheets, requiring extensive product knowledge, spreadsheet manipulation and formulas while researching and extracting information from the AS400 program• Maintaining of the Large Quote Log used for weekly reporting. Collaborate and create MS PowerPoint presentations for departmental use• Create training cells in order to improve match percentage and product insight. Brainstorming with Quotations Manager and Director in order to improve workflow in department

Chicago, Il

• Researched, created and completed quote contracts in AS400/BCPS system to ensure accuracy of order quantities, cost and special allowances. Coordinated special and off-book pricing requests as needed• Heavy contact with Purchasing, Sales Team, and Vendors. Multi-coverage of three cues, expanding skills and knowledge to four different sectors of company products, vendors and buyers• High paced environment with quick, independent decisions at a moment’s notice. Teamwork to meet quotation quotas, exceeding 100 lines per day

Chicago, Il

• Reviewed, proofread and inputted new contracts into data system to ensure accuracy of order quantities and quality. Zero percent rejection rate over twelve months• Maintained and tracked daily reports, oversaw inventory of ingredients and FOB costs for four major plants with supply and demand in R&D• Created MS PowerPoint and MS Excel presentations• Arranged travel arrangements and itineraries, completed expense vouchers and tracked invoices

Education record

Education record