Supporting analysis and reporting on La Clinica del Pueblo's electronic health record data management system (eClinicalWorks) with BridgeIT Solutions and other tools.

ColdFusion developer at the Office of Planning and Policy Support of the Office of the Assistant Secretary for Planning and Evaluation of the U.S. Department of Health & Human Services.

Worked at SRA International maintaining and enhancing a complex regulatory process management application for the Food and Drug Administration in ColdFusion 9 and Oracle 11g. Used Eclipse to develop the front end in CFML, HTML, and JavaScript. Used Oracle SQL Developer and the Toad Extension to Eclipse to write queries and make database modifications. Version control was in Subversion (SVN).Participated in government-mandated SDLC processes. Tracked features through JIRA, tracked requirements and defects through HP Quality Center, wrote Unit Test Result documents, requirements documents, and design documents.

Performed CRM database implementations and conversions using the cloud-based Salesforce.com platform with the Non Profit Starter Pack and Convio Common Ground.Implemented Salesforce.com for nonprofit organizations. Identified objects, fields, and workflows to be created, mapped data from the legacy system to the Salesforce platform, obtained business process descriptions and implemented them in Salesforce, converted data.Imported 40K+ contacts and organizations and 15K+ financial transactions into Salesforce and Convio Common Ground from a custom-built SQL Server database.Configured the Salesforce.com platform and the Non Profit Starter Pack to support the special needs of nonprofit operations.

Designed, built, and maintained ColdFusion applications starting in 2000 using successive versions of ColdFusion. Enhanced application functionality with JavaScript, HTML, CSS, SQL.Built custom online applications: CMS support and customization, CRM implementation, report generation, intranet development; built membership systems, client tracking systems, federated systems.Created data entry forms with JavaScript validation, provided user interfaces to maintain and query databases, supported public-facing websites and password-protected business applications, wrote interfaces to payment gateways, generated emails, enabled downloads in HTML, PDF, and CSV formats.Served as informal technical lead on small development teams. Working with a project manager, communicated with clients, coordinated team work, mentored developers.Used the Agile development methodology to increase client control over delivery of the final product.Consulted with small to medium-sized non-profit customers to build websites and develop customized online database applications.Designed, developed and implemented custom database applications in ColdFusion, MySQL, and MS SQL Server, including:· A management system for collecting outcome data from savings-based micro lending women’s groups in Africa.· A mortgage counseling and education tracking system for a national network of organizations helping disadvantaged persons become homeowners.· A volunteer and client management system for a national network of agencies coordinated by a major national organization.· Searchable databases of resources and a system for vetting publicly submitted resources prior to online publication.

Developed a database reporting infrastructure for Singleshop.com (on-line shopping engine): Designed, built and implemented a graduated commission calculation procedure for Singleshop order system in Oracle PL/SQL. Identified client requirements, designed table structure, developed algorithm, wrote stored procedures and prepared reports.Using Oracle Developer, MS Excel, and ODBC, delivered reports, graphs, and data extracts to external clients.

Customized and deployed off-the-shelf association management software (ABLAZE Enterprise Manager):Wrote SQL Server scripts and led writing of MS SQL Server scripts for data conversion.Used MS Transact-SQL to analyze data to be converted and verify conversion accuracy.Wrote MS SQL Server-stored procedures to customize the product.

Led the conversion from a custom-written association management system to several off-the-shelf packages: Built tools in System 1032 and MS Access to control and automate the conversion process.Developed user requirements; authored a Request for Proposal (RFP); met with all the major vendors of association, PAC, and government affairs management software; analyzed proposals; selected packages (iMIS and Keep In Touch); directed contractors on customization and integration; and successfully executed data conversions.

Designed, developed, and enhanced a 200-table, 1,200-program, 120-user association management system for a 100,000-member federated trade association, featuring: membership management for four interrelated organizations; a $2 million PAC; grass roots contact support; meeting, event, and rooming management; magazine circulation auditing and fulfillment; order processing and inventory control. Wrote the software in System 1032, a DEC OpenVMS-based RDBMS.

Performed requirements analysis, design, and implementation (Oracle, Paradox, and Dbase) of departmental business applications for private industry and for international organizations.

Designed and implemented an atmospheric dispersion model post-processor summarizing in table and graphic form the daily impact of over 100 emission source points across 1,600 receptors. Fortran on Vax. Tape input. Used NCAR graphics utilities to produce isopleth maps.Developed a PC-based interactive air quality model with graphics output in Borland Turbo Pascal.