CLIENTS & CASE STUDIES

International Longevity Center (ILC), New York, NY
ILC is a not-for-profit, non-partisan research and education organization whose mission is to help societies address longevity and population aging in positive and productive ways.

Project Goal:
Build a fully functional contact management system. This would include reports on development financial information, all contact history, contact address and phone information, contact mailing history as well as search engines, printing, mailings and custom tools for Contact management. The site also includes a highly specific group builder which allows the user to create temporary groups of contacts based on the contacts group, region, job, beat, and joint mailing status. This project also called for the development of a web based employee administration section to allow for the maintenece of employee rights and level. The site is fully integrated with SQL Server 2000.

Work Performed:
Analysis of project requirements, wrote functional specs
Designed database schema and created SQL Server database, utilized stored proceduress
Designed multiple search engines, utilized SQL Servers "Full Text Search"
Designed complex system which would allow for additions and modifications of all contact information
Designed system to allow Users to create customized mailings based on region, job title and media beat
Designed system to allow for joint mailings for contacts who where married
Designed system to track history of all solicitations and mailings for ILC
Designed System to allow the additions of Pledges and Contributions, and to view financial info
Designed system for the maintenance of Media information
Developed SQL Server jobs to automate back ups, and update Full Text index
Data Migration: Managed the process of moving the Clients data from Outlook to SQL Server 2000
Developed client side JavaScript for form field validations

Software/Technologies Used:
ASP, VBScript, COM, SQL Server, JavaScript, HTML, MS Visual Interdev

CLIENT CASE STUDY

Oxford Management Services, Melville, NY
OMS provides financial recovery services to business throughout the United States.

Project Goal:
The goal of the project is to provide a public front end web site, and a SSL enabled secure site to allow clients of OMS to login and view critical and personal financial account information. This data driven site pulls from both a SQL Server 2000 and Sybase backend.

Work Performed:

Developed and designed the OMS website. www.oxfmgt.com

Public Site
Analysis of project requirements
Designed database schema and created SQL Server database
Managed Design

Debtor Management System
Designed system to allow clients to login and view debtor information
Integrated clients Sybase system with SQL Server to manage Users data
Designed system to allow Users to download and print Reports

Content Management System
Designed web GUI to allow for content changes on OMS website
Designed News manager
Designed Employee Bio management system

Client Management System
Designed system to allow admin to login and add, delete and modify clients

Software/Technologies Used:
ASP, VBScript, SQL Server, Sybase, JavaScript, HTML, MS Visual Interdev

CLIENT CASE STUDY

RicambiSport.com, New York, NY
http://www.ricambisport.com

RicambiSport is a high-end auto parts e-commerce site. The site features a full catalog of over 3000 high-end auto parts.

Project Goal:
To build a fully functional and scalable e-commerce site. The site includes SSL enabled credit card transactions using Verisign's PayProFlow. The project also included the development of web based administration GUI. This admin GUI allows RicamiSport to track orders, as well as maintain and modify there ever growing catalog.

Work Performed:

Met with client to discuss project specifications
Decided on technologies to solve business requirements
Outlined the functional specifications for the client
Designed database schema and created SQL Server database, utilized stored procs
Developed MTS COM objects in Visual Basic for scalable auto part searches and customer registration
Interfaced with Verisign DLL to process credit cards.
Developed client side JavaScript for form field validations
Data migration from clients old system into SQL Server 2000

Software: ASP, COM, Visual Basic, MTS, VBScript, SQL Server, JavaScript, HTML, MS Visual Interdev

CLIENT CASE STUDY

Multex Investor
http://www.multexinvestor.com

Multex.com, New York, NY
Multex.com is a leading provider of online investment research and information services designed to meet the needs of institutional investors, investment banks, brokerage firms, corporations and individual investors.

Project Goal:
To rewrite and debug critical application code. This site consists of hundreds of pages and tens of thousands of lines of code. MereMedia was called in to assess the coding standards, and clean up the mess that had been made by multiple application developers.

Work Performed:

Responsible for enforcing coding standards and re-structuring of include files
Designed new login page with attention to maintaining various levels of state for users utilizing cookies
Designed new download page, allowing users to download financial documents based on membership level
Re-designed multiple functions, and consolidated functions into include files
Utilized custom COM objects for database access
Wrote customized JavaScript's for stress and regression testing of multexinvestor.com, utilizing Webload

Software/Technologies Used:
ASP, VBScript, JavaScript, HTML, MS Visual Interdev, Visual SourceSafe, WebLoad