Mark Koester Email & Phone Number

Prairie Village, Ks, Us

Greenfield, In, Us

• Develop effective forecast models based on industry trends and demand patterns.•Successfully communicate forecast and inventory estimations to cross functional team.• Monitor and report on important changes in sales forecasts, budgets, and business strategies.Coordinate with KAMs, Brand Managers and Supply Chain to understand demand planning needs for Sales and Operation Planning.

Houston, Tx, Us

• Responsible for the reporting and analytics needed to support strategic go-to-market initiatives.• Work directly with Sales Operations leadership on business-critical reporting needs.• Create and maintain reports tracking standardized sales process, KPIs, and executive dashboards.• Work cross-functionally across sales, merchandising, revenue management and finance teams.

Kansas City, Missouri, Us

• Led activities involving allocation/replenishment and executing inventory strategies.• Influenced and problem-solved through relationships with Hallmark merchants and vendor partners.• Evaluated, forecast and drove store business from rooftop level planning product including seasonal aspects.• Completed weekly store/sku analysis to maximize sales while minimizing risk.

Kansas City, Missouri, Us

• Administrator for Blackline financial and accounting software. Managed all user access and the import of data into Blackline.• Administrator and script writer for Winshuttle SAP process automation software. Documented, trained and troubleshot the transition from version 10 to 11.• Administrator for Crown Financial Services Accounting SharePoint site. Created International Request for Appropriation from using InfoPath Designer.• Responsible for several SAP processes including system allocations, currency revalues and the scheduling of automated clearing.• Responsible for several regular reports including, cash flow summary, Canada fixtures capitalization, profit in inventory and depreciation forecasting.

Kansas City, Missouri, Us

Model Line Architect III (Jan.2014-Present) Category Analyst III (July 2013-Jan. 2014)Category Analyst II (Sept. 2010-July 2013)• Provided analytic resolutions to business partners. Regularly interfaced with marketing, finance, I/T and other areas. Improved and created reports with various platforms including Excel and Tableau for the department.• Managed a team that was responsible for getting skus into multiple systems and identified, defined and directed the implementation of appropriate and accurate coding of sku traits that drove revenue generating business decisions. When our team took over coding accuracy went from under 20% to over 98% in a year. • Developed customer specific model lines by translating the master product offerings into actionable customer assortments that maximized sales and return on investment choices. • Collaborated with customer teams and product marketing in support of each individual differentiation strategy. Formulated cohesive strategies to maximize return on assets, and made recommendations that promoted change and increased productivity. Developed and reviewed all reports required for approval of the customer specific offering with each individual customer teams.• Responsible for ensuring financial targets were realized through the model line choices. Framed choices and collaborated with individual customer teams to identify and implement the best solutions. • Worked with Customer teams and Project Managers to better link and predict Average Price Available information from inception in the MPO through RSI.

Kansas City, Mo, Us

• Assisted in the enforcement of payment and collection policies for the new collection department within the cashier office.• Improved and created new reports for the department. Saved workers hours each day by using a vlookup or index/match functions to bring information from one spreadsheet to another.

Armonk, New York, Ny, Us

•Converted over 100 reports to Cognos Report Studio and Query Studio Reports.•Worked with users and coordinated with developers to understand and capture reporting requirements.•Documented and communicated all updates to report writing documents.

• Identified process improvements and developed systems using available business intelligence resources to control cost and evaluate company productivity and performance.• Created an audit system using a series of spreadsheets and relational Access tables that verify employees claimed time against worked time saving the center over $1400 a pay period accounting for over $36400 in savings during 2008.• Set up updateable MS Excel links that more accurately and quickly updated a Results Tracker KPI report that combines several loss and goal reports into one simple to read report.• Utilized Impromptu and MS Excel with nested if statements and vlookup functions to significantly reduce manual update time on a monthly complaint report.• Participated on core project management teams in the implementation of two systems. Worked with different departments to ensure key objectives and deliverables were fulfilled. • Trained over 250 employees and management and helped to design training for new time keeping system. Also created all reporting methods in new system and trained peers in reporting techniques.

Analyzed financial data and developed account specific plans designed to reduce company loss. Worked closely with dealers, customers, independent contractors and coworkers to resolve delinquent accounts or recover company collateral.

Implemented interpersonal communications skills to ensure customer satisfaction.