Ken Fine

adkmw1@r.postjobfree.com Brookline, MA 024**-***-*** 7702

www.linkedin.com/in/ken-fine-3611aa9

● Automating data-entry and reporting activities in MS Access, VBA, SQL and Excel

● Custom menu-driven GUI tools for healthcare, finance, education and government

● 'Industry-agnostic' MS Access/VBA front-end tools that link to ORACLE/SQL Server

● Building creative software for any office environment ("ideas in motion")

RELEVANT EXPERIENCE

MA Department of Public Health / Office of Emergency Medical Services

Project manager for data analysis

Boston, MA 2013 - Aug 2017

oBuilt opioid statistics Access database (automated review of over one million ambulance runs)

oFulfilled Public Information Requests relating to trauma by city, county, type of service requested

oAnalyzed municipal motor vehicle injuries, bike/pedestrian crashes, trauma analysis, AMI and cardiac arrests

oBuilt the Ambulance Regulatory database in Access and served as the go-to Windows developer for

paramedics and EMTs

AMERICAN INSURANCE GROUP / Lexington Insurance

Project manager for insurance reporting systems

Boston, MA 2010 - 2012

oCreated multi-user database systems for managing claims made in a variety of industries (marine, motor vehicle performance, building structural deficits)

oCreated Access/VBA log of work requests, automating by division and service type (new, assigned and completed). Extensive automated reporting makes this compelling software.

oBuilt database to analyze PPS by branch, exclusions, endorsements and renewals.

oBuilt reimbursement management software in Access, reporting by division

BRIGHAM and WOMEN'S HOSPITAL 2005 - 2010

Project manager for Nursing and Orthopedics Departments

Boston, MA

oCreated database of Nursing Department vacation requests by cost center, manager and employee

oBuilt nurse demographics profiling Excel software, by years of service, specialty, hours per week, job code

oNursing concerns database software, to track issues raised by nurses (safety and staffing).

oBuilt Open requests and Accounts Receivable software for Physicians Group

oCreated Accounts Receivable software for Orthopedic Surgery department

MASSACHUSETTS GENERAL HOSPITAL / Cancer Center Administration

Thoracic oncology software developer

Boston, MA 2009

● Tumor Genetics software: electronic medical records of thoracic carcinoma patients

Demographics

Histology (tumor type and variance)

Clinical Presentation

Treatments (localized and systemic)

Tumor Bank Genetics (15 genes, with genotypes)

NEW ENGLAND EYE CENTER / TUFTS UNIVERSITY SCHOOL OF MEDICINE

oBoston, MA April 2008 - 2009

oClinical Productivity Software: statistical reporting on sessions and % of new patients

oSatellite-office Payment tracking software: Payments made at a dozen suburban clinics

oPhysician blocked/unblocked scheduling software: by the calendar work hour

SIMMONS COLLEGE

Boston, MA Nov 2008 - 2009

oBuilt three-year budget forecasting software: Excel modeling of BS/IS and Statement of Changes

oAnalyzed revenues generated by faculty members in my automated Excel workbook, measured against scenarios of benefits offered and other projected expenses (assuming a growth factor between years)

STATE STREET BANK Global Markets Technology

Boston, MA and Toronto Aug 2007 - 2008

oIntraday-trading software: Combining ORACLE data with Access/ Excel/VBA; links to Toronto Stock Exchange Automated date and time Access menu-driven import from ORACLE to Access tables.

Software imports security name, trade date, settlement date, quantity, price, commission, buy/sell flag and counterparty for all trades between the user-defined date/time periods and then calculates a coded trailer for each trade, denoting trade type (Jitney trade, short sale, average-price). All this trade detail matches exactly with FIDESSA (the on-line repository of world-wide institutional trades

oTrade Order/Portfolio Order Commission Calculator: BLOOMBERG trades for London, Boston and Toronto are imported into my Access software, and then VBA code calculates the commission for each trade based on the buys and sells.

EVANS MEDICAL FOUNDATION (BOSTON UNIVERSITY SCHOOL OF MEDICINE)

Boston, MA Jan 2003 - 2010

Clinical Productivity / Bell Curve software: Performance evaluation for physicians and departments

Computed CPT code variances as documented by physicians for both visits and procedures

Automated graphing of visit % by provider against either year-to-date or national distribution

The user selects a physician or medical department, then can multi-select up to 22 visit types. The software then graphs the physician/department activity by % of each activity's CPT code within a multiple-acuity visit type, generating a 'Bell Curve'. Hospital administrators use this.

Evaluation & Management Annual Physician Audit software: Prospective reviews by department are summarized and graphed in this Access software. For each audited patient visit, any of five acuity levels are assigned for History of Present Illness, Review of Service, exam and diagnosis. Assigned and amended CPT codes are monitored and reported on by physician and department to insure that over- and under-coding of CPT values is minimized year to year. Compliance deviation reports are shared with hospital administration. Software then creates summary reports for latest four years.

VOLUNTEER EXPERIENCE

Brazilian Immigrant Center 2010 - Present

Workers' Rights software in Access/VBA

South End Community Health Center 2008 - Present

Diabetic Clinic software in Access/VBA

EDUCATION

MBA - Tulane University Finance/Accounting

BA - Syracuse University Marketing/Psychology

Contact this candidate