Email p: 631-543-0480
Medical Physics Consulting Firm
Microsoft Office-Based Projects
Restaurant Holding Company – Using Visual Basic, SQL Server and Excel, created a system that collects daily sales and guest counts for each of 50 restaurants and creates multi-tabbed spreadsheet with detailed day-over-day, week-over-week, and year-over-year comparisons for sales and guests; front page summaries for all data; extra tab showing when and how often a particular restaurant achieved its highest sales; all elegantly formatted from scratch using VB; integration with Outlook to mail final product to various distribution lists. Other projects included tracking payroll changes for all the restaurants and providing automated feeds between non-homogeneous off-the-shelf systems.
Fulfillment Warehouse Client Processing – Using an Access database “template” system, created individualized Access systems, most using SQL Server as a back end processor, for each client of the fulfillment warehouse. The individualized systems handle unique requirements of each client that include:
Firm benefits from the individualized systems by minimizing clerical training on how to use each system, which contains only the features relevant to a particular client.
International Bank/Alternative Investment/Hedge Fund Group
International Insurance Broking Firm – Using Oracle, Access, Excel, and PowerPoint, created a process to present profitability analysis information, transforming data warehouse dumps into senior management presentations, reducing the time to create senior management presentations from weeks to minutes.
Also integrated automated features of PowerPoint and Excel to create a sophisticated Client Executive Value Pricing Tool for use by senior client executives in evaluating strategies for expanding services to clients. Tool presents a forms-based presentation-quality walk-through of the evaluation strategy.
International Insurance Standards Organization - Using Access, created a data base of industry and client data for performing complex rate, assessment, and adjustment calculations with an easy-to-use user interface.
Other Consulting Projects
International Insurance Broking Firm – Did substantial work on global data warehouse, providing automated procedures for data transformations on source data from European and South American countries. Provided both the programs (VB, ACCESS, Oracle, Essbase) and extensive procedural documentation on the entire quarterly process. Earlier projects included work on developing global solutions for world-wide office automation.
Advisor to Senior Management for IS Strategic Planning – Worked with a diverse client base of medium-sized firms that had outgrown limited IS facilities and required serious automation planning to keep their businesses ahead of highly competitive markets; clients required holistic approaches from desktop to servers to minis to tie together basic business processes with the information needs of management, user departments, suppliers, and clients.
Clients include two advertising media firms, a medium-sized village government on Long Island, several manufacturing firms, a brokerage clearance firm, and a real estate development corporation.
Senior Advisor to a Bond Market Trade Association - Played a primary role in efforts to deliver worldwide, real-time price dissemination (ticker) for the Government Securities Market (GOVPX). From request-for-proposal through development to final test, served as the association’s technical advisor to the GOVPX owners, coordinating between the facility manager, the broker sources and the information vendors who delivered the product to market. Other projects included implementation of several online PSA information products for Mortgage-Backed Securities and strategic planning for internal technology growth.
Financial Services Firm - Conceived and implemented a complete corporate office automation system integrating document preparation, customer databases, research analysis, presentation graphics, meeting and conference planning, mailings, and desktop publishing.
Regional Telephone Operating Company - Planned and developed corporate information systems extracting large volumes of mainframe billing data into PC databases for market and product analysis. Extensive and flexible year-over-year reports and graphs made available in seconds by account, region, jurisdiction, product groups, organizational divisions, and other criteria, using precursors to today’s OLAP technologies.
Earlier mainframe-based software development efforts have covered the gamut from decision support and large-scale budget analysis systems, to mission planning and tracking systems for satellite vehicles, to bill of materials/inventory processing, to real-time transaction-processing systems for the brokerage/banking community.
|© 2008-2010 Information Center Sciences, Inc. • All Rights Reserved|