Built and manage Faneuil’s foundation database on Oracle. Database is comprised of over 6 million US households. Database contains demographic and vehicle information. 

• Built and analyzed marketing databases for Faneuil’s clients. These databases were then used for marketing purposes. Projects included:
• A Gasoline Fortune 500 company interested in increasing the number of gas credit card holders. The results were then put on a web page, enabling other Faneuil employees to view and add input to the analysis.
• A Bank interested in profiling existing customers. For this client, a web page was setup so that the client could see how the analysis was coming, and could request and see the answer to ad hoc questions on a real time basis.
• A Baby Bell for whom Faneuil telemarkets telephone equipment and services. This client, like the others, provided a target list which was uploaded into Oracle and overlaid with demographic information. This new database was then analyzed using extensive crosstabs, as every record needed to be ranked according to its likelihood of generating a sale. After every record was assigned a ranking, the database was transferred to the Call Center for telemarketing. A web page was built showing the results by ranking on a daily basis. This campaign is renewed every year. This past year, the Baby Bell had their data overlaid with Microvision. Using the Microvision codes, the results were shown daily on a web page ordered by the best codes. This enable the Call Center manager to exclude households not likely to buy. This joint effort lifted calling success by more than double.
• In all instances, overlays were required from Experian, which I arranged.
• Developed Internet Reporting. Internet Reporting involves Perl scripts with embedded SQL. These scripts are run on a Linux server, which communicates with the EIS Centenium calling platform. The back end database of this platform is an Informix RDBMS. The scripts generate HTML, which is then FTPed to the web server. The scripts are set up to run automatically and in some cases every hour. This enables the managers of Faneuil’s call centers to see the progress of calling campaigns on a real time basis, any time, anywhere in the world provided he/she has internet access.
• Managed IT staff for the intent of maintaining computer systems. Systems included Unix E450 running Oracle RDBMS 7.x and Oracle Express, Linux Web Server running Apache, Netware 4.x, NT workstation running Checkpoint Firewall, Hubs, Switches, CSU/DSU, and UPS, in addition to general PC support.
• Served as web master.

• Setup new research office in Orem, Utah. Duties included selecting suitable location and office, setting up computer and telecommunications systems, getting furniture, and other related activities.
• Build and analyze stock market databases.
• Wrote and had published in-house a pedagogical document describing the issues surrounding proper sample size determination.
• Analyzed proprietary database with the intent of finding demographic segments most likely to purchase certain kinds of vehicles.

• Examined primary market data to measure and improve customer satisfaction. Projects included:
• A regression analysis of customer satisfaction surveys to determine the factor most important in influencing satisfaction.
• A chaid analysis for an insurance company to determine which policyholders should be targeted for renewal and
• A cluster analysis for a dental network for the purpose of categorizing dental prices by zip code across the United States.
• Analyzed marketing research issues, including proper sample size, CHAID, and database design. Projects included:
• A paper outlining how to find the correct sample size for different populations i.e. large vs. small & averages vs. proportions.
• A paper outlining the mechanics of CHAID analysis, and a major paper which discusses database design as it relates to scripts in the context of market research.
• Developed systems for reporting and research design. Projects included:
• A system designed in Paradox for an automobile repair franchise which scored each store according to customer satisfaction by store, market and region (this system includes a data entry interface capability.)
• Graphical reports generated from a database which contains surveys of customers from a tire store franchise and
• Lead generation reports produced in Excel for an insurance company.
Served as Network Supervisor and PC support specialist. Responsibilities included: loading software, trouble shooting, fixing software, correcting printing problems, putting machines on the LAN, answering software questions, and transfer of data to and from multiple platforms (i.e. ascii, spreadsheets, databases, wordprocessors, graphics packages, statistical packages).

Conducted systematic review of hotel pricing policy. Project included capturing average daily rate data of all major hotels in the Salt Lake City downtown area into a useable form, performing a series of dummy variable regressions (day and month were used as the dummy variables), determining the price elasticity for this particular hotel.

• Gathered information concerning proposed amendments in State tax code with the intent of discovering the fiscal impact on the State of Utah. Duties included: Comparing current tax code legislation to proposed amended tax code legislation to find real differences, and calling businesses and various professional associations to determine in what way their business practices and sales affected the State fiscally.

Aided in the analysis of proposed legislation. Responsibility entailed studying all relevant aspects of legislation to determine how and by how much the state would be impacted fiscally.

• Compiled data on futures market.

Maintained database.