|
Matt Rager is a member of the management team of West Monroe Partners. He has spent the past seven years implementing, architecting, and managing software engineering and data warehousing projects for West Monroe Partners and Andersen's Business Consulting practice. Matt is considered an expert in designing data models for dynamic, data-driven desktop and web applications and data warehouses. He has a reputation for delivering appropriate, high-quality solutions on time and under budget. Matt enjoys the challenge of applying technology to solve business problems and seeks to thoroughly understand the problem and the client's needs before proposing a solution.
Highlights
Matt has been involved with a wide range of solutions, including these:
He led design and implementation of an ASP .NET application that serves as a corporate portal for West Monroe Partners. The application provides tools for project management, time and expense reporting, project status reporting, automation and workflow for internal processes, and real time management of the firm's consulting business, including generated revenues, project inventory, invoicing, and receivables. The application uses web services to share information with and retrieve information from other internal systems. The application runs on a SQL Server 2000 database, and all data retrieval and manipulation is done through the use of stored procedures.
He designed and implemented several enhancements to a real estate sales management application. The application is an ASP .NET application written in C# with a SQL Server 2000 database. Sales people enter customer and contract information throughout the sales process. Self-service, real-time reports are delivered via the web to management and investors. The reports are generated in Crystal Reports, C#, and downloadable Microsoft Word and Excel files. Matt worked with the client to add new functionality and new reports as needs arose.
He participated in the design and implementation of a client/server application that allows a user to collect data in XML format while disconnected from the network and then connect to the Internet to exchange data with the server. The client communicates via HTTP with the server through a distributed architecture that uses IIS/Active Server Pages as an interface, COM for all business logic, and Oracle 8i for data storage. Tasks included design of overall architecture, proofing of included technologies, and design of several components including Oracle data model and file storage, general error handling, interface layout, and document generation.
He designed and led the implementation of a Web-based tool that allowed Arthur Andersen partners to update the attributes of their jobs. Tasks included design of the application's data model, interface, business rules, and daily data import and extraction routines. Technologies included SQL Server 7/Transact SQL, IIS/Active Server Pages, Lotus Notes (for email notifications), and MS Excel (for generating downloadable reports).
He participated in the design and implementation of a customer analytics data warehouse for an online merchant. Tasks included defining dimensions and metrics, designing the warehouse data model, applying Andersen's generic star schema load tool set, and transforming and loading historical data into the star schema. The warehouse was built on an Oracle 8i database.
He investigated the capabilities of leading EAI tools and lead the design and implementation of a prototype EAI application using IBM's MQ Series. The prototype included a hub server that facilitated the exchange of XML messages among three representative applications. The extraction and integration of messages at the application servers as well as the collection and distribution of messages at the hub server was written in Java. The prototype results were used to propose an enterprise-wide EAI solution that included a data warehouse that subscribed to all messages sent to the hub.
He designed and led the implementation of a decision support system for Andersen business consulting that reports fees, direct costs, margin, and other data across several dimensions including client, job, time, location, and personnel for 69 U.S. offices and 6 U.S. regions. Tasks included extraction from SQL Server 6.5 and 7.0 databases (Transact SQL), transformations on a SQL Server 7.0 database, loading of an Oracle 8.0 star schema using generic, dynamic PL/SQL, delivery of MicroStrategy reports via web interface (Active Server Pages), and development of a full suite of warehouse maintenance tools using Active Server Pages.
He participated in the implementation of a web application for the U.S. government that captures data points used to calculate key performance indicators used to evaluate customer service contracts.
He designed an enterprise application for a multi-billion dollar energy company that includes activity based costing, shareholder value analysis, and transfer pricing. Matt then led a team of contract developers in the implementation and testing of the application. Matt was responsible for estimating development time and costs, managing project scope, scheduling, and helped make resource decisions (in concert with the client).
He designed and led a team in the implementation of a data warehouse/decision support system for an international company. The warehouse pulls sales, customer, employee, and product data from more than 20 regional offices and allows multi-dimensional analysis at all levels of the company. Matt's responsibilities included tracking and reporting project status, managing project scope, database and extraction design, and managing the development team.
He led the development of a prototype business simulation interface used as a generic front end to systemic business models built using Powersim software. The simulator is a generic Visual Basic program which is customized using MS Access tables to control a specific Powersim model. Matt has also developed an MS Access application to make customization easy for the system modeler. Matt is working to develop this prototype into the firm wide standard interface for systemic models. He has also begun to apply this interface to several modeling projects throughout the firm
Matt worked on an internal custom software package that provides simple front-end access to mainframe employee data used in promotions, raises, and evaluations. Mainframe data is loaded into a Microsoft SQL Server database and then manipulated using Microsoft Access on a Windows platform.
He also worked on a managed healthcare project that proposed to combine four Chicago area managed healthcare providers into a single, consolidated entity. Matt helped design and maintain a dynamic financial model for the newly formed company using Microsoft Excel. He then researched and altered the parameters of the model and analyzed the resulting data to develop possible scenarios and their outcomes. Finally, Matt helped in the design and documentation of the business plan for the startup company. |
