Project Manager Sales

JOY YOUNG

P.O. Box ***, Atwood, CA *****

512-***-**** ● ***.****.*****@*****.***

PROFILE

Self-motivated, creative, results driven professional with a demonstrated ability to successfully manage multiple projects while supporting business and project goals. Strong ability to analyze information and utilize it effectively to develop actionable strategies. Particularly inventive with VBA to enhance the functionality of both Excel and Access per user preferences. Highly capable of analyzing trends and creating responses to observable behaviors. Advanced competitive analysis and customer segmentation skills. Proficient with web based efficiency metrics and ROI calculations. Accustomed to multi-tasking in a fast pace environment with stringent deadlines. Demonstrated natural leadership and motivational skills. Excellent communication and presentation skills.

SKILLS SUMMARY

Financial Analysis and Reporting

Advanced Mathematics and Statistics

Project Management and Leadership

Oral and Written Communication

Organized and Detailed Oriented

Proficient in VBA, Excel, Access, Word, & PowerPoint; SAP, MapInfo & Photoshop

Conversational Spanish

EDUCATION

Master of Business Administration, Fall 2010

Master of Science, Leadership Fall 2010

Grand Canyon University, Phoenix, AZ

Honors: Summa cum Laude; Delta Mu Delta Honor Society

Earned both degrees online while working 40 to 70 hours per week

Bachelor of Science, Engineering Fall 1983

Texas A&M University, College Station, TX

PROFESSIONAL EXPERIENCE

Irvine Technology Corporation September 2011 – May 2012

Pacific Sunwear Project, Anaheim, CA

Excel VBA Development Consultant (Responsibilities Equivalent to Software Development Engineer)

Excel Spreadsheet Automation. Created several multi-functional spreadsheet tools to automate merchandise planning and distribution using Excel VBA. These noteworthy and innovative “One-Click” tools retrieved information, updated formulas, revised layouts, and enhanced existing user forms across more than 300 spreadsheets within 79 interlinked excel workbooks.

Aquent, LLC July 2006 – September 2011

Live Nation Project, Beverly Hills, CA

Marketing Consultant and Project Manager (Responsibilities Equivalent to VP Analytics)

Provided fact-based, tangible recommendations supporting all Live Nation / Ticketmaster ongoing and seasonal promotions, and marketing dollar allocations using Excel VBA macro development for both periodic and ad hoc reporting.

Analyzed Omniture based promotions data to implement promotion scorecards supporting all major promotions

Uncovered major reporting issues from Omniture resulting in an overhaul of the Omniture system on the Omniture side.

Provided useful insights gained from analytics to the decision making process, to drive marketing spend optimization across 17 North American regions, 4 venue types, 8 lines of business, more than 6,000 venues, 7,000 to 9,000 shows per year (local and touring), 9,687 artists and partnering artists, 15 music genres, and 9 media spending types (radio, TV, print, online, advertisement production, poster production & distribution, flyer & street team, billboard, miscellaneous)

Established, calculated and reported statistical trend analyses to improve media spending patterns, attendance and capacity trends, ticket revenues (ROI), and onsale/event date timing using complex Excel functions & cross-referencing formulas (vlookups, pivot tables, nested functions, arrays, & custom macros)

Metrics including spend per fan, spend per show, budget per show, fans per show, ticket revenue per advertising dollar, and attendance/capacity artist rankings were analyzed over specific time periods to forecast cash flow requirements and provide information regarding ad spend timing – each metric analyzed overall and segmented by region, media type, venue type, lines of business, music genre type, and specific venue to pinpoint success trends and high stress areas

Geographically segmented fan base according to music genre sales trends

Ensured reporting consistency through VBA enhanced data management strategies

Customized monthly and yearly reports to each of 17 regions regarding their specific venues, lines of business, music genres, upcoming and played shows, budgets, fluctuations in media distributions and the effect thereof on each metric

Used Excel VBA to prepare thousands of customized real time data driven graphics for each region and associated venue types, lines of business, and media spending types to visually demonstrate key metrics in presentation format

Maritz, Inc. Project, Torrance, CA (Project Completed)

Visual Basic Consultant (Responsibilities Equivalent to Software Development Engineer)

Visual Basic Development: developed a market analysis survey and interactive sales volume tracking tools in Excel for multiple automotive dealerships

Moelis & Company, Los Angeles, CA (Project Completed)

Presentations Consultant

Responsible for preparing financial presentations to assist management

Transcribed financial information into presentation documents using Word, PowerPoint and Excel

Nestlé USA, Glendale, CA March 2005 – September 2005

Marketing Project Manager and Marketing & Supply Chain Analyst (Project Completed)

Performed key functions within the Supply Chain team within the Confections Marketing Team including Project Management, Demand Forecasting, and Packaging Design & Production

Responsible for vendor and database management using Excel & SAP

Acted as a liaison to the sales team, and managed key seasonal inventory initiatives

Develop and maintain replenishment models (regression analyses & other statistical modeling) for sample inventories.

Zoned in on inventory and sales allocation trends to underscore opportunities and risks while reducing out of stocks and excess production

Smoothed and streamlined existing vendor/client relationships based upon the needs of all involved

Herbalife, Century City, CA March 2004 – September 2005

Lead Product Specifications Analyst (Project Completed)

Created product specifications using Adobe Acrobat Professional

Developed internal quality assurance processes and standards that resulted in improved vendor/client relations (voluntary & outside job description)

Contact this candidate