Clemence Castillo Email & Phone Number

Beverly Hills, California, US

• Expanding responsibilities to include supporting venue business development
• Creating new value and insights by leveraging data sources that have never been used before
• Many more to come

Beverly Hills, California, US

• Built a team from zero employees to four Sr Analysts and Analysts
• Mentored, coached, and managed employees of different experience levels, motivations, and communication styles
• Presented revenue-generating opportunities to operational leaders by analyzing third-party rebate deals and providing routing recommendations
• Managed the division’s entire concert pipeline reporting of confirmed deals, offers outstanding, and discussions in progress.

Beverly Hills, California, US

• Nominated and awarded Rockstar Award
• Utilized SAP Business Objects for insights and analytics on a by-tour basis
• Built Monte Carlo simulation to assess the risk of approving tour business plan forecasts
• Supported development of streamlined business plan templates and approval process
• Programmed user friendly VBA macros to save hours from repetitive manual tasks

Westlake Village, California, US

• Developed and shipped automated month-end reports for efficient decision-making
• Presented self-service analytics tools to executive management and finance teams
• Supported month-end close process and ensured department-level reports are accurate
• Analyzed balance sheets, income statements, and P&Ls using BI360 automated tools
• Coordinated with various teams to maintain data integrity and reconcile data sources
• Maintained product roadmap for project roll-outs utilizing Agile principles and values

Westlake Village, CA, US

• Analyzed $300M sales of warranty, private label credit card, and gift card services
• Increased sales 10% by negotiating vendor-sponsored incentives to sales team
• Expanded marketing activities for promotional services and incentive programs
• Produced excel forecasts, sensitivity models, and reports on performance metrics
• Used business intelligence tools (SQL, MicroStrategy) to accelerate analysis
• Researched competitor’s products and promotions to adjust plans as necessary

Westlake Village, CA, US

• Nominated for Outstanding Service Award out of 10,000 employees
• Created $300M budget and ended 2016 favorable for first time in over four years
• Saved $8M per year in variable labor expenses by conducting Time & Motion Study
• Conducted User Acceptance Testing (UAT) for DayForce application upgrades
• Updated revenue recognition and automated reporting to free 10% of workweek
• Advanced 10,000 employee pay cycle from Semi-Monthly to Bi-Weekly

Atlanta, Georgia, US

• Awarded General Manager of the Quarter out of 800 managers
• Guided team of 20 to rank 9th in company for overall performance
• Maintained <0.9% product waste in 12 stores as Expenses Captain
• Delivered 8% sales increase per location per year as Sales Captain

Study Abroad, Global Business

Master Of Business Administration (M.B.A.), Finance & Applied Analytics

B.S., Business Management