SUMMARY:

• Senior level data scientist, SAS developer and analytics systems engineer with 16 years professional experience specializing in design, development and implementation of large scale analytic projects for organizations including Catalina, Kellogg, Confidential and Confidential .

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg IL

SAS / Netezza Developer Consultant, Data Science

Responsibilities:

• Created SAS Macro libraries of tools to identify shoppers and estimate revenue of new dynamic targeting programs utilizing Catalina's 280 million shopper transaction level Netezza database via SAS Enterprise Guide.

Confidential, Dayton OH

SAS Programmer and Analytics Applications Administrator

Responsibilities:

• Monitored work load on servers and identified algorithms to improve processing efficiency of SAS ETL processes.
• Responsible for daily administration and server setup for regulatory reporting applications (HEDIS CareAnalyzer, MDE Encounters Pro), Teradata Enterprise Data Warehouse ETL servers and Microstrategy BI Reporting system

Confidential, Chicago IL

Consultant

Responsibilities:

• Used SAS and Unix scripting to create a work flow which analyzes households in the Catalina Frequent Shopper Card data universe and their exposure to a partner's internet ad exposure database for post - event measurement and pre-event targeting.

Confidential, Indianapolis, IN

Consultant to Business Intelligence Department

Responsibilities:

• Performed root cause analysis of issues related to the migration of a reporting system utilizing SAS 9.1.3 to SAS 9.2.

Confidential, Battle Creek, MI

Consultant to Business Analytics Departmentr

Responsibilities:

• Reviewed and update of Walmart pricing analysis code which reduced run time from 5 days to 20 hours by reorganizing pre-processing of Walmart retail link data and reducing I/O steps.
• Updated store level modeling processes which use IRI store level data. Changed code and work flow process from one program per product to one program that completes the analysis for all products. Reduced run time by 50-75% per product by updating source data import procedures and using the macro processor to dynamically create price points to model at run time.

Confidential, Chicago, IL

Lead Specialist - Go To Market Information Solutions

Responsibilities:

• Created algorithm which linked internal shipment data and event calendars to IRI syndicated point of sale data.
• Created algorithm which calculates lift factors, incremental revenue per trade dollar spent, promotion profitability, and cannibalization effects for 3 years of promotions for 8 large grocery chains.
• Clustered promotions into groups based upon price point, display location, and inclusion in feature advertisements.
• Using Tableau software, created reports which displayed results and recommended actions to Frito Lay management.

Confidential, Schaumburg, IL

SAS Consultant, Research & Development Department

Responsibilities:

• Assisted with the ongoing development of SAS processes that maintain and create 20 million UPC product characteristic databases, which are used as source data for analysis projects.
• Assisted in the development, implementation, and periodic refreshes of an application that examined market share and identifies sales growth opportunities for a major soft drink manufacturer from a 90,000 panelist 2.3 million UPC sales trend database.
• Developed and implemented an algorithm which creates Promoted Product Group classifications based upon in-store promotions, product characteristics, and sales volume for all food UPCs.

Confidential, Downers Grove, IL

Consultant to Forecasting Department

Responsibilities:

• Using SAS, created the reports and definitions used to determine list of menu items and menu item groupings for an automated restaurant ordering and replenishment system based upon product sales volume and frequency.
• Completed key issue analysis of existing forecasting system to determine a list of needs for future development prior to the launch of the expanded system.

Confidential, Chicago, IL

Senior Programming Analyst

Responsibilities:

• Created SAS macro library used to clean raw survey data according to specifications provided by the client. Cleaning specifications included items like processing missing values, identifying skip patterns, creating a sample disposition which identified the level to which the respondent completed the survey, consistency checks on questions which had a relationship to other questions in the survey, and identifying outliers on questions with numerical responses.

Confidential, Auburn, IN

Consultant

Responsibilities:

• Assisted with the start-up of my family’s business targeting sales and distribution of aerospace grade insulation products to industrial manufacturers and suppliers in the Midwest.

Confidential, Downers Grove, IL

Forecasting Analyst

Responsibilities:

• Model / Code Development Projects using SAS:
• Developed and implemented restaurant level sales seasonality and holiday adjustment model.
• Created unreported promotion detection algorithm to adjust historical baselines for promotions not reported by Confidential ’s. Resulted in reduced volatility of baseline forecasts due to unforeseen events in sales data.
• Updated production SAS code with process improvements such as utilizing new data sources, reduction of processing time.
• Led project to create and develop processes and tools for forecast exception management identification and correction in SAS:
• Designed SAS AF based operational task tool used to complete day-to-day exception management. The tool enables the user to complete all aspects of a work flow within SAS, resulting in higher efficiency and consistency in decision making.
• Developed and implemented SAS macro library of standard tasks to be performed in the tool such as common data queries, reports, graphing, and updates of production datasets that contain forecast input parameters.
• Responsible for accuracy, production, and communication of daily promotional packaging and new food item forecasts used to generate individual restaurant shipment quantities.
• Worked with internal users of the forecasts to reallocate forecasts based upon information gained after the start of the promotion.

Confidential, Indianapolis, IN

Senior Inventory Analyst

Responsibilities:

• Created inventory availability reports used to maximize usage of inventory through all distribution channels.
• Developed and implemented affiliate inventory reporting and implementation procedures, which reconcile resort developer point allocations and inventory ceded to Confidential to ensure proper levels of inventory in the reservation system.
• Worked with resort representatives to complete valuation of resort properties. Determined initial sales and reservation point values through application of model that determines point values based on resort quality, resort amenities, and region demand.
• Monitored and reallocated inventory based upon future demand forecasts and upcoming promotions.
• Responsible for and assigning work to Inventory Analyst.

Confidential

Information Analyst

Responsibilities:

• Produced trend analysis reports. Reports were used to make recommendations to management and peers for inventory utilization and business forecasting in weekly timeshare reservation system.
• Enhanced existing reports and developed new methods for standard and ad hoc reporting by creating an automated SAS process to produce and distribute reports of key business metrics.
• Led project to create a SAS program and data library, used to increase efficiency though use of standardized code and reports.