Michael Mellert

• Created ad hoc and production datasets, text files, MS Access Databases, and MS Excel Spreadsheets for use by the Sears Credit Programs Product Management Department (Data Base Marketing) and Risk Management. • Selection (inclusion and exclusion), segmentation, and control group creation for customer mailings, convenience checks, statement check and insert offers, Rewards fulfillment compliance and mailings, Customer Service offers and non-monetary credit card transactions. • Data extraction from monthl

• Create Adobe PDF Documents and MS Excel Spreadsheets for distribution to approximately 3,000 Sales Representatives and District Managers every trimester (four month interval) using SAS and MS VBA. • Reports included sales statistics by representative and region, market share by region, and growth of share by month within region. • Maintained and operated the Call Planning Reports each trimester as requirements and data inputs changed. • Created ad hoc datasets, text files, MS Access Databases, and MS E

• Extract Sales data from databases, text files and MS Excel spreadsheets into SAS for use by Marketing Research and Sales Analysis for analysis. • Various data was used to determine sales force effectiveness, sales person bonuses, competitive market share, market share growth trends, and other sales data useful to ZS Associate’s customers. • Created ad hoc reports and spreadsheets for various customers, including competitive prescription information (IMS) by doctor, pharmacy (point of sale), and region,

CIS/Business Administration