Project Sales

ZACHARY S. Ransom CSM

*** *. **** ****** ***. *** Denver, Co 80203 Mobile 716-***-**** acuo77@r.postjobfree.com

EDUCATION

Kansas State University, College of Business Administration

Master’s in Business Administration

Finance & International Management

University of Pittsburgh, College of Business Administration

Manhattan, KS May 2011

Overall GPA 3.7

Pittsburgh, PA

Bachelor of Science in Business Administration

April 2008

Major in Marketing & Political Science

Overall GPA 3.0

Minor in Economics

University of Virginia, Semester at Sea

Fall 2006

• Member of Ambassador’s Club and met with U.S Embassy Officials throughout the world

• Member of the Service Club and planned events for Inter-port students

CERTIFICATIONS

Certified ScrumMaster CSM 2015

Scrum Alliance

EXPERIENCE

Lavastorm Analytics-Denver, CO Professional Services Consultant 3/13-Pres.

• Created a revenue assurance model that captures leakage for a major Dutch telecom company’s pre-paid mobile platform

• Led the project that changed the way Comcast reports revenue to internal and external shareholders

• Constructed a repeatable data integrity process to help a major US telecom company divest their wireline business.

• Worked with Bermuda’s largest utility company to create audits required for preparation to install new infrastructure software

• Conducted numerous billing dispute analysis for a major US telecom company resulting potentially millions of dollars saved

• Led a Lavastorm Analytics Engine (LAE) training seminar for over 30 participants across different industries

Agility Solutions-Denver, CO Consultant 6/11-3/13

• Identify root causes for services operating at a net loss for a major telecom company resulting in million dollar recoveries

• Create new ways to research customer billing, standard pricing rates, expense reports, and customer contracts

• Extract and analyze large volumes of data via data mining to ensure client profitability

• Consistently exceed individual goal of capturing $8K in weekly recoveries by mining through data using Access and SQL

• Report and present weekly performance vs. yearly goals during weekly status meeting using an original reporting document

• Developed measurements for matching cost with revenue resulting in million dollars of recoveries

Steel Pipe Supply-Manhattan, KS

Business Analytics Intern

8/10-5/11

• Conducted analysis, prepared forecasts, and presented findings to the CEO regarding competitor acquisition

• Initiated a feasibility study to build new inventory and processing warehouse to better facilitate customer needs

• Created database using Excel and Access to analyze trends in the steel industry used by Senior Vice President of Sales

• Assisted in forecasting quarterly sales reports

MGM Resorts International-Las Vegas, NV Financial Shared Service Center Intern 5/10-8/10

• Contributed to Employee Banking Solution: Cost cutting project to save company $1 million annually

• Initiated Service Fee Project: Revenue generating project to increase revenue without gouging guests

• Created ‘Splash Pass’: Original revenue generating project with minimal cost to implement

• Created progress and financial reports for Corporate Controller using SQL, Cognos Finance, and @Task

• Validated journal entries to be used in corporate finance data warehouse repository by using Microsoft Excel

• Proficient in Microsoft Office, including Word, Powerpoint, Excel, and Access

LEADERSHIP

Student Government Board-Pittsburgh

Board & Allocations Member

1/04-12/05

• One of the eight students elected to represent the University to other students, schools, alumni, staff, and

Administration

• Partnered with University administration to accomplish goals in the area of athletics, off-campus housing, and student life

• Allocated funds from the $2.3 million Student Government Board account to over 300 student organizations

Contact this candidate