Michael Crane Email & Phone Number

Aurora, Il, Us

Aurora, Il, Us

Us

Us

Deerfield, Il, Us

- Lead role for fee analysis and forecasting for select pharmacy payers on a weekly and monthly basis. Coordinating budgets for the long range planning models and reconciliation with accounting. Responsible for all aspects of the process and recommending any forecast changes.-Responsible for weekly gross profit analysis for all pharmacy payers including brand rate variances and trending for all financial drivers of the profitability.-Use basic knowledge of SAS and SQL coding to create queries for weekly profitability analysis and any ad hoc individual pharmacy payer results.

Rosemont, Il, Us

Senior Analyst – Customer Information Management Team (current role)-Member of the Database Change Ambassador Team as nominated by Senior Director of Merchandising Finance.-Lead for Data Governance Team for Processes and Procedures and Customer Data Standards.-Responsible for all analytics for customer data for financial metrics.-Responsible for role in establishing baselines and organization to build customer segmentation.-Work with other analysts to build workflow timelines and assignments for specific projects and ad hoc requests.-Validate monthly vendor files for accuracy. Built MS Access query to find errors. Coordinated this work process with other analysts. Created a separate high profile customer list to track against vendor files to prevent inaccurate customer data from downloading.-Assigned lead role in creating and maintaining all database analytics for Executive Leadership Committee.-Take part in all UAT testing for multiple databases as needed.-Point person for Team on any analytical questions or scenarios as needed.-Currently training other analysts on excel formulas and weekly customer data reports with MS Access.-Lead person on all IT uploads for new customer data.Pricing Analyst/Senior Analyst-Created template for total sales by customer with promotional allowances analysis.-Worked with Poultry, Dry Grocery, Fruits/Vegs Category Teams for pricing analysis.-Created a template to show Top Performers with projected case conversions for incremental gross profit by division by product number. Used for Q4 Scorecard for all divisions.-Created Rate Variance report for allowances & gross profit for all categories to show top performers and lower performers by product number.-Created weekly allowance & gross profit projection template to track against year over year company-wide metric.-Created Commodity/Non Commodity analysis template to show by division 13-month rolling trends in sales

Chicago, Il, Us

Assistant Buyer – Footwear (Athletic and Work Boots)-Performed all day-to-day merchandise functions for work boots.-Responsible for calculating and placing all buys. Provided input for assortment with vendors and partners.-Approved all contracts in Rockport.-Built marketing plans each month with financials and advertising using key metrics.-Did all approvals for advertising MRM and online imaging with page confirmations.-Reviewed all advertising Bar Graphs each week to verify preprint accuracy and store signage.-Did monthly Post Mortem sales analysis for Open to Buy meetings and reported results to VP & DMM.-Created new item submission sheets for dotcom and work wear catalogs.-Created all samples tags for marketing and catalogs and handled all samples.-Answered all work boot Help Tickets from retail store associates.ACHIEVEMENTS: Completed Apprentice Training Program 2007. Twice received Apprentice of the Week Award as voted by group for contribution to the team. Received Buyer of the Month certificate in April 2007 & May 2007 in Automotive as part of the Tire Buying Team.

-Responsible for financial reporting on all of the General Motors divisions. -Central contact for all promotional related questions for corporate sponsorship contracts. -Performed all financial analysis of promotional contracts and corporate sponsorships. -Performed all asset reviews and compliance requirements for GM Business Process Controls.ACHIEVEMENTS: Created an accounts payable tracking system that was adopted by all offices. Lead role in achieving Satisfactory Rating on external audit for first time in office records. Created approval process on all contract payments that were used by Detroit purchasing. Created an asset tracking database to ensure proper IRS reporting.

Master Of Business Administration (Mba), Management/Finance

Business/Commerce, General