Dean R. Email and Phone Number

BI Solution Architect specializing in performing BI Readiness Assessments, Discovery Facilitation, BI Architecture reviews, Data Model reviews, Leadership of large, complex BI engagements , and BI Best Practices Mentoring. Also responsible for internal Staff Development, Pre-Sales and Marketing support.

Lead the Database Development team of the Data Management group encompassing the end to end development of the GAFRI BI Program. Supervise, guide, and direct quarterly Business Intelligence releases. Collaborate with the Data Governance Leadership Team to prioritize demand. Strategically Interface on multiple levels within the broader business and IT Leadership community. Serve as Technical BI Program Liaison to Enterprise Data Governance Committee.

Leader of the BI Development Team, which included Strategic, Online Analytical Reporting capabilities, along with Tactical Reporting, Managed end user report demand. Led design and architecture sessions for structure and content of Multi-Dimensional models. provided oversight of integration points between Dimensional Kalido model and Multi-dimensional SqlServer Analaysis Services (SSAS) cubes and SqlServer Reporting Services (SSRS) Reporting.

Leader of the development team for Source ETL, Data Cleansing, Master Data Management, and Kalido Dimensional Warehouse. Coordinated and controlled releases of incremental value for Enterprise Business Intelligence Program. Led Design process for complete backend architecture in support of DWH 2.0 design.

Led Proof of Value engagements with Clients to demonstrate Kalido’s Dynamic Information Warehouse and Master Data Management products against actual business cases and data. Conducted solution strategy sessions with prospective Clients to define project requirements, including technical architecture, business models, and reporting requirements. Trained and coached System Integration Partners and internal client resources.

Lead architect for new enterprise-wide data warehouse on Teradata V2R5. Develop logical and physical data models in ERStudio. Document and create ETL processes using DataStage, SQL and Unix Shell scripts. Key MicroStrategy Support and development resource. Project Manager for initial reporting phase of new data warehouse.Designed and Implemented MicroStrategy based corporate and field reporting structure for merchandise planning and sales analysis against an existing AS/400 DB2 data warehouse. Trained and guided business personnel through the transition from Cognos Impromptu to MicroStrategy Web.

Internal Business Development 9-01 to 4-02Developed enhanced multi-dimensional OLAP functionality for proprietary web-based Business Intelligence Portal. Responded to client RFPs. Participated in business vision and strategy sessions. ASP, JavaScript, SQL2000, Databeacon. Engagement: Advanstar Communications 1-01 to 9-01Designed customer analysis data mart for Fashion and Apparel Trade Show business unit. Managed project lifecycle. Conducted Business Analysis. Architected logical and physical data mart models. Conducted end-user training. Compiled extensive technical and business documentation. SQLServer, MicroStrategy, DataStage, DataFlux.Engagement: American Greetings Corporation 8-00 to 3-01Designed, Architected, and Implemented Account Profitability Data Mart. AIX UNIX, DB2, Cognos PowerPlay/Impromptu. Engagement: Cole National Corporation 12-99 to 12-00Designed, Architected, and Implemented Vision Claims Analysis Data Mart. DataStage, Oracle, SQL, HP-UX

Engagement: Owens Corning 8-99 to 12-99Designed and Implemented Pricing Analysis Data Mart for Vinyl Siding Division saving company $10M in final quarter. Oracle, SAP, Cognos PowerPlay Web, Cognos Accelerator, Cognos ImpromptuEngagement: Norandex Reynolds 4-99Assessed Data Warehouse project ensuring satisfaction of business needs. Mapped physical design against logical design. Provided recommendations for improvement.Engagement: MTD Products 4-98 to 12-99Designed, Architected, and Implemented Sales Analysis Data Warehouse for three divisions including Open Orders, Shipments, Cancellations, Inventory, Production Forecast, and Warranty Claims. Oracle, SQL, NT, AS/400, Symbiator, Cognos.

Architected and Enhanced Decision Support applications and Data Warehouse.Designed and modified Executive Information System. Provided technical support for Data Warehouse end user community. HP-UX, Oracle, C, SQL, Cognos PowerPlay/ Impromptu

Served as technical resource for problem solving and mentor to members of retail applications development staff. Provided second level support for store systems and applications. Designed, developed, and implemented software and hardware based business reporting solutions to identify customer purchase trends and departmental penetration. Managed project development life cycles using Microsoft Project. AIX UNIX, Oracle, SQL, Cognos PowerPlay/Impromptu.

Programmer/Analyst. Database Publishing Group. Developed custom publishing solutions for client data sources. Clients included NACS (National Association of College Stores), Roadway, Federated Investors.