Customized to you
Whether you need a simple spreadsheet organized or a pixel perfect report created for the Board, I can fit the scope to your needs, work with your reporting group, or be your reporting group.
Creating a publication quality 70 page annual report for executive leadership and the Board of Directors, summarizing operational and strategic metrics for a 450+ member physician group.
Merging 6 Gigs of billing data across three databases and two corporations to create a stand-alone specialized reporting dataset.
Cleaning and proofing 500+ crufty old html pages and migrating them to a new content management system.
Gathering and merging stock use data from mulitiple sources to create use statistics and presentation maps for Yosemite National Park.
Working with physicians to break apart Oncology and Neurosciences into sub-programs based on diagnosis codes, and generating rich operational reports.
A focus on usability.
Design is at the core of my practice. My focus is to create clean, highly usable reports, charts, maps, websites, spreadsheets, or whatever you need.
The point isn’t to make things pretty. The goal is to present your information in the clearest possible way.
Experience & Skills
Data mining, maintenance and report automation programming with Python (and a dash of VBA). The goal is to produce expressive, well-documented code that is easy to maintain, increases productivity, minimizes drudgery, and produces accurate results fast.
Extensive report generation and custom SQL experience with mysql, sqlite, Microsoft Access.
Data analysis and plotting with R, d3.js, Excel, and Illustrator.
Keeping everything in order with Git and Mercurial distributed version control.
Design of all sorts with the Adobe Suite (Indesign, Photoshop, Illustrator).
Map creation with ESRI ArcMap and Illustrator.