Steve Hoffmeyer Email & Phone Number

Northbrook, Il, Us

Northbrook, Il, Us

Northbrook, Il, Us

Technical expert for Enterprise Level Metrics created for the purposes of executing incentive bonus programs for our agency partners. Assist in developing new metrics, new programs, and ensuring data quality through balancing with financials or other sources.

Northbrook, Il, Us

Responsible for onboarding the Information Services Group, Business Intelligence and Analytics area to the new Allstate Release Management structure following the ITIL Framework.

Northbrook, Il, Us

Manage technical team (onshore and offshore) supporting database marketing in campaign execution, measurement, and analysis. Recently partnered with Marketing and Architecture to select and implement a new campaign management tool, Unica Affinium Campaign, and a text analytics tool, Attensity. We are also bringing new data into the Allstate Data Warehouse from Billing systems and our complaint management system.

Northbrook, Il, Us

Led technical team responsible for support and enhancement of the 24/7 high availability Siebel Call Center customer contact applicationUtilized release schedules to manage project work and production code migrationsStarted utilizing developers offshore to reduce costs

Northbrook, Il, Us

- Built and led a new team through full development lifecycle of a multi-terabyte data mart for marketing research and predictive analytics scoring model development - Established and maintained relationship with the business client in the Allstate Research Center in Menlo Park, California - Provided production support and enhancements for predictive model scoring application - Participated in business intelligence tool evaluation as BrioQuery subject matter expert

Northbrook, Il, Us

- Led 9 Allstate employees and 4 independent contractors- Led team through complete development lifecycle for a predictive model scoring application that produced lifetime value (LTV) scores for all Allstate customers to be used for marketing as part of a major CRM initiative - Provided leadership and knowledge sharing to my team in order to provide production job support and end user support for 5 production data mart applications- Provided subject matter expertise and made recommendations to several business units in Allstate regarding the purchase of business intelligence and OLAP software (Hyperion Essbase, Microsoft Analysis Services, BrioQuery, WebFOCUS, Cognos, MicroStrategy)- Negotiated Software Licensing Agreements with BrioQuery, Teleran, and Comshare

Northbrook, Il, Us

- Coordinated BrioQuery installation for over 150 client PC’s countrywide- Prepared and conducted classroom BrioQuery training for end users- Provided end user support for premium data mart- Negotiated software license agreement for BrioQuery- Developed dynamic web-based reporting application using WebFOCUS and Active Server Pages to be used by over 1500 field sales managers- Designed an Oracle data mart utilizing a star schema design for sales agent performance measurement- Implemented database usage monitoring software called Teleran iSight- Provided Essbase support for financial reporting and customer satisfaction measurement applications- Designed and developed new Essbase application used to measure results from a new customer survey- Conducted tool evaluation for geographic information systems (GIS) and presented recommendation to enterprise architects- Environment: Sun E10K, Solaris, Oracle 7, OS390, MVS, DB2, Windows 3.11/NT, Essbase, BrioQuery, Microsoft IIS, JavaScript, WebFOCUS, Teleran, Tactician, ArcView, Decision

Northbrook, Il, Us

- Developed and provided support for an Essbase application to measure overall customer satisfaction- Developed and maintained multi-dimensional planning models for Personal Lines Finance using Comshare System W and One-Up- Developed and conducted formal end user training on how to use One-Up for developing and maintaining the various financial plans- Designed and developed a PC-based reporting application using One-Up to replace a mainframe-based application with similar functionality- Designed and developed process to extract data from financial planning models and load the data into the Corporate Database- Developed test database to simulate the Corporate Database and provide an environment for user acceptance testing- Provided production support and developed enhancements for a mainframe-based online query system - Environment: MVS, Windows 3.1/3.11/NT, DOS, DB2, One-Up, System W, COBOL, PL/1, APL, Essbase, Visual Basic for Applications, Microsoft Office

Bachelor Of Science, Industrial Management

Certificate, Computer Career Program