Bruce Cassell Email and Phone Number

* Developed automated daily sales and marketing reports for sales and marketing managers* Designed and developed the gross margin, COGS, and operating expense variance calculations for consolidated and unconsolidated reporting* Gathered organization criteria to develop key performance drivers roiPE dashboard tool * Led in depth business intelligence analysis compare of roiPE, Tableau, and PowerBI* Trained users on dashboard models and warehouse reporting criteria and techniques* Partnered with Monsanto to integrate ERP system and masterdata hierarchies* Developed and maintained masterdata alternate hierarchy process for US divisions * Collaborated with SME to develop efficient way of automating authorization process for end users* Completed the divestment of Animal Health business to Elanco Animal Health Corporation

Lead for the Oracle systems development and implementation work: * Gathered requirements for business intelligence system design for reporting and planning* Designed analytical solutions in EPM dashboard/models for planning and reporting* Created business rules and calc scripts based on business and functional requirements* Developed application/models for controlling and demand groups* Consolidated ODI script packages into groups and rebuilt interface jobs* Maintained the EPMA masterdata change management processSupport and maintain the operational planning and reporting process:* Processed the month end close load and validation process for all report apps* Delivered training to the Shawnee and Kansas City plant locations* Ran the assessment process for all divisionsSupported the SAP data warehouse for Bayer US and explored efficiency opportunities:* Partnered with project leads to eliminate hurtles during discussing meetings* Analyzed trading partner breakout as journal entries instead of top side adjustments* Delivered training to Shawnee and Kansas City plant locations Promoted from previous position - Senior Financial Specialistpromoted from previous position - Financial Specialist

* Implement and support Hyperion Reporting for all aspects of cost, planning, and analysis * 2010 Budget season, gathered and analyzed business requirements and developed improvements for break link revenue process, developed profit center dimension, and updated partition mappings* Supported and maintained the DRM metadata management tool* Maintain security for all users of the Hyperion suite of tools * Support HFM consolidations and metadata update processes* Created an MDX calc that track the beginning and ending inventory in the Daily INV ASO cube* Wrote multiple maxl and calc scripts to use the new profit center dimension* Created ASO cubes and maxl scripting for everyday and shrink reporting in Hyperion * Partnered with IT and implement the Hyperion Shared Services Security server upgrade

* Managed the PeopleSoft ERP and Hyperion Warehouse Reporting systems for Embarq* Supervised a staff of 6 employees that support Hyperion HFM Consolidations, Analyzer Dashboard, Planning, Essbase, Financial Reporting Studio, Smartview, and Shared Services* During the Spin off from Sprint to Embarq I trained my staff and oversaw all reporting, security, business owned applications, and Hyperion systems that we stood up to support Embarq. Sprint managed these same systems with 20 employees, and I managed them with 6.

* Supported the financial analysis of the financial statements* Implemented and supported the combination of Sprint and Nextel ERP 8.4 budget solution * Liaison lead between the Finance group and the IT contractors and IBM programmer groups * Wrote the requirement documentation for the budget upgrade project from ERP 8.4 to EPM 8.8* Gathered and wrote the requirements for the SNS budget project from ERP 7.5 to ERP 8.4* Developed and tested multiple projects: SNS ETL, A/R BWM, and Refund Phase I & II * Implemented the PEAS (Period Expense Amortization System) project* Worked with IT developers on various conversion and allocation projects* Taught PeopleSoft budget and reporting to end users