Selected Solutions



Technology Management Workflow
Helped define and implement a project management workflow solution for a technology organization within a fortune 100 financial institution. Enabled a data warehouse team to achieve better results by employing a more structured, collaborative and transparent work process. Worked with management to define project structures, assignments types, roles, milestones, aggregations and other project criteria. Developed an on-line workflow application in which tasks and related information are passed from one team member to another for action. The user-defined workflow captures tasks, sets schedules, and ties resources to each task for project teams. Team members track their progress and communicate with members of their team via status updates, time logs, notes, emails, and submitted work. Project Managers are able to structure and monitor individual projects so that each one can be tracked separately or aggregated with other projects in a meaningful way. Managers get real-time status updates and can drill down with granularity into the current state of individual projects.
Data Center Finance & Operations Dashboard
Designed and implemented a web portal that manages financial and operational reporting for a national operator of data center facilities. Worked with management to establish key financial and operational performance metrics. Collaborated with key personnel to develop the means for collecting the relevant historical and ongoing business data. Developed an on-line system that captures and measures business results against the company’s business plan and other benchmarks. Tracks and measures financial performance, capacity planning, energy utilization, energy efficiency, customer deployments and call center productivity. Created data upload utilities that capture information from general ledger, other third party systems, and spreadsheets. Online data entry forms collect business results from facility operators and help desk personnel. Results are available on-demand via advanced online interactive reports. The system has achieved vast improvements in efficiency over a previous Excel-based, manual process.
Real Estate Forecasting and Asset Management
Developed a custom forecasting and asset management system for a commercial real estate investment organization to help automate the processes of tracking and reporting investment performance. An on-line Portfolio Management application records original investment targets, capital budgets, ownership structure, partnership and debt terms, business units, and other information. A related forecasting application tracks and measures financial performance against original investment targets and annual business plans throughout the life of each investment. Performance is measured for each property and at various levels of aggregation including projects, intermediate business entities, funds, and investors. The application provides an Excel Add-in menu interface that links complex forecast spreadsheet models to a SQL Server database and MRI accounting system. The Excel Add-in provide utilities for uploading and downloading data between the systems, and provides a wide variety of reports and pivot tables that are downloaded for analysis and reporting.
Customer Realignment Workflow
Developed a custom workflow application for a fortune 100 financial institution to manage a bank-wide customer realignment program. Eligible customers were identified for realignment between the Wealth Management and Retail bank segments based on business rules that take into account customer tenure, relationship profile, account balances, and other criteria. Customer and account information was organized by households and customer relationships and was delivered to targeted bankers and managers via the online tool. Bankers made alignment decisions and entered notes to document their decisions. Decisions were subsequently reviewed and approved online in a multi-step process involving up to four bankers per customer. Approved customers were ultimately aligned with new bankers in the appropriate bank channel. The application tracked each step of the process and facilitated the generation of account conversion instructions to the underlying systems of record. Over 225,000 customers were processed by over 2,500 bankers. After seven years of use, the functionality of the workflow tool was ultimately built into the bank’s primary customer relationship management system.
US Department of Labor Regulation D
Worked with the cross-product team of a Fortune 500 financial services corporation to meet the requirements of Regulation D, which is intended to provide greater transparency to defined-contribution retirement plan participants by giving them annual access to Department of Labor-defined plan documents for their investments. In addition to analyzing, understanding, and implementing the statutory requirements of the new regulation, developed a Microsoft Office VBA application that provides a dashboard user interface for the compliance department. The application manages the maintenance of lists for some 2,000 clients and all of the funds in which those clients invest. The program automates the process of assembling and sending tailored emails with appropriate plan documents to each client. The automated process enabled a single individual to create and sent all the required mailings and attachments within a few hours.
Bank Fee Management
Created a fee income reporting process for a fortune 100 financial institution to manage discretionary fee waivers from retail deposit accounts. Designed and implemented business logic to identify and differentiate banker initiated discretionary waivers from system-generated program waivers. A discretionary fee waiver percentage is calculated to help manage banker behavior toward acceptable levels of fee collections. Designed and implemented data load processes from the bank’s deposit and general ledger systems to a Teradata database. Developed methodologies that validate the results against the general ledger to ensure data integrity. The data from this process is used in bank-wide reporting systems that enable managers the ability to drill-down to individual banker and transaction details. The process has been in place for over ten years and has helped the bank reduce discretionary fee waivers by 3% on a $2.8 billion annual revenue stream.