Drew Simon Email & Phone Number

New York, Ny, Us

New York, Ny, Us

Montvale, Nj, Us

Hoboken, Nj, Us

Hoboken, Nj, Us

• Develop financial models to improve forecasting and budgeting accuracy for the Knowledge & Learning division. Using a combination of historical trends and editor input, the models have been back tested to have only a 2% variance to the actual results.• Analyze monthly results and present to business partners and senior leadership. Identify drivers that cause a variance to the plan and are having a significant impact on the business.• Partner with the editors to understand their key metrics and then create new dashboards and/or reports that provide deep insight to how the business is performing. • Build cash flow models for potential new deals and partnerships. Model various scenarios that allow Wiley to make the highest profit while minimizing risk.

Teaneck, New Jersey, Us

• Drive high priority Ecommerce business initiatives that will increase sales and conversion. Use agile methodology to lead sessions for discovery, requirements, design and testing.• Use excellent problem solving skills to design high level solutions within given constraints.• Partner with project manager through all stages of the project to deliver solution.

Parsippany, New Jersey, Us

. Optimize US dotcom fulfillment network that does $1.1b in sales by distributing and fulfilling orders in the most cost effective manner. Create allocation templates and strategies using Manhattan Order Management System (OMS) that best utilizes the fulfillment network. . Improve recovery rates on returns and aged inventory by using marketing strategies and third party software and websites. . Achieved $6m in network cost savings in 2016 by strategically placing items in fulfillment centers, optimizing the engine logic that distributes orders and adding regional carriers. . Ensure dotcom orders in all fulfillment channels get closed out within the service level agreement and analyze key customer facing metrics such as aging orders, on time delivery and cancellations. Determine root cause and develop action items to improve metrics. . Ad hoc data analysis on demand/shipping trends and identify any potential savings and/or improvements to the network.

Parsippany, New Jersey, Us

• Constructed national tests on radio, insert, and display marketing, analyzing the lift in sales using APT software.• Designed store tests for new products and major design changes, reporting sales results to business leaders who own the project. • Created a visual dashboard of store performance using Tableau software, helping to identify store outliers.

Parsippany, New Jersey, Us

• Supported the Consumables and Infant Care Division, which has annual sales over $1.2b spread over eight departments. • Reported daily on sales volume and promo mix, down to the class level, and use that data to forecast the sales and margin dollars for the remainder of the week. • Compiled information provided by merchandise planners each month to forecast sales and margin dollars for the entire Division.• Lead an effort to reduce inventory levels by identifying potentially obsolete inventory.• Advanced use of Excel, moderate use of Access, Oracle Database, and SAP’s Outlooksoft.

Parsippany, New Jersey, Us

• Analyzed monthly performance of the domestic brick and mortar stores, focusing on the supplies and visual signage the stores use. Identified outliers and expense accounts that deviate from the normal usage and further investigated the charges.• Supported our Express Program, assisting real estate in finding profitable locations in malls and outlets and then reporting on their performance.• Collaborated with procurement and store operations to examine charges from vendors and reduce erroneous charges. This has resulted in a nearly one hundred thousand dollars in company savings.• Budgeted the 2012 store operation expense accounts for the entire domestic chain. During the process I partnered with the store operations team to identify savings in certain accounts and how to better spread the funds. Also worked with the VP of Flagship stores in a separate process to set the 2012 Flagship budget.• Created monthly P&L and EBTIDA reports and sent out to Regional Vice Presidents and District Managers. I then fielded any questions from store and district managers and researched their questions.• Enhanced a model that analyzed store performance by various attributes, such as store size, store location, and store type. Analyzed results to identify possible expense savings.

Analyzed ten years of market data and over fifty economic variables to identify leading price indicators of Secondary Market Indices for GE's Bank Loans Group. Created predictive model using SPSS and SAS statistical software.Presented findings and recommendations to executive leadership.

London, Uk, Gb

Analyzed financial statements along with industry research to rate current and potential customers' credit worthiness. Incorporated findings into summary report that included environment and company specific factors as well as operating trends and future predictions.Monitored covenants to ensure clients were in good financial health and within acceptable limits outlined in the credit agreement.

Zurich, Ch

Handled client communication, database management, and buy/sell orders for financial advisors, some dealing with high net-worth clients. Led an effort to improve UBS's account opening procedures and software by leveraging my previous information technology experience.Reduced time spent on mailings by streamlining the mail merge procedures.Updated, managed and created new client accounts after learning UBS's proprietary software.

Global, Us

Developed test cases and numerous scenarios to run when transferring to new version of software. Organized the resources necessary to conduct testing; including personnel, equipment, and time/location.Coordinated and acted as liaison to communication information between end-users and the IT department to execute implementation plans and execute test runs. Updated project plans weekly to document tasks completed and flag tasks needing attention.Created 'Business Use' cases in Microsoft Visio to document current and future procedures.Gained experience in database management, project management, application testing and business architecture in both small and large group environments.Received 'Consistently Exceeds' rating and promoted from 'Associate' to 'Staff' during the annual review conducted in March 2007.

Mba, Finance

Education record