New York City Department of Health and Mental Hygiene (DOHMH)
The Fund for Public Health in New York (FPHNY)
2007-Present
|
- Project is part of a larger effort to prevent colon cancer by urging patients to get life-saving colonoscopy screening.
- Developed a distributed database application currently being installed at 16 area hospitals.
- Data collected by DOHMH is used to evaluate the effectiveness of "Patient Navigator" programs in partnership with FPHNY and the New York City Health and Hospitals Corporation (HHC).
- Use of a unified database application ensures consistency and integrity in data collection and reporting, thereby allowing reliable and efficient analysis.
- Compliance with HIPAA regulations regarding patient privacy and de-identified data.
- Conversion of pre-existing data to new application format where applicable.
- Access application designed with scalability in mind, including future expansion to SQL Server back end.
Technology: Microsoft Access, Visual Basic 2005, .NET 2.0
|
Mount Sinai Hospital
2004-Present
|
- Developed a clinical database to facilitate the statistical analysis of kidney patient outcomes. The software provides a repository for patient demographics, visits, diagnoses, labs, clinical parameters, and other valuable data. The dataset is readily exportable to SPSS, SAS, or any statistical analysis packages. A web interface provides secure, multi-user, network accessible, cross-platform access.
- Developed an operational database used to administrate the Visiting Doctors Program. Software automates visit scheduling; tracks patient demographics, enrollment status, diagnoses, and medications; generates daily field paperwork and operational reports; interfaces data with a third-party paperless office system; and provides contact management features.
Technology: SQL Server, Microsoft Access, Citrix, STRUTS, J2EE, MySQL
|
EnergyWatch, Inc.
2003-Present
|
- Developed custom software for monitoring and analysis of commercial, industrial, and residential utility costs.
- Created an automated system for calculating Mandatory Hourly Pricing (MHP) electrical bills based on actual customer interval data and published Day-Ahead Market LBMP prices.
- Module for duplicating Con Edison bill calculations to enable forecasting, analysis, and other consulting services.
- Ongoing data services, support, and program enhancements.
Technology: SQL Server, Microsoft Access, .NET 2.0, C#, Visual Basic, Adobe InDesign SDK
|
Guggenheim Museum
1996-2002
|
- Extensive consulting provided for a wide variety of projects.
- Developed a series of Microsoft Access databases for tracking artwork through all
stages of an exhibition. These programs store information on artwork
for labels and catalogs, lender and artist contacts, shipping
arrangements, condition and appraisal data, and other vital
information. Multiple curators and registrars share the information and
use reports to organize the exhibitions.
- Assisted the Budgeting and Planning Department
with making its yearly projections by creating a time-saving
forecasting database. This database imported information from existing
accounting software and from Excel Spreadsheets which they manipulated
into numerous model budgets. Sophisticated financial reports were
created to mimic their existing reports, while avoiding double-entry in
the maintenance of account code ranges. Assisted employees with a great
deal of troubleshooting and data conversion in a deadline-oriented
environment.
- Created custom Crystal Reports which tapped into
the museum's inventory management software (SQL Server
based). This involved deciphering the undocumented data scheme of the
software, which utilized some 250 tables.
Technology: SQL Server, Microsoft Access, Crystal Reports, third-party accounting and gallery management systems
|
| Cablevision
1997-2000
|
- Provided external assistance to large corporate IT department supporting custom software apps
- Helped
to improve existing custom accounting software in Microsoft Access
which provided intradepartmental reconciliation of transactions for
several of their divisions.
Technology: Microsoft Access
|
Duamex, LLC
1995, 1999
|
- Streamlined
this international cut flower broker's operation by creating a tool for
creating daily pricelists, while importing and manipulating raw price
data from their vendors in Holland. A task that used to take several
people several hours was now finished in 20 minutes by two people. This
allowed them to get the jump on their competition, and achieve their
first million sales month.
Technology: Microsoft Access
|
