Dave Dreyer Email & Phone Number

Shelbyville, Indiana

Batesville, Indiana 47006

Administration of IBM Cognos Business Intelligence software used by 150 Sales Representatives and Sales management, 100 Logistics Field and Manufacturing personnel, and 40 home office users. This also included supporting & training the in-house IBM Cognos report developers in an effort to make them self-sufficient using this B.I. tool. Also, ETL Specialist supporting Informatica software for extracting, transforming and loading data from J.D. Edwards Enterprise software into Oracle Database and publishing into IBM Cognos packages. This also included creating and executing the required SQL statements to build required DB tables and validate data loaded.IBM Cognos Administration, Project Management, Training, Report Development, End User Support, Informatica PowerCenter, Department Budget, Policy Deployment, PowerPoint, Excel, Word

Batesville, Indiana 47006

TMW / PeopleNet GPS Project: Worked closely with the Logistics Dispatch, Garage personnel and our First Haul drivers during the integration of TMW, the new transportation system and the PeopleNet devices that are now installed in our fleet. I produced Batesville Casket’s PeopleNet GPS Driver Training document and trained the initial drivers on usage of the new device in their truck. I also the liaison with TWM and PeopleNet Technical Support personnel during the setup and integration of these systems.Options Engraving & Shipping Decentralization Project: My initial project upon return to the B.I.S. group was completion of the decentralization of the Urn engraving and shipping process. This project realized an estimated net cost savings of over $300,000 per year. It required obtaining and configuring 3 computers, a bar code printer, bar code scanner, laser engraver and mechanical engraver for each of five new sites. This project was completed with little supervision due to the PeopleSoft 8.10 upgrade.Lakeshore Casket Company acquisition integration Business Information Services lead: During the late 2006 and throughout 2007, I led the B.I.S. portion of Lakeshore Casket Company acquisition integration. This included integration of the computer system used by Lakeshore’s owners, sales reps, home office and warehouse facility personnel into Batesville’s systems. Post-acquisition, I created reporting for and tracked billings of previous Lakeshore customers for the owners’ retention bonus.J.D.Edwards, Acquisition Integration, TMW, PeopleSoft, Department Budget, Project Management, Training, IBM Cognos, Policy Deployment, PowerPoint, Excel, Word

Batesville, Indiana 47006

Responsibilities included design, implementation, results tracking and sales rep bonus payout of marketing campaigns, co-operation with others in the Marketing department for implementation of annual casket and urn price increases, produced monthly Policy Deployment analysis and presentation, annual plan development and Marketing representative to weekly Logistics/Manufacturing Routing meeting. Marketing Campaigns produced casket growth at an average of approximately 10,000 caskets per year with the targeted prospect customer group. Marketing Campaigns provided me the opportunity to work with Sales & Marketing executives, Regional Directors and Sales Representatives. I designed and developed functionality in J.D. Edwards that allowed Batesville Casket to implement campaigns that offer payment term enhancements. This is something that Sales & Marketing executives requested, but our consultants told us J.D. Edwards was not designed to do. I also provided J.D. Edwards support for Advanced Pricing and Customer Rebate calculations and payouts, which was produced by the Finance organization.Marketing Campaigns, IBM Cognos, Sales Support, J.D. Edwards, Policy Deployment, PowerPoint, Excel, Word

Batesville, Indiana 47006

I was one of two people selected to represent Sales & Marketing during the Business Transformation / Enterprise Resource Planning Project that converted and implemented our legacy mainframe system to J.D. Edwards. I was the team lead for the Advanced Pricing configuration and Payment Term setup that implemented our pricing and customer programs. I had indirect responsibility for four people that participated part time with the J.D. Edwards configuration. I oversaw and assisted in the data mapping and validation of our customer and program information which helped to convert data of customers, items and rebate history. This was a project that I volunteered to participate in as I saw it an opportunity to utilize my unique skills sets to help transform Batesville Casket Company’s business processes.J.D. Edwards, Business Transformation, Advanced Pricing, Data Mapping

Batesville, Indiana 47006

I provided analysis for Marketing and Sales personnel on customer sales trends and helped to identify areas of opportunity for growth. I also participated in the development of the Marketing and Sales monthly Policy Deployment and Root Cause analysis. I provided information and recommendations (i.e. providing insight of the data) to the Regional Directors and Sales management. I also provided information for the annual price increase and analysis towards the development of new customer Marketing campaigns.For International Business Team, I had responsibilities for the acquired Hawaii distributor, prepared the budgets for the International Dept. (which included Canada as well as International Sales), performed sales analysis for International division. During this part of my career, I received the opportunity to become the Batesville Casket Sales representative for Hawaii and oversaw the personnel of the acquired Honolulu Service Center. This provided me the opportunity to educate the Hawaii funeral directors of all that Batesville Casket Company had to offer. Soon after Batesville Casket’s acquisition of the Hawaii distributor, two of our competitors opened new warehouses in Hawaii. Within 1-½ years both of these competitors closed their warehouses due to lack of customer purchases.

Batesville, Indiana 47006

Performed analysis and compiled annual Business Plan and Strategic Framework. I also maintained Competitive Intelligence data and communicated information to our Sales and Marketing personnel. During this time I reported to the Vice President of Business Planning who later became the V.P. of International/Business Planning. I performed International administrative tasks (i.e. budgeting, data analysis, plan development).

Batesville, Indiana 47006

Provided computer system development and support for Merchandising and Sales departments. I implemented computer training for Sales Regional Directors and their Administrative personnel. Worked to develop the On-Site Business Analysis tool that allowed Batesville Sales reps to complete the Merchandising Analysis and Plan at the funeral home.

Batesville, Indiana 47006

I Managed the Merchandising Services department which ranged from 6 to 9 people. I also presented Batesville Merchandising training for customer trips. During this time, I also implemented a new Merchandising Analysis and Planning system that provided funeral home business planning services. This included the development of funeral home casket price lists and price cards that complied with state requirements.

Batesville, Indiana 47006

Provided computer help desk support and assembly/set-up of computers which included installing computer hardware and software as well as user training. I also did computer programming for Custom Shop Operations and Merchandising Services areas.