Analyzed income and expenses for the previous ten years and developed the Fall 2010/Spring 2011 budget forecast utilizing Excel spreadsheets. Developed plans to reduce expenditures and increase income to validate the continuation of the group after the 2012 Spring Concert season, in spite of significant loses in 2008 and 2009. Analyzed income and expenses from the 40th Anniversary Concert and developed the Fall 2011/Spring 2012 budget forecast, which included the 45th Anniversary Concert. Validated that a profit could be expected, no matter what type or scope of concert utilizing Excel spreadsheets.Developed the Fall 2012/Spring 2013 budget forecast utilizing Excel spreadsheets, which included income and expenses for the Video Games Live performance. Analyzed income and expenses from 2001 to 2008 Christmas Dinner Concerts versus proposed 2013 Yuletide Feast to determine viability.Developed the Fall 2013/Spring 2014 budget forecast, which included income and expenses for the 2013 Yuletide Feast. Analyzed income and expenses to validate continuation of the Yuletide Feast and determine viability of a Bluegrass Mass in the spring and a cabaret in the summer utilizing Excel spreadsheets.

Designed, implemented and maintained a SAS auditing system that validated accuracy of nightly data before it was transferred to downstream applications. Designed and implemented programs and macros that validated the movement of historical Tesseract transaction data into a PeopleSoft transaction instance.Designed, implemented and maintained SAS programs that aggregated and classified transactions and uploaded them to an application for company-wide viewing.

Developed and modified SAS programs for HR system data conversion and nightly batch audits, which ensured that Transaction and Reporting Data Bases (RDB) were in sync.Analyzed data and developed programs to analyze and audit conversion and reconcile Core to Looking Glass international data within HR RDBs.Analyzed data and developed programs to audit loading of HR data from the RDB to the Training Information System (TIS). Audits ran nightly and were customized to handle the idiosyncrasies of TIS and support Y2K. Created a system of International Integrity audits (IIA), which validated data between RDB and Looking Glass international feeds. Developed audits to validate the addition of algorithmically populated data elements to support data joins in tools accessing data. Developed programs to provide RDB data for Single Sign-On (SSO) and validate data with domestic and international feeds. Developed programs to validate the effects of the Tesseract maintenance release on the RDB. Created macros to generate reporting relationship structures and populate with current information of employees in those positions. Analyzed data and developed programs to audit conversion and reconciliation of non-employee and visiting scientist data within HR RDBs. Created batch audits for monitoring data reconciliation run on a weekly basis. Developed a system of macros to generate a position direct-report hierarchy given a supervisor position. Modified existing nightly batch audits and developed numerous ad hoc audits and reports to support Y2K. Added warning level to the failed level in existing nightly batch audits, which triggered downstream processes and data feeds.Developed programs to audit changes of security grant access to the RDB by employee or position number using a Top Secret userid. Analyzed and created audits for actions in the RDB not tracked within the transaction database.

Developed and implemented Needs & Interest scoring algorithm for discounted and undiscounted revenue levels on a customer and household basis consisting of a 12-month window of residential usage and demographic data. Statistical analysis such as gains, loses, win backs, churn rates and various market level and savings plan forecasts were generated using initial scoring. Developed algorithms and created categorical variables using the data at individual customer and block level for use in an Expectation Maximization (EM) model.Taught SAS programming and data analysis to newly acquired personnel and performed initial background analysis, handing off for further analysis and implementation.Created, enhanced and maintained a system for the Market Analysis and Forecasting group, which created numerous databases and reports and were utilized for data forecasting and customer tracking of private line billing information. Monthly data was aggregated to various level Oracle databases, including a year-to-date level, and exported to a local area network.Created and maintained monthly downloads of financial data to a UNIX system. Files include aggregation and dispersion of transfer price cost of goods sold based on sales and returns of business customers.Analyzed a customer perception study involving sales, quality, maintenance, installation, billing and reputation rating data. Developed forecasting models using attribute and sub-attribute responses to predict market share at an industry, region, account strata and overall level for telecommunication services.Evaluated SAS and SAS/Assist versus Oracle in a database consolidation and standardization project of customer perception study data in existing databases.Technical expert in survey questionnaire development, and liaison with data collection vendor and sample provider. Performed statistical analysis to remove outliers, recoded data and developed forecasting models.