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• Worked directly with various teams to diagnose, troubleshoot, and resolve system issues

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