brett

(dot)

fanelli

(at) gmail (dot) com

814.941.7696

RR 4 Box 298

designer/developer

Altoona, PA 16601

Personal

Disciplined, results-driven professional who brings proven experience as well as willingness and eagerness to learn.  Masterfully adept problem solver with excellent logical and abstract reasoning skills.  Enjoys the analysis and troubleshooting required to design quality software, and appreciates the challenges inherent in its development.  Devoted team player with leadership experience, seeking to contribute to the growth and continued success of an organization that provides opportunity for advancement.

Technical

Languages

SQL, T-SQL, C#, C++, VB.NET, VB6, Java, PHP, Python, XML, HTML, CSS, Pascal, JPL

Software

Windows (3.11-Vista), Mac (OS8-OSX), Linux/UNIX, SQL Server (7, 2000, 2005), Informix, MySql, Visual Studio (5, 6, 2003, 2005), Prolifics Panther, Team Foundation Server, Visual SourceSafe, SVN, Rational Clearcase , Sharepoint, Microsoft Office Suite, Visio, Frontpage, Dreamweaver

Concepts

Database design and management, Requirements Analysis, Data Modeling, Relational and Hierarchical models, Normalization to 5NF or DKNF, OOA/OOD/OOP, Polymorphism, Abstraction, Decoupling, Currying, Generics, Implementation vs. Inheritance (vs. Composition)

Professional

Chief Architect

Folx Systems, Inc

August 2005 – January 2009

Creator of FolxCare – an enterprise application providing flexible, data-driven solutions for private duty home care agencies.  The feature-rich application is a distributed system of client and server software and is flexible and customizable from server to UI, with features such as:

·  Scheduling: generate patient visits using doctor orders (required services, recurrence pattern, etc) • assign weights to agency-defined preferences of patients and caregivers, and – when finding an open/able resource – rank the result based on traits of both (filtering any exclusions explicitly defined by either) • drag/drop visits, aided by visual cues of caregiver capability and availability • schedule or edit many visits at once

·  Billing: automatically create AR upon verification of a completed visit – based on charges defined for services provided, mileage driven, and supplies used – adjusting for payer/patient contractual allowances and per-visit overrides • print claims using formats defined per payer • employing double-entry record keeping – apply payments, write-offs, refunds, and deposits, and reassign open AR to other payers

·  Custom Forms: compose agency-specific questionnaires using numeric, date, free text, and multiple-choice (and multiple-answer) questions, and their possible answers • complete and store the answered forms

Through version 1.6.11, was the sole or chief contributor in ALL phases of design and development, including:

Information Gathering / Analysis: spoke directly with customers and other third party consultants to determine the requirements and possible uses of the application • researched industry standard practices and individual customer needs to create a data model, including specific validation, error-handling, and other logic

Database: using the model illustrated by requirements, created a structure that would ultimately establish business objects • devised a set of table types (representing general lookups, inheritance, extensions, joins) –determined methodically by their relationships, rules of normalization, and overall consistency • wrote stored procedures to handle CRUD functions, stale data checks, and transactional support • per HIPAA requirements, information regarding each action was logged to audit any change or inspection of data

Data Access/Management: developed a slender set of generic structures to manage messages from client to server ∞ client makes requests to web service and implements caching strategies for responses – limiting bottleneck from unnecessary or excess network round-trips ΰ web service runs on database server (or optionally on separate web server) and acts as proxy between client and server, providing opportunity for customization and communication with other applications ΰ [database] server dynamically creates and executes SQL commands – generically creating and returning business object(s) with result

User Interface: designed a hierarchy of composite, generic views and custom controls • screens were drawn dynamically at runtime – as dictated by required functionality, usability, and user-customized layout/skin • used delegates, curries, and abstract command structures for navigating and performing other user actions

Independent Contractor

Siemens Home Health
(currently Delta Health Technologies)

August 2003 – August 2005

Developer of NOVIUS Clinical Software (now Encore Clinicals) – a homecare clinical tool to assist the management and reporting of patient care.  Upgraded product from versions 3.15 to 4.5, including a migration from Informix to SQL Server, which entailed major UI and report changes, including:

User Interface: recoded over 600 screens to fix bugs and update embedded T-SQL • revised all screen layouts – ensuring proper alignment, usability, and uniformity with Siemens standards • created screens for new features like hospice and bereavement functionality, dynamic discipline management, and more

Reporting: overhauled all reports from UNIX to Windows reporting tools • modified report access to improve ease of use • rewrote and redrew all reports for consistency and clarity

Debugging / Troubleshooting: wrote, reviewed, and conducted test plans – documenting inconsistencies and errors • categorized issues and made fixes where applicable or appropriate

Education

Associate in Specialized Technology: Programming/Network Administration

South Hills School
of Business & Technology

March 2002 – September 2003
Overall GPA: 4.00

Bachelor of Arts: Integrative Arts
Member, Alpha Lambda Delta National Honor Society for Academic Excellence

Pennsylvania State University

August 1994 – August 1997
Overall GPA: 3.28

References Available Upon Request